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

120 rows where "fy_end_date" is on date 2019-03-31

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, filed_date, icu_beds, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, subprovider_oth_beds, skilled_nursing_beds, oth_longterm_beds, filed_date (date)

fy_end_date (date) ✖

  • 2019-03-31 · 120 ✖
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
116 116 WEST RIVER REGIONAL MEDICAL CENTER-CAH 1000 HIGHWAY 12 HETTINGER ND 58639 ADAMS (701) 567-4561 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0013230 -102.6282390 0   1 38 38001         https://data.medicare.gov/resource/xubh-q36u/row-kpck-85x6-gtvw 351330 654546 2019-08-29 2019-03-31 25           25               25
134 134 THOMAS HOSPITAL 750 MORPHY AVENUE FAIRHOPE AL 36532 BALDWIN (251) 928-2375 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.5199990 -87.8903330 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-47ke~57kn.r69r 10100 653821 2019-08-30 2019-03-31 112 10     7   129   12           141
135 135 NORTH BALDWIN INFIRMARY 1815 HAND AVENUE BAY MINETTE AL 36507 BALDWIN (251) 937-5521 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.9024920 -87.7833180 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-vac9~xsmg.2gg8 10129 653823 2019-08-30 2019-03-31 51 4         55 15             70
166 166 DUPONT HOSPITAL LLC 2520 E DUPONT RD FORT WAYNE IN 46825 ALLEN (260) 416-3000 Acute Care Hospitals Proprietary TRUE 41.1786890 -85.1106030 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-q73v-xd2h_rmgd 150150 654122 2019-09-04 2019-03-31 92 10         131               131
173 173 THE MEDICAL CENTER AT SCOTTSVILLE 456 BURNLEY ROAD SCOTTSVILLE KY 42164 ALLEN (270) 622-2800 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.7597650 -86.2162120 0   3 21 21003 14540 Bowling Green-Glasgow, KY Outlying Allen County https://data.medicare.gov/resource/xubh-q36u/row-v9hf~phby-c7vz 181324 654252 2019-09-03 2019-03-31 25           25       110       135
175 175 OAKDALE COMMUNITY HOSPITAL 130 N HOSPITAL DR OAKDALE LA 71463 ALLEN (318) 335-3700 Acute Care Hospitals Proprietary TRUE 30.8162640 -92.6445450 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-7xwr-vazc_74w6 190106 654443 2019-09-09 2019-03-31 46 3         49               49
184 184 MUNISING MEMORIAL HOSPITAL 1500 SAND POINT RD MUNISING MI 49862 ALGER (906) 387-4110 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4238490 -86.6257160 0   3 26 26003         https://data.medicare.gov/resource/xubh-q36u/row-7pqa.fabg.y26z 231308 654139 2019-09-04 2019-03-31 11           11               11
243 243 TENNOVA HEALTHCARE-SHELBYVILLE 2835 HWY 231 NORTH SHELBYVILLE TN 37160 BEDFORD (931) 685-5433 Acute Care Hospitals Proprietary TRUE 35.5632180 -86.4463720 0   3 47 47003 43180 Nashville-Davidson--Murfreesboro, TN Central Bedford County https://data.medicare.gov/resource/xubh-q36u/row-nnwj-ykm6~eviv 440137 654172 2019-09-04 2019-03-31 36 8         44               44
323 323 CACHE VALLEY HOSPITAL 2380 NORTH 400 EAST NORTH LOGAN UT 84341 CACHE (435) 713-9580 Acute Care Hospitals Proprietary TRUE 41.7757140 -111.8230920 0   5 49 49005 30860   Central Cache County https://data.medicare.gov/resource/xubh-q36u/row-quy7.rbde-cdcc 460054 653289 2019-08-22 2019-03-31 28           28               28
340 340 SILOAM SPRINGS REGIONAL HOSPITAL 603 NORTH PROGRESS AVENUE SILOAM SPRINGS AR 72761 BENTON (479) 524-4141 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.1903770 -94.5096580 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-6neb~fx59-g35b 40001 653533 2019-08-30 2019-03-31 38 6         44               44
405 405 NORTH ARKANSAS REGIONAL MEDICAL CENTER 620 NORTH MAIN STREET HARRISON AR 72601 BOONE (870) 414-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.2362810 -93.1071480 0   9 5 5009 25460   Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-arky~dirt~vz74 40017 653366 2019-09-03 2019-03-31 96 24         120 14         4   138
475 475 MENNONITE GENERAL HOSPITAL INC CALLE JOSE C VASQUEZ BO. CAONILLAS AIBONITO PR 705 AIBONITO (787) 535-1001 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.1437170 -66.2628471 1 GEOMETRIC_CENTER 9 72 72009 41980 San Juan-Carolina, PR Central Aibonito Municipio https://data.medicare.gov/resource/xubh-q36u/row-bj3m-c3jd~qtix 400018 658954 2019-11-05 2019-03-31 144 6         150               150
512 512 BOLIVAR MEDICAL CENTER 901 E SUNFLOWER RD CLEVELAND MS 38732 BOLIVAR (662) 846-0061 Acute Care Hospitals Proprietary TRUE 33.7474710 -90.7081280 0   11 28 28011 17380 Cleveland-Indianola, MS Central Bolivar County https://data.medicare.gov/resource/xubh-q36u/row-6ymk.r4nx_mhwx 250093 653424 2019-09-03 2019-03-31 144 8         152 12         35   199
538 538 DAVIS HOSPITAL AND MEDICAL CENTER 1600 WEST ANTELOPE DRIVE LAYTON UT 84041 DAVIS (801) 807-7001 Acute Care Hospitals Proprietary TRUE 41.0892420 -111.9954710 0   11 49 49011 36260 Salt Lake City-Provo-Orem, UT Central Davis County https://data.medicare.gov/resource/xubh-q36u/row-wuqr~ebyx-f6ny 460041 653359 2019-08-30 2019-03-31 141 14       15 170 25 10           205
541 541 LEGACY SALMON CREEK MEDICAL CENTER 2211 NE 139TH STREET VANCOUVER WA 98686 CLARK (360) 487-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.7218230 -122.6498990 0   11 53 53011 38900 Portland-Vancouver-Salem, OR-WA Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-b4a4.2925~zmi9 500150 653361 2019-08-30 2019-03-31 128 16         166               166
565 565 ABRAZO CENTRAL CAMPUS 2000 WEST BETHANY HOME ROAD PHOENIX AZ 85015 MARICOPA (602) 249-0212 Acute Care Hospitals Physician TRUE 33.5241160 -112.1019340 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-apke-ic6r-dws7 30030 654065 2019-08-30 2019-03-31 116 28         144   16           160
566 566 ABRAZO ARROWHEAD CAMPUS 18701 NORTH 67TH AVENUE GLENDALE AZ 85308 MARICOPA (623) 561-1000 Acute Care Hospitals Proprietary TRUE 33.6550420 -112.2028890 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mbqg~urbx.9rm7 30094 654000 2019-08-29 2019-03-31 224 38         262               262
635 635 MOUNTAIN VIEW REGIONAL MEDICAL CENTER 4311 EAST LOHMAN AVENUE LAS CRUCES NM 88011 DONA ANA (575) 556-7610 Acute Care Hospitals Proprietary TRUE 32.3226390 -106.7282970 0   13 35 35013 29740 El Paso-Las Cruces, TX-NM Central Doña Ana County https://data.medicare.gov/resource/xubh-q36u/row-6m6j-xb3y-q4ig 320085 654343 2019-08-30 2019-03-31 145 23         180               180
725 725 CHICOT MEMORIAL MEDICAL CENTER 2729 SOUTH HIGHWAY 65 & 82 LAKE VILLAGE AR 71653 CHICOT (870) 265-5351 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.3056420 -91.2903530 0   17 5 5017         https://data.medicare.gov/resource/xubh-q36u/row-n4n3~4tmq_i4ky 41328 660163 2019-11-22 2019-03-31 25           25               25
830 830 DEQUINCY MEMORIAL HOSPITAL 110 WEST 4TH STREET DEQUINCY LA 70633 CALCASIEU (337) 786-1200 Critical Access Hospitals Proprietary TRUE 30.4518030 -93.4371910 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-9sya_iav2.y4rk 191307 653779 2019-09-09 2019-03-31 19           19 10             29
844 844 SOUTH LYON MEDICAL CENTER 213 S WHITACRE/PO BOX 940 YERINGTON NV 89447 LYON (775) 781-3761 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.9840873 -119.1669050 1 ROOFTOP 19 32 32019 22280 Reno-Carson City-Fernley, NV Central Lyon County https://data.medicare.gov/resource/xubh-q36u/row-ykja.hnhj~bmpe 291314 653342 2019-08-30 2019-03-31 14           14       49       63
857 857 TRIDENT MEDICAL CENTER 9330 MEDICAL PLAZA DR CHARLESTON SC 29406 CHARLESTON (843) 847-4100 Acute Care Hospitals Proprietary TRUE 32.9751280 -80.0722740 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-p4db.5rji~qzvv 420079 654485 2019-09-24 2019-03-31 384 36       14 434 17             451
898 898 CITIZENS MEDICAL CENTER 7939 U S HWY 165 SOUTH COLUMBIA LA 71418 CALDWELL (318) 649-6106 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.0778710 -92.0952180 0   21 22 22021         https://data.medicare.gov/resource/xubh-q36u/row-ivth~mw7c.ra49 190184 653245 2019-08-30 2019-03-31 40           40               40
949 949 BLECKLEY MEMORIAL HOSPITAL 145 PEACOCK STREET COCHRAN GA 31014 BLECKLEY (478) 934-6211 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.3845450 -83.3459270 0   23 13 13023         https://data.medicare.gov/resource/xubh-q36u/row-wjpa_e9pd.p88y 111302 653882 2019-09-05 2019-03-31 15           15               15
1020 1020 OAKLAWN HOSPITAL 200 N MADISON MARSHALL MI 49068 CALHOUN (269) 781-4271 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.2735330 -84.9577960 0   25 26 26025 12980 Kalamazoo-Battle Creek-Portage, MI Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-ixqw.78q4_jfqy 230217 653972 2019-08-28 2019-03-31 66 12         78               78
1056 1056 HOSPITAL MENONITA CAGUAS INC CARR 172 EXIT 21 URB TURABO GARDENS CAGUAS PR 725 CAGUAS (787) 744-3141 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.2199893 -66.0490741 1 GEOMETRIC_CENTER 25 72 72025 41980 San Juan-Carolina, PR Central Caguas Municipio https://data.medicare.gov/resource/xubh-q36u/row-j2pr-gczt~4uze 400104 658956 2019-11-05 2019-03-31 207 18         225               225
1146 1146 THE HEALTHCENTER 320 SUNNYVIEW LANE KALISPELL MT 59901 FLATHEAD (406) 756-4720 Acute Care Hospitals Proprietary FALSE 48.2162080 -114.3240470 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-q8tk.6pjn~75zu 270087 653252 2019-08-26 2019-03-31 17           17   10           27
1147 1147 KALISPELL REGIONAL MEDICAL CENTER 310 SUNNYVIEW LANE KALISPELL MT 59901 FLATHEAD (406) 752-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 48.2156850 -114.3247530 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-n6nd-i5ym.67yu 270051 653251 2019-08-26 2019-03-31 151 18         178       110       288
1148 1148 NORTH VALLEY HOSPITAL 1600 HOSPITAL WAY WHITEFISH MT 59937 FLATHEAD (406) 863-3550 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3810320 -114.3313260 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-29tt-ysrs_pnbv 271336 654458 2019-08-28 2019-03-31 21 4         25               25
1161 1161 LINTON HOSPITAL - CAH 518 NORTH BROADWAY LINTON ND 58552 EMMONS (701) 254-4511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.2710630 -100.2328710 0   29 38 38029         https://data.medicare.gov/resource/xubh-q36u/row-zu7c~i74a~kiv4 351328 651912 2019-07-15 2019-03-31 14           14               14
1253 1253 JACKSON PARK HOSPITAL 7531 S STONY ISLAND AVE CHICAGO IL 60649 COOK (773) 947-7500 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7573320 -87.5857100 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-6y5k.zxz3~agdm 140177 653314 2019-08-29 2019-03-31 193 8         201               201
1254 1254 ROSELAND COMMUNITY HOSPITAL 45 W 111TH STREET CHICAGO IL 60628 COOK (773) 995-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.6925620 -87.6247340 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-pt5k~csix_ikqj 140068 654202 2019-09-03 2019-03-31 124 10         134               134
1281 1281 CHERRY COUNTY HOSPITAL P O BOX 410, 510 NORTH GREEN ST VALENTINE NE 69201 CHERRY (402) 376-2525 Critical Access Hospitals Government - Local TRUE 42.8790786 -100.5384010 1 ROOFTOP 31 31 31031         https://data.medicare.gov/resource/xubh-q36u/row-fpwc_rzae.e38t 281344 652757 2019-07-23 2019-03-31 25           25               25
1311 1311 SHOALS HOSPITAL 201 WEST AVALON AVENUE MUSCLE SHOALS AL 35661 COLBERT (256) 386-1601 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7449410 -87.6765110 0   33 1 1033 22520   Central Colbert County https://data.medicare.gov/resource/xubh-q36u/row-ks6f.h6du~x2iz 10157 653870 2019-09-04 2019-03-31 112 10         122 30 32           184
1394 1394 CUYUNA REGIONAL MEDICAL CENTER 320 EAST MAIN STREET CROSBY MN 56441 CROW WING (218) 546-2300 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4824080 -93.9452500 0   35 27 27035 14660   Central Crow Wing County https://data.medicare.gov/resource/xubh-q36u/row-57iz_j5w8~gija 241353 654337 2019-09-09 2019-03-31 19 6         25       113       138
1451 1451 HOSPITAL MENONITA DE CAYEY BO. RINCON SECTOR LAS LOMAS KM.3.1 CARR 14 CAYEY PR 737 CAYEY (787) 535-1001 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.1243563 -66.1385053 1 ROOFTOP 35 72 72035 41980 San Juan-Carolina, PR Central Cayey Municipio https://data.medicare.gov/resource/xubh-q36u/row-tvip_6utn.5a9j 400013 655177 2019-10-11 2019-03-31 190 35         225               225
1464 1464 CASA COLINA HOSPITAL 255 E BONITA AVE POMONA CA 91767 LOS ANGELES (909) 596-7733 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.0962420 -117.7468610 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rhgb.p6kp-nbju 50782 662170 2019-11-26 2019-03-31 25 6         31   68           99
1540 1540 VIA CHRISTI HOSPITAL PITTSBURG INC 1 MT CARMEL WAY PITTSBURG KS 66762 CRAWFORD (620) 231-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3815300 -94.6838500 0   37 20 20037 38260   Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-vkqa-3pn8_khmc 170006 654017 2019-08-29 2019-03-31 54 12         66   12           78
1580 1580 ANDALUSIA HEALTH 849 SOUTH THREE NOTCH STREET ANDALUSIA AL 36420 COVINGTON (334) 222-8466 Acute Care Hospitals Proprietary TRUE 31.2974620 -86.4955990 0   39 1 1039         https://data.medicare.gov/resource/xubh-q36u/row-5sky_nfni.vnsr 10036 653819 2019-08-30 2019-03-31 75 8         83               83
1607 1607 ALLIANCEHEALTH CLINTON 100 NORTH 30TH STREET CLINTON OK 73601 CUSTER (580) 323-2363 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.5147890 -98.9968790 0   39 40 40039 48220   Central Custer County https://data.medicare.gov/resource/xubh-q36u/row-dvix_7ap3~spry 370029 653451 2019-08-30 2019-03-31 41 4         45   11           56
1681 1681 DREW MEMORIAL HOSPITAL 778 SCOGIN DRIVE MONTICELLO AR 71655 DREW (870) 367-2411 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6106280 -91.8149780 0   43 5 5043         https://data.medicare.gov/resource/xubh-q36u/row-fv6e_36f4.x8wa 40051 654082 2019-09-03 2019-03-31 44 5         49               49
1816 1816 LEGACY SILVERTON MEDICAL CENTER 342 FAIRVIEW STREET SILVERTON OR 97381 MARION (503) 873-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.0045640 -122.7907460 0   47 41 41047 41420 Portland-Vancouver-Salem, OR-WA Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-wm4f.qf22_nr3s 380029 654480 2019-08-30 2019-03-31 25 4         29               29
1826 1826 DEKALB REGIONAL MEDICAL CENTER 200 MED CENTER DRIVE FORT PAYNE AL 35968 DE KALB (256) 845-3150 Acute Care Hospitals Proprietary TRUE 34.4419753 -85.7550138 1 ROOFTOP 49 1 1049         https://data.medicare.gov/resource/xubh-q36u/row-pt4k~hfcs.k9m2 10012 653737 2019-08-22 2019-03-31 85 12         97 18             115
1922 1922 LEGACY EMANUEL MEDICAL CENTER 2801 N GANTENBEIN AVENUE PORTLAND OR 97227 MULTNOMAH (503) 413-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5440500 -122.6694450 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-7f4v.d6m7-2kdb 380007 654861 2019-09-26 2019-03-31 263           384 101             485
1925 1925 LEGACY GOOD SAMARITAN MEDICAL CENTER 1015 NW 22ND AVENUE, W121 PORTLAND OR 97210 MULTNOMAH (503) 413-7711 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5305510 -122.6965890 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-6zih.h2xm.wkif 380017 653351 2019-08-30 2019-03-31 136 28         164   36           200
1926 1926 LEGACY MOUNT HOOD MEDICAL CENTER 24800 SE STARK STREET GRESHAM OR 97030 MULTNOMAH (503) 674-1122 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5190530 -122.4082790 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-cxuh~ek4n_xkr9 380025 653352 2019-08-30 2019-03-31 83 10         93               93
1952 1952 THE MEDICAL CENTER AT ALBANY 723 BURKESVILLE ROAD ALBANY KY 42602 CLINTON (606) 387-6421 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6983350 -85.1465540 0   53 21 21053         https://data.medicare.gov/resource/xubh-q36u/row-py7x~3tmy.cdg5 180106 653670 2019-09-03 2019-03-31 38           38               38
1965 1965 CABINET PEAKS MEDICAL CENTER 209 HEALTH PARK DR LIBBY MT 59923 LINCOLN (406) 293-0100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3926210 -115.5462710 0   53 30 30053         https://data.medicare.gov/resource/xubh-q36u/row-rev2~xaru.cjba 271320 654457 2019-08-28 2019-03-31 25           25               25
2097 2097 HOSPITAL MENONITA GUAYAMA AVE. PEDRO ALBIZU CAMPOS URB. LA HACIENDA GUAYAMA PR 785 GUAYANILLA (787) 864-4300 Acute Care Hospitals Voluntary non-profit - Church TRUE 17.9739992 -66.1065029 1 GEOMETRIC_CENTER 57 72 72057 25020 San Juan-Carolina, PR Central Guayama Municipio https://data.medicare.gov/resource/xubh-q36u/row-by64~txfx~5j23 400048 653990 2019-09-03 2019-03-31 110 6         116               116
2227 2227 VALLEY REGIONAL MEDICAL CENTER 100 A ALTON GLOOR BROWNSVILLE TX 78526 CAMERON (956) 350-7000 Acute Care Hospitals Proprietary TRUE 25.9780246 -97.5146344 1 ROOFTOP 61 48 48061 15180 Brownsville-Harlingen-Raymondville, TX Central Cameron County https://data.medicare.gov/resource/xubh-q36u/row-8upk-rgcf.533w 450662 653217 2019-08-28 2019-03-31 186 18       10 214               214
2327 2327 PARKRIDGE MEDICAL CENTER 2333 MCCALLIE AVE CHATTANOOGA TN 37404 HAMILTON (423) 894-4220 Acute Care Hospitals Proprietary TRUE 35.0337390 -85.2688600 0   65 47 47065 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-5m9j_jhfi~zhhr 440156 653858 2019-08-30 2019-03-31 325 33       22 380 44 12 24         460
2373 2373 LEGACY MERIDIAN PARK MEDICAL CENTER 19300 SW 65TH AVENUE TUALATIN OR 97062 WASHINGTON (503) 692-2182 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.3774810 -122.7439310 0   67 41 41067 38900 Portland-Vancouver-Salem, OR-WA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-wudw-qmsk_mszn 380089 653353 2019-08-30 2019-03-31 101 16         117               117
2397 2397 HARDIN COUNTY GENERAL HOSPITAL FERRELL ROAD ROSICLARE IL 62982 HARDIN (618) 285-6634 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.4103431 -88.3558252 1 GEOMETRIC_CENTER 69 17 17069         https://data.medicare.gov/resource/xubh-q36u/row-p9aq.m5aa.6pkb 141328 653315 2019-08-29 2019-03-31 25           25               25
2409 2409 HEART OF AMERICA MEDICAL CENTER 800 S MAIN AVE RUGBY ND 58368 PIERCE (701) 776-5261 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3635110 -99.9961110 0   69 38 38069         https://data.medicare.gov/resource/xubh-q36u/row-qi8i~9ssv.ufv2 351332 654478 2019-08-30 2019-03-31 25           25       55       80
2538 2538 MERIT HEALTH WESLEY 5001 W HARDY ST HATTIESBURG MS 39402 LAMAR (601) 268-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.3230580 -89.3669000 0   73 28 28073 25620   Central Lamar County https://data.medicare.gov/resource/xubh-q36u/row-km5x_fm4w~g8dw 250094 653587 2019-08-29 2019-03-31 113 17         130 13     24       167
2603 2603 MEMORIAL HOSPITAL OF CARBONDALE 405 W JACKSON CARBONDALE IL 62901 JACKSON (618) 549-0721 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7279730 -89.2201210 0   77 17 17077 16060   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-2ipw_2w48-wu9a 140164 653132 2019-08-27 2019-03-31 133 21       13 167               167
2604 2604 ST JOSEPH MEMORIAL HOSPITAL 2 SOUTH HOSPITAL DRIVE MURPHYSBORO IL 62966 JACKSON (618) 684-3156 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.7732050 -89.3263500 0   77 17 17077 16060   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-nyfv~asqm.5q4f 141334 653239 2019-08-23 2019-03-31 25           25               25
2707 2707 HARRISON COUNTY COMMUNITY HOSPITAL 2600 MILLER STREET BETHANY MO 64424 HARRISON (660) 425-0284 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.2652920 -94.0261450 0   81 29 29081         https://data.medicare.gov/resource/xubh-q36u/row-myhp~ktka_u8d3 261312 653250 2019-08-20 2019-03-31 14           14               14
2754 2754 GOLDEN VALLEY MEMORIAL HOSPITAL 1600 N 2ND ST CLINTON MO 64735 HENRY (660) 885-5511 Acute Care Hospitals Government - Hospital District or Authority TRUE 38.3913890 -93.7705060 0   83 29 29083         https://data.medicare.gov/resource/xubh-q36u/row-4nw8.8waa_7twa 260175 653249 2019-08-21 2019-03-31 34 8         42               42
2790 2790 HOLTON COMMUNITY HOSPITAL 1110 COLUMBINE DRIVE HOLTON KS 66436 JACKSON (785) 364-2116 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4794640 -95.7509080 0   85 20 20085 45820   Outlying Jackson County https://data.medicare.gov/resource/xubh-q36u/row-8a8r_8yba-yt3v 171319 653242 2019-08-21 2019-03-31 12           12               12
2792 2792 SABINE MEDICAL CENTER 240 HIGHLAND DRIVE MANY LA 71449 SABINE (318) 256-1232 Acute Care Hospitals Proprietary TRUE 31.5604480 -93.4709830 0   85 22 22085         https://data.medicare.gov/resource/xubh-q36u/row-hq48.q6wx-zncf 190218 654331 2019-09-09 2019-03-31 48           48               48
2811 2811 BAYLOR SCOTT & WHITE MEDICAL CENTER - CENTENNIAL 12505 LEBANON ROAD FRISCO TX 75035 COLLIN (972) 963-3333 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.1158710 -96.7698920 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-mwua_bzhk.yenq 450885 653285 2019-08-29 2019-03-31 92 12       14 118               118
2812 2812 MEDICAL CITY PLANO 3901 W 15TH ST PLANO TX 75075 COLLIN (972) 596-6800 Acute Care Hospitals Proprietary TRUE 33.0193870 -96.7657300 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-tpnt.jr5f_tzah 450651 653284 2019-08-28 2019-03-31 324   76     41 441   20           461
2852 2852 MEMORIAL HOSPITAL AND MANOR 1500 E SHOTWELL STREET BAINBRIDGE GA 39819 DECATUR (229) 246-3500 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.9037810 -84.5536700 0   87 13 13087 12460 Tallahassee-Bainbridge, FL-GA Central Decatur County https://data.medicare.gov/resource/xubh-q36u/row-74nj_m8fg-jx3q 110132 653382 2019-08-28 2019-03-31 70 10         80       107       187
2864 2864 HELEN HAYES HOSPITAL 51 NORTH ROUTE 9W WEST HAVERSTRAW NY 10993 ROCKLAND (845) 786-4000 Acute Care Hospitals Government - Local FALSE 41.2127790 -73.9857680 0   87 36 36087 35620 New York-Newark, NY-NJ-CT-PA Central Rockland County https://data.medicare.gov/resource/xubh-q36u/row-ye8c.wrcw~884k 330405 653449 2019-09-06 2019-03-31                 106   49       155
2872 2872 HENRICO DOCTORS' HOSPITAL 1602 SKIPWITH ROAD RICHMOND VA 23229 HENRICO (804) 289-4500 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.6040450 -77.5377170 0   87 51 51087 40060   Central Henrico County https://data.medicare.gov/resource/xubh-q36u/row-d52i.bns3.tppc 490118 653527 2019-09-03 2019-03-31 595 17 24   12 37 685 46 36           767
2884 2884 ARKANSAS VALLEY REGIONAL MEDICAL CENTER 1100 CARSON AVENUE LA JUNTA CO 81050 OTERO (719) 383-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9769290 -103.5487420 0   89 8 8089         https://data.medicare.gov/resource/xubh-q36u/row-967u~ukgn_sq4q 61336 653832 2019-08-29 2019-03-31 16 506         522       30       552
2938 2938 NORTH OKALOOSA MEDICAL CENTER 151 REDSTONE AVE SE CRESTVIEW FL 32539 OKALOOSA (850) 689-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.7369470 -86.5618420 0   91 12 12091 18880   Central Okaloosa County https://data.medicare.gov/resource/xubh-q36u/row-st5i~zswh-quid 100122 654719 2019-09-20 2019-03-31 90 20         110               110
2996 2996 ST JAMES PARISH HOSPITAL 1645 LUTCHER AVENUE LUTCHER LA 70071 ST. JAMES (225) 869-5512 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.0513910 -90.7018900 0   93 22 22093 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. James Parish https://data.medicare.gov/resource/xubh-q36u/row-5r4n.ki8u.r7sd 191305 653142 2019-08-28 2019-03-31 25           25               25
3054 3054 CENTERPOINT MEDICAL CENTER 19600 EAST 39TH STREET INDEPENDENCE MO 64057 JACKSON (816) 698-7000 Acute Care Hospitals Proprietary TRUE 39.0477710 -94.3493130 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-iwpd.bh6w~c7gg 260095 653909 2019-08-26 2019-03-31 177 40 36       265   16           281
3065 3065 ALLIANCEHEALTH MADILL 901 S 5TH AVE MADILL OK 73446 MARSHALL (580) 795-3384 Critical Access Hospitals Proprietary TRUE 34.0817380 -96.7784500 0   95 40 40095         https://data.medicare.gov/resource/xubh-q36u/row-b6vq_dbi2_tjfb 371326 653270 2019-08-30 2019-03-31 21           21               21
3077 3077 MOBILE INFIRMARY MEDICAL CENTER 5 MOBILE INFIRMARY CIRCLE MOBILE AL 36652 MOBILE (251) 435-4700 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.6964430 -88.0810170 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-5pcu_va59~2efz 10113 653822 2019-08-30 2019-03-31 547 14 14   24 12 611 17 41           669
3085 3085 SONOMA SPECIALTY HOSPITAL 501 PETALUMA AVENUE SEBASTOPOL CA 95472 SONOMA (707) 823-8511 Acute Care Hospitals Government - Local TRUE 38.3971390 -122.8204370 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-57b8_at7i-gjwt 50781 659918 2019-07-26 2019-03-31 32 5         37               37
3092 3092 LAKE BEHAVIORAL HOSPITAL 2615 W WASHINGTON ST WAUKEGAN IL 60085 LAKE (847) 249-3900 Acute Care Hospitals Proprietary TRUE 42.3594020 -87.8666050 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-t57b.6rbp-musy 140033 654119 2019-09-04 2019-03-31               46             46
3110 3110 MACKINAC STRAITS HOSPITAL AND HEALTH CENTER 1140 N STATE STREET SAINT IGNACE MI 49781 MACKINAC (906) 643-8585 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8910240 -84.7275690 0   97 26 26097         https://data.medicare.gov/resource/xubh-q36u/row-qcen.rt7a~rgc3 231306 655210 2019-10-09 2019-03-31 15           15       48       63
3122 3122 HILLCREST HOSPITAL PRYOR 111 NORTH BAILEY STREET PRYOR OK 74361 MAYES (918) 825-1600 Acute Care Hospitals Proprietary TRUE 36.3082740 -95.3053880 0   97 40 40097         https://data.medicare.gov/resource/xubh-q36u/row-zivh.t584.w3vu 370015 653268 2019-08-30 2019-03-31 24           24               24
3161 3161 THE MEDICAL CENTER AT CAVERNA 1501 SOUTH DIXIE STREET HORSE CAVE KY 42749 HART (270) 786-2191 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1603360 -85.9231720 0   99 21 21099         https://data.medicare.gov/resource/xubh-q36u/row-iigz-6fve-xf87 181314 654250 2019-09-03 2019-03-31 25           25               25
3243 3243 DECATUR MORGAN HOSPITAL-DECATUR CAMPUS 1201 7TH STREET SE DECATUR AL 35601 MORGAN (256) 341-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.5911680 -86.9726210 0   103 1 1103 19460 Huntsville-Decatur-Albertville, AL Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-j3pt~7hw5~edsk 10085 653820 2019-09-03 2019-03-31 166 23 11       200 64             264
3271 3271 OCHSNER MEDICAL CENTER - NORTHSHORE, L L C 100 MEDICAL CENTER DRIVE SLIDELL LA 70461 ST. TAMMANY (985) 646-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2862430 -89.7431320 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-6y24-p7cg-m3ix 190204 654025 2019-08-29 2019-03-31 125 20       5 150   18           168
3310 3310 LINCOLN COUNTY HOSPITAL 624 N SECOND LINCOLN KS 67455 LINCOLN (785) 524-4403 Critical Access Hospitals Government - Local FALSE 39.0451750 -98.1443700 0   105 20 20105         https://data.medicare.gov/resource/xubh-q36u/row-teha_g9nc~sv4a 171360 654126 2019-09-04 2019-03-31 10           10               10
3350 3350 ALLIANCEHEALTH SEMINOLE 2401 WRANGLER BOULEVARD SEMINOLE OK 74868 SEMINOLE (405) 303-4050 Acute Care Hospitals Proprietary TRUE 35.2464640 -96.6990130 0   133 40 40133         https://data.medicare.gov/resource/xubh-q36u/row-t47q~8ahq-97c8 370229 654158 2019-09-13 2019-03-31 32           32               32
3352 3352 MERCER COUNTY JOINT TOWNSHIP COMMUNITY HOSPITAL 800 WEST MAIN STREET COLDWATER OH 45828 MERCER (419) 678-4843 Acute Care Hospitals Government - Hospital District or Authority FALSE 40.4797820 -84.6382430 0   107 39 39107 16380 Lima-Van Wert-Celina, OH Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-wqa9_97uu.ces7 360058 653713 2019-08-27 2019-03-31 37 5         42               42
3363 3363 TROY REGIONAL MEDICAL CENTER 1330 HIGHWAY 231 SOUTH TROY AL 36081 PIKE (334) 670-5000 Acute Care Hospitals Government - Federal TRUE 31.7803220 -85.9455290 0   109 1 1109 45980   Central Pike County https://data.medicare.gov/resource/xubh-q36u/row-5ter_pyex-x2fe 10126 654064 2019-08-30 2019-03-31 88 9         97 18             115
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
3406 3406 CULBERSON HOSPITAL EISENHOWER ROAD AND FM 2185 VAN HORN TX 79855 CULBERSON (432) 283-2760 Critical Access Hospitals Proprietary FALSE 31.0496690 -104.8283880 0   109 48 48109         https://data.medicare.gov/resource/xubh-q36u/row-g73p-emdj_vjx2 451338 653287 2019-08-29 2019-03-31 14           14               14
3512 3512 HAYWARD AREA MEMORIAL HOSPITAL 11040 N STATE RD 77 HAYWARD WI 54843 SAWYER (715) 934-4321 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0354000 -91.4884650 0   113 55 55113         https://data.medicare.gov/resource/xubh-q36u/row-m9mb_emjr_zips 521336 653363 2019-08-29 2019-03-31 25           25       50       75
3542 3542 MEDICAL ARTS HOSPITAL 2200 N BRYAN AVE LAMESA TX 79331 DAWSON (806) 872-2183 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7502790 -101.9664700 0   115 48 48115 29500   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-epaw-jzbp_b5c6 450489 653519 2019-09-03 2019-03-31 22           22               22
3560 3560 SHERIDAN COMMUNITY HOSPITAL 301 N MAIN ST SHERIDAN MI 48884 MONTCALM (989) 291-3261 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2154440 -85.0735660 0   117 26 26117 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Montcalm County https://data.medicare.gov/resource/xubh-q36u/row-76f7~3hgm.9t9p 231312 654260 2019-09-04 2019-03-31 22           22               22
3639 3639 SALEM TOWNSHIP HOSPITAL 1201 RICKER DRIVE SALEM IL 62881 MARION (618) 548-3194 Critical Access Hospitals Government - Local TRUE 38.6408300 -88.9483370 0   121 17 17121 16460 St. Louis-St. Charles-Farmington, MO-IL Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-ha9g~pxnq-kea7 141345 654203 2019-09-09 2019-03-31 25           25               25
3677 3677 MITCHELL COUNTY HOSPITAL HEALTH SYSTEMS 400 W 8TH STREET, P O BOX 399 BELOIT KS 67420 MITCHELL (785) 738-2266 Critical Access Hospitals Government - Local TRUE 39.4664990 -98.1142350 0   123 20 20123         https://data.medicare.gov/resource/xubh-q36u/row-pzzg_8xf8_sq7i 171375 654375 2019-08-30 2019-03-31 12 4         16 10     40       66
3745 3745 MASSAC MEMORIAL HOSPITAL 28 CHICK STREET, PO BOX 850 METROPOLIS IL 62960 MASSAC (618) 524-2176 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.1668360 -88.7395780 0   127 17 17127 37140 Paducah-Mayfield, KY-IL Outlying Massac County https://data.medicare.gov/resource/xubh-q36u/row-xx73_2wjk~8zu2 141323 654243 2019-09-03 2019-03-31 25           25               25
3749 3749 THREE RIVERS MEDICAL CENTER 2485 HIGHWAY 644 LOUISA KY 41230 LAWRENCE (606) 638-9451 Acute Care Hospitals Proprietary TRUE 38.0933000 -82.6047400 0   127 21 21127         https://data.medicare.gov/resource/xubh-q36u/row-j4ps_phu6_dvj7 180128 654022 2019-08-29 2019-03-31 59 6         65 19             84
3750 3750 WINN PARISH MEDICAL CENTER 301 W BOUNDARY AVE WINNFIELD LA 71483 WINN (318) 648-3000 Acute Care Hospitals Proprietary TRUE 31.9249790 -92.6451390 0   127 22 22127         https://data.medicare.gov/resource/xubh-q36u/row-tecb_9uuz_3xte 190090 653892 2019-09-09 2019-03-31 41 5         46               46
3757 3757 PUSHMATAHA COUNTY TOWN OF ANTLERS HOSPITAL 510 EAST MAIN STREET ANTLERS OK 74523 PUSHMATAHA (580) 298-3341 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.2317170 -95.6156030 0   127 40 40127         https://data.medicare.gov/resource/xubh-q36u/row-2h9r-9buw.dkj2 370083 653854 2019-09-03 2019-03-31 42           42               42
3790 3790 BERGER HOSPITAL 600 NORTH PICKAWAY STREET CIRCLEVILLE OH 43113 PICKAWAY (740) 420-8020 Acute Care Hospitals Government - Local TRUE 39.6102810 -82.9377470 0   129 39 39129 18140 Columbus-Marion-Zanesville, OH Outlying Pickaway County https://data.medicare.gov/resource/xubh-q36u/row-zp45_7tue~gsqz 360170 655646 2019-10-23 2019-03-31 75 8         83               83
3796 3796 SPOONER HEALTH SYSTEM 1280 CHANDLER DR SPOONER WI 54801 WASHBURN (715) 635-2111 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8414373 -91.8703438 1 ROOFTOP 129 55 55129         https://data.medicare.gov/resource/xubh-q36u/row-y5vj~v6dk_vfyv 521332 653362 2019-08-30 2019-03-31 20           20               20
3861 3861 SEQUOYAH COUNTY-CITY OF SALLISAW HOSPITAL AUTHORIT 213 EAST REDWOOD SALLISAW OK 74955 SEQUOYAH (918) 774-1100 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.4635630 -94.7890400 0   135 40 40135 22900   Outlying Sequoyah County https://data.medicare.gov/resource/xubh-q36u/row-8fna.wsab~hcry 370112 653452 2019-09-04 2019-03-31 41           41               41
3892 3892 HOLLAND COMMUNITY HOSPITAL 602 MICHIGAN AVE HOLLAND MI 49423 OTTAWA (616) 392-5141 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7745810 -86.1127720 0   139 26 26139 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-c44k-ptca~3ckt 230072 654029 2019-08-29 2019-03-31 181 8         189               189
3984 3984 FREEMAN HEALTH SYSTEM - FREEMAN WEST 1102 WEST 32ND STREET JOPLIN MO 64804 JASPER (417) 347-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.0544080 -94.5268840 0   145 29 29145 27900 Joplin-Miami, MO-OK Outlying Newton County https://data.medicare.gov/resource/xubh-q36u/row-z9xx.uegx.4u5a 260137 654453 2019-09-05 2019-03-31 298 39       24 361 10 20           391
3986 3986 FREEMAN NEOSHO HOSPITAL 113 WEST HICKORY STREET NEOSHO MO 64850 NEWTON (417) 451-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.8676140 -94.3687870 0   145 29 29145 27900 Joplin-Miami, MO-OK Outlying Newton County https://data.medicare.gov/resource/xubh-q36u/row-w9w5_ehe3-ntf6 261331 654736 2019-10-01 2019-03-31 25           25               25

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