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

70 rows where hospital_ownership = "Proprietary" and hospital_type = "Critical Access Hospitals"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, emergency_services, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, acute_beds, icu_beds, coronary_beds, subtotal_acute_beds, subprovider_ipf_beds, skilled_nursing_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
33 33 RED BUD REGIONAL HOSPITAL 325 SPRING STREET RED BUD IL 62278 RANDOLPH (618) 282-3831 Critical Access Hospitals Proprietary TRUE 38.2096050 -89.9964080 0   157 17 17157         https://data.medicare.gov/resource/xubh-q36u/row-p29n.6wib~fbrj 141348 660526 2019-11-27 2019-06-30 25           25               25
197 197 MESA VIEW REGIONAL HOSPITAL 1299 BERTHA HOWE AVENUE MESQUITE NV 89027 CLARK (702) 346-8040 Critical Access Hospitals Proprietary TRUE 36.8088590 -114.1144560 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8rk4-cq3s_fa8n 291307 640239 2018-12-18 2018-07-31 21 4         25               25
339 339 OZARKS COMMUNITY HOSPITAL OF GRAVETTE 1101 JACKSON STREET SW GRAVETTE AR 72736 BENTON (479) 787-5291 Critical Access Hospitals Proprietary TRUE 36.4085630 -94.4598700 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-snva.mem9_cs94 41331 651314 2019-05-30 2018-12-31 25           25               25
348 348 SHANDS STARKE REGIONAL MEDICAL CENTER 922 E CALL ST STARKE FL 32091 BRADFORD (904) 368-2300 Critical Access Hospitals Proprietary TRUE 29.9419070 -82.1016500 0   7 12 12007         https://data.medicare.gov/resource/xubh-q36u/row-463i.u2z5-p3cq 101310 660199 2019-12-02 2019-06-30 25           25               25
382 382 COLUMBIA MEMORIAL HOSPITAL 2111 EXCHANGE STREET ASTORIA OR 97103 CLATSOP (503) 325-4321 Critical Access Hospitals Proprietary TRUE 46.1885030 -123.8185020 0   7 41 41007 11820   Central Clatsop County https://data.medicare.gov/resource/xubh-q36u/row-qaiq-isb9.5jkp 381320 647151 2019-04-30 2018-12-31 21 4         25               25
517 517 MONADNOCK COMMUNITY HOSPITAL 452 OLD STREET ROAD PETERBOROUGH NH 3458 HILLSBOROUGH (603) 924-7191 Critical Access Hospitals Proprietary TRUE 42.8934610 -71.9374710 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-mhsm~xuaz.m9jn 301309 645432 2019-03-01 2018-09-30 25           25               25
607 607 BIENVILLE MEDICAL CENTER 1175 PINE STREET ARCADIA LA 71001 BIENVILLE (318) 263-4700 Critical Access Hospitals Proprietary TRUE 32.5530850 -92.9157770 0   13 22 22013         https://data.medicare.gov/resource/xubh-q36u/row-ui8b~9pic.2t2z 191320 650142 2019-06-03 2018-12-31 21           21               21
673 673 EUREKA SPRINGS HOSPITAL, LLC 24 NORRIS STREET EUREKA SPRINGS AR 72632 CARROLL (479) 253-7400 Critical Access Hospitals Proprietary TRUE 36.4004330 -93.7446990 0   15 5 5015         https://data.medicare.gov/resource/xubh-q36u/row-fpuw-vbap-fsdb 41304 647643 2019-05-14 2018-12-31 15           15               15
744 744 RUMFORD HOSPITAL 420 FRANKLIN STREET RUMFORD ME 4276 OXFORD (207) 369-1000 Critical Access Hospitals Proprietary TRUE 44.5517210 -70.5571710 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-923a_kexq.nxfx 201306 662536 2019-12-02 2019-06-30 25           25               25
792 792 MULESHOE AREA MEDICAL CENTER 708 S 1ST ST MULESHOE TX 79347 BAILEY (806) 272-4524 Critical Access Hospitals Proprietary TRUE 34.2210290 -102.7284580 0   17 48 48017         https://data.medicare.gov/resource/xubh-q36u/row-2yhf.nyid~b2dz 451372 644191 2019-02-28 2018-09-30 25           25               25
830 830 DEQUINCY MEMORIAL HOSPITAL 110 WEST 4TH STREET DEQUINCY LA 70633 CALCASIEU (337) 786-1200 Critical Access Hospitals Proprietary TRUE 30.4518030 -93.4371910 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-9sya_iav2.y4rk 191307 653779 2019-09-09 2019-03-31 19           19 10             29
869 869 PLATEAU MEDICAL CENTER 430 MAIN STREET, WEST OAK HILL WV 25901 FAYETTE (304) 469-8600 Critical Access Hospitals Proprietary TRUE 37.9746800 -81.1441700 0   19 54 54019 13220   Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-3eu5_8zzh~m57x 511317 651684 2019-06-24 2018-12-31 22 3         25               25
928 928 TRISTAR ASHLAND CITY MEDICAL CENTER 313 NORTH MAIN ST ASHLAND CITY TN 37015 CHEATHAM (615) 792-3030 Critical Access Hospitals Proprietary TRUE 36.2769740 -87.0659760 0   21 47 47021 34980 Nashville-Davidson--Murfreesboro, TN Outlying Cheatham County https://data.medicare.gov/resource/xubh-q36u/row-dctd_vqeq_ijzv 441311 655652 2019-10-30 2019-05-31 12           12               12
941 941 HOLY CROSS HOSPITAL 1171 WEST TARGET RANGE ROAD NOGALES AZ 85621 SANTA CRUZ (520) 285-3000 Critical Access Hospitals Proprietary TRUE 31.3411180 -110.9587340 0   23 4 4023 35700 Tucson-Nogales, AZ Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-datt~k3n6_g682 31313 644092 2019-02-28 2018-09-30 25           25               25
965 965 DESERT VIEW HOSPITAL 360 SOUTH LOLA LANE PAHRUMP NV 89048 NYE (775) 751-7500 Critical Access Hospitals Proprietary TRUE 36.2143760 -116.0233810 0   23 32 32023 37220 Las Vegas-Henderson, NV-AZ Central Nye County https://data.medicare.gov/resource/xubh-q36u/row-tvhx.ef9u_jqa6 291311 654936 2019-09-20 2018-12-31 25           25               25
1001 1001 REDINGTON FAIRVIEW GENERAL HOSPITAL 46 FAIRVIEW AVE PO BOX 468 SKOWHEGAN ME 4976 SOMERSET (207) 474-5121 Critical Access Hospitals Proprietary TRUE 44.7583360 -69.7134950 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-g9mx~aw3n.5hnn 201314 661526 2019-12-02 2019-06-30 21 4         25               25
1109 1109 DELTA COMMUNITY HOSPITAL 126 SOUTH WHITE SAGE AVENUE DELTA UT 84624 MILLARD (435) 864-5591 Critical Access Hospitals Proprietary TRUE 39.3502940 -112.5600230 0   27 49 49027         https://data.medicare.gov/resource/xubh-q36u/row-drqc-aprc.hcpi 461300 652115 2019-05-30 2018-12-31 18           18               18
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
1164 1164 MARY HURLEY HOSPITAL 6 NORTH COVINGTON COALGATE OK 74538 COAL (580) 927-2327 Critical Access Hospitals Proprietary TRUE 34.5392220 -96.2242870 0   29 40 40029         https://data.medicare.gov/resource/xubh-q36u/row-vgqy-nnxi.ph5t 371319 661388 2019-11-27 2019-06-30 20           20               20
1543 1543 SPARROW CLINTON HOSPITAL 805 S OAKLAND SAINT JOHNS MI 48879 CLINTON (989) 224-6881 Critical Access Hospitals Proprietary TRUE 42.9934350 -84.5558080 0   37 26 26037 29620 Lansing-East Lansing-Owosso, MI Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-2x5u-xt8b.6eqd 231326 649611 2019-05-31 2018-12-31 23 2         25               25
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
1621 1621 GUNNISON VALLEY HOSPITAL 64 EAST 100 NORTH GUNNISON UT 84634 SANPETE (435) 528-7246 Critical Access Hospitals Proprietary TRUE 39.1566610 -111.8170140 0   39 49 49039         https://data.medicare.gov/resource/xubh-q36u/row-rqkf~i25u_knq8 461306 659077 2019-11-20 2019-06-30 25           25               25
1712 1712 BIG BEND REGIONAL MEDICAL CENTER 2600 HIGHWAY 118 NORTH ALPINE TX 79830 BREWSTER (432) 837-3447 Critical Access Hospitals Proprietary TRUE 30.3838110 -103.6721400 0   43 48 48043         https://data.medicare.gov/resource/xubh-q36u/row-snt8.6tvq~cxi3 451378 654056 2019-08-28 2018-09-30 22 3         25               25
1733 1733 SOCORRO GENERAL HOSPITAL 1202 HIGHWAY 60 WEST SOCORRO NM 87801 SOCORRO (575) 835-1140 Critical Access Hospitals Proprietary TRUE 34.0387210 -106.9120140 0   53 35 35053         https://data.medicare.gov/resource/xubh-q36u/row-93zp~dbrk.vq66 321301 651646 2019-06-27 2018-12-31 24           24               24
1951 1951 ELLSWORTH COUNTY MEDICAL CENTER 1604 AYLWARD AVENUE ELLSWORTH KS 67439 ELLSWORTH (785) 472-3111 Critical Access Hospitals Proprietary TRUE 38.7419690 -98.2188920 0   53 20 20053         https://data.medicare.gov/resource/xubh-q36u/row-gj2d~qekt_mg63 171327 659792 2019-11-18 2019-06-30 18           18               18
2002 2002 REGIONAL MEDICAL CENTER 709 W MAIN STREET MANCHESTER IA 52057 DELAWARE (563) 927-3232 Critical Access Hospitals Proprietary TRUE 42.4839030 -91.4666440 0   55 19 19055         https://data.medicare.gov/resource/xubh-q36u/row-znx9.yjf2.jpru 161343 660219 2019-11-25 2019-06-30 25           25           1   26
2034 2034 MANGUM REGIONAL MEDICAL CENTER 1 WICKERSHAM DRIVE MANGUM OK 73554 GREER (580) 782-3353 Critical Access Hospitals Proprietary TRUE 34.8918230 -99.5023410 0   55 40 40055         https://data.medicare.gov/resource/xubh-q36u/row-irnc.n45b.ecpm 371330 649816 2019-05-31 2018-12-31 18           18               18
2223 2223 HASKELL COUNTY COMMUNITY HOSPITAL 401 NORTHWEST H STREET STIGLER OK 74462 HASKELL (918) 967-4682 Critical Access Hospitals Proprietary TRUE 35.2608090 -95.1289420 0   61 40 40061         https://data.medicare.gov/resource/xubh-q36u/row-rknu_3rxm-eq7v 371335 642484 2019-01-17 2018-09-30 25           25               25
2261 2261 IZARD COUNTY MEDICAL CENTER, LLC 61 GRASSE STREET CALICO ROCK AR 72519 BAXTER (870) 297-2400 Critical Access Hospitals Proprietary TRUE 36.1263360 -92.1285870 0   65 5 5065         https://data.medicare.gov/resource/xubh-q36u/row-nm2c~hstr_uanu 41306 662150 2019-12-06 2019-06-30 25           25               25
2456 2456 GEORGE C GRAPE COMMUNITY HOSPITAL 2959 US HIGHWAY 275 HAMBURG IA 51640 FREMONT (712) 382-1515 Critical Access Hospitals Proprietary TRUE 40.6205540 -95.6494750 0   71 19 19071         https://data.medicare.gov/resource/xubh-q36u/row-yhg7~bavy~3mu7 161324 644272 2019-03-05 2018-09-30 25           25               25
2491 2491 RICELAND MEDICAL CENTER 538 BROADWAY WINNIE TX 77665 CHAMBERS (409) 296-6000 Critical Access Hospitals Proprietary TRUE 29.8205230 -94.3771330 0   71 48 48071 26420 Houston-The Woodlands, TX Central Chambers County https://data.medicare.gov/resource/xubh-q36u/row-wtt6~522f_uuw2 451328 659900 2019-11-08 2018-12-31 25           25               25
2871 2871 COLLINGSWORTH GENERAL HOSPITAL 1013 15TH ST WELLINGTON TX 79095 COLLINGSWORTH (806) 447-2521 Critical Access Hospitals Proprietary TRUE 34.8491100 -100.2120150 0   87 48 48087         https://data.medicare.gov/resource/xubh-q36u/row-iy62.m34i.p94f 451355 643660 2019-02-27 2018-09-30 15           15               15
2928 2928 RICE MEDICAL CENTER 600 SOUTH AUSTIN ROAD EAGLE LAKE TX 77434 COLORADO (979) 234-5571 Critical Access Hospitals Proprietary TRUE 29.5880660 -96.3459410 0   89 48 48089         https://data.medicare.gov/resource/xubh-q36u/row-vnik-sqe7~5xri 451312 661825 2019-12-05 2018-12-31 21           21               21
2978 2978 MARSHALL COUNTY HEALTHCARE CENTER - CAH 413 9TH STREET BRITTON SD 57430 MARSHALL (605) 448-2253 Critical Access Hospitals Proprietary TRUE 45.7892150 -97.7460490 0   91 46 46091         https://data.medicare.gov/resource/xubh-q36u/row-6vvk-qfd7.3dtg 431312 658793 2019-11-14 2019-06-30 20           20               20
3065 3065 ALLIANCEHEALTH MADILL 901 S 5TH AVE MADILL OK 73446 MARSHALL (580) 795-3384 Critical Access Hospitals Proprietary TRUE 34.0817380 -96.7784500 0   95 40 40095         https://data.medicare.gov/resource/xubh-q36u/row-b6vq_dbi2_tjfb 371326 653270 2019-08-30 2019-03-31 21           21               21
3124 3124 LAUDERDALE COMMUNITY HOSPITAL 326 ASBURY AVENUE RIPLEY TN 38063 LAUDERDALE (731) 221-2200 Critical Access Hospitals Proprietary TRUE 35.7465540 -89.5489490 0   97 47 47097         https://data.medicare.gov/resource/xubh-q36u/row-ke8q-6b6z~pb2i 441314 641976 2019-01-28 2018-09-30 25           25               25
3159 3159 OSWEGO COMMUNITY HOSPITAL 800 BARKER DRIVE OSWEGO KS 67356 LABETTE (620) 795-2921 Critical Access Hospitals Proprietary TRUE 37.1596730 -95.1107700 0   99 20 20099 37660   Central Labette County https://data.medicare.gov/resource/xubh-q36u/row-r8kw_57qd_r6fs 171302 643032 2019-01-29 2018-09-30 12           12               12
3273 3273 BELL HOSPITAL 901 LAKESHORE DRIVE ISHPEMING MI 49849 MARQUETTE (906) 486-4431 Critical Access Hospitals Proprietary TRUE 46.4986650 -87.6829930 0   103 26 26103 32100   Central Marquette County https://data.medicare.gov/resource/xubh-q36u/row-ag2p-d743~hfr4 231321 661204 2019-12-03 2019-06-30 21   4       25               25
3348 3348 LAFAYETTE REGIONAL HEALTH CENTER 1500 STATE STREET LEXINGTON MO 64067 LAFAYETTE (660) 259-2203 Critical Access Hospitals Proprietary TRUE 39.1891460 -93.8770650 0   107 29 29107 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Lafayette County https://data.medicare.gov/resource/xubh-q36u/row-sn6v-86t8~7h98 261320 645576 2019-03-01 2018-09-30 23 2         25               25
3406 3406 CULBERSON HOSPITAL EISENHOWER ROAD AND FM 2185 VAN HORN TX 79855 CULBERSON (432) 283-2760 Critical Access Hospitals Proprietary FALSE 31.0496690 -104.8283880 0   109 48 48109         https://data.medicare.gov/resource/xubh-q36u/row-g73p-emdj_vjx2 451338 653287 2019-08-29 2019-03-31 14           14               14
3438 3438 PERRY COUNTY GENERAL HOSP 206 BAY ST RICHTON MS 39476 GREENE (601) 788-6316 Critical Access Hospitals Proprietary TRUE 31.3470310 -88.9373920 0   111 28 28111 25620   Outlying Perry County https://data.medicare.gov/resource/xubh-q36u/row-jpr3_ecff-vsry 251306 649789 2019-06-01 2018-12-31 22           22               22
3450 3450 CONEMAUGH MEYERSDALE MEDICAL CENTER 200 HOSPITAL DRIVE MEYERSDALE PA 15552 SOMERSET (814) 634-5911 Critical Access Hospitals Proprietary TRUE 39.8092810 -79.0253380 0   111 42 42111 43740 Johnstown-Somerset, PA Central Somerset County https://data.medicare.gov/resource/xubh-q36u/row-zfec_mecz_mmru 391302 660304 2019-12-03 2019-06-30 20           20               20
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
3599 3599 QUITMAN COUNTY HOSPITAL CAH 340 GETWELL DRIVE MARKS MS 38646 QUITMAN (662) 326-8031 Critical Access Hospitals Proprietary TRUE 34.2474640 -90.2770590 0   119 28 28119         https://data.medicare.gov/resource/xubh-q36u/row-94fq~mrkf~464e                                      
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
3704 3704 LAKE BUTLER HOSPITAL 850 E MAIN ST LAKE BUTLER FL 32054 UNION (386) 496-2323 Critical Access Hospitals Proprietary TRUE 30.0236030 -82.3274330 0   125 12 12125         https://data.medicare.gov/resource/xubh-q36u/row-rej7-beh4~2wb4 101303 651512 2019-05-31 2018-12-31 25           25               25
3777 3777 INDIANHEAD MEDICAL CENTER SHELL LAKE 113 4TH AVE SHELL LAKE WI 54871 WASHBURN (715) 468-7833 Critical Access Hospitals Proprietary TRUE 45.7421020 -91.9257800 0   129 55 55129         https://data.medicare.gov/resource/xubh-q36u/row-kcr4.6q2e-4e5f 521342 650795 2019-05-30 2018-12-31 25           25               25
3813 3813 STONE COUNTY HOSPITAL 1434 EAST CENTRAL AVENUE WIGGINS MS 39577 STONE (601) 928-6600 Critical Access Hospitals Proprietary TRUE 30.8456460 -89.1152020 0   131 28 28131         https://data.medicare.gov/resource/xubh-q36u/row-wr7g-c4g3-jpqu 251303 650843 2019-06-05 2018-12-31 25           25               25
3825 3825 ST MARY'S GOOD SAMARITAN HOSPITAL 5401 LAKE OCONEE PARKWAY GREENSBORO GA 30642 GREENE (706) 453-7331 Critical Access Hospitals Proprietary TRUE 33.4799210 -83.2416450 0   133 13 13133         https://data.medicare.gov/resource/xubh-q36u/row-bqbp~uisy-u894 111329 660372 2019-12-03 2019-06-30 25           25               25
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
3868 3868 MOUNTAIN LAKES MEDICAL CENTER 162 LEGACY POINT CLAYTON GA 30525 RABUN (706) 782-3100 Critical Access Hospitals Proprietary TRUE 34.5540750 -83.5442300 0   137 13 13137 18460   Central Habersham County https://data.medicare.gov/resource/xubh-q36u/row-75eu.dvw3~kk2p 111336 647771 2019-05-09 2018-12-31 25           25               25
3947 3947 SCOTT MEMORIAL HEALTH 1451 N GARDNER ST SCOTTSBURG IN 47170 SCOTT (812) 752-3456 Critical Access Hospitals Proprietary TRUE 38.7055250 -85.7852000 0   143 18 18143 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Outlying Scott County https://data.medicare.gov/resource/xubh-q36u/row-w3qq-86eu-wbzv 151334 649730 2019-06-03 2018-12-31 21 4         25               25
4011 4011 DARDANELLE HOSPITAL 200 NORTH THIRD STREET DARDANELLE AR 72834 YELL (479) 229-4677 Critical Access Hospitals Proprietary TRUE 35.2209170 -93.1569870 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-u9x6_diim.h7v6 41302 639835 2018-12-26 2018-06-30 25           25 10             35
4014 4014 FLOYD VALLEY HEALTHCARE 714 LINCOLN ST NE LE MARS IA 51031 PLYMOUTH (712) 546-7871 Critical Access Hospitals Proprietary TRUE 42.7972800 -96.1559900 0   149 19 19149 43580 Sioux City-Vermillion, IA-SD-NE Outlying Plymouth County https://data.medicare.gov/resource/xubh-q36u/row-dyg7.rs5y.hwrt 161368 661183 2019-12-03 2019-06-30 25           25               25
4099 4099 ST ELIZABETH MEDICAL CENTER 1200 GRANT BLVD W WABASHA MN 55981 WABASHA (651) 565-4531 Critical Access Hospitals Proprietary TRUE 44.3864160 -92.0491400 0   157 27 27157 40340 Rochester-Austin, MN Outlying Wabasha County https://data.medicare.gov/resource/xubh-q36u/row-diq7.k9ja_4m53 241335 661737 2019-12-03 2019-06-30 14           14       100       114
4130 4130 RIVERVIEW REGIONAL MEDICAL CENTER 158 HOSPITAL DRIVE CARTHAGE TN 37030 SMITH (615) 735-9815 Critical Access Hospitals Proprietary TRUE 36.2636070 -85.9485560 0   159 47 47159 34980 Nashville-Davidson--Murfreesboro, TN Outlying Smith County https://data.medicare.gov/resource/xubh-q36u/row-rt2i~krrj-iike 441307 641882 2019-01-02 2018-07-31 23 2         25 10             35
4182 4182 JENKINS COUNTY HOSPITAL 931 EAST WINTHROPE AVENUE MILLEN GA 30442 JENKINS (478) 982-4221 Critical Access Hospitals Proprietary TRUE 32.8036780 -81.9340740 0   165 13 13165         https://data.medicare.gov/resource/xubh-q36u/row-wabu-mgcf_ujg3 111311 651201 2019-06-03 2018-12-31 15           15               15
4225 4225 LIFEBRITE COMMUNITY HOSPITAL OF STOKES 1570 NC 8 & 89 HWY NORTH DANBURY NC 27016 STOKES (336) 593-2831 Critical Access Hospitals Proprietary TRUE 36.4180006 -80.2309154 1 GEOMETRIC_CENTER 169 37 37169 49180 Greensboro--Winston-Salem--High Point, NC Central Stokes County https://data.medicare.gov/resource/xubh-q36u/row-dqr8~4bpg.trsv 341317 646477 2019-04-15 2018-09-30 25           25       40       65
4295 4295 UNION COUNTY HOSPITAL 517 NORTH MAIN STREET ANNA IL 62906 UNION (618) 833-4511 Critical Access Hospitals Proprietary TRUE 37.4653050 -89.2450190 0   181 17 17181         https://data.medicare.gov/resource/xubh-q36u/row-pcrc-gp3a~kn84 141342 653887 2019-08-27 2018-12-31 25           25           22   47
4309 4309 OHIO COUNTY HOSPITAL 1211 OLD MAIN STREET HARTFORD KY 42347 OHIO (270) 298-7411 Critical Access Hospitals Proprietary TRUE 37.4476490 -86.8964740 0   183 21 21183         https://data.medicare.gov/resource/xubh-q36u/row-jams.uqap-8mmi 181323 645091 2019-03-12 2018-09-30 21 4         25               25
4340 4340 WASHINGTON COUNTY HOSP INC 958 US HWY 64 EAST PLYMOUTH NC 27962 WASHINGTON (252) 793-4135 Critical Access Hospitals Proprietary TRUE 35.8479840 -76.7558380 0   187 37 37187         https://data.medicare.gov/resource/xubh-q36u/row-x8x8-fegi-en3k 341314 640726 2019-01-02 2018-09-30 25           25               25
4382 4382 I-70 COMMUNITY HOSPITAL 105 HOSPITAL DRIVE, BUILDING B SWEET SPRINGS MO 65351 SALINE (660) 335-4700 Critical Access Hospitals Proprietary TRUE 38.9782840 -93.4176350 0   195 29 29195 32180   Central Saline County https://data.medicare.gov/resource/xubh-q36u/row-4t2s.h4cc.n3vd 261334 651708 2019-06-28 2018-09-30 15           15               15
4493 4493 CROCKETT MEDICAL CENTER 1100 E LOOP 304 CROCKETT TX 75835 HOUSTON (936) 546-3890 Critical Access Hospitals Proprietary TRUE 31.3236990 -95.4372570 0   225 48 48225         https://data.medicare.gov/resource/xubh-q36u/row-2gki~micg.zrhe                                      
4501 4501 GOLDEN PLAINS COMMUNITY HOSPITAL 100 MEDICAL DRIVE BORGER TX 79007 HUTCHINSON (806) 273-1100 Critical Access Hospitals Proprietary TRUE 35.6538340 -101.4090410 0   233 48 48233 14420 Amarillo-Borger, TX Central Hutchinson County https://data.medicare.gov/resource/xubh-q36u/row-rtyt.xqrr~9rdj 451369 660153 2019-12-05 2018-12-31 21 4         25               25
4507 4507 BLUEGRASS COMMUNITY HOSPITAL 360 AMSDEN AVENUE VERSAILLES KY 40383 WOODFORD (859) 873-3111 Critical Access Hospitals Proprietary TRUE 38.0553430 -84.7234150 0   239 21 21239 30460 Lexington-Fayette--Richmond--Frankfort, KY Outlying Woodford County https://data.medicare.gov/resource/xubh-q36u/row-9aks-4jh9~zwp7 181308 652512 2019-08-01 2019-02-28 25           25               25
4520 4520 OPTIM MEDICAL CENTER - SCREVEN 215 MIMS ROAD SYLVANIA GA 30467 SCREVEN (912) 564-7426 Critical Access Hospitals Proprietary TRUE 32.7501600 -81.6459370 0   251 13 13251         https://data.medicare.gov/resource/xubh-q36u/row-aesx-wury_ra8f 111312 651202 2019-05-31 2018-12-31 25           25               25
4533 4533 OPTIM MEDICAL CENTER - TATTNALL 247 S MAIN STREET REIDSVILLE GA 30453 TATTNALL (912) 557-1000 Critical Access Hospitals Proprietary TRUE 32.0806490 -82.1110420 0   267 13 13267         https://data.medicare.gov/resource/xubh-q36u/row-g732.aahv_uv3n 111323 651204 2019-05-31 2018-12-31 25           25               25
4579 4579 LITTLE RIVER HEALTHCARE 1700 BRAZOS ROCKDALE TX 76567 MILAM (512) 446-4500 Critical Access Hospitals Proprietary TRUE 30.6503240 -97.0201050 0   331 48 48331         https://data.medicare.gov/resource/xubh-q36u/row-afvn-5pmv_graz 451357 630239 2018-06-01 2017-12-31 25           25               25
4618 4618 SABINE COUNTY HOSPITAL PO BOX 750, 2301 HWY 83 W HEMPHILL TX 75948 SABINE (409) 787-3300 Critical Access Hospitals Proprietary TRUE 31.3407403 -93.8468520 1 APPROXIMATE 403 48 48403         https://data.medicare.gov/resource/xubh-q36u/row-quek_rvd7~v5jz 451361 648996 2019-05-28 2018-12-31 25           25               25
4621 4621 SCHLEICHER COUNTY MEDICAL CENTER 102 NORTH US HIGHWAY 277 ELDORADO TX 76936 SCHLEICHER (325) 853-2507 Critical Access Hospitals Proprietary TRUE 30.8698690 -100.5903930 0   413 48 48413         https://data.medicare.gov/resource/xubh-q36u/row-ukk5-7d2r~gvs8 451304 649143 2019-05-21 2018-12-31 14           14               14

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