hospital_data

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

19 rows where "filed_date" is on date 2019-12-03 and hospital_ownership = "Government - Local"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, county_name, hospital_type, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, burn_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_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
305 305 LINCOLN MEDICAL & MENTAL HEALTH CENTER 234 EAST 149TH STREET BRONX NY 10451 BRONX (718) 579-5000 Acute Care Hospitals Government - Local TRUE 40.8176810 -73.9240720 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-b6it.a7xa.ygmk 330080 661747 2019-12-03 2019-06-30 229 38       20 287 60             347
306 306 JACOBI MEDICAL CENTER 1400 PELHAM PARKWAY SOUTH BRONX NY 10461 BRONX (718) 918-5000 Acute Care Hospitals Government - Local TRUE 40.8574550 -73.8472100 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-ah92_ybye.fwuw 330127 661748 2019-12-03 2019-06-30 249 32 12 8   25 326 89 24           439
308 308 NORTH CENTRAL BRONX HOSPITAL 3424 KOSSUTH AVENUE & 210TH STREET BRONX NY 10467 BRONX (212) 519-5000 Acute Care Hospitals Government - Local TRUE 40.8804709 -73.8811305 1 RANGE_INTERPOLATED 5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-kzjb-7xtm_jntx 330385 661753 2019-12-03 2019-06-30 98 20       12 130 70             200
474 474 MEMORIAL HOSPITAL OF CONVERSE COUNTY 111 SOUTH 5TH STREET DOUGLAS WY 82633 CONVERSE (307) 358-2122 Critical Access Hospitals Government - Local TRUE 42.7588050 -105.3812790 0   9 56 56009         https://data.medicare.gov/resource/xubh-q36u/row-zei4~mbih_rgkv 531302 662095 2019-12-03 2019-06-30 25           25               25
1473 1473 LAC+USC MEDICAL CENTER 1200 N STATE ST, ROOM C2K100 LOS ANGELES CA 90033 LOS ANGELES (323) 226-2800 Acute Care Hospitals Government - Local TRUE 34.0598720 -118.2103080 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zb2x~3wn3~q6ug 50373 662473 2019-12-03 2019-06-30 396 128 10 20     594 76             670
1475 1475 LAC/HARBOR-UCLA MED CENTER 1000 W CARSON ST TORRANCE CA 90502 LOS ANGELES (310) 222-2101 Acute Care Hospitals Government - Local TRUE 33.8315830 -118.2945460 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-5whm.24nh_dyri 50376 662474 2019-12-03 2019-06-30 311 46 6       390 38             428
1801 1801 KINGS COUNTY HOSPITAL CENTER 451 CLARKSON AVENUE BROOKLYN NY 11203 KINGS (718) 245-3901 Acute Care Hospitals Government - Local TRUE 40.6557730 -73.9440390 0   47 36 36047 35620 New York-Newark, NY-NJ-CT-PA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-3ead-5d6n-7ch8 330202 661941 2019-12-03 2019-06-30 329 32 8     30 406 205 23           634
1803 1803 CONEY ISLAND HOSPITAL CENTER 2601 OCEAN PARKWAY BROOKLYN NY 11235 KINGS (718) 616-3000 Acute Care Hospitals Government - Local TRUE 40.5849400 -73.9662850 0   47 36 36047 35620 New York-Newark, NY-NJ-CT-PA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-fexm.v6yu~x42b 330196 661751 2019-12-03 2019-06-30 251 22 9     10 292 64 15           371
1805 1805 WOODHULL MEDICAL & MENTAL HEALTH CENTER 760 BROADWAY BROOKLYN NY 11206 KINGS (718) 963-8100 Acute Care Hospitals Government - Local TRUE 40.7005120 -73.9415570 0   47 36 36047 35620 New York-Newark, NY-NJ-CT-PA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-dr4w~e5x7-guxp 330396 661754 2019-12-03 2019-06-30 204 24       10 238 133             371
1975 1975 MILAN GENERAL HOSPITAL 4039 HIGHLAND ST MILAN TN 38358 GIBSON (731) 686-1591 Acute Care Hospitals Government - Local TRUE 35.9133110 -88.7534950 0   53 47 47053         https://data.medicare.gov/resource/xubh-q36u/row-b2mu-x63s-nuvr 440060 660042 2019-12-03 2019-06-30 44 3         47               47
2263 2263 DUKE REGIONAL HOSPITAL 3643 N ROXBORO STREET DURHAM NC 27704 DURHAM (919) 470-4000 Acute Care Hospitals Government - Local TRUE 36.0374390 -78.8970370 0   63 37 37063 20500 Raleigh-Durham-Chapel Hill, NC Central Durham County https://data.medicare.gov/resource/xubh-q36u/row-m5gb~2g67~avuk 340155 661577 2019-12-03 2019-06-30 279 22         301 23 30           354
2381 2381 SUMMERSVILLE REGIONAL MEDICAL CENTER 400 FAIRVIEW HEIGHTS ROAD SUMMERSVILLE WV 26651 NICHOLAS (304) 872-2891 Critical Access Hospitals Government - Local TRUE 38.2919030 -80.8311360 0   67 54 54067         https://data.medicare.gov/resource/xubh-q36u/row-a2eh.63jr_sfyc 511322 661675 2019-12-03 2019-06-30 19 6         25       52       77
2555 2555 LAWRENCE MEMORIAL HOSPITAL 1309 WEST MAIN STREET WALNUT RIDGE AR 72476 LAWRENCE (870) 886-1200 Critical Access Hospitals Government - Local TRUE 36.0747010 -90.9669820 0   75 5 5075         https://data.medicare.gov/resource/xubh-q36u/row-jpmn_3ec8~urk8 41309 661136 2019-12-03 2019-06-30 25           25               25
2564 2564 ZUCKERBERG SAN FRANCISCO GENERAL HOSP & TRAUMA CTR 1001 POTRERO AVENUE SAN FRANCISCO CA 94110 SAN FRANCISCO (415) 206-8000 Acute Care Hospitals Government - Local TRUE 37.7561710 -122.4066080 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-zbv8_bttg_wjmw 50228 662022 2019-12-03 2019-06-30 213 58       13 284 83     30       397
2710 2710 ELMHURST HOSPITAL CENTER 79-01 BROADWAY ELMHURST NY 11373 QUEENS (718) 334-1141 Acute Care Hospitals Government - Local TRUE 40.7443400 -73.8859800 0   81 36 36081 35620 New York-Newark, NY-NJ-CT-PA Central Queens County https://data.medicare.gov/resource/xubh-q36u/row-8fgb_w35z.836q 330128 661749 2019-12-03 2019-06-30 299 20 9     30 358 132 10           500
2716 2716 QUEENS HOSPITAL CENTER 82-68 164TH STREET JAMAICA NY 11432 QUEENS (718) 883-3000 Acute Care Hospitals Government - Local TRUE 40.7169800 -73.8034310 0   81 36 36081 35620 New York-Newark, NY-NJ-CT-PA Central Queens County https://data.medicare.gov/resource/xubh-q36u/row-dc2n_pkiz-sauj 330231 661752 2019-12-03 2019-06-30 169 16       15 200 53             253
3272 3272 UP HEALTH SYSTEM - MARQUETTE 850 W BARAGA AVE MARQUETTE MI 49855 MARQUETTE (906) 228-9440 Acute Care Hospitals Government - Local TRUE 46.5430810 -87.4110360 0   103 26 26103 32100   Central Marquette County https://data.medicare.gov/resource/xubh-q36u/row-qqgq-mmy3.4i67 230054 661339 2019-12-03 2019-06-30 201 26       11 238 43 20           301
3965 3965 RHEA MEDICAL CENTER 9400 RHEA COUNTY HIGHWAY DAYTON TN 37321 RHEA (423) 775-1121 Critical Access Hospitals Government - Local TRUE 35.5303740 -84.9823340 0   143 47 47143 19420 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Rhea County https://data.medicare.gov/resource/xubh-q36u/row-nzwz~fwja_c4gt 441310 661109 2019-12-03 2019-06-30 22 3         25               25
4024 4024 CORDELL MEMORIAL HOSPITAL 1220 NORTH GLENN ENGLISH STREET CORDELL OK 73632 WASHITA (580) 832-3339 Critical Access Hospitals Government - Local TRUE 35.3025240 -98.9875950 0   149 40 40149         https://data.medicare.gov/resource/xubh-q36u/row-k6qa-iqdm.jnj9 371325 660005 2019-12-03 2019-06-30 14           14               14

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);