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

31 rows where "fy_end_date" is on date 2019-02-28

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, zip_code, county_name, hospital_type, hospital_ownership, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_date, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, all_beds, filed_date (date)

fy_end_date (date) ✖

  • 2019-02-28 · 31 ✖
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
77 77 NORTH FLORIDA REGIONAL MEDICAL CENTER 6500 NEWBERRY RD GAINESVILLE FL 32605 ALACHUA (352) 333-4100 Acute Care Hospitals Proprietary TRUE 29.6596990 -82.4115970 0   1 12 12001 23540 Gainesville-Lake City, FL Central Alachua County https://data.medicare.gov/resource/xubh-q36u/row-cu2v_edeq-29tz 100204 652641 2019-08-01 2019-02-28 321   48     12 381 33             414
108 108 LOVELACE MEDICAL CENTER 601 DR MARTIN LUTHER KING JR AVE NE ALBUQUERQUE NM 87102 BERNALILLO (505) 727-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0856220 -106.6397650 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-kci4.56nf~rfu7 320009 652759 2019-07-29 2019-02-28 245 48         293               293
325 325 LEWISGALE HOSPITAL ALLEGHANY ONE ARH LANE - PO BOX 7 LOW MOOR VA 24457 ALLEGHANY (540) 862-6011 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7917929 -79.8809172 1 ROOFTOP 5 51 51005         https://data.medicare.gov/resource/xubh-q36u/row-fp3a~xuin-uu4c 490126 652979 2019-08-02 2019-02-28 85 10         95 15             110
653 653 JELLICO MEDICAL CENTER, INC 188 HOSPITAL LANE JELLICO TN 37762 CAMPBELL (423) 784-7252 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.5736190 -84.1272400 0   13 47 47013 28940 Knoxville-Morristown-Sevierville, TN Outlying Campbell County https://data.medicare.gov/resource/xubh-q36u/row-n2fu-p6zw_cd43 440180 654899 2019-09-24 2019-02-28 30 4         34               34
696 696 PORTSMOUTH REGIONAL HOSPITAL 333 BORTHWICK AVE PORTSMOUTH NH 3801 ROCKINGHAM (603) 436-5110 Acute Care Hospitals Proprietary TRUE 43.0640930 -70.7877740 0   15 33 33015 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Rockingham County https://data.medicare.gov/resource/xubh-q36u/row-mstp-mc9d-7mre 300029 652758 2019-08-01 2019-02-28 127 16         143 30             173
703 703 ST JOSEPH'S HOSPITAL 555 ST JOSEPH'S BLVD ELMIRA NY 14901 CHEMUNG (607) 733-6541 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0912140 -76.7974720 0   15 36 36015 21300 Elmira-Corning, NY Central Chemung County https://data.medicare.gov/resource/xubh-q36u/row-kyx8_fy6q.m2sb 330108 653056 2019-08-14 2019-02-28 20           20 25 20   111       176
996 996 CLAY COUNTY HOSPITAL 911 STACY BURK DRIVE FLORA IL 62839 CLAY (618) 662-2131 Critical Access Hospitals Government - Local TRUE 38.6809170 -88.4703370 0   25 17 17025         https://data.medicare.gov/resource/xubh-q36u/row-waac_79mj~znty 141351 653013 2019-08-02 2019-02-28 20           20               20
1178 1178 METHODIST STONE OAK HOSPITAL 1139 E SONTERRA BLVD, STE 535 SAN ANTONIO TX 78258 BEXAR (210) 638-2100 Acute Care Hospitals Proprietary TRUE 29.6144940 -98.4754590 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-32ag-t8fj-9ybq 670055 652855 2019-07-31 2019-02-28 175 28       24 227   15           242
1945 1945 OAK HILL HOSPITAL 11375 CORTEZ BLVD BROOKSVILLE FL 34613 HERNANDO (352) 596-6632 Acute Care Hospitals Voluntary non-profit - Other TRUE 28.5333050 -82.5344950 0   53 12 12053 45300   Outlying Hernando County https://data.medicare.gov/resource/xubh-q36u/row-rykp.dde9-42ms 100264 652644 2019-07-29 2019-02-28 256 24         280               280
2068 2068 WESTERN PLAINS MEDICAL COMPLEX 3001 AVENUE A DODGE CITY KS 67801 FORD (620) 225-8400 Acute Care Hospitals Proprietary TRUE 37.7854870 -100.0149750 0   57 20 20057 19980   Central Ford County https://data.medicare.gov/resource/xubh-q36u/row-w4ff.nykp.gqd4 170175 652748 2019-08-01 2019-02-28 50 10         60               60
2077 2077 DUNDY COUNTY HOSPITAL P O BOX 626, 1313 NORTH CHEYENNE ST BENKELMAN NE 69021 DUNDY (308) 423-2204 Critical Access Hospitals Government - Local TRUE 40.0565540 -101.5374470 1 ROOFTOP 57 31 31057         https://data.medicare.gov/resource/xubh-q36u/row-pych_p5gr-xzj5 281340 652885 2019-08-05 2019-02-28 14           14               14
2533 2533 GLENWOOD REGIONAL MEDICAL CENTER 503 MCMILLAN ROAD WEST MONROE LA 71291 OUACHITA (318) 329-4600 Acute Care Hospitals Proprietary TRUE 32.5134620 -92.1567610 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-p2i2~hyuu~bqfj 190160 652655 2019-07-31 2019-02-28 164 44       6 214 40 16   14       284
2748 2748 JACKSON PURCHASE MEDICAL CENTER 1099 MEDICAL CENTER CIRCLE MAYFIELD KY 42066 GRAVES (270) 251-4585 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.7574110 -88.6509810 0   83 21 21083 32460 Paducah-Mayfield, KY-IL Central Graves County https://data.medicare.gov/resource/xubh-q36u/row-scw3~i5jx_eivs 180116 652359 2019-07-31 2019-02-28 87 8         95 12             107
2788 2788 KOSCIUSKO COMMUNITY HOSPITAL 2101 E DUBOIS DR WARSAW IN 46580 KOSCIUSKO (574) 267-3200 Acute Care Hospitals Proprietary TRUE 41.2464300 -85.8283200 0   85 18 18085 47700   Central Kosciusko County https://data.medicare.gov/resource/xubh-q36u/row-ijct_r8b9~pygm 150133 654577 2019-09-13 2019-02-28 58 14         72               72
3199 3199 REGIONAL MEDICAL CENTER BAYONET POINT 14000 FIVAY RD HUDSON FL 34667 PASCO (727) 819-2929 Acute Care Hospitals Proprietary TRUE 28.3607430 -82.6901480 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-burc_j8eh.zcc8 100256 652643 2019-07-31 2019-02-28 230 20 40       290               290
3251 3251 LARGO MEDICAL CENTER 201 14TH ST SW LARGO FL 33770 PINELLAS (727) 588-5200 Acute Care Hospitals Proprietary TRUE 27.9149140 -82.8026710 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-p62b_5uvn.q827 100248 652642 2019-08-01 2019-02-28 220 22         262 71 30           363
3347 3347 PANOLA MEDICAL CENTER 303 MEDICAL CENTER DRIVE BATESVILLE MS 38606 PANOLA (662) 563-5611 Acute Care Hospitals Proprietary TRUE 34.3063190 -89.9164880 0   107 28 28107         https://data.medicare.gov/resource/xubh-q36u/row-3tn8.ifxk_3zyp 250128 652883 2019-08-05 2019-02-28 45           45 22             67
3843 3843 LIVINGSTON REGIONAL HOSPITAL 315 OAK ST BOX 550 LIVINGSTON TN 38570 OVERTON (931) 823-5611 Acute Care Hospitals Proprietary TRUE 36.3846950 -85.3280970 0   133 47 47133 18260   Outlying Overton County https://data.medicare.gov/resource/xubh-q36u/row-yei3~9qc6~cfrt 440187 652547 2019-08-01 2019-02-28 84 6         90 10 14           114
3918 3918 LOGAN MEMORIAL HOSPITAL 1625 NASHVILLE STREET RUSSELLVILLE KY 42276 LOGAN (270) 726-4011 Acute Care Hospitals Proprietary TRUE 36.8154370 -86.8825930 0   141 21 21141         https://data.medicare.gov/resource/xubh-q36u/row-kw6k-zetw_vziz 180066 652353 2019-08-01 2019-02-28 69 6         75               75
4217 4217 SARAH D CULBERTSON MEMORIAL HOSPITAL 238 SOUTH CONGRESS STREET RUSHVILLE IL 62681 SCHUYLER (217) 322-4321 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1179440 -90.5635870 0   169 17 17169         https://data.medicare.gov/resource/xubh-q36u/row-bfu9.4ehe.ppey 141333 652646 2019-07-26 2019-02-28 22           22               22
4232 4232 MONROE COUNTY MEDICAL CENTER 529 CAPP HARLAN ROAD TOMPKINSVILLE KY 42167 MONROE (270) 487-9231 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.6985060 -85.6771200 0   171 21 21171         https://data.medicare.gov/resource/xubh-q36u/row-ep5d-ygrp~vtff 180105 652357 2019-07-31 2019-02-28 49           49               49
4383 4383 WILSON MEDICAL CENTER 1705 S TARBORO ST WILSON NC 27893 WILSON (252) 399-8040 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7205240 -77.9440470 0   195 37 37195 48980 Rocky Mount-Wilson-Roanoke Rapids, NC Central Wilson County https://data.medicare.gov/resource/xubh-q36u/row-674m.zg3x~pbew 340126 652665 2019-08-02 2019-02-28 256 14         270 24             294
4407 4407 HARRIS HEALTH SYSTEM 2525 HOLLY HALL HOUSTON TX 77054 HARRIS (713) 566-6417 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.6854220 -95.3870940 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-727m.2zxf~gpiz 450289 652272 2019-07-31 2019-02-28 479 30 8     16 615 20 25   24       684
4437 4437 WOMANS HOSPITAL OF TEXAS,THE 7600 FANNIN HOUSTON TX 77054 HARRIS (713) 790-1234 Acute Care Hospitals Proprietary TRUE 29.6929770 -95.4010900 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-pvha_dpmv~q2t2 450674 652609 2019-07-31 2019-02-28 253 4         257               257
4458 4458 GEORGETOWN COMMUNITY HOSPITAL 1140 LEXINGTON ROAD GEORGETOWN KY 40324 SCOTT (502) 868-1100 Acute Care Hospitals Proprietary TRUE 38.1862230 -84.5624450 0   209 21 21209 30460 Lexington-Fayette--Richmond--Frankfort, KY Outlying Scott County https://data.medicare.gov/resource/xubh-q36u/row-spxj.g7x2.6ev5 180101 652355 2019-08-01 2019-02-28 69 6         75               75
4507 4507 BLUEGRASS COMMUNITY HOSPITAL 360 AMSDEN AVENUE VERSAILLES KY 40383 WOODFORD (859) 873-3111 Critical Access Hospitals Proprietary TRUE 38.0553430 -84.7234150 0   239 21 21239 30460 Lexington-Fayette--Richmond--Frankfort, KY Outlying Woodford County https://data.medicare.gov/resource/xubh-q36u/row-9aks-4jh9~zwp7 181308 652512 2019-08-01 2019-02-28 25           25               25
4538 4538 KNOX COUNTY HOSPITAL 701 SOUTHEAST 5TH STREET KNOX CITY TX 79529 KNOX (940) 657-3535 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.4141070 -99.8114510 0   275 48 48275         https://data.medicare.gov/resource/xubh-q36u/row-7yyt-3mtc_a7wb 450746 652728 2019-08-01 2019-02-28 28           28               28
4703 4703 ROUND ROCK MEDICAL CENTER 2400 ROUND ROCK AVE ROUND ROCK TX 78681 WILLIAMSON (512) 341-1000 Acute Care Hospitals Proprietary TRUE 30.5093360 -97.7123610 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-jpx8_mm4d-nyqm 450718 652275 2019-07-31 2019-02-28 127 18       12 157   12           169
4711 4711 HAMILTON HOSPITAL 901 WEST HAMILTON OLNEY TX 76374 YOUNG (940) 564-5521 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.3696690 -98.7646300 0   503 48 48503         https://data.medicare.gov/resource/xubh-q36u/row-2jrh~g63r.wnym 451354 652730 2019-07-31 2019-02-28 25           25               25
4736 4736 SOUTHERN VIRGINIA REGIONAL MEDICAL CENTER 727 NORTH MAIN STREET EMPORIA VA 23847 EMPORIA CITY (434) 348-4400 Acute Care Hospitals Proprietary TRUE 36.7015680 -77.5359850 0   595 51 51595         https://data.medicare.gov/resource/xubh-q36u/row-ggnv~rn79-ude3 490097 652769 2019-08-01 2019-02-28 63 7         70 10             80
4753 4753 SOUTHSIDE REGIONAL MEDICAL CENTER 200 MEDICAL PARK BOULEVARD PETERSBURG VA 23805 PETERSBURG CITY (804) 765-5000 Acute Care Hospitals Proprietary TRUE 37.1836540 -77.3614660 0   730 51 51730 40060   Central Petersburg city https://data.medicare.gov/resource/xubh-q36u/row-p9qg_3z5t_zrt3 490067 654869 2019-09-20 2019-02-28 272 28         300               300

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