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

23 rows where "filed_date" is on date 2019-05-28 and hospital_ownership = "Proprietary"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, zip_code, county_name, hospital_type, emergency_services, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, icu_beds, coronary_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, all_beds, filed_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
194 194 MOUNTAINVIEW HOSPITAL 3100 N TENAYA WAY LAS VEGAS NV 89128 CLARK (702) 255-5065 Acute Care Hospitals Proprietary TRUE 36.2156000 -115.2507950 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-ifwz~wzbs.p5xc 290039 650298 2019-05-28 2018-12-31 277 47       24 348   36           384
664 664 HOSPITAL DR CAYETANO COLL Y TOSTE CARRETERA 129 KM.1 AVENIDA SAN LUIS ARECIBO PR 613 ARECIBO (787) 650-7272 Acute Care Hospitals Proprietary TRUE 18.4672197 -66.7313808 1 ROOFTOP 13 72 72013 11640 San Juan-Carolina, PR Central Arecibo Municipio https://data.medicare.gov/resource/xubh-q36u/row-7vbx.kyy9.acup 400087 650361 2019-05-28 2018-12-31 148 8       16 172               172
804 804 SANTA CRUZ VALLEY REGIONAL HOSPITAL 4455 SOUTH I-19 FRONTAGE ROAD GREEN VALLEY AZ 85614 PIMA (520) 393-4700 Acute Care Hospitals Proprietary TRUE 31.8079430 -111.0109660 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-td2s-wa4r_529q 30137 650635 2019-05-28 2018-12-31 43 6         49               49
1476 1476 COAST PLAZA HOSPITAL 13100 STUDERBAKER ROAD NORWALK CA 90650 LOS ANGELES (310) 356-0550 Acute Care Hospitals Proprietary TRUE 33.9124280 -118.0991560 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-baz4~ypiy.z9bn 50771 650565 2019-05-28 2018-12-31 110 7         117               117
1477 1477 COMMUNITY HOSPITAL OF HUNTINGTON PARK 2623 E SLAUSON AVE HUNTINGTON PARK CA 90255 LOS ANGELES (323) 583-1931 Acute Care Hospitals Proprietary TRUE 33.9891820 -118.2241900 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-iys2_ksat~f7ec 50091 649701 2019-05-28 2018-12-31 77 4         81               81
1478 1478 EAST LOS ANGELES DOCTORS HOSPITAL 4060 WHITTIER BLVD LOS ANGELES CA 90023 LOS ANGELES (323) 268-5514 Acute Care Hospitals Proprietary FALSE 34.0239300 -118.1842850 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-9bfr_bqi3-29y6 50641 649702 2019-05-28 2018-12-31 92 10         102       25       127
1481 1481 MEMORIAL HOSPITAL OF GARDENA 1145 W REDONDO BEACH BLVD GARDENA CA 90247 LOS ANGELES (310) 532-4200 Acute Care Hospitals Proprietary FALSE 33.8923750 -118.2951060 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-hmjb.hw5r-grvf 50468 650564 2019-05-28 2018-12-31 93 10         103       69       172
1878 1878 TIMPANOGOS REGIONAL HOSPITAL 750 WEST 800 NORTH OREM UT 84057 UTAH (801) 714-6800 Acute Care Hospitals Proprietary TRUE 40.3121730 -111.7149900 0   49 49 49049 39340 Salt Lake City-Provo-Orem, UT Central Utah County https://data.medicare.gov/resource/xubh-q36u/row-gve8_aynp_383h 460052 648781 2019-05-28 2018-12-31 68 20       29 117               117
1989 1989 CARIBBEAN MEDICAL CENTER 151 AVE OSVALDO MOLINA FAJARDO PR 738 FAJARDO (787) 801-0081 Acute Care Hospitals Proprietary TRUE 18.3321123 -65.6501216 1 ROOFTOP 53 72 72053 41980 San Juan-Carolina, PR Outlying Fajardo Municipio https://data.medicare.gov/resource/xubh-q36u/row-8r2t_fsxg-uxdh 400131 648864 2019-05-28 2018-12-31 38 4         42               42
2984 2984 MANATI MEDICAL CENTER DR OTERO LOPEZ CALLE HERNANDEZ CARRION URB ATENAS MANATI PR 674 MANATI (787) 621-3700 Acute Care Hospitals Proprietary TRUE 18.4346023 -66.4823714 1 GEOMETRIC_CENTER 91 72 72091 41980 San Juan-Carolina, PR Central Manatí Municipio https://data.medicare.gov/resource/xubh-q36u/row-bgg8-aaue_zyh9 400114 649496 2019-05-28 2018-12-31 231 20         251               251
3130 3130 MAYAGUEZ MEDICAL CENTER DR RAMON EMETERIO BETANCES CARR 2 BO SABALOS MAYAGUEZ PR 682 MAYAGUEZ (787) 652-9200 Acute Care Hospitals Proprietary TRUE 18.1764606 -67.1512480 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-gthf.kgy6-stvn 400103 648571 2019-05-28 2018-12-31 161 31         192               192
3131 3131 HOSPITAL PEREA 15 DR BASORA STREET MAYAGUEZ PR 681 MAYAGUEZ (787) 834-0101 Acute Care Hospitals Proprietary TRUE 18.2028218 -67.1398281 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-gmvm-vs4t~timp 400123 649348 2019-05-28 2018-12-31 106 4       8 118               118
3291 3291 BLACK HILLS SURGICAL HOSPITAL LLP 216 ANAMARIA DR RAPID CITY SD 57703 PENNINGTON (605) 721-4700 Acute Care Hospitals Proprietary FALSE 44.0460350 -103.2229120 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-g4ad-2arx~xwzj 430091 650609 2019-05-28 2018-12-31 26           26               26
3379 3379 LINCOLN SURGICAL HOSPITAL 1710 SOUTH 70TH ST LINCOLN NE 68506 LANCASTER (402) 484-9090 Acute Care Hospitals Proprietary FALSE 40.7947180 -96.6249740 0   109 31 31109 30700 Lincoln-Beatrice, NE Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-hidj_7arr-2ww3 280127 648714 2019-05-28 2018-12-31 21           21               21
3491 3491 BAYLOR SURGICAL HOSPITAL AT LAS COLINAS 400 WEST INTERSTATE 635 SUITE 101 IRVING TX 75063 DALLAS (972) 868-4000 Acute Care Hospitals Proprietary TRUE 32.9123170 -96.9515220 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-bgqf-7u9w-mxah 450874 651485 2019-05-28 2018-12-31 20           20               20
3776 3776 HOSPITAL SAN FRANCISCO 371 DE DIEGO AVE SAN JUAN PR 923 SAN JUAN (787) 767-5100 Acute Care Hospitals Proprietary TRUE 18.3990299 -66.0387156 1 ROOFTOP 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-ptc2_mz25~5eh6 400098 650771 2019-05-28 2018-12-31 115 10         125               125
3938 3938 HOSPITAL METROPOLITANO DE LA MONTANA CALLE ISAAC GONZALEZ ESQUINA LEDESMA BDA NUEVA PR 641 UTUADO (787) 933-1100 Acute Care Hospitals Proprietary TRUE 18.2675675 -66.7013424 1 GEOMETRIC_CENTER 141 72 72141 10380   Central Utuado Municipio https://data.medicare.gov/resource/xubh-q36u/row-8n9a.kpfm-bvb9 400130 650777 2019-05-28 2018-12-31 7           7 40             47
4301 4301 TEXOMA MEDICAL CENTER 5016 S US HIGHWAY 75 DENISON TX 75020 GRAYSON (903) 416-4000 Acute Care Hospitals Proprietary TRUE 33.7111330 -96.5869560 0   181 48 48181 43300 Dallas-Fort Worth, TX-OK Central Grayson County https://data.medicare.gov/resource/xubh-q36u/row-f76b.3utz.ar9i 450324 649355 2019-05-28 2018-12-31 265 52         329 28 21           378
4474 4474 CORNERSTONE REGIONAL HOSPITAL 2302 CORNERSTONE BOULEVARD EDINBURG TX 78539 HIDALGO (956) 618-4444 Acute Care Hospitals Proprietary TRUE 26.2630960 -98.1991640 0   215 48 48215 32580 McAllen-Edinburg, TX Central Hidalgo County https://data.medicare.gov/resource/xubh-q36u/row-wtje.zqmn.bcn4 450825 649141 2019-05-28 2018-12-31 14           14               14
4477 4477 SOUTH TEXAS HEALTH SYSTEM 1102 W TRENTON ROAD EDINBURG TX 78539 HIDALGO (956) 632-4484 Acute Care Hospitals Proprietary TRUE 26.2633410 -98.1828490 0   215 48 48215 32580 McAllen-Edinburg, TX Central Hidalgo County https://data.medicare.gov/resource/xubh-q36u/row-ueuk_wahb_mxys 450119 651355 2019-05-28 2018-12-31 601 81 60       788 28 22           838
4576 4576 FORT DUNCAN MEDICAL CENTER 3333 N FOSTER MALDONADO BLVD EAGLE PASS TX 78852 MAVERICK (830) 773-5321 Acute Care Hospitals Proprietary TRUE 28.7114180 -100.4541050 0   323 48 48323 20580   Central Maverick County https://data.medicare.gov/resource/xubh-q36u/row-zqqu-eqhh-2cw6 450092 648764 2019-05-28 2018-12-31 76 10         86   15           101
4618 4618 SABINE COUNTY HOSPITAL PO BOX 750, 2301 HWY 83 W HEMPHILL TX 75948 SABINE (409) 787-3300 Critical Access Hospitals Proprietary TRUE 31.3407403 -93.8468520 1 APPROXIMATE 403 48 48403         https://data.medicare.gov/resource/xubh-q36u/row-quek_rvd7~v5jz 451361 648996 2019-05-28 2018-12-31 25           25               25
4690 4690 DOCTORS HOSPITAL OF LAREDO 10700 MCPHERSON ROAD LAREDO TX 78041 WEBB (956) 523-2000 Acute Care Hospitals Proprietary TRUE 27.6070900 -99.4762810 0   479 48 48479 29700   Central Webb County https://data.medicare.gov/resource/xubh-q36u/row-6c8y.r68k.t52s 450643 648988 2019-05-28 2018-12-31 135 24         171   12           183

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