hospital_data
Data source: Big Local News · About: big-local-datasette
10 rows where "filed_date" is on date 2019-11-25 and hospital_ownership = "Voluntary non-profit - Other"
This data as json, copyable, CSV (advanced)
Suggested facets: hospital_type, geocode_flag, geocode_accuracy, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, icu_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, all_beds, filed_date (date), fy_end_date (date)
Link | rowid ▼ | hospital_name | address | city | state | zip_code | county_name | phone_number | hospital_type | hospital_ownership | emergency_services | lat | lng | geocode_flag | geocode_accuracy | countyfips | statefips | statecountyfips | cbsacode | csatitle | centraloutlyingcounty | countyequivalent | hosp_lookup_url | PRVDR_NUM | RPT_REC_NUM | filed_date | fy_end_date | acute_beds | icu_beds | coronary_beds | burn_beds | surg_icu_beds | oth_spec_beds | subtotal_acute_beds | subprovider_ipf_beds | subprovider_irf_beds | subprovider_oth_beds | skilled_nursing_beds | nursing_fac_beds | oth_longterm_beds | hospice_beds | all_beds |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
471 | 471 | ST MARYS HOSPITAL MEDICAL CTR | 1726 SHAWANO AVE | GREEN BAY | WI | 54303 | BROWN | (920) 498-4200 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 44.5321840 | -88.0665610 | 0 | 9 | 55 | 55009 | 24580 | Green Bay-Shawano, WI | Central | Brown County | https://data.medicare.gov/resource/xubh-q36u/row-kt4k-sbbe~w8n6 | 520097 | 660733 | 2019-11-25 | 2019-06-30 | 75 | 8 | 83 | 83 | ||||||||||||
506 | 506 | MAINEGENERAL MEDICAL CENTER | 35 MEDICAL CENTER PARKWAY | AUGUSTA | ME | 4330 | KENNEBEC | (207) 626-1000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 44.3608530 | -69.7857180 | 0 | 11 | 23 | 23011 | 12300 | Central | Kennebec County | https://data.medicare.gov/resource/xubh-q36u/row-k6q5-wdks.vqnn | 200039 | 659964 | 2019-11-25 | 2019-06-30 | 156 | 16 | 172 | 20 | 192 | ||||||||||||
688 | 688 | SPECTRUM HEALTH PENNOCK | 1009 W GREEN ST | HASTINGS | MI | 49058 | BARRY | (269) 945-3451 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 42.6442000 | -85.3021000 | 0 | 15 | 26 | 26015 | 24340 | Grand Rapids-Wyoming-Muskegon, MI | Outlying | Barry County | https://data.medicare.gov/resource/xubh-q36u/row-7m4u.pz7d~8678 | 231339 | 660108 | 2019-11-25 | 2019-06-30 | 19 | 6 | 25 | 25 | ||||||||||||
1301 | 1301 | CLARION HOSPITAL | ONE HOSPITAL DRIVE | CLARION | PA | 16214 | CLARION | (814) 226-9500 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 41.1927583 | -79.3976930 | 1 | ROOFTOP | 31 | 42 | 42031 | https://data.medicare.gov/resource/xubh-q36u/row-5n3x.3zm2.8hqq | 390093 | 660440 | 2019-11-25 | 2019-06-30 | 50 | 7 | 57 | 8 | 65 | ||||||||||||||
1372 | 1372 | UW MEDICINE/NORTHWEST HOSPITAL | 1550 NORTH 115TH STREET | SEATTLE | WA | 98133 | KING | (206) 368-1700 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 47.7122630 | -122.3359360 | 0 | 33 | 53 | 53033 | 42660 | Seattle-Tacoma, WA | Central | King County | https://data.medicare.gov/resource/xubh-q36u/row-drv9~ptgn-5qjd | 500001 | 660337 | 2019-11-25 | 2019-06-30 | 147 | 32 | 179 | 27 | 206 | |||||||||||
2355 | 2355 | BAPTIST HEALTH LEXINGTON | 1740 NICHOLASVILLE ROAD | LEXINGTON | KY | 40503 | FAYETTE | (859) 260-6104 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.0188420 | -84.5139480 | 0 | 67 | 21 | 21067 | 30460 | Lexington-Fayette--Richmond--Frankfort, KY | Central | Fayette County | https://data.medicare.gov/resource/xubh-q36u/row-w47h-k353~ymyx | 180103 | 660563 | 2019-11-25 | 2018-08-31 | 339 | 52 | 391 | 391 | ||||||||||||
2488 | 2488 | NEWBERRY COUNTY MEMORIAL HOSPITAL | 2669 KINARD ST PO BOX 497 | NEWBERRY | SC | 29108 | NEWBERRY | (803) 405-7145 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 34.2894330 | -81.6049150 | 0 | 71 | 45 | 45071 | 35140 | Columbia-Orangeburg-Newberry, SC | Central | Newberry County | https://data.medicare.gov/resource/xubh-q36u/row-9ehy.xh96.39uz | 420053 | 659725 | 2019-11-25 | 2019-06-30 | 41 | 7 | 48 | 48 | ||||||||||||
4008 | 4008 | NORTHCREST MEDICAL CENTER | 100 NORTHCREST DRIVE | SPRINGFIELD | TN | 37172 | ROBERTSON | (615) 384-2411 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 36.4795180 | -86.8888980 | 0 | 147 | 47 | 47147 | 34980 | Nashville-Davidson--Murfreesboro, TN | Outlying | Robertson County | https://data.medicare.gov/resource/xubh-q36u/row-xhnc.dc7v_7vxz | 440065 | 660043 | 2019-11-25 | 2019-06-30 | 101 | 8 | 109 | 109 | ||||||||||||
4057 | 4057 | RAWLINS COUNTY HEALTH CENTER | 707 GRANT ST | ATWOOD | KS | 67730 | RAWLINS | (785) 626-3211 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 39.8132640 | -101.0385000 | 0 | 153 | 20 | 20153 | https://data.medicare.gov/resource/xubh-q36u/row-aajh-f5t2_nat3 | 171307 | 659791 | 2019-11-25 | 2019-06-30 | 15 | 15 | 15 | |||||||||||||||||
4203 | 4203 | ORANGE CITY AREA HEALTH SYSTEM | 1000 LINCOLN CIRCLE SE | ORANGE CITY | IA | 51041 | SIOUX | (712) 737-4984 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 42.9948780 | -96.0457340 | 0 | 167 | 19 | 19167 | https://data.medicare.gov/resource/xubh-q36u/row-j9vg.b9hy-cjqt | 161360 | 659790 | 2019-11-25 | 2019-06-30 | 25 | 25 | 25 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [hospital_data] ( [hospital_name] TEXT, [address] TEXT, [city] TEXT, [state] TEXT, [zip_code] INTEGER, [county_name] TEXT, [phone_number] TEXT, [hospital_type] TEXT, [hospital_ownership] TEXT, [emergency_services] TEXT, [lat] TEXT, [lng] TEXT, [geocode_flag] INTEGER, [geocode_accuracy] TEXT, [countyfips] INTEGER, [statefips] INTEGER, [statecountyfips] INTEGER, [cbsacode] TEXT, [csatitle] TEXT, [centraloutlyingcounty] TEXT, [countyequivalent] TEXT, [hosp_lookup_url] TEXT, [PRVDR_NUM] INTEGER, [RPT_REC_NUM] INTEGER, [filed_date] TEXT, [fy_end_date] TEXT, [acute_beds] INTEGER, [icu_beds] TEXT, [coronary_beds] TEXT, [burn_beds] TEXT, [surg_icu_beds] TEXT, [oth_spec_beds] TEXT, [subtotal_acute_beds] INTEGER, [subprovider_ipf_beds] TEXT, [subprovider_irf_beds] TEXT, [subprovider_oth_beds] TEXT, [skilled_nursing_beds] TEXT, [nursing_fac_beds] TEXT, [oth_longterm_beds] TEXT, [hospice_beds] TEXT, [all_beds] INTEGER );