Stream: Covid-19 Response
Topic: Sample Hospitals for May Connectathon
Michael Donnelly (Apr 23 2020 at 16:41):
When we're exchanging metrics at the Connectathon, we'll need a shared set of hospitals to use. I've taken a stab at making two lists; can the folks who do geomapping take a look and see if these have what you need to be good examples?
Michael Donnelly (Apr 23 2020 at 16:42):
Hospitals_Cook_County.csv
Hospitals_Rhode_Island.csv
Michael Donnelly (Apr 23 2020 at 16:45):
@Abigail Watson @Thomas Emge
Michael Donnelly (Apr 23 2020 at 16:46):
@Keith Boone you mentioned someone else who should look at this, but I didn't write down who it was.
Keith Boone (Apr 23 2020 at 16:47):
ESRI and/or Juvare
Abbie Watson (Apr 23 2020 at 16:50):
Yeah, this looks fine. We've got the entire HIFLID file loaded up in a searchable index. I'll verify the IDs match and/or map them in as secondary IDs. Is the CCN the Medicare ID, the HIFLID, or something else?
Michael Donnelly (Apr 23 2020 at 17:03):
CCN is the CMS Certification Number, which I think is the same as the Medicare ID?
Thomas Emge (Apr 23 2020 at 19:44):
Yep, data looks good. Sample Hospital Locations
Michael Donnelly (Apr 24 2020 at 16:12):
@Gino Canessa take a look at these to see if the format works for you. I'll have ones with less realistic names today.
Gino Canessa (Apr 24 2020 at 16:19):
Yep, those are fine. Having all the extra unnamed fields at the end is odd, but I can discard them.
Michael Donnelly (Apr 24 2020 at 17:17):
Here are some new ones. The have real addresses but fake names. If people think we need fake addresses too, I'll want to work with a geomapping person to make sure we'll have something that'll actually meet their needs.
Hospitals_Chef_County.csv Hospitals_State_of_New_Cyprus.csv
Michael Donnelly (Apr 24 2020 at 17:26):
I made up names rather than using "Hospital 1" and "Hospital 2" because it makes for a better experience.
Gino Canessa (Apr 27 2020 at 18:08):
Does this look right: Organizations and matching Locations?
Generated bundles are on GitHub.
Any changes / requests, please let me know.
Michele Mottini (Apr 27 2020 at 18:48):
(deleted)
Josh Mandel (Apr 29 2020 at 15:21):
Thanks -- these look great! I think it'd be good to also capture the Location.managingOrganization to point back to the org, to capture the underlying structure.
Gino Canessa (Apr 29 2020 at 15:24):
Good point, I'll add that as soon as I have build working again (currently updating measures)
Keith Boone (Apr 29 2020 at 15:29):
I did recall we said something about using the right data but changing names to Hospital 1, Hospital 2, et cetera.
At least for testing, so there's not confusion.
I think there might also be some value in tagging (as in Resource.meta.tag) this all as Test data.
Gino Canessa (Apr 29 2020 at 15:42):
For the names, @Michael Donnelly mentioned on the 24th (this thread) that they are made up names - just not blatantly so. I'm fine either way, so long as it's generally agreeable and we don't thrash too much.
Right now, everything loaded into a server from our pipeline uses the tag: https://github.com/microsoft-healthcare-madison/learning-spike-erp|sample-data. I can add more, and/or add tags to the JSON files. Preferences?
Michael Donnelly (Apr 29 2020 at 16:25):
I prefer to use realistic-but-not-real names vs. "Hospital 1" and can go into detail about why if anyone cares.
Gino Canessa (Apr 29 2020 at 16:37):
Added managing organization, single query for orgs and locs on HAPI
Michael Donnelly (Apr 29 2020 at 17:00):
Would it be useful to have some managing orgs that are not self-references? Hospitals_Chef_County-v02.csv
Abbie Watson (May 07 2020 at 13:28):
Oh my lord, "Chef County". Got a good belly laugh out of that. Hat tip. Well done.
Mark Deaton (May 07 2020 at 19:05):
@Gino Canessa Looking at Organizations and matching Locations...we'll probably want to import these in such a way that we have most of each Organization's attributes from "Organizations" but use the canonical lat/lon location from "Locations". (We could infer locations from the address, but why do that if there's precise geographic location available?)
So what's the link between the Organizations and Locations? Is it the entry>resource>meta>source field?
Thanks in advance!
Gino Canessa (May 07 2020 at 19:30):
Hi Mark. In the current versions the link is via Location.managingOrganization.
But, I also went ahead and added the geolocation extension to the address in Organization. Example: X140103: Organization, Location.
Does that work, or do you need something else?
Mark Deaton (May 07 2020 at 19:55):
That works just fine, Gino. Thanks!
Last updated: Apr 12 2022 at 19:14 UTC
