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

165 rows where "filed_date" is on date 2019-12-03 sorted by csatitle

✎ 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, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-12-03 · 165 ✖
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
132 132 IVINSON MEMORIAL HOSPITAL 255 N 30TH LARAMIE WY 82072 ALBANY (307) 755-4600 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.3113900 -105.5575120 0   1 56 56001 29660   Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-ptq5-c827_j29e 530025 660342 2019-12-03 2019-06-30 62 4         66 10     10       86
140 140 SAN LUIS VALLEY HEALTH 106 BLANCA AVE ALAMOSA CO 81101 ALAMOSA (719) 589-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4723600 -105.8837120 0   3 8 8003         https://data.medicare.gov/resource/xubh-q36u/row-bztx~k7ma~ri7p 60008 661701 2019-12-03 2019-06-30 43 6         49               49
267 267 BAYHEALTH HOSPITAL, SUSSEX CAMPUS 100 WELLNESS WAY MILFORD DE 19963 SUSSEX (302) 422-3311 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8868357 -75.3911438 1 ROOFTOP 5 10 10005 41540   Central Sussex County https://data.medicare.gov/resource/xubh-q36u/row-pqau~nrba-tybq 80009 661150 2019-12-03 2019-06-30 105 9         114   42           156
296 296 CHESHIRE MEDICAL CENTER 580 COURT STREET KEENE NH 3431 CHESHIRE (603) 354-5400 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9498540 -72.2907250 0   5 33 33005 28300   Central Cheshire County https://data.medicare.gov/resource/xubh-q36u/row-xyq5~7j27.ews5 300019 661742 2019-12-03 2019-06-30 59 27         86   24           110
319 319 CAMDEN GENERAL HOSPITAL 175 HOSPITAL DRIVE CAMDEN TN 38320 BENTON (731) 584-0109 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.0557800 -88.1075170 0   5 47 47005         https://data.medicare.gov/resource/xubh-q36u/row-rp5g~twzk~kf69 441316 660045 2019-12-03 2019-06-30 25           25               25
365 365 BROADWATER HEALTH CENTER 110 N OAK ST TOWNSEND MT 59644 BROADWATER (406) 266-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3213540 -111.5164280 0   7 30 30007         https://data.medicare.gov/resource/xubh-q36u/row-3bqc_c9ze~3cij 271333 662052 2019-12-03 2019-06-30 25           25               25
406 406 MARK TWAIN MEDICAL CENTER 768 MOUNTAIN RANCH RD SAN ANDREAS CA 95249 CALAVERAS (209) 754-2515 Critical Access Hospitals Voluntary non-profit - Other FALSE 38.1909730 -120.6706610 0   9 6 6009         https://data.medicare.gov/resource/xubh-q36u/row-vzvr.d5an~vpec 51332 660493 2019-12-03 2019-06-30 25           25               25
436 436 BUNKIE GENERAL HOSPITAL 427 EVERGREEN STREET BUNKIE LA 71322 AVOYELLES (318) 346-6681 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.9524260 -92.1766470 0   9 22 22009         https://data.medicare.gov/resource/xubh-q36u/row-56d9~jh8q~59bh 191311 662210 2019-12-03 2019-06-30 25           25               25
451 451 ALICE PECK DAY MEMORIAL HOSPITAL 10 ALICE PECK DAY DRIVE LEBANON NH 3766 GRAFTON (603) 448-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6402930 -72.2643660 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-t8xb_fse9~ukfj 301305 661743 2019-12-03 2019-06-30 24           24               24
474 474 MEMORIAL HOSPITAL OF CONVERSE COUNTY 111 SOUTH 5TH STREET DOUGLAS WY 82633 CONVERSE (307) 358-2122 Critical Access Hospitals Government - Local TRUE 42.7588050 -105.3812790 0   9 56 56009         https://data.medicare.gov/resource/xubh-q36u/row-zei4~mbih_rgkv 531302 662095 2019-12-03 2019-06-30 25           25               25
561 561 MERCY GILBERT MEDICAL CENTER 3555 SOUTH VAL VISTA DRIVE GILBERT AZ 85297 MARICOPA (480) 728-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.2866610 -111.7553110 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ab5w_8jiw.5ys7 30119 662011 2019-12-03 2019-06-30 174 24         198               198
644 644 CONEMAUGH NASON MEDICAL CENTER 105 NASON DRIVE ROARING SPRING PA 16673 BLAIR (814) 224-2141 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3380670 -78.3889450 0   13 42 42013 11020   Central Blair County https://data.medicare.gov/resource/xubh-q36u/row-q5b2-s4qk-jc5a 390062 660015 2019-12-03 2019-06-30 41 4         45               45
705 705 CHI ST ALEXIUS HEALTH 900 E BROADWAY BISMARCK ND 58501 BURLEIGH (701) 530-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.8063690 -100.7770750 0   15 38 38015 13900   Central Burleigh County https://data.medicare.gov/resource/xubh-q36u/row-i4ue-xmjd.qmkx 350002 662065 2019-12-03 2019-06-30 142 39         181 25     19       225
738 738 NORTH CADDO MEDICAL CENTER 815 SOUTH PINE STREET VIVIAN LA 71082 CADDO (318) 375-3235 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.8634600 -93.9877170 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-b4zm~5u3q.sne4 191304 662209 2019-12-03 2019-06-30 25           25               25
741 741 OCHSNER LSU HEALTH SHREVEPORT 1541 KINGS HIGHWAY SHREVEPORT LA 71103 CADDO (318) 675-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4817910 -93.7615900 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-mkra_a29f.kchy 190098 660383 2019-12-03 2019-06-30 285     10     369 37             406
872 872 JOHNSON COUNTY HEALTHCARE CENTER 497 WEST LOTT BUFFALO WY 82834 JOHNSON (307) 684-5521 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.3497880 -106.7072480 0   19 56 56019         https://data.medicare.gov/resource/xubh-q36u/row-jfvm_9yjt_xtnf 531308 662298 2019-12-03 2019-06-30 22           22           3   69
883 883 GLENN MEDICAL CENTER 1133 W SYCAMORE ST WILLOWS CA 95988 GLENN (530) 934-1818 Critical Access Hospitals Government - Federal TRUE 39.5204670 -122.2081200 0   21 6 6021         https://data.medicare.gov/resource/xubh-q36u/row-7nst_26uq.zcvx 51306 662484 2019-12-03 2019-06-30 15           15               15
884 884 SAN LUIS VALLEY HEALTH CONEJOS COUNTY HOSPITAL 19021 US HIGHWAY 285 LA JARA CO 81140 CONEJOS (719) 274-5121 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.2637500 -105.9640950 0   21 8 8021         https://data.medicare.gov/resource/xubh-q36u/row-2ncf.isv7_93r9 61308 662179 2019-12-03 2019-06-30 17           17               17
1123 1123 MERCY HOSPITAL 2215 TRUXTUN AVENUE BAKERSFIELD CA 93301 KERN (661) 632-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.3733230 -119.0273860 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-e2k4-zc2q~ukyi 50295 661459 2019-12-03 2019-06-30 189 28       9 226               226
1128 1128 BAKERSFIELD MEMORIAL HOSPITAL 420 34TH ST BAKERSFIELD CA 93301 KERN (661) 327-1792 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3904740 -119.0068360 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-yg5p.buuv_2y73 50036 661282 2019-12-03 2019-06-30 342 41   7   31 421               421
1327 1327 LANE REGIONAL MEDICAL CENTER 6300 MAIN STREET ZACHARY LA 70791 E. BATON ROUGE (225) 658-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.6499570 -91.1367470 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-6rne~rwgc-e8xv 190020 659955 2019-12-03 2019-06-30 95 8       2 113   30   39       182
1400 1400 GERALD CHAMPION REGIONAL MEDICAL CENTER 2669 NORTH SCENIC DRIVE ALAMOGORDO NM 88310 OTERO (575) 443-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9268620 -105.9339170 0   35 35 35035 10460   Central Otero County https://data.medicare.gov/resource/xubh-q36u/row-jeb6-3eqs_s323 320004 659992 2019-12-03 2019-06-30 40 10         50 36 12           98
1645 1645 HERINGTON MUNICIPAL HOSPITAL 100 E HELEN STREET HERINGTON KS 67449 DICKINSON (785) 258-2207 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.6795610 -96.9422740 0   41 20 20041         https://data.medicare.gov/resource/xubh-q36u/row-sgwx~evd5.tciy 171340 661326 2019-12-03 2019-06-30 15           15               15
1671 1671 ST JOSEPH REGIONAL HEALTH CENTER 2801 FRANCISCAN DR BRYAN TX 77802 BRAZOS (979) 776-3912 Acute Care Hospitals Voluntary non-profit - Private FALSE 30.6555260 -96.3476380 0   41 48 48041 17780   Central Brazos County https://data.medicare.gov/resource/xubh-q36u/row-zs72.9n7k-uvcg 450011 660049 2019-12-03 2019-06-30 189 20         209               209
1744 1744 SAN JUAN REGIONAL MEDICAL CENTER 801 WEST MAPLE STREET FARMINGTON NM 87401 SAN JUAN (505) 609-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7243230 -108.2155010 0   45 35 35045 22140   Central San Juan County https://data.medicare.gov/resource/xubh-q36u/row-4isx~82pp.w4au 320005 660135 2019-12-03 2019-06-30 174 10         184               184
1765 1765 WEST TENNESSEE HEALTHCARE DYERSBURG HOSPITAL 400 EAST TICKLE STREET DYERSBURG TN 38024 DYER (731) 285-2410 Acute Care Hospitals Proprietary TRUE 36.0473580 -89.3805900 0   45 47 47045 20540   Central Dyer County https://data.medicare.gov/resource/xubh-q36u/row-rkhu_ciht-shk2 440072 661654 2019-12-03 2019-06-30 95 14         109               109
1782 1782 ATLANTIC GENERAL HOSPITAL 9733 HEALTHWAY DRIVE BERLIN MD 21811 WORCESTER (410) 641-9600 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3386040 -75.2104720 0   47 24 24047 41540   Outlying Worcester County https://data.medicare.gov/resource/xubh-q36u/row-kz7f~bne7-xch9 210061 660098 2019-12-03 2019-06-30 42 6         48               48
1975 1975 MILAN GENERAL HOSPITAL 4039 HIGHLAND ST MILAN TN 38358 GIBSON (731) 686-1591 Acute Care Hospitals Government - Local TRUE 35.9133110 -88.7534950 0   53 47 47053         https://data.medicare.gov/resource/xubh-q36u/row-b2mu-x63s-nuvr 440060 660042 2019-12-03 2019-06-30 44 3         47               47
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
2268 2268 HOLDENVILLE GENERAL HOSPITAL 100 MCDOUGAL DRIVE HOLDENVILLE OK 74848 HUGHES (405) 379-4200 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.0882130 -96.3782650 0   63 40 40063         https://data.medicare.gov/resource/xubh-q36u/row-sj8k.rz7i~rzh6 371321 660004 2019-12-03 2019-06-30 25           25               25
2311 2311 SALEM MEMORIAL DISTRICT HOSPITAL PO BOX 774, SALEM MO 65560 DENT (573) 729-6626 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6604402 -91.5692851 1 ROOFTOP 65 29 29065         https://data.medicare.gov/resource/xubh-q36u/row-wiw4-tpja~sz74 261318 661354 2019-12-03 2019-06-30 25           25           18   43
2381 2381 SUMMERSVILLE REGIONAL MEDICAL CENTER 400 FAIRVIEW HEIGHTS ROAD SUMMERSVILLE WV 26651 NICHOLAS (304) 872-2891 Critical Access Hospitals Government - Local TRUE 38.2919030 -80.8311360 0   67 54 54067         https://data.medicare.gov/resource/xubh-q36u/row-a2eh.63jr_sfyc 511322 661675 2019-12-03 2019-06-30 19 6         25       52       77
2415 2415 BOLIVAR GENERAL HOSPITAL 650 NUCKOLLS ROAD BOLIVAR TN 38008 HARDEMAN (731) 658-3100 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.2679530 -89.0005770 0   69 47 47069         https://data.medicare.gov/resource/xubh-q36u/row-xpdy_i9ip-a66t 441320 660046 2019-12-03 2019-06-30 25           25               25
2555 2555 LAWRENCE MEMORIAL HOSPITAL 1309 WEST MAIN STREET WALNUT RIDGE AR 72476 LAWRENCE (870) 886-1200 Critical Access Hospitals Government - Local TRUE 36.0747010 -90.9669820 0   75 5 5075         https://data.medicare.gov/resource/xubh-q36u/row-jpmn_3ec8~urk8 41309 661136 2019-12-03 2019-06-30 25           25               25
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
2658 2658 EASTERN OKLAHOMA MEDICAL CENTER 105 WALL STREET POTEAU OK 74953 LE FLORE (918) 647-8161 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.0439790 -94.6128340 0   79 40 40079 22900   Outlying Le Flore County https://data.medicare.gov/resource/xubh-q36u/row-4db9~xpsx-e222 371337 662241 2019-12-03 2019-06-30 21 4         25 10             35
2989 2989 MERCY MEDICAL CENTER MT SHASTA 914 PINE STREET MOUNT SHASTA CA 96067 SISKIYOU (530) 926-6111 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.3177640 -122.3215540 0   93 6 6093         https://data.medicare.gov/resource/xubh-q36u/row-z3p6.8j4z_mz6s 51319 662174 2019-12-03 2019-06-30 21 4         25               25
3173 3173 UNITY MEDICAL CENTER 164 W 13TH STREET GRAFTON ND 58237 WALSH (701) 352-1620 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4114840 -97.4138290 0   99 38 38099         https://data.medicare.gov/resource/xubh-q36u/row-xvyg.2uq7_fcwn 351320 660660 2019-12-03 2019-06-30 14           14               14
3254 3254 JOHNS HOPKINS ALL CHILDREN'S HOSPITAL 501 SIXTH AVENUE SOUTH SAINT PETERSBURG FL 33701 PINELLAS (813) 898-7451 Childrens Voluntary non-profit - Other TRUE 27.7642490 -82.6410120 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-rxaq~253f.593c 103300 661485 2019-12-03 2019-06-30 112 28 22     97 259               259
3272 3272 UP HEALTH SYSTEM - MARQUETTE 850 W BARAGA AVE MARQUETTE MI 49855 MARQUETTE (906) 228-9440 Acute Care Hospitals Government - Local TRUE 46.5430810 -87.4110360 0   103 26 26103 32100   Central Marquette County https://data.medicare.gov/resource/xubh-q36u/row-qqgq-mmy3.4i67 230054 661339 2019-12-03 2019-06-30 201 26       11 238 43 20           301
3273 3273 BELL HOSPITAL 901 LAKESHORE DRIVE ISHPEMING MI 49849 MARQUETTE (906) 486-4431 Critical Access Hospitals Proprietary TRUE 46.4986650 -87.6829930 0   103 26 26103 32100   Central Marquette County https://data.medicare.gov/resource/xubh-q36u/row-ag2p-d743~hfr4 231321 661204 2019-12-03 2019-06-30 21   4       25               25
3305 3305 ELBERT MEMORIAL HOSPITAL 4 MEDICAL DRIVE ELBERTON GA 30635 ELBERT (706) 213-2535 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1130680 -82.8756010 0   105 13 13105         https://data.medicare.gov/resource/xubh-q36u/row-qihd.4t9x~yppv 110026 660503 2019-12-03 2019-06-30 48 4         52               52
3474 3474 BEACHAM MEMORIAL HOSPITAL 205 N CHERRY STREET MAGNOLIA MS 39652 PIKE (601) 783-2353 Acute Care Hospitals Proprietary FALSE 31.1456260 -90.4592900 0   113 28 28113 32620   Central Pike County https://data.medicare.gov/resource/xubh-q36u/row-3dmz-gqww~dtyc 250049 660400 2019-12-03 2019-06-30 17           17 14             31
3487 3487 JACKSON-MADISON COUNTY GENERAL HOSPITAL 620 SKYLINE DRIVE JACKSON TN 38301 MADISON (731) 541-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.6395400 -88.8319730 0   113 47 47113 27180   Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-7x5u~ak3g.bt68 440002 660037 2019-12-03 2019-06-30 652 73 18       777               777
3587 3587 ST MARY'S SACRED HEART HOSPITAL, INC 367 CLEAR CREEK PARKWAY LAVONIA GA 30553 FRANKLIN (706) 356-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.4394850 -83.1308550 0   119 13 13119         https://data.medicare.gov/resource/xubh-q36u/row-tqnr-ai73~p7se 110027 660367 2019-12-03 2019-06-30 48 8         56               56
3694 3694 WARREN GENERAL HOSPITAL TWO CRESCENT PARK WEST WARREN PA 16365 WARREN (814) 723-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8431152 -79.1555220 1 ROOFTOP 123 42 42123 47620   Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-cza6_xsbu-7xn7 390146 660444 2019-12-03 2019-06-30 79 6         85               85
3751 3751 MERCY HEALTH LAKESHORE CAMPUS 72 SOUTH STATE STREET SHELBY MI 49455 OCEANA (231) 861-2156 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6070530 -86.3651500 0   127 26 26127         https://data.medicare.gov/resource/xubh-q36u/row-4je3~28uk~h2y8 231320 661203 2019-12-03 2019-06-30 24           24               24
3797 3797 KETCHIKAN MEDICAL CENTER 3100 TONGASS AVENUE KETCHIKAN AK 99901 KETCHIKAN GATEWAY (907) 225-5171 Critical Access Hospitals Voluntary non-profit - Church TRUE 55.3527170 -131.6860490 0   130 2 2130 28540   Central Ketchikan Gateway Borough https://data.medicare.gov/resource/xubh-q36u/row-qt33-ugsf~ggm9 21311 661277 2019-12-03 2019-06-30 21 4         25       29       54
3806 3806 MITCHELL COUNTY REGIONAL HEALTH 616 NORTH EIGHTH STREET OSAGE IA 50461 MITCHELL (641) 732-6000 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.2890760 -92.8094820 0   131 19 19131         https://data.medicare.gov/resource/xubh-q36u/row-vd49.a3jn-dt4a 161323 661180 2019-12-03 2019-06-30 25           25               25
3809 3809 MARY BRECKINRIDGE ARH HOSPITAL 130 KATE IRELAND DRIVE HYDEN KY 41749 LESLIE (606) 672-2901 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1638890 -83.3783600 0   131 21 21131         https://data.medicare.gov/resource/xubh-q36u/row-ms82.xh5f.a6zw 181316 661511 2019-12-03 2019-06-30 25           25               25
3825 3825 ST MARY'S GOOD SAMARITAN HOSPITAL 5401 LAKE OCONEE PARKWAY GREENSBORO GA 30642 GREENE (706) 453-7331 Critical Access Hospitals Proprietary TRUE 33.4799210 -83.2416450 0   133 13 13133         https://data.medicare.gov/resource/xubh-q36u/row-bqbp~uisy-u894 111329 660372 2019-12-03 2019-06-30 25           25               25
3829 3829 WHITESBURG ARH HOSPITAL 240 HOSPITAL ROAD WHITESBURG KY 41858 LETCHER (606) 633-3500 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.1118200 -82.8136120 0   133 21 21133         https://data.medicare.gov/resource/xubh-q36u/row-pqne.4qjx-j597 180002 662525 2019-12-03 2019-06-30 84 6         90               90
3940 3940 ARKANSAS CHILDREN'S NORTHWEST, INC 2601 GENE GEORGE BOULEVARD SPRINGDALE AR 72762 WASHINGTON (479) 725-6800 Childrens Voluntary non-profit - Private TRUE 36.1633250 -94.1926020 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ancy_ajta_8yhj 43301 660747 2019-12-03 2019-06-30 24           24               24
4010 4010 CHAMBERS MEMORIAL HOSPITAL 719 DETROIT STREET DANVILLE AR 72833 YELL (479) 495-2241 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0548230 -93.3885430 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-d59r_eigs_n4bw 40011 660743 2019-12-03 2019-06-30 30           30 12             42
4024 4024 CORDELL MEMORIAL HOSPITAL 1220 NORTH GLENN ENGLISH STREET CORDELL OK 73632 WASHITA (580) 832-3339 Critical Access Hospitals Government - Local TRUE 35.3025240 -98.9875950 0   149 40 40149         https://data.medicare.gov/resource/xubh-q36u/row-k6qa-iqdm.jnj9 371325 660005 2019-12-03 2019-06-30 14           14               14
4231 4231 SCOTT COUNTY HOSPITAL 201 ALBERT AVENUE SCOTT CITY KS 67871 SCOTT (620) 872-5811 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.4848700 -100.9035000 0   171 20 20171         https://data.medicare.gov/resource/xubh-q36u/row-3s9g-yvmr~yjua 171372 661186 2019-12-03 2019-06-30 25           25               25
4245 4245 ST VINCENT WARRICK 1116 MILLIS AVE BOONVILLE IN 47601 WARRICK (812) 897-4800 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.0413560 -87.2633740 0   173 18 18173 21780   Central Warrick County https://data.medicare.gov/resource/xubh-q36u/row-7qwf.qysm-8pah 151325 661170 2019-12-03 2019-06-30 25           25 10             35
4266 4266 MORGAN COUNTY ARH HOSPITAL 476 LIBERTY ROAD WEST LIBERTY KY 41472 MORGAN (606) 743-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9201370 -83.2662760 0   175 21 21175         https://data.medicare.gov/resource/xubh-q36u/row-aia2-xvbh~gtxt 181307 662531 2019-12-03 2019-06-30 25           25               25
4361 4361 COVENANT HOSPITAL PLAINVIEW 2601 DIMMITT RD PLAINVIEW TX 79072 HALE (806) 296-5531 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2072140 -101.7316260 0   189 48 48189 38380   Central Hale County https://data.medicare.gov/resource/xubh-q36u/row-3bv3~8kd2-nnfr 450539 661663 2019-12-03 2019-06-30 44 5         49               49
4682 4682 VAL VERDE REGIONAL MEDICAL CENTER 801 BEDELL AVE DEL RIO TX 78840 VAL VERDE (830) 775-8566 Acute Care Hospitals Proprietary TRUE 29.3744250 -100.8930340 0   465 48 48465 19620   Central Val Verde County https://data.medicare.gov/resource/xubh-q36u/row-vvbk~jkwv.nw4c 450154 660322 2019-12-03 2019-06-30 40 7         47           1   48
3005 3005 SUNNYVIEW HOSPITAL AND REHABILITATION CENTER 1270 BELMONT AVENUE SCHENECTADY NY 12308 SCHENECTADY (518) 386-3580 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.8222290 -73.9138600 0   93 36 36093 10580 Albany-Schenectady, NY Central Schenectady County https://data.medicare.gov/resource/xubh-q36u/row-7q97_97wq-vj47 330406 661755 2019-12-03 2019-06-30 17           17   98           115
1729 1729 TANNER MEDICAL CENTER VILLA RICA 601 DALLAS HIGHWAY VILLA RICA GA 30180 CARROLL (770) 456-3101 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7429920 -84.9194770 0   45 13 13045 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Carroll County https://data.medicare.gov/resource/xubh-q36u/row-r7tm_8s6b-q394 110015 660366 2019-12-03 2019-06-30 34 6         40 92             132
1730 1730 TANNER MEDICAL CENTER - CARROLLTON 705 DIXIE STREET CARROLLTON GA 30117 CARROLL (770) 836-9580 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5705550 -85.0724640 0   45 13 13045 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Carroll County https://data.medicare.gov/resource/xubh-q36u/row-7yah~3pv6~c65g 110011 660365 2019-12-03 2019-06-30 135 12   10     157               157
2133 2133 ST MARY'S HOSPITAL 1230 BAXTER STREET ATHENS GA 30606 CLARKE (706) 389-3930 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9459290 -83.4044670 0   59 13 13059 12020 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Clarke County https://data.medicare.gov/resource/xubh-q36u/row-sxr7_vrrg_xb9c 110006 660364 2019-12-03 2019-06-30 97 68         165   20       83   268
2993 2993 ST VINCENT DUNN HOSPITAL INC 1600 23RD ST BEDFORD IN 47421 LAWRENCE (812) 276-1065 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8534880 -86.4931940 0   93 18 18093 13260 Bloomington-Bedford, IN Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-i3na-nck9_frex 151335 661320 2019-12-03 2019-06-30 25           25               25
86 86 SAINT ALPHONSUS REGIONAL MEDICAL CENTER 1055 NORTH CURTIS ROAD BOISE ID 83706 ADA (208) 367-2121 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.6140720 -116.2536220 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-bd8k~rga3_kmdd 130007 662193 2019-12-03 2019-06-30 282 42       24 348   30           378
516 516 ELLIOT HOSPITAL 1 ELLIOT WAY MANCHESTER NH 3103 HILLSBOROUGH (603) 669-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9827950 -71.4357390 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-eaev.u4vg~83e6 300012 661552 2019-12-03 2019-06-30 183 16         199 41             240
3965 3965 RHEA MEDICAL CENTER 9400 RHEA COUNTY HIGHWAY DAYTON TN 37321 RHEA (423) 775-1121 Critical Access Hospitals Government - Local TRUE 35.5303740 -84.9823340 0   143 47 47143 19420 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Rhea County https://data.medicare.gov/resource/xubh-q36u/row-nzwz~fwja_c4gt 441310 661109 2019-12-03 2019-06-30 22 3         25               25
1237 1237 THOREK MEMORIAL HOSPITAL 850 W IRVING PARK RD CHICAGO IL 60613 COOK (312) 525-6780 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9545560 -87.6508990 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-5qet-q6ur~zveq 140115 661719 2019-12-03 2019-06-30 146 10         156               156
1238 1238 LITTLE COMPANY OF MARY HOSPITAL 2800 W 95TH ST EVERGREEN PARK IL 60805 COOK (708) 422-6200 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.7209020 -87.6919660 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-ayba.shit.wjgg 140179 661867 2019-12-03 2019-06-30 184 26         220 24             244
1239 1239 MACNEAL HOSPITAL 3249 SOUTH OAK PARK AVENUE BERWYN IL 60402 COOK (708) 783-9100 Acute Care Hospitals Proprietary TRUE 41.8320020 -87.7927830 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-8fyp_i9ee-cjpu 140054 662197 2019-12-03 2019-06-30 239 17         256 25 12   25       318
1240 1240 LOYOLA GOTTLIEB MEMORIAL HOSPITAL 701 WEST NORTH AVE MELROSE PARK IL 60160 COOK (708) 681-3200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9083420 -87.8411010 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-f9em_zs87~xp9w 140008 662196 2019-12-03 2019-06-30 109 16         125 12 20   34       191
1259 1259 MERCY HOSPITAL AND MEDICAL CENTER 2525 S MICHIGAN AVE CHICAGO IL 60616 COOK (312) 567-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8470530 -87.6235830 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-c8jf~nktq~hw5i 140158 661721 2019-12-03 2019-06-30 168 14 6       203 39 16           258
779 779 WEST CHESTER HOSPITAL, LLC 7700 UNIVERSITY DRIVE WEST CHESTER OH 45069 BUTLER (513) 298-7700 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3582480 -84.3671700 0   17 39 39017 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-zbwb-99pw~8xag 360354 661612 2019-12-03 2019-06-30 135 18         153               153
2215 2215 UNIVERSITY OF CINCINNATI MEDICAL CENTER, LLC 234 GOODMAN STREET CINCINNATI OH 45219 HAMILTON (513) 584-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.1367280 -84.5025620 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-rc7b_nuaq-8nt3 360003 661583 2019-12-03 2019-06-30 366     10 34   515 40             555
4104 4104 TRINITY HOSPITAL TWIN CITY 819 NORTH FIRST STREET DENNISON OH 44621 TUSCARAWAS (740) 922-2800 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.4014640 -81.3358740 0   157 39 39157 35420 Cleveland-Akron-Canton, OH Central Tuscarawas County https://data.medicare.gov/resource/xubh-q36u/row-yjye.hnn5~27ky 361302 661614 2019-12-03 2019-06-30 25           25               25
2813 2813 METHODIST RICHARDSON MEDICAL CENTER 2831 E PRESIDENT GEORGE BUSH HIGHWAY RICHARDSON TX 75082 COLLIN (469) 204-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9961430 -96.6691760 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-stfg-vvxf_2h9k 450537 660472 2019-12-03 2019-06-30 125 25         172 51             223
3493 3493 METHODIST CHARLTON MEDICAL CENTER 3500 W WHEATLAND ROAD DALLAS TX 75237 DALLAS (214) 947-7777 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.6474440 -96.8762650 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-gfw6_p99d~9eii 450723 660889 2019-12-03 2019-06-30 285 32         317               317
3497 3497 METHODIST DALLAS MEDICAL CENTER 1441 NORTH BECKLEY AVENUE DALLAS TX 75203 DALLAS (214) 947-2879 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.7616390 -96.8230060 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-izsm~sbv7_cnfx 450051 660883 2019-12-03 2019-06-30 258       36   378               378
3504 3504 BAYLOR MEDICAL CENTER AT IRVING 1901 N MACARTHUR BLVD IRVING TX 75061 DALLAS (972) 579-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8354960 -96.9592260 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-3wsg_teba-uziy 450079 660884 2019-12-03 2019-06-30 155 14 25     10 204   18           222
4652 4652 METHODIST MANSFIELD MEDICAL CENTER 2700 E BROAD STREET MANSFIELD TX 76063 TARRANT (682) 622-2059 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.5692280 -97.0956410 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-3zhm.gxuz-a5ti 670023 660157 2019-12-03 2019-06-30 224 22         254               254
593 593 LONGS PEAK HOSPITAL 1750 EAST KEN PRATT BOULEVARD LONGMONT CO 80504 BOULDER (720) 718-3005 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1621720 -105.0581160 1 ROOFTOP 13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-i5b6~xwcd-bndp 60128 661294 2019-12-03 2019-06-30 44 6         50               50
4054 4054 IOWA LUTHERAN HOSPITAL 700 EAST UNIVERSITY AVENUE DES MOINES IA 50316 POLK (515) 263-5612 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6003930 -93.6107560 0   153 19 19153 19780 Des Moines-Ames-West Des Moines, IA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-5ngf-z47j-y8jb 160024 661322 2019-12-03 2019-06-30 151 10         161 12     16       189
2998 2998 ASCENSION BRIGHTON CENTER FOR RECOVERY 12851 GRAND RIVER RD BRIGHTON MI 48116 LIVINGSTON (810) 227-1211 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.5176600 -83.6945230 0   93 26 26093 19820 Detroit-Warren-Ann Arbor, MI Outlying Livingston County https://data.medicare.gov/resource/xubh-q36u/row-qf5d-9hbt_ivvy 230279 661539 2019-12-03 2019-06-30 99           99               99
3999 3999 ASCENSION RIVER DISTRICT HOSPITAL 4100 RIVER RD EAST CHINA MI 48054 ST. CLAIR (810) 329-7111 Acute Care Hospitals Government - Hospital District or Authority FALSE 42.7865050 -82.4782080 0   147 26 26147 19820 Detroit-Warren-Ann Arbor, MI Outlying St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-kcai_xx52-e2uf 230241 661538 2019-12-03 2019-06-30 62 3         65               65
4164 4164 ASCENSION ST JOHN HOSPITAL 22101 MOROSS RD DETROIT MI 48236 WAYNE (313) 343-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.4190110 -82.9150080 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-x44u_zj2b.k8t2 230165 661342 2019-12-03 2019-06-30 462 52       35 549 27 36           612
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
165 165 LUTHERAN HOSPITAL OF INDIANA 7950 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-7001 Acute Care Hospitals Proprietary TRUE 41.0373740 -85.2458850 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-22sz~6zvg.fbpc 150017 661886 2019-12-03 2019-06-30 254   24       396               396
2703 2703 SAINT MARY'S HEALTH CARE 200 JEFFERSON AVENUE SE GRAND RAPIDS MI 49503 KENT (616) 685-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.9582520 -85.6641140 0   81 26 26081 24340 Grand Rapids-Wyoming-Muskegon, MI Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-nf3c_wwgn.2t3h 230059 661537 2019-12-03 2019-06-30 228 32       15 275 28             303
3643 3643 MERCY HEALTH MUSKEGON 1700 CLINTON STREET MUSKEGON MI 49442 MUSKEGON (231) 726-3511 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.2219390 -86.2430750 0   121 26 26121 34740 Grand Rapids-Wyoming-Muskegon, MI Central Muskegon County https://data.medicare.gov/resource/xubh-q36u/row-8d2d~k3ui.36nq 230066 661340 2019-12-03 2019-06-30 287 44         331 27 17           375
2079 2079 LEXINGTON MEMORIAL HOSPITAL INC 250 HOSPITAL DRIVE PO BOX 1817 LEXINGTON NC 27293 DAVIDSON (336) 248-5161 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8027540 -80.2872240 0   57 37 37057 49180 Greensboro--Winston-Salem--High Point, NC Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-ndpr~q5bq~7gpt 340096 661576 2019-12-03 2019-06-30 64 16         80               80
4422 4422 ST LUKE'S HOSPITAL AT THE VINTAGE 20171 CHASEWOOD PARK DRIVE HOUSTON TX 77070 HARRIS (832) 534-5000 Acute Care Hospitals Proprietary TRUE 29.9894890 -95.5702480 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-68e3-j3wm_u7j8 670075 661132 2019-12-03 2019-06-30 70 12         86               86
1848 1848 MISSISSIPPI METHODIST REHAB CTR 1350 E WOODROW WILSON DR JACKSON MS 39216 HINDS (601) 981-2611 Acute Care Hospitals Voluntary non-profit - Private FALSE 32.3268300 -90.1721800 0   49 28 28049 27140 Jackson-Vicksburg-Brookhaven, MS Central Hinds County https://data.medicare.gov/resource/xubh-q36u/row-msuq_x57k.afv9 250152 659986 2019-12-03 2019-06-30 31           31   93       60   184
925 925 CONEMAUGH MEMORIAL MEDICAL CENTER 1086 FRANKLIN STREET JOHNSTOWN PA 15905 CAMBRIA (814) 534-9000 Acute Care Hospitals Proprietary TRUE 40.3051980 -78.9182490 0   21 42 42021 27780 Johnstown-Somerset, PA Central Cambria County https://data.medicare.gov/resource/xubh-q36u/row-29hn-pzm2.n5mv 390110 660295 2019-12-03 2019-06-30 313 14 11       354 13 39   30       436
3450 3450 CONEMAUGH MEYERSDALE MEDICAL CENTER 200 HOSPITAL DRIVE MEYERSDALE PA 15552 SOMERSET (814) 634-5911 Critical Access Hospitals Proprietary TRUE 39.8092810 -79.0253380 0   111 42 42111 43740 Johnstown-Somerset, PA Central Somerset County https://data.medicare.gov/resource/xubh-q36u/row-zfec_mecz_mmru 391302 660304 2019-12-03 2019-06-30 20           20               20
2609 2609 ASCENSION BORGESS HOSPITAL 1521 GULL ROAD KALAMAZOO MI 49048 KALAMAZOO (269) 226-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.3047590 -85.5614250 0   77 26 26077 28020 Kalamazoo-Battle Creek-Portage, MI Central Kalamazoo County https://data.medicare.gov/resource/xubh-q36u/row-e5a3_pdew_gq2m 230117 661341 2019-12-03 2019-06-30 276 15 15       306 50 15           371
3047 3047 TRUMAN MEDICAL CENTER HOSPITAL HILL 2301 HOLMES STREET KANSAS CITY MO 64108 JACKSON (816) 404-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0848150 -94.5757990 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-34yq.yjtb-buxd 260048 661350 2019-12-03 2019-06-30 189 41         238               238
3051 3051 TRUMAN MEDICAL CENTER LAKEWOOD 7900 LEE'S SUMMIT RD KANSAS CITY MO 64139 JACKSON (816) 404-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9735830 -94.3904070 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xhfv_9j22.vn6f 260102 661352 2019-12-03 2019-06-30 97 8         110       188       298
199 199 SAINT ROSE DOMINICAN HOSPITALS - SAN MARTIN CAMPUS 8280 W WARM SPRINGS ROAD LAS VEGAS NV 89113 CLARK (702) 492-8509 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.0555450 -115.2713230 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-sdqu.kd85~4dy8 290053 662224 2019-12-03 2019-06-30 106 24         136               136
2385 2385 JEFFERSON REGIONAL MEDICAL CENTER 1600 WEST 40TH AVENUE PINE BLUFF AR 71603 JEFFERSON (870) 541-7100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1890660 -92.0184530 0   69 5 5069 38220 Little Rock-North Little Rock, AR Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-cysb.jz8a~paid 40071 662147 2019-12-03 2019-06-30 237 34         271 18 27           316

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