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

22 rows where "filed_date" is on date 2019-05-31 and geocode_accuracy = "ROOFTOP"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, county_name, hospital_type, hospital_ownership, emergency_services, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, 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, 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
295 295 CARSON VALLEY MEDICAL CENTER 1107 HIGHWAY 395 GARDNERVILLE NV 89410 DOUGLAS (775) 782-1500 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9195628 -119.7189852 1 ROOFTOP 5 32 32005 23820 Reno-Carson City-Fernley, NV Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-zs3t-b2ik_qdz7 291306 650728 2019-05-31 2018-12-31 23           23               23
454 454 CAPE REGIONAL MEDICAL CENTER INC TWO STONE HARBOR BLVD CAPE MAY COURT HOUSE NJ 8210 CAPE MAY (609) 463-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0875407 -74.8169302 1 ROOFTOP 9 34 34009 36140 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Cape May County https://data.medicare.gov/resource/xubh-q36u/row-rka3_zh3w_qfu4 310011 649928 2019-05-31 2018-12-31 133 16         149               149
918 918 CAPITAL HEALTH MEDICAL CENTER - HOPEWELL ONE CAPITAL WAY PENNINGTON NJ 8534 MERCER (609) 303-4000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.2918008 -74.8041257 1 ROOFTOP 21 34 34021 45940 New York-Newark, NY-NJ-CT-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-57bi.fjhf.mmkn 310044 649048 2019-05-31 2018-12-31 129 16         145               145
1126 1126 ADVENTIST HEALTH TEHACHAPI VALLEY 1100 MAGELLAN TEHACHAPI CA 93561 KERN (661) 823-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1474419 -118.4504364 1 ROOFTOP 29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-xx6n.a25c~74jx 51301 648598 2019-05-31 2018-12-31 16 4         20               20
1314 1314 ADVENTIST HEALTH CLEARLAKE 15630 18TH AVE - HWY 53 CLEARLAKE CA 95422 LAKE (707) 994-6486 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.9353458 -122.6200816 1 ROOFTOP 33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-hud3~fp2e-cmcb 51317 648600 2019-05-31 2018-12-31 21 4         25               25
1485 1485 WHITE MEMORIAL MEDICAL CENTER 1720 E CESAR AVENUE LOS ANGELES CA 90033 LOS ANGELES (323) 268-5000 Acute Care Hospitals Voluntary non-profit - Church FALSE 34.0492967 -118.2171632 1 ROOFTOP 37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-n689-ji7q_qdqg 50103 659189 2019-05-31 2018-12-31 243 34       5 310   16   27       353
1721 1721 BAPTIST HEALTH MEDICAL CENTER-CONWAY 1555 EXCHANGE AVENUE CONWAY AR 72032 FAULKNER (501) 585-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0564394 -92.4192706 1 ROOFTOP 45 5 5045 30780 Little Rock-North Little Rock, AR Outlying Faulkner County https://data.medicare.gov/resource/xubh-q36u/row-begn.7uvq~4sez 40154 650111 2019-05-31 2018-12-31 102 8         110               110
1988 1988 HIMA-SAN PABLO FAJARDO GENERAL VALERO AVE#404 FAJARDO PR 738 FAJARDO (787) 655-0505 Acute Care Hospitals Proprietary TRUE 18.3356291 -65.6532034 1 ROOFTOP 53 72 72053 41980 San Juan-Carolina, PR Outlying Fajardo Municipio https://data.medicare.gov/resource/xubh-q36u/row-97wi-8fxd.yjx6 400125 650362 2019-05-31 2018-12-31 163 17         180               180
2057 2057 ST JOSEPHS HOSPITAL 3001 W MARTIN LUTHER KING JR BLVD TAMPA FL 33677 HILLSBOROUGH (813) 870-4398 Acute Care Hospitals Voluntary non-profit - Church TRUE 27.9822844 -82.4911306 1 ROOFTOP 57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-w8gx-3zfk-n7gh 100075 650969 2019-05-31 2018-12-31 866 106 26     64 1062               1062
2421 2421 HIMA SAN PABLO HUMACAO CALLE FONT MARTELO #3 HUMACAO PR 791 HUMACAO (787) 852-2424 Acute Care Hospitals Proprietary TRUE 18.1505887 -65.8266744 1 ROOFTOP 69 72 72069 41980 San Juan-Carolina, PR Central Humacao Municipio https://data.medicare.gov/resource/xubh-q36u/row-qp8j~6s5w~t5hf 400005 650770 2019-05-31 2018-12-31 58 6         64               64
2572 2572 HAMILTON COUNTY HOSPITAL 700 NORTH HUSER SYRACUSE KS 67878 HAMILTON (620) 384-7461 Critical Access Hospitals Government - Local TRUE 37.9846055 -101.7426286 1 ROOFTOP 75 20 20075         https://data.medicare.gov/resource/xubh-q36u/row-aubk-tw4u-vx2j 171322 649228 2019-05-31 2018-12-31 25           25               25
2829 2829 KENDALL REGIONAL MEDICAL CENTER 11750 BIRD RD MIAMI FL 33175 MIAMI-DADE (305) 223-3000 Acute Care Hospitals Proprietary TRUE 25.7319314 -80.3857679 1 ROOFTOP 86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-dsci.kfbc_pykp 100209 649079 2019-05-31 2018-12-31 322 52       13 394 23             417
2835 2835 CORAL GABLES HOSPITAL 3100 DOUGLAS RD CORAL GABLES FL 33134 MIAMI-DADE (305) 445-8461 Acute Care Hospitals Proprietary TRUE 25.7434206 -80.2547399 1 ROOFTOP 86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-aamf_du99_66z8 100183 649552 2019-05-31 2018-12-31 229 16         245               245
3277 3277 STONY BROOK UNIVERSITY HOSPITAL HEALTH SCIENCES CENTER SUNY STONY BROOK NY 11794 SUFFOLK (631) 444-4000 Acute Care Hospitals Government - State TRUE 40.9097910 -73.1161755 1 ROOFTOP 103 36 36103 35620 New York-Newark, NY-NJ-CT-PA Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-v82y.wvkf-fyvq 330393 650754 2019-05-31 2018-12-31 525 70   6   46 657 38             695
3482 3482 MIAMI VALLEY HOSPITAL ONE WYOMING STREET DAYTON OH 45409 MONTGOMERY (937) 208-3023 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7454533 -84.1856087 1 ROOFTOP 113 39 39113 19380 Dayton-Springfield-Sidney, OH Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-as44_ad35~hctr 360051 649310 2019-05-31 2018-12-31 574 103   10     753 32 40           825
3580 3580 BAPTIST HEALTH MEDICAL CENTER-LITTLE ROCK 9601 INTERSTATE LITTLE ROCK AR 72205 PULASKI (501) 202-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7443211 -92.3806640 1 ROOFTOP 119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-bf2h_7zv8-2ay2 40114 651550 2019-05-31 2018-12-31 513 36 18   18   683 24     27       734
3614 3614 NOVANT HEALTH MATTHEWS MEDICAL CENTER 1500 MATTHEWS TWNSHP PRKWY BOX 3310 MATTHEWS NC 28106 MECKLENBURG (704) 384-6500 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.1200788 -80.7140896 1 ROOFTOP 119 37 37119 16740 Charlotte-Concord, NC-SC Central Mecklenburg County https://data.medicare.gov/resource/xubh-q36u/row-w45y-62xv~5ktk 340171 650350 2019-05-31 2018-12-31 105 10         123               123
3616 3616 NOVANT HEALTH MINT HILL MEDICAL CENTER 8201 HEALTHCARE LOOP CHARLOTTE NC 28215 MECKLENBURG (704) 384-4089 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2227400 -80.6475276 1 ROOFTOP 119 37 37119 16740 Charlotte-Concord, NC-SC Central Mecklenburg County https://data.medicare.gov/resource/xubh-q36u/row-7d32-dc2j-jk39 340190 650352 2019-05-31 2018-12-31 24 4         28               28
3737 3737 HOSPITAL METROPOLITANO SAN GERMAN CALLE JAVILLA #8 AL COSTADO PARQUE DE BOMBAS SAN GERMAN PR 683 SAN GERMAN (787) 892-5300 Acute Care Hospitals Proprietary TRUE 18.0824930 -67.0401082 1 ROOFTOP 125 72 72125 41900 Mayagüez-San Germán, PR Central San Germán Municipio https://data.medicare.gov/resource/xubh-q36u/row-vvsg~hsvv~xuim 400126 649953 2019-05-31 2018-12-31 59 6         65               65
3767 3767 METROPOLITAN HOSPITAL CARRETERA 21 1785 URB LAS LOMAS SAN JUAN PR 915 SAN JUAN (787) 782-9999 Acute Care Hospitals Proprietary TRUE 18.3896633 -66.0988444 1 ROOFTOP 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-iham_kjk3_hiuu 400106 649952 2019-05-31 2018-12-31 126 6         132     15         147
3925 3925 THE HOSPITALS OF PROVIDENCE TRANSMOUNTAIN CAMPUS 2000 TRANSMOUNTAIN RD EL PASO TX 79911 EL PASO (915) 877-8136 Acute Care Hospitals Proprietary TRUE 31.9044828 -106.5650394 1 ROOFTOP 141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-8cqi.sqna_eif8 670120 649983 2019-05-31 2018-12-31 94 12         106               106
4193 4193 ATRIUM MEDICAL CENTER ONE MEDICAL CENTER DRIVE FRANKLIN OH 45005 WARREN (513) 420-5102 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4985347 -84.3148178 1 ROOFTOP 165 39 39165 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-hkrb_6v8h-iir7 360076 649316 2019-05-31 2018-12-31 160 16 41       217 30 20           267

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