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

43 rows where "filed_date" is on date 2019-03-04

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, acute_beds, icu_beds, burn_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, all_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-03-04 · 43 ✖
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
63 63 STAMFORD HOSPITAL ONE HOSPITAL PLAZA STAMFORD CT 6904 FAIRFIELD (203) 276-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0544448 -73.5522909 1 ROOFTOP 1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-z4bk-5sz6.bqpu 70006 644101 2019-03-04 2018-09-30 252 36         288   17           305
179 179 HOULTON REGIONAL HOSPITAL 20 HARTFORD STREET HOULTON ME 4730 AROOSTOOK (207) 532-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1329620 -67.8426440 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-tx6y-y4iu-nd9t 201308 645561 2019-03-04 2018-09-30 25           25               25
309 309 ALLEGHANY COUNTY MEMORIAL HOSPITAL 617 DOCTORS STREET SPARTA NC 28675 ALLEGHANY (336) 372-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.5095115 -81.1150447 1 RANGE_INTERPOLATED 5 37 37005         https://data.medicare.gov/resource/xubh-q36u/row-zjv8.p46n-e733 341320 645140 2019-03-04 2018-09-30 25           25               25
317 317 ALLENDALE COUNTY HOSPITAL 1787 ALLENDALE FAIRFAX RD FAIRFAX SC 29827 ALLENDALE (803) 632-3311 Critical Access Hospitals Government - Local TRUE 32.9662250 -81.2477270 0   5 45 45005         https://data.medicare.gov/resource/xubh-q36u/row-bjdu~dq8g.u82d 421300 645444 2019-03-04 2018-09-30 25           25       44       69
481 481 BRADLEY COUNTY MEDICAL CENTER 404 SOUTH BRADLEY STREET WARREN AR 71671 BRADLEY (870) 226-3731 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6105380 -92.0586650 0   11 5 5011         https://data.medicare.gov/resource/xubh-q36u/row-ga7d-t3u8~gykp 41327 644212 2019-03-04 2018-09-30 25           25 10             35
513 513 COX BARTON COUNTY HOSPITAL 29 NW 1ST LANE LAMAR MO 64759 BARTON (417) 682-6081 Critical Access Hospitals Government - Local TRUE 37.5052820 -94.2994820 0   11 29 29011         https://data.medicare.gov/resource/xubh-q36u/row-8cv5-t4zj_7sig 261325 645577 2019-03-04 2018-09-30 21 4         25               25
865 865 NORTH COUNTRY HOSPITAL AND HEALTH CENTER 189 PROUTY DRIVE NEWPORT VT 5855 ORLEANS (802) 334-7331 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9546140 -72.2003390 0   19 50 50019         https://data.medicare.gov/resource/xubh-q36u/row-ipgf_5jyr.qb5v 471304 645803 2019-03-04 2018-09-30 20 5         25               25
889 889 MEDICAL CENTER, NAVICENT HEALTH (THE) 777 HEMLOCK STREET MACON GA 31201 BIBB (478) 633-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8332020 -83.6365530 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-qa2j~4dhx.y2zw 110107 645712 2019-03-04 2018-09-30 453 77       64 594 16             610
901 901 MAYO REGIONAL HOSPITAL 897 WEST MAIN STREET DOVER FOXCROFT ME 4426 PISCATAQUIS (207) 564-4251 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.1865560 -69.2377980 0   21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-zhbf-zz89~t9dz 201309 645562 2019-03-04 2018-09-30 25           25               25
1055 1055 SUMMIT MEDICAL CENTER 6350 E 2ND STREET CASPER WY 82609 NATRONA (307) 232-6600 Acute Care Hospitals Physician FALSE 42.8408460 -106.2317960 0   25 56 56025 16220   Central Natrona County https://data.medicare.gov/resource/xubh-q36u/row-8pwp.t3su_b96w 530034 645740 2019-03-04 2017-12-31                              
1232 1232 METHODIST HOSPITAL OF CHICAGO 5025 N PAULINA STREET CHICAGO IL 60640 COOK (773) 271-9040 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9732620 -87.6711410 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-iv7k_hinv.nxvu 140197 645542 2019-03-04 2018-09-30 136 9         145               145
1330 1330 WOMANS HOSPITAL 100 WOMAN'S WAY BATON ROUGE LA 70817 E. BATON ROUGE (225) 927-1300 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4088600 -91.0310200 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-n9vu.wxmz_qfwr 190128 644733 2019-03-04 2018-09-30 140 4       84 228               228
1405 1405 FRYE REGIONAL MEDICAL CENTER 420 N CENTER ST HICKORY NC 28601 CATAWBA (828) 322-6070 Acute Care Hospitals Proprietary TRUE 35.7371750 -81.3377780 0   35 37 37035 25860 Hickory-Lenoir, NC Central Catawba County https://data.medicare.gov/resource/xubh-q36u/row-h6s5_yv38.x5zx 340116 643928 2019-03-04 2018-09-30 196 24       6 226 100 29           355
1533 1533 GEORGE E WEEMS MEMORIAL HOSPITAL 135 AVE G APALACHICOLA FL 32320 FRANKLIN (850) 653-8853 Critical Access Hospitals Government - Local TRUE 29.7244840 -84.9912750 0   37 12 12037         https://data.medicare.gov/resource/xubh-q36u/row-z2w8_ts6n.p4qb 101305 644253 2019-03-04 2018-09-30 25           25               25
2238 2238 GREENE COUNTY HOSPITAL 509 WILSON AVENUE EUTAW AL 35462 GREENE (205) 372-3388 Acute Care Hospitals Government - Local TRUE 32.8447440 -87.8893070 0   63 1 1063         https://data.medicare.gov/resource/xubh-q36u/row-dyit.ypt9~f4e7 10051 645036 2019-03-04 2018-09-30 20           20       72       92
2255 2255 JEFFERSON COUNTY HOSPITAL 870 S MAIN FAYETTE MS 39069 JEFFERSON (601) 786-3401 Acute Care Hospitals Government - Local TRUE 31.7048425 -91.0685345 1 ROOFTOP 63 28 28063         https://data.medicare.gov/resource/xubh-q36u/row-6ixf.trx6_t5pg 250060 644298 2019-03-04 2018-09-30 12           12 18             30
2536 2536 JOHNSON MEMORIAL HOSPITAL 1282 WALNUT STREET DAWSON MN 56232 LAC QUI PARLE (320) 769-4323 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.9309710 -96.0670630 0   73 27 27073         https://data.medicare.gov/resource/xubh-q36u/row-aiqt_9tq3~e2sg 241314 643711 2019-03-04 2018-09-30 20           20       56       76
2569 2569 IROQUOIS MEMORIAL HOSPITAL 200 FAIRMAN STREET WATSEKA IL 60970 IROQUOIS (815) 432-5201 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7655410 -87.7326660 0   75 17 17075         https://data.medicare.gov/resource/xubh-q36u/row-2e44.299n~22z8 140167 645541 2019-03-04 2018-09-30 25           25       35   1   61
2767 2767 CASCADE MEDICAL CENTER 402 LAKE CASCADE PARKWAY CASCADE ID 83611 VALLEY (208) 382-4242 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5179210 -116.0489380 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-8r6g.s3au-3yid 131308 644833 2019-03-04 2018-09-30 8           8               8
2787 2787 MIDWEST MEDICAL CENTER 1 MEDICAL CENTER DRIVE GALENA IL 61036 JO DAVIESS (815) 777-1340 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4466220 -90.4569720 0   85 17 17085         https://data.medicare.gov/resource/xubh-q36u/row-gqwe-keau_be9a 141302 645763 2019-03-04 2018-09-30 25           25       5   52   82
2925 2925 WILLIAMSBURG REGIONAL HOSPITAL 500 NELSON BOULEVARD KINGSTREE SC 29556 WILLIAMSBURG (843) 355-8888 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6606660 -79.8202390 0   89 45 45089         https://data.medicare.gov/resource/xubh-q36u/row-7x78.i9ew-8k26 421303 645445 2019-03-04 2018-09-30 21 4         25               25
2935 2935 BRYAN W. WHITFIELD MEMORIAL HOSPITAL 105 HIGHWAY 80 EAST DEMOPOLIS AL 36732 MARENGO (334) 289-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.5036760 -87.8367440 0   91 1 1091         https://data.medicare.gov/resource/xubh-q36u/row-eqeg.jsdy-rvpp 10112 645707 2019-03-04 2018-09-30 32 5         37 20             57
3043 3043 MILLE LACS HEALTH SYSTEM 200 NORTH ELM STREET ONAMIA MN 56359 MILLE LACS (320) 532-3154 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0724670 -93.6618230 0   95 27 27095 33460 Minneapolis-St. Paul, MN-WI Outlying Mille Lacs County https://data.medicare.gov/resource/xubh-q36u/row-akw3_c4ae~5vtw 241356 645771 2019-03-04 2018-09-30 28           28 10     57       95
3068 3068 CONCHO COUNTY HOSPITAL 614 EAKER STREET EDEN TX 76837 CONCHO (915) 869-5911 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2208850 -99.8478320 0   95 48 48095         https://data.medicare.gov/resource/xubh-q36u/row-gyb7_xqfh_6ezj 451325 643976 2019-03-04 2018-09-30 16           16               16
3108 3108 HARRISON MEMORIAL HOSPITAL 1210 KY HWY 36 E CYNTHIANA KY 41031 HARRISON (859) 234-2300 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.3848220 -84.2767970 0   97 21 21097         https://data.medicare.gov/resource/xubh-q36u/row-6253.q85p_2jd3 180079 644489 2019-03-04 2018-09-30 55 6         61               61
3145 3145 LAKESIDE MEDICAL CENTER 39200 HOOKER HWY BELLE GLADE FL 33430 PALM BEACH (561) 996-6571 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.7256840 -80.6700790 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-vcv9~uwnp_a6fi 100130 644242 2019-03-04 2018-09-30 48 6         54               54
3452 3452 REEDSBURG AREA MEDICAL CENTER 2000 N DEWEY AVE REEDSBURG WI 53959 SAUK (608) 524-6487 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5492870 -89.9945480 0   111 55 55111 12660 Madison-Janesville-Beloit, WI Central Sauk County https://data.medicare.gov/resource/xubh-q36u/row-ffr4.2rxx_5fnq 521351 645872 2019-03-04 2018-09-30 21 4         25               25
3485 3485 PAWHUSKA HOSPITAL, INC 1101 EAST 15TH STREET PAWHUSKA OK 74056 OSAGE (918) 287-3232 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.6728510 -96.3257580 0   113 40 40113 46140 Tulsa-Muskogee-Bartlesville, OK Central Osage County https://data.medicare.gov/resource/xubh-q36u/row-hgmu~bcvs-2zwc 371309 644172 2019-03-04 2018-09-30 25           25               25
3529 3529 HILLSBORO COMMUNITY HOSPITAL 101 INDUSTRIAL ROAD HILLSBORO KS 67063 MARION (620) 947-3114 Critical Access Hospitals Proprietary FALSE 38.3614950 -97.1875890 0   115 20 20115         https://data.medicare.gov/resource/xubh-q36u/row-ik5a_fj2t_xvzd 171357 645552 2019-03-04 2018-09-30 15           15               15
3723 3723 SHARKEY ISSAQUENA COMMUNITY HOSPITAL 47 SOUTH FOURTH ST ROLLING FORK MS 39159 SHARKEY (662) 873-4395 Acute Care Hospitals Government - Local TRUE 32.9053730 -90.8849890 0   125 28 28125         https://data.medicare.gov/resource/xubh-q36u/row-xv4d_iffv-iegn 250079 643907 2019-03-04 2018-09-30 19           19 10     54       83
3798 3798 J PAUL JONES HOSPITAL 317 MCWILLIAMS AVENUE CAMDEN AL 36726 WILCOX (334) 682-4131 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.9966110 -87.2994240 0   131 1 1131         https://data.medicare.gov/resource/xubh-q36u/row-xkym~x6ui_jjb9 10102 645039 2019-03-04 2018-09-30 21           21               21
3832 3832 NORTH SUNFLOWER MEDICAL CENTER CAH 840 NORTH OAK AVENUE RULEVILLE MS 38771 SUNFLOWER (662) 756-2711 Critical Access Hospitals Government - Local TRUE 33.7348390 -90.5468230 0   133 28 28133 26940 Cleveland-Indianola, MS Central Sunflower County https://data.medicare.gov/resource/xubh-q36u/row-aeyn_exnd~v4c3 251318 644041 2019-03-04 2018-09-30 25           25 10             35
4117 4117 JASPER MEMORIAL HOSPITAL 898 COLLEGE STREET MONTICELLO GA 31064 JASPER (706) 468-6411 Critical Access Hospitals Government - Local TRUE 33.3139820 -83.6868770 0   159 13 13159 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-7m3n_3mxm~mxsc 111303 645064 2019-03-04 2018-09-30 12           12       55       67
4143 4143 YALOBUSHA GENERAL HOSPITAL 630 SOUTH MAIN STREET WATER VALLEY MS 38965 YALOBUSHA (662) 473-1411 Acute Care Hospitals Government - Local FALSE 34.1307000 -89.6410130 0   161 28 28161         https://data.medicare.gov/resource/xubh-q36u/row-f4gk_jx8c-563i 250061 643906 2019-03-04 2018-09-30 26           26           122   148
4199 4199 MEMORIAL MEDICAL CENTER 701 N FIRST ST SPRINGFIELD IL 62702 SANGAMON (217) 788-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8087780 -89.6545860 0   167 17 17167 44100 Springfield-Jacksonville-Lincoln, IL Central Sangamon County https://data.medicare.gov/resource/xubh-q36u/row-pnue~2mxb_uc9u 140148 645540 2019-03-04 2018-09-30 352 38   10     400 36 30           466
4236 4236 NORTHERN HOSPITAL OF SURRY COUNTY 830 ROCKFORD ST MOUNT AIRY NC 27030 SURRY (336) 719-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.4884180 -80.6111810 0   171 37 37171 34340 Greensboro--Winston-Salem--High Point, NC Central Surry County https://data.medicare.gov/resource/xubh-q36u/row-t67h_ck7x_3fsi 340003 645130 2019-03-04 2018-09-30 90 10         100       33       133
4452 4452 MONROE COUNTY HOSPITAL 88 MARTIN LUTHER KING JR DRIVE FORSYTH GA 31029 MONROE (478) 994-2521 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.0319810 -83.9464940 0   207 13 13207 31420 Macon-Warner Robins, GA Outlying Monroe County https://data.medicare.gov/resource/xubh-q36u/row-8ub4_vxra.n6a3 111318 645067 2019-03-04 2018-09-30 25           25               25
4491 4491 MEDICAL CENTER OF PEACH COUNTY, NAVICENT HEALTH 1960 HIGHWAY 247 CONNECTOR BYRON GA 31008 PEACH (478) 654-2000 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.6065680 -83.7584490 0   225 13 13225 47580 Macon-Warner Robins, GA Outlying Peach County https://data.medicare.gov/resource/xubh-q36u/row-diiq-qiab_fezm 111310 645065 2019-03-04 2018-09-30 25           25               25
4505 4505 PUTNAM GENERAL HOSPITAL 101 LAKE OCONEE PARKWAY EATONTON GA 31024 PUTNAM (706) 485-2711 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.3355190 -83.3708440 0   237 13 13237         https://data.medicare.gov/resource/xubh-q36u/row-dznu-rxmb.4s2q 111313 645066 2019-03-04 2018-09-30 25           25               25
4549 4549 LIBERTY DAYTON REGIONAL MEDICAL CENTER 1353 N TRAVIS ST LIBERTY TX 77575 LIBERTY (936) 336-7316 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.0685150 -94.7978880 0   291 48 48291 26420 Houston-The Woodlands, TX Outlying Liberty County https://data.medicare.gov/resource/xubh-q36u/row-mqxs.73v9-quxd 451375 651358 2019-03-04 2018-09-30 25           25               25
4557 4557 BAYLOR SCOTT & WHITE MEDICAL CENTER - LLANO 200 W OLLIE LLANO TX 78643 LLANO (325) 247-5040 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.7433450 -98.6779960 0   299 48 48299         https://data.medicare.gov/resource/xubh-q36u/row-f5ig_zcze-hhqw 450219 657514 2019-03-04 2018-08-31 25           25               25
4615 4615 BALLINGER MEMORIAL HOSPITAL 608 AVENUE B BALLINGER TX 76821 RUNNELS (325) 365-2531 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7498220 -99.9623020 0   399 48 48399         https://data.medicare.gov/resource/xubh-q36u/row-nqcy_n2re.zwit 451310 643973 2019-03-04 2018-09-30 16           16               16
4680 4680 RANKIN HOSPITAL MEDICAL CLINIC 1611 SPUR 576 RANKIN TX 79778 UPTON (432) 693-2443 Critical Access Hospitals Government - Hospital District or Authority FALSE 31.2335480 -101.9361780 1 ROOFTOP 461 48 48461         https://data.medicare.gov/resource/xubh-q36u/row-k6d6.95dp.xxq5 451329 643977 2019-03-04 2018-09-30 15           15               15

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