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

403 rows where hospital_ownership = "Government - Local" sorted by fy_end_date

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_irf_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

hospital_ownership ✖

  • Government - Local · 403 ✖
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
18 18 HOUSTON COUNTY COMMUNITY HOSPITAL 5001 EAST MAIN STREET ERIN TN 37061 HOUSTON (931) 289-4211 Critical Access Hospitals Government - Local TRUE 36.3195160 -87.6891930 0   83 47 47083         https://data.medicare.gov/resource/xubh-q36u/row-dt3z.s9ya.age2 441322 639931 2018-12-03 2018-06-30 25           25               25
147 147 BIG HORN HOSPITAL 17 N MILES HARDIN MT 59034 BIG HORN (406) 665-2310 Critical Access Hospitals Government - Local TRUE 45.7288560 -107.6170100 0   3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-2cgz.f5s8-gu8f 271338 652087 2018-11-27 2018-06-30 25           25               25
564 564 VALLEYWISE HEALTH MEDICAL CENTER 2601 EAST ROOSEVELT STREET PHOENIX AZ 85008 MARICOPA (602) 344-5011 Acute Care Hospitals Government - Local TRUE 33.4585250 -112.0264300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-c5qr_etcr-7dch 30022 661279 2018-12-03 2018-06-30 211 20   19 13   323 241             564
798 798 HOT SPRINGS COUNTY MEMORIAL HOSPITAL 150 EAST ARAPAHOE THERMOPOLIS WY 82443 HOT SPRINGS (307) 864-3121 Critical Access Hospitals Government - Local TRUE 43.6474320 -108.1995900 0   17 56 56017         https://data.medicare.gov/resource/xubh-q36u/row-ktb5~jtkf~b2ae 531304 640300 2018-11-30 2018-06-30 25           25               25
1483 1483 LAC/RANCHO LOS AMIGOS NATIONAL REHABILITATION CTR 7601 EAST IMPERIAL HIGHWAY DOWNEY CA 90242 LOS ANGELES (562) 401-7022 Acute Care Hospitals Government - Local FALSE 33.9293317 -118.1585885 1 ROOFTOP 37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rfj5_pyf7~7bni 50717 662350 2018-12-03 2018-06-30 89 12         101   109           210
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
2127 2127 FAIRVIEW DEVELOPMENTAL CENTER 2501 HARBOR BOULEVARD COSTA MESA CA 92626 ORANGE (714) 957-5000 Acute Care Hospitals Government - Local FALSE 33.6649120 -117.9192670 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-gyrb-ji8k_8vsj 50548 638176 2018-11-27 2018-06-30 30           30           1151   1181
2286 2286 RIVERSIDE UNIVERSITY HEALTH SYSTEM-MEDICAL CENTER 26520 CACTUS AVENUE MORENO VALLEY CA 92555 RIVERSIDE (951) 486-4000 Acute Care Hospitals Government - Local TRUE 33.9100540 -117.1958240 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-h5qt.qee8.h53s 50292 662336 2018-12-28 2018-06-30 354 45       8 439               439
2683 2683 SAN MATEO MEDICAL CENTER 222 W 39TH AVE SAN MATEO CA 94403 SAN MATEO (650) 573-2222 Acute Care Hospitals Government - Local TRUE 37.5301160 -122.2994060 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-n83i.z2gh_aca4 50113 660755 2018-12-03 2018-06-30 93 7         100 34     374       508
2919 2919 MARGARET R PARDEE MEMORIAL HOSPITAL 800 N JUSTICE ST HENDERSONVILLE NC 28791 HENDERSON (828) 696-1000 Acute Care Hospitals Government - Local TRUE 35.3208140 -82.4681530 0   89 37 37089 11700 Asheville-Brevard, NC Central Henderson County https://data.medicare.gov/resource/xubh-q36u/row-zt42_agis.ksd3 340017 658528 2018-11-29 2018-06-30 147 13         160               160
3420 3420 VENTURA COUNTY MEDICAL CENTER 300 HILLMONT AVENUE VENTURA CA 93003 VENTURA (805) 652-6075 Acute Care Hospitals Government - Local TRUE 34.2790550 -119.2543550 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-8hxa_nmwp_zdmb 50159 662323 2018-12-03 2018-06-30 196 52       24 272               272
4484 4484 SITKA COMMUNITY HOSPITAL 209 MOLLER DRIVE SITKA AK 99835 SITKA BOROUGH (907) 747-3241 Critical Access Hospitals Government - Local TRUE 57.0589920 -135.3459290 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-asew~ba2y_nt2p 21303 638783 2018-12-03 2018-06-30 12           12       15       27
731 731 DORMINY MEDICAL CENTER 200 PERRY HOUSE ROAD, BOX 1447 FITZGERALD GA 31750 BEN HILL (229) 424-7100 Acute Care Hospitals Government - Local TRUE 31.6979180 -83.2609750 0   17 13 13017 22340   Central Ben Hill County https://data.medicare.gov/resource/xubh-q36u/row-x5tq.yugi-ym8v 110073 658241 2019-01-02 2018-07-31 43 5         48 12             60
3362 3362 MARSHFIELD MEDICAL CENTER - LADYSMITH 900 COLLEGE AVE WEST LADYSMITH WI 54848 RUSK (715) 532-5561 Critical Access Hospitals Government - Local TRUE 45.4556050 -91.1111300 0   107 55 55107         https://data.medicare.gov/resource/xubh-q36u/row-bp7n_sbwx-c86k 521328 642554 2019-02-05 2018-08-31 21 4         25               25
4487 4487 WASHINGTON COUNTY MEMORIAL HOSPITAL 300 HEALTH WAY POTOSI MO 63664 WASHINGTON (573) 438-5451 Critical Access Hospitals Government - Local TRUE 37.9259900 -90.7731330 0   221 29 29221         https://data.medicare.gov/resource/xubh-q36u/row-f9yf_fkru~8ynh 261308 643043 2019-01-29 2018-08-31 25           25               25
121 121 ABBEVILLE AREA MEDICAL CENTER 420 THOMSON CIRCLE ABBEVILLE SC 29620 ABBEVILLE (864) 366-5011 Critical Access Hospitals Government - Local TRUE 34.1561250 -82.3801740 0   1 45 45001 24940 Greenville-Spartanburg-Anderson, SC Outlying Abbeville County https://data.medicare.gov/resource/xubh-q36u/row-v8xu.2huz_ubxe 421301 645182 2019-02-25 2018-09-30 19 6         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
317 317 ALLENDALE COUNTY HOSPITAL 1787 ALLENDALE FAIRFAX RD FAIRFAX SC 29827 ALLENDALE (803) 632-3311 Critical Access Hospitals Government - Local TRUE 32.9662250 -81.2477270 0   5 45 45005         https://data.medicare.gov/resource/xubh-q36u/row-bjdu~dq8g.u82d 421300 645444 2019-03-04 2018-09-30 25           25       44       69
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
510 510 ORTONVILLE AREA HEALTH SERVICES 450 EASTVOLD AVE ORTONVILLE MN 56278 BIG STONE (320) 839-2505 Critical Access Hospitals Government - Local TRUE 45.3147690 -96.4465630 0   11 27 27011         https://data.medicare.gov/resource/xubh-q36u/row-jt8y~id78.iwpi 241342 645770 2019-03-28 2018-09-30 25           25       51       76
513 513 COX BARTON COUNTY HOSPITAL 29 NW 1ST LANE LAMAR MO 64759 BARTON (417) 682-6081 Critical Access Hospitals Government - Local TRUE 37.5052820 -94.2994820 0   11 29 29011         https://data.medicare.gov/resource/xubh-q36u/row-8cv5-t4zj_7sig 261325 645577 2019-03-04 2018-09-30 21 4         25               25
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
616 616 BARAGA COUNTY MEMORIAL HOSPITAL 18341 US HIGHWAY 41 L' ANSE MI 49946 BARAGA (906) 524-3300 Critical Access Hospitals Government - Local TRUE 46.7344600 -88.4280420 0   13 26 26013         https://data.medicare.gov/resource/xubh-q36u/row-kzgx-j54h-paej 231307 645568 2019-03-05 2018-09-30 24           24               24
649 649 BEAUFORT COUNTY MEMORIAL HOSPITAL 955 RIBAUT RD BEAUFORT SC 29902 BEAUFORT (843) 522-5200 Acute Care Hospitals Government - Local TRUE 32.4172440 -80.6885460 0   13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-simj~c9x8.yqtx 420067 644559 2019-02-25 2018-09-30 155 12         167 14 14           195
666 666 NORTHEAST ALABAMA REGIONAL MEDICAL CENTER 400 EAST 10TH STREET ANNISTON AL 36207 CALHOUN (256) 235-5121 Acute Care Hospitals Government - Local TRUE 33.6571230 -85.8233530 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-ima9~p9t8~qh92 10078 644086 2019-02-28 2018-09-30 232 18         250 20             270
838 838 CHOCTAW REGIONAL MEDICAL CENTER 8613 MS HWY 12 ACKERMAN MS 39735 CHOCTAW (662) 285-4400 Critical Access Hospitals Government - Local TRUE 33.3184650 -89.1823040 0   19 28 28019         https://data.medicare.gov/resource/xubh-q36u/row-9nt3~77et_z9mg 251334 643914 2019-03-01 2018-09-30 15           15         73     88
1060 1060 MAGNOLIA HOSPITAL 101 HOSPITAL DRIVE MAGNOLIA AR 71754 COLUMBIA (870) 235-3000 Acute Care Hospitals Government - Local TRUE 33.2751230 -93.2400710 0   27 5 5027 31620   Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-ed5b-6fgx_6hyv 40067 644209 2019-03-01 2018-09-30 24 6         30               30
1134 1134 CARIBOU MEMORIAL HOSPITAL 300 SOUTH 3RD WEST SODA SPRINGS ID 83276 CARIBOU (208) 547-3341 Critical Access Hospitals Government - Local TRUE 42.6522350 -111.6133540 0   29 16 16029         https://data.medicare.gov/resource/xubh-q36u/row-k69a-4kn6-dfne 131309 644028 2019-02-28 2018-09-30 25           25       30       55
1165 1165 ASANTE ASHLAND COMMUNITY HOSPITAL 280 MAPLE STREET ASHLAND OR 97520 JACKSON (541) 201-4017 Acute Care Hospitals Government - Local TRUE 42.2064450 -122.7251290 0   29 41 41029 32780 Medford-Grants Pass, OR Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xsnr-xsme.wejp 380005 644057 2019-02-27 2018-09-30 34 4         38               38
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
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
1396 1396 FORREST GENERAL HOSPITAL 6051 US HIGHWAY 49 HATTIESBURG MS 39404 FORREST (601) 288-7000 Acute Care Hospitals Government - Local TRUE 31.3185784 -89.3295264 1 ROOFTOP 35 28 28035 25620   Central Forrest County https://data.medicare.gov/resource/xubh-q36u/row-sww7-fvy2-pqtj 250078 659303 2019-10-30 2018-09-30 379 40 8       427   24   20       471
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
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
1641 1641 FRANKLIN COUNTY MEDICAL CENTER 44 NORTH FIRST EAST PRESTON ID 83263 FRANKLIN (208) 852-0137 Critical Access Hospitals Government - Local TRUE 42.0983790 -111.8754670 0   41 16 16041 30860   Outlying Franklin County https://data.medicare.gov/resource/xubh-q36u/row-9du2~qaxa~z8nm 131322 645243 2019-03-08 2018-09-30 20           20       35       55
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
1658 1658 VIDANT CHOWAN HOSPITAL 211 VIRGINIA RD EDENTON NC 27932 CHOWAN (252) 482-8451 Critical Access Hospitals Government - Local TRUE 36.0707740 -76.6090930 0   41 37 37041         https://data.medicare.gov/resource/xubh-q36u/row-trbd~xc39_h8ri 341318 644158 2019-02-28 2018-09-30 21 4         25               25
1731 1731 VALOR HEALTH 1202 EAST LOCUST STREET EMMETT ID 83617 GEM (208) 365-3561 Critical Access Hospitals Government - Local TRUE 43.8790780 -116.4852550 0   45 16 16045 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Gem County https://data.medicare.gov/resource/xubh-q36u/row-cch8-kmmd-nmhb 131318 644635 2019-02-28 2018-09-30 13           13               13
1742 1742 OCHSNER MEDICAL CENTER-HANCOCK 149 DRINKWATER BLVD BAY SAINT LOUIS MS 39520 HANCOCK (228) 467-8600 Acute Care Hospitals Government - Local TRUE 30.3130400 -89.3556570 0   45 28 28045 25060   Central Hancock County https://data.medicare.gov/resource/xubh-q36u/row-8qr6~e2iu-2dck 250162 645723 2019-03-01 2018-09-30 41 6         47               47
1788 1788 MEMORIAL HOSPITAL AT GULFPORT 4500 13TH STREET GULFPORT MS 39502 HARRISON (228) 867-4000 Acute Care Hospitals Government - Local TRUE 30.3669280 -89.1149070 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-s5rd_v3j6.9dir 250019 640104 2018-12-26 2018-09-30 232 26         281               281
1790 1790 EXCELSIOR SPRINGS HOSPITAL 1700 RAINBOW BOULEVARD EXCELSIOR SPRINGS MO 64024 CLAY (816) 630-6081 Critical Access Hospitals Government - Local TRUE 39.3622170 -94.2365190 0   47 29 29047 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-7pwj-2gs7.gpk5 261322 644516 2019-02-27 2018-09-30 25           25         60     85
2004 2004 CRITTENDEN COMMUNITY HOSPITAL 520 WEST GUM STREET MARION KY 42064 CRITTENDEN (270) 965-1001 Acute Care Hospitals Government - Local TRUE 37.3296160 -88.0919450 0   55 21 21055         https://data.medicare.gov/resource/xubh-q36u/row-29y5_rw8y-4sga 180095 643771 2019-03-01 2018-09-30 48           48               48
2135 2135 STEELE MEMORIAL MEDICAL CENTER 203 SOUTH DAISY STREET SALMON ID 83467 LEMHI (208) 756-5600 Critical Access Hospitals Government - Local TRUE 45.1733110 -113.8909180 0   59 16 16059         https://data.medicare.gov/resource/xubh-q36u/row-frkw_jutq_kwk4 131305 645073 2019-03-05 2018-09-30 18           18               18
2144 2144 SINGING RIVER HEALTH SYSTEM 2809 DENNY AV PASCAGOULA MS 39581 JACKSON (228) 809-5000 Acute Care Hospitals Government - Local TRUE 30.3748710 -88.5324040 0   59 28 28059 25060   Outlying Jackson County https://data.medicare.gov/resource/xubh-q36u/row-tcrr_p47m-6bi7 250040 645722 2019-03-01 2018-09-30 272 48         320 14 20   36       390
2159 2159 HARPER COUNTY COMMUNITY HOSPITAL 1003 US HIGHWAY 64 NORTH BUFFALO OK 73834 HARPER (580) 735-2555 Critical Access Hospitals Government - Local TRUE 36.8449660 -99.6293020 0   59 40 40059         https://data.medicare.gov/resource/xubh-q36u/row-ubpf.zpwz~4xju 371324 643003 2019-02-11 2018-09-30 15           15               15
2195 2195 JASPER GENERAL HOSPITAL 15 SOUTH 6TH STREET BAY SPRINGS MS 39422 JASPER (601) 764-2101 Acute Care Hospitals Government - Local FALSE 31.9766880 -89.2905550 0   61 28 28061 29860   Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-y8rq~vqyv_stwk 250018 643796 2019-02-27 2018-09-30 20           20               20
2210 2210 VIDANT DUPLIN HOSPITAL 401 N MAIN ST KENANSVILLE NC 28349 DUPLIN (910) 296-0941 Acute Care Hospitals Government - Local TRUE 34.9647690 -77.9604790 0   61 37 37061         https://data.medicare.gov/resource/xubh-q36u/row-3z8q-ur44-gq7x 340120 643929 2019-02-28 2018-09-30 40 9         49 25             74
2238 2238 GREENE COUNTY HOSPITAL 509 WILSON AVENUE EUTAW AL 35462 GREENE (205) 372-3388 Acute Care Hospitals Government - Local TRUE 32.8447440 -87.8893070 0   63 1 1063         https://data.medicare.gov/resource/xubh-q36u/row-dyit.ypt9~f4e7 10051 645036 2019-03-04 2018-09-30 20           20       72       92
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
2299 2299 MADISON MEMORIAL HOSPITAL 450 EAST MAIN STREET REXBURG ID 83440 MADISON (208) 359-6900 Acute Care Hospitals Government - Local TRUE 43.8260510 -111.7731480 0   65 16 16065 39940 Idaho Falls-Rexburg-Blackfoot, ID Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-x7qh_3ndv.ii77 130025 643024 2019-02-05 2018-09-30 49 4         67               67
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
2317 2317 VIDANT EDGECOMBE HOSPITAL 111 HOSPITAL DR TARBORO NC 27886 EDGECOMBE (252) 641-7700 Acute Care Hospitals Government - Local TRUE 35.9218850 -77.5569940 0   65 37 37065 40580 Rocky Mount-Wilson-Roanoke Rapids, NC Central Edgecombe County https://data.medicare.gov/resource/xubh-q36u/row-9nuq.ij7s_3aca 340107 643926 2019-02-28 2018-09-30 86 15         101   16           117
2345 2345 MINIDOKA MEMORIAL HOSPITAL 1224 8TH STREET RUPERT ID 83350 MINIDOKA (208) 436-0481 Critical Access Hospitals Government - Local TRUE 42.6196250 -113.6853620 0   67 16 16067 15420   Outlying Minidoka County https://data.medicare.gov/resource/xubh-q36u/row-m4t9~2798.xb46 131319 643405 2019-02-26 2018-09-30 16           16       46       62
2359 2359 SOUTH CENTRAL REG MED CTR 1220 JEFFERSON ST BOX 607 LAUREL MS 39440 JONES (601) 426-4000 Acute Care Hospitals Government - Local TRUE 31.6859110 -89.1413500 0   67 28 28067 29860   Central Jones County https://data.medicare.gov/resource/xubh-q36u/row-5i4a~fevp-cvm5 250058 644753 2019-02-27 2018-09-30 254 14         268               268
2529 2529 GREENWOOD COUNTY HOSPITAL 100 W 16TH STREET EUREKA KS 67045 GREENWOOD (620) 583-7451 Critical Access Hospitals Government - Local TRUE 37.8353150 -96.2941800 0   73 20 20073         https://data.medicare.gov/resource/xubh-q36u/row-g9zc.t83r_s62e 171339 645085 2019-02-28 2018-09-30 25           25               25
2583 2583 TRMC OF ORANGEBURG & CALHOUN 3000 ST MATTHEWS RD BOX 1806 ORANGEBURG SC 29115 ORANGEBURG (803) 533-2460 Acute Care Hospitals Government - Local FALSE 33.5401756 -80.8306233 1 ROOFTOP 75 45 45075 36700 Columbia-Orangeburg-Newberry, SC Central Orangeburg County https://data.medicare.gov/resource/xubh-q36u/row-n6wq.i5zs_x785 420068 645174 2019-02-28 2018-09-30 231 20         251 15 20           286
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
2618 2618 GRANVILLE HEALTH SYSTEMS 1010 COLLEGE ST OXFORD NC 27565 GRANVILLE (919) 690-3000 Acute Care Hospitals Government - Local TRUE 36.3263380 -78.5944070 0   77 37 37077 37080 Raleigh-Durham-Chapel Hill, NC Central Granville County https://data.medicare.gov/resource/xubh-q36u/row-m2jd_5kps_77k4 340127 645436 2019-03-01 2018-09-30 36 6         42       80       122
2630 2630 CLAY COUNTY MEMORIAL HOSPITAL 310 W SOUTH STREET HENRIETTA TX 76365 CLAY (940) 538-5621 Critical Access Hospitals Government - Local TRUE 33.8139220 -98.1979950 0   77 48 48077 48660   Outlying Clay County https://data.medicare.gov/resource/xubh-q36u/row-tnt6-7h3c_zq5a 451362 643465 2019-02-25 2018-09-30 25           25               25
2753 2753 GREENWOOD LEFLORE HOSPITAL 1401 RIVER RD GREENWOOD MS 38935 LEFLORE (662) 459-7561 Acute Care Hospitals Government - Local TRUE 33.5182540 -90.2001890 0   83 28 28083 24900   Central Leflore County https://data.medicare.gov/resource/xubh-q36u/row-h4t8-zied.hz4k 250099 644302 2019-02-28 2018-09-30 164 9         173   20           193
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
3158 3158 SEDAN CITY HOSPITAL 300 NORTH STREET SEDAN KS 67361 CHAUTAUQUA (620) 725-3115 Critical Access Hospitals Government - Local TRUE 37.1714400 -95.1030540 0   99 20 20099 37660   Central Labette County https://data.medicare.gov/resource/xubh-q36u/row-vdwb_dtrj-qnpi 171318 644727 2019-02-26 2018-09-30 17           17               17
3168 3168 NESHOBA COUNTY GENERAL HOSPITAL 1001 HOLLAND AVENUE PHILADELPHIA MS 39350 NESHOBA (601) 663-1200 Acute Care Hospitals Government - Local TRUE 32.7578160 -89.1054150 0   99 28 28099         https://data.medicare.gov/resource/xubh-q36u/row-k6bw.w463_gjg8 250043 643619 2019-02-26 2018-09-30 38           38 10     160       208
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
3317 3317 OCH REGIONAL MEDICAL CENTER 400 HOSPITAL ROAD /MAIL PO BOX 1506 STARKVILLE MS 39759 OKTIBBEHA (662) 323-4320 Acute Care Hospitals Government - Local TRUE 33.4749570 -88.8205540 0   105 28 28105 44260   Central Oktibbeha County https://data.medicare.gov/resource/xubh-q36u/row-pqyp-ajyc_anci 250050 654588 2019-09-18 2018-09-30 82 6         88               88
3333 3333 PICKENS COUNTY MEDICAL CENTER 241 ROBERT K WILSON DRIVE CARROLLTON AL 35447 PICKENS (205) 367-8111 Acute Care Hospitals Government - Local TRUE 33.2748070 -88.0896730 0   107 1 1107 46220   Outlying Pickens County https://data.medicare.gov/resource/xubh-q36u/row-zn5h.i3rc.njwh 10109 644006 2019-03-01 2018-09-30 36 4         40 10             50
3376 3376 PEARL RIVER COUNTY HOSPITAL & NURSING HOME 305 WEST MOODY STREET POPLARVILLE MS 39470 PEARL RIVER (601) 795-4543 Critical Access Hospitals Government - Local TRUE 30.8570980 -89.5414790 0   109 28 28109 38100 New Orleans-Metairie-Hammond, LA-MS Central Pearl River County https://data.medicare.gov/resource/xubh-q36u/row-sbq8~9npp-fvb5 251333 651568 2019-07-09 2018-09-30 24           24           120   144
3475 3475 SOUTHWEST MS REGIONAL MEDICAL CENTER 215 MARION AV BOX 1307 MCCOMB MS 39649 PIKE (601) 249-5500 Acute Care Hospitals Government - Local TRUE 31.2509484 -90.4747234 1 ROOFTOP 113 28 28113 32620   Central Pike County https://data.medicare.gov/resource/xubh-q36u/row-h3gs~88sx_7rs8 250097 645003 2019-03-01 2018-09-30 132 16 12       160               160
3723 3723 SHARKEY ISSAQUENA COMMUNITY HOSPITAL 47 SOUTH FOURTH ST ROLLING FORK MS 39159 SHARKEY (662) 873-4395 Acute Care Hospitals Government - Local TRUE 32.9053730 -90.8849890 0   125 28 28125         https://data.medicare.gov/resource/xubh-q36u/row-xv4d_iffv-iegn 250079 643907 2019-03-04 2018-09-30 19           19 10     54       83
3789 3789 NEW HANOVER REGIONAL MEDICAL CENTER 2131 S 17TH ST BOX 9000 WILMINGTON NC 28402 NEW HANOVER (910) 343-7000 Acute Care Hospitals Government - Local TRUE 34.2061830 -77.9241820 0   129 37 37129 48900   Central New Hanover County https://data.medicare.gov/resource/xubh-q36u/row-88y4~nwby~bew7 340141 646693 2019-04-12 2018-09-30 514 29 28     51 622 60 56           738
3832 3832 NORTH SUNFLOWER MEDICAL CENTER CAH 840 NORTH OAK AVENUE RULEVILLE MS 38771 SUNFLOWER (662) 756-2711 Critical Access Hospitals Government - Local TRUE 33.7348390 -90.5468230 0   133 28 28133 26940 Cleveland-Indianola, MS Central Sunflower County https://data.medicare.gov/resource/xubh-q36u/row-aeyn_exnd~v4c3 251318 644041 2019-03-04 2018-09-30 25           25 10             35
3833 3833 SOUTH SUNFLOWER COUNTY HOSPITAL 121 E BAKER ST INDIANOLA MS 38751 SUNFLOWER (662) 887-5235 Acute Care Hospitals Government - Local TRUE 33.4572340 -90.6502400 0   133 28 28133 26940 Cleveland-Indianola, MS Central Sunflower County https://data.medicare.gov/resource/xubh-q36u/row-bmwa.aic3-zxsr 250095 644301 2019-03-01 2018-09-30 47           47               47
3858 3858 TALLAHATCHIE CRITICAL ACCESS HOSPITAL 201 SOUTH MARKET ST / PO BOX 230 CHARLESTON MS 38921 TALLAHATCHIE (662) 647-5535 Critical Access Hospitals Government - Local TRUE 34.0050790 -90.0581650 0   135 28 28135         https://data.medicare.gov/resource/xubh-q36u/row-avrr~zg9m~xqab 251304 644307 2019-02-28 2018-09-30 9           9               9
3887 3887 NORTHEAST GEORGIA MEDICAL CENTER, INC 743 SPRING STREET GAINESVILLE GA 30501 HALL (770) 535-3553 Acute Care Hospitals Government - Local TRUE 34.3033500 -83.8173700 0   139 13 13139 23580 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Hall County https://data.medicare.gov/resource/xubh-q36u/row-7syr~f3ei~dkan 110029 645060 2019-03-01 2018-09-30 460 85         545 54 24   261       884
3896 3896 TIPPAH COUNTY HOSPITAL 1005 CITY AVE NORTH RIPLEY MS 38663 TIPPAH (662) 837-9221 Critical Access Hospitals Government - Local TRUE 34.7393220 -88.9495120 0   139 28 28139         https://data.medicare.gov/resource/xubh-q36u/row-cezn_vrxn~h3x4 251337 646103 2018-12-26 2018-09-30 25           25 10     40       75
3922 3922 PENDER MEMORIAL HOSPITAL 507 E FREMONT ST BURGAW NC 28425 PENDER (910) 300-4004 Critical Access Hospitals Government - Local TRUE 34.5512630 -77.9204230 0   141 37 37141 48900   Outlying Pender County https://data.medicare.gov/resource/xubh-q36u/row-7fvf-phgu_s8i7 341307 659598 2019-11-25 2018-09-30 25           25       43       68
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
4018 4018 STURGIS HOSPITAL 916 MYRTLE AVE STURGIS MI 49091 ST. JOSEPH (269) 651-7824 Acute Care Hospitals Government - Local TRUE 41.7941930 -85.4073080 0   149 26 26149 44780 Kalamazoo-Battle Creek-Portage, MI Central St. Joseph County https://data.medicare.gov/resource/xubh-q36u/row-pcw2.cypd.6m9k 230096 644293 2019-02-20 2018-09-30 45   4       49               49
4040 4040 APPLETON MUNICIPAL HOSPITAL 30 SOUTH BEHL STREET APPLETON MN 56208 SWIFT (320) 289-8508 Critical Access Hospitals Government - Local TRUE 45.1996580 -96.0092240 0   151 27 27151         https://data.medicare.gov/resource/xubh-q36u/row-egz5_fa7v_8upj 241341 656449 2019-10-21 2018-09-30 15           15       50       65
4041 4041 DELTA REGIONAL MEDICAL CENTER 1400 E UNION ST GREENVILLE MS 38704 WASHINGTON (662) 378-3783 Acute Care Hospitals Government - Local TRUE 33.4099070 -91.0352430 0   151 28 28151 24740   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-yix8-b75e-8aep 250082 660822 2019-11-18 2018-09-30 155 22         177   24           201
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
4117 4117 JASPER MEMORIAL HOSPITAL 898 COLLEGE STREET MONTICELLO GA 31064 JASPER (706) 468-6411 Critical Access Hospitals Government - Local TRUE 33.3139820 -83.6868770 0   159 13 13159 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-7m3n_3mxm~mxsc 111303 645064 2019-03-04 2018-09-30 12           12       55       67
4143 4143 YALOBUSHA GENERAL HOSPITAL 630 SOUTH MAIN STREET WATER VALLEY MS 38965 YALOBUSHA (662) 473-1411 Acute Care Hospitals Government - Local FALSE 34.1307000 -89.6410130 0   161 28 28161         https://data.medicare.gov/resource/xubh-q36u/row-f4gk_jx8c-563i 250061 643906 2019-03-04 2018-09-30 26           26           122   148
4178 4178 SAMPSON REGIONAL MEDICAL CENTER 607 BEAMAN ST CLINTON NC 28328 SAMPSON (910) 592-8511 Acute Care Hospitals Government - Local TRUE 35.0077830 -78.3236350 0   163 37 37163         https://data.medicare.gov/resource/xubh-q36u/row-a9b2_fhm6_47x6 340024 643924 2019-02-28 2018-09-30 63 8         71               71
4359 4359 WATAUGA MEDICAL CENTER 336 DEERFIELD ROAD BOONE NC 28607 WATAUGA (828) 263-1211 Acute Care Hospitals Government - Local TRUE 36.1987530 -81.6524230 0   189 37 37189 14380   Central Watauga County https://data.medicare.gov/resource/xubh-q36u/row-p9id_sdf3_mtw8 340051 645346 2019-02-28 2018-09-30 81 10       4 95               95
4542 4542 LAMB HEALTHCARE CENTER 1500 S SUNSET LITTLEFIELD TX 79339 LAMB (806) 385-6411 Acute Care Hospitals Government - Local TRUE 33.9116250 -102.3454390 0   279 48 48279         https://data.medicare.gov/resource/xubh-q36u/row-wpjt.5mwq_y5d4 450698 643967 2019-03-01 2018-09-30 42           42               42
4578 4578 MIDLAND MEMORIAL HOSPITAL 400 ROSALIND REDFERN GROVER PARKWAY MIDLAND TX 79701 MIDLAND (432) 685-1111 Acute Care Hospitals Government - Local TRUE 31.9974940 -102.0999760 0   329 48 48329 33260 Midland-Odessa, TX Central Midland County https://data.medicare.gov/resource/xubh-q36u/row-cs6x~ax5d_pb7f 450133 647760 2019-05-16 2018-09-30 180   48       228               228
4706 4706 WINKLER COUNTY MEMORIAL HOSPITAL 821 JEFFEE DRIVE KERMIT TX 79745 WINKLER (432) 586-5865 Critical Access Hospitals Government - Local TRUE 31.8497390 -103.0899160 0   495 48 48495         https://data.medicare.gov/resource/xubh-q36u/row-qbhw-92m9~uia9 451314 643975 2019-02-28 2018-09-30 19           19               19
4276 4276 RAY COUNTY MEMORIAL HOSPITAL 904 WOLLARD BOULEVARD RICHMOND MO 64085 RAY (816) 470-5432 Critical Access Hospitals Government - Local TRUE 39.2643940 -93.9561730 0   177 29 29177 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Ray County https://data.medicare.gov/resource/xubh-q36u/row-mqv3.5d72~fjx6 261327 644761 2019-02-27 2018-10-31 25           25               25
4463 4463 SULLIVAN COUNTY MEMORIAL HOSPITAL 630 WEST THIRD STREET MILAN MO 63556 SULLIVAN (660) 265-4212 Critical Access Hospitals Government - Local TRUE 40.2021740 -93.1311360 0   211 29 29211         https://data.medicare.gov/resource/xubh-q36u/row-puyt~jfux-w58a 261306 659511 2019-02-26 2018-10-31 17           17         9     26
4536 4536 SEARHC WRANGELL MEDICAL CENTER-CAH 310 BENNETT STREET PO BOX 1081 WRANGELL AK 99929 WRANGELL CITY AND BOROUGH (907) 874-7000 Critical Access Hospitals Government - Local FALSE 56.4716460 -132.3764140 0   275 2 2275         https://data.medicare.gov/resource/xubh-q36u/row-n33k~as59_upeg 21305 645317 2019-03-18 2018-10-31 8           8       14       22
4365 4365 SUMNER COMMUNITY HOSPITAL 1323 NORTH A STREET WELLINGTON KS 67152 SUMNER (620) 326-7451 Acute Care Hospitals Government - Local TRUE 37.2778150 -97.3942510 0   191 20 20191 48620 Wichita-Arkansas City-Winfield, KS Outlying Sumner County https://data.medicare.gov/resource/xubh-q36u/row-cuq3.h3r6~ee87 170039 651273 2019-07-01 2018-11-18 42           42 10     9       61
1220 1220 JOHN H STROGER JR HOSPITAL 1901 W HARRISON ST CHICAGO IL 60612 COOK (312) 864-6000 Acute Care Hospitals Government - Local TRUE 41.8740410 -87.6743110 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-2ss5~bvsp.bpf4 140124 659251 2019-11-07 2018-11-30 310 32   8 14   448               448
1225 1225 PROVIDENT HOSPITAL OF CHICAGO 500 E 51ST ST CHICAGO IL 60615 COOK (312) 572-2000 Acute Care Hospitals Government - Local TRUE 41.8021580 -87.6141930 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-knkg_mg7f-2emf 140300 659411 2019-11-05 2018-11-30 25           25               25
13 13 NORTH VALLEY HOSPITAL 203 SOUTH WESTERN TONASKET WA 98855 OKANOGAN (509) 486-2151 Critical Access Hospitals Government - Local TRUE 48.7068190 -119.4395970 0   47 53 53047         https://data.medicare.gov/resource/xubh-q36u/row-dpfb.gqi2_r2fh 501321 648787 2019-05-29 2018-12-31 21           21               21
28 28 MORTON COUNTY HOSPITAL 445 N HILLTOP ELKHART KS 67950 MORTON (620) 697-2141 Acute Care Hospitals Government - Local TRUE 37.0019009 -101.9053025 1 ROOFTOP 129 20 20129         https://data.medicare.gov/resource/xubh-q36u/row-uv4u~7jpi~swm6 170166 651519 2019-07-09 2018-12-31 26           26               26
88 88 ADAMS MEMORIAL HOSPITAL 1100 MERCER AVE DECATUR IN 46733 ADAMS (260) 724-2145 Critical Access Hospitals Government - Local TRUE 40.8179660 -84.9125350 0   1 18 18001 19540 Fort Wayne-Huntington-Auburn, IN Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-vdys.bcxa-gdh7 151330 649100 2019-05-30 2018-12-31 21 4         25               25
117 117 ADAMS COUNTY REGIONAL MEDICAL CENTER 230 MEDICAL CENTER DRIVE SEAMAN OH 45679 ADAMS (937) 386-3400 Critical Access Hospitals Government - Local TRUE 38.9338480 -83.5856120 0   1 39 39001         https://data.medicare.gov/resource/xubh-q36u/row-wb9j-jzwz-2xmu 361326 649329 2019-05-30 2018-12-31 25           25               25
176 176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
212 212 BERGEN NEW BRIDGE MEDICAL CENTER 230 EAST RIDGEWOOD AVE PARAMUS NJ 7652 BERGEN (201) 967-4000 Acute Care Hospitals Government - Local TRUE 40.9586020 -74.0621510 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-uajf_w5ak.e5wh 310058 651020 2019-06-03 2018-12-31 118 9         127 319     574       1020

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