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 subprovider_ipf_beds

View and edit SQL

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
68 BAYHEALTH HOSPITAL, KENT CAMPUS 640 S STATE STREET DOVER DE 19901 KENT (302) 744-7001 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.1506870 -75.5223270 0   1 10 10001 20100 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-xzyy~cxna_anhv 80004 662104 2019-12-03 2019-06-30 189 29         281               281
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
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
150 ST FRANCIS HOSPITAL 7TH AND CLAYTON STS WILMINGTON DE 19805 NEW CASTLE (302) 421-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7498827 -75.5665813 1 ROOFTOP 3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-2uda_n6xn~szp8 80003 660361 2019-12-03 2019-06-30 154 20         180               180
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
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
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 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 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 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 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 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 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 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
484 BROWARD HEALTH NORTH 201 E SAMPLE RD POMPANO BEACH FL 33064 BROWARD (954) 786-6950 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.2751370 -80.1207390 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-itvd-njjr.5yxa 100086 661478 2019-12-03 2019-06-30 251 29 8       304   30           334
497 BROWARD HEALTH CORAL SPRINGS 3000 CORAL HILLS DR CORAL SPRINGS FL 33065 BROWARD (954) 344-3000 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.2687790 -80.2541610 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-8hk9~vqe6-vica 100276 662357 2019-12-03 2019-06-30 130 16 35       196               196
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
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
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
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
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
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 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 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 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 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
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
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
1349 GALION COMMUNITY HOSPITAL 269 PORTLAND WAY SOUTH GALION OH 44833 CRAWFORD (419) 468-4841 Critical Access Hospitals Voluntary non-profit - Church FALSE 40.7311430 -82.8032960 0   33 39 39033 15340 Mansfield-Ashland-Bucyrus, OH Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-5krw_yxr7-22n8 361325 661619 2019-12-03 2019-06-30 22 3         25   10           35
1350 BUCYRUS COMMUNITY HOSPITAL 629 NORTH SANDUSKY AVENUE BUCYRUS OH 44820 CRAWFORD (419) 562-4677 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.8156980 -82.9756040 0   33 39 39033 15340 Mansfield-Ashland-Bucyrus, OH Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-aujg-sixr-jmqg 361316 661617 2019-12-03 2019-06-30 19 6         25               25
1454 ST MARY MEDICAL CENTER 1050 LINDEN AVE LONG BEACH CA 90813 LOS ANGELES (562) 491-9000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.7799540 -118.1866830 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-822b_vkkd-dfpx 50191 662021 2019-12-03 2019-06-30 195 30       25 250   34           284
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 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
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
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 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
1775 MERCY MEDICAL CENTER 333 MERCY AVENUE MERCED CA 95340 MERCED (209) 564-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3401220 -120.4652140 0   47 6 6047 32900 Modesto-Merced, CA Central Merced County https://data.medicare.gov/resource/xubh-q36u/row-w9t4~7ucu~gmfz 50444 661461 2019-12-03 2019-06-30 166 20         186               186
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
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
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
2047 SIERRA NEVADA MEMORIAL HOSPITAL 155 GLASSON WAY GRASS VALLEY CA 95945 NEVADA (530) 274-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.2289490 -121.0472640 0   57 6 6057 46020 Sacramento-Roseville, CA Central Nevada County https://data.medicare.gov/resource/xubh-q36u/row-tqcx-33m6.phqg 50150 662470 2019-12-03 2019-06-30 100 4         104               104
2060 GRAHAM HOSPITAL ASSOCIATION 210 WEST WALNUT STREET CANTON IL 61520 FULTON (309) 647-5240 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5532930 -90.0381150 0   57 17 17057 15900 Peoria-Canton, IL Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-xkp5.fehw.8cwr 140001 661308 2019-12-03 2019-06-30 38 5         43       20 18     81
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
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
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
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 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
2338 MERCY GENERAL HOSPITAL 4001 J ST SACRAMENTO CA 95819 SACRAMENTO (916) 453-4453 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5693850 -121.4524820 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-rwmi.cr73~pmuw 50017 661453 2019-12-03 2019-06-30 343   25   21   389   30           419
2339 MERCY HOSPITAL OF FOLSOM 1650 CREEKSIDE DRIVE FOLSOM CA 95630 SACRAMENTO (916) 983-7400 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6711250 -121.1458330 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-uh5k-64gy~w35r 50414 662163 2019-12-03 2019-06-30 98 8         106               106
2340 MERCY SAN JUAN MEDICAL CENTER 6501 COYLE AVE CARMICHAEL CA 95608 SACRAMENTO (916) 537-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.6680480 -121.3129640 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-7ym9-ncgj_itkz 50516 662477 2019-12-03 2019-06-30 288 56       26 370               370
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 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
2429 LOMA LINDA UNIVERSITY CHILDREN'S HOSPITAL 11234 ANDERSON STREET SUITE A LOMA LINDA CA 92354 SAN BERNARDINO (909) 558-8000 Acute Care Hospitals Voluntary non-profit - Church FALSE 34.0494820 -117.2611220 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-pf24-s78t.y754 50778 662028 2019-12-03 2019-06-30 160         84 343               343
2431 LOMA LINDA UNIVERSITY MEDICAL CENTER 11234 ANDERSON ST LOMA LINDA CA 92354 SAN BERNARDINO (909) 558-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0494820 -117.2611220 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-r4h3-hu3v~c6dr 50327 660169 2019-12-03 2019-06-30 339 41 33       463   61           524
2433 ST BERNARDINE MEDICAL CENTER 2101 N WATERMAN AVE SAN BERNARDINO CA 92404 SAN BERNARDINO (909) 883-8711 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1343310 -117.2787600 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-nb4u_ggs9~ayk9 50129 661457 2019-12-03 2019-06-30 261 47       20 328               328
2466 NEW ORLEANS EAST HOSPITAL 5620 READ BLVD NEW ORLEANS LA 70127 ORLEANS (504) 592-6600 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.0307380 -89.9715830 0   71 22 22071 35380 New Orleans-Metairie-Hammond, LA-MS Central Orleans Parish https://data.medicare.gov/resource/xubh-q36u/row-n3g7_ie2c.v7eh 190313 662208 2019-12-03 2019-06-30 50           50               50
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
2590 ST JOSEPH'S MEDICAL CENTER OF STOCKTON 1800 N CALIFORNIA ST STOCKTON CA 95204 SAN JOAQUIN (209) 943-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9707370 -121.2892510 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-6eu4-8z8z~ftzd 50084 662014 2019-12-03 2019-06-30 279 30 9     30 348               348
2636 PRESTON MEMORIAL HOSPITAL 150 MEMORIAL DRIVE KINGWOOD WV 26537 PRESTON (304) 329-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4656410 -79.6763980 0   77 54 54077 34060 Morgantown-Fairmont, WV Outlying Preston County https://data.medicare.gov/resource/xubh-q36u/row-6xzk~kxqz_ca3u 511312 661674 2019-12-03 2019-06-30 25           25               25
2807 SHARON REGIONAL HEALTH SYSTEM 740 EAST STATE STREET SHARON PA 16146 MERCER (724) 983-3800 Acute Care Hospitals Proprietary TRUE 41.2330090 -80.4954970 0   85 42 42085 49660 Youngstown-Warren, OH-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-x4we.ijz6_pgmf 390211 661253 2019-12-03 2019-06-30 174 12 9       195       38       233
2846 DOMINICAN HOSPITAL 1555 SOQUEL DRIVE SANTA CRUZ CA 95065 SANTA CRUZ (831) 462-7700 Acute Care Hospitals Proprietary TRUE 36.9883410 -121.9838180 0   87 6 6087 42100 San Jose-San Francisco-Oakland, CA Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-yrt6-ce3m.tfzi 50242 662023 2019-12-03 2019-06-30 172 16       14 202   20           222
2972 LANSDALE HOSPITAL 100 MEDICAL CAMPUS DRIVE LANSDALE PA 19446 MONTGOMERY (215) 368-2100 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.2512000 -75.2715230 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-47ck-pm39.hwef 390012 660851 2019-12-03 2019-06-30 126 14         140               140
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
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
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
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
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 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
3150 BOCA RATON REGIONAL HOSPITAL 800 MEADOWS RD BOCA RATON FL 33486 PALM BEACH (561) 362-5002 Acute Care Hospitals Voluntary non-profit - Private TRUE 26.3595990 -80.1022110 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-q6we_su9g_5fxn 100168 660182 2019-12-03 2019-06-30 319 30     11   370               370
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
3232 ARIA HEALTH 10800 KNIGHTS ROAD PHILADELPHIA PA 19114 PHILADELPHIA (215) 612-4129 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0707880 -74.9814290 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-hak8.j8jv.xez2 390115 661634 2019-12-03 2019-06-30 383           450               450
3233 WILLS EYE HOSPITAL 840 WALNUT STREET PHILADELPHIA PA 19107 PHILADELPHIA (215) 440-3100 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9482710 -75.1557000 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-nxn5~vwjj_bn3j 390331 660449 2019-12-03 2019-06-30 4           4               4
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
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 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
3414 ST JOHNS PLEASANT VALLEY HOSPITAL 2309 ANTONIO AVE CAMARILLO CA 93010 VENTURA (805) 389-5800 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2429650 -119.0183060 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-t2cn.wci4_rvdy 50616 662168 2019-12-03 2019-06-30 73 8         81       74       155
3418 ST JOHNS REGIONAL MEDICAL CENTER 1600 N ROSE AVE OXNARD CA 93030 VENTURA (805) 988-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2165550 -119.1583510 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-s23s~wseq.h96w 50082 661284 2019-12-03 2019-06-30 206 20         242   23           265
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
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
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 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 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
3577 UAMS MEDICAL CENTER 4301 WEST MARKHAM STREET MAIL SLOT 612 LITTLE ROCK AR 72205 PULASKI (501) 686-5000 Acute Care Hospitals Government - State TRUE 34.7515830 -92.3209980 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-s6x4~kv5r_9fry 40016 660912 2019-12-03 2019-06-30 389 28 24     64 505               505
3583 ARKANSAS CHILDREN'S HOSPITAL 1 CHILDREN'S WAY, SLOT 301 LITTLE ROCK AR 72202 PULASKI (501) 364-1100 Childrens Voluntary non-profit - Private TRUE 34.7428220 -92.2920060 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-p66z~xhi7.pxk4 43300 660352 2019-12-03 2019-06-30 153 26 30 10   104 336               336
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 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 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 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 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 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 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 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
3901 AVITA ONTARIO 715 RICHLAND MALL ONTARIO OH 44906 RICHLAND (567) 307-7666 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7724080 -82.5932600 0   139 39 39139 31900 Mansfield-Ashland-Bucyrus, OH Central Richland County https://data.medicare.gov/resource/xubh-q36u/row-vdni.wbw2~6kux 360365 661613 2019-12-03 2019-06-30 19 7         26               26
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
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
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
4014 FLOYD VALLEY HEALTHCARE 714 LINCOLN ST NE LE MARS IA 51031 PLYMOUTH (712) 546-7871 Critical Access Hospitals Proprietary TRUE 42.7972800 -96.1559900 0   149 19 19149 43580 Sioux City-Vermillion, IA-SD-NE Outlying Plymouth County https://data.medicare.gov/resource/xubh-q36u/row-dyg7.rs5y.hwrt 161368 661183 2019-12-03 2019-06-30 25           25               25
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
4099 ST ELIZABETH MEDICAL CENTER 1200 GRANT BLVD W WABASHA MN 55981 WABASHA (651) 565-4531 Critical Access Hospitals Proprietary TRUE 44.3864160 -92.0491400 0   157 27 27157 40340 Rochester-Austin, MN Outlying Wabasha County https://data.medicare.gov/resource/xubh-q36u/row-diq7.k9ja_4m53 241335 661737 2019-12-03 2019-06-30 14           14       100       114
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

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