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

26 rows where "filed_date" is on date 2019-02-28 and hospital_ownership = "Proprietary"

✎ 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, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_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
241 241 KENT COUNTY MEMORIAL HOSPITAL 455 TOLL GATE RD WARWICK RI 2886 KENT (401) 737-7010 Acute Care Hospitals Proprietary TRUE 41.7044780 -71.4779020 0   3 44 44003 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-cxmm.944u~3iqc 410009 644655 2019-02-28 2018-09-30 308 15         323   20           343
263 263 SHARON HOSPITAL 50 HOSPITAL HILL ROAD SHARON CT 6069 LITCHFIELD (860) 364-4228 Acute Care Hospitals Proprietary TRUE 41.8796620 -73.4815720 0   5 9 9005 45860 New York-Newark, NY-NJ-CT-PA Central Litchfield County https://data.medicare.gov/resource/xubh-q36u/row-cvhr-qzru_z9ev 70004 658178 2019-02-28 2018-09-30 55 11         66 12             78
549 549 ABRAZO SCOTTSDALE CAMPUS 3929 EAST BELL ROAD PHOENIX AZ 85032 MARICOPA (602) 923-5000 Acute Care Hospitals Proprietary TRUE 33.6406030 -111.9976920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-3yrx.bcen.wd4a 30083 644698 2019-02-28 2018-09-30 113 14         127               127
667 667 STRINGFELLOW MEMORIAL HOSPITAL 301 EAST 18TH ST ANNISTON AL 36201 CALHOUN (256) 235-8900 Acute Care Hospitals Proprietary TRUE 33.6677010 -85.8250250 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-2tt8-gqrt.8qr7 10038 644691 2019-02-28 2018-09-30 119 6         125               125
730 730 BAYFRONT HEALTH SEVEN RIVERS 6201 N SUNCOAST BLVD CRYSTAL RIVER FL 34428 CITRUS (352) 795-6560 Acute Care Hospitals Proprietary TRUE 28.9508960 -82.6258660 0   17 12 12017 26140   Central Citrus County https://data.medicare.gov/resource/xubh-q36u/row-e3ek_i6mx~pzz2 100249 644711 2019-02-28 2018-09-30 112 16         128               128
792 792 MULESHOE AREA MEDICAL CENTER 708 S 1ST ST MULESHOE TX 79347 BAILEY (806) 272-4524 Critical Access Hospitals Proprietary TRUE 34.2210290 -102.7284580 0   17 48 48017         https://data.medicare.gov/resource/xubh-q36u/row-2yhf.nyid~b2dz 451372 644191 2019-02-28 2018-09-30 25           25               25
820 820 EASTERN IDAHO REGIONAL MEDICAL CENTER 3100 CHANNING WAY IDAHO FALLS ID 83404 BONNEVILLE (208) 529-6210 Acute Care Hospitals Proprietary TRUE 43.4702760 -111.9901590 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-zu9m_rfwy-xxuk 130018 644978 2019-02-28 2018-09-30 165 35         226 28 17       10   310
885 885 PHYSICIANS REGIONAL MEDICAL CENTER - PINE RIDGE 6101 PINE RIDGE ROAD NAPLES FL 34119 COLLIER (239) 348-4000 Acute Care Hospitals Proprietary TRUE 26.2117640 -81.7307070 0   21 12 12021 34940 Cape Coral-Fort Myers-Naples, FL Central Collier County https://data.medicare.gov/resource/xubh-q36u/row-z54t-v8nq.fk93 100286 643693 2019-02-28 2018-09-30 177 24         201               201
941 941 HOLY CROSS HOSPITAL 1171 WEST TARGET RANGE ROAD NOGALES AZ 85621 SANTA CRUZ (520) 285-3000 Critical Access Hospitals Proprietary TRUE 31.3411180 -110.9587340 0   23 4 4023 35700 Tucson-Nogales, AZ Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-datt~k3n6_g682 31313 644092 2019-02-28 2018-09-30 25           25               25
1067 1067 WEST VALLEY MEDICAL CENTER 1717 ARLINGTON STREET CALDWELL ID 83605 CANYON (208) 459-4641 Acute Care Hospitals Proprietary TRUE 43.6542200 -116.6956400 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-q3w9-74rj.ew8y 130014 645072 2019-02-28 2018-09-30 95 13       4 112               112
1215 1215 EAST GEORGIA REGIONAL MEDICAL CENTER 1499 FAIR ROAD STATESBORO GA 30458 BULLOCH (912) 486-1500 Acute Care Hospitals Proprietary TRUE 32.4151710 -81.7686500 0   31 13 13031 44340 Savannah-Hinesville-Statesboro, GA Central Bulloch County https://data.medicare.gov/resource/xubh-q36u/row-xsms-9ix9.jicj 110075 645062 2019-02-28 2018-09-30 118 24         142               142
2037 2037 KERSHAWHEALTH 1315 ROBERTS STREET CAMDEN SC 29020 KERSHAW (803) 432-4311 Acute Care Hospitals Proprietary TRUE 34.2531640 -80.5895790 0   55 45 45055 17900 Columbia-Orangeburg-Newberry, SC Outlying Kershaw County https://data.medicare.gov/resource/xubh-q36u/row-938m.r575~tkt8 420048 643943 2019-02-28 2018-09-30 113 10         123           55   178
2046 2046 WADLEY REGIONAL MEDICAL CENTER AT HOPE 2001 SOUTH MAIN HOPE AR 71801 HEMPSTEAD (870) 722-3800 Acute Care Hospitals Proprietary TRUE 33.6480080 -93.5870520 0   57 5 5057         https://data.medicare.gov/resource/xubh-q36u/row-zn9u-sntu_5nuw 40153 643865 2019-02-28 2018-09-30 59 8         67 12             79
2665 2665 PROVIDENCE HEALTH 120 GATEWAY CORPORATE BLVD COLUMBIA SC 29203 RICHLAND (803) 256-5300 Acute Care Hospitals Proprietary TRUE 34.1044220 -80.9550540 0   79 45 45079 17900 Columbia-Orangeburg-Newberry, SC Central Richland County https://data.medicare.gov/resource/xubh-q36u/row-4vdj-xj4s_we4k 420026 645172 2019-02-28 2018-09-30 273 18 32   9   332               332
2851 2851 LOWER KEYS MEDICAL CENTER 5900 COLLEGE ROAD KEY WEST FL 33040 MONROE (305) 294-5531 Acute Care Hospitals Proprietary TRUE 24.5815730 -81.7436880 0   87 12 12087 28580   Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-ygrq~jm9y.gjez 100150 644708 2019-02-28 2018-09-30 90 9         99 21             120
3016 3016 TENNOVA HEALTHCARE-NORTH KNOXVILLE MEDICAL CENTER 7565 DANNAHER WAY POWELL POWELL TN 37849 KNOX (865) 545-8000 Acute Care Hospitals Proprietary TRUE 36.0533300 -83.9965920 0   93 47 47093 28940 Knoxville-Morristown-Sevierville, TN Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-sfi4~bdiw.dy3i 440120 645185 2019-02-28 2018-09-30 282 52 44     15 393 25 22           440
3117 3117 DAVIS REGIONAL MEDICAL CENTER 218 OLD MOCKSBVILLE RD PO BOX 1823 STATESVILLE NC 28687 IREDELL (704) 873-0281 Acute Care Hospitals Proprietary TRUE 35.8186480 -80.8291896 1 ROOFTOP 97 37 37097 16740 Charlotte-Concord, NC-SC Central Iredell County https://data.medicare.gov/resource/xubh-q36u/row-ks69_qbdx-fr95 340144 645138 2019-02-28 2018-09-30 120 8         128 12             140
3196 3196 ADVENTHEALTH DADE CITY 13100 FT KING RD DADE CITY FL 33525 PASCO (352) 568-3174 Acute Care Hospitals Proprietary TRUE 28.3485870 -82.2016850 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-w886-maw8~uhkt 100211 644709 2019-02-28 2018-09-30 108 12         120               120
3250 3250 NORTHSIDE HOSPITAL 6000 49TH ST N SAINT PETERSBURG FL 33709 PINELLAS (813) 521-5000 Acute Care Hospitals Proprietary TRUE 27.8260530 -82.7000010 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-9c7k~923g.xenn 100238 645056 2019-02-28 2018-09-30 189 32         221               221
3258 3258 PALMS OF PASADENA HOSPITAL 1501 PASADENA AVE S SAINT PETERSBURG FL 33707 PINELLAS (727) 381-1000 Acute Care Hospitals Proprietary TRUE 27.7535170 -82.7381760 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-5brx.ibn9.ivnj 100126 644707 2019-02-28 2018-09-30 149 18         167   20           187
3357 3357 STARR REGIONAL MEDICAL CENTER ATHENS 1114 W MADISON AVE ATHENS TN 37371 MC MINN (423) 745-1411 Acute Care Hospitals Proprietary TRUE 35.4407890 -84.6088230 0   107 47 47107 11940 Chattanooga-Cleveland-Dalton, TN-GA-AL Central McMinn County https://data.medicare.gov/resource/xubh-q36u/row-j9r6~ujtq-iqfx 440068 644180 2019-02-28 2018-09-30 84 4         88 18     13 75     194
3575 3575 ARKANSAS HEART HOSPITAL, LLC 1701 S SHACKLEFORD ROAD LITTLE ROCK AR 72211 PULASKI (501) 219-7000 Acute Care Hospitals Proprietary TRUE 34.7391590 -92.3944210 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-jzxu~zre6.ev3c 40134 644703 2019-02-28 2018-09-30 112           112               112
3734 3734 TENNOVA HEALTHCARE-CLARKSVILLE 651 DUNLOP LANE CLARKSVILLE TN 37040 MONTGOMERY (931) 502-1000 Acute Care Hospitals Proprietary TRUE 36.5804140 -87.2684850 0   125 47 47125 17300   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-r6jb.kc9p.era9 440035 644065 2019-02-28 2018-09-30 200 21         234   20           254
3865 3865 ODESSA REGIONAL MEDICAL CENTER 520 E 6TH STREET ODESSA TX 79761 ECTOR (432) 582-8340 Acute Care Hospitals Proprietary TRUE 31.8514580 -102.3660270 0   135 48 48135 36220 Midland-Odessa, TX Central Ector County https://data.medicare.gov/resource/xubh-q36u/row-62b5_9y3z.qtwf 450661 643964 2019-02-28 2018-09-30 133 10       49 192   14           206
4079 4079 SPRING VIEW HOSPITAL 320 LORETTO ROAD LEBANON KY 40033 MARION (270) 692-5145 Acute Care Hospitals Proprietary TRUE 37.5703250 -85.2593970 0   155 21 21155         https://data.medicare.gov/resource/xubh-q36u/row-ri6m~j23x~rpdu 180024 643767 2019-02-28 2018-09-30 57 6         63 12             75
4739 4739 TWIN COUNTY REGIONAL HOSPITAL 200 HOSPITAL DRIVE GALAX VA 24333 GALAX CITY (276) 236-8181 Acute Care Hospitals Proprietary TRUE 36.6718130 -80.9238140 0   640 51 51640         https://data.medicare.gov/resource/xubh-q36u/row-scan.4a2b.zisp 490115 643992 2019-02-28 2018-09-30 131 10         141               141

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