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

87 rows where geocode_accuracy = "ROOFTOP" and hospital_type = "Critical Access Hospitals"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_ownership, emergency_services, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, acute_beds, icu_beds, subtotal_acute_beds, subprovider_ipf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_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
39 39 SAGE MEMORIAL HOSPITAL STATE ROUTE 264 SOUTH 191 GANADO AZ 86505 APACHE (928) 755-4541 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7108602 -109.5423597 1 ROOFTOP 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-vmgp-erfi.puty 31309 652060 2019-05-06 2018-09-30 25           25               25
187 187 P H S INDIAN HOSPITAL CROW / NORTHERN CHEYENNE 1010 SOUTH 7650 EAST, POST OFFICE BOX 9 CROW AGENCY MT 59022 BIG HORN (406) 638-2626 Critical Access Hospitals Government - Federal TRUE 45.5821958 -107.4488586 1 ROOFTOP 3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-pgmt~4b42~eq7a 271339 646565 2019-03-26 2018-09-30 24           24               24
188 188 ANTELOPE MEMORIAL HOSPITAL P O BOX 229, 102 WEST 9TH ST NELIGH NE 68756 ANTELOPE (402) 887-4151 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1336539 -98.0299847 1 ROOFTOP 3 31 31003         https://data.medicare.gov/resource/xubh-q36u/row-uv86-cr3r-pfws 281326 661040 2019-12-02 2019-06-30 23           23               23
275 275 ATCHISON HOSPITAL 800 RAVIN HILL DRIVE ATCHISON KS 66002 ATCHISON (913) 360-5581 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5366253 -95.1282386 1 ROOFTOP 5 20 20005 11860 Kansas City-Overland Park-Kansas City, MO-KS Central Atchison County https://data.medicare.gov/resource/xubh-q36u/row-fwt4-3qfd~33ue 171382 645412 2019-03-01 2018-09-30 21 4         25               25
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
295 295 CARSON VALLEY MEDICAL CENTER 1107 HIGHWAY 395 GARDNERVILLE NV 89410 DOUGLAS (775) 782-1500 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9195628 -119.7189852 1 ROOFTOP 5 32 32005 23820 Reno-Carson City-Fernley, NV Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-zs3t-b2ik_qdz7 291306 650728 2019-05-31 2018-12-31 23           23               23
353 353 MERCYONE CENTERVILLE MEDICAL CENTER ONE ST JOSEPH'S DRIVE CENTERVILLE IA 52544 APPANOOSE (641) 437-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7555228 -92.8568047 1 ROOFTOP 7 19 19007         https://data.medicare.gov/resource/xubh-q36u/row-quyx-h8pq.iqb9 161377 660989 2019-12-02 2019-06-30 22 3         25           19   44
515 515 BOONE COUNTY HEALTH CENTER P O BOX 151, 723 WEST FAIRVIEW ST ALBION NE 68620 BOONE (402) 395-2191 Critical Access Hospitals Government - Local TRUE 41.6921113 -98.0002224 1 ROOFTOP 11 31 31011         https://data.medicare.gov/resource/xubh-q36u/row-3j5p_6aw6-77k2 281334 645125 2019-02-28 2018-09-30 25           25               25
622 622 BOX BUTTE GENERAL HOSPITAL P O BOX 810, 2101 BOX BUTTE AVE ALLIANCE NE 69301 BOX BUTTE (308) 762-6660 Critical Access Hospitals Government - Local TRUE 42.0984344 -102.8703880 1 ROOFTOP 13 31 31013         https://data.medicare.gov/resource/xubh-q36u/row-gsu6_furw.wta3 281360 661047 2019-12-02 2019-06-30 25           25               25
692 692 MISSOURI RIVER MEDICAL CENTER 1501 ST CHARLES ST FORT BENTON MT 59442 CHOUTEAU (406) 622-3331 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8203555 -110.6722100 1 ROOFTOP 15 30 30015         https://data.medicare.gov/resource/xubh-q36u/row-ibbr.ff9i-ncwz 271304 656304 2019-11-04 2019-06-30 25           25               25
694 694 NIOBRARA VALLEY HOSPITAL P O BOX 118, 401 SOUTH 5TH STREET LYNCH NE 68746 BOYD (402) 569-2451 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8245631 -98.4684820 1 ROOFTOP 15 31 31015         https://data.medicare.gov/resource/xubh-q36u/row-34qy.5xrg_j9e4 281303 658942 2018-11-19 2018-08-31 20           20               20
844 844 SOUTH LYON MEDICAL CENTER 213 S WHITACRE/PO BOX 940 YERINGTON NV 89447 LYON (775) 781-3761 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.9840873 -119.1669050 1 ROOFTOP 19 32 32019 22280 Reno-Carson City-Fernley, NV Central Lyon County https://data.medicare.gov/resource/xubh-q36u/row-ykja.hnhj~bmpe 291314 653342 2019-08-30 2019-03-31 14           14       49       63
940 940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
999 999 ASHLAND HEALTH CENTER 625 SOUTH KENTUCKY ASHLAND KS 67831 CLARK (620) 635-2241 Critical Access Hospitals Voluntary non-profit - Other TRUE 37.1902572 -99.7797746 1 ROOFTOP 25 20 20025         https://data.medicare.gov/resource/xubh-q36u/row-6n24_uu3q.wx9d 171304 655206 2019-10-10 2018-12-31 25           25               25
1044 1044 GRACE COTTAGE HOSPITAL PO BOX 216 TOWNSHEND VT 5353 WINDHAM (802) 365-7920 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0489148 -72.6682465 1 ROOFTOP 25 50 50025         https://data.medicare.gov/resource/xubh-q36u/row-u9ts~hp4k-kd62 471300 643746 2019-02-22 2018-09-30 19           19               19
1112 1112 SPRINGFIELD HOSPITAL PO BOX 2003 SPRINGFIELD VT 5156 WINDSOR (802) 885-2151 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2981414 -72.4948662 1 ROOFTOP 27 50 50027 17200   Central Windsor County https://data.medicare.gov/resource/xubh-q36u/row-zewq-djn4-pp8m 471306 643749 2019-02-25 2018-09-30 25           25 10             35
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
1139 1139 RIVERLAND MEDICAL CENTER 1700 WALLACE BLVD FERRIDAY LA 71334 CONCORDIA (318) 757-6551 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.6469583 -91.5548418 1 ROOFTOP 29 22 22029 35020   Central Concordia Parish https://data.medicare.gov/resource/xubh-q36u/row-v73w.iknw.vmzz 191318 644280 2019-03-01 2018-09-30 20 5         25               25
1142 1142 MUNSON HEALTHCARE CHARLEVOIX HOSPITAL 14700 LAKESHORE DRIVE CHARLEVOIX MI 49720 CHARLEVOIX (231) 547-4024 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.3144980 -85.2748510 1 ROOFTOP 29 26 26029         https://data.medicare.gov/resource/xubh-q36u/row-cdsd.f9cx_c7j8 231322 660601 2019-11-27 2019-06-30 25           25               25
1149 1149 CHASE COUNTY COMMUNITY HOSPITAL P O BOX 819, 600 W 12TH ST IMPERIAL NE 69033 CHASE (308) 882-7111 Critical Access Hospitals Government - Local TRUE 40.5163553 -101.6419049 1 ROOFTOP 29 31 31029         https://data.medicare.gov/resource/xubh-q36u/row-nwms~eext-vthe 281351 655132 2019-10-04 2019-06-30 20           20               20
1154 1154 MIMBRES MEMORIAL HOSPITAL 900 W ASH DEMING NM 88031 LUNA (575) 546-5803 Critical Access Hospitals Proprietary TRUE 32.2603723 -107.7678531 1 ROOFTOP 29 35 35029 19700   Central Luna County https://data.medicare.gov/resource/xubh-q36u/row-vtah.tqch.7v58 321309 653912 2019-08-27 2018-12-31 19 6         25               25
1281 1281 CHERRY COUNTY HOSPITAL P O BOX 410, 510 NORTH GREEN ST VALENTINE NE 69201 CHERRY (402) 376-2525 Critical Access Hospitals Government - Local TRUE 42.8790786 -100.5384010 1 ROOFTOP 31 31 31031         https://data.medicare.gov/resource/xubh-q36u/row-fpwc_rzae.e38t 281344 652757 2019-07-23 2019-03-31 25           25               25
1314 1314 ADVENTIST HEALTH CLEARLAKE 15630 18TH AVE - HWY 53 CLEARLAKE CA 95422 LAKE (707) 994-6486 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.9353458 -122.6200816 1 ROOFTOP 33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-hud3~fp2e-cmcb 51317 648600 2019-05-31 2018-12-31 21 4         25               25
1407 1407 NORTHWOOD DEACONESS HEALTH CENTER PO BOX 190 NORTHWOOD ND 58267 GRAND FORKS (701) 587-6060 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.7343845 -97.5683593 1 ROOFTOP 35 38 38035 24220   Central Grand Forks County https://data.medicare.gov/resource/xubh-q36u/row-r4gy_k4h8~nujf 351312 646643 2019-04-15 2018-12-31 12           12       45       57
1557 1557 DRUMRIGHT REGIONAL HOSPITAL 610 WEST BYPASS DRUMRIGHT OK 74030 CREEK (918) 382-2300 Critical Access Hospitals Proprietary TRUE 35.9981930 -96.6059788 1 ROOFTOP 37 40 40037 46140 Tulsa-Muskogee-Bartlesville, OK Central Creek County https://data.medicare.gov/resource/xubh-q36u/row-7yzz_kwx7_bt4n 371331 641664 2019-01-08 2018-09-30 15           15               15
1654 1654 CALLAWAY DISTRICT HOSPITAL P O BOX 100, 211 E KIMBALL CALLAWAY NE 68825 CUSTER (308) 836-2228 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.2909887 -99.9242095 1 ROOFTOP 41 31 31041         https://data.medicare.gov/resource/xubh-q36u/row-nfg8_ccxm-ja7t 281335 660412 2019-01-02 2018-07-31 12           12               12
1764 1764 BOWDLE HOSPITAL - CAH 8001 W 5TH POST OFFICE BOX 556 BOWDLE SD 57428 EDMUNDS (605) 285-6146 Critical Access Hospitals Government - Local TRUE 45.4480531 -99.6609364 1 ROOFTOP 45 46 46045 10100   Outlying Edmunds County https://data.medicare.gov/resource/xubh-q36u/row-q6h5.bajv_fkde 431318 637935 2018-11-26 2018-06-30 12           12       34       46
1795 1795 LEXINGTON REGIONAL HEALTH CENTER P O BOX 980, 1201 NORTH ERIE ST LEXINGTON NE 68850 DAWSON (308) 324-5651 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.7858157 -99.7587068 1 ROOFTOP 47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dbaj_tjsz.ntkv 281361 655216 2019-10-02 2019-06-30 25           25               25
1796 1796 COZAD COMMUNITY HOSPITAL P O BOX 108, 300 EAST 12TH ST COZAD NE 69130 DAWSON (308) 784-2261 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8608215 -99.9856389 1 ROOFTOP 47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-kmiy~67m8-urj8 281327 654099 2019-09-03 2019-04-30 20           20               20
1831 1831 ADVENTHEALTH WAUCHULA 735 S 5TH AVE WAUCHULA FL 33873 HARDEE (863) 773-0216 Critical Access Hospitals Voluntary non-profit - Private TRUE 27.5394213 -81.8072774 1 ROOFTOP 49 12 12049 48100   Central Hardee County https://data.medicare.gov/resource/xubh-q36u/row-ev8e.32dq-kwq8 101300 649888 2019-05-30 2018-12-31 25           25               25
1908 1908 PRAIRIE RIDGE HOSPITAL AND HEALTH SERVICES 1411 HIGHWAY 793 E ELBOW LAKE MN 56531 GRANT (218) 685-7300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9908032 -95.9578947 1 ROOFTOP 51 27 27051         https://data.medicare.gov/resource/xubh-q36u/row-is3f.7a5b~t9ju 241379 644131 2019-02-28 2018-09-30 10           10               10
1932 1932 MILBANK AREA HOSPITAL/AVERA HEALTH 301 FLYNN DRIVE MILBANK SD 57252 GRANT (605) 432-4538 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2219130 -96.6175485 1 ROOFTOP 51 46 46051         https://data.medicare.gov/resource/xubh-q36u/row-y6xc~czq6~y94b 431326 660034 2019-11-26 2019-06-30 25           25               25
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
1974 1974 AVERA GREGORY HOSPITAL 400 PARK STREET POST OFFICE BOX 408 GREGORY SD 57533 GREGORY (605) 835-8394 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2319878 -99.4304377 1 ROOFTOP 53 46 46053         https://data.medicare.gov/resource/xubh-q36u/row-sxnm~ansc_ejzf 431338 662257 2019-11-26 2019-06-30 25           25       55       80
2038 2038 HANS P PETERSON MEMORIAL HOSPITAL - CAH 503 W PINE POST OFFICE BOX 790 PHILIP SD 57567 HAAKON (605) 859-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0392471 -101.6628240 1 ROOFTOP 55 46 46055         https://data.medicare.gov/resource/xubh-q36u/row-5652-vpwn_wmme 431319 651668 2019-07-01 2018-12-31 18           18         30     48
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
2146 2146 FILLMORE COUNTY HOSPITAL P O BOX 193, 1900 F STREET GENEVA NE 68361 FILLMORE (402) 759-3167 Critical Access Hospitals Government - Local TRUE 40.5243546 -97.5877126 1 ROOFTOP 59 31 31059         https://data.medicare.gov/resource/xubh-q36u/row-h8d4~72pk-88se 281301 659702 2019-11-18 2019-06-30 20           20 10             30
2161 2161 ST ANTHONY HOSPITAL 2801 ST ANTHONY WAY PENDLETON OR 97801 UMATILLA (541) 276-5121 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.6482496 -118.8124252 1 ROOFTOP 59 41 41059 25840   Central Umatilla County https://data.medicare.gov/resource/xubh-q36u/row-hwf6-ji7m-72j9 381319 660288 2019-11-27 2019-06-30 20 5         25               25
2311 2311 SALEM MEMORIAL DISTRICT HOSPITAL PO BOX 774, SALEM MO 65560 DENT (573) 729-6626 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6604402 -91.5692851 1 ROOFTOP 65 29 29065         https://data.medicare.gov/resource/xubh-q36u/row-wiw4-tpja~sz74 261318 661354 2019-12-03 2019-06-30 25           25           18   43
2361 2361 BEATRICE COMMUNITY HOSPITAL & HEALTH CENTER, INC P O BOX 278, 4800 HOSPITAL PARKWAY BEATRICE NE 68310 GAGE (402) 228-3344 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3161806 -96.7495665 1 ROOFTOP 67 31 31067 13100 Lincoln-Beatrice, NE Central Gage County https://data.medicare.gov/resource/xubh-q36u/row-hnr5~xngx-6v22 281364 645126 2019-02-28 2018-09-30 22 3         25               25
2544 2544 MERCY HOSPITAL KINGFISHER, INC 1000 KINGFISHER HOSPITAL DRIVE KINGFISHER OK 73750 KINGFISHER (405) 375-3141 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.8100746 -97.9449387 1 ROOFTOP 73 40 40073         https://data.medicare.gov/resource/xubh-q36u/row-h8q6~j6ue-y5ca 371313 660141 2019-11-25 2019-06-30 25           25               25
2572 2572 HAMILTON COUNTY HOSPITAL 700 NORTH HUSER SYRACUSE KS 67878 HAMILTON (620) 384-7461 Critical Access Hospitals Government - Local TRUE 37.9846055 -101.7426286 1 ROOFTOP 75 20 20075         https://data.medicare.gov/resource/xubh-q36u/row-aubk-tw4u-vx2j 171322 649228 2019-05-31 2018-12-31 25           25               25
2730 2730 TOMAH MEMORIAL HOSPITAL 501 GOPHER DR TOMAH WI 54660 MONROE (608) 372-2181 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9585209 -90.5124608 1 ROOFTOP 81 55 55081         https://data.medicare.gov/resource/xubh-q36u/row-k2zz~hrus_4u53 521320 645871 2019-03-06 2018-09-30 25           25               25
2756 2756 HARLAN COUNTY HEALTH SYSTEM P O BOX 836, 717 NORTH BROWN ST ALMA NE 68920 HARLAN (308) 928-2151 Critical Access Hospitals Government - Local TRUE 40.0981797 -99.3631677 1 ROOFTOP 83 31 31083         https://data.medicare.gov/resource/xubh-q36u/row-yvs4.45jj.87ms 281300 647189 2019-04-23 2018-12-31 19           19               19
2760 2760 OUR COMMUNITY HOSPITAL 921 JUNIOR HIGH ROAD SCOTLAND NECK NC 27874 HALIFAX (252) 826-4144 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.1323341 -77.4291154 1 ROOFTOP 83 37 37083 40260 Rocky Mount-Wilson-Roanoke Rapids, NC Central Halifax County https://data.medicare.gov/resource/xubh-q36u/row-3t5i~i654~cm6e 341302 645787 2019-03-21 2018-09-30 20           20       60   20   100
2860 2860 MAHNOMEN HEALTH CENTER 414 W JEFFERSON PO BOX 396 MAHNOMEN MN 56557 MAHNOMEN (218) 935-2511 Critical Access Hospitals Government - Local TRUE 47.3117925 -95.9729278 1 ROOFTOP 87 27 27087         https://data.medicare.gov/resource/xubh-q36u/row-hmyn_2dwh_mr9t 241300 651009 2019-06-04 2018-12-31 10           10       32       42
2922 2922 MCCURTAIN MEMORIAL HOSPITAL 1301 LINCOLN ROAD IDABEL OK 74745 MCCURTAIN (580) 286-7623 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8827686 -94.8112299 1 ROOFTOP 89 40 40089         https://data.medicare.gov/resource/xubh-q36u/row-pgd6-5hq6_fe4r                                      
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
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
3058 3058 TOWNER COUNTY MEDICAL CENTER HWY 281 N CANDO ND 58324 TOWNER (701) 968-4411 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4931522 -99.2110430 1 ROOFTOP 95 38 38095         https://data.medicare.gov/resource/xubh-q36u/row-8pd6_eppf-kx3r 351331 638004 2018-11-28 2018-06-30 20           20       30   5   55
3202 3202 LANE COUNTY HOSPITAL 235 WEST VINE PO BOX 969 DIGHTON KS 67839 LANE (620) 397-5321 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.4805486 -100.4690751 1 ROOFTOP 101 20 20101         https://data.medicare.gov/resource/xubh-q36u/row-9e78_nak8_vx8n 171303 647616 2019-05-06 2018-12-31 25           25               25
3214 3214 AVERA CREIGHTON HOSPITAL P O BOX 186, 1503 MAIN ST CREIGHTON NE 68729 KNOX (402) 358-5700 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4664016 -97.9072475 1 ROOFTOP 107 31 31107         https://data.medicare.gov/resource/xubh-q36u/row-7tv3_vise~cn54 281331 660258 2019-11-25 2019-06-30 23           23       47       70
3217 3217 KENMARE COMMUNITY HOSPITAL PO BOX 697 KENMARE ND 58746 WARD (701) 385-4296 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.6742881 -102.0844703 1 ROOFTOP 101 38 38101 33500   Central Ward County https://data.medicare.gov/resource/xubh-q36u/row-tfzi_r3ee-4azt 351305 660271 2019-11-25 2019-06-30 25           25               25
3246 3246 PIONEERS MEDICAL CENTER 100 PIONEERS MEDICAL CENTER DR MEEKER CO 81641 RIO BLANCO (970) 878-5047 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0470026 -107.8822968 1 ROOFTOP 103 8 8103         https://data.medicare.gov/resource/xubh-q36u/row-ygxw-c3bh-9y5d 61325 647603 2019-05-08 2018-12-31 10           10       30       40
3275 3275 NOXUBEE GENERAL CRITICAL ACCESS HOSP 78 HOSPITAL ROAD MACON MS 39341 NOXUBEE (662) 726-4231 Critical Access Hospitals Government - Local TRUE 33.1220867 -88.5588576 1 ROOFTOP 103 28 28103         https://data.medicare.gov/resource/xubh-q36u/row-j554~em5b.ies8 251307 645005 2019-03-05 2018-09-30 25           25               25
3628 3628 SHANDS LIVE OAK REGIONAL MEDICAL CENTER 1100 SW 11TH ST LIVE OAK FL 32060 SUWANNEE (904) 362-1413 Critical Access Hospitals Proprietary TRUE 30.2917367 -83.0028124 1 ROOFTOP 121 12 12121         https://data.medicare.gov/resource/xubh-q36u/row-keij_wts9-t8jc 101301 660198 2019-12-02 2019-06-30 25           25               25
3724 3724 GENOA COMMUNITY HOSPITAL P O BOX 310, 706 EWING AVE GENOA NE 68640 PLATTE (402) 993-2283 Critical Access Hospitals Government - Local TRUE 41.4438882 -97.7325043 1 ROOFTOP 125 31 31125         https://data.medicare.gov/resource/xubh-q36u/row-c2af.d7kh~u8nh 281312 657908 2019-10-30 2019-06-30 19           19           39   58
3732 3732 PIONEER MEMORIAL HOSPITAL - CAH 315 N WASHINGTON AVE POST OFFICE BOX 368 VIBORG SD 57070 TURNER (605) 326-5161 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1700926 -97.0818666 1 ROOFTOP 125 46 46125 43620   Outlying Turner County https://data.medicare.gov/resource/xubh-q36u/row-eg2b-5945~rjby 431328 652385 2019-07-02 2018-12-31 12           12       52       64
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
3787 3787 BRODSTONE MEMORIAL HOSP P O BOX 187, 520 EAST 10TH ST SUPERIOR NE 68978 NUCKOLLS (402) 879-3281 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0266410 -98.0661260 1 ROOFTOP 129 31 31129         https://data.medicare.gov/resource/xubh-q36u/row-w2de_bhr4_4ftq 281315 653977 2019-08-27 2019-04-30 25           25               25
3796 3796 SPOONER HEALTH SYSTEM 1280 CHANDLER DR SPOONER WI 54801 WASHBURN (715) 635-2111 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8414373 -91.8703438 1 ROOFTOP 129 55 55129         https://data.medicare.gov/resource/xubh-q36u/row-y5vj~v6dk_vfyv 521332 653362 2019-08-30 2019-03-31 20           20               20
3815 3815 SYRACUSE AREA HEALTH 2731 HEALTHCARE DR SYRACUSE NE 68446 OTOE (402) 269-2011 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6770233 -96.1814653 1 ROOFTOP 131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-e4xn-76tv~ys3t 281309 658943 2019-11-11 2019-06-30 10           10               10
3830 3830 SPECTRUM HEALTH REED CITY HOSPITAL 300 N PATTERSON, PO BOX 75 REED CITY MI 49677 OSCEOLA (231) 832-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8782450 -85.5211907 1 ROOFTOP 133 26 26133         https://data.medicare.gov/resource/xubh-q36u/row-hhgy~8j82.d9qv 231323 660106 2019-11-25 2019-06-30 21 4         25       50       75
3834 3834 PAWNEE COUNTY MEMORIAL HOSPITAL P O BOX 433, 600 I ST PAWNEE CITY NE 68420 PAWNEE (402) 852-2231 Critical Access Hospitals Proprietary TRUE 40.1098396 -96.1532422 1 ROOFTOP 133 31 31133         https://data.medicare.gov/resource/xubh-q36u/row-2ahw-y3eh_6phq 281302 661036 2019-12-02 2019-06-30 17           17               17
3897 3897 CHI HEALTH PLAINVIEW P O BOX 489, 704 NORTH THIRD ST PLAINVIEW NE 68769 PIERCE (402) 582-4245 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.3587128 -97.7857721 1 ROOFTOP 139 31 31139 35740   Outlying Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dyfy-rvq7~3hjd 281346 661043 2019-12-02 2019-06-30 15           15               15
3898 3898 OSMOND GENERAL HOSPITAL P O BOX 429, 402 NORTH MAPLE ST OSMOND NE 68765 PIERCE (402) 748-3393 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.3585954 -97.5966622 1 ROOFTOP 139 31 31139 35740   Outlying Pierce County https://data.medicare.gov/resource/xubh-q36u/row-xjrz.88zi_zwqf 281347 659513 2019-11-13 2019-06-30 20           20               20
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
3987 3987 COMMUNITY HOSPITAL P O BOX 1328, 1301 EAST H ST MCCOOK NE 69001 RED WILLOW (308) 344-2650 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.2004042 -100.6317977 1 ROOFTOP 145 31 31145         https://data.medicare.gov/resource/xubh-q36u/row-b3ww-n6dr.gmwh 281363 661048 2019-12-02 2019-06-30 25           25               25
4004 4004 COMMUNITY MEDICAL CENTER, INC P O BOX 399, 3307 BARADA ST FALLS CITY NE 68355 RICHARDSON (402) 245-2428 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0778770 -95.6075970 1 ROOFTOP 147 31 31147         https://data.medicare.gov/resource/xubh-q36u/row-xcna_pb8z-kjhc 281352 640654 2018-12-28 2018-07-31 24           24               24
4043 4043 CRETE AREA MEDICAL CENTER P O BOX 220, 2910 BETTEN DR CRETE NE 68333 SALINE (402) 826-2101 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.6407290 -96.9377207 1 ROOFTOP 151 31 31151         https://data.medicare.gov/resource/xubh-q36u/row-r9d7_ysji.sjzi 281354 649921 2019-06-03 2018-12-31 24           24               24
4060 4060 CENTRACARE HEALTH SYSTEM - LONG PRAIRIE 50 CENTRACARE DRIVE LONG PRAIRIE MN 56347 TODD (320) 732-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9733659 -94.8429923 1 ROOFTOP 153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-auf6_7hb8_cyed 241326 660609 2019-11-26 2019-06-30 14           14       70       84
4091 4091 SPARTA COMMUNITY HOSPITAL 818 E BROADWAY SPARTA IL 62286 RANDOLPH (618) 443-2177 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.1239588 -89.6915364 1 ROOFTOP 157 17 17157         https://data.medicare.gov/resource/xubh-q36u/row-x2d7.jahq~9785 141349 659259 2019-11-06 2019-06-30 25           25               25
4256 4256 PENDER COMMUNITY HOSPITAL P O BOX 100, 100 HOSPITAL DRIVE PENDER NE 68047 THURSTON (402) 385-3083 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1055877 -96.7110334 1 ROOFTOP 173 31 31173         https://data.medicare.gov/resource/xubh-q36u/row-iane_yp36_h5j2 281349 661213 2019-12-02 2019-06-30 21           21               21
4281 4281 LIBERTY REGIONAL MEDICAL CENTER 462 E G MILES PARKWAY HINESVILLE GA 31310 LIBERTY (912) 369-9438 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8394772 -81.6009755 1 ROOFTOP 179 13 13179 25980 Savannah-Hinesville-Statesboro, GA Central Liberty County https://data.medicare.gov/resource/xubh-q36u/row-3b9g_44yp.xw63 111335 647248 2019-05-01 2018-11-30 25           25       108       133
4294 4294 NORTON SOUND REGIONAL HOSPITAL 1000 GREG KRUSCHEK AVENUE (P O BOX 966) NOME AK 99762 NOME (907) 443-3311 Critical Access Hospitals Tribal TRUE 64.4992304 -165.3784042 1 ROOFTOP 180 2 2180         https://data.medicare.gov/resource/xubh-q36u/row-2xs3~z9eg.fia9 21308 646669 2019-04-15 2018-09-30 18           18       18       36
4298 4298 WEBSTER COUNTY COMMUNITY HOSPITAL P O BOX 465, 621 N FRANKLIN ST RED CLOUD NE 68970 WEBSTER (402) 746-5600 Critical Access Hospitals Government - Local TRUE 40.0915582 -98.5280755 1 ROOFTOP 181 31 31181         https://data.medicare.gov/resource/xubh-q36u/row-2g3y_shvn~j8h3 281316 660132 2019-11-26 2019-06-30 13           13               13
4328 4328 YORK GENERAL HOSPITAL 2222 LINCOLN AVE YORK NE 68467 YORK (402) 362-6671 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8824760 -97.5921090 1 ROOFTOP 185 31 31185         https://data.medicare.gov/resource/xubh-q36u/row-dn5r-dnwm.i2as 281336 642099 2019-01-22 2018-09-30 25           25       129       154
4344 4344 MANIILAQ HEALTH CENTER PO BOX 43 KOTZEBUE AK 99752 NORTHWEST ARTIC BOROUGH (907) 442-3321 Critical Access Hospitals Tribal TRUE 66.8961387 -162.5868698 1 ROOFTOP 188 2 2188         https://data.medicare.gov/resource/xubh-q36u/row-5pbr_yrqg~qkzd 21310 646530 2019-03-29 2018-09-30 17           17               17
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27
4449 4449 WILSON MEDICAL CENTER REECE CAMPUS 2600 OTTAWA ROAD NEODESHA KS 66757 WILSON (620) 325-2611 Critical Access Hospitals Government - Local TRUE 37.4085290 -95.7082419 1 ROOFTOP 205 20 20205         https://data.medicare.gov/resource/xubh-q36u/row-fh4a~9srx~xwnp 171344 649229 2019-05-30 2018-12-31 15           15               15
4455 4455 HASKELL MEMORIAL HOSPITAL 1 NORTH AVENUE N PO BOX 1117 HASKELL TX 79521 HASKELL (940) 864-2621 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.1572901 -99.7446581 1 ROOFTOP 207 48 48207         https://data.medicare.gov/resource/xubh-q36u/row-66f3~mect.vjwe 451341 644375 2019-03-01 2018-09-30 25           25               25
4529 4529 PROVIDENCE VALDEZ MEDICAL CENTER PO BOX 550 VALDEZ AK 99686 VALDEZ-CORDOVA (907) 835-2249 Critical Access Hospitals Government - Local TRUE 61.1364781 -146.3458866 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-2ygw.872k~d2en 21301 652057 2019-05-30 2018-12-31 11           11       10       21
4530 4530 CORDOVA COMMUNITY MEDICAL CENTER PO BOX 160 - 602 CHASE AVENUE CORDOVA AK 99574 VALDEZ-CORDOVA (907) 424-8000 Critical Access Hospitals Government - Local TRUE 60.5413354 -145.7505310 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-kscp_6dza~rvey 21307 650633 2019-05-30 2018-12-31 13           13       10       23
4572 4572 MARTIN COUNTY HOSPITAL DISTRICT 600 E INTERSTATE 20 PO BOX 640 STANTON TX 79782 MARTIN (432) 756-3345 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.1397988 -101.7870627 1 ROOFTOP 317 48 48317 33260 Midland-Odessa, TX Outlying Martin County https://data.medicare.gov/resource/xubh-q36u/row-b2bs_dpvv_us2e 451333 655474 2019-10-01 2019-04-30 18           18               18
4619 4619 CHI ST LUKES HEALTH MEMORIAL SAN AUGUSTINE 511 HOSPITAL ST SAN AUGUSTINE TX 75972 SAN AUGUSTINE (936) 275-3446 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.5322792 -94.1031699 1 ROOFTOP 405 48 48405         https://data.medicare.gov/resource/xubh-q36u/row-d3sm_en2i-92xw 451360 660892 2019-11-27 2019-06-30 9           9               9
4679 4679 MCCAMEY HOSPITAL 2500 HWY 305 SOUTH MCCAMEY TX 79752 UPTON (432) 652-8626 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.1145414 -102.2102683 1 ROOFTOP 461 48 48461         https://data.medicare.gov/resource/xubh-q36u/row-ezrc~bqk8~d5gy 451309 643464 2019-02-22 2018-09-30 11           11               11
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
);