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

4,766 rows sorted by RPT_REC_NUM

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, burn_beds, subprovider_oth_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
3238 3238 SHRINERS HOSPITALS FOR CHILDREN - PHILADELPHIA 3551 N BROAD STREET PHILADELPHIA PA 19104 PHILADELPHIA (215) 430-4000 Childrens Voluntary non-profit - Other FALSE 40.0069680 -75.1516990 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-iwpu.igc9.39y9 393309 629311 2018-05-30 2017-12-31                              
191 191 HARMON HOSPITAL 2170 EAST HARMON AVENUE LAS VEGAS NV 89119 CLARK (702) 794-0100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.1073690 -115.1219920 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-qtzp-aczd_sysf 290042 629833 2018-05-31 2017-12-31                              
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
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
982 982 CENTRAL VALLEY MEDICAL CENTER - CAH 48 WEST 1500 NORTH NEPHI UT 84648 JUAB (435) 623-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.7305870 -111.8372150 0   23 49 49023 39340 Salt Lake City-Provo-Orem, UT Outlying Juab County https://data.medicare.gov/resource/xubh-q36u/row-chs9.w8rs-dsc2 461304 637950 2018-11-21 2018-06-30 25           25               25
851 851 CAVALIER COUNTY MEMORIAL HOSPITAL ASSOCIATION 909 2ND ST LANGDON ND 58249 CAVALIER (701) 256-6100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7612430 -98.3666610 0   19 38 38019         https://data.medicare.gov/resource/xubh-q36u/row-m8nv.tvsx-unkm 351323 638003 2018-11-28 2018-06-30 20           20               20
3058 3058 TOWNER COUNTY MEDICAL CENTER HWY 281 N CANDO ND 58324 TOWNER (701) 968-4411 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4931522 -99.2110430 1 ROOFTOP 95 38 38095         https://data.medicare.gov/resource/xubh-q36u/row-8pd6_eppf-kx3r 351331 638004 2018-11-28 2018-06-30 20           20       30   5   55
3338 3338 PORTERVILLE DEVELOPMENTAL CENTER 26501 AVENUE 140 PORTERVILLE CA 93257 TULARE (559) 782-2222 Acute Care Hospitals Government - State FALSE 36.0439080 -118.9804830 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-8jhm_m9d6-frtp 50546 638174 2018-11-27 2018-06-30 44           44           1182   1226
3080 3080 SONOMA DEVELOPMENTAL CENTER 15000 ARNOLD DRIVE / P O BOX 1493 ELDRIDGE CA 95431 SONOMA (707) 938-6000 Acute Care Hospitals Government - State FALSE 38.3490270 -122.5169100 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-j6wx.73xx-wqrm 50547 638175 2018-11-27 2018-06-30 13           13           963   976
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
1468 1468 CATALINA ISLAND MEDICAL CENTER 100 FALLS CANYON ROAD AVALON CA 90704 LOS ANGELES (310) 510-0700 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.3390790 -118.3304770 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8vi9~ashp_y9rx 51307 638364 2018-11-29 2018-06-30 8           8       4       12
974 974 ST LUKE'S HOSPITAL 702 1ST ST SW CROSBY ND 58730 DIVIDE (701) 965-6384 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.9067080 -103.2982300 0   23 38 38023         https://data.medicare.gov/resource/xubh-q36u/row-pn67~uvq9.k3y8 351325 638546 2018-11-26 2018-06-30 15           15       40       55
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
1195 1195 CODY REGIONAL HEALTH 707 SHERIDAN AVENUE CODY WY 82414 PARK (307) 578-2488 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5260710 -109.0735760 0   29 56 56029         https://data.medicare.gov/resource/xubh-q36u/row-hbhj.vs4q~3zsw 531312 638925 2018-12-03 2018-06-30 21 4         25       94       119
4204 4204 HEGG MEMORIAL HEALTH CENTER 1202 21ST AVENUE ROCK VALLEY IA 51247 SIOUX (712) 476-8000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2016930 -96.2850860 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-5p5r_j23k-rsrv 161336 639251 2018-12-03 2018-06-30 25           25           60   85
3114 3114 PIONEER MEDICAL CENTER 301 W 7TH AVE BIG TIMBER MT 59011 SWEET GRASS (406) 932-4603 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8284800 -109.9524270 0   97 30 30097         https://data.medicare.gov/resource/xubh-q36u/row-y6u6-i6dq_6uh8 271313 639315 2018-12-03 2018-06-30 25           25               25
3778 3778 CENTRO CARDIOVASCULAR AVENIDA AMERICO MIRANDA, ENTRADA PRINCIPAL CM RIO PIEDRAS PR 936 SAN JUAN (787) 754-8500 Acute Care Hospitals Government - State FALSE 18.3997905 -66.0681500 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-n57n_rm6c-sekq 400124 639357 2018-12-12 2018-06-30 114 50         164               164
543 543 CABELL HUNTINGTON HOSPITAL INC 1340 HAL GREER BOULEVARD HUNTINGTON WV 25701 CABELL (304) 526-2192 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4100220 -82.4284110 0   11 54 54011 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Cabell County https://data.medicare.gov/resource/xubh-q36u/row-yhap.a3pm.rgzf 510055 639552 2018-12-14 2018-09-30 225 20   6 18   330               330
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
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
509 509 ASCENSION STANDISH HOSPITAL 805 W CEDAR ST STANDISH MI 48658 ARENAC (517) 846-4521 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9828300 -83.9693520 0   11 26 26011         https://data.medicare.gov/resource/xubh-q36u/row-3a56-bznt.bz29 231305 639965 2018-12-12 2018-06-30 20 5         25       29       54
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
4257 4257 SWAIN COUNTY HOSPITAL 45 PLATEAU STREET BRYSON CITY NC 28713 SWAIN (828) 488-2155 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.4351230 -83.4446880 0   173 37 37173         https://data.medicare.gov/resource/xubh-q36u/row-xctq~5kw9.id78 341305 640115 2018-12-27 2018-07-31 24           24               24
544 544 ST MARY'S MEDICAL CENTER 2900 1ST AVENUE HUNTINGTON WV 25702 CABELL (304) 526-1234 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.4318330 -82.4013350 0   11 54 54011 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Cabell County https://data.medicare.gov/resource/xubh-q36u/row-cgcv-7ue3.g3gg 510007 640146 2018-12-26 2018-09-30 306 12 12   20   350 10     19       379
1626 1626 ST FRANCIS HOSPITAL 333 LAIDLEY ST CHARLESTON WV 25301 KANAWHA (304) 347-6500 Acute Care Hospitals Proprietary TRUE 38.3533640 -81.6325800 0   39 54 54039 16620 Charleston-Huntington-Ashland, WV-OH-KY Central Kanawha County https://data.medicare.gov/resource/xubh-q36u/row-snvq.hpwk.4wwh 510031 640147 2018-12-31 2018-09-30 27 5         32       12       44
3766 3766 UNIVERSITY PEDIATRIC HOSPITAL PUERTO RICO MEDICAL CENTER IN RIO PIEDRAS SAN JUAN PR 935 SAN JUAN (787) 777-3232 Childrens Government - State TRUE 18.3958646 -66.0736306 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-aat9~yvnm_fjvd 403301 640173 2018-11-30 2018-06-30                              
3185 3185 CORYELL MEMORIAL HEALTHCARE SYSTEM 1507 W MAIN STREET GATESVILLE TX 76528 CORYELL (254) 865-8251 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.4331520 -97.7788220 0   99 48 48099 28660   Central Coryell County https://data.medicare.gov/resource/xubh-q36u/row-ndki.wivs~b55z 451379 640181 2019-01-02 2018-07-31 21 4         25               25
1595 1595 GRANITE COUNTY MEDICAL CENTER 310 SANSOME ST PHILIPSBURG MT 59858 GRANITE (406) 859-3271 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.3327550 -113.2942070 0   39 30 30039         https://data.medicare.gov/resource/xubh-q36u/row-wazi~b6n6_xzju 271303 640231 2018-12-03 2018-06-30 25           25               25
448 448 BEARTOOTH BILLINGS CLINIC 2525 N BROADWAY RED LODGE MT 59068 CARBON (406) 446-2345 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2116970 -109.2430450 0   9 30 30009 13740   Outlying Carbon County https://data.medicare.gov/resource/xubh-q36u/row-i4we~7hxf.sxbf 271326 640232 2018-12-03 2018-06-30 10           10               10
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
15 15 GARRISON MEMORIAL HOSPITAL 407 3RD AVE SE GARRISON ND 58540 MCLEAN (701) 463-2275 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.6483420 -101.4113010 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-e4ej.ybr6_ritz 351303 640250 2018-12-03 2018-06-30 22           22       28       50
2032 2032 CHI ST ALEXIUS HEALTH TURTLE LAKE 220 5TH AVE W TURTLE LAKE ND 58575 MCLEAN (701) 448-2331 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.5179250 -100.8944420 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-w8fb-47fy-9nzg 351304 640251 2018-12-03 2018-06-30 25           25               25
2265 2265 NELSON COUNTY HEALTH SYSTEM 200 N MAIN ST MCVILLE ND 58254 NELSON (701) 322-4328 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7656260 -98.1773140 0   63 38 38063         https://data.medicare.gov/resource/xubh-q36u/row-mxe5_p48x_qufq 351308 640252 2018-11-29 2018-06-30 19           19       39       58
1770 1770 WESTON COUNTY HEALTH SERVICES 1124 WASHINGTON BOULEVARD NEWCASTLE WY 82701 WESTON (307) 746-4491 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.8487470 -104.1887560 0   45 56 56045         https://data.medicare.gov/resource/xubh-q36u/row-jibn-3jkh~ba9g 531303 640299 2018-12-03 2018-06-30 12           12       58       70
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
545 545 CROOK COUNTY HOSPITAL 713 OAK STREET SUNDANCE WY 82729 CROOK (307) 283-3501 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4088300 -104.3735960 0   11 56 56011         https://data.medicare.gov/resource/xubh-q36u/row-ikyx-7gnq-abzi 531311 640303 2018-12-04 2018-06-30 16           16       32       48
1120 1120 NIOBRARA HEALTH & LIFE CENTER 921 SOUTH BALLANCEE AVENUE LUSK WY 82225 NIOBRARA (307) 334-4000 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7532780 -104.4460830 0   27 56 56027         https://data.medicare.gov/resource/xubh-q36u/row-ee9k~358g.gwyk 531314 640304 2018-12-03 2018-06-30 24           24               24
4601 4601 UT HEALTH EAST TEXAS CARTHAGE HOSPITAL 409 COTTAGE RD CARTHAGE TX 75633 PANOLA (093) 693-3841 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1671260 -94.3460390 0   365 48 48365         https://data.medicare.gov/resource/xubh-q36u/row-tyuw-zwkq.zq2r 450210 640322 2018-12-28 2018-07-31 42           42               42
344 344 ORCHARD HOSPITAL 240 SPRUCE STREET GRIDLEY CA 95948 BUTTE (530) 846-5671 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3669740 -121.6897170 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-kvk2_zuau.b3ab 51311 640345 2018-12-03 2018-06-30 24           24       52       76
81 81 HALE HO'OLA HAMAKUA 45-547 PLUMERIA STREET HONOKAA HI 96727 HAWAII (808) 932-4100 Critical Access Hospitals Government - State TRUE 20.0762710 -155.4705950 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-z9jm-2idi-sq3z 121307 640366 2018-12-03 2018-06-30 11           11       66       77
90 90 T J HEALTH COLUMBIA 901 WESTLAKE DRIVE COLUMBIA KY 42728 ADAIR (270) 384-4753 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.0962890 -85.2949400 0   1 21 21001         https://data.medicare.gov/resource/xubh-q36u/row-7iis-x23i.zsak 180149 640382 2018-12-31 2018-09-30 49           49 20             69
1459 1459 TORRANCE MEMORIAL MEDICAL CENTER 3330 LOMITA BLVD TORRANCE CA 90509 LOS ANGELES (310) 325-9110 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.8126440 -118.3437500 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-cibe~cfxf_9r58 50351 640468 2018-11-30 2018-06-30 391 44   12   25 472       40       512
2241 2241 PLUMAS DISTRICT HOSPITAL 1065 BUCKS LAKE ROAD QUINCY CA 95971 PLUMAS (530) 283-2121 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.9347670 -120.9192510 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-k6tt~sk6g~887z 51326 640492 2018-12-13 2018-06-30 23           23               23
351 351 SAMUEL MAHELONA MEMORIAL HOSPITAL 4800 KAWAIHAU ROAD KAPAA HI 96746 KAUAI (808) 822-4961 Critical Access Hospitals Government - State TRUE 22.0876190 -159.3142040 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ysve.ycbm-b3qy 121306 640504 2018-11-30 2018-06-30 5           5 9     66       80
3550 3550 CARLINVILLE AREA HOSPITAL 20733 N BROAD STREET CARLINVILLE IL 62626 MACOUPIN (217) 854-3141 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.2996420 -89.8816300 0   117 17 17117 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Macoupin County https://data.medicare.gov/resource/xubh-q36u/row-pxfs~3ysx~txi8 141347 640505 2019-01-07 2018-07-31 25           25               25
2708 2708 MARCUS DALY MEMORIAL HOSPITAL - CAH 1200 WESTWOOD DR HAMILTON MT 59840 RAVALLI (406) 375-4408 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.2471580 -114.1713650 0   81 30 30081         https://data.medicare.gov/resource/xubh-q36u/row-r262~sb7s_y9sk 271340 640517 2018-12-04 2018-06-30 20 5         25               31
1612 1612 PEACEHEALTH COTTAGE GROVE COMMUNITY MEDICAL CENTER 1515 VILLAGE DRIVE COTTAGE GROVE OR 97424 LANE (541) 767-5202 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8038370 -123.0386760 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-6buq_rs3k.th8r 381301 640536 2018-11-30 2018-06-30 14           14               14
2093 2093 PEACEHEALTH UNITED GENERAL MEDICAL CENTER 2000 HOSPITAL DRIVE SEDRO WOOLLEY WA 98284 SKAGIT (360) 856-6021 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.4955160 -122.2752870 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-bxir_c4z7.hk8y 501329 640561 2018-11-30 2018-06-30 25           25               25
2041 2041 PEACEHEALTH PEACE ISLAND MEDICAL CENTER 1117 SPRING STREET FRIDAY HARBOR WA 98250 SAN JUAN (360) 378-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5298570 -123.0281710 0   55 53 53055         https://data.medicare.gov/resource/xubh-q36u/row-tq94~fpij_9q58 501340 640562 2018-11-30 2018-06-30 10           10               10
1560 1560 LAKE DISTRICT HOSPITAL 700 SOUTH J STREET LAKEVIEW OR 97630 LAKE (541) 947-2114 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1815830 -120.3514370 0   37 41 41037         https://data.medicare.gov/resource/xubh-q36u/row-2rpx~hmxp~n924 381309 640591 2018-12-10 2018-06-30 24           24               24
4004 4004 COMMUNITY MEDICAL CENTER, INC P O BOX 399, 3307 BARADA ST FALLS CITY NE 68355 RICHARDSON (402) 245-2428 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0778770 -95.6075970 1 ROOFTOP 147 31 31147         https://data.medicare.gov/resource/xubh-q36u/row-xcna_pb8z-kjhc 281352 640654 2018-12-28 2018-07-31 24           24               24
4205 4205 RUSSELL REGIONAL HOSPITAL 200 S MAIN STREET RUSSELL KS 67665 RUSSELL (785) 483-3131 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8832620 -98.8598360 0   167 20 20167         https://data.medicare.gov/resource/xubh-q36u/row-jqcp-w49x~7w2h 171350 640712 2019-01-03 2018-07-31 19           19           22   41
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
1198 1198 NEA BAPTIST MEMORIAL HOSPITAL 4800 EAST JOHNSON AVENUE JONESBORO AR 72401 CRAIGHEAD (870) 972-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8642040 -90.6391070 0   31 5 5031 27860 Jonesboro-Paragould, AR Central Craighead County https://data.medicare.gov/resource/xubh-q36u/row-2xtp-iu4z.fhj9 40118 640739 2018-12-28 2018-09-30 144 36         180   24           204
2546 2546 ELLWOOD CITY MEDICAL CENTER 724 PERSHING STREET ELLWOOD CITY PA 16117 LAWRENCE (724) 752-0081 Acute Care Hospitals Proprietary TRUE 40.8693490 -80.2744790 0   73 42 42073 35260 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-k638_yc9y~2hzs 390008 640799 2019-01-10 2018-06-30 46 6         52 10             62
950 950 LOST RIVERS MEDICAL CENTER 551 HIGHLAND DRIVE ARCO ID 83213 BUTTE (208) 252-7654 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6405520 -113.2962530 0   23 16 16023 26820 Idaho Falls-Rexburg-Blackfoot, ID Outlying Butte County https://data.medicare.gov/resource/xubh-q36u/row-77px.m9qb~bsww 131324 640856 2019-01-08 2018-09-30 14           14               14
3528 3528 DECATUR MEMORIAL HOSPITAL 2300 NORTH EDWARD STREET DECATUR IL 62526 MACON (217) 876-8121 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8664920 -88.9609120 0   115 17 17115 19500   Central Macon County https://data.medicare.gov/resource/xubh-q36u/row-4jiv~9ut8.2dsg 140135 640894 2018-12-24 2018-09-30 150 22 30       202 20             222
4095 4095 REPUBLIC COUNTY HOSPITAL 2420 G STREET BELLEVILLE KS 66935 REPUBLIC (785) 527-2254 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.8180870 -97.6369260 0   157 20 20157         https://data.medicare.gov/resource/xubh-q36u/row-9zem~u5py-ykuc 171361 640899 2019-01-10 2018-09-30 25           25               25
610 610 BAYSTATE NOBLE HOSPITAL 115 WEST SILVER STREET WESTFIELD MA 1085 HAMPDEN (413) 568-2811 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1177890 -72.7603970 0   13 25 25013 44140 Springfield-Greenfield Town, MA Central Hampden County https://data.medicare.gov/resource/xubh-q36u/row-5p48_fc7t.9du7 220065 640904 2019-01-03 2018-09-30 76 6         82   15           97
330 330 MARSHFIELD MEDICAL CENTER - RICE LAKE 1700 WEST STOUT STREET RICE LAKE WI 54868 BARRON (715) 234-1515 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5080420 -91.7590270 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-skqj~bt33-3hxj 520011 640931 2019-01-10 2018-09-30 35 5         40               40
3937 3937 MARSHFIELD MEDICAL CENTER 611 ST JOSEPH AVE MARSHFIELD WI 54449 WOOD (715) 387-7850 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.6780444 -90.1770418 1 ROOFTOP 141 55 55141 49220 Wausau-Stevens Point-Wisconsin Rapids, WI Central Wood County https://data.medicare.gov/resource/xubh-q36u/row-skbx~dk6q-qiix 520037 641007 2019-01-08 2018-09-30 181   11   12   230   8           238
4573 4573 PHOEBE WORTH MEDICAL CENTER 807 SOUTH ISABELLA STREET SYLVESTER GA 31791 WORTH (229) 777-3851 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.5123850 -83.8406730 0   321 13 13321 10500   Outlying Worth County https://data.medicare.gov/resource/xubh-q36u/row-kvdr-2fup-rgie 111328 641024 2018-12-28 2018-07-31 25           25               25
4213 4213 BAPTIST MEMORIAL HOSPITAL TIPTON 1995 HIGHWAY 51 S COVINGTON TN 38019 TIPTON (901) 476-2621 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.5352480 -89.6761690 0   167 47 47167 32820 Memphis-Forrest City, TN-MS-AR Outlying Tipton County https://data.medicare.gov/resource/xubh-q36u/row-nznx.5apf-m53s 440131 641061 2018-12-28 2018-09-30 40   7       47               47
412 412 GRIFFIN HOSPITAL 130 DIVISION ST DERBY CT 6418 NEW HAVEN (203) 732-7500 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.3359780 -73.0886890 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-ikfk.swi4.hhft 70031 641347 2019-01-22 2018-09-30 87 14         101 16         2   119
661 661 BURNETT MEDICAL CENTER 257 W ST GEORGE AVE GRANTSBURG WI 54840 BURNETT (715) 463-5353 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.7755460 -92.6871820 0   13 55 55013         https://data.medicare.gov/resource/xubh-q36u/row-zayf~pj6y.5spk 521331 641418 2019-01-24 2018-09-30 25           25       50       75
2416 2416 PLAINS MEMORIAL HOSPITAL 310 WEST HALSELL STREET DIMMITT TX 79027 CASTRO (806) 647-2191 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.5555910 -102.3157640 0   69 48 48069         https://data.medicare.gov/resource/xubh-q36u/row-c55u_ceer_6r3n 451350 641531 2019-01-14 2018-09-30 17           17               17
4223 4223 WINONA HEALTH SERVICES 855 MANKATO AVENUE WINONA MN 55987 WINONA (507) 454-3650 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0330160 -91.6221360 0   169 27 27169 49100   Central Winona County https://data.medicare.gov/resource/xubh-q36u/row-krgn_vcn8~g9tk 240044 641593 2019-01-28 2018-09-30 33 8         41               41
623 623 HUMBOLDT GENERAL HOSPITAL 118 EAST HASKELL STREET WINNEMUCCA NV 89445 HUMBOLDT (775) 623-5222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9715810 -117.7285340 0   13 32 32013 49080   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-ca7p_4a94-fjt7 291308 641600 2018-11-30 2018-06-30 22 3         25       42       67
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
4510 4510 SOUTHWEST GEORGIA REGIONAL MEDICAL CENTER 361 RANDOLPH STREET CUTHBERT GA 39840 RANDOLPH (229) 732-2181 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7748230 -84.7936060 0   243 13 13243         https://data.medicare.gov/resource/xubh-q36u/row-9bkz.mqd7-hbvn 111300 641801 2019-01-02 2018-07-31 25           25       80       105
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
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
2056 2056 SOUTH BAY HOSPITAL 4016 SUN CITY CENTER BLVD SUN CITY CENTER FL 33573 HILLSBOROUGH (813) 634-3301 Acute Care Hospitals Proprietary TRUE 27.7123900 -82.3651680 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-t2n2.68x7~rif4 100259 642087 2019-01-25 2018-08-31 126 12         138               138
2105 2105 THOMAS H BOYD MEMORIAL HOSPITAL 800 SCHOOL ST CARROLLTON IL 62016 GREENE (217) 942-6946 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.2961700 -90.4123030 0   61 17 17061         https://data.medicare.gov/resource/xubh-q36u/row-vab7-2ww3-xwdi 141300 642094 2019-01-30 2018-08-31 25           25               25
4328 4328 YORK GENERAL HOSPITAL 2222 LINCOLN AVE YORK NE 68467 YORK (402) 362-6671 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8824760 -97.5921090 1 ROOFTOP 185 31 31185         https://data.medicare.gov/resource/xubh-q36u/row-dn5r-dnwm.i2as 281336 642099 2019-01-22 2018-09-30 25           25       129       154
3795 3795 MOBRIDGE REGIONAL HOSPITAL - CAH 1401 10TH AVE WEST MOBRIDGE SD 57601 WALWORTH (605) 845-3692 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.5461360 -100.4481520 0   129 46 46129         https://data.medicare.gov/resource/xubh-q36u/row-xyu8~7ke2-84ch 431325 642290 2019-01-31 2018-09-30 21 4         25               25
3294 3294 RAPPAHANNOCK GENERAL HOSPITAL 101 HARRIS ROAD KILMARNOCK VA 22482 LANCASTER (804) 435-8000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.7002900 -76.3897780 0   103 51 51103         https://data.medicare.gov/resource/xubh-q36u/row-ft5v.4v76~xrcw 491308 642300 2019-01-31 2018-08-31 25           25 10             35
1627 1627 THOMAS MEMORIAL HOSPITAL 4605 MACCORKLE AVENUE SW SOUTH CHARLESTON WV 25309 KANAWHA (304) 766-3600 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3556430 -81.7265020 0   39 54 54039 16620 Charleston-Huntington-Ashland, WV-OH-KY Central Kanawha County https://data.medicare.gov/resource/xubh-q36u/row-cjx7~u6wd.5zu6 510029 642302 2019-02-01 2018-09-30 162   16       178 28             206
1226 1226 ANN & ROBERT H LURIE CHILDRENS HOSPITAL OF CHICAGO 225 E CHICAGO AVE, BOX 140 CHICAGO IL 60611 COOK (312) 227-4000 Childrens Voluntary non-profit - Private TRUE 41.8967460 -87.6219060 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-apzm~334d~hd6g 143300 642330 2019-02-01 2018-08-31 168 40 44     60 312               312
1 1 ASHLEY COUNTY MEDICAL CENTER 1015 UNITY ROAD CROSSETT AR 71635 ASHLEY (870) 364-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.1372060 -91.9387800 0   3 5 5003         https://data.medicare.gov/resource/xubh-q36u/row-gq3d.ak25_8qvw 41323 642385 2019-01-15 2018-09-30 19 6         25 10             35
276 276 PREVOST MEMORIAL HOSPITAL 301 MEMORIAL DR DONALDSONVILLE LA 70346 ASCENSION (225) 474-2133 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.0879510 -91.0029040 0   5 22 22005 12940   Central Ascension Parish https://data.medicare.gov/resource/xubh-q36u/row-e567~vwui.ed3h 191308 642472 2019-02-01 2018-08-31 25           25               25
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
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
1534 1534 VALLEY WEST COMMUNITY HOSPITAL 1301 NORTH MAIN STREET SANDWICH IL 60548 DE KALB (815) 786-8484 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.6571330 -88.6219200 0   37 17 17037 16980 Chicago-Naperville, IL-IN-WI Outlying DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-hn6i_547d~phkm 141340 642794 2019-02-04 2018-08-31 21 4         25               25
912 912 GLENDIVE MEDICAL CENTER 202 PROSPECT DR GLENDIVE MT 59330 DAWSON (406) 345-3306 Critical Access Hospitals Voluntary non-profit - Other TRUE 47.1172260 -104.7049530 0   21 30 30021         https://data.medicare.gov/resource/xubh-q36u/row-x469.qqvr~n68h 271332 642881 2019-02-07 2018-06-30 22 3         25       56       81
1966 1966 METHODIST FREMONT HEALTH 450 EAST 23RD ST FREMONT NE 68025 DODGE (402) 721-1610 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4514640 -96.4924730 0   53 31 31053 23340 Omaha-Council Bluffs-Fremont, NE-IA Central Dodge County https://data.medicare.gov/resource/xubh-q36u/row-fbad~4pf8_77wx 280077 642882 2019-01-28 2018-09-30 50           50 20     106       176
1351 1351 ASANTE THREE RIVERS MEDICAL CENTER 500 SW RAMSEY AVENUE GRANTS PASS OR 97527 JOSEPHINE (541) 472-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.4204370 -123.3414950 0   33 41 41033 24420 Medford-Grants Pass, OR Central Josephine County https://data.medicare.gov/resource/xubh-q36u/row-ybif~ftnq_236g 380002 642897 2019-01-29 2018-09-30 109 12         121               121
1167 1167 ASANTE ROGUE REGIONAL MEDICAL CENTER 2825 E BARNETT ROAD MEDFORD OR 97504 JACKSON (541) 789-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3164830 -122.8304430 0   29 41 41029 32780 Medford-Grants Pass, OR Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-9ft2-cyq3.jcug 380018 642898 2019-01-29 2018-09-30 238 15 16       301 21 15           337
1777 1777 NORTH CANYON MEDICAL CENTER 267 NORTH CANYON DR GOODING ID 83330 GOODING (208) 934-4433 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.9218690 -114.7111280 0   47 16 16047         https://data.medicare.gov/resource/xubh-q36u/row-dagw~rfa6-2dqe 131302 642945 2019-02-06 2018-09-30 16           16               16
1832 1832 SYRINGA GENERAL HOSPITAL 607 W MAIN STREET GRANGEVILLE ID 83530 IDAHO (208) 983-1700 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.9267890 -116.1269940 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-9the-4kgt.urhi 131315 642946 2019-02-08 2018-09-30 15           15               15
933 933 LOURDES MEDICAL CENTER 520 N FOURTH AVENUE PASCO WA 99301 FRANKLIN (509) 546-2278 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.2350260 -119.0944360 0   21 53 53021 28420   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-h47i.7rwx-7e8h 501337 642976 2019-02-04 2018-08-31 25           25   10           35
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
850 850 J ARTHUR DOSHER MEMORIAL HOSPITAL 924 HOWE ST SOUTHPORT NC 28461 BRUNSWICK (910) 457-3800 Critical Access Hospitals Voluntary non-profit - Other TRUE 33.9290380 -78.0221940 0   19 37 37019 34820 Myrtle Beach-Conway, SC-NC Central Brunswick County https://data.medicare.gov/resource/xubh-q36u/row-6aha~5azi-guhu 341327 643001 2019-02-07 2018-09-30 25           25               25
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
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
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
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
1653 1653 JENNIE M MELHAM MEMORIAL MEDICAL CENTER 145 MEMORIAL DRIVE BROKEN BOW NE 68822 CUSTER (308) 872-4100 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4090540 -99.6322620 0   41 31 31041         https://data.medicare.gov/resource/xubh-q36u/row-j4ps~9hc7.f4ta 281365 643047 2019-01-30 2018-09-30 23           23               23
244 244 PERMIAN REGIONAL MEDICAL CENTER ANDREWS COUNTY HO 720 HOSPITAL DRIVE ANDREWS TX 79714 ANDREWS (432) 523-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3374240 -102.5468660 0   3 48 48003 11380   Central Andrews County https://data.medicare.gov/resource/xubh-q36u/row-juik.55wn.c6fd 450144 643151 2019-02-12 2018-09-30 30           30               30
4032 4032 PRATT REGIONAL MEDICAL CENTER 200 COMMODORE ST PRATT KS 67124 PRATT (620) 450-1160 Acute Care Hospitals Proprietary TRUE 37.6453650 -98.7293670 0   151 20 20151         https://data.medicare.gov/resource/xubh-q36u/row-7vie.23jw-s3kw 170027 643206 2019-02-11 2018-09-30 29 6         35       46       81

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