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

286 rows where "filed_date" is on date 2019-11-27 sorted by hospital_ownership

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, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date)

  • 2019-11-27 · 286
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
3519 ADVENTIST HEALTH AND RIDEOUT 726 4TH ST MARYSVILLE CA 95901 YUBA (530) 749-4300 Acute Care Hospitals Government - Federal TRUE 39.1388320 -121.5936220 0   115 6 6115 49700 Sacramento-Roseville, CA Central Yuba County https://data.medicare.gov/resource/xubh-q36u/row-ena2_rmjt-rgun 50133 660916 2019-11-27 2019-06-30 179 24         209               209
52 HIGHLAND HOSPITAL 1411 EAST 31ST STREET OAKLAND CA 94602 ALAMEDA (510) 437-4800 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7992340 -122.2311990 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-j4fu_u24q~7stg 50320 662161 2019-11-27 2019-06-30 137 24         169 69 25   109       372
101 BARRETT HOSPITAL & HEALTHCARE 600 MT HWY 91 S DILLON MT 59725 BEAVERHEAD (406) 683-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.2006540 -112.6460030 0   1 30 30001         https://data.medicare.gov/resource/xubh-q36u/row-2tkn_v7av-d2ep 271318 662223 2019-11-27 2019-06-30 18           18               18
252 NORTH BIG HORN HOSPITAL DISTRICT 1115 LANE 12 LOVELL WY 82431 BIG HORN (307) 548-5200 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.8257990 -108.3906880 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-s9vd~bscy-xn2k 531309 662633 2019-11-27 2019-06-30 12           12       85       97
670 KINGMAN REGIONAL MEDICAL CENTER 3269 STOCKTON HILL ROAD KINGMAN AZ 86409 MOHAVE (928) 757-2101 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2199070 -114.0358130 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-3ksp.3iej_8pd7 30055 660485 2019-11-27 2019-06-30 176 20         196   18       12   226
978 BLUE MOUNTAIN HOSPITAL 170 FORD ROAD JOHN DAY OR 97845 GRANT (541) 575-1311 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4176510 -118.9592200 0   23 41 41023         https://data.medicare.gov/resource/xubh-q36u/row-svyy.cxkf.r4qf 381305 662576 2019-11-27 2019-06-30 14           14               14
1074 CLAIBORNE MEMORIAL MEDICAL CENTER 620 EAST COLLEGE STREET HOMER LA 71040 CLAIBORNE (318) 927-2024 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7943270 -93.0624690 0   27 22 22027         https://data.medicare.gov/resource/xubh-q36u/row-ncph.ugan.rj3n 190114 661188 2019-11-27 2019-06-30 33 4         37 10             47
1088 PERSHING GENERAL HOSPITAL 855 6TH STREET/PO BOX 661 LOVELOCK NV 89419 PERSHING (775) 273-2621 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1766240 -118.4820870 0   27 32 32027         https://data.medicare.gov/resource/xubh-q36u/row-9yyu.vv2v~izhm 291304 662550 2019-11-27 2019-06-30 13           13       25       38
1194 POWELL VALLEY HOSPITAL 777 AVENUE H POWELL WY 82435 PARK (307) 754-2267 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7566220 -108.7705470 0   29 56 56029         https://data.medicare.gov/resource/xubh-q36u/row-gs73_h7cj.ibeh 531310 662634 2019-11-27 2019-06-30 25           25       100       125
1344 WILLIAM BEE RIRIE HOSPITAL 1500 AVENUE H ELY NV 89301 WHITE PINE (775) 289-3001 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2560650 -114.8600860 0   33 32 32033         https://data.medicare.gov/resource/xubh-q36u/row-xg87~7vrt.qaws 291302 662548 2019-11-27 2019-06-30 25           25               25
1385 WELLSTAR SYLVAN GROVE HOSPITAL 1050 MCDONOUGH ROAD JACKSON GA 30233 BUTTS (770) 775-7861 Critical Access Hospitals Government - Hospital District or Authority FALSE 33.3030850 -83.9778230 0   35 13 13035 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Butts County https://data.medicare.gov/resource/xubh-q36u/row-uazj.s3pp-ngue 111319 660799 2019-11-27 2019-06-30 25           25               25
1431 GOODALL WITCHER HOSPITAL 101 POSEY AVENUE CLIFTON TX 76634 BOSQUE (254) 675-8322 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7771530 -97.5884310 0   35 48 48035         https://data.medicare.gov/resource/xubh-q36u/row-xqqi.9yb9.h6f2 451385 660476 2019-11-27 2019-06-30 25           25               25
1737 CASEY COUNTY HOSPITAL 187 WOLFORD AVENUE LIBERTY KY 42539 CASEY (606) 787-6275 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3178090 -84.9317170 0   45 21 21045         https://data.medicare.gov/resource/xubh-q36u/row-aju2-kjdy-yhzq 181309 662532 2019-11-27 2019-06-30 24           24               24
1828 MODOC MEDICAL CENTER 228 W MCDOWELL AVE ALTURAS CA 96101 MODOC (530) 233-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.4799490 -120.5455030 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-kyq6~7b5b.wgww 51330 662175 2019-11-27 2019-06-30 16           16       71       87
2048 TAHOE FOREST HOSPITAL 10121 PINE AVE TRUCKEE CA 96161 NEVADA (530) 587-6011 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3251630 -120.2013440 0   57 6 6057 46020 Sacramento-Roseville, CA Central Nevada County https://data.medicare.gov/resource/xubh-q36u/row-n6zm-373j_a9uq 51328 661144 2019-11-27 2019-06-30 19 6         25       37       62
2221 EASTERN PLUMAS HOSPITAL - PORTOLA CAMPUS 500 FIRST AVENUE PORTOLA CA 96122 PLUMAS (530) 832-4277 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.8061440 -120.4631290 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-4uid-vtd8_6vsi 51300 662171 2019-11-27 2019-06-30 9           9       66       75
2319 JACKSON COUNTY MEMORIAL HOSPITAL AUTHORITY 1200 EAST PECAN ST ALTUS OK 73521 JACKSON (580) 379-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6352730 -99.3191190 0   65 40 40065 11060   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-grzh.mrwf.u2yy 370022 660425 2019-11-27 2019-06-30 43 6         49               49
2326 ERLANGER MEDICAL CENTER 975 E 3RD ST CHATTANOOGA TN 37403 HAMILTON (423) 778-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.0478990 -85.2908530 0   65 47 47065 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-5dss-8gth.uas3 440104 660457 2019-11-27 2019-06-30 462 84 8   18 64 674               674
2343 WELLSTAR KENNESTONE HOSPITAL 677 CHURCH STREET MARIETTA GA 30060 COBB (770) 793-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.9681280 -84.5512410 0   67 13 13067 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Cobb County https://data.medicare.gov/resource/xubh-q36u/row-tycq-w98p-rta4 110035 659933 2019-11-27 2019-06-30 533 55 30     24 642   20           662
2401 NATCHITOCHES REGIONAL MEDICAL CENTER 501 KEYSER AVE NATCHITOCHES LA 71457 NATCHITOCHES (318) 471-2628 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7535630 -93.0792530 0   69 22 22069 35060   Central Natchitoches Parish https://data.medicare.gov/resource/xubh-q36u/row-uz56_ud5f_t8uu 190007 660094 2019-11-27 2019-06-30 73 8         81 15     112       208
2402 ASCENSION ST JOSEPH HOSPITAL 200 HEMLOCK TAWAS CITY MI 48764 IOSCO (989) 362-9301 Acute Care Hospitals Government - Hospital District or Authority TRUE 44.2749110 -83.5110020 0   69 26 26069         https://data.medicare.gov/resource/xubh-q36u/row-8tzd-yjbe.qpjd 230100 661009 2019-11-27 2019-06-30 43 4         47               47
2430 BEAR VALLEY COMMUNITY HOSPITAL 41870 GARSTIN DR BIG BEAR LAKE CA 92315 SAN BERNARDINO (909) 866-6501 Critical Access Hospitals Government - Hospital District or Authority FALSE 34.2460230 -116.8883430 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-4ruv_6zyd-x27y 51335 662176 2019-11-27 2019-06-30 9           9       21       30
2692 CRISP REGIONAL HOSPITAL 902 7TH STREET NORTH CORDELE GA 31015 CRISP (229) 276-3100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.9775150 -83.7828460 0   81 13 13081 18380   Central Crisp County https://data.medicare.gov/resource/xubh-q36u/row-cdxw-tgcq~24hj 110104 659938 2019-11-27 2019-06-30 49 16         65       143       208
3001 IRON COUNTY MEDICAL CENTER 301 NORTH HIGHWAY 21 PILOT KNOB MO 63663 IRON (573) 546-1260 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6087570 -90.6291900 0   93 29 29093         https://data.medicare.gov/resource/xubh-q36u/row-gcg8.69nm~t5ha 261336 660408 2019-11-27 2019-06-30 15           15               15
3311 NORTH OAKS MEDICAL CENTER, L L C 15790 PAUL VEGA MD DRIVE HAMMOND LA 70403 TANGIPAHOA (985) 345-2700 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4666980 -90.4575800 0   105 22 22105 25220 New Orleans-Metairie-Hammond, LA-MS Central Tangipahoa Parish https://data.medicare.gov/resource/xubh-q36u/row-bi5b~pgr6-9fkg 190015 659682 2019-11-27 2019-06-30 270 60       14 344               344
3413 TANNER MEDICAL CENTER-EAST ALABAMA 1032 MAIN STREET SOUTH WEDOWEE AL 36278 RANDOLPH (256) 357-2111 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.2966660 -85.4800280 0   111 1 1111         https://data.medicare.gov/resource/xubh-q36u/row-beeg-xgp7.fjvj 11306 659914 2019-11-27 2019-06-30 15           15               15
3526 FLOYD MEDICAL CENTER 304 TURNER MCCALL BLVD P O BOX 233 ROME GA 30162 FLOYD (706) 509-6900 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.2604540 -85.1799570 0   115 13 13115 40660 Rome-Summerville, GA Central Floyd County https://data.medicare.gov/resource/xubh-q36u/row-xuu3.r7hw.gmwg 110054 659936 2019-11-27 2019-06-30 201 26         227 53 19           299
3569 MARSHALL MEDICAL CENTER 1080 NORTH ELLINGTON PARKWAY LEWISBURG TN 37091 MARSHALL (931) 359-6276 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.4644210 -86.7866520 0   117 47 47117 30280 Nashville-Davidson--Murfreesboro, TN Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-kdp7~w7ma-n6wt 441309 660459 2019-11-27 2019-06-30 25           25               25
4111 REGIONAL ONE HEALTH 877 JEFFERSON AVENUE MEMPHIS TN 38103 SHELBY (901) 545-7928 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.1426340 -90.0312970 0   157 47 47157 32820 Memphis-Forrest City, TN-MS-AR Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-s7c8-zbce-azfz 440152 660458 2019-11-27 2019-06-30 164     14   18 288   24   14       326
4398 SCOTLAND COUNTY HOSPITAL 450 E SIGLER AVENUE MEMPHIS MO 63555 SCOTLAND (660) 465-8511 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.4660230 -92.1681710 0   199 29 29199         https://data.medicare.gov/resource/xubh-q36u/row-gdbv.rfmr-j5dc 261310 660633 2019-11-27 2019-06-30 25           25               25
4480 TAYLOR REGIONAL HOSPITAL 1700 OLD LEBANON ROAD CAMPBELLSVILLE KY 42718 TAYLOR (270) 465-3561 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.3662160 -85.3391790 0   217 21 21217 15820   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-qk8p.6ayj.fgni 180087 660562 2019-11-27 2019-06-30 82 8         90               90
36 THAYER COUNTY HEALTH SERVICES 120 PARK AVE HEBRON NE 68370 THAYER (402) 768-6041 Critical Access Hospitals Government - Local TRUE 40.1601230 -97.5932670 0   169 31 31169         https://data.medicare.gov/resource/xubh-q36u/row-b26e~mfmy~67qg 281304 660643 2019-11-27 2019-06-30 19           19               19
145 JOHN DEMPSEY HOSPITAL 263 FARMINGTON AVE FARMINGTON CT 6032 HARTFORD (860) 679-1145 Acute Care Hospitals Government - Local TRUE 41.7350900 -72.7958200 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-dhzf~ccfg~faa5 70036 661473 2019-11-27 2019-06-30 118 20         138 18             156
923 NORTHEASTERN HEALTH SYSTEM 1400 EAST DOWNING STREET TAHLEQUAH OK 74465 CHEROKEE (918) 456-0641 Acute Care Hospitals Government - Local TRUE 35.9153260 -94.9505580 0   21 40 40021 45140 Tulsa-Muskogee-Bartlesville, OK Central Cherokee County https://data.medicare.gov/resource/xubh-q36u/row-y8w6~8rs4_b8fq 370089 660430 2019-11-27 2019-06-30 40 14 16       70 10 10           90
1054 WYOMING MEDICAL CENTER 1233 EAST 2ND ST CASPER WY 82601 NATRONA (307) 577-7201 Acute Care Hospitals Government - Local TRUE 42.8487180 -106.3087530 0   25 56 56025 16220   Central Natrona County https://data.medicare.gov/resource/xubh-q36u/row-sk2z.s7zk-vge8 530012 662631 2019-11-27 2019-06-30 198 14         212               212
1899 DAVIS COUNTY HOSPITAL 509 NORTH MADISON STREET BLOOMFIELD IA 52537 DAVIS (641) 664-2145 Critical Access Hospitals Government - Local TRUE 40.7592230 -92.4149870 0   51 19 19051 36900   Outlying Davis County https://data.medicare.gov/resource/xubh-q36u/row-m6yx_jbnt.5nnb 161327 660964 2019-11-27 2019-06-30 25           25               25
2298 CLINCH MEMORIAL HOSPITAL 1050 VALDOSTA HIGHWAY HOMERVILLE GA 31634 CLINCH (912) 487-5211 Critical Access Hospitals Government - Local TRUE 31.0326510 -82.7638580 0   65 13 13065         https://data.medicare.gov/resource/xubh-q36u/row-6x28-ujdc_jsi5 111308 659942 2019-11-27 2019-06-30 15           15               15
2427 ARROWHEAD REGIONAL MEDICAL CENTER 400 NORTH PEPPER AVENUE COLTON CA 92324 SAN BERNARDINO (909) 580-1000 Acute Care Hospitals Government - Local TRUE 34.0728840 -117.3528330 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-w78g-jnyb.b7ix 50245 662024 2019-11-27 2019-06-30 274 32   14 16 30 366 90             456
2661 LEHIGH VALLEY HOSPITAL - HAZLETON 700 EAST BROAD STREET HAZLETON PA 18201 LUZERNE (570) 501-4000 Acute Care Hospitals Government - Local TRUE 40.9504640 -75.9634540 0   79 42 42079 42540   Central Luzerne County https://data.medicare.gov/resource/xubh-q36u/row-2eia_cme8~vh69 390185 660147 2019-11-27 2019-06-30 122 12         134   16           150
2744 JERSEY COMMUNITY HOSPITAL 400 MAPLE SUMMIT ROAD JERSEYVILLE IL 62052 JERSEY (618) 498-6402 Acute Care Hospitals Government - Local TRUE 39.1099060 -90.3416220 0   83 17 17083 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Jersey County https://data.medicare.gov/resource/xubh-q36u/row-4rjp~camg~jz6s 140059 660513 2019-11-27 2019-06-30 42 4         46               46
3623 MAURY REGIONAL HOSPITAL 1224 TROTWOOD AVE COLUMBIA TN 38401 MAURY (931) 381-1111 Acute Care Hospitals Government - Local TRUE 35.6058550 -87.0658440 0   119 47 47119 34980 Nashville-Davidson--Murfreesboro, TN Outlying Maury County https://data.medicare.gov/resource/xubh-q36u/row-p7jv_yp6j.kbu3 440073 660311 2019-11-27 2019-06-30 200 41 24       265               265
3640 MADISON COUNTY HEALTH CARE SYSTEM 300 WEST HUTCHINGS STREET WINTERSET IA 50273 MADISON (515) 462-2373 Critical Access Hospitals Government - Local TRUE 41.3288160 -94.0169630 0   121 19 19121 19780 Des Moines-Ames-West Des Moines, IA Outlying Madison County https://data.medicare.gov/resource/xubh-q36u/row-qsgk_v4q5~5yrz 161326 660963 2019-11-27 2019-06-30 25           25               25
3642 BARBOURVILLE ARH HOSPITAL 80 HOSPITAL DRIVE BARBOURVILLE KY 40906 KNOX (606) 546-4175 Critical Access Hospitals Government - Local TRUE 36.8523100 -83.8715200 0   121 21 21121 30940   Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-bv2i-ez4s_feje 181328 660569 2019-11-27 2019-06-30 19 6         25               25
3752 CARRIS HEALTH - REDWOOD, LLC 100 FALLWOOD ROAD REDWOOD FALLS MN 56283 REDWOOD (507) 637-4500 Critical Access Hospitals Government - Local TRUE 44.5370300 -95.1072680 0   127 27 27127         https://data.medicare.gov/resource/xubh-q36u/row-nr7s_ak8r_x54m 241351 661207 2019-11-27 2019-06-30 25           25           4   29
3765 ADMIN DE SERVICIOS MEDICOS PUERTO RIC BO MONACILLO CARR NUM 22 SAN JUAN PR 935 SAN JUAN (787) 777-3535 Acute Care Hospitals Government - Local TRUE 18.4500000 -66.0600000 1 APPROXIMATE 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-gchu_zjdy_292t 400127 660877 2019-11-27 2019-06-30   68         68               68
3996 PALO ALTO COUNTY HOSPITAL 3201 1ST STREET EMMETSBURG IA 50536 PALO ALTO (712) 852-5500 Critical Access Hospitals Government - Local TRUE 43.1191910 -94.6913430 0   147 19 19147         https://data.medicare.gov/resource/xubh-q36u/row-u98n.v74q-n83i 161357 660981 2019-11-27 2019-06-30 24           24           1   47
4212 VAN BUREN COUNTY HOSPITAL 304 FRANKLIN STREET KEOSAUQUA IA 52565 VAN BUREN (319) 293-3171 Critical Access Hospitals Government - Local TRUE 40.7358620 -91.9590430 0   177 19 19177         https://data.medicare.gov/resource/xubh-q36u/row-e8fj_uhg7-i98m 161337 660970 2019-11-27 2019-06-30 25           25               25
4324 WAYNE COUNTY HOSPITAL 417 SOUTH EAST STREET CORYDON IA 50060 WAYNE (641) 872-2260 Critical Access Hospitals Government - Local TRUE 40.7544920 -93.3123200 0   185 19 19185         https://data.medicare.gov/resource/xubh-q36u/row-z889-j4w6-dfyd 161358 660982 2019-11-27 2019-06-30 25           25               25
1699 UNIVERSITY OF MISSISSIPPI MEDICAL CENTER- GRENADA 960 AVENT DRIVE GRENADA MS 38901 GRENADA (662) 227-7000 Acute Care Hospitals Government - State TRUE 33.7633070 -89.8175320 0   43 28 28043 24980   Central Grenada County https://data.medicare.gov/resource/xubh-q36u/row-p3dc_vfsq.nigj 250168 659814 2019-11-27 2019-06-30 44   5       49               49
1847 UNIVERSITY OF MISSISSIPPI MED CENTER 2500 N STATE ST JACKSON MS 39216 HINDS (601) 984-4100 Acute Care Hospitals Government - State TRUE 32.3287830 -90.1755800 0   49 28 28049 27140 Jackson-Vicksburg-Brookhaven, MS Central Hinds County https://data.medicare.gov/resource/xubh-q36u/row-ckry~yqs7_czxf 250001 661025 2019-11-27 2019-06-30 486 20 20   20 30 698               698
1909 HOLMES COUNTY HOSPITAL AND CLINICS 239 BOWLING GREEN ROAD LEXINGTON MS 39095 HOLMES (662) 834-1321 Critical Access Hospitals Government - State TRUE 33.1110770 -90.0297410 0   51 28 28051         https://data.medicare.gov/resource/xubh-q36u/row-bbwk_bsmz-qfyj 251319 660403 2019-11-27 2019-06-30 25           25               25
1978 HIRAM W DAVIS MEDICAL CENTER P O BOX 4030 PETERSBURG VA 23803 PETERSBURG CITY (804) 524-7344 Acute Care Hospitals Government - State FALSE 37.2098658 -77.4509355 1 ROOFTOP 53 51 51053 40060   Central Dinwiddie County https://data.medicare.gov/resource/xubh-q36u/row-xvn2.38q5-2xg5 490104 661117 2019-11-27 2019-06-30 4           4       50 30 277   361
3773 HOSPITAL UNIVERSITARIO DE ADULTO BARRIO MONACILLOS CENTROMEDICO RIO PIEDRAS PR 927 SAN JUAN (787) 754-0101 Acute Care Hospitals Government - State TRUE 18.3960081 -66.0738624 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-swte-w8pc_y4fj 400061 660309 2019-11-27 2019-06-30 200 15         215               215
3860 UNIVERSITY OF NORTH CAROLINA HOSPITAL 101 MANNING DRIVE CHAPEL HILL NC 27514 ORANGE (919) 966-4141 Acute Care Hospitals Government - State TRUE 35.9035510 -79.0518940 0   135 37 37135 20500 Raleigh-Durham-Chapel Hill, NC Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-pha8_ahwj~xmph 340061 660649 2019-11-27 2019-06-30 676   13       803 104 30       6   943
4733 UNIVERSITY OF VIRGINIA MEDICAL CENTER 1215 LEE STREET CHARLOTTESVILLE VA 22908 CHARLOTTESVILLE CITY (800) 251-3627 Acute Care Hospitals Government - State TRUE 38.0318290 -78.4984550 0   540 51 51540 16820   Central Charlottesville city https://data.medicare.gov/resource/xubh-q36u/row-br7u-jiza~znwz 490009 660720 2019-11-27 2019-06-30 437 14 9     57 585 27             612
33 RED BUD REGIONAL HOSPITAL 325 SPRING STREET RED BUD IL 62278 RANDOLPH (618) 282-3831 Critical Access Hospitals Proprietary TRUE 38.2096050 -89.9964080 0   157 17 17157         https://data.medicare.gov/resource/xubh-q36u/row-p29n.6wib~fbrj 141348 660526 2019-11-27 2019-06-30 25           25               25
366 NORTHEASTERN NEVADA REGIONAL HOSPITAL 2001 ERRECART BLVD ELKO NV 89801 ELKO (775) 738-5151 Acute Care Hospitals Proprietary TRUE 40.8225080 -115.7290260 0   7 32 32007 21220   Central Elko County https://data.medicare.gov/resource/xubh-q36u/row-q6r2~fn4e-z9r9 290008 662547 2019-11-27 2019-06-30 52 7         59               59
1164 MARY HURLEY HOSPITAL 6 NORTH COVINGTON COALGATE OK 74538 COAL (580) 927-2327 Critical Access Hospitals Proprietary TRUE 34.5392220 -96.2242870 0   29 40 40029         https://data.medicare.gov/resource/xubh-q36u/row-vgqy-nnxi.ph5t 371319 661388 2019-11-27 2019-06-30 20           20               20
1171 BRANDYWINE HOSPITAL 201 REECEVILLE ROAD COATESVILLE PA 19320 CHESTER (610) 383-8000 Acute Care Hospitals Proprietary TRUE 40.0095860 -75.7902630 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-3tb9_z7kw.8hjr 390076 660696 2019-11-27 2019-06-30 140 15         155 16             171
1172 PHOENIXVILLE HOSPITAL 140 NUTT ROAD PHOENIXVILLE PA 19460 CHESTER (610) 983-1000 Acute Care Hospitals Proprietary TRUE 40.1333870 -75.5380530 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-y3he~wx68-j8cb 390127 660699 2019-11-27 2019-06-30 95 24         123   14           137
1439 LONE PEAK HOSPITAL 11925 SOUTH STATE STREET DRAPER UT 84020 SALT LAKE (801) 545-8000 Acute Care Hospitals Proprietary TRUE 40.5352380 -111.8914640 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-3yfr.y4qy.386x 460060 662283 2019-11-27 2019-06-30 26 4         30               30
1776 CHI MEMORIAL HOSPITAL- GEORGIA 100 GROSS CRESCENT CIRCLE FORT OGLETHORPE GA 30742 CATOOSA (770) 874-5400 Acute Care Hospitals Proprietary TRUE 34.9477700 -85.2627560 0   47 13 13047 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Catoosa County https://data.medicare.gov/resource/xubh-q36u/row-a96y-gfhv_jnf7 110236 659941 2019-11-27 2019-06-30 36           36               36
2284 EISENHOWER MEDICAL CENTER 39-000 BOB HOPE DRIVE RANCHO MIRAGE CA 92270 RIVERSIDE (760) 340-3911 Acute Care Hospitals Proprietary TRUE 33.7648520 -116.4080850 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-8rsp~gqw9-ukc2 50573 662165 2019-11-27 2019-06-30 311 34         345   23           368
2601 SOUTHEASTERN REGIONAL MEDICAL CENTER 600 CELEBRATE LIFE PARKWAY NEWNAN GA 30265 COWETA (404) 844-8334 Acute Care Hospitals Proprietary FALSE 33.3863910 -84.7574190 0   77 13 13077 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Coweta County https://data.medicare.gov/resource/xubh-q36u/row-xjc6~cs4d.dgfj 110233 660205 2019-11-27 2019-06-30 45 5         50               50
2878 CRESTWOOD MEDICAL CENTER ONE HOSPITAL DR SE HUNTSVILLE AL 35801 MADISON (256) 882-3100 Acute Care Hospitals Proprietary TRUE 34.6943814 -86.5720291 1 ROOFTOP 89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-tkhv~u3mn_apnu 10131 659468 2019-11-27 2019-06-30 164 16         183               183
3147 JFK MEDICAL CENTER 5301 S CONGRESS AVE ATLANTIS FL 33462 PALM BEACH (561) 965-7300 Acute Care Hospitals Proprietary TRUE 26.5985480 -80.0903100 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-j4p6-7iw3.fhkt 100080 660497 2019-11-27 2019-06-30 551 72         623 92             715
3198 MEDICAL CENTER OF TRINITY 9330 SR 54, STE 401 TRINITY FL 34655 PASCO (727) 834-4900 Acute Care Hospitals Proprietary TRUE 28.2060140 -82.6609640 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-4d2n_cq7g-qn33 100191 660792 2019-11-27 2019-06-30 199 34       12 245 62             307
3234 CHESTNUT HILL HOSPITAL 8835 GERMANTOWN AVE PHILADELPHIA PA 19118 PHILADELPHIA (215) 248-8200 Acute Care Hospitals Proprietary TRUE 40.0787910 -75.2127520 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-f7vd-4uzw~5mpg 390026 660694 2019-11-27 2019-06-30 114 14         128 20             148
3630 WELLSTAR ATLANTA MEDICAL CENTER 303 PARKWAY DRIVE, NE ATLANTA GA 30312 FULTON (404) 265-4000 Acute Care Hospitals Proprietary TRUE 33.7632700 -84.3739860 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-qjqh_i6pn~dht9 110115 660798 2019-11-27 2019-06-30 383 63       33 491 17 20           528
3633 WELLSTAR NORTH FULTON HOSPITAL 3000 HOSPITAL BOULEVARD ROSWELL GA 30076 FULTON (770) 751-2500 Acute Care Hospitals Proprietary TRUE 34.0629890 -84.3224770 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-bhvw-vh6x~dynd 110198 660370 2019-11-27 2019-06-30 141 28         169   33           202
4379 TUG VALLEY ARH REGIONAL MEDICAL CENTER 260 HOSPITAL DRIVE SOUTH WILLIAMSON KY 41503 PIKE (606) 237-1700 Acute Care Hospitals Proprietary TRUE 37.6763730 -82.2965810 0   195 21 21195         https://data.medicare.gov/resource/xubh-q36u/row-nrkm~8dtb_x2ee 180069 662529 2019-11-27 2019-06-30 82 6         88       35       123
4525 WELLSTAR SPALDING REGIONAL HOSPITAL 601 SOUTH 8TH STREET GRIFFIN GA 30223 SPALDING (770) 228-2721 Acute Care Hospitals Proprietary TRUE 33.2392150 -84.2656710 0   255 13 13255 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Spalding County https://data.medicare.gov/resource/xubh-q36u/row-i8c2-fhpr~cjn5 110031 660201 2019-11-27 2019-06-30 138 22         160               160
650 AVERA ST LUKES 305 S STATE ST POST OFFICE BOX 4450 ABERDEEN SD 57401 BROWN (605) 622-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.4617950 -98.4793500 0   13 46 46013 10100   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-pruy~fuxf-c6av 430014 662254 2019-11-27 2019-06-30 43 6         49 10     81 56     196
718 PEACEHEALTH ST JOHN MEDICAL CENTER 1615 DELAWARE STREET LONGVIEW WA 98632 COWLITZ (360) 414-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.1309920 -122.9411920 0   15 53 53015 31020 Portland-Vancouver-Salem, OR-WA Central Cowlitz County https://data.medicare.gov/resource/xubh-q36u/row-n4kt-b68h~5bhw 500041 662288 2019-11-27 2019-06-30 148 18         166               166
895 MERCY HOSPITAL COLUMBUS 220 N PENNSYLVANIA AVENUE COLUMBUS KS 66725 CHEROKEE (620) 429-2545 Critical Access Hospitals Voluntary non-profit - Church TRUE 37.1720640 -94.8438050 0   21 20 20021         https://data.medicare.gov/resource/xubh-q36u/row-sn95~jvt2.e2ep 171308 660551 2019-11-27 2019-06-30 10           10               10
1236 ALEXIAN BROTHERS MEDICAL CENTER 1 800 W BIESTERFIELD RD ELK GROVE VILLAGE IL 60007 COOK (847) 437-5500 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0037050 -88.0149960 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-22rs-enea-7d2m 140258 660521 2019-11-27 2019-06-30 221 36         257 25 72       16   370
1247 RUSH OAK PARK HOSPITAL 520 S MAPLE AVE OAK PARK IL 60304 COOK (708) 383-9300 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.8790260 -87.8038180 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-xnpc~27df_qfvd 140063 661156 2019-11-27 2019-06-30 151 14         165       36       201
1248 ST ALEXIUS MEDICAL CENTER 1555 N BARRINGTON RD HOFFMAN ESTATES IL 60169 COOK (847) 843-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0524090 -88.1444450 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-b2zc_temi.u4ux 140290 660522 2019-11-27 2019-06-30 267 35         318               318
1369 ST FRANCIS COMMUNITY HOSPITAL 34515 9TH AVENUE SOUTH FEDERAL WAY WA 98003 KING (253) 944-8100 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.2921060 -122.3229510 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-26c7~6xv9.c5tp 500141 662625 2019-11-27 2019-06-30 110 14         124               124
1371 ST ELIZABETH HOSPITAL 1450 BATTERSBY AVENUE ENUMCLAW WA 98022 KING (360) 825-2505 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.2084170 -121.9881570 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-8kts.qr6u-cywi 501335 660477 2019-11-27 2019-06-30 25           25               25
1594 MUNSON HEALTHCARE GRAYLING HOSPITAL 1100 E MICHIGAN AVE GRAYLING MI 49738 CRAWFORD (989) 348-5461 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.6672510 -84.7079390 0   39 26 26039         https://data.medicare.gov/resource/xubh-q36u/row-unnq.cpq3.chrb 230058 660583 2019-11-27 2019-06-30 43 6         49       39       88
1839 ASCENSION GENESYS HOSPITAL ONE GENESYS PARKWAY GRAND BLANC MI 48439 GENESEE (810) 606-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.8903226 -83.6367994 1 ROOFTOP 49 26 26049 22420 Detroit-Warren-Ann Arbor, MI Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-puhx-szv4~kvmj 230197 661015 2019-11-27 2019-06-30 305 45         350   20           370
1981 ST JOSEPH MEDICAL CENTER 1717 SOUTH J STREET TACOMA WA 98405 PIERCE (253) 627-4101 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.2454690 -122.4487570 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-pud3~63vu~69st 500108 662624 2019-11-27 2019-06-30 292 82         374               374
1982 ST ANTHONY HOSPITAL 11567 CANTERWOOD BOULEVARD NW GIG HARBOR WA 98332 PIERCE (253) 530-2050 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.3650330 -122.6150630 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-tej2.8itp~9z5w 500151 662293 2019-11-27 2019-06-30 96 16         112               112
1985 ST CLARE HOSPITAL 11315 BRIDGEPORT WAY S W LAKEWOOD WA 98499 PIERCE (253) 588-1711 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.1542130 -122.5044950 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dwu9_j2ug-7e7a 500021 662622 2019-11-27 2019-06-30 75 31         106               106
1994 QUEEN OF THE VALLEY MEDICAL CENTER 1000 TRANCAS ST NAPA CA 94558 NAPA (707) 252-4411 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.3235540 -122.2959680 0   55 6 6055 34900 San Jose-San Francisco-Oakland, CA Central Napa County https://data.medicare.gov/resource/xubh-q36u/row-tqw2_dtrw-avff 50009 662463 2019-11-27 2019-06-30 110 36       6 152   14           166
2122 ST JUDE MEDICAL CENTER 101 E VALENCIA MESA DRIVE FULLERTON CA 92835 ORANGE (714) 992-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.8935030 -117.9279520 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-fxj7-vaud_psma 50168 662471 2019-11-27 2019-06-30 225 51         290   30           320
2126 ST JOSEPH HOSPITAL 1100 WEST STEWART DR ORANGE CA 92868 ORANGE (714) 633-9111 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.7823990 -117.8660930 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-x65w~hu2t-xjdy 50069 661283 2019-11-27 2019-06-30 357 32 20       409 37             446
2161 ST ANTHONY HOSPITAL 2801 ST ANTHONY WAY PENDLETON OR 97801 UMATILLA (541) 276-5121 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.6482496 -118.8124252 1 ROOFTOP 59 41 41059 25840   Central Umatilla County https://data.medicare.gov/resource/xubh-q36u/row-hwf6-ji7m-72j9 381319 660288 2019-11-27 2019-06-30 20 5         25               25
2249 AVERA HOLY FAMILY HOSPITAL 826 NORTH 8TH STREET ESTHERVILLE IA 51334 EMMET (712) 362-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.4105960 -94.8339560 0   63 19 19063         https://data.medicare.gov/resource/xubh-q36u/row-gfry-34vq-dsa9 161351 660978 2019-11-27 2019-06-30 22           22               22
2325 MEMORIAL HEALTHCARE SYSTEM, INC 2525 DESALES AVE CHATTANOOGA TN 37404 HAMILTON (423) 495-2525 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.0400370 -85.2611290 0   65 47 47065 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-urkm~t32p-kn9t 440091 660456 2019-11-27 2019-06-30 363 34 14   12   423               423
2348 ST VINCENT KOKOMO 1907 W SYCAMORE ST KOKOMO IN 46904 HOWARD (765) 452-5611 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.4872180 -86.1554870 0   67 18 18067 29020 Kokomo-Peru, IN Central Howard County https://data.medicare.gov/resource/xubh-q36u/row-h43a-56y9-pcfm 150010 660935 2019-11-27 2019-06-30 98 13         111   18           129
2353 SAINT JOSEPH HOSPITAL ONE SAINT JOSEPH DRIVE LEXINGTON KY 40504 FAYETTE (859) 313-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.0332481 -84.5236220 1 ROOFTOP 67 21 21067 30460 Lexington-Fayette--Richmond--Frankfort, KY Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-erie~rwhk.b5ea 180010 660554 2019-11-27 2019-06-30 205 38 12       255               255
2382 ASPIRUS LANGLADE HOSPITAL 112 E FIFTH AVE ANTIGO WI 54409 LANGLADE (715) 623-2331 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.1403190 -89.1402920 0   67 55 55067         https://data.medicare.gov/resource/xubh-q36u/row-fn2s~3kqd.84yg 521350 661688 2019-11-27 2019-06-30 21 4         25               25
2419 ASCENSION GOOD SAMARITAN HOSPITAL 601 S CENTER AVE MERRILL WI 54452 LINCOLN (715) 536-5511 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.1758580 -89.6830310 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-22bh-e9v4.hnpp 521339 661687 2019-11-27 2019-06-30 25           25               25
2420 ASCENSION SACRED HEART HOSPITAL 401 W MOHAWK DR SUITE 100 TOMAHAWK WI 54487 LINCOLN (715) 453-7700 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.4890060 -89.7335960 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-zubv-e9fv-qs3r 521313 661446 2019-11-27 2019-06-30 15           15               15
2631 HOWARD YOUNG MEDICAL CTR 240 MAPLE ST WOODRUFF WI 54568 VILAS (715) 356-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.8943700 -89.7018370 0   85 55 55085         https://data.medicare.gov/resource/xubh-q36u/row-9mxb-vzak_pksq 520091 661681 2019-11-27 2019-06-30 40 10         50               50
2670 ASCENSION COLUMBIA ST MARY'S HOSPITAL MILWAUKEE 2323 N LAKE DR MILWAUKEE WI 53211 MILWAUKEE (414) 585-1374 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.0614110 -87.8791390 0   79 55 55079 33340 Milwaukee-Racine-Waukesha, WI Central Milwaukee County https://data.medicare.gov/resource/xubh-q36u/row-k5x2_2n3g-wddg 520051 661679 2019-11-27 2019-06-30 190 36   12   25 263               263
2672 ASCENSION SE WISCONSIN HOSPITAL - ST JOSEPH CAMPUS 5000 W CHAMBERS ST MILWAUKEE WI 53210 MILWAUKEE (414) 447-2130 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.0734650 -87.9761000 0   79 55 55079 33340 Milwaukee-Racine-Waukesha, WI Central Milwaukee County https://data.medicare.gov/resource/xubh-q36u/row-i5tc-dt6s_7u6h 520136 661685 2019-11-27 2019-06-30 237 42         325   9           334
2920 CHI ST ALEXIUS HEALTH DICKINSON 2500 FAIRWAY STREET DICKINSON ND 58601 STARK (701) 456-4000 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.8872670 -102.8205980 0   89 38 38089 19860   Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-e333-s9qr~xa2s 351336 659599 2019-11-27 2019-06-30 21 4         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
);