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-02-26 sorted by geocode_accuracy

✎ 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, fy_end_date, acute_beds, icu_beds, coronary_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-02-26 · 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
261 261 SWEDISH MEDICAL CENTER 501 E HAMPDEN AVE ENGLEWOOD CO 80113 ARAPAHOE (303) 788-5000 Acute Care Hospitals Proprietary TRUE 39.6531360 -104.9817100 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-3yvr.y5p2.2bay 60034 643574 2019-02-26 2018-09-30 281 58       17 356   16           372
280 280 MID COAST HOSPITAL 123 MEDICAL CENTER DRIVE BRUNSWICK ME 4011 CUMBERLAND (207) 729-0181 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.9056610 -69.8920060 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-aikj.qgnk-5idc 200021 643898 2019-02-26 2018-09-30 81 11         92               92
286 286 SOUTHCOAST HOSPITAL GROUP, INC 363 HIGHLAND AVENUE FALL RIVER MA 2720 BRISTOL (508) 679-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7105220 -71.1464390 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-veij_kb96-ysvv 220074 643785 2019-02-26 2018-09-30 761 58       16 835   32           867
367 367 ANDROSCOGGIN VALLEY HOSPITAL 59 PAGE HILL ROAD BERLIN NH 3570 COOS (603) 752-2200 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4870990 -71.1565480 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-fdui.znjf.jm5w 301310 643921 2019-02-26 2018-09-30 25           25               25
748 748 LOWELL GENERAL HOSPITAL 295 VARNUM AVENUE LOWELL MA 1854 MIDDLESEX (978) 937-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6463070 -71.3413230 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-2fw8.fd6r.2ntv 220063 643784 2019-02-26 2018-09-30 367 40         407               407
759 759 MERCY HOSPITAL 4572 COUNTY ROAD 61 MOOSE LAKE MN 55767 CARLTON (218) 485-4481 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4425450 -92.7757250 0   17 27 27017 20260   Outlying Carlton County https://data.medicare.gov/resource/xubh-q36u/row-ank5~56fj_iw2s 241350 645270 2019-02-26 2018-09-30 23 2         25               25
791 791 BAPTIST MEMORIAL HOSPITAL - CARROLL COUNTY 631 RB WILSON DR HUNTINGDON TN 38344 CARROLL (731) 986-4461 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0230410 -88.4134920 0   17 47 47017         https://data.medicare.gov/resource/xubh-q36u/row-xcqt-svm2~s3iu 440016 644064 2019-02-26 2018-09-30 36   6       42 12             54
891 891 TAYLORVILLE MEMORIAL HOSPITAL 201 EAST PLEASANT STREET TAYLORVILLE IL 62568 CHRISTIAN (217) 824-3331 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5537530 -89.2937540 0   21 17 17021 45380 Springfield-Jacksonville-Lincoln, IL Central Christian County https://data.medicare.gov/resource/xubh-q36u/row-vfba-cp55.36er 141339 643765 2019-02-26 2018-09-30 25           25               25
1175 1175 TENNOVA HEALTHCARE-NEWPORT MEDICAL CENTER 435 2ND ST NEWPORT TN 37821 COCKE (423) 625-2200 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.9650670 -83.1816190 0   29 47 47029 35460 Knoxville-Morristown-Sevierville, TN Central Cocke County https://data.medicare.gov/resource/xubh-q36u/row-ipf5-nfbk.t6y4 440153 644182 2019-02-26 2018-09-30 27 5         32         56     88
1209 1209 BAPTIST MEDICAL CENTER - BEACHES 1350 13TH AVE S JACKSONVILLE BEACH FL 32250 DUVAL (904) 247-2900 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2745270 -81.3994690 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-y5qj_3rke_6hp2 100117 644239 2019-02-26 2018-09-30 135           135               135
1224 1224 NORWEGIAN-AMERICAN HOSPITAL 1044 N FRANCISCO AVE CHICAGO IL 60622 COOK (773) 292-8200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9004810 -87.6992880 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-imkw.vufm-9stx 140206 643884 2019-02-26 2018-09-30 161 12         173 12             185
1397 1397 NORTHERN ROCKIES MEDICAL CENTER 802 2ND ST SE CUT BANK MT 59427 GLACIER (406) 873-2251 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.6287800 -112.3263450 0   35 30 30035         https://data.medicare.gov/resource/xubh-q36u/row-mzwj.8j2h.fdnu 271337 643521 2019-02-26 2018-09-30 20           20               20
1838 1838 JACKSON PARISH HOSPITAL 165 BEECH SPRINGS ROAD JONESBORO LA 71251 JACKSON (318) 259-4435 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2523490 -92.7196360 0   49 22 22049         https://data.medicare.gov/resource/xubh-q36u/row-sfrf-yeiu_hcfg 191317 643894 2019-02-26 2018-09-30 25           25               25
2251 2251 MCLAREN THUMB REGION 1100 SOUTH VAN DYKE ROAD BAD AXE MI 48413 HURON (989) 269-9521 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.8022340 -83.0308150 0   63 26 26063         https://data.medicare.gov/resource/xubh-q36u/row-3sc9_deg3~u7uk 230118 644747 2019-02-26 2018-09-30 54 4         58               58
2345 2345 MINIDOKA MEMORIAL HOSPITAL 1224 8TH STREET RUPERT ID 83350 MINIDOKA (208) 436-0481 Critical Access Hospitals Government - Local TRUE 42.6196250 -113.6853620 0   67 16 16067 15420   Outlying Minidoka County https://data.medicare.gov/resource/xubh-q36u/row-m4t9~2798.xb46 131319 643405 2019-02-26 2018-09-30 16           16       46       62
2445 2445 REDLANDS COMMUNITY HOSPITAL 350 TERRACINA BLVD REDLANDS CA 92373 SAN BERNARDINO (909) 335-5500 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0384040 -117.2064140 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-wstf_qkrp.vp7m 50272 644013 2019-02-26 2018-09-30 166 12         195 18     16       229
2469 2469 BAPTIST MEMORIAL HOSPITAL NORTH MS 1100 BELK BLVD OXFORD MS 38655 LAFAYETTE (662) 232-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.3466090 -89.5212000 0   71 28 28071 37060   Central Lafayette County https://data.medicare.gov/resource/xubh-q36u/row-ddrc~hvv6_ksn3 250034 644039 2019-02-26 2018-09-30 145 24         169   13           182
2637 2637 LAWRENCE MEDICAL CENTER 202 HOSPITAL STREET MOULTON AL 35650 LAWRENCE (256) 974-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4828840 -87.2860190 0   79 1 1079 19460 Huntsville-Decatur-Albertville, AL Outlying Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-vch8-q4mb_8uww 10059 644694 2019-02-26 2018-09-30 37 6         43               43
2885 2885 BAPTIST MEDICAL CENTER - NASSAU 1250 S 18TH ST FERNANDINA BEACH FL 32034 NASSAU (904) 321-3500 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.6530280 -81.4494620 0   89 12 12089 27260 Jacksonville-St. Marys-Palatka, FL-GA Outlying Nassau County https://data.medicare.gov/resource/xubh-q36u/row-v3si~mbmz-bg64 100140 643689 2019-02-26 2018-09-30 54           54               54
3158 3158 SEDAN CITY HOSPITAL 300 NORTH STREET SEDAN KS 67361 CHAUTAUQUA (620) 725-3115 Critical Access Hospitals Government - Local TRUE 37.1714400 -95.1030540 0   99 20 20099 37660   Central Labette County https://data.medicare.gov/resource/xubh-q36u/row-vdwb_dtrj-qnpi 171318 644727 2019-02-26 2018-09-30 17           17               17
3168 3168 NESHOBA COUNTY GENERAL HOSPITAL 1001 HOLLAND AVENUE PHILADELPHIA MS 39350 NESHOBA (601) 663-1200 Acute Care Hospitals Government - Local TRUE 32.7578160 -89.1054150 0   99 28 28099         https://data.medicare.gov/resource/xubh-q36u/row-k6bw.w463_gjg8 250043 643619 2019-02-26 2018-09-30 38           38 10     160       208
3508 3508 TEXAS SCOTTISH RITE HOSPITAL FOR CHILDREN 2222 WELBORN STREET DALLAS TX 75219 DALLAS (214) 559-5000 Childrens Voluntary non-profit - Private FALSE 32.8032510 -96.8133570 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-ks6w_wivi.sen3 453314 645801 2019-02-26 2018-09-30                              
3562 3562 BAPTIST MEMORIAL HOSPITAL BOONEVILLE 100 HOSPITAL DRIVE BOONEVILLE MS 38829 PRENTISS (662) 720-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.6563370 -88.5657630 0   117 28 28117         https://data.medicare.gov/resource/xubh-q36u/row-yxvp-p3fk_sfj3 250044 644040 2019-02-26 2018-09-30 28   11       39 15             54
3687 3687 MADISON MEDICAL CENTER 611 W MAIN ST FREDERICKTOWN MO 63645 MADISON (573) 781-3341 Critical Access Hospitals Voluntary non-profit - Other TRUE 37.5598460 -90.3024080 0   123 29 29123         https://data.medicare.gov/resource/xubh-q36u/row-gy2q-fidk.9r9u 261302 644759 2019-02-26 2018-09-30 25           25       6   113   144
3820 3820 BAPTIST MEMORIAL HOSPITAL UNION CITY 1201 BISHOP ST, PO BOX 310 UNION CITY TN 38261 OBION (731) 885-2410 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.4144230 -89.0390370 0   131 47 47131 46460 Martin-Union City, TN-KY Central Obion County https://data.medicare.gov/resource/xubh-q36u/row-nim3~wnvr~z29r 440130 644181 2019-02-26 2018-09-30 56   7       63               63
3991 3991 WAGONER COMMUNITY HOSPITAL 1200 WEST CHEROKEE STREET WAGONER OK 74467 WAGONER (918) 485-5514 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.9599110 -95.3923770 0   145 40 40145 46140 Tulsa-Muskogee-Bartlesville, OK Central Wagoner County https://data.medicare.gov/resource/xubh-q36u/row-c9ha_a4zk-cz5h 370166 644772 2019-02-26 2018-09-30 94 6         100               100
4044 4044 RANDOLPH HOSPITAL 364 WHITE OAK STREET ASHEBORO NC 27204 RANDOLPH (336) 625-5151 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7119580 -79.8148250 0   151 37 37151 24660 Greensboro--Winston-Salem--High Point, NC Outlying Randolph County https://data.medicare.gov/resource/xubh-q36u/row-ixf6-gq86-pf9f 340123 643429 2019-02-26 2018-09-30 133 12         145               145
4216 4216 RUSSELL COUNTY HOSPITAL 58 CARROLL STREET LEBANON VA 24266 RUSSELL (276) 883-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8990270 -82.0781050 0   167 51 51167         https://data.medicare.gov/resource/xubh-q36u/row-frbu~5ain_ahc2 490002 644793 2019-02-26 2018-09-30 44 5         49 20             69
4221 4221 SALINA REGIONAL HEALTH CENTER 400 SOUTH SANTA FE AVENUE SALINA KS 67401 SALINE (785) 452-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8332710 -97.6105250 0   169 20 20169 41460   Central Saline County https://data.medicare.gov/resource/xubh-q36u/row-qcyy-3633.w2ek 170012 645082 2019-02-26 2018-09-30 143 18         175 15 13           203
4342 4342 GUADALUPE REGIONAL MEDICAL CENTER 1215 E COURT ST SEGUIN TX 78155 GUADALUPE (830) 379-2411 Acute Care Hospitals Voluntary non-profit - Other TRUE 29.5690430 -97.9483340 0   187 48 48187 41700   Central Guadalupe County https://data.medicare.gov/resource/xubh-q36u/row-gyz4_fre4.eqtq 450104 643647 2019-02-26 2018-09-30 108 9         117   22           139
4384 4384 HANSFORD COUNTY HOSPITAL 707 ROLAND ST SPEARMAN TX 79081 HANSFORD (806) 659-2535 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.1904750 -101.2001270 0   195 48 48195         https://data.medicare.gov/resource/xubh-q36u/row-4gxw_72vt-83ub 451344 643658 2019-02-26 2018-09-30 14           14           8   22
4463 4463 SULLIVAN COUNTY MEMORIAL HOSPITAL 630 WEST THIRD STREET MILAN MO 63556 SULLIVAN (660) 265-4212 Critical Access Hospitals Government - Local TRUE 40.2021740 -93.1311360 0   211 29 29211         https://data.medicare.gov/resource/xubh-q36u/row-puyt~jfux-w58a 261306 659511 2019-02-26 2018-10-31 17           17         9     26
4508 4508 JACKSON HEALTHCARE CENTER 1013 S WELLS EDNA TX 77957 JACKSON (361) 782-7800 Critical Access Hospitals Government - Hospital District or Authority TRUE 28.9693880 -96.6348390 0   239 48 48239         https://data.medicare.gov/resource/xubh-q36u/row-vk5d.74uh-ngkv 451363 644190 2019-02-26 2018-09-30 25           25               25
3056 3056 JEFFERSON COMMUNITY HEALTH & LIFE P O BOX 277, 2200 H ST FAIRBURY NE 68352 JEFFERSON (402) 729-3351 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1364252 -97.1816307 1 ROOFTOP 95 31 31095         https://data.medicare.gov/resource/xubh-q36u/row-uhie_h8g7.ayhp 281319 644763 2019-02-26 2018-09-30 17           17       40       57
3983 3983 BAPTIST MEMORIAL HOSPITAL UNION COUNTY 200 HWY 30 WEST NEW ALBANY MS 38652 UNION (662) 538-7631 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.4969900 -89.0279582 1 ROOFTOP 145 28 28145         https://data.medicare.gov/resource/xubh-q36u/row-f3mh-shgd-bs86 250006 644038 2019-02-26 2018-09-30 84 8         92               92

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