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

151 rows where "filed_date" is on date 2019-03-01 sorted by cbsacode

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-03-01 · 151 ✖
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
4 4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
209 209 MEMORIAL HOSPITAL, THE 3073 WHITE MOUNTAIN HIGHWAY NORTH CONWAY NH 3860 CARROLL (603) 356-5461 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0605190 -71.1385100 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-n7xq-6ijr_9ppy 301307 645671 2019-03-01 2018-09-30 21 4         25         45     70
251 251 MEMORIAL MEDICAL CENTER 1615 MAPLE LANE ASHLAND WI 54806 ASHLAND (715) 685-5500 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5668870 -90.8879780 0   3 55 55003         https://data.medicare.gov/resource/xubh-q36u/row-d5tf.6nqz~nbsb 521359 645519 2019-03-01 2018-09-30 25           25 10             35
363 363 BAPTIST MEDICAL CENTER-ATTALA 220 HWY 12 WEST KOSCIUSKO MS 39090 ATTALA (662) 289-4311 Critical Access Hospitals Voluntary non-profit - Other TRUE 33.0655920 -89.5967210 0   7 28 28007         https://data.medicare.gov/resource/xubh-q36u/row-24jy_6div~59c7 251336 644042 2019-03-01 2018-09-30 25           25               25
548 548 REGIONAL MEDICAL CENTER OF CENTRAL ALABAMA 29 L V STABLER DRIVE GREENVILLE AL 36037 BUTLER (334) 382-2200 Acute Care Hospitals Proprietary TRUE 31.8294500 -86.6458600 0   13 1 1013         https://data.medicare.gov/resource/xubh-q36u/row-ca8j-ucpx~zp9d 10150 645390 2019-03-01 2018-09-30 37 7         44 13             57
618 618 BMH-CALHOUN 140 BURKE-CALHOUN CITY ROAD CALHOUN CITY MS 38916 CALHOUN (662) 628-6611 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8696650 -89.3171760 0   13 28 28013         https://data.medicare.gov/resource/xubh-q36u/row-583j-immm~hxvr 251331 643806 2019-03-01 2018-09-30 25           25               25
708 708 THE PHYSICIANS' HOSPITAL IN ANADARKO 1002 E CENTRAL BLVD ANADARKO OK 73005 CADDO (405) 247-8236 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0722700 -98.2279900 0   15 40 40015         https://data.medicare.gov/resource/xubh-q36u/row-p7ys.d7q7.puqw 371314 644773 2019-03-01 2018-09-30 25           25               25
716 716 COPLEY HOSPITAL 528 WASHINGTON HIGHWAY MORRISVILLE VT 5661 LAMOILLE (802) 888-4231 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5541860 -72.5912140 0   15 50 50015         https://data.medicare.gov/resource/xubh-q36u/row-ddkp~wcpj_r9te 471305 645509 2019-03-01 2018-09-30 25           25               25
774 774 CAPE FEAR VALLEY-BLADEN COUNTY HOSPITAL 501 SOUTH POPLAR STREET ELIZABETHTOWN NC 28337 BLADEN (910) 862-5100 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6234740 -78.6082980 0   17 37 37017         https://data.medicare.gov/resource/xubh-q36u/row-t5uc~43ax~cbx3 341315 645438 2019-03-01 2018-09-30 21 4         25               25
838 838 CHOCTAW REGIONAL MEDICAL CENTER 8613 MS HWY 12 ACKERMAN MS 39735 CHOCTAW (662) 285-4400 Critical Access Hospitals Government - Local TRUE 33.3184650 -89.1823040 0   19 28 28019         https://data.medicare.gov/resource/xubh-q36u/row-9nt3~77et_z9mg 251334 643914 2019-03-01 2018-09-30 15           15         73     88
1038 1038 MCLEOD HEALTH CHERAW 711 CHESTERFIELD HIGHWAY CHERAW SC 29520 CHESTERFIELD (843) 537-7881 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.6953720 -79.9180960 0   25 45 45025         https://data.medicare.gov/resource/xubh-q36u/row-gcbc~ig8b~ej5u 420107 645362 2019-03-01 2018-09-30 42 6         48               48
1102 1102 MCLEOD HEALTH CLARENDON 10 EAST HOSPITAL STREET MANNING SC 29102 CLARENDON (803) 435-8463 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6878660 -80.2117670 0   27 45 45027         https://data.medicare.gov/resource/xubh-q36u/row-vf43_k4z3~k3q8 420109 645363 2019-03-01 2018-09-30 43 6         49               49
1196 1196 ROY LESTER SCHNEIDER HOSPITAL,THE 9048 SUGAR ESTATE ST THOMAS VI 801 SAINT THOMAS ISLAND (809) 776-8311 Acute Care Hospitals Government - Local TRUE 18.3403280 -64.9146707 1 ROOFTOP 30 78 78030         https://data.medicare.gov/resource/xubh-q36u/row-smqm-6qpj_ky9s 480001 644382 2019-03-01 2018-09-30 99 8         107               107
1293 1293 ELIZABETHTOWN COMMUNITY HOSPITAL 75 PARK STREET ELIZABETHTOWN NY 12932 ESSEX (518) 873-6377 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2154300 -73.5966240 0   31 36 36031         https://data.medicare.gov/resource/xubh-q36u/row-5q4b-47ss~5b4c 331302 645483 2019-03-01 2018-09-30 25           25               25
1354 1354 MCLEOD MEDICAL CENTER - DILLON 301 E JACKSON STREET PO BOX 1327 DILLON SC 29536 DILLON (843) 774-4111 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.4212660 -79.3661070 0   33 45 45033         https://data.medicare.gov/resource/xubh-q36u/row-6w6y-vqzn-x943 420005 645356 2019-03-01 2018-09-30 66 6         72               72
1592 1592 MERCY REGIONAL MEDICAL CENTER 800 E MAIN VILLE PLATTE LA 70586 EVANGELINE (337) 363-5684 Acute Care Hospitals Proprietary TRUE 30.6849310 -92.2659730 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-2sdk.fhzr.wwum 190167 645559 2019-03-01 2018-09-30 85 14         99   10           109
1743 1743 CHADRON COMMUNITY HOSPITAL CORP 825 CENTENNIAL DRIVE CHADRON NE 69337 DAWES (308) 432-5586 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8225730 -103.0128660 0   45 31 31045         https://data.medicare.gov/resource/xubh-q36u/row-9xyh-jdjr.unui 281341 645579 2019-03-01 2018-09-30 25           25               25
1898 1898 GIBSON GENERAL HOSPITAL 1808 SHERMAN DR PRINCETON IN 47670 GIBSON (812) 385-3401 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.3602310 -87.5895590 0   51 18 18051         https://data.medicare.gov/resource/xubh-q36u/row-79ak.ea49~jzf3 151319 645409 2019-03-01 2018-09-30 20 5         25               25
1901 1901 ADVENTHEALTH MANCHESTER 210 MARIE LANGDON DRIVE MANCHESTER KY 40962 CLAY (606) 598-5104 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.1621540 -83.7613560 0   51 21 21051         https://data.medicare.gov/resource/xubh-q36u/row-vicy-u46v-q8em 180043 644277 2019-03-01 2018-09-30 43 6         49               49
1938 1938 D W MCMILLAN MEMORIAL HOSPITAL 1301 BELLEVILLE AVENUE BREWTON AL 36426 ESCAMBIA (251) 867-8061 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.1271050 -87.0723780 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-ug8v.qapr~xntq 10099 644201 2019-03-01 2018-09-30 38 8         46               46
2004 2004 CRITTENDEN COMMUNITY HOSPITAL 520 WEST GUM STREET MARION KY 42064 CRITTENDEN (270) 965-1001 Acute Care Hospitals Government - Local TRUE 37.3296160 -88.0919450 0   55 21 21055         https://data.medicare.gov/resource/xubh-q36u/row-29y5_rw8y-4sga 180095 643771 2019-03-01 2018-09-30 48           48               48
2140 2140 LASALLE GENERAL HOSPITAL 187 NINTH ST/HWY 84 WEST JENA LA 71342 LASALLE (318) 992-9200 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6831927 -92.1337360 1 GEOMETRIC_CENTER 59 22 22059         https://data.medicare.gov/resource/xubh-q36u/row-dbin~f8yn~yhkn 190145 644279 2019-03-01 2018-09-30 30           30 16             46
2176 2176 HOWARD MEMORIAL HOSPITAL 130 MEDICAL CIRCLE NASHVILLE AR 71852 HOWARD (870) 845-4400 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.9509260 -93.8807720 0   61 5 5061         https://data.medicare.gov/resource/xubh-q36u/row-943b-exqy.j5es 41311 643866 2019-03-01 2018-09-30 25           25               25
2243 2243 JACKSON HOSPITAL 4250 HOSPITAL DR MARIANNA FL 32446 JACKSON (850) 526-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7874800 -85.2409320 0   63 12 12063         https://data.medicare.gov/resource/xubh-q36u/row-kd9h-xmn9-4awy 100142 645398 2019-03-01 2018-09-30 59 7         66               66
2612 2612 LAWRENCE COUNTY HOSPITAL CAH 1065 EAST BROAD ST / PO BOX 788 MONTICELLO MS 39654 LAWRENCE (601) 587-4051 Critical Access Hospitals Government - Local TRUE 31.5534190 -90.1002620 0   77 28 28077         https://data.medicare.gov/resource/xubh-q36u/row-rkyi-kmeu_5f45 251305 643909 2019-03-01 2018-09-30 25           25               25
2650 2650 BAPTIST MEDICAL CENTER-LEAKE 1100 HIGHWAY 16 EAST CARTHAGE MS 39051 LEAKE (601) 267-1422 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.7385330 -89.5164100 0   79 28 28079         https://data.medicare.gov/resource/xubh-q36u/row-mxfu-3fr5~s5kq 251315 643911 2019-03-01 2018-09-30 25           25               25
2668 2668 COCHRAN MEMORIAL HOSPITAL 205 E GRANT STREET MORTON TX 79346 COCHRAN (806) 266-5565 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7192940 -102.7580750 0   79 48 48079         https://data.medicare.gov/resource/xubh-q36u/row-cdg6.bkks~3hn7 451366 643985 2019-03-01 2018-09-30 18           18               18
3112 3112 TYLER HOLMES MEMORIAL HOSPITAL CAH 409 TYLER HOLMES DRIVE WINONA MS 38967 MONTGOMERY (662) 283-4114 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.4906520 -89.7377480 0   97 28 28097         https://data.medicare.gov/resource/xubh-q36u/row-ynxj~8abv-iadk 251312 643802 2019-03-01 2018-09-30 25           25               25
3353 3353 CREEK NATION COMMUNITY HOSPITAL 1800 E COPLIN OKEMAH OK 74859 OKFUSKEE (918) 623-1424 Critical Access Hospitals Tribal TRUE 35.4206670 -96.3042900 0   107 40 40107         https://data.medicare.gov/resource/xubh-q36u/row-eqjs.ws8m-7374 371333 644340 2019-03-01 2018-09-30 25           25               25
3366 3366 EVANS MEMORIAL HOSPITAL 200 N RIVER STREET CLAXTON GA 30417 EVANS (912) 739-5105 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.1641330 -81.9004030 0   109 13 13109         https://data.medicare.gov/resource/xubh-q36u/row-kvst.dgp7-seha 110142 644715 2019-03-01 2018-09-30 49           49 10             59
3412 3412 COMMONWEALTH HEALTH CENTER 1 LOWER NAVY HILL ROAD (PO BOX 409CK) GARAPAN MP 96950 SAIPAN (670) 234-8950 Acute Care Hospitals Proprietary TRUE 15.2086299 145.7303467 1 GEOMETRIC_CENTER 110 69 69110         https://data.medicare.gov/resource/xubh-q36u/row-z8uz.de7b_sx86 660001 644688 2019-03-01 2018-09-30 70 4         74               74
3479 3479 ANGEL MEDICAL CENTER 120 RIVERVIEW ST PO BOX 1209 FRANKLIN NC 28734 MACON (828) 524-8411 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.1846340 -83.3776400 0   113 37 37113         https://data.medicare.gov/resource/xubh-q36u/row-7yi7_miqw_9mna 341326 645352 2019-03-01 2018-09-30 20 5         25               25
3652 3652 BLUE RIDGE REGIONAL HOSPITAL 125 HOSPITAL DR SPRUCE PINE NC 28777 MITCHELL (828) 765-4201 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9110300 -82.0645930 0   121 37 37121         https://data.medicare.gov/resource/xubh-q36u/row-kdxn~cinw_ttrc 341329 645353 2019-03-01 2018-09-30 25           25               25
3690 3690 FIRSTHEALTH MONTGOMERY MEMORIAL HOSP 520 ALLEN STREET TROY NC 27371 MONTGOMERY (910) 572-1301 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.3644300 -79.8915570 0   123 37 37123         https://data.medicare.gov/resource/xubh-q36u/row-vp9e-re8p-tifk 341303 645139 2019-03-01 2018-09-30 4           4               4
3760 3760 DIMMIT REGIONAL HOSPITAL 704 HOSPITAL DRIVE CARRIZO SPRINGS TX 78834 DIMMIT (830) 876-2424 Critical Access Hospitals Voluntary non-profit - Other TRUE 28.5199740 -99.8620980 0   127 48 48127         https://data.medicare.gov/resource/xubh-q36u/row-f4ys-ri9j-kfns 451390 643855 2019-03-01 2018-09-30 25           25               25
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
4022 4022 ST LUKES HOSPITAL 101 HOSPITAL DRIVE COLUMBUS NC 28722 POLK (828) 894-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.2418330 -82.2136460 0   149 37 37149         https://data.medicare.gov/resource/xubh-q36u/row-wtmr-3fw6_9q8w 341322 645350 2019-03-01 2018-09-30 19 6         25 10             35
4196 4196 MEMORIAL HOSPITAL 209 NORTHWEST 8TH STREET SEMINOLE TX 79360 GAINES (432) 758-4854 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.7213190 -102.6537290 0   165 48 48165         https://data.medicare.gov/resource/xubh-q36u/row-3czq_q5xj.bax4 451358 643854 2019-03-01 2018-09-30 25           25               25
4206 4206 THE JAMES B HAGGIN MEMORIAL HOSPITAL 464 LINDEN AVENUE HARRODSBURG KY 40330 MERCER (859) 239-2409 Critical Access Hospitals Voluntary non-profit - Other TRUE 37.7564480 -84.8482120 0   167 21 21167         https://data.medicare.gov/resource/xubh-q36u/row-wq8e~n6v3_qk82 181302 658990 2019-03-01 2018-09-30 21 4         25               25
4335 4335 OSF HOLY FAMILY MEDICAL CENTER 1000 W HARLEM AVENUE MONMOUTH IL 61462 WARREN (309) 734-3141 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.9212910 -90.6589860 0   187 17 17187         https://data.medicare.gov/resource/xubh-q36u/row-ndee.5fb3~7qje 141318 645471 2019-03-01 2018-09-30 23           23               23
4455 4455 HASKELL MEMORIAL HOSPITAL 1 NORTH AVENUE N PO BOX 1117 HASKELL TX 79521 HASKELL (940) 864-2621 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.1572901 -99.7446581 1 ROOFTOP 207 48 48207         https://data.medicare.gov/resource/xubh-q36u/row-66f3~mect.vjwe 451341 644375 2019-03-01 2018-09-30 25           25               25
4542 4542 LAMB HEALTHCARE CENTER 1500 S SUNSET LITTLEFIELD TX 79339 LAMB (806) 385-6411 Acute Care Hospitals Government - Local TRUE 33.9116250 -102.3454390 0   279 48 48279         https://data.medicare.gov/resource/xubh-q36u/row-wpjt.5mwq_y5d4 450698 643967 2019-03-01 2018-09-30 42           42               42
4630 4630 STONEWALL MEMORIAL HOSPITAL 821 NORTH BROADWAY ASPERMONT TX 79502 STONEWALL (940) 989-3551 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.1481491 -100.2274452 1 RANGE_INTERPOLATED 433 48 48433         https://data.medicare.gov/resource/xubh-q36u/row-2ftf-f2vh-6a2t 451318 644669 2019-03-01 2018-09-30 20           20               20
4030 4030 CAMERON MEMORIAL COMMUNITY HOSPITAL INC 416 E MAUMEE ST ANGOLA IN 46703 STEUBEN (260) 665-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.6348830 -84.9955200 0   151 18 18151 11420 Fort Wayne-Huntington-Auburn, IN Central Steuben County https://data.medicare.gov/resource/xubh-q36u/row-mbpc_x46f~xi2m 151315 645408 2019-03-01 2018-09-30 23 2         25               25
1063 1063 DESOTO MEMORIAL HOSPITAL 900 N ROBERT AVE ARCADIA FL 34265 DE SOTO (863) 494-3535 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.2273880 -81.8516750 0   27 12 12027 11580 North Port-Sarasota, FL Central DeSoto County https://data.medicare.gov/resource/xubh-q36u/row-reum.syy4-hiqf 100175 644246 2019-03-01 2018-09-30 41 8         49               49
275 275 ATCHISON HOSPITAL 800 RAVIN HILL DRIVE ATCHISON KS 66002 ATCHISON (913) 360-5581 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5366253 -95.1282386 1 ROOFTOP 5 20 20005 11860 Kansas City-Overland Park-Kansas City, MO-KS Central Atchison County https://data.medicare.gov/resource/xubh-q36u/row-fwt4-3qfd~33ue 171382 645412 2019-03-01 2018-09-30 21 4         25               25
599 599 NORTHEAST GEORGIA MEDICAL CENTER BARROW 316 NORTH BROAD STREET WINDER GA 30680 BARROW (770) 848-8611 Acute Care Hospitals Proprietary TRUE 34.0077010 -83.7067060 0   13 13 13013 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Barrow County https://data.medicare.gov/resource/xubh-q36u/row-hr24_ckbz~3ykf 110045 644713 2019-03-01 2018-09-30 50 6         56               56
2058 2058 NORTHSIDE HOSPITAL CHEROKEE 450 NORTHSIDE CHEROKEE BOULEVARD CANTON GA 30115 CHEROKEE (770) 244-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.2275230 -84.4605620 0   57 13 13057 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Cherokee County https://data.medicare.gov/resource/xubh-q36u/row-8mi6.4b7m_m9gq 110008 644263 2019-03-01 2018-09-30 99   15       114               114
3548 3548 NORTHSIDE HOSPITAL FORSYTH 1200 NORTHSIDE FORSYTH DRIVE CUMMING GA 30041 FORSYTH (770) 844-3200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1785880 -84.1392460 0   117 13 13117 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Forsyth County https://data.medicare.gov/resource/xubh-q36u/row-93nb~wj4q_sm29 110005 644262 2019-03-01 2018-09-30 275 24         299               299
3635 3635 NORTHSIDE HOSPITAL 1000 JOHNSON FERRY ROAD, NE ATLANTA GA 30342 FULTON (404) 851-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9078950 -84.3547540 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-dez8_n5pm.z7cz 110161 644716 2019-03-01 2018-09-30 508 28         536               536
2679 2679 EAST ALABAMA MEDICAL CENTER 2000 PEPPERELL PARKWAY OPELIKA AL 36801 LEE (334) 749-3411 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.6380550 -85.4040030 0   81 1 1081 12220 Columbus-Auburn-Opelika, GA-AL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-vb76-r6it-demb 10029 645461 2019-03-01 2018-09-30 344 20 8       372   17   126       515
1328 1328 OCHSNER MEDICAL CENTER - BATON ROUGE 17000 MEDICAL CENTER DR BATON ROUGE LA 70816 E. BATON ROUGE (225) 752-2470 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4409940 -91.0015130 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-gdgh.frpy~45nu 190202 645417 2019-03-01 2018-09-30 132 20       9 161               161
336 336 BIBB MEDICAL CENTER 208 PIERSON AVE CENTREVILLE AL 35042 BIBB (205) 926-4881 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9511010 -87.1478650 0   7 1 1007 13820 Birmingham-Hoover-Talladega, AL Outlying Bibb County https://data.medicare.gov/resource/xubh-q36u/row-h96v_9sq6~aaj9 10058 644693 2019-03-01 2018-09-30 25           25       131       156
2497 2497 UNIVERSITY OF ALABAMA HOSPITAL 619 SOUTH 19TH STREET BIRMINGHAM AL 35233 JEFFERSON (205) 934-4011 Acute Care Hospitals Government - State TRUE 33.5061290 -86.8019220 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-x229.ejr6_kvzz 10033 645809 2019-03-01 2018-09-30 772 37     48   1063 93 49           1205
2498 2498 UAB CALLAHAN EYE HOSPITAL AUTHORITY 1720 UNIVERSITY BLVD, SUITE 500 BIRMINGHAM AL 35233 JEFFERSON (205) 325-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5031370 -86.8024010 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-txeu_r7zi.ibaa 10018 644082 2019-03-01 2018-09-30 12           12               12
2499 2499 MEDICAL WEST, AN AFFILIATE OF UAB HEALTH SYSTEM 995 9TH AVENUE SOUTHWEST BESSEMER AL 35021 JEFFERSON (205) 481-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.3730860 -86.9917090 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-4v9u.s38j~rrc7 10114 644202 2019-03-01 2018-09-30 119 21         187 25 19           231
765 765 FRISBIE MEMORIAL HOSPITAL 11 WHITEHALL ROAD ROCHESTER NH 3867 STRAFFORD (603) 332-5211 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.2981890 -70.9611940 0   17 33 33017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Outlying Strafford County https://data.medicare.gov/resource/xubh-q36u/row-6n5x.y352.3bdm 300014 645670 2019-03-01 2018-09-30 58 6         64 20             84
1007 1007 BOSTON MEDICAL CENTER CORPORATION- 1 BOSTON MEDICAL CENTER PLACE BOSTON MA 2118 SUFFOLK (617) 638-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3348100 -71.0744800 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-mqjp.wiw7.7ber 220031 645656 2019-03-01 2018-09-30 361 71         432               432
4269 4269 TRANSYLVANIA REGIONAL HOSPITAL, INC 90 HOSPITAL DRIVE PO BOX 1116 BREVARD NC 28712 TRANSYLVANIA (828) 883-5302 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.2563240 -82.7151960 0   175 37 37175 14820 Asheville-Brevard, NC Central Transylvania County https://data.medicare.gov/resource/xubh-q36u/row-932e.bf5e.fdxt 341319 645349 2019-03-01 2018-09-30 21 4         25       10       35
1875 1875 BROWNWOOD REGIONAL MEDICAL CENTER 1501 BURNET DR BROWNWOOD TX 76801 BROWN (325) 646-8541 Acute Care Hospitals Proprietary TRUE 31.6802110 -98.9881580 0   49 48 48049 15220   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-mwhq-a826-mmad 450587 645612 2019-03-01 2018-09-30 65 12         77               77
822 822 OSF HEART OF MARY MEDICAL CENTER 1400 WEST PARK AVENUE URBANA IL 61801 CHAMPAIGN (217) 337-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.1173910 -88.2271230 0   19 17 17019 16580   Central Champaign County https://data.medicare.gov/resource/xubh-q36u/row-mvbr_gjxz-rw36 140113 645247 2019-03-01 2018-09-30 156 13         169   25           194
1948 1948 GIBSON COMMUNITY HOSPITAL 1120 N MELVIN STREET GIBSON CITY IL 60936 FORD (217) 784-4251 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4780720 -88.3707160 0   53 17 17053 16580   Outlying Ford County https://data.medicare.gov/resource/xubh-q36u/row-f8jw.6gex-n8ig 141317 645250 2019-03-01 2018-09-30 23 2         25       5   37   67
1230 1230 SWEDISH COVENANT HOSPITAL 5145 N CALIFORNIA AVE CHICAGO IL 60625 COOK (773) 878-8200 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9752190 -87.6989180 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-5wpu.kw38~h94a 140114 645640 2019-03-01 2018-09-30 188 18         216 31 25   34       306
845 845 VALLEY REGIONAL HOSPITAL 243 ELM STREET CLAREMONT NH 3743 SULLIVAN (603) 542-7771 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3851430 -72.3424650 0   19 33 33019 17200   Outlying Sullivan County https://data.medicare.gov/resource/xubh-q36u/row-pzan~sayc~gyd3 301308 645431 2019-03-01 2018-09-30 25           25               25
1672 1672 COLLEGE STATION MEDICAL CENTER 1604 ROCK PRAIRIE ROAD COLLEGE STATION TX 77842 BRAZOS (979) 764-5151 Acute Care Hospitals Proprietary TRUE 30.5826260 -96.2910140 0   41 48 48041 17780   Central Brazos County https://data.medicare.gov/resource/xubh-q36u/row-kw5b_vp92-tdms 450299 645732 2019-03-01 2018-09-30 102 12         114               114
2271 2271 LEXINGTON MEDICAL CENTER 2720 SUNSET BLVD WEST COLUMBIA SC 29169 LEXINGTON (803) 791-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.0044030 -81.1143610 0   63 45 45063 17900 Columbia-Orangeburg-Newberry, SC Central Lexington County https://data.medicare.gov/resource/xubh-q36u/row-qscu~35q6.43rv 420073 645360 2019-03-01 2018-09-30 397 21     18   436               436
2662 2662 PRISMA HEALTH RICHLAND HOSPITAL 5 MEDICAL PARK COLUMBIA SC 29203 RICHLAND (803) 296-2548 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0266990 -81.0350320 0   79 45 45079 17900 Columbia-Orangeburg-Newberry, SC Central Richland County https://data.medicare.gov/resource/xubh-q36u/row-ktx8~zrze~bafm 420018 644778 2019-03-01 2018-09-30 426 46 88     98 672 32             704
2664 2664 PRISMA HEALTH BAPTIST PARKRIDGE 400 PALMETTO HEALTH PARKWAY COLUMBIA SC 29212 LEXINGTON (803) 907-7011 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0872139 -81.1596497 1 ROOFTOP 79 45 45079 17900 Columbia-Orangeburg-Newberry, SC Central Richland County https://data.medicare.gov/resource/xubh-q36u/row-bd2d~ef8j_qggw 420106 644781 2019-03-01 2018-09-30 60 16         76               76
1642 1642 FAYETTE REGIONAL HEALTH SYSTEM 1941 VIRGINIA AVE CONNERSVILLE IN 47331 FAYETTE (765) 825-5131 Acute Care Hospitals Proprietary TRUE 39.6559200 -85.1319840 0   41 18 18041 18220 Richmond-Connersville, IN Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-eksi_yzpc.5837 150064 645404 2019-03-01 2018-09-30 25 20         45 12             57
3801 3801 HEALTHMARK REGIONAL MEDICAL CENTER 4413 US HWY 331 S DEFUNIAK SPRINGS FL 32435 WALTON (850) 951-4500 Acute Care Hospitals Proprietary TRUE 30.6587420 -86.1191880 0   131 12 12131 18880   Central Walton County https://data.medicare.gov/resource/xubh-q36u/row-esxw~eejr-faw4 100081 644706 2019-03-01 2018-09-30 44 6         50               50
3662 3662 BAYLOR SCOTT AND WHITE MEDICAL CENTER CARROLLTON 4343 NORTH JOSEY LANE CARROLLTON TX 75010 DENTON (972) 394-2255 Acute Care Hospitals Proprietary FALSE 33.0289660 -96.8839500 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-5qkb_cw98-y3cm 450730 644372 2019-03-01 2018-09-30 73 16         94               94
4649 4649 JPS HEALTH NETWORK 1500 S MAIN ST FORT WORTH TX 76104 TARRANT (817) 921-3431 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7273350 -97.3264050 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-7dvr-ayce.t7an 450039 644576 2019-03-01 2018-09-30 359 36     35   430 132             562
4305 4305 OSF SACRED HEART MEDICAL CENTER 812 N LOGAN AVE DANVILLE IL 61832 VERMILION (217) 443-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.1361970 -87.6449080 0   183 17 17183 19180   Central Vermilion County https://data.medicare.gov/resource/xubh-q36u/row-dkxe~imc7_ebbc 140093 645245 2019-03-01 2018-09-30 145 12         157               157
897 897 EPHRAIM MCDOWELL REGIONAL MEDICAL CENTER 217 SOUTH THIRD STREET DANVILLE KY 40422 BOYLE (859) 239-2409 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6438180 -84.7726380 0   21 21 21021 19220   Central Boyle County https://data.medicare.gov/resource/xubh-q36u/row-umsp-afi7~cb4h 180048 643770 2019-03-01 2018-09-30 148 22         170 27     25       222
3872 3872 EPHRAIM MCDOWELL FORT LOGAN HOSPITAL 110 METKER TRAIL STANFORD KY 40484 LINCOLN (606) 365-4788 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.5436160 -84.6538790 0   137 21 21137 19220   Outlying Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-r5qq~biyw~n5dv 181315 643775 2019-03-01 2018-09-30 25           25               25
133 133 SOUTH BALDWIN REGIONAL MEDICAL CENTER 1613 NORTH MCKENZIE STREET FOLEY AL 36535 BALDWIN (251) 949-3400 Acute Care Hospitals Proprietary TRUE 30.4261090 -87.6831870 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-pyt4.i3a3.r8cm 10083 645389 2019-03-01 2018-09-30 82 30         112               112
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
2383 2383 FLOWERS HOSPITAL 4370 WEST MAIN STREET DOTHAN AL 36305 HOUSTON (334) 793-5000 Acute Care Hospitals Proprietary TRUE 31.2359910 -85.4579370 0   69 1 1069 20020 Dothan-Enterprise-Ozark, AL Central Houston County https://data.medicare.gov/resource/xubh-q36u/row-i7jd_zyzr.7uv6 10055 645037 2019-03-01 2018-09-30 203 26         235               235
2384 2384 SOUTHEAST ALABAMA MEDICAL CENTER 1108 ROSS CLARK CIRCLE DOTHAN AL 36301 HOUSTON (334) 793-8701 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2140580 -85.3617250 0   69 1 1069 20020 Dothan-Enterprise-Ozark, AL Central Houston County https://data.medicare.gov/resource/xubh-q36u/row-qib2_2qqh~zmw8 10001 644080 2019-03-01 2018-09-30 271 40       16 327               327
3876 3876 ELY BLOOMENSON COMMUNITY HOSPITAL 328 WEST CONAN STREET ELY MN 55731 ST. LOUIS (218) 365-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.9007010 -91.8719710 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-tia7_tsch.3esn 241318 645476 2019-03-01 2018-09-30 16           16               16
3935 3935 EL PASO CHILDREN'S HOSPITAL 4845 ALAMEDA AVENUE EL PASO TX 79905 EL PASO (915) 521-7148 Childrens Voluntary non-profit - Private TRUE 31.7706550 -106.4342000 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-ncax.wugj~a6h5 453313 646113 2019-03-01 2018-09-30 76 24       22 122               122
1303 1303 MCLEOD MEDICAL CENTER - DARLINGTON 701 CASHUA FERRY ROAD DARLINGTON SC 29540 DARLINGTON (843) 777-1100 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.3129880 -79.8382530 0   31 45 45031 22500   Outlying Darlington County https://data.medicare.gov/resource/xubh-q36u/row-6zdq_e43i.3ag8 420057 645359 2019-03-01 2018-09-30 36           36 23             59
3426 3426 FORT MADISON COMMUNITY HOSPITAL 5445 AVE O FORT MADISON IA 52627 LEE (319) 372-6530 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6241670 -91.3820670 0   111 19 19111 22800   Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-iqeh-tjnf-g9mv 160122 645411 2019-03-01 2018-09-30 47 3         50               50
4285 4285 BLUFFTON REGIONAL MEDICAL CENTER 303 S MAIN ST BLUFFTON IN 46714 WELLS (260) 824-3210 Acute Care Hospitals Proprietary TRUE 40.7376450 -85.1714940 0   179 18 18179 23060 Fort Wayne-Huntington-Auburn, IN Outlying Wells County https://data.medicare.gov/resource/xubh-q36u/row-7d75-xz4v.txjj 150075 645405 2019-03-01 2018-09-30 55 7         62       13       75
3887 3887 NORTHEAST GEORGIA MEDICAL CENTER, INC 743 SPRING STREET GAINESVILLE GA 30501 HALL (770) 535-3553 Acute Care Hospitals Government - Local TRUE 34.3033500 -83.8173700 0   139 13 13139 23580 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Hall County https://data.medicare.gov/resource/xubh-q36u/row-7syr~f3ei~dkan 110029 645060 2019-03-01 2018-09-30 460 85         545 54 24   261       884
508 508 BAYSTATE FRANKLIN MEDICAL CENTER 164 HIGH STREET GREENFIELD MA 1301 FRANKLIN (413) 773-0211 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5956060 -72.5912870 0   11 25 25011 24640 Springfield-Greenfield Town, MA Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-hsyh.fr4q.9c2a 220016 645419 2019-03-01 2018-09-30 83 6         89               89
2627 2627 PRISMA HEALTH BAPTIST EASLEY HOSPITAL 200 FLEETWOOD DRIVE EASLEY SC 29640 PICKENS (864) 442-7606 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.8396510 -82.6070640 0   77 45 45077 24860 Greenville-Spartanburg-Anderson, SC Central Pickens County https://data.medicare.gov/resource/xubh-q36u/row-9gec~ndsf~i9kp 420015 644777 2019-03-01 2018-09-30 78   11       89               89
1818 1818 SELF REGIONAL HEALTHCARE 1325 SPRING STREET GREENWOOD SC 29646 GREENWOOD (864) 227-4111 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1753620 -82.1578680 0   47 45 45047 24940 Greenville-Spartanburg-Anderson, SC Central Greenwood County https://data.medicare.gov/resource/xubh-q36u/row-vc2q_jqxe-uebz 420071 644780 2019-03-01 2018-09-30 242 20 10       290 32             322
1742 1742 OCHSNER MEDICAL CENTER-HANCOCK 149 DRINKWATER BLVD BAY SAINT LOUIS MS 39520 HANCOCK (228) 467-8600 Acute Care Hospitals Government - Local TRUE 30.3130400 -89.3556570 0   45 28 28045 25060   Central Hancock County https://data.medicare.gov/resource/xubh-q36u/row-8qr6~e2iu-2dck 250162 645723 2019-03-01 2018-09-30 41 6         47               47
1786 1786 MERIT HEALTH BILOXI 150 REYNOIR STREET BILOXI MS 39530 HARRISON (228) 436-1104 Acute Care Hospitals Proprietary TRUE 30.3961120 -88.8904380 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-had8.h2gv_r2ex 250007 645573 2019-03-01 2018-09-30 147 18         165 12             177
2144 2144 SINGING RIVER HEALTH SYSTEM 2809 DENNY AV PASCAGOULA MS 39581 JACKSON (228) 809-5000 Acute Care Hospitals Government - Local TRUE 30.3748710 -88.5324040 0   59 28 28059 25060   Outlying Jackson County https://data.medicare.gov/resource/xubh-q36u/row-tcrr_p47m-6bi7 250040 645722 2019-03-01 2018-09-30 272 48         320 14 20   36       390
146 146 HOSPITAL OF CENTRAL CONNECTICUT, THE 100 GRAND STREET NEW BRITAIN CT 6050 HARTFORD (860) 224-5011 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.6620150 -72.7877990 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-wbxc-gjw3~i99u 70035 645240 2019-03-01 2018-09-30 222 24         246 32             278
3570 3570 HEREFORD REGIONAL MEDICAL CENTER 801 EAST THIRD HEREFORD TX 79045 DEAF SMITH (806) 364-2141 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8211620 -102.3902000 0   117 48 48117 25820   Central Deaf Smith County https://data.medicare.gov/resource/xubh-q36u/row-mm6e.hbdq-vz9a 450155 643952 2019-03-01 2018-09-30 30           30               30
1619 1619 SWEENY COMMUNITY HOSPITAL 305 NORTH MCKINNEY SWEENY TX 77480 BRAZORIA (979) 548-3311 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.0485140 -95.6913920 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-argn.cnxa-jdss 451311 643974 2019-03-01 2018-09-30 14           14               14
4115 4115 MEMORIAL HERMANN SUGAR LAND HOSPITAL 17500 W GRAND PARKWAY SOUTH SUGAR LAND TX 77479 FORT BEND (281) 725-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.5640800 -95.6879100 0   157 48 48157 26420 Houston-The Woodlands, TX Central Fort Bend County https://data.medicare.gov/resource/xubh-q36u/row-bagw~v25h.x4rt 450848 643971 2019-03-01 2018-09-30 119 14         145               145
3833 3833 SOUTH SUNFLOWER COUNTY HOSPITAL 121 E BAKER ST INDIANOLA MS 38751 SUNFLOWER (662) 887-5235 Acute Care Hospitals Government - Local TRUE 33.4572340 -90.6502400 0   133 28 28133 26940 Cleveland-Indianola, MS Central Sunflower County https://data.medicare.gov/resource/xubh-q36u/row-bmwa.aic3-zxsr 250095 644301 2019-03-01 2018-09-30 47           47               47
1849 1849 MISSISSIPPI BAPTIST MEDICAL CENTER 1225 N STATE ST JACKSON MS 39202 HINDS (601) 968-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.3142780 -90.1782280 0   49 28 28049 27140 Jackson-Vicksburg-Brookhaven, MS Central Hinds County https://data.medicare.gov/resource/xubh-q36u/row-qf32-zbi6~3xms 250102 644303 2019-03-01 2018-09-30 354 28 16       430 16             446
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
3050 3050 LEE'S SUMMIT MEDICAL CENTER 2100 SE BLUE PARKWAY LEES SUMMIT MO 64063 JACKSON (816) 282-5000 Acute Care Hospitals Proprietary TRUE 38.9022850 -94.3321510 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-4563.d7dj_x9m5 260190 645575 2019-03-01 2018-09-30 70 10         80               80
3348 3348 LAFAYETTE REGIONAL HEALTH CENTER 1500 STATE STREET LEXINGTON MO 64067 LAFAYETTE (660) 259-2203 Critical Access Hospitals Proprietary TRUE 39.1891460 -93.8770650 0   107 29 29107 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Lafayette County https://data.medicare.gov/resource/xubh-q36u/row-sn6v-86t8~7h98 261320 645576 2019-03-01 2018-09-30 23 2         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
);