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

35 rows where "filed_date" is on date 2019-11-29

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, burn_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, fy_end_date (date)

filed_date (date) ✖

  • 2019-11-29 · 35 ✖
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
22 22 STILLWATER BILLINGS CLINIC 710 N 11TH ST COLUMBUS MT 59019 STILLWATER (406) 322-5316 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6426860 -109.2431780 0   95 30 30095         https://data.medicare.gov/resource/xubh-q36u/row-feve.dr4z_em5n 271330 662542 2019-11-29 2019-06-30 10           10               10
83 83 KOHALA HOSPITAL 54-383 HOSPITAL ROAD KAPAAU HI 96755 HAWAII (808) 889-6211 Critical Access Hospitals Government - State TRUE 20.2317370 -155.7972530 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-zwx4_qya8~b57e 121302 662519 2019-11-29 2019-06-30 6           6       22       28
105 105 ATLANTICARE REGIONAL MEDICAL CENTER - CITY CAMPUS 1925 PACIFIC AVENUE ATLANTIC CITY NJ 8401 ATLANTIC (609) 441-8020 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3577910 -74.4339420 0   1 34 34001 12100 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Atlantic County https://data.medicare.gov/resource/xubh-q36u/row-bp79~7q24_hctk 310064 661933 2019-11-29 2019-06-30 470 38 10       540               540
160 160 THE QUEENS MEDICAL CENTER 1301 PUNCHBOWL ST HONOLULU HI 96813 HONOLULU (808) 538-9011 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3083070 -157.8549650 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-miez-e8mq~vhab 120001 662517 2019-11-29 2019-06-30 592 58         650               650
192 192 UNIVERSITY MEDICAL CENTER 1800 W CHARLESTON BLVD LAS VEGAS NV 89102 CLARK (702) 383-2000 Acute Care Hospitals Government - Local TRUE 36.1589410 -115.1659450 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-crh9_6nqs_53ud 290007 662546 2019-11-29 2019-06-30 358 20 24 16 16 14 498               498
253 253 SOUTH BIG HORN COUNTY CRITICAL ACCESS HOSPITAL 388 US HIGHWAY 20 SOUTH BASIN WY 82410 BIG HORN (307) 568-1500 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4344490 -108.0490070 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-vp99_bama.8nds 531301 661691 2019-11-29 2019-06-30 10           10       37       47
318 318 HURON REGIONAL MEDICAL CENTER 172 FOURTH STREET SE HURON SD 57350 BEADLE (605) 353-6200 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3620350 -98.2107510 0   5 46 46005 26700   Central Beadle County https://data.medicare.gov/resource/xubh-q36u/row-zcx3~7b4g-9rji 431335 662256 2019-11-29 2019-06-30 19 6         25               25
531 531 ST JOSEPH MEDICAL CENTER 2500 BERNVILLE ROAD READING PA 19605 BERKS (610) 378-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.3767170 -75.9776610 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-6esh~ksbq.jpve 390096 661397 2019-11-29 2019-06-30 144 30       6 180               180
695 695 BATTLE MOUNTAIN GENERAL HOSPITAL 535 SOUTH HUMBOLDT STREET BATTE MTN NV 89820 LANDER (775) 635-2550 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6406520 -116.9388210 0   15 32 32015         https://data.medicare.gov/resource/xubh-q36u/row-w9hj-b8v2_4i43 291303 662549 2019-11-29 2019-06-30 5           5       25       30
735 735 WAVERLY HEALTH CENTER 312 9TH STREET SW WAVERLY IA 50677 BREMER (319) 352-4120 Critical Access Hospitals Government - Local TRUE 42.7236680 -92.4818020 0   17 19 19017 47940   Outlying Bremer County https://data.medicare.gov/resource/xubh-q36u/row-cy2n.fbzb~m6ce 161339 661181 2019-11-29 2019-06-30 21           21               21
893 893 ST VINCENT CLAY HOSPITAL INC 1206 E NATIONAL AVE BRAZIL IN 47834 CLAY (812) 442-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5269350 -87.1113180 0   21 18 18021 45460   Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-rnay_y3j3.e852 151309 661168 2019-11-29 2019-06-30 25           25               25
946 946 JEROLD PHELPS COMMUNITY HOSPITAL 733 CEDAR ST GARBERVILLE CA 95542 HUMBOLDT (707) 923-3921 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1014910 -123.7927560 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-xasy~ndp2-8fte 51309 662173 2019-11-29 2019-06-30 9           9       8       17
1085 1085 ASCENSION BORGESS LEE HOSPITAL 420 W HIGH ST DOWAGIAC MI 49047 CASS (269) 782-8681 Critical Access Hospitals Voluntary non-profit - Church TRUE 41.9826650 -86.1154990 0   27 26 26027 43780 South Bend-Elkhart-Mishawaka, IN-MI Central Cass County https://data.medicare.gov/resource/xubh-q36u/row-vqdi~vtd4.ymdx 231315 661020 2019-11-29 2019-06-30 25           25               25
1452 1452 GARFIELD MEDICAL CENTER 525 N GARFIELD AVE MONTEREY PARK CA 91754 LOS ANGELES (626) 573-2222 Acute Care Hospitals Proprietary TRUE 34.0678640 -118.1229060 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-bqur_3wtu-xznx 50737 661290 2019-11-29 2019-06-30 140 10 8     20 182   28           210
1470 1470 MONTEREY PARK HOSPITAL 900 S ATLANTIC BLVD MONTEREY PARK CA 91754 LOS ANGELES (626) 570-9000 Acute Care Hospitals Proprietary FALSE 34.0497690 -118.1387510 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-npsi-724a~gdgs 50736 662482 2019-11-29 2019-06-30 97 4         101               101
1507 1507 GREATER EL MONTE COMMUNITY HOSPITAL 1701 SANTA ANITA AVE SOUTH EL MONTE CA 91733 LOS ANGELES (626) 350-7975 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.0487050 -118.0424520 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-titm_q5t2~8q6i 50738 662483 2019-11-29 2019-06-30 94 10         104       13       117
1703 1703 SEILING MUNICIPAL HOSPITAL 809 NE HIGHWAY 60 SEILING OK 73663 DEWEY (580) 922-7361 Critical Access Hospitals Government - Local TRUE 36.1574590 -98.9207150 0   43 40 40043         https://data.medicare.gov/resource/xubh-q36u/row-79bz~vfcy-sppu 371332 660432 2019-11-29 2019-06-30 18           18               18
1934 1934 BURLESON ST JOSEPH HEALTH CENTER 1101 WOODSON DRIVE CALDWELL TX 77836 BURLESON (979) 567-3245 Critical Access Hospitals Voluntary non-profit - Church FALSE 30.5203070 -96.7177140 0   51 48 48051 17780   Outlying Burleson County https://data.medicare.gov/resource/xubh-q36u/row-gq4y-tvhz_2h55 451305 660890 2019-11-29 2019-06-30 15           15               15
2272 2272 MORRISTOWN HAMBLEN HOSPITAL ASSOCIATION 908 W 4TH NORTH ST MORRISTOWN TN 37814 HAMBLEN (423) 586-4231 Acute Care Hospitals Government - Local TRUE 36.2119480 -83.3043450 0   63 47 47063 34100 Knoxville-Morristown-Sevierville, TN Central Hamblen County https://data.medicare.gov/resource/xubh-q36u/row-rd4n-mfc6-zag8 440030 660040 2019-11-29 2019-06-30 96 20         116 12             128
2399 2399 FRANKLIN GENERAL HOSPITAL 1720 CENTRAL AVENUE EAST HAMPTON IA 50441 FRANKLIN (641) 456-5000 Critical Access Hospitals Government - Local TRUE 42.7414070 -93.1867630 0   69 19 19069         https://data.medicare.gov/resource/xubh-q36u/row-acr5.brk4.hide 161308 661178 2019-11-29 2019-06-30 25           25         52     77
2697 2697 HANCOCK COUNTY HEALTH SYSTEM 532 1ST ST NW BRITT IA 50423 HANCOCK (641) 843-5000 Critical Access Hospitals Government - Local TRUE 43.0978180 -93.8069930 0   81 19 19081         https://data.medicare.gov/resource/xubh-q36u/row-i3sh.fr5p_6qsp 161307 661324 2019-11-29 2019-06-30 25           25               25
2705 2705 AVERA TYLER HOSPITAL 240 WILLOW STREET TYLER MN 56178 LINCOLN (507) 247-5521 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2722740 -96.1309430 0   81 27 27081         https://data.medicare.gov/resource/xubh-q36u/row-n4ct.diqe~2bh6 241348 661738 2019-11-29 2019-06-30 21           21       30       51
2752 2752 AVERA MARSHALL REGIONAL MEDICAL CTR 300 SOUTH BRUCE STREET MARSHALL MN 56258 LYON (507) 532-9661 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4476340 -95.7761850 0   83 27 27083 32140   Central Lyon County https://data.medicare.gov/resource/xubh-q36u/row-w278-8yip-75pa 241359 661739 2019-11-29 2019-06-30 25           25 10     76       111
2804 2804 MERCY HEALTH LOVE COUNTY 300 WANDA STREET MARIETTA OK 73448 LOVE (580) 276-3347 Critical Access Hospitals Government - Local TRUE 33.9424810 -97.1310800 0   85 40 40085         https://data.medicare.gov/resource/xubh-q36u/row-y7i7_sqdk~8zer 371306 660849 2019-11-29 2019-06-30 25           25               25
2881 2881 MAYERS MEMORIAL HOSPITAL 43563 HWY 299 EAST FALL RIVER MILLS CA 96028 SHASTA (530) 336-5511 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0239680 -121.4246510 0   89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-fpxd_qi9h_6mni 51305 662172 2019-11-29 2019-06-30 22           22       99       121
2974 2974 HOLY REDEEMER HOSPITAL AND MEDICAL CENTER 1648 HUNTINGDON PIKE MEADOWBROOK PA 19046 MONTGOMERY (215) 947-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.1089440 -75.0811010 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-xy3b_raa5.mzva 390097 660856 2019-11-29 2019-06-30 159 20       22 201 24     21   14   260
3097 3097 ST VINCENT HOSPITAL & HEALTH SERVICES 2001 W 86TH ST INDIANAPOLIS IN 46260 MARION (317) 338-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.9119960 -86.1960080 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-9jxm-5mhq.h9it 150084 661166 2019-11-29 2019-06-30 583 56         768 57             825
3301 3301 POINCIANA MEDICAL CENTER 325 CYPRESS PKWY KISSIMMEE FL 34758 OSCEOLA (407) 530-2000 Acute Care Hospitals Proprietary TRUE 28.1427230 -81.4729850 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-tjed.e78g~qkje 100320 660197 2019-11-29 2019-06-30 70 6         76               76
3369 3369 KOSSUTH REGIONAL HEALTH CENTER 1515 SOUTH PHILLIPS STREET ALGONA IA 50511 KOSSUTH (515) 295-2451 Critical Access Hospitals Government - Local TRUE 43.0568220 -94.2271240 0   109 19 19109         https://data.medicare.gov/resource/xubh-q36u/row-xb5y.qfar-cu3w 161353 660979 2019-11-29 2019-06-30 24           24           1   25
3772 3772 SAN JUAN MUNICIPAL HOSPITAL BARRIO MONACILLOS,CENTRO MEDICO RIO PIEDRAS PR 936 SAN JUAN (787) 756-8535 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.3960081 -66.0738624 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-k4tw_xde7_xhx9 400015 661646 2019-11-29 2019-06-30 144 30         174               174
3959 3959 OKLAHOMA STATE UNIVERSITY MEDICAL CENTER 744 WEST 9TH STREET TULSA OK 74127 TULSA (918) 599-1000 Acute Care Hospitals Government - State TRUE 36.1468360 -96.0001190 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-zrhv~9hmr~mtje 370078 660429 2019-11-29 2019-06-30 138 33         171               171
4155 4155 ST VINCENT EVANSVILLE 3700 WASHINGTON AVE EVANSVILLE IN 47750 VANDERBURGH (812) 485-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9624080 -87.5055400 0   163 18 18163 21780   Central Vanderburgh County https://data.medicare.gov/resource/xubh-q36u/row-aaru.g7q3~5zy8 150100 661167 2019-11-29 2019-06-30 292 60 8       400 14 24           438
4263 4263 ST VINCENT SALEM HOSPITAL INC 911 N SHELBY ST SALEM IN 47167 WASHINGTON (812) 883-5881 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.6131650 -86.1078020 0   175 18 18175 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Outlying Washington County https://data.medicare.gov/resource/xubh-q36u/row-xpep~ie7g_33t3 151314 661169 2019-11-29 2019-06-30 25           25               25
4331 4331 GRIMES ST JOSEPH HEALTH CENTER 210 JUDSON ST NAVASOTA TX 77868 GRIMES (936) 825-6585 Critical Access Hospitals Voluntary non-profit - Church TRUE 30.3928950 -96.0771680 0   185 48 48185         https://data.medicare.gov/resource/xubh-q36u/row-ng26_s56i-assy 451322 661419 2019-11-29 2019-06-30 18           18               18
4681 4681 UVALDE MEMORIAL HOSPITAL 1025 GARNER FIELD ROAD UVALDE TX 78801 UVALDE (830) 278-6251 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.2151260 -99.7686680 0   463 48 48463 46620   Central Uvalde County https://data.medicare.gov/resource/xubh-q36u/row-v3yf_upph.s38x 451387 660893 2019-11-29 2019-06-30 15 6         21               21

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