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

52 rows where acute_beds = 16 and hospital_type = "Critical Access Hospitals"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, icu_beds, subtotal_acute_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, all_beds, filed_date (date), fy_end_date (date)

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
9 9 NORTH SHORE HEALTH 515 5TH AVE WEST GRAND MARAIS MN 55604 COOK (218) 387-3040 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7567440 -90.3401790 0   31 27 27031         https://data.medicare.gov/resource/xubh-q36u/row-kcfv-qat3~9wit 241317 649272 2019-05-28 2018-12-31 16           16       37       53
16 16 AVERA WESKOTA MEMORIAL MEDICAL CENTER - CAH 604 1ST ST NE WESSINGTON SPRINGS SD 57382 JERAULD (605) 539-1201 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0803940 -98.5636820 0   73 46 46073         https://data.medicare.gov/resource/xubh-q36u/row-pcwb-j3y8~f5au 431324 662583 2019-11-27 2019-06-30 16           16               16
27 27 NEMAHA COUNTY HOSPITAL 2022 13TH ST AUBURN NE 68305 NEMAHA (402) 274-4366 Critical Access Hospitals Government - Local TRUE 40.3920330 -95.8530200 0   127 31 31127         https://data.medicare.gov/resource/xubh-q36u/row-jgty.gwke-kfnb 281324 654855 2019-09-24 2019-04-30 16           16               16
128 128 OTHELLO COMMUNITY HOSPITAL 315 NORTH 14TH AVENUE OTHELLO WA 99344 ADAMS (509) 488-2636 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.8303630 -119.1543630 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-5z56.vhnt-5g9t 501318 658624 2019-11-12 2018-12-31 16           16               16
292 292 FIELD HEALTH SYSTEM 178 HIGHWAY 24 CENTREVILLE MS 39631 WILKINSON (601) 890-0500 Critical Access Hospitals Government - Local TRUE 31.0820299 -91.0587631 1 ROOFTOP 5 28 28005 32620   Outlying Amite County https://data.medicare.gov/resource/xubh-q36u/row-d7tp~8xnm~uwen 251309 646102 2019-02-28 2018-09-30 16           16               16
293 293 COMMUNITY HOSPITAL ASSOCIATION 26136 US HIGHWAY 59, PO BOX 107 FAIRFAX MO 64446 ATCHISON (660) 686-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3482150 -95.3973230 0   5 29 29005         https://data.medicare.gov/resource/xubh-q36u/row-kkzi.c85k.9msb 261303 660249 2019-11-26 2019-06-30 16           16               16
368 368 UPPER CONNECTICUT VALLEY HOSPITAL 181 CORLISS LANE COLEBROOK NH 3576 COOS (603) 237-4971 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9044120 -71.4814890 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-5jxk.h2s8~zvc6 301300 644312 2019-02-27 2018-09-30 16           16               16
545 545 CROOK COUNTY HOSPITAL 713 OAK STREET SUNDANCE WY 82729 CROOK (307) 283-3501 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4088300 -104.3735960 0   11 56 56011         https://data.medicare.gov/resource/xubh-q36u/row-ikyx-7gnq-abzi 531311 640303 2018-12-04 2018-06-30 16           16       32       48
643 643 ST CHARLES PRINEVILLE 384 SE COMBS FLAT ROAD PRINEVILLE OR 97754 CROOK (541) 447-6254 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2980930 -120.8269680 0   13 41 41013 39260 Bend-Redmond-Prineville, OR Central Crook County https://data.medicare.gov/resource/xubh-q36u/row-yy7v_qhni~xpgc 381313 651052 2019-06-03 2018-12-31 16           16               16
691 691 SLEEPY EYE MUNICIPAL HOSPITAL 400 FOURTH AVENUE NORTHWEST SLEEPY EYE MN 56085 BROWN (507) 794-3571 Critical Access Hospitals Government - Local TRUE 44.2993190 -94.7273150 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-td5y_avnx_gs7p 241327 651011 2019-06-03 2018-12-31 16           16               16
709 709 CURRY GENERAL HOSPITAL 94220 FOURTH STREET GOLD BEACH OR 97444 CURRY (541) 247-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.4116590 -124.4186580 0   15 41 41015 15060   Central Curry County https://data.medicare.gov/resource/xubh-q36u/row-9rud.6rf5~it7z 381322 659603 2019-11-25 2019-06-30 16           16               16
734 734 COMMUNITY MEMORIAL HOSPITAL MEDICAL CENTER 909 WEST FIRST STREET SUMNER IA 50674 BREMER (563) 578-3275 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8474220 -92.1096910 0   17 19 19017 47940   Outlying Bremer County https://data.medicare.gov/resource/xubh-q36u/row-c7f9.r33q_65gq 161320 649106 2019-05-24 2018-12-31 16           16               16
854 854 LOWER UMPQUA HOSPITAL DISTRICT 600 RANCH ROAD REEDSPORT OR 97467 DOUGLAS (541) 271-2171 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6953240 -124.1355710 0   19 41 41019 40700   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-nysc.rhhn_bb99 381311 659602 2019-11-25 2019-06-30 16           16               16
913 913 MERCYONE OAKLAND MEDICAL CENTER 601 EAST SECOND ST OAKLAND NE 68045 BURT (402) 685-5601 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8345710 -96.4591970 0   21 31 31021         https://data.medicare.gov/resource/xubh-q36u/row-bi44_haku_5d9v 281321 660644 2019-11-27 2019-06-30 16           16               16
952 952 CHEYENNE COUNTY HOSPITAL 210 WEST 1ST STREET ST FRANCIS KS 67756 CHEYENNE (785) 332-2104 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.7710690 -101.8032590 0   23 20 20023         https://data.medicare.gov/resource/xubh-q36u/row-xmfg-epi6~swcr 171310 648914 2019-05-28 2018-12-31 16           16               16
992 992 O'CONNOR HOSPITAL 460 ANDES ROAD DELHI NY 13753 DELAWARE (607) 746-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.2668700 -74.9168500 0   25 36 36025         https://data.medicare.gov/resource/xubh-q36u/row-we9d-4xh5_rhbv 331305 650323 2019-05-31 2018-12-31 16           16               16
1126 1126 ADVENTIST HEALTH TEHACHAPI VALLEY 1100 MAGELLAN TEHACHAPI CA 93561 KERN (661) 823-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1474419 -118.4504364 1 ROOFTOP 29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-xx6n.a25c~74jx 51301 648598 2019-05-31 2018-12-31 16 4         20               20
1427 1427 BUCKTAIL MEDICAL CENTER 1001 PINE STREET RENOVO PA 17764 CLINTON (570) 923-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.3269380 -77.7374450 0   35 42 42035 30820 Williamsport-Lock Haven, PA Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-vesv-my7y~edhc 391304 660870 2019-11-27 2019-06-30 16           16       43       59
1649 1649 ST FRANCIS HOSPITAL 3401 LUDINGTON ST ESCANABA MI 49829 DELTA (906) 786-3311 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.7457600 -87.0948530 0   41 26 26041 21540   Central Delta County https://data.medicare.gov/resource/xubh-q36u/row-iqyh_xi8k_igyu 231337 645115 2019-02-28 2018-09-30 16 9         25               25
1777 1777 NORTH CANYON MEDICAL CENTER 267 NORTH CANYON DR GOODING ID 83330 GOODING (208) 934-4433 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.9218690 -114.7111280 0   47 16 16047         https://data.medicare.gov/resource/xubh-q36u/row-dagw~rfa6-2dqe 131302 642945 2019-02-06 2018-09-30 16           16               16
1828 1828 MODOC MEDICAL CENTER 228 W MCDOWELL AVE ALTURAS CA 96101 MODOC (530) 233-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.4799490 -120.5455030 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-kyq6~7b5b.wgww 51330 662175 2019-11-27 2019-06-30 16           16       71       87
1973 1973 COMMUNITY MEMORIAL HOSPITAL 809 JACKSON POST OFFICE BOX 319 BURKE SD 57523 GREGORY (605) 775-2621 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1817666 -99.2925606 1 ROOFTOP 53 46 46053         https://data.medicare.gov/resource/xubh-q36u/row-sb5r_k2dt_an8q 431309 646936 2019-04-25 2018-12-31 16           16               16
1995 1995 SPANISH PEAKS REGIONAL HEALTH CENTER 23500 US HWY 160 WALSENBURG CO 81089 HUERFANO (719) 738-5100 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6076880 -104.8197860 0   55 8 8055         https://data.medicare.gov/resource/xubh-q36u/row-d4uh.vzxr_8sf9 61316 650807 2019-06-04 2018-12-31 16           16         9 120   145
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
2574 2574 LAKE VIEW MEMORIAL HOSPITAL 325 ELEVENTH AVE TWO HARBORS MN 55616 LAKE (218) 834-7300 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.0296500 -91.6671570 0   75 27 27075         https://data.medicare.gov/resource/xubh-q36u/row-rhaa_cegt~vewc 241308 647902 2019-05-14 2018-12-31 16           16               16
2615 2615 DEER LODGE MEDICAL CENTER 1100 HOLLENBACK LN DEER LODGE MT 59722 POWELL (406) 846-2212 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4126340 -112.7263300 0   77 30 30077         https://data.medicare.gov/resource/xubh-q36u/row-4c8x-nuk8~9qhn 271314 656305 2019-11-04 2019-06-30 16           16               16
2725 2725 REGIONAL HEALTH LEAD-DEADWOOD HOSPITAL 61 CHARLES STREET DEADWOOD SD 57732 LAWRENCE (605) 717-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3700480 -103.7283480 0   81 46 46081 43940 Rapid City-Spearfish, SD Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-y22w.5f36-z9aq 431320 658589 2019-11-12 2019-06-30 16 2         18               18
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
2884 2884 ARKANSAS VALLEY REGIONAL MEDICAL CENTER 1100 CARSON AVENUE LA JUNTA CO 81050 OTERO (719) 383-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9769290 -103.5487420 0   89 8 8089         https://data.medicare.gov/resource/xubh-q36u/row-967u~ukgn_sq4q 61336 653832 2019-08-29 2019-03-31 16 506         522       30       552
2910 2910 CLARK FORK VALLEY HOSPITAL 10 KRUGER RD PLAINS MT 59859 SANDERS (406) 826-4800 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4695390 -114.8919080 0   89 30 30089         https://data.medicare.gov/resource/xubh-q36u/row-325u_sses_9br7 271323 649796 2019-05-24 2018-12-31 16           16       28       44
3003 3003 HOWARD COUNTY MEDICAL CENTER P O BOX 406, 1113 SHERMAN ST ST PAUL NE 68873 HOWARD (308) 754-4421 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.2145463 -98.4583381 1 ROOFTOP 93 31 31093 24260   Outlying Howard County https://data.medicare.gov/resource/xubh-q36u/row-dnv4.v747-tfbf 281338 655322 2019-10-18 2019-06-30 16           16               16
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
3120 3120 SANFORD MEDICAL CENTER HILLSBORO 12 THIRD STREET SE HILLSBORO ND 58045 TRAILL (701) 636-3200 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4034380 -97.0566450 0   97 38 38097         https://data.medicare.gov/resource/xubh-q36u/row-gj8t.p7hq.xvix 351329 647925 2019-05-16 2018-12-31 16           16       36       52
3679 3679 SPECTRUM HEALTH GERBER MEMORIAL 212 S SULLIVAN ST FREMONT MI 49412 NEWAYGO (231) 924-3300 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4643830 -85.9507630 0   123 26 26123         https://data.medicare.gov/resource/xubh-q36u/row-hx3e~pnt6_cpqb 231338 659581 2019-11-22 2019-06-30 16 9         25               25
3703 3703 WRAY COMMUNITY DISTRICT HOSPITAL 1017 WEST 7TH ST WRAY CO 80758 YUMA (970) 332-4811 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0754050 -102.2346600 0   125 8 8125         https://data.medicare.gov/resource/xubh-q36u/row-jpdk~yrgm-qq54 61309 649710 2019-06-03 2018-12-31 16           16               16
3785 3785 RENVILLE COUNTY HOSPITAL AND CLINICS 100 HEALTHY WAY OLIVIA MN 56277 RENVILLE (320) 523-1261 Critical Access Hospitals Government - Local TRUE 44.7747296 -94.9724885 1 ROOFTOP 129 27 27129         https://data.medicare.gov/resource/xubh-q36u/row-9bry_ub3h~y6xn 241306 652484 2019-07-29 2018-12-31 16           16           16   32
3874 3874 ESSENTIA HEALTH NORTHERN PINES MEDICAL CENTER 5211 HIGHWAY 110 AURORA MN 55705 ST. LOUIS (218) 229-4222 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.5172120 -92.2296870 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-shqb_564u.ru74 241340 661024 2019-11-27 2019-06-30 16           16       33       49
3876 3876 ELY BLOOMENSON COMMUNITY HOSPITAL 328 WEST CONAN STREET ELY MN 55731 ST. LOUIS (218) 365-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.9007010 -91.8719710 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-tia7_tsch.3esn 241318 645476 2019-03-01 2018-09-30 16           16               16
3949 3949 RIDGEVIEW SIBLEY MEDICAL CENTER 601 WEST CHANDLER ARLINGTON MN 55307 SIBLEY (507) 964-8415 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.6097820 -94.0846310 0   143 27 27143 33460 Minneapolis-St. Paul, MN-WI Outlying Sibley County https://data.medicare.gov/resource/xubh-q36u/row-udbf-4pka.q8zs 241311 651010 2019-06-03 2018-12-31 16           16               16
3950 3950 ANNIE JEFFREY MEMORIAL COUNTY HEALTH CENTER P O BOX 428, 531 BEEBE ST OSCEOLA NE 68651 POLK (402) 747-2031 Critical Access Hospitals Government - Local TRUE 41.1697878 -97.5490124 1 ROOFTOP 143 31 31143         https://data.medicare.gov/resource/xubh-q36u/row-tmyd~dpec-xnwq 281314 655636 2019-10-21 2019-06-30 16           16               16
3995 3995 KIRBY MEDICAL CENTER 1000 MEDICAL CENTER DRIVE MONTICELLO IL 61856 PIATT (217) 762-2115 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0601630 -88.5637700 0   147 17 17147 16580   Outlying Piatt County https://data.medicare.gov/resource/xubh-q36u/row-cyx9_rxkq~v7gg 141301 659780 2019-11-22 2019-06-30 16           16               16
4084 4084 SAUNDERS MEDICAL CENTER 1760 COUNTY RD J WAHOO NE 68066 SAUNDERS (402) 443-4191 Critical Access Hospitals Government - Local TRUE 41.1915550 -96.6353120 0   155 31 31155 36540 Omaha-Council Bluffs-Fremont, NE-IA Outlying Saunders County https://data.medicare.gov/resource/xubh-q36u/row-8cvc-ddhe-2jxx 281307 659512 2019-11-14 2019-06-30 16           16       60       76
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
4158 4158 ROOKS COUNTY HEALTH CENTER 1210 NORTH WASHINGTON PLAINVILLE KS 67663 ROOKS (785) 434-4553 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2479670 -99.2982030 0   163 20 20163         https://data.medicare.gov/resource/xubh-q36u/row-y4ci.d2n6.6wdh 171311 651275 2019-06-12 2018-12-31 16           16               16
4187 4187 RUSH COUNTY MEMORIAL HOSPITAL 801 LOCUST ST LA CROSSE KS 67548 RUSH (785) 222-2545 Critical Access Hospitals Government - Local FALSE 38.5305970 -99.3165720 0   165 20 20165         https://data.medicare.gov/resource/xubh-q36u/row-kzd7-vdnf-jix7 171342 650577 2019-06-04 2018-12-31 16           16               16
4230 4230 ST VINCENT WILLIAMSPORT HOSPITAL INC 412 N MONROE ST WILLIAMSPORT IN 47993 WARREN (765) 762-4000 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.2904700 -87.2958190 0   171 18 18171         https://data.medicare.gov/resource/xubh-q36u/row-hngk~n78p-82t8 151307 660948 2019-12-02 2019-06-30 16           16               16
4268 4268 VALLEY COUNTY HEALTH SYSTEM 2707 L STREET ORD NE 68862 VALLEY (308) 728-4200 Critical Access Hospitals Government - Local TRUE 41.6032130 -98.9426760 0   175 31 31175         https://data.medicare.gov/resource/xubh-q36u/row-y2qv_7x4q_v7xu 281353 661044 2019-12-02 2019-06-30 16           16               16
4308 4308 SMITH COUNTY MEMORIAL HOSPITAL 921 E. HIGHWAY 36 SMITH CENTER KS 66967 SMITH (785) 282-6845 Critical Access Hospitals Government - Local TRUE 39.7852490 -98.7727680 0   183 20 20183         https://data.medicare.gov/resource/xubh-q36u/row-2xcp~xm86-a2da 171377 654020 2019-08-29 2019-03-31 16           16               16
4337 4337 STANTON COUNTY HOSPITAL 404 N CHESTNUT JOHNSON KS 67855 STANTON (620) 492-6250 Critical Access Hospitals Government - Local TRUE 37.5741650 -101.7494100 0   187 20 20187         https://data.medicare.gov/resource/xubh-q36u/row-nbvv-b265_tdp8 171343 649594 2019-06-03 2018-12-31 16           16               16
4590 4590 MEMORIAL HOSPITAL 224 E SECOND STREET DUMAS TX 79029 MOORE (806) 935-7171 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.8642640 -101.9710060 0   341 48 48341 20300   Central Moore County https://data.medicare.gov/resource/xubh-q36u/row-35k5-7dip~y499 451386 659901 2019-11-25 2019-06-30 16 3         19               19
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
4693 4693 PARKVIEW HOSPITAL 901 S. SWEETWATER WHEELER TX 79096 WHEELER (806) 826-5581 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.4393630 -100.2708030 0   483 48 48483         https://data.medicare.gov/resource/xubh-q36u/row-nt4i-f4bk~gj2q 451334 655475 2019-10-22 2019-05-31 16           16               16

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