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

49 rows where "filed_date" is on date 2019-12-04

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, icu_beds, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-12-04 · 49 ✖
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
37 37 PRATTVILLE BAPTIST HOSPITAL 124 S MEMORIAL DR PRATTVILLE AL 36067 AUTAUGA (334) 361-4267 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4644230 -86.4509360 0   1 1 1001 33860   Central Autauga County https://data.medicare.gov/resource/xubh-q36u/row-62jx-izkm-znx2 10108 660906 2019-12-04 2019-06-30 49 6         55               55
341 341 MERCY HOSPITAL NORTHWEST ARKANSAS 2710 SOUTH RIFE MEDICAL LANE ROGERS AR 72758 BENTON (479) 338-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.3095620 -94.1847090 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-3g3b-cs9n_qbhj 40010 660742 2019-12-04 2019-06-30 174 24         206               206
490 490 PLANTATION GENERAL HOSPITAL 401 NW 42ND AVE PLANTATION FL 33317 BROWARD (954) 587-5010 Acute Care Hospitals Voluntary non-profit - Private TRUE 26.1264610 -80.2041700 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-k3qn_68yj.yfxn 100167 661481 2019-12-04 2018-08-31 477 61       37 589 56 15           660
498 498 HABERSHAM COUNTY MEDICAL CTR 541 HISTORIC HIGHWAY 441-NORTH DEMOREST GA 30535 HABERSHAM (706) 754-2161 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4058790 -83.4859890 0   11 13 13011         https://data.medicare.gov/resource/xubh-q36u/row-vwu4-xgbr~5v33 110041 660923 2019-12-04 2019-06-30 49 4         53       84       137
672 672 MERCY HOSPITAL BERRYVILLE 214 CARTER STREET BERRYVILLE AR 72616 CARROLL (870) 423-3355 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.3582250 -93.5519930 0   15 5 5015         https://data.medicare.gov/resource/xubh-q36u/row-dj6g_rn37~rqpp 41329 659917 2019-12-04 2019-06-30 25           25               25
841 841 DANIELS MEMORIAL HOSPITAL 105 5TH AVE E SCOBEY MT 59263 DANIELS (406) 487-2296 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7886240 -105.4185870 0   19 30 30019         https://data.medicare.gov/resource/xubh-q36u/row-xufw-inrb~p3dx 271342 662053 2019-12-04 2019-06-30 25           25               25
911 911 MOSAIC LIFE CARE AT ST JOSEPH 5325 FARAON STREET SAINT JOSEPH MO 64506 BUCHANAN (816) 271-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7702010 -94.7702470 0   21 29 29021 41140 Kansas City-Overland Park-Kansas City, MO-KS Central Buchanan County https://data.medicare.gov/resource/xubh-q36u/row-3zkc_waie.mgmy 260006 661920 2019-12-04 2019-06-30 331 21         352               352
985 985 GRANT MEMORIAL HOSPITAL 117 HOSPITAL DRIVE PETERSBURG WV 26847 GRANT (304) 257-1026 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.0018410 -79.1379850 0   23 54 54023         https://data.medicare.gov/resource/xubh-q36u/row-czyj.xar4_pg4s 511316 661126 2019-12-04 2019-06-30 22 3         25       20       45
990 990 GROVE HILL MEMORIAL HOSPITAL 295 JACKSON HWY S GROVE HILL AL 36451 CLARKE (251) 275-3191 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6942130 -87.7772310 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-qwpn-mu4j-e76s 10091 660905 2019-12-04 2019-06-30 21           21 9             30
1071 1071 ST ANTHONY REGIONAL HOSPITAL & NURSING HOME 311 SOUTH CLARK STREET CARROLL IA 51401 CARROLL (712) 792-3581 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0569820 -94.8679810 0   27 19 19027         https://data.medicare.gov/resource/xubh-q36u/row-mmxr_bdg2_23xf 160005 661893 2019-12-04 2019-06-30 43 6         49 14       79     142
1252 1252 WESTLAKE HOSPITAL 1225 LAKE ST MELROSE PARK IL 60160 COOK (708) 938-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.8917940 -87.8489630 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-627u.ykd7_33gx 140240 662200 2019-12-04 2019-01-27 109 12         121 17 20           158
1323 1323 CALDWELL MEDICAL CENTER 100 MEDICAL CENTER DRIVE PRINCETON KY 42445 CALDWELL (270) 365-0300 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.1142150 -87.9076580 0   33 21 21033         https://data.medicare.gov/resource/xubh-q36u/row-8ivi_hkzn.i9ke 181322 661513 2019-12-04 2019-06-30 25           25               25
1342 1342 CARROLL COUNTY MEMORIAL HOSPITAL 1502 NORTH JEFFERSON CARROLLTON MO 64633 CARROLL (660) 542-1695 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3761610 -93.4942180 0   33 29 29033         https://data.medicare.gov/resource/xubh-q36u/row-jxaf~kp9t_wqyd 261332 661925 2019-12-04 2019-06-30 21           21               21
1428 1428 LOCK HAVEN HOSPITAL 24 CREE DRIVE LOCK HAVEN PA 17745 CLINTON (570) 893-5024 Acute Care Hospitals Proprietary TRUE 41.1328120 -77.4701830 0   35 42 42035 30820 Williamsport-Lock Haven, PA Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-i2uu~n4az-hqsg 390071 662135 2019-12-04 2019-06-30 47           47       90       137
1490 1490 CHILDREN'S HOSP OF LOS ANGELES 4650 SUNSET BLVD, MS 108 LOS ANGELES CA 90027 LOS ANGELES (323) 669-2164 Childrens Voluntary non-profit - Private TRUE 34.0981450 -118.2908780 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-unns_mtk9.tbkh 53302 660920 2019-12-04 2019-06-30 273 48         379               379
1630 1630 ST JOHNS MEDICAL CENTER 625 EAST BROADWAY JACKSON WY 83001 TETON (307) 733-3636 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.4796950 -110.7499860 0   39 56 56039 27220   Central Teton County https://data.medicare.gov/resource/xubh-q36u/row-vuqt_cw9d-cjux 530015 662632 2019-12-04 2019-06-30 42 6         48       60       108
1695 1695 MERCY ONE ELKADER MEDICAL CENTER 901 DAVIDSON STREET NW ELKADER IA 52043 CLAYTON (563) 245-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8597710 -91.4145360 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-tpbr_taqd~69cu 161319 661725 2019-12-04 2019-06-30 15           15               15
1755 1755 MERCY CATHOLIC MEDICAL CENTER- MERCY FITZGERALD 1500 LANSDOWNE AVE DARBY PA 19023 DELAWARE (215) 237-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9247180 -75.2670310 0   45 42 42045 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Delaware County https://data.medicare.gov/resource/xubh-q36u/row-xpnt-5xqj~h7ju 390156 660861 2019-12-04 2019-06-30 254 18         292 39 9           340
1773 1773 MERCY HOSPITAL TURNER MEMORIAL 801 WEST RIVER STREET OZARK AR 72949 FRANKLIN (479) 667-4138 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.4861180 -93.8338050 0   47 5 5047         https://data.medicare.gov/resource/xubh-q36u/row-ztbc-aceq_xeqj 41303 660745 2019-12-04 2019-06-30 25           25               25
2013 2013 MISSOURI BAPTIST SULLIVAN HOSPITAL 751 SAPPINGTON BRIDGE RD SULLIVAN MO 63080 FRANKLIN (573) 468-4186 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.1955740 -91.1692880 0   55 29 29055         https://data.medicare.gov/resource/xubh-q36u/row-tm3p_uhvr.kmvz 261337 662222 2019-12-04 2018-12-31 25           25 10             35
2579 2579 MOSAIC MEDICAL CENTER ALBANY 705 N COLLEGE STREET ALBANY MO 64402 GENTRY (660) 726-3941 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.2521240 -94.3254760 0   75 29 29075         https://data.medicare.gov/resource/xubh-q36u/row-67e7_s6bv.9rwi 261328 662128 2019-12-04 2019-06-30 25           25               25
2587 2587 POCAHONTAS MEMORIAL HOSPITAL 150 DUNCAN ROAD BUCKEYE WV 24924 POCAHONTAS (304) 799-7400 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.2014230 -80.1087010 0   75 54 54075         https://data.medicare.gov/resource/xubh-q36u/row-7guc_uvmn-5wb3 511314 661125 2019-12-04 2019-06-30 25           25               25
2611 2611 LAKEWOOD HEALTH CENTER 600 MAIN AVE S BAUDETTE MN 56623 LAKE OF WOODS (218) 634-2120 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.7074270 -94.6011720 0   77 27 27077         https://data.medicare.gov/resource/xubh-q36u/row-x2n8-qsfh.99ps 241301 661915 2019-12-04 2019-06-30 15           15       44       59
2722 2722 UPMC SUSQUEHANNA MUNCY 215 EAST WATER STREET MUNCY PA 17756 LYCOMING (570) 546-8282 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.2091260 -76.7752800 0   81 42 42081 48700 Williamsport-Lock Haven, PA Central Lycoming County https://data.medicare.gov/resource/xubh-q36u/row-jipe-jg5r.4523 391301 661642 2019-12-04 2019-06-30 20           20       138       158
2724 2724 WILLIAMSPORT REGIONAL MEDICAL CENTER 700 HIGH STREET WILLIAMSPORT PA 17701 LYCOMING (570) 321-2389 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.2454700 -77.0144320 0   81 42 42081 48700 Williamsport-Lock Haven, PA Central Lycoming County https://data.medicare.gov/resource/xubh-q36u/row-r8vh~rwtx.ueje 390045 660853 2019-12-04 2019-06-30 199 28         227   28           255
2733 2733 MERCY HOSPITAL BOONEVILLE 880 WEST MAIN BOONEVILLE AR 72927 LOGAN (479) 675-2800 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.1409790 -93.9347030 0   83 5 5083         https://data.medicare.gov/resource/xubh-q36u/row-jff3_g33y~pc8b 41318 662152 2019-12-04 2019-06-30 24           24               24
2734 2734 NORTH LOGAN MERCY HOSPITAL 500 EAST ACADEMY PARIS AR 72855 LOGAN (479) 963-6101 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.2899880 -93.7254190 0   83 5 5083         https://data.medicare.gov/resource/xubh-q36u/row-6tgs-f8yk-urcu 41300 660744 2019-12-04 2019-06-30 16           16               16
2780 2780 SANTA CLARA VALLEY MEDICAL CENTER 751 SOUTH BASCOM AVENUE SAN JOSE CA 95128 SANTA CLARA (408) 885-5000 Acute Care Hospitals Government - Local TRUE 37.3137020 -121.9318880 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-uh57.f27a-8g3n 50038 662012 2019-12-04 2019-06-30 728 35 12 8 8 47 852 48 50   24       974
3039 3039 COMPASS MEMORIAL HEALTHCARE 300 W MAY ST MARENGO IA 52301 IOWA (319) 642-5543 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.8017520 -92.0727990 0   95 19 19095         https://data.medicare.gov/resource/xubh-q36u/row-efjy~djys-nyx6 161317 661897 2019-12-04 2019-06-30 25           25               25
3123 3123 SUNBURY COMMUNITY HOSPITAL 350 NORTH 11TH STREET SUNBURY PA 17801 NORTHUMBERLND (570) 286-3333 Acute Care Hospitals Proprietary FALSE 40.8622430 -76.7782680 0   97 42 42097 44980 Bloomsburg-Berwick-Sunbury, PA Central Northumberland County https://data.medicare.gov/resource/xubh-q36u/row-w7iu-3na7~pqc2 390084 662136 2019-12-04 2019-06-30 63           63               63
3157 3157 SKIFF MEDICAL CENTER 204 N 4TH AVE E NEWTON IA 50208 JASPER (641) 792-1273 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7024130 -93.0511770 0   99 19 19099 35500 Des Moines-Ames-West Des Moines, IA Central Jasper County https://data.medicare.gov/resource/xubh-q36u/row-yd86~aswp_q926 160032 661895 2019-12-04 2019-06-30 44   4       48               48
3189 3189 BAPTIST MEDICAL CENTER SOUTH 2105 EAST SOUTH BOULEVARD MONTGOMERY AL 36116 MONTGOMERY (334) 288-2100 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3271440 -86.2767640 0   101 1 1101 33860   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-fvig.i38a~3f75 10023 660904 2019-12-04 2019-06-30 222 12 18   14 40 320 60             380
3190 3190 BAPTIST MEDICAL CENTER EAST 400 TAYLOR ROAD MONTGOMERY AL 36117 MONTGOMERY (334) 244-8330 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3768210 -86.1720950 0   101 1 1101 33860   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-r8t9_nce5~hpyh 10149 660907 2019-12-04 2019-06-30 170 12       25 207               207
3235 3235 NAZARETH HOSPITAL 2601 HOLME AVE PHILADELPHIA PA 19152 PHILADELPHIA (215) 335-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0585290 -75.0433870 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-5mkv.e58j_bxra 390204 661252 2019-12-04 2019-06-30 138 14         152   20   28       200
3262 3262 MERCY HOSPITAL 500 E MARKET STREET IOWA CITY IA 52245 JOHNSON (319) 339-0300 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.6635410 -91.5286530 0   103 19 19103 26980 Cedar Rapids-Iowa City, IA Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-h8wm-543c_t74e 160029 661894 2019-12-04 2019-06-30 200 18         218               218
3335 3335 KAWEAH DELTA MEDICAL CENTER 400 W MINERAL KING AVE VISALIA CA 93291 TULARE (559) 624-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.3274150 -119.2941720 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-2rh3~mb6h~sxp4 50057 662013 2019-12-04 2019-06-30 347 41       15 403 63 45   70       581
3490 3490 BAYLOR SCOTT AND WHITE MEDICAL CENTER SUNNYVALE 231 SOUTH COLLINS ROAD SUNNYVALE TX 75182 DALLAS (972) 892-3000 Acute Care Hospitals Proprietary TRUE 32.7783400 -96.5671780 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-xs7f_5svn~da2r 670060 661839 2019-12-04 2018-12-31 62 8         70               70
3568 3568 UPMC SUSQUEHANNA SOLDIERS & SAILORS 32-36 CENTRAL AVENUE WELLSBORO PA 16901 TIOGA (570) 724-1631 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.7451920 -77.2989970 0   117 42 42117         https://data.medicare.gov/resource/xubh-q36u/row-q3yy-urf8~vdh2 391316 660022 2019-12-04 2019-06-30 19 6         25               25
3601 3601 MERCY HOSPITAL WALDRON 1341 WEST SIXTH STREET WALDRON AR 72958 SCOTT (479) 637-4135 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.8967850 -94.1060780 0   127 5 5127         https://data.medicare.gov/resource/xubh-q36u/row-hh5p.qtqy-xetd 41305 662149 2019-12-04 2019-06-30 24           24               24
3701 3701 SALINE MEMORIAL HOSPITAL #1 MEDICAL PARK DRIVE BENTON AR 72015 SALINE (501) 776-6000 Acute Care Hospitals Proprietary TRUE 34.5735520 -92.5844050 0   125 5 5125 30780 Little Rock-North Little Rock, AR Central Saline County https://data.medicare.gov/resource/xubh-q36u/row-yg8k~yizr-mxhg 40084 660068 2019-12-04 2019-06-30 114 16         130 19 12       16   177
3720 3720 ASCENSION PROVIDENCE HOSPITAL 16001 W NINE MILE RD SOUTHFIELD MI 48075 OAKLAND (248) 849-3011 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.4591960 -83.2051630 0   125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-6smt_snvy_988f 230019 662125 2019-12-04 2019-06-30 459 34 34     15 542 25 16           583
3988 3988 PERSON MEMORIAL HOSPITAL 615 RIDGE RD ROXBORO NC 27573 PERSON (336) 599-2121 Acute Care Hospitals Proprietary TRUE 36.4075490 -78.9847630 0   145 37 37145 20500 Raleigh-Durham-Chapel Hill, NC Outlying Person County https://data.medicare.gov/resource/xubh-q36u/row-yre6~9jh6~c6uz 340159 661066 2019-12-04 2019-06-30 32 6         38       60       98
4003 4003 MOSAIC MEDICAL CENTER - MARYVILLE 2016 SOUTH MAIN ST MARYVILLE MO 64468 NODAWAY (660) 562-2600 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.3260530 -94.8740380 0   147 29 29147 32340   Central Nodaway County https://data.medicare.gov/resource/xubh-q36u/row-kehc_eqeq_s8gt 260050 661922 2019-12-04 2019-06-30 38           38 14             52
4037 4037 MARLETTE REGIONAL HOSPITAL 2770 MAIN STREET MARLETTE MI 48453 SANILAC (989) 635-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3325790 -83.0801600 0   151 26 26151         https://data.medicare.gov/resource/xubh-q36u/row-zwdj_2e6m-nqmv 231330 661912 2019-12-04 2019-06-30 25           25       39   6   70
4120 4120 RINGGOLD COUNTY HOSPITAL 504 NORTH CLEVELAND STREET MOUNT AYR IA 50854 RINGGOLD (641) 464-3226 Critical Access Hospitals Government - Local TRUE 40.7183300 -94.2236130 0   159 19 19159         https://data.medicare.gov/resource/xubh-q36u/row-wph7-7anh~da9v 161373 661898 2019-12-04 2019-06-30 16           16               16
4183 4183 FERRELL HOSPITAL COMMUNITY FOUNDATIONS 1201 PINE STREET ELDORADO IL 62930 SALINE (618) 273-3361 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.8153320 -88.4414510 0   165 17 17165         https://data.medicare.gov/resource/xubh-q36u/row-7gt3_vkhk~hsp3 141324 662524 2019-12-04 2019-03-31 25           25               25
4338 4338 PARKLAND HEALTH CENTER - BONNE TERRE 7245 RAIDER ROAD BONNE TERRE MO 63628 ST. FRANCOIS (573) 358-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9092860 -90.5252970 0   187 29 29187 22100 St. Louis-St. Charles-Farmington, MO-IL Central St. Francois County https://data.medicare.gov/resource/xubh-q36u/row-qfh6_b86g_9np8 261315 662397 2019-12-04 2018-12-31 3           3               3
4339 4339 PARKLAND HEALTH CENTER 1101 W LIBERTY FARMINGTON MO 63640 ST. FRANCOIS (573) 431-6005 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7806240 -90.4381950 0   187 29 29187 22100 St. Louis-St. Charles-Farmington, MO-IL Central St. Francois County https://data.medicare.gov/resource/xubh-q36u/row-m5zi.8uca_6c7z 260163 662396 2019-12-04 2018-12-31 82 10         92 16             108
4357 4357 MISSOURI BAPTIST MEDICAL CENTER 3015 N BALLAS RD TOWN AND COUNTRY MO 63131 ST. LOUIS (314) 996-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6355320 -90.4436360 0   189 29 29189 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-22pi-vzza~yq54 260108 661924 2019-12-04 2018-12-31 366 40         406   20           426

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