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

24 rows where "fy_end_date" is on date 2019-01-31

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, county_name, hospital_type, hospital_ownership, emergency_services, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_date, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, all_beds, filed_date (date)

fy_end_date (date) ✖

  • 2019-01-31 · 24 ✖
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
109 109 LOVELACE WESTSIDE HOSPITAL 10501 GOLF COURSE ROAD NW ALBUQUERQUE NM 87114 BERNALILLO (505) 727-2001 Acute Care Hospitals Proprietary TRUE 35.2075080 -106.6759740 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-t6an-qbnd.nby8 320074 651222 2019-06-28 2019-01-31 62 8         70               70
202 202 SOUTHERN HILLS HOSPITAL AND MEDICAL CENTER 9300 WEST SUNSET RD LAS VEGAS NV 89148 CLARK (702) 880-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0702560 -115.2955120 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-cqhe-8u2q_uxa4 290047 651711 2019-07-01 2019-01-31 135 22       15 172 14             186
206 206 SUNRISE HOSPITAL AND MEDICAL CENTER 3186 S MARYLAND PKWY LAS VEGAS NV 89109 CLARK (702) 731-8000 Acute Care Hospitals Proprietary TRUE 36.1345860 -115.1368830 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-9gwr_6ph4-9w5i 290003 652435 2019-08-01 2019-01-31 376 64     20 72 554   42           596
269 269 GULF COAST REGIONAL MEDICAL CENTER 449 W 23RD ST PANAMA CITY FL 32405 BAY (850) 769-8341 Acute Care Hospitals Proprietary TRUE 30.1896820 -85.6661240 0   5 12 12005 37460   Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-7wyf_m6mi-z99k 100242 651510 2019-07-01 2019-01-31 170 20       28 222               222
494 494 WESTSIDE REGIONAL MEDICAL CENTER 8201 W BROWARD BLVD PLANTATION FL 33324 BROWARD (954) 473-6600 Acute Care Hospitals Proprietary FALSE 26.1208820 -80.2584290 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-nnuu-rs8x~9yxs 100228 651509 2019-06-28 2019-01-31 192 32         224               224
563 563 CHANDLER REGIONAL MEDICAL CENTER 1955 WEST FRYE ROAD CHANDLER AZ 85224 MARICOPA (480) 728-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.2986910 -111.8735080 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-zqcn.hhh2-gsee 30036 659471 2019-11-18 2019-01-31 277 49         338               338
751 751 METROWEST MEDICAL CENTER 115 LINCOLN STREET FRAMINGHAM MA 1701 MIDDLESEX (508) 383-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2842700 -71.4197540 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-jxfn~nfcv-9atv 220175 652195 2019-07-01 2019-01-31 194 22         216 72             288
920 920 MEMORIAL MISSION HOSPITAL AND ASHEVILLE SURGERY CE 509 BILTMORE AVE ASHEVILLE NC 28801 BUNCOMBE (828) 213-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.5779420 -82.5483700 0   21 37 37021 11700 Asheville-Brevard, NC Central Buncombe County https://data.medicare.gov/resource/xubh-q36u/row-bp7g-nivr_i743 340002 652663 2019-07-26 2019-01-31 448 146 20     51 665 62             727
1082 1082 ST VINCENT HOSPITAL 123 SUMMER STREET WORCESTER MA 1608 WORCESTER (508) 363-5000 Acute Care Hospitals Proprietary TRUE 42.2659710 -71.7954900 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-vfu4_exvq.gvbq 220176 651783 2019-06-27 2019-01-31 239       20   259 13             272
1466 1466 CALIFORNIA HOSPITAL MEDICAL CENTER LA 1401 SOUTH GRAND AVENUE LOS ANGELES CA 90015 LOS ANGELES (213) 748-2411 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.0372120 -118.2653630 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-azik.d4zd~xp8w 50149 659198 2019-11-18 2019-01-31 264 28       26 318               318
1492 1492 NORTHRIDGE HOSPITAL MEDICAL CENTER 18300 ROSCOE BLVD NORTHRIDGE CA 91325 LOS ANGELES (818) 885-8500 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2207890 -118.5332160 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-ig89.azt3-j8hs 50116 659194 2019-11-18 2019-01-31 234 46       18 318 40 36           394
1555 1555 CEDAR COUNTY MEMORIAL HOSPITAL 1401 SOUTH PARK STREET EL DORADO SPRINGS MO 64744 CEDAR (417) 876-2511 Critical Access Hospitals Government - Local TRUE 37.8606740 -94.0185050 0   39 29 29039         https://data.medicare.gov/resource/xubh-q36u/row-6kgc-85en.jtc2 261323 651640 2019-06-27 2019-01-31 25           25               25
1618 1618 HCA HOUSTON HEALTHCARE PEARLAND 11100 SHADOW CREEK PARKWAY PEARLAND TX 77584 BRAZORIA (713) 770-7000 Acute Care Hospitals Proprietary TRUE 29.5799940 -95.3919110 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-z9yc-krd4-cpqc 670106 651121 2019-06-27 2019-01-31 41 8         49               49
1820 1820 ASHLEY REGIONAL MEDICAL CENTER 150 WEST 100 NORTH VERNAL UT 84078 UINTAH (435) 789-3342 Acute Care Hospitals Proprietary TRUE 40.4577900 -109.5304640 0   47 49 49047 46860   Central Uintah County https://data.medicare.gov/resource/xubh-q36u/row-ydws.ihn5-urcm 460030 651729 2019-07-03 2019-01-31 35 4         39               39
2440 2440 BARSTOW COMMUNITY HOSPITAL 820 E MOUNTAIN VIEW STREET BARSTOW CA 92311 SAN BERNARDINO (760) 256-1761 Acute Care Hospitals Proprietary TRUE 34.8936960 -117.0166000 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-2mmv_xa7g.rdya 50298 654086 2019-08-27 2019-01-31 26 4         30               30
2629 2629 HENDERSON COUNTY COMMUNITY HOSPITAL 200 W CHURCH ST LEXINGTON TN 38351 HENDERSON (731) 968-1801 Acute Care Hospitals Proprietary TRUE 35.6541950 -88.3988380 0   77 47 47077         https://data.medicare.gov/resource/xubh-q36u/row-cnu2~rrwu-tu6p 440008 653856 2019-08-27 2019-01-31 36           36               36
2640 2640 FRENCH HOSPITAL MEDICAL CENTER 1911 JOHNSON AVE SAN LUIS OBISPO CA 93401 SAN LUIS OBISPO (805) 543-5353 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2786630 -120.6502120 0   79 6 6079 42020   Central San Luis Obispo County https://data.medicare.gov/resource/xubh-q36u/row-bis7_sxyv_suh7 50232 660167 2019-11-18 2019-01-31 87 11         98               98
2686 2686 SEQUOIA HOSPITAL 170 ALAMEDA DE LAS PULGAS REDWOOD CITY CA 94062 SAN MATEO (650) 367-5551 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4809870 -122.2532230 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-gsqv_bt37.hfgx 50197 659476 2019-11-18 2019-01-31 171 16 21       208               208
2777 2777 GOOD SAMARITAN HOSPITAL 2425 SAMARITAN DRIVE SAN JOSE CA 95124 SANTA CLARA (408) 559-2011 Acute Care Hospitals Proprietary TRUE 37.2511040 -121.9465630 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-22ue_gc2m_q5ju 50380 651600 2019-06-28 2019-01-31 223 24 17       309 18 15           342
3445 3445 MISSION HOSPITAL MCDOWELL 430 RANKIN DRIVE P O BOX 730 MARION NC 28752 MC DOWELL (828) 659-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6651870 -82.0217720 0   111 37 37111 32000 Hickory-Lenoir, NC Central McDowell County https://data.medicare.gov/resource/xubh-q36u/row-k2nj~ckkt.k7ui 340087 660651 2019-12-02 2019-01-31 40 9         49               49
3458 3458 WOODLAND MEMORIAL HOSPITAL 1325 COTTONWOOD STREET WOODLAND CA 95695 YOLO (530) 662-3961 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.6643440 -121.7934030 0   113 6 6113 40900 Sacramento-Roseville, CA Outlying Yolo County https://data.medicare.gov/resource/xubh-q36u/row-d6ip_hh3b.rimz 50127 659473 2019-11-18 2019-01-31 69 8         77 31             108
3478 3478 HIGHLANDS CASHIERS HOSPITAL 190 HOSPITAL DRIVE HIGHLANDS NC 28741 MACON (828) 526-1200 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0856520 -83.1861100 0   113 37 37113         https://data.medicare.gov/resource/xubh-q36u/row-sjsc-r5is_zgk4 341316 661372 2019-12-16 2019-01-31 24           24               24
4635 4635 MEDICAL CITY FORT WORTH 900 EIGHTH AVENUE FORT WORTH TX 76104 TARRANT (817) 336-2100 Acute Care Hospitals Proprietary TRUE 32.7354810 -97.3437040 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-ur6k~km8p~s2zk 450672 651726 2019-06-28 2019-01-31 156 44         200   18           218
4636 4636 MEDICAL CITY ALLIANCE 3101 NORTH TARRANT PARKWAY FORT WORTH TX 76177 TARRANT (817) 639-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8985270 -97.3138140 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-7h4z-bqez~gg2f 670103 650796 2019-06-24 2019-01-31 59 8       8 75               75

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