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 skilled_nursing_beds descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, 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
2793 2793 GLENCOE REGIONAL HEALTH SERVICES 1805 HENNEPIN AVENUE NORTH GLENCOE MN 55336 MC LEOD (320) 864-3121 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.7775500 -94.1517140 0   85 27 27085 26780 Minneapolis-St. Paul, MN-WI Central McLeod County https://data.medicare.gov/resource/xubh-q36u/row-j3nk_h3k3_6mv6 241355 649274 2019-05-24 2018-12-31 25           25       99       124
2881 2881 MAYERS MEMORIAL HOSPITAL 43563 HWY 299 EAST FALL RIVER MILLS CA 96028 SHASTA (530) 336-5511 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0239680 -121.4246510 0   89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-fpxd_qi9h_6mni 51305 662172 2019-11-29 2019-06-30 22           22       99       121
1469 1469 PACIFICA HOSPITAL OF THE VALLEY 9449 SAN FERNANDO RD SUN VALLEY CA 91352 LOS ANGELES (818) 767-3310 Acute Care Hospitals Proprietary TRUE 34.2411340 -118.3956690 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-dhg6-n9an_6w25 50378 650948 2019-06-03 2018-12-31 126   7       133       98       231
291 291 ESSENTIA HEALTH ST MARYS - DETROIT LAKES 1027 WASHINGTON AVE DETROIT LAKES MN 56501 BECKER (218) 847-0888 Acute Care Hospitals Voluntary non-profit - Church FALSE 46.8153070 -95.8454530 0   5 27 27005         https://data.medicare.gov/resource/xubh-q36u/row-my2b~zwif~njdr 240101 660605 2019-11-26 2019-06-30 28 8         36       96       132
2175 2175 WIREGRASS MEDICAL CENTER 1200 W MAPLE AVENUE GENEVA AL 36340 GENEVA (334) 684-3655 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0480630 -85.8908370 0   61 1 1061 20020 Dothan-Enterprise-Ozark, AL Outlying Geneva County https://data.medicare.gov/resource/xubh-q36u/row-6zer-5ewe_shgk 10062 644199 2019-03-01 2018-09-30 67 6         73 16     96       185
3436 3436 PERHAM HEALTH 1000 CONEY STREET WEST PERHAM MN 56573 OTTER TAIL (218) 347-1301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.5926850 -95.5951650 0   111 27 27111 22260   Central Otter Tail County https://data.medicare.gov/resource/xubh-q36u/row-zmw6~bp7u-2zf8 241373 643422 2019-02-22 2018-09-30 25           25       96       121
1039 1039 CLAIBORNE MEDICAL CENTER 1850 OLD KNOXVILLE HIGHWAY TAZEWELL TN 37879 CLAIBORNE (423) 626-4211 Acute Care Hospitals Government - Local TRUE 36.4533410 -83.5719720 0   25 47 47025         https://data.medicare.gov/resource/xubh-q36u/row-vk5j.mjgd~i76d 440057 658958 2019-11-18 2019-06-30 28 5         33       95       128
2428 2428 HI-DESERT MEDICAL CENTER 6601 WHITE FEATHER ROAD JOSHUA TREE CA 92252 SAN BERNARDINO (760) 366-3711 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1326760 -116.2767090 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-3mx7_8i2i.7siq 50279 655668 2019-10-30 2019-05-31 51 4         55       95 25     175
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
2739 2739 MARIAN REGIONAL MEDICAL CENTER 1400 E CHURCH ST SANTA MARIA CA 93454 SANTA BARBARA (805) 739-3100 Acute Care Hospitals Voluntary non-profit - Church FALSE 34.9521170 -120.4124940 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-fcqm_qb6a~xqvi 50107 655525 2019-10-11 2019-06-30 224 28         273   20   95       388
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
2755 2755 SIDNEY HEALTH CENTER 216 14TH AVE SW SIDNEY MT 59270 RICHLAND (406) 488-2100 Critical Access Hospitals Voluntary non-profit - Other TRUE 47.7158390 -104.1741710 0   83 30 30083         https://data.medicare.gov/resource/xubh-q36u/row-8bhp_awpt~duw3 271344 658357 2019-11-12 2019-06-30 25           25       93       118
4132 4132 GENESIS HEALTH SYSTEM 801 ILLINI DR SILVIS IL 61282 ROCK ISLAND (309) 281-4000 Acute Care Hospitals Government - Local TRUE 41.4930680 -90.4199970 0   161 17 17161 19340 Davenport-Moline, IA-IL Central Rock Island County https://data.medicare.gov/resource/xubh-q36u/row-wxqw_k6y5~djg4 140275 654836 2019-09-24 2019-06-30 138 7         145       92 28     265
24 24 ST ALOISIUS MEDICAL CENTER 325 E BREWSTER ST HARVEY ND 58341 WELLS (701) 324-4651 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7676870 -99.9330890 0   103 38 38103         https://data.medicare.gov/resource/xubh-q36u/row-u657.4sxp.u7ix 351327 644053 2019-02-27 2018-09-30 25           25       91       116
574 574 BANNER BOSWELL MEDICAL CENTER 10401 WEST THUNDERBIRD BOULEVARD SUN CITY AZ 85351 MARICOPA (623) 832-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.6047980 -112.2825380 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-jqxq_rtvy~eb3s 30061 654709 2019-09-18 2018-12-31 325 85         410   24   91       525
1036 1036 ST LUKE'S HOSPITAL-GNADEN HUETTEN CAMPUS 211 NORTH 12TH STREET LEHIGHTON PA 18235 CARBON (607) 377-1300 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8325350 -75.7268010 0   25 42 42025 10900 New York-Newark, NY-NJ-CT-PA Central Carbon County https://data.medicare.gov/resource/xubh-q36u/row-hnbg_wr7i.75b7 390194 660865 2019-12-02 2019-06-30 62 6         68 20 22   91       201
1428 1428 LOCK HAVEN HOSPITAL 24 CREE DRIVE LOCK HAVEN PA 17745 CLINTON (570) 893-5024 Acute Care Hospitals Proprietary TRUE 41.1328120 -77.4701830 0   35 42 42035 30820 Williamsport-Lock Haven, PA Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-i2uu~n4az-hqsg 390071 662135 2019-12-04 2019-06-30 47           47       90       137
1843 1843 MAYO CLINIC HEALTH SYSTEM - LAKE CITY 500 WEST GRANT STREET LAKE CITY MN 55041 WABASHA (651) 345-5955 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4583350 -92.2883650 0   49 27 27049 39860 Minneapolis-St. Paul, MN-WI Central Goodhue County https://data.medicare.gov/resource/xubh-q36u/row-xfrx_892y-jk4u 241338 649781 2019-05-30 2018-12-31 18           18       90       108
2934 2934 FAIRBANKS MEMORIAL HOSPITAL 1650 COWLES STREET FAIRBANKS AK 99701 FAIRBANKS NORTH STAR (907) 452-8181 Acute Care Hospitals Voluntary non-profit - Private TRUE 64.8314070 -147.7362540 0   90 2 2090 21820   Central Fairbanks North Star Borough https://data.medicare.gov/resource/xubh-q36u/row-e5th.n9ja~cin9 20012 648324 2019-05-28 2018-12-31 109 13         122       90       212
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
1460 1460 HOLLYWOOD PRESBYTERIAN MEDICAL CENTER 1300 N VERMONT AVE LOS ANGELES CA 90027 LOS ANGELES (213) 413-3000 Acute Care Hospitals Proprietary TRUE 34.0961160 -118.2917530 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8qce_cap7_t65z 50063 651260 2019-07-02 2018-12-31 266 36       15 317   28   89       434
3850 3850 NORTHSIDE HOSPITAL GWINNETT 1000 MEDICAL CENTER BOULEVARD LAWRENCEVILLE GA 30045 GWINNETT (678) 312-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.9664550 -84.0130120 0   135 13 13135 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Gwinnett County https://data.medicare.gov/resource/xubh-q36u/row-s7r7-ja6f~94m5 110087 661711 2019-12-13 2019-08-27 367 46       24 437   30   89       556
4029 4029 PIEDMONT HENRY HOSPITAL 1133 EAGLE'S LANDING PARKWAY STOCKBRIDGE GA 30281 HENRY (678) 604-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5089960 -84.2255610 0   151 13 13151 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-vhdk-mf48~gr2g 110191 659490 2019-11-25 2019-06-30 196   40     16 252       89       341
4233 4233 CENTRACARE HEALTH - MONTICELLO 1013 HART BOULEVARD MONTICELLO MN 55362 WRIGHT (763) 295-2945 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3001700 -93.7791070 0   171 27 27171 33460 Minneapolis-St. Paul, MN-WI Central Wright County https://data.medicare.gov/resource/xubh-q36u/row-8yik_ujc7-cau4 241362 660614 2019-11-26 2019-06-30 22 3         25 10     89       124
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
2442 2442 COMMUNITY HOSPITAL OF SAN BERNARDINO 1805 MEDICAL CENTER DRIVE SAN BERNARDINO CA 92411 SAN BERNARDINO (909) 887-6333 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1312380 -117.3225590 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-7h58.yy87~u565 50089 661456 2019-12-03 2019-06-30 155 21       9 185 74     88   84   431
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
252 252 NORTH BIG HORN HOSPITAL DISTRICT 1115 LANE 12 LOVELL WY 82431 BIG HORN (307) 548-5200 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.8257990 -108.3906880 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-s9vd~bscy-xn2k 531309 662633 2019-11-27 2019-06-30 12           12       85       97
1897 1897 FAYETTE COUNTY HOSPITAL 7TH AND TAYLOR VANDALIA IL 62471 FAYETTE (618) 283-1231 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.9706410 -89.0988780 1 GEOMETRIC_CENTER 51 17 17051         https://data.medicare.gov/resource/xubh-q36u/row-3m36-npvv-f9tn 141346 648907 2019-05-30 2018-12-31 25 4         29       85       114
498 498 HABERSHAM COUNTY MEDICAL CTR 541 HISTORIC HIGHWAY 441-NORTH DEMOREST GA 30535 HABERSHAM (706) 754-2161 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4058790 -83.4859890 0   11 13 13011         https://data.medicare.gov/resource/xubh-q36u/row-vwu4-xgbr~5v33 110041 660923 2019-12-04 2019-06-30 49 4         53       84       137
608 608 PENOBSCOT BAY MEDICAL CENTER 6 GLEN COVE DRIVE ROCKPORT ME 4856 KNOX (207) 921-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1444340 -69.0865370 0   13 23 23013         https://data.medicare.gov/resource/xubh-q36u/row-ahvj_huyh~m44w 200063 650478 2019-05-31 2018-12-31 73 8         81       84       165
761 761 HOLY ROSARY HEALTHCARE 2600 WILSON ST MILES CITY MT 59301 CUSTER (406) 233-2600 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3973550 -105.8278370 0   17 30 30017         https://data.medicare.gov/resource/xubh-q36u/row-89tn_7hx4-8qhz 271347 649797 2019-06-03 2018-12-31 21 4         25       84       109
1159 1159 MERCY HOSPITAL OF BUFFALO 565 ABBOTT ROAD BUFFALO NY 14220 ERIE (716) 826-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8478750 -78.8118760 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-i2f7.7shj.6bd2 330279 650752 2019-06-24 2018-12-31 303 28 18     15 364   22   84       470
1402 1402 NATHAN LITTAUER HOSPITAL 99 EAST STATE STREET GLOVERSVILLE NY 12078 FULTON (518) 725-8621 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.0680290 -74.3308170 0   35 36 36035 24100 Albany-Schenectady, NY Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-d8mm-sn3z_9adu 330276 650751 2019-05-30 2018-12-31 50 8         58       84       142
1429 1429 AVERA QUEEN OF PEACE 525 N FOSTER MITCHELL SD 57301 DAVISON (605) 995-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.7138420 -98.0073250 0   35 46 46035 33580   Central Davison County https://data.medicare.gov/resource/xubh-q36u/row-vs8d.p4rg.tbmc 430013 660030 2019-11-26 2019-06-30 42 8         50       84       134
3014 3014 REGIONAL HEALTH STURGIS HOSPITAL 2140 JUNCTION AVE STURGIS SD 57785 MEADE (605) 720-2400 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.4027870 -103.5091220 0   93 46 46093 39660 Rapid City-Spearfish, SD Central Meade County https://data.medicare.gov/resource/xubh-q36u/row-wstg_ymgi.qr4e 431321 658914 2019-11-15 2019-06-30 22 3         25       84       109
934 934 DIVINE SAVIOR HEALTHCARE 2817 NEW PINERY ROAD PORTAGE WI 53901 COLUMBIA (608) 742-4131 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5662780 -89.4694450 0   21 55 55021 31540 Madison-Janesville-Beloit, WI Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-qhad~azvf~jeqw 520041 661128 2019-11-26 2019-06-30 37 6         43       83   40   166
1058 1058 CLAY COUNTY HOSPITAL 83825 HIGHWAY 9 P O BOX 1270 ASHLAND AL 36251 CLAY (256) 354-2131 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2765480 -85.8237890 0   27 1 1027         https://data.medicare.gov/resource/xubh-q36u/row-p2yh_2e24~5sth 10073 644085 2019-02-28 2018-09-30 42 4         46       83       129
1012 1012 MARGARETVILLE MEMORIAL HOSPITAL 42084 STATE HIGHWAY 28 MARGARETVILLE NY 12455 DELAWARE (845) 586-2631 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1476540 -74.6426290 0   25 36 36025         https://data.medicare.gov/resource/xubh-q36u/row-n54k.cyed-635i 331304 650758 2019-05-30 2018-12-31 15           15       82       97
3004 3004 ELLIS HOSPITAL 1101 NOTT STREET SCHENECTADY NY 12308 SCHENECTADY (518) 243-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8198180 -73.9188830 0   93 36 36093 10580 Albany-Schenectady, NY Central Schenectady County https://data.medicare.gov/resource/xubh-q36u/row-85ip_99s5_jima 330153 650303 2019-05-31 2018-12-31 298 36         334       82       416
4150 4150 MEMORIAL HOSPITAL 4500 MEMORIAL DRIVE BELLEVILLE IL 62226 ST. CLAIR (618) 233-7750 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5505330 -90.0211680 0   163 17 17163 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-mafx-marv~a3nv 140185 650125 2019-05-31 2018-12-31 192 20         212       82       294
650 650 AVERA ST LUKES 305 S STATE ST POST OFFICE BOX 4450 ABERDEEN SD 57401 BROWN (605) 622-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.4617950 -98.4793500 0   13 46 46013 10100   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-pruy~fuxf-c6av 430014 662254 2019-11-27 2019-06-30 43 6         49 10     81 56     196
522 522 AUBURN COMMUNITY HOSPITAL 17 LANSING STREET AUBURN NY 13021 CAYUGA (315) 255-7011 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9407610 -76.5646070 0   11 36 36011 12180 Syracuse-Auburn, NY Central Cayuga County https://data.medicare.gov/resource/xubh-q36u/row-7wyc_jst8-xyh7 330235 650319 2019-05-31 2018-12-31 71   14       85 14     80       179
773 773 CHENANGO MEMORIAL HOSPITAL 179 NORTH BROAD STREET NORWICH NY 13815 CHENANGO (607) 337-4111 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5420380 -75.5247240 0   17 36 36017         https://data.medicare.gov/resource/xubh-q36u/row-9jfe-nh8q_gain 330033 649474 2019-06-11 2018-12-31 51 7         58       80       138
972 972 GUTHRIE CORTLAND REGIONAL MEDICAL CENTER 134 HOMER AVENUE CORTLAND NY 13045 CORTLAND (607) 756-3501 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6089970 -76.1861170 0   23 36 36023 18660 Ithaca-Cortland, NY Central Cortland County https://data.medicare.gov/resource/xubh-q36u/row-br3w~352e~gb7g 330175 661938 2019-12-06 2019-06-30 91 12         103 11     80       194
979 979 MUSC HEALTH CHESTER MEDICAL CENTER 1 MEDICAL PARK DRIVE CHESTER SC 29706 CHESTER (803) 581-3151 Acute Care Hospitals Proprietary TRUE 34.6834290 -81.1845510 0   23 45 45023 16740 Charlotte-Concord, NC-SC Outlying Chester County https://data.medicare.gov/resource/xubh-q36u/row-uikk_hqcf-3s3p 420019 655231 2019-10-10 2019-06-30 36 6         42       80       122
1155 1155 BERTRAND CHAFFEE HOSPITAL 224 EAST MAIN STREET SPRINGVILLE NY 14141 ERIE (716) 592-2871 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.5084840 -78.6592350 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-kh2y-a8h3~k7jx 330111 650864 2019-06-03 2018-12-31 21   2       23       80       103
1157 1157 SISTERS OF CHARITY HOSPITAL 2157 MAIN STREET BUFFALO NY 14214 ERIE (716) 862-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9291700 -78.8499160 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-tkhh.t5uq_u2r8 330078 650858 2019-06-03 2018-12-31 316 30       40 386       80       466
1158 1158 KALEIDA HEALTH 100 HIGH STREET BUFFALO NY 14210 ERIE (716) 859-8620 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9003290 -78.8649370 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-xn8m_fv8h.at49 330005 650732 2019-05-31 2018-12-31 750 70 29   31 74 954   34   80       1068
2316 2316 ROME MEMORIAL HOSPITAL, INC 1500 NORTH JAMES STREET ROME NY 13440 ONEIDA (315) 338-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.2289540 -75.4442480 0   65 36 36065 46540   Central Oneida County https://data.medicare.gov/resource/xubh-q36u/row-y3h4.7wi3_6xz9 330215 650314 2019-05-31 2018-12-31 69 10         79 12     80       171
2324 2324 AVERA ST MARY'S HOSPITAL 801 E SIOUX PIERRE SD 57501 HUGHES (605) 224-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.3612680 -100.3422350 0   65 46 46065 38180   Central Hughes County https://data.medicare.gov/resource/xubh-q36u/row-y7ep-uymv.yumv 430015 660031 2019-11-26 2019-06-30 44 6         50       80       130
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
3695 3695 WINNER REGIONAL HEALTHCARE CENTER - CAH 745 EAST 8TH STREET WINNER SD 57580 TRIPP (605) 842-7100 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3709470 -99.8476170 0   123 46 46123         https://data.medicare.gov/resource/xubh-q36u/row-8vjy-k644_c637 431334 650611 2019-05-30 2018-12-31 25           25       80       105
4207 4207 ST FRANCIS MEDICAL CENTER 2400 ST FRANCIS DRIVE BRECKENRIDGE MN 56520 WILKIN (218) 643-3000 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.2913140 -96.5904330 0   167 27 27167 47420 Fargo-Wahpeton, ND-MN Outlying Wilkin County https://data.medicare.gov/resource/xubh-q36u/row-z674~sdts.8mhw 241377 661740 2019-12-03 2019-06-30 25           25       80       105
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
946 946 JEROLD PHELPS COMMUNITY HOSPITAL 733 CEDAR ST GARBERVILLE CA 95542 HUMBOLDT (707) 923-3921 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1014910 -123.7927560 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-xasy~ndp2-8fte 51309 662173 2019-11-29 2019-06-30 9           9       8       17
3373 3373 TERREBONNE GENERAL MEDICAL CENTER 8166 MAIN STREET HOUMA LA 70360 TERREBONNE (985) 873-4141 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5985370 -90.7143220 0   109 22 22109 26380   Central Terrebonne Parish https://data.medicare.gov/resource/xubh-q36u/row-4s8d.7jh4_ep57 190008 653139 2019-08-28 2019-03-31 162 18         188   14   8       210
4393 4393 WYTHE COUNTY COMMUNITY HOSPITAL 600 WEST RIDGE ROAD WYTHEVILLE VA 24382 WYTHE (276) 228-0200 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.9532970 -81.0950690 0   197 51 51197         https://data.medicare.gov/resource/xubh-q36u/row-2f6p~evdq~actr 490111 645869 2019-04-02 2018-10-31 86 6         92       8       100
4436 4436 MEMORIAL HERMANN TEXAS MEDICAL CENTER 6411 FANNIN HOUSTON TX 77030 HARRIS (713) 704-3700 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7136840 -95.3976270 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dk5e-jq9i-qp7s 450068 659613 2019-11-25 2019-06-30 658 38 18     118 994   12   8       1014
534 534 BROOKINGS HEALTH SYSTEM 300 22ND AVE BROOKINGS SD 57006 BROOKINGS (605) 696-9000 Acute Care Hospitals Government - Local TRUE 44.3077510 -96.7681990 0   11 46 46011 15100   Central Brookings County https://data.medicare.gov/resource/xubh-q36u/row-tq89~5fbc_ivbf 430008 650780 2019-06-26 2018-12-31 49           49       79       128
2985 2985 MARION REGIONAL MEDICAL CENTER 1256 MILITARY STREET SOUTH HAMILTON AL 35570 MARION (205) 921-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1258520 -87.9898060 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-ak6z-c9hr~7upb 10044 643754 2019-02-28 2018-09-30 32 4         36       79       115
4394 4394 WARM SPRINGS MEDICAL CENTER 5995 SPRING STREET WARM SPRINGS GA 31830 MERIWETHER (706) 655-9351 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.8906520 -84.6829110 0   199 13 13199 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Meriwether County https://data.medicare.gov/resource/xubh-q36u/row-zkjq-ab6q-8vh9 111316 651203 2019-06-03 2018-12-31 25           25       79       104
360 360 SANFORD BEMIDJI MEDICAL CENTER 1300 ANNE ST NW BEMIDJI MN 56601 BELTRAMI (218) 751-5430 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.5050090 -94.8981250 0   7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-uwkp_7ty3-835f 240100 649770 2019-05-23 2018-12-31 84 10         94 12 12   78       196
1718 1718 SOUTHWEST HEALTH CENTER 1400 EAST SIDE RD PLATTEVILLE WI 53818 GRANT (608) 348-2331 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.7197810 -90.4557830 0   43 55 55043 38420   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-vwfv~jm7m_6m6b 521354 661836 2019-11-27 2019-06-30 25           25 10     78       113
2358 2358 CARRIS HEALTH LLC 301 BECKER AVE SW WILLMAR MN 56201 KANDIYOHI (320) 235-4543 Acute Care Hospitals Government - Local TRUE 45.1205140 -95.0463660 0   67 27 27067 48820   Central Kandiyohi County https://data.medicare.gov/resource/xubh-q36u/row-ypur_bzw7_kp3d 240088 661914 2019-12-06 2019-06-30 73 8         81       78       159
3624 3624 ASPIRUS MEDFORD HOSPITAL & CLINICS, INC 135 S GIBSON ST MEDFORD WI 54451 TAYLOR (715) 748-8100 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.1358340 -90.3540120 0   119 55 55119         https://data.medicare.gov/resource/xubh-q36u/row-8cup-n67n_55ac 521324 662627 2019-12-23 2019-06-30 25           25       78   10   113
4047 4047 ALLIANCE COMMUNITY HOSPITAL 200 EAST STATE STREET ALLIANCE OH 44601 STARK (330) 596-7018 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.9016790 -81.1027360 0   151 39 39151 15940 Cleveland-Akron-Canton, OH Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-9pb7.6hrh_xxpz 360131 649642 2019-06-03 2018-12-31 43 12         55 12     78       145
1734 1734 GENESIS MEDICAL CENTER-DEWITT 1118 11TH STREET DEWITT IA 52742 CLINTON (563) 659-4200 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8259400 -90.5462570 0   45 19 19045 17540 Davenport-Moline, IA-IL Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-buet_jiin-dt28 161313 659569 2019-11-19 2019-06-30 13           13       77       90
3878 3878 ESSENTIA HEALTH VIRGINIA 901 9TH STREET NORTH VIRGINIA MN 55792 ST. LOUIS (218) 741-3340 Acute Care Hospitals Government - Local FALSE 47.5307110 -92.5487970 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-39c9_62zv_e3w4 240084 662217 2019-12-02 2019-06-30 40 8         48   16   77       141
2557 2557 LAGUNA HONDA HOSPITAL & REHABILITATION CENTER 375 LAGUNA HONDA BLVD SAN FRANCISCO CA 94116 SAN FRANCISCO (415) 759-2300 Acute Care Hospitals Government - Local FALSE 37.7478240 -122.4586360 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-tz44~vi64-ys8h 50668 662169 2019-12-02 2019-06-30 6           6   5   769       780
466 466 BLOUNT MEMORIAL HOSPITAL 907 E LAMAR ALEXANDER PARKWAY MARYVILLE TN 37804 BLOUNT (865) 983-7211 Acute Care Hospitals Government - Local TRUE 35.7549750 -83.9586020 0   9 47 47009 28940 Knoxville-Morristown-Sevierville, TN Central Blount County https://data.medicare.gov/resource/xubh-q36u/row-q2u9.xgek.22ux 440011 659450 2019-11-25 2019-06-30 177 8 8       193 10     76       279
1355 1355 REGIONAL HEALTH CUSTER HOSPITAL 1220 MONTGOMERY STREET CUSTER SD 57730 CUSTER (605) 673-9400 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7728160 -103.5911730 0   33 46 46033 39660 Rapid City-Spearfish, SD Outlying Custer County https://data.medicare.gov/resource/xubh-q36u/row-ce9i_v2bn~dsgz 431323 659361 2019-11-20 2019-06-30 11           11       76       87
2752 2752 AVERA MARSHALL REGIONAL MEDICAL CTR 300 SOUTH BRUCE STREET MARSHALL MN 56258 LYON (507) 532-9661 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4476340 -95.7761850 0   83 27 27083 32140   Central Lyon County https://data.medicare.gov/resource/xubh-q36u/row-w278-8yip-75pa 241359 661739 2019-11-29 2019-06-30 25           25 10     76       111
1793 1793 ST LUKE COMMUNITY HOSPITAL 107 6TH AVE SW RONAN MT 59864 LAKE (406) 676-4441 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.5288350 -114.1062420 0   47 30 30047         https://data.medicare.gov/resource/xubh-q36u/row-y443~xiew.45c8 271325 647134 2019-05-06 2018-12-31 25           25       75       100
3980 3980 CENTRACARE HEALTH SYSTEM - MELROSE HOSPITAL 525 WEST MAIN STREET MELROSE MN 56352 STEARNS (320) 256-1761 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6749160 -94.8234350 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-zgd7-nfj6_jc2g 241330 660610 2019-11-27 2019-06-30 14           14       75       89
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
1131 1131 KERN VALLEY HEALTHCARE DISTRICT 6412 LAUREL AVE LAKE ISABELLA CA 93240 KERN (760) 379-2681 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6353510 -118.4063000 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-vmmb-dmgx.ncbv 51314 652738 2018-12-04 2018-06-30 24           24       74       98
1268 1268 SOUTHERN MAINE HEALTH CARE 1 MEDICAL CENTER DRIVE BIDDEFORD ME 4005 YORK (207) 283-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.4784360 -70.4921740 0   31 23 23031 38860 Portland-Lewiston-South Portland, ME Central York County https://data.medicare.gov/resource/xubh-q36u/row-am4g_dvue_z9bw 200019 649741 2019-05-30 2018-12-31 131 9         140 12     74   38   264
1644 1644 MEMORIAL HOSPITAL 511 NE 10TH ST ABILENE KS 67410 DICKINSON (785) 263-6610 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.9249610 -97.2064830 0   41 20 20041         https://data.medicare.gov/resource/xubh-q36u/row-7wyc-bxfb~aagq 171381 648690 2019-05-24 2018-12-31 19           19 10     74       103
2855 2855 HENRY COUNTY HEALTH CENTER 407 S WHITE ST MOUNT PLEASANT IA 52641 HENRY (319) 385-3141 Critical Access Hospitals Government - Local TRUE 40.9631160 -91.5580180 0   87 19 19087         https://data.medicare.gov/resource/xubh-q36u/row-vzbh~3fhi_gk69 161356 662119 2019-12-05 2019-06-30 25           25       74       99
3414 3414 ST JOHNS PLEASANT VALLEY HOSPITAL 2309 ANTONIO AVE CAMARILLO CA 93010 VENTURA (805) 389-5800 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2429650 -119.0183060 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-t2cn.wci4_rvdy 50616 662168 2019-12-03 2019-06-30 73 8         81       74       155
2489 2489 HARDIN MEDICAL CENTER 935 WAYNE ROAD SAVANNAH TN 38372 HARDIN (731) 926-8121 Acute Care Hospitals Government - Local TRUE 35.2271300 -88.2303620 0   71 47 47071         https://data.medicare.gov/resource/xubh-q36u/row-2dfc~89p6~kqtc 440109 660709 2019-12-02 2019-06-30 49           49       73       122
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
1828 1828 MODOC MEDICAL CENTER 228 W MCDOWELL AVE ALTURAS CA 96101 MODOC (530) 233-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.4799490 -120.5455030 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-kyq6~7b5b.wgww 51330 662175 2019-11-27 2019-06-30 16           16       71       87
3335 3335 KAWEAH DELTA MEDICAL CENTER 400 W MINERAL KING AVE VISALIA CA 93291 TULARE (559) 624-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.3274150 -119.2941720 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-2rh3~mb6h~sxp4 50057 662013 2019-12-04 2019-06-30 347 41       15 403 63 45   70       581
4060 4060 CENTRACARE HEALTH SYSTEM - LONG PRAIRIE 50 CENTRACARE DRIVE LONG PRAIRIE MN 56347 TODD (320) 732-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9733659 -94.8429923 1 ROOFTOP 153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-auf6_7hb8_cyed 241326 660609 2019-11-26 2019-06-30 14           14       70       84
4290 4290 ATRIUM HEALTH UNION 600 HOSPITAL DR MONROE NC 28112 UNION (704) 283-3100 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9751110 -80.5228530 0   179 37 37179 16740 Charlotte-Concord, NC-SC Central Union County https://data.medicare.gov/resource/xubh-q36u/row-z2m5~mpse-nkc2 340130 650345 2019-05-30 2018-12-31 164 14       4 182       70       252
4348 4348 ST LUKES HOSPITAL 232 S WOODS MILL RD CHESTERFIELD MO 63017 ST. LOUIS (314) 434-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6530660 -90.5059200 0   189 29 29189 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-sqq4~n4bf~fm2b 260179 661211 2019-12-02 2019-06-30 360 18 16       394       70   60   524
4080 4080 MEMORIAL HEALTHCARE 826 WEST KING STREET OWOSSO MI 48867 SHIAWASSEE (989) 723-5211 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.0050750 -84.1820760 0   155 26 26155 37020 Lansing-East Lansing-Owosso, MI Central Shiawassee County https://data.medicare.gov/resource/xubh-q36u/row-3gmb~kzum~86xp 230121 649608 2019-05-31 2018-12-31 104 7         111       7 32     150
4240 4240 UNICOI COUNTY HOSPITAL 2030 TEMPLE HILL ROAD ERWIN TN 37650 UNICOI (423) 743-3141 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1213650 -82.4456210 0   171 47 47171 27740 Johnson City-Kingsport-Bristol, TN-VA Outlying Unicoi County https://data.medicare.gov/resource/xubh-q36u/row-8b8j.szqj-76se 440001 649955 2019-05-28 2018-12-31 10           10       7 39     56
4450 4450 ST CLAIRE REGIONAL MEDICAL CENTER 222 MEDICAL CIRCLE MOREHEAD KY 40351 ROWAN (606) 783-6502 Acute Care Hospitals Government - Federal TRUE 38.1800160 -83.4424540 0   205 21 21205         https://data.medicare.gov/resource/xubh-q36u/row-epvn~wthp~wxsz 180018 660556 2019-11-26 2019-06-30 76 14         90 20 10   7   3   130
1481 1481 MEMORIAL HOSPITAL OF GARDENA 1145 W REDONDO BEACH BLVD GARDENA CA 90247 LOS ANGELES (310) 532-4200 Acute Care Hospitals Proprietary FALSE 33.8923750 -118.2951060 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-hmjb.hw5r-grvf 50468 650564 2019-05-28 2018-12-31 93 10         103       69       172
2620 2620 FISHER-TITUS HOSPITAL 272 BENEDICT AVENUE NORWALK OH 44857 HURON (419) 668-8101 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2260340 -82.6020080 0   77 39 39077 35940 Cleveland-Akron-Canton, OH Central Huron County https://data.medicare.gov/resource/xubh-q36u/row-k8y3~5cmj-9fh2 360065 649312 2019-05-31 2018-12-31 68 10         78       69       147
4202 4202 SIOUX CENTER HEALTH 1101 9TH STREET SE SIOUX CENTER IA 51250 SIOUX (712) 722-1271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0696850 -96.1592870 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-69h8.g24x.naq3 161346 659789 2019-11-25 2019-06-30 19           19       69   1   89
153 153 ED FRASER MEMORIAL HOSPITAL 159 N 3RD ST MACCLENNY FL 32063 BAKER (904) 259-3151 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.2855500 -82.1195500 0   3 12 12003 27260 Jacksonville-St. Marys-Palatka, FL-GA Outlying Baker County https://data.medicare.gov/resource/xubh-q36u/row-bder~g3nx~udyj 100134 644243 2019-03-01 2018-09-30 21           21       68       89
710 710 GUTHRIE TOWANDA MEMORIAL HOSPITAL 91 HOSPITAL DRIVE TOWANDA PA 18848 BRADFORD (570) 265-2191 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7837960 -76.4486020 0   15 42 42015 42380   Central Bradford County https://data.medicare.gov/resource/xubh-q36u/row-p45f.b6p6~45xq 390236 660868 2019-12-02 2019-06-30 31 4         35       68       103
3364 3364 ADVENTIST HEALTH SONORA 1000 GREENLEY ROAD SONORA CA 95370 TUOLUMNE (209) 536-5000 Acute Care Hospitals Voluntary non-profit - Church FALSE 37.9767280 -120.3694420 0   109 6 6109 43760   Central Tuolumne County https://data.medicare.gov/resource/xubh-q36u/row-7tcs_nvgu-e2ik 50335 652417 2019-05-31 2018-12-31 78 6         84       68       152
2086 2086 FULTON COUNTY MEDICAL CENTER 214 PEACH ORCHARD ROAD MCCONNELLSBURG PA 17233 FULTON (717) 485-3155 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.9367160 -78.0090000 0   57 42 42057         https://data.medicare.gov/resource/xubh-q36u/row-wvyv.r4u3.6wb9 391303 660450 2019-12-03 2019-06-30 21           21       67       88
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
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

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