hospital_data
Data source: Big Local News · About: big-local-datasette
16 rows where "filed_date" is on date 2019-06-03 and hospital_ownership = "Voluntary non-profit - Church"
This data as json, copyable, CSV (advanced)
Suggested facets: state, county_name, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, countyequivalent, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, subprovider_oth_beds, skilled_nursing_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
262 | 262 | CENTURA HEALTH-LITTLETON ADVENTIST HOSPITAL | 7700 S BROADWAY | LITTLETON | CO | 80122 | ARAPAHOE | (303) 730-8900 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 39.5765540 | -104.9884890 | 0 | 5 | 8 | 8005 | 19740 | Denver-Aurora, CO | Central | Arapahoe County | https://data.medicare.gov/resource/xubh-q36u/row-xab7~spdz_mmxf | 60113 | 649074 | 2019-06-03 | 2018-12-31 | 121 | 24 | 159 | 17 | 176 | |||||||||||
592 | 592 | CENTURA HEALTH-AVISTA ADVENTIST HOSPITAL | 100 HEALTH PARK DR | LOUISVILLE | CO | 80027 | BOULDER | (303) 673-1280 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 39.9508470 | -105.1491540 | 0 | 13 | 8 | 8013 | 14500 | Denver-Aurora, CO | Central | Boulder County | https://data.medicare.gov/resource/xubh-q36u/row-mqpm_6h4w_if8p | 60103 | 649709 | 2019-06-03 | 2018-12-31 | 74 | 8 | 108 | 108 | ||||||||||||
766 | 766 | CAREPOINT HEALTH-HOBOKEN UNIVERSITY MEDICAL CENTER | 308 WILLOW AVE | HOBOKEN | NJ | 7030 | HUDSON | (201) 418-1000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 40.7412130 | -74.0335590 | 0 | 17 | 34 | 34017 | 35620 | New York-Newark, NY-NJ-CT-PA | Central | Hudson County | https://data.medicare.gov/resource/xubh-q36u/row-64ry-qaxe-vxjm | 310040 | 649624 | 2019-06-03 | 2018-12-31 | 102 | 15 | 117 | 47 | 11 | 15 | 190 | |||||||||
767 | 767 | CAREPOINT HEALTH-CHRIST HOSPITAL | 176 PALISADE AVE | JERSEY CITY | NJ | 7306 | HUDSON | (201) 795-8200 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 40.7348760 | -74.0501420 | 0 | 17 | 34 | 34017 | 35620 | New York-Newark, NY-NJ-CT-PA | Central | Hudson County | https://data.medicare.gov/resource/xubh-q36u/row-zyny.ji2k-c7cs | 310016 | 648953 | 2019-06-03 | 2018-12-31 | 160 | 18 | 178 | 178 | ||||||||||||
834 | 834 | ST JOSEPH HOSPITAL | 360 BROADWAY | BANGOR | ME | 4401 | PENOBSCOT | (207) 262-1000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 44.8145300 | -68.7712600 | 0 | 19 | 23 | 23019 | 12620 | Central | Penobscot County | https://data.medicare.gov/resource/xubh-q36u/row-ad3u-g4s7-xxty | 200001 | 650700 | 2019-06-03 | 2018-12-31 | 92 | 7 | 99 | 99 | |||||||||||||
1155 | 1155 | BERTRAND CHAFFEE HOSPITAL | 224 EAST MAIN STREET | SPRINGVILLE | NY | 14141 | ERIE | (716) 592-2871 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 42.5084840 | -78.6592350 | 0 | 29 | 36 | 36029 | 15380 | Buffalo-Cheektowaga, NY | Central | Erie County | https://data.medicare.gov/resource/xubh-q36u/row-kh2y-a8h3~k7jx | 330111 | 650864 | 2019-06-03 | 2018-12-31 | 21 | 2 | 23 | 80 | 103 | |||||||||||
2561 | 2561 | CALIFORNIA PACIFIC MEDICAL CENTER - MISSION BERNAL | 3555 CESAR CHAVEZ STREET | SAN FRANCISCO | CA | 94110 | SAN FRANCISCO | (415) 641-6562 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 37.7480500 | -122.4209870 | 0 | 75 | 6 | 6075 | 41860 | San Jose-San Francisco-Oakland, CA | Central | San Francisco County | https://data.medicare.gov/resource/xubh-q36u/row-9ens-9k58_jhkp | 50055 | 650944 | 2019-06-03 | 2018-12-31 | 110 | 10 | 120 | 120 | ||||||||||||
2895 | 2895 | FRANCISCAN HEALTH DYER | 24 JOLIET ST | DYER | IN | 46311 | LAKE | (219) 865-2141 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 41.4943650 | -87.5241660 | 0 | 89 | 18 | 18089 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Lake County | https://data.medicare.gov/resource/xubh-q36u/row-ptgy-v6qn-79qv | 150090 | 649568 | 2019-06-03 | 2018-12-31 | 119 | 14 | 7 | 140 | 30 | 170 | ||||||||||
2899 | 2899 | FRANCISCAN HEALTH CROWN POINT | 1201 S MAIN ST | CROWN POINT | IN | 46307 | LAKE | (219) 757-6100 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 41.3964970 | -87.3644360 | 0 | 89 | 18 | 18089 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Lake County | https://data.medicare.gov/resource/xubh-q36u/row-bu7y_i7m5~izb5 | 150126 | 649896 | 2019-06-03 | 2018-12-31 | 172 | 22 | 20 | 214 | 214 | |||||||||||
3100 | 3100 | FRANCISCAN HEALTH INDIANAPOLIS | 8111 S EMERSON AVE | INDIANAPOLIS | IN | 46237 | MARION | (317) 528-5000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 39.6483650 | -86.0826740 | 0 | 97 | 18 | 18097 | 26900 | Indianapolis-Carmel-Muncie, IN | Central | Marion County | https://data.medicare.gov/resource/xubh-q36u/row-caju~6id9.wgbb | 150162 | 649897 | 2019-06-03 | 2018-12-31 | 257 | 60 | 66 | 31 | 441 | 21 | 462 | |||||||||
3129 | 3129 | BELLA VISTA HOSPITAL | CARR 349 KM 2 7 CERRO LAS MESAS | MAYAGUEZ | PR | 681 | MAYAGUEZ | (787) 652-6045 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 18.1868275 | -67.1192192 | 1 | GEOMETRIC_CENTER | 97 | 72 | 72097 | 32420 | Mayagüez-San Germán, PR | Central | Mayagüez Municipio | https://data.medicare.gov/resource/xubh-q36u/row-3qj8-u7h6~eihq | 400014 | 650360 | 2019-06-03 | 2018-12-31 | 149 | 9 | 158 | 25 | 183 | ||||||||||
3281 | 3281 | GOOD SAMARITAN HOSPITAL MEDICAL CENTER | 1000 MONTAUK HIGHWAY | WEST ISLIP | NY | 11795 | SUFFOLK | (631) 376-3000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 40.6968070 | -73.2863210 | 0 | 103 | 36 | 36103 | 35620 | New York-Newark, NY-NJ-CT-PA | Central | Suffolk County | https://data.medicare.gov/resource/xubh-q36u/row-vej5-kcwb-92y5 | 330286 | 651033 | 2019-06-03 | 2018-12-31 | 373 | 44 | 16 | 437 | 437 | |||||||||||
3343 | 3343 | FRANCISCAN HEALTH CRAWFORDSVILLE | 1710 LAFAYETTE RD | CRAWFORDSVILLE | IN | 47933 | MONTGOMERY | (765) 362-2800 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 40.0660730 | -86.9080850 | 0 | 107 | 18 | 18107 | 18820 | Indianapolis-Carmel-Muncie, IN | Central | Montgomery County | https://data.medicare.gov/resource/xubh-q36u/row-dt4z-fqaw_yjyt | 150022 | 649562 | 2019-06-03 | 2018-12-31 | 24 | 5 | 29 | 11 | 40 | |||||||||||
3368 | 3368 | FRANCISCAN HEALTH MOORESVILLE | 1201 HADLEY RD | MOORESVILLE | IN | 46158 | MORGAN | (317) 831-1160 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 39.6093220 | -86.3560980 | 0 | 109 | 18 | 18109 | 26900 | Indianapolis-Carmel-Muncie, IN | Central | Morgan County | https://data.medicare.gov/resource/xubh-q36u/row-9xhw-5asg~b2v8 | 150057 | 649894 | 2019-06-03 | 2018-12-31 | 73 | 10 | 83 | 83 | ||||||||||||
3400 | 3400 | SSM HEALTH ST ANTHONY HOSPITAL - OKLAHOMA CITY | 1000 NORTH LEE AVENUE | OKLAHOMA CITY | OK | 73101 | OKLAHOMA | (405) 272-7000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 35.4777860 | -97.5242910 | 0 | 109 | 40 | 40109 | 36420 | Oklahoma City-Shawnee, OK | Central | Oklahoma County | https://data.medicare.gov/resource/xubh-q36u/row-muxg_8sv2-fqgg | 370037 | 651421 | 2019-06-03 | 2018-12-31 | 309 | 48 | 390 | 53 | 18 | 139 | 600 | |||||||||
4094 | 4094 | FRANCISCAN HEALTH LAFAYETTE | 1701 S CREASY LN | LAFAYETTE | IN | 47905 | TIPPECANOE | (765) 502-4334 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 40.3938450 | -86.8383780 | 0 | 157 | 18 | 18157 | 29200 | Lafayette-West Lafayette-Frankfort, IN | Central | Tippecanoe County | https://data.medicare.gov/resource/xubh-q36u/row-68pj~ad45-cb3k | 150109 | 649570 | 2019-06-03 | 2018-12-31 | 158 | 16 | 14 | 188 | 15 | 203 |
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 );