Project: Develop an Android mobile application to show patient friendly costs of care

Projects Toolkit
, , ,
9

Please check if my approach is correct

  1. I will get location coordinates of user , which I will pass in Overpass API to get Nearby hospitals, Then with the name of Nearby Hospitals , I will use Github API to download CDM which I have already saved to a repo .The CDM will be downloaded in app & will be stored in SQL Database in app.

Example

https://raw.githubusercontent.com/Darshpreet2000/Hospital-CDM/master/atlanticare-regional-medical-center.csv

I have to only insert name of hospital https://raw.githubusercontent.com/Darshpreet2000/Hospital-CDM/master/ + “NAME FETCHED FROM OVERPASS API” +".csv"

But For this approach hospital name must be the same as that saved in github

I have done experimenting this approach & it was working correctly in app. But for this, I need to take care for name to be same from overpass API response & that saved on github.

How do you suggest ? @sunbiz @r0bby @muarachmann @judywawira

10

I have planned to scrap hospitals CDM statewise, I will start from California & will scrap around 40 hospitals of each state , By the end of this program I will have scraped data of around 2000 Hospitals as there are 50 States in US.

https://health.usnews.com/best-hospitals/area/ca

Using this website I can get top hospitals of each state.

I want to know how you suggest

@sunbiz @r0bby @muarachmann @judywawira

1 Like
11

What are we naming this thing? Making repos now.

12

@r0bby Please make two repo one for this app & another for webscrapping scripts & data

You can name it anything like Hospital CDM Crawler , or whatever other mentors suggest

13

Why do repos? Can’t be done with one?

14

Yes, it can be done with one, but there will be large data after scrapping CDM & also I think App Code should be separated Web Crawler code.

But if you want to create only one it’s okay, it will work.

15

@r0bby we will be needing two please

16

Yes, we will need to run CI Pipeline for Scrapping Data daily.

Two repo are necessary

17

Alrighty. What is the name of this app?

18

Curative Care

LH Care

PatientFriendly

Patient Care

MedCompare

MedProcedures

Hospital Tracker

I thought of these names, these are according to my priority.

How do you suggest ? @r0bby @sunbiz @muarachmann @judywawira

1 Like
19

@Darshpreet2000, please can you give a detail on what you will be doing this week and when you will be free for the call. Also we will decide on the repos name, for now just keep working on your github repos. We shall mirror it. Also provide the links here so I track your progress.

I like the idea of the CI for running say daily so we get updated data.

2 Likes
20

This is my Gitlab Repo, I have scrapped data of 4 hospitals for trial, I have created a CI pipeline which automatically scrap data on push to repository.

But currently everything is running under one job, I want to seperate into multiple jobs without installing package again, I need to look for this.

Also , I will create a process file which parses all CDM to correct column names ,this will also run from pipeline.

You can contact me anytime you want but please tell me time beforehand

@muarachmann @r0bby @sunbiz @judywawira

21

and your android app? We’re going to fork, then remove the fork relationship, so you’ll need to fork again. You’ll make Merge Requests against our repo. Does this sound good to ya? You can commit a gitlab-ci config file and set things up and make merge requests against that file.

22

I made a new app with changed UI.

For now I have named it Curative Care. We can change name later

This app can run on Android, IOS & Web also.

@r0bby @sunbiz @muarachmann @judywawira

23

Android App:

Scraper:
24

@Darshpreet2000 The repo was renamed – so just fork both

History is intact.

1 Like
25

https://health.data.ny.gov/Health/Hospital-Inpatient-Cost-Transparency-Beginning-200/7dtz-qxmr

https://www.in.gov/isdh/28202.htm

I found these links ,

First contains chargemaster of all Hospitals of New York

second one contains CDM of all hospitals of California

Third contains Discharge data of 2018 of hospitals of Indiana State

So, these don’t contain latest CDM

Should I use them or manually save link for each hospital?

@muarachmann @sunbiz @r0bby @judywawira

2 Likes
26

Link to My Blog, week 3 Community Bonding

1 Like
27

The last might be the latest in many cases. So, if something was published in 2018, it might still be correct for now, as prices likely didn’t change in 2019 and the 2020 updates have not happened. Your repo should be able to keep history of all those, so that you can later do some pricing analytics

2 Likes
28

I found these

Inpatient Data of 3000 Hospitals

https://data.cms.gov/Medicare-Inpatient/Inpatient-Prospective-Payment-System-IPPS-Provider/tcsp-6e99

Outpatient Data of Hospitals

https://data.cms.gov/Medicare-Outpatient/Provider-Outpatient-Hospital-Charge-Data-by-APC-CY/fmbt-qrrw

Should I use this ? but these don’t contain all procedures. It has only 150 procedures per hospital

I searched for Tooth Extraction & XRay but there were no results

Or Should I manually scrap each hospital?

@sunbiz @r0bby @muarachmann @judywawira

1 Like