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

1,122 rows where centraloutlyingcounty = "" sorted by lat

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, fy_end_date, icu_beds, coronary_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, nursing_fac_beds, filed_date (date), fy_end_date (date)

centraloutlyingcounty ✖

  • - · 1,122 ✖
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
476 476 LBJ TROPICAL MEDICAL CENTER FAGAALU VILLAGE PAGO PAGO AS 96799 EASTERN DISTRICT (684) 633-4590 Acute Care Hospitals Government - Hospital District or Authority TRUE -14.2900610 -170.6847054 1 APPROXIMATE 10 60 60010         https://data.medicare.gov/resource/xubh-q36u/row-6iv4.yudm-sdek                                      
477 477 GUAM MEMORIAL HOSPITAL AUTHORITY 85O GOV CARLOS G CAMACHO ROAD TAMUNING GU 96913 GUAM (671) 647-2552 Acute Care Hospitals Government - Local TRUE 13.5008229 144.7755910 1 GEOMETRIC_CENTER 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-4hjs.vy3n_hawy 650001 644079 2019-02-28 2018-09-30 147 14         161       40       201
478 478 GUAM REGIONAL MEDICAL CITY 133 ROUTE 3 DEDEDO GU 96929 GUAM (671) 645-5500 Acute Care Hospitals Voluntary non-profit - Private TRUE 13.5248362 144.8232653 1 ROOFTOP 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-ikxi.yahy_8xvd 650003 651493 2019-06-04 2018-12-31 88 17         105               105
3412 3412 COMMONWEALTH HEALTH CENTER 1 LOWER NAVY HILL ROAD (PO BOX 409CK) GARAPAN MP 96950 SAIPAN (670) 234-8950 Acute Care Hospitals Proprietary TRUE 15.2086299 145.7303467 1 GEOMETRIC_CENTER 110 69 69110         https://data.medicare.gov/resource/xubh-q36u/row-z8uz.de7b_sx86 660001 644688 2019-03-01 2018-09-30 70 4         74               74
479 479 GOV JUAN F LUIS HOSPITAL & MEDICAL CTR #4007 EST DIAMOND RUBY, CHRISTIANSTED ST CROIX VI 820 SAINT CROIX ISLAND (340) 778-6311 Acute Care Hospitals Government - State TRUE 17.7336768 -64.7515758 1 ROOFTOP 10 78 78010         https://data.medicare.gov/resource/xubh-q36u/row-bs2s~9p8n_k2e3 480002 644383 2019-02-28 2018-09-30 66 11         77               77
1196 1196 ROY LESTER SCHNEIDER HOSPITAL,THE 9048 SUGAR ESTATE ST THOMAS VI 801 SAINT THOMAS ISLAND (809) 776-8311 Acute Care Hospitals Government - Local TRUE 18.3403280 -64.9146707 1 ROOFTOP 30 78 78030         https://data.medicare.gov/resource/xubh-q36u/row-smqm-6qpj_ky9s 480001 644382 2019-03-01 2018-09-30 99 8         107               107
4612 4612 REFUGIO COUNTY MEMORIAL HOSPITAL 107 SWIFT STREET REFUGIO TX 78377 REFUGIO (361) 526-2321 Critical Access Hospitals Government - Hospital District or Authority TRUE 28.3064870 -97.2794390 0   391 48 48391         https://data.medicare.gov/resource/xubh-q36u/row-2im8~3t6u.ez3t 451317 649504 2019-05-29 2018-12-31 20           20               20
3760 3760 DIMMIT REGIONAL HOSPITAL 704 HOSPITAL DRIVE CARRIZO SPRINGS TX 78834 DIMMIT (830) 876-2424 Critical Access Hospitals Voluntary non-profit - Other TRUE 28.5199740 -99.8620980 0   127 48 48127         https://data.medicare.gov/resource/xubh-q36u/row-f4ys-ri9j-kfns 451390 643855 2019-03-01 2018-09-30 25           25               25
4526 4526 OTTO KAISER MEMORIAL HOSPITAL 3349 S HIGHWAY 181 KENEDY TX 78119 KARNES (830) 583-3401 Critical Access Hospitals Government - Hospital District or Authority TRUE 28.8042500 -97.8566420 0   255 48 48255         https://data.medicare.gov/resource/xubh-q36u/row-4ahf_4ve9~n23g 451364 659545 2019-11-21 2019-06-30 25           25               25
34 34 FRIO REGIONAL HOSPITAL 200 S IH 35 PEARSALL TX 78061 FRIO (830) 334-3617 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.8970480 -99.1160130 0   163 48 48163         https://data.medicare.gov/resource/xubh-q36u/row-9gys.vgtu~2pyx 451391 650214 2019-06-03 2018-12-31 24           24               24
4508 4508 JACKSON HEALTHCARE CENTER 1013 S WELLS EDNA TX 77957 JACKSON (361) 782-7800 Critical Access Hospitals Government - Hospital District or Authority TRUE 28.9693880 -96.6348390 0   239 48 48239         https://data.medicare.gov/resource/xubh-q36u/row-vk5d.74uh-ngkv 451363 644190 2019-02-26 2018-09-30 25           25               25
3697 3697 CUERO REGIONAL HOSPITAL 2550 N ESPLANADE CUERO TX 77954 DE WITT (361) 275-6191 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.1124950 -97.2816930 0   123 48 48123         https://data.medicare.gov/resource/xubh-q36u/row-awr8_s97f~hye5 450597 643378 2019-02-21 2018-09-30 44           44               44
4547 4547 YOAKUM COMMUNITY HOSPITAL 1200 CARL RAMERT DRIVE YOAKUM TX 77995 LAVACA (361) 293-2321 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.3066200 -97.1303060 0   285 48 48285         https://data.medicare.gov/resource/xubh-q36u/row-fd62_5vyv.n9wj 451346 660056 2019-11-21 2019-06-30 22 3         25               25
2567 2567 REGIONAL GENERAL HOSPITAL WILLISTON 125 SW 7TH ST WILLISTON FL 32696 LEVY (352) 528-2801 Acute Care Hospitals Proprietary TRUE 29.3843540 -82.4557930 0   75 12 12075         https://data.medicare.gov/resource/xubh-q36u/row-tm6t.5fgm.s5u5 100322 642986 2019-02-04 2018-08-31 20           20               20
4546 4546 LAVACA MEDICAL CENTER 1400 NORTH TEXANA STREET HALLETTSVILLE TX 77964 LAVACA (361) 798-3671 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.4571450 -96.9398770 0   285 48 48285         https://data.medicare.gov/resource/xubh-q36u/row-wjtg_etrx~yntz 451376 649677 2019-05-31 2018-12-31 25           25               25
4279 4279 MEMORIAL HOSPITAL 1110 NORTH SARAH DEWITT DRIVE GONZALES TX 78629 GONZALES (830) 672-7581 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5158950 -97.4288680 0   177 48 48177         https://data.medicare.gov/resource/xubh-q36u/row-7g7y.b4hd-s8g5 450235 659735 2019-11-25 2019-06-30 34           34               34
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
2929 2929 COLUMBUS COMMUNITY HOSPITAL 110 SHULT DR COLUMBUS TX 78934 COLORADO (979) 732-2371 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.6942870 -96.5424830 0   89 48 48089         https://data.medicare.gov/resource/xubh-q36u/row-sd44-u9xj_6uxs 450370 654698 2019-09-26 2019-04-30 40           40               40
1533 1533 GEORGE E WEEMS MEMORIAL HOSPITAL 135 AVE G APALACHICOLA FL 32320 FRANKLIN (850) 653-8853 Critical Access Hospitals Government - Local TRUE 29.7244840 -84.9912750 0   37 12 12037         https://data.medicare.gov/resource/xubh-q36u/row-z2w8_ts6n.p4qb 101305 644253 2019-03-04 2018-09-30 25           25               25
31 31 ST MARKS MEDICAL CENTER ONE ST MARK'S PLACE LA GRANGE TX 78945 FAYETTE (979) 242-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.9353227 -96.8763382 1 ROOFTOP 149 48 48149         https://data.medicare.gov/resource/xubh-q36u/row-sffi-gqgq~nh45 670004 660902 2019-12-02 2019-06-30 38           38               38
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
356 356 ASSUMPTION COMMUNITY HOSPITAL 135 HIGHWAY 402 NAPOLEONVILLE LA 70390 ASSUMPTION (985) 369-3600 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.9575850 -91.0338750 0   7 22 22007         https://data.medicare.gov/resource/xubh-q36u/row-smss_wf6g.wmww 191303 659796 2019-11-27 2019-06-30 15           15               15
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
3674 3674 DOCTORS MEMORIAL HOSPITAL INC 333 N BYRON BUTLER PKWY PERRY FL 32348 TAYLOR (850) 584-0800 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1211280 -83.5920090 0   123 12 12123         https://data.medicare.gov/resource/xubh-q36u/row-zuzs_bydp_aath 100106 656062 2019-10-31 2019-05-31 42 6         48               48
1953 1953 JENNINGS AMERICAN LEGION HOSPITAL 1634 ELTON ROAD JENNINGS LA 70546 JEFFRSON DAVIS (337) 616-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2392150 -92.6634450 0   53 22 22053         https://data.medicare.gov/resource/xubh-q36u/row-xvdw_xhgm-htky 190053 647257 2019-05-01 2018-11-30 44 5         49               49
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
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
4331 4331 GRIMES ST JOSEPH HEALTH CENTER 210 JUDSON ST NAVASOTA TX 77868 GRIMES (936) 825-6585 Critical Access Hospitals Voluntary non-profit - Church TRUE 30.3928950 -96.0771680 0   185 48 48185         https://data.medicare.gov/resource/xubh-q36u/row-ng26_s56i-assy 451322 661419 2019-11-29 2019-06-30 18           18               18
598 598 CALHOUN-LIBERTY HOSPITAL 20370 NE BURNS AVE BLOUNTSTOWN FL 32424 CALHOUN (850) 674-3493 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.4581280 -85.0495870 0   13 12 12013         https://data.medicare.gov/resource/xubh-q36u/row-sxhi~5k5k~4igt 101304 651800 2019-05-24 2018-12-31 15           15               15
2641 2641 MADISON COUNTY MEMORIAL HOSPITAL 224 NW CRANE AVE MADISON FL 32340 MADISON (850) 973-2271 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.4714130 -83.4198980 0   79 12 12079         https://data.medicare.gov/resource/xubh-q36u/row-gara~x4i8-9hau 101311 643696 2019-02-27 2018-09-30 25           25               25
174 174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
4534 4534 KIMBLE HOSPITAL 349 REID ROAD JUNCTION TX 76849 KIMBLE (325) 446-3321 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.4991940 -99.7802540 0   267 48 48267         https://data.medicare.gov/resource/xubh-q36u/row-k7bm_txp3.mutf 451306 643379 2019-02-20 2018-09-30 15           15               15
4631 4631 LILLIAN M HUDSPETH MEMORIAL HOSPITAL 308 HUDSPETH SONORA TX 76950 SUTTON (325) 387-2521 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.5637580 -100.6348700 0   435 48 48435         https://data.medicare.gov/resource/xubh-q36u/row-i9e9_qde3.um4r 451324 652847 2019-08-21 2018-12-31 12           12               12
1591 1591 SAVOY MEDICAL CENTER 801 POINCIANA AVENUE MAMOU LA 70554 EVANGELINE (337) 468-5261 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.6410320 -92.4176050 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-53wc.63uu-ebuh 190025 650138 2019-06-03 2018-12-31 118 10         128 38 10           176
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
1592 1592 MERCY REGIONAL MEDICAL CENTER 800 E MAIN VILLE PLATTE LA 70586 EVANGELINE (337) 363-5684 Acute Care Hospitals Proprietary TRUE 30.6849310 -92.2659730 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-2sdk.fhzr.wwum 190167 645559 2019-03-01 2018-09-30 85 14         99   10           109
1976 1976 SETON HIGHLAND LAKES HIGHWAY 281 SOUTH BURNET TX 78611 BURNET (512) 715-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.7113209 -98.2467221 1 GEOMETRIC_CENTER 53 48 48053         https://data.medicare.gov/resource/xubh-q36u/row-khw5~6jgp-v7pk 451365 659615 2019-11-25 2019-06-30 21 4         25               25
4557 4557 BAYLOR SCOTT & WHITE MEDICAL CENTER - LLANO 200 W OLLIE LLANO TX 78643 LLANO (325) 247-5040 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.7433450 -98.6779960 0   299 48 48299         https://data.medicare.gov/resource/xubh-q36u/row-f5ig_zcze-hhqw 450219 657514 2019-03-04 2018-08-31 25           25               25
2132 2132 DOCTORS MEMORIAL HOSPITAL 2600 HOSPITAL DR BONIFAY FL 32425 HOLMES (850) 547-1120 Critical Access Hospitals Government - Hospital District or Authority FALSE 30.7605900 -85.6824740 0   59 12 12059         https://data.medicare.gov/resource/xubh-q36u/row-sw88.r7zg.v2gg 101307 645754 2019-03-18 2018-09-30 20           20               20
3824 3824 NORTHWEST FLORIDA COMMUNITY HOSPITAL 1360 BRICKYARD RD CHIPLEY FL 32428 WASHINGTON (850) 638-1610 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.7645700 -85.5426430 0   133 12 12133         https://data.medicare.gov/resource/xubh-q36u/row-84ns~ra4k.iaii 101308 648804 2019-05-28 2018-12-31 25           25       34       59
4678 4678 TYLER COUNTY HOSPITAL 1100 WEST BLUFF WOODVILLE TX 75979 TYLER (409) 283-8141 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7752870 -94.4282200 0   457 48 48457         https://data.medicare.gov/resource/xubh-q36u/row-xfu9.wq3c~xr3i 450460 660053 2019-11-25 2019-06-30 25           25               25
2243 2243 JACKSON HOSPITAL 4250 HOSPITAL DR MARIANNA FL 32446 JACKSON (850) 526-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7874800 -85.2409320 0   63 12 12063         https://data.medicare.gov/resource/xubh-q36u/row-kd9h-xmn9-4awy 100142 645398 2019-03-01 2018-09-30 59 7         66               66
175 175 OAKDALE COMMUNITY HOSPITAL 130 N HOSPITAL DR OAKDALE LA 71463 ALLEN (318) 335-3700 Acute Care Hospitals Proprietary TRUE 30.8162640 -92.6445450 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-7xwr-vazc_74w6 190106 654443 2019-09-09 2019-03-31 46 3         49               49
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
3803 3803 GRADY GENERAL HOSPITAL 1155 5TH STREET, SE CAIRO GA 39828 GRADY (229) 377-0251 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.8633930 -84.2002610 0   131 13 13131         https://data.medicare.gov/resource/xubh-q36u/row-axxf.dqez-4s36 110121 644023 2019-02-25 2018-09-30 42 4         46               46
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
4604 4604 PECOS COUNTY MEMORIAL HOSPITAL 387 WEST I 10 FORT STOCKTON TX 79735 PECOS (432) 336-2004 Critical Access Hospitals Government - Local TRUE 30.9064090 -102.8823510 0   371 48 48371         https://data.medicare.gov/resource/xubh-q36u/row-d6ks_jvwm~jfzs 451389 655476 2019-10-18 2018-12-31 25           25               25
4509 4509 CHRISTUS JASPER MEMORIAL HOSPITAL 1275 MARVIN HANCOCK DRIVE JASPER TX 75951 JASPER (409) 384-5461 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.9076390 -94.0085330 0   241 48 48241         https://data.medicare.gov/resource/xubh-q36u/row-3yge~3w33.2wyx 450573 659898 2019-11-26 2019-06-30 34 6         40               40
4605 4605 IRAAN GENERAL HOSPITAL 600 HIGHWAY 349 NORTH IRAAN TX 79744 PECOS (432) 639-2575 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.9141890 -101.9066730 0   371 48 48371         https://data.medicare.gov/resource/xubh-q36u/row-gutj.3p8m~9z3e 451307 651245 2019-06-28 2018-12-31 14           14               14
1535 1535 GEORGE REGIONAL HEALTH SYSTEM 859 WINTER STREET LUCEDALE MS 39452 GEORGE (601) 947-3161 Acute Care Hospitals Government - Local TRUE 30.9222350 -88.5928530 0   39 28 28039         https://data.medicare.gov/resource/xubh-q36u/row-f75f~mexp.zvtb 250036 643798 2019-02-28 2018-09-30 36 6         42               42
4570 4570 MADISON ST JOSEPH HEALTH CENTER 100 WEST CROSS STREET MADISONVILLE TX 77864 MADISON (936) 348-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 30.9420460 -95.9099560 0   313 48 48313         https://data.medicare.gov/resource/xubh-q36u/row-nns8-bhuk_vxd6 451316 660055 2019-12-02 2019-06-30 15           15               15
436 436 BUNKIE GENERAL HOSPITAL 427 EVERGREEN STREET BUNKIE LA 71322 AVOYELLES (318) 346-6681 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.9524260 -92.1766470 0   9 22 22009         https://data.medicare.gov/resource/xubh-q36u/row-56d9~jh8q~59bh 191311 662210 2019-12-03 2019-06-30 25           25               25
1939 1939 ATMORE COMMUNITY HOSPITAL 401 MEDICAL PARK DRIVE ATMORE AL 36502 ESCAMBIA (251) 368-2500 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0165700 -87.4797350 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-nw85.p2jc-cva6 10169 645521 2019-02-28 2018-09-30 43 6         49               49
2298 2298 CLINCH MEMORIAL HOSPITAL 1050 VALDOSTA HIGHWAY HOMERVILLE GA 31634 CLINCH (912) 487-5211 Critical Access Hospitals Government - Local TRUE 31.0326510 -82.7638580 0   65 13 13065         https://data.medicare.gov/resource/xubh-q36u/row-6x28-ujdc_jsi5 111308 659942 2019-11-27 2019-06-30 15           15               15
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
4522 4522 DONALSONVILLE HOSPITAL INC 102 HOSPITAL CIR DONALSONVILLE GA 39845 SEMINOLE (229) 524-5217 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.0507070 -84.8801230 0   253 13 13253         https://data.medicare.gov/resource/xubh-q36u/row-nrim~ztp2.rnen 110194 659233 2019-11-21 2019-06-30 45           45 20     75       140
2568 2568 SOUTHWELL MEDICAL, A CAMPUS OF TRMC 260 MJ TAYLOR ROAD ADEL GA 31620 COOK (229) 896-8077 Acute Care Hospitals Proprietary TRUE 31.1091810 -83.4263720 0   75 13 13075         https://data.medicare.gov/resource/xubh-q36u/row-9kgg_7cj7~n9m2 110101 660504 2019-12-03 2019-06-30 33           33 12     95       140
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
4566 4566 HEART OF TEXAS MEMORIAL HOSPITAL 2008 NINE ROAD BRADY TX 76825 MC CULLOCH (325) 597-2901 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.1163340 -99.3466000 0   307 48 48307         https://data.medicare.gov/resource/xubh-q36u/row-kqsv.fye9_9h3c 451348 653867 2019-09-03 2019-03-31 14           14               14
4002 4002 WALTHALL COUNTY GENERAL HOSPITAL CAH 100 HOSPITAL DRIVE TYLERTOWN MS 39667 WALTHALL (601) 876-2122 Critical Access Hospitals Government - Local TRUE 31.1195830 -90.1556180 0   147 28 28147         https://data.medicare.gov/resource/xubh-q36u/row-zr2m~67zx~8i4c 251324 652148 2019-07-29 2018-09-30 25           25               25
1938 1938 D W MCMILLAN MEMORIAL HOSPITAL 1301 BELLEVILLE AVENUE BREWTON AL 36426 ESCAMBIA (251) 867-8061 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.1271050 -87.0723780 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-ug8v.qapr~xntq 10099 644201 2019-03-01 2018-09-30 38 8         46               46
435 435 AVOYELLES HOSPITAL 4231 HIGHWAY 1192 MARKSVILLE LA 71351 AVOYELLES (318) 253-8611 Acute Care Hospitals Proprietary TRUE 31.1431270 -92.0644330 0   9 22 22009         https://data.medicare.gov/resource/xubh-q36u/row-yf6k.hf5w.97ar 190099 661332 2019-12-09 2019-06-30 47 2         49               49
1651 1651 GREENE COUNTY HOSPITAL CAH 1017 JACKSON STREET LEAKESVILLE MS 39451 GREENE (601) 394-4135 Critical Access Hospitals Government - Local TRUE 31.1547640 -88.5626450 0   41 28 28041         https://data.medicare.gov/resource/xubh-q36u/row-w43a~rntf~brjp 251329 643805 2019-02-28 2018-09-30 7           7               7
4400 4400 MILLER COUNTY HOSPITAL 209 N CUTHBERT STREET COLQUITT GA 39837 MILLER (229) 758-4231 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.1754800 -84.7345480 0   201 13 13201         https://data.medicare.gov/resource/xubh-q36u/row-9k3y-ss2d~tagp 111305 659030 2019-11-20 2019-06-30 25           25       131       156
4610 4610 REAGAN MEMORIAL HOSPITAL 1300 N MAIN AVENUE BIG LAKE TX 76932 REAGAN (325) 844-2561 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2016510 -101.4615870 0   383 48 48383         https://data.medicare.gov/resource/xubh-q36u/row-3fmb~j2vv~wgtn 451301 651298 2019-03-05 2018-09-30 7           7               7
4 4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
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
4447 4447 MITCHELL COUNTY HOSPITAL 90 STEPHENS STREET CAMILLA GA 31730 MITCHELL (229) 336-5284 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2292770 -84.2050910 0   205 13 13205         https://data.medicare.gov/resource/xubh-q36u/row-wyam-jqj8.gyct 111331 644025 2019-02-25 2018-09-30 25           25       156       181
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
2959 2959 MARION GENERAL HOSPITAL 1560 SUMRALL RD COLUMBIA MS 39429 MARION (601) 736-6303 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.2563540 -89.8062730 0   91 28 28091         https://data.medicare.gov/resource/xubh-q36u/row-5fw7_6zqy_6c5t 250085 652594 2019-07-29 2018-09-30 43 6         49               49
1579 1579 MIZELL MEMORIAL HOSPITAL 702 N MAIN ST OPP AL 36467 COVINGTON (334) 493-3541 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.2919720 -86.2554150 0   39 1 1039         https://data.medicare.gov/resource/xubh-q36u/row-syeg~nab9~7ee4 10007 644003 2019-02-27 2018-09-30 40 5         45 14             59
1580 1580 ANDALUSIA HEALTH 849 SOUTH THREE NOTCH STREET ANDALUSIA AL 36420 COVINGTON (334) 222-8466 Acute Care Hospitals Proprietary TRUE 31.2974620 -86.4955990 0   39 1 1039         https://data.medicare.gov/resource/xubh-q36u/row-5sky_nfni.vnsr 10036 653819 2019-08-30 2019-03-31 75 8         83               83
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                                      
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
3151 3151 LIFEBRITE COMMUNITY HOSPITAL OF EARLY 11740 COLUMBIA STREET BLAKELY GA 39823 EARLY (229) 723-4241 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.3743820 -84.9462450 0   99 13 13099         https://data.medicare.gov/resource/xubh-q36u/row-x8g6~hmy4~rqqp 111314 646292 2019-04-01 2018-09-30 15           15       127       142
3293 3293 CRANE COUNTY HOSPITAL DISTRICT 1310 S ALFORD ST CRANE TX 79731 CRANE (432) 558-3555 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.3905650 -102.3493730 0   103 48 48103         https://data.medicare.gov/resource/xubh-q36u/row-q9vt-2wgg.5txf 451353 655608 2019-02-27 2018-09-30 25           25               25
1377 1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
3782 3782 WASHINGTON COUNTY HOSPITAL 14600 ST. STEPHENS AVENUE CHATOM AL 36518 WASHINGTON (251) 847-2223 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.4602960 -88.2352910 0   129 1 1129         https://data.medicare.gov/resource/xubh-q36u/row-kzeh_fuyx-rvjh 11300 644204 2019-03-01 2018-09-30 15           15       88       103
1546 1546 FRANKLIN COUNTY MEMORIAL HOSPITAL 40 UNION CHURCH RD MEADVILLE MS 39653 FRANKLIN (601) 384-5801 Critical Access Hospitals Government - Local TRUE 31.4732480 -90.8849240 0   37 28 28037         https://data.medicare.gov/resource/xubh-q36u/row-bz6b_zt43.ihwe 251330 655016 2019-10-02 2019-04-30 24           24               24
3132 3132 MONROE COUNTY HOSPITAL 2016 SOUTH ALABAMA AVENUE MONROEVILLE AL 36460 MONROE (251) 575-3111 Acute Care Hospitals Government - Local TRUE 31.4978390 -87.3194110 0   99 1 1099         https://data.medicare.gov/resource/xubh-q36u/row-4wyz~k8fh_i5ug 10120 645040 2019-03-13 2018-09-30 41 8         49               49
989 989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
4553 4553 LIMESTONE MEDICAL CENTER 701 MCCLINTIC DRIVE GROESBECK TX 76642 LIMESTONE (254) 729-3281 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.5319230 -96.5296210 0   293 48 48293         https://data.medicare.gov/resource/xubh-q36u/row-3e5u-tjfa_7eb2 451303 643539 2019-02-22 2018-09-30 20           20               20
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
270 270 BACON COUNTY HOSPITAL 302 SOUTH WAYNE STREET ALMA GA 31510 BACON (912) 632-8961 Critical Access Hospitals Voluntary non-profit - Other TRUE 31.5391100 -82.4596870 0   5 13 13005         https://data.medicare.gov/resource/xubh-q36u/row-fsgt~f6fy~f5qx 111327 659492 2019-11-26 2019-06-30 21 4         25       88       113
2612 2612 LAWRENCE COUNTY HOSPITAL CAH 1065 EAST BROAD ST / PO BOX 788 MONTICELLO MS 39654 LAWRENCE (601) 587-4051 Critical Access Hospitals Government - Local TRUE 31.5534190 -90.1002620 0   77 28 28077         https://data.medicare.gov/resource/xubh-q36u/row-rkyi-kmeu_5f45 251305 643909 2019-03-01 2018-09-30 25           25               25
2792 2792 SABINE MEDICAL CENTER 240 HIGHLAND DRIVE MANY LA 71449 SABINE (318) 256-1232 Acute Care Hospitals Proprietary TRUE 31.5604480 -93.4709830 0   85 22 22085         https://data.medicare.gov/resource/xubh-q36u/row-hq48.q6wx-zncf 190218 654331 2019-09-09 2019-03-31 48           48               48
4687 4687 WARD MEMORIAL HOSPITAL 406 SOUTH GARY ST MONAHANS TX 79756 WARD (432) 943-2511 Critical Access Hospitals Government - Local TRUE 31.5939700 -102.8845830 0   475 48 48475         https://data.medicare.gov/resource/xubh-q36u/row-sujn~5cdz-gz6m 451373 648492 2019-05-24 2018-12-31 21           21               21
2310 2310 JEFFERSON DAVIS COMMUNITY HOSPITAL CAH 1102 ROSE STREET PRENTISS MS 39474 JEFFERSON DAVIS (601) 792-4276 Critical Access Hospitals Government - Local TRUE 31.5939910 -89.8723810 0   65 28 28065         https://data.medicare.gov/resource/xubh-q36u/row-n4vm-retm~2x2d 251326 652938 2019-07-29 2018-09-30 25           25       60       85
4074 4074 IRWIN COUNTY HOSPITAL 710 N IRWIN AVENUE OCILLA GA 31774 IRWIN (229) 468-3845 Acute Care Hospitals Government - Hospital District or Authority FALSE 31.6027970 -83.2503310 0   155 13 13155         https://data.medicare.gov/resource/xubh-q36u/row-x4wh~4hz8~nrk6 110130 647117 2019-04-30 2018-11-30 34           34       30       64
1276 1276 COVINGTON COUNTY HOSPITAL CAH 701 SOUTH HOLLY AVENUE COLLINS MS 39428 COVINGTON (601) 765-6711 Critical Access Hospitals Government - Local TRUE 31.6382360 -89.5544240 0   31 28 28031         https://data.medicare.gov/resource/xubh-q36u/row-6qgj_6i6m-qfrk 251325 643804 2019-02-27 2018-09-30 25           25               25
4061 4061 WAYNE GENERAL HOSPITAL 950 MATTHEW DR WAYNESBORO MS 39367 WAYNE (601) 735-5151 Acute Care Hospitals Government - Local TRUE 31.6736010 -88.6333120 0   153 28 28153         https://data.medicare.gov/resource/xubh-q36u/row-tfe3.zk6i-7e8n 250077 644509 2019-02-27 2018-09-30 43 6         49               49
4554 4554 PARKVIEW REGIONAL HOSPITAL 600 SOUTH BONHAM STREET MEXIA TX 76667 LIMESTONE (254) 562-5332 Acute Care Hospitals Proprietary TRUE 31.6750590 -96.4800130 0   293 48 48293         https://data.medicare.gov/resource/xubh-q36u/row-eqsz~67zm-42nm 450400 653518 2019-09-05 2019-03-31 43 6         49 9             58
2140 2140 LASALLE GENERAL HOSPITAL 187 NINTH ST/HWY 84 WEST JENA LA 71342 LASALLE (318) 992-9200 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6831927 -92.1337360 1 GEOMETRIC_CENTER 59 22 22059         https://data.medicare.gov/resource/xubh-q36u/row-dbin~f8yn~yhkn 190145 644279 2019-03-01 2018-09-30 30           30 16             46
1631 1631 CRENSHAW COMMUNITY HOSPITAL 101 HOSPITAL CIRCLE LUVERNE AL 36049 CRENSHAW (334) 335-3374 Acute Care Hospitals Proprietary TRUE 31.6925950 -86.2661560 0   41 1 1041         https://data.medicare.gov/resource/xubh-q36u/row-7kz6.2gr2.w3cp 10008 647847 2019-05-15 2018-12-31 29           29 20             49
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
4374 4374 HAMILTON GENERAL HOSPITAL 400 N BROWN, BUILDING 1 HAMILTON TX 76531 HAMILTON (254) 386-3151 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7038520 -98.1134620 0   193 48 48193         https://data.medicare.gov/resource/xubh-q36u/row-u9ir-x2hd-6nbs                                      
2255 2255 JEFFERSON COUNTY HOSPITAL 870 S MAIN FAYETTE MS 39069 JEFFERSON (601) 786-3401 Acute Care Hospitals Government - Local TRUE 31.7048425 -91.0685345 1 ROOFTOP 63 28 28063         https://data.medicare.gov/resource/xubh-q36u/row-6ixf.trx6_t5pg 250060 644298 2019-03-04 2018-09-30 12           12 18             30
4148 4148 FREESTONE MEDICAL CENTER 125 NEWMAN ST FAIRFIELD TX 75840 FREESTONE (903) 389-1612 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7256440 -96.1696100 0   161 48 48161         https://data.medicare.gov/resource/xubh-q36u/row-7ffj_67x5_e9my 450658 657537 2019-01-31 2018-08-31 37           37               37
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
78 78 APPLING HOSPITAL 163 E TOLLISON STREET BAXLEY GA 31513 APPLING (912) 367-9841 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7687680 -82.3493510 0   1 13 13001         https://data.medicare.gov/resource/xubh-q36u/row-j4qq-twpw~u8jw 110071 658240 2019-03-29 2018-08-31 31 3         34 30     101       165

Next page

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