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 county_name

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
76 UF HEALTH SHANDS HOSPITAL 1600 SW ARCHER RD GAINESVILLE FL 32610 ALACHUA (352) 265-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.6392230 -82.3433250 0   1 12 12001 23540 Gainesville-Lake City, FL Central Alachua County https://data.medicare.gov/resource/xubh-q36u/row-6avt~6iq6-eksg 100113 661480 2019-11-27 2019-06-30 519 66 48 8 96   921 90 39           1050
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
112 ALBANY MEMORIAL HOSPITAL 600 NORTHERN BOULEVARD ALBANY NY 12204 ALBANY (518) 471-3490 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6746850 -73.7488610 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-fbeu-trch-uemx 330003 661359 2019-11-27 2019-06-30 57 16         73               73
227 MAGEE WOMENS HOSPITAL OF UPMC HEALTH SYSTEM 300 HALKET STREET PITTSBURGH PA 15213 ALLEGHENY (412) 641-4010 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.4370770 -79.9595460 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-tusn~f4sz~kzrq 390114 660858 2019-11-27 2019-06-30 220 18         315       20       335
231 OHIO VALLEY GENERAL HOSPITAL 25 HECKEL ROAD MCKEES ROCKS PA 15136 ALLEGHENY (412) 777-6161 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4724220 -80.0928730 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-fzb2.pi34_kuyu 390157 659873 2019-11-27 2019-06-30 60 27         87 21 16           124
232 ST CLAIR HOSPITAL 1000 BOWER HILL ROAD PITTSBURGH PA 15243 ALLEGHENY (412) 942-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3767750 -80.0669660 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-rf2f_7h7t~9hcu 390228 660445 2019-11-27 2019-06-30 264 12 16       303 26             329
321 CHI ST LUKES HEALTH MEMORIAL LUFKIN 1201 WEST FRANK STREET LUFKIN TX 75901 ANGELINA (936) 634-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.3373240 -94.7424810 0   5 48 48005 31260   Central Angelina County https://data.medicare.gov/resource/xubh-q36u/row-rdm9.4ki2~5y5k 450211 660887 2019-11-27 2019-06-30 148 24         172   12           184
356 ASSUMPTION COMMUNITY HOSPITAL 135 HIGHWAY 402 NAPOLEONVILLE LA 70390 ASSUMPTION (985) 369-3600 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.9575850 -91.0338750 0   7 22 22007         https://data.medicare.gov/resource/xubh-q36u/row-smss_wf6g.wmww 191303 659796 2019-11-27 2019-06-30 15           15               15
4715 SAINT AGNES HOSPITAL 900 CATON AVENUE BALTIMORE MD 21229 BALTIMORE CITY (410) 368-2101 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.2726280 -76.6708160 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-8677_z859_wmay 210011 660387 2019-11-27 2019-06-30 215 16 12       267               267
332 CUMBERLAND MEMORIAL HOSPITAL 1110 7TH AVENUE CUMBERLAND WI 54829 BARRON (715) 822-7500 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.5309390 -92.0295920 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-r4fu_4cy5~ir4d 521353 661689 2019-11-27 2019-06-30 25           25               25
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
460 GREAT PLAINS REGIONAL MEDICAL CENTER 1801 WEST 3RD STREET ELK CITY OK 73644 BECKHAM (580) 225-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4117210 -99.4256540 0   9 40 40009 21120   Central Beckham County https://data.medicare.gov/resource/xubh-q36u/row-ygr6~ifvk~u3j8 370019 660278 2019-11-27 2019-06-30 28 6         34 12 8           54
605 MIDDLESBORO APPALACHIAN REGIONAL HEALTHCARE HOSPIT 3600 WEST CUMBERLAND AVENUE MIDDLESBORO KY 40965 BELL (606) 242-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6051990 -83.7400560 0   13 21 21013 33180   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-ddm7.jenh~wuwk 180020 660557 2019-11-27 2019-06-30 39 7         46               46
532 READING HOSPITAL 420 S 5TH AVENUE WEST READING PA 19611 BERKS (610) 988-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3298630 -75.9480590 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-rf2n_5umm~j8bk 390044 659867 2019-11-27 2019-06-30 491 20     21 30 562 50 62   50       724
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
511 ESSENTIA HEALTH HOLY TRINITY HOSPITAL 115 SECOND STREET WEST, BOX 157 GRACEVILLE MN 56240 BIG STONE (320) 748-8200 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.5624100 -96.4334520 0   11 27 27011         https://data.medicare.gov/resource/xubh-q36u/row-crzd_579y.ukdv 241321 660608 2019-11-27 2019-06-30 15           15       40       55
645 UPMC ALTOONA 620 HOWARD AVENUE ALTOONA PA 16601 BLAIR (814) 889-2011 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5211420 -78.3981840 0   13 42 42013 11020   Central Blair County https://data.medicare.gov/resource/xubh-q36u/row-wkn5_wsma_rprd 390073 661248 2019-11-27 2019-06-30 303 33 8       344               344
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
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
824 BUCHANAN COUNTY HEALTH CENTER 1600 FIRST ST EAST INDEPENDENCE IA 50644 BUCHANAN (319) 332-0999 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.4687870 -91.8750150 0   19 19 19019         https://data.medicare.gov/resource/xubh-q36u/row-cq2e.inyq-2gxf 161335 660969 2019-11-27 2019-06-30 25           25           39   64
1113 BUCHANAN GENERAL HOSPITAL 1535 SLATE CREEK ROAD GRUNDY VA 24614 BUCHANAN (276) 935-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.2855060 -82.0678170 0   27 51 51027         https://data.medicare.gov/resource/xubh-q36u/row-fxtx.a9g4-8ec6 490127 660724 2019-11-27 2019-06-30 37 12         49               49
913 MERCYONE OAKLAND MEDICAL CENTER 601 EAST SECOND ST OAKLAND NE 68045 BURT (402) 685-5601 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8345710 -96.4591970 0   21 31 31021         https://data.medicare.gov/resource/xubh-q36u/row-bi44_haku_5d9v 281321 660644 2019-11-27 2019-06-30 16           16               16
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
719 ASCENSION CALUMET HOSPITAL 614 MEMORIAL DRIVE CHILTON WI 53014 CALUMET (920) 849-2386 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0254390 -88.1543990 0   15 55 55015 11540 Appleton-Oshkosh-Neenah, WI Central Calumet County https://data.medicare.gov/resource/xubh-q36u/row-q97p-97ns_bxut 521317 661447 2019-11-27 2019-06-30 25           25               25
781 INTEGRIS CANADIAN VALLEY HOSPITAL 1201 HEALTH CENTER PARKWAY YUKON OK 73099 CANADIAN (405) 717-6800 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4836950 -97.7602420 0   17 40 40017 36420 Oklahoma City-Shawnee, OK Central Canadian County https://data.medicare.gov/resource/xubh-q36u/row-bfap-q9md_hknr 370211 660282 2019-11-27 2019-06-30 66 8         74               74
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
775 ESSENTIA HEALTH FARGO 3000 32ND AVE SOUTH FARGO ND 58104 CASS (701) 364-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.8325000 -96.8281060 0   17 38 38017 22020 Fargo-Wahpeton, ND-MN Central Cass County https://data.medicare.gov/resource/xubh-q36u/row-9tdc-2u7p-zr8f 350070 662238 2019-11-27 2019-06-30 89 44         133               133
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
1142 MUNSON HEALTHCARE CHARLEVOIX HOSPITAL 14700 LAKESHORE DRIVE CHARLEVOIX MI 49720 CHARLEVOIX (231) 547-4024 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.3144980 -85.2748510 1 ROOFTOP 29 26 26029         https://data.medicare.gov/resource/xubh-q36u/row-cdsd.f9cx_c7j8 231322 660601 2019-11-27 2019-06-30 25           25               25
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
1553 CHATHAM HOSPITAL INC 475 PROGRESS BLVD SILER CITY NC 27344 CHATHAM (919) 799-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.7235100 -79.4222610 0   37 37 37037 20500 Raleigh-Durham-Chapel Hill, NC Central Chatham County https://data.medicare.gov/resource/xubh-q36u/row-7ygq~q73i.83q4 341311 660655 2019-11-27 2019-06-30 21 4         25               25
1894 CANDLER HOSPITAL 5353 REYNOLDS STREET SAVANNAH GA 31412 CHATHAM (912) 819-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.0273610 -81.1017310 0   51 13 13051 42340 Savannah-Hinesville-Statesboro, GA Central Chatham County https://data.medicare.gov/resource/xubh-q36u/row-cmu8.t2da.4a2c 110024 659932 2019-11-27 2019-06-30 192 20         212   23   11       246
1896 ST JOSEPH'S HOSPITAL - SAVANNAH 11705 MERCY BOULEVARD SAVANNAH GA 31419 CHATHAM (912) 819-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.9850790 -81.1527920 0   51 13 13051 42340 Savannah-Hinesville-Statesboro, GA Central Chatham County https://data.medicare.gov/resource/xubh-q36u/row-8433~zwv5_hgz5 110043 659935 2019-11-27 2019-06-30 172 22 16       210   22   11       243
799 FLOYD CHEROKEE MEDICAL CENTER 400 NORTHWOOD DR CENTRE AL 35960 CHEROKEE (256) 927-5531 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1627610 -85.6514200 0   19 1 1019         https://data.medicare.gov/resource/xubh-q36u/row-wy8i.rrc6.c8zi 10022 660348 2019-11-27 2019-06-30 45           45               45
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
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
1601 MURPHY MEDICAL CENTER INC 3990 EAST US HIGHWAY 64 ALT MURPHY NC 28906 CHEROKEE (828) 837-8161 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0731600 -83.9654240 0   39 37 37039         https://data.medicare.gov/resource/xubh-q36u/row-6u4n.7ur8_z37n 341328 660656 2019-11-27 2019-06-30 25           25               25
1168 JENNERSVILLE HOSPITAL 1015 WEST BALTIMORE PIKE WEST GROVE PA 19390 CHESTER (610) 869-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8227440 -75.8879180 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-gfcj_eve8~h6ap 390220 660700 2019-11-27 2019-06-30 43 10         53               53
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
870 ASCENSION OUR LADY OF VICTORY HOSPITAL 1120 PINE ST STANLEY WI 54768 CHIPPEWA (715) 644-5571 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.9553110 -90.9205640 0   19 55 55019         https://data.medicare.gov/resource/xubh-q36u/row-xzzk-sbky-rj53 521311 661445 2019-11-27 2019-06-30 24           24               24
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
1393 MIDMICHIGAN MEDICAL CENTER-CLARE 703 N MCEWAN ST CLARE MI 48617 CLARE (989) 802-5000 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.8207240 -84.7683490 0   35 26 26035         https://data.medicare.gov/resource/xubh-q36u/row-x95c-xq2z-tjc4 230180 661013 2019-11-27 2019-06-30 49           49               49
12 CLARKE COUNTY HOSPITAL 800 S FILLMORE ST OSCEOLA IA 50213 CLARKE (641) 342-2184 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0257100 -93.7675330 0   39 19 19039         https://data.medicare.gov/resource/xubh-q36u/row-xtat~vhgt.9ane 161348 660976 2019-11-27 2019-06-30 25           25               25
818 ORANGE PARK MEDICAL CENTER 2001 KINGSLEY AVE ORANGE PARK FL 32073 CLAY (904) 276-8500 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.1648070 -81.7385980 0   19 12 12019 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-wsf2~ud7b_znaf 100226 660500 2019-11-27 2019-06-30 229 28         273 24 20           317
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
1427 BUCKTAIL MEDICAL CENTER 1001 PINE STREET RENOVO PA 17764 CLINTON (570) 923-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.3269380 -77.7374450 0   35 42 42035 30820 Williamsport-Lock Haven, PA Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-vesv-my7y~edhc 391304 660870 2019-11-27 2019-06-30 16           16       43       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
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
255 FLAGSTAFF MEDICAL CENTER 1200 NORTH BEAVER STREET FLAGSTAFF AZ 86001 COCONINO (928) 779-3366 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2095340 -111.6448350 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-bzd3~hd4v-cg2f 30023 662010 2019-11-27 2019-06-30 183 41       18 242 22             264
2815 BAYLOR SCOTT AND WHITE MEDICAL CENTER MCKINNEY 5252 WEST UNIVERSITY DRIVE MC KINNEY TX 75071 COLLIN (469) 764-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2184040 -96.6810200 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-z87n_qjyy.khsy 670082 660482 2019-11-27 2019-06-30 114 16       13 143               143
1562 GEISINGER-BLOOMSBURG HOSPITAL 549 EAST FAIR STREET BLOOMSBURG PA 17815 COLUMBIA (570) 387-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0084310 -76.4531930 0   37 42 42037 14100 Bloomsburg-Berwick-Sunbury, PA Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-86e6-ifiy~4gix 390003 661087 2019-11-27 2019-06-30 44 12         56 20             76
1233 RUSH UNIVERSITY MEDICAL CENTER 1653 WEST CONGRESS PARKWAY CHICAGO IL 60612 COOK (312) 942-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8751660 -87.6685100 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-jhqf.rc36_fwc5 140119 661160 2019-11-27 2019-06-30 387       56 55 576 67 54           697
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
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
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
1425 SAINT FRANCIS HOSPITAL VINITA, INC 735 NORTH FOREMAN STREET VINITA OK 74301 CRAIG (918) 256-7551 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6533720 -95.1556420 0   35 40 40035         https://data.medicare.gov/resource/xubh-q36u/row-bg5g~s52b_99xj 370237 659861 2019-11-27 2019-06-30 35           35 20             55
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
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
1663 HOLY SPIRIT HOSPITAL 503 NORTH 21ST STREET CAMP HILL PA 17011 CUMBERLAND (717) 763-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2514100 -76.9234680 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-p38r_8hnx-xf4j 390004 660850 2019-11-27 2019-06-30 239 21 12       277 31             308
3509 BAYLOR UNIVERSITY MEDICAL CENTER 3500 GASTON AVE DALLAS TX 75246 DALLAS (214) 820-0111 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.7905670 -96.7808100 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-9d5w.w52g_35rp 450021 660882 2019-11-27 2019-06-30 619 128         824               824
1707 MILTON S HERSHEY MEDICAL CENTER 500 UNIVERSITY DRIVE HERSHEY PA 17033 DAUPHIN (717) 531-8521 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.2659320 -76.6745570 0   43 42 42043 25420 Harrisburg-York-Lebanon, PA Central Dauphin County https://data.medicare.gov/resource/xubh-q36u/row-wsnf.ibqp_dukp 390256 661640 2019-11-27 2019-06-30 421 16     61 50 548               548
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
3089 WELLSTAR DOUGLAS HOSPITAL 8954 HOSPITAL DRIVE DOUGLASVILLE GA 30134 DOUGLAS (770) 949-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.7389730 -84.7330500 0   97 13 13097 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-ti6d-jhrr.aif6 110184 659940 2019-11-27 2019-06-30 94 8         102               102
2184 MERCYONE DYERSVILLE MEDICAL CENTER 1111 3RD STREET SW DYERSVILLE IA 52040 DUBUQUE (563) 875-7101 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4759240 -91.1296320 0   61 19 19061 20220   Central Dubuque County https://data.medicare.gov/resource/xubh-q36u/row-erwi.dcvk.sxse 161378 660547 2019-11-27 2019-06-30 20           20               20
1212 UF HEALTH JACKSONVILLE 655 W 8TH ST JACKSONVILLE FL 32209 DUVAL (904) 244-0411 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.3467990 -81.6642280 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-ku4k~xtjd~bra7 100001 661475 2019-11-27 2019-06-30 348 80 49     8 533       56       589
1637 UCHEALTH GRANDVIEW HOSPITAL 5623 PULPIT PEAK VIEW COLORADO SPRINGS CO 80918 EL PASO (719) 272-3623 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9102620 -104.8164360 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-6gec-fw6v-ugx7 60130 660178 2019-11-27 2019-06-30 22           22               22
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
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
1315 ASCENSION SACRED HEART PENSACOLA 5151 N 9TH AVE PENSACOLA FL 32504 ESCAMBIA (850) 416-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4755880 -87.2109860 0   33 12 12033 37860   Central Escambia County https://data.medicare.gov/resource/xubh-q36u/row-cuin_8gyu.u6ry 100025 660788 2019-11-27 2019-06-30 419 34       26 561               561
2352 SAINT JOSEPH EAST 150 NORTH EAGLE CREEK DRIVE LEXINGTON KY 40509 FAYETTE (859) 967-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.0001990 -84.4403710 0   67 21 21067 30460 Lexington-Fayette--Richmond--Frankfort, KY Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-rapg-8qze_gszp 180143 660566 2019-11-27 2019-06-30 148 12         160               160
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
1668 LAKE CITY COMMUNITY HOSPITAL 258 N RON MCNAIR BLVD LAKE CITY SC 29560 FLORENCE (843) 374-2036 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8803700 -79.7590890 0   41 45 45041 22500   Central Florence County https://data.medicare.gov/resource/xubh-q36u/row-cj23~5qzh.swv8 420066 661103 2019-11-27 2019-06-30 26           26               26
2350 FLOYD COUNTY MEDICAL CENTER 800 11TH ST CHARLES CITY IA 50616 FLOYD (641) 228-6830 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.0526670 -92.6825050 0   67 19 19067         https://data.medicare.gov/resource/xubh-q36u/row-wh9h~5vd4_p9gh 161347 660975 2019-11-27 2019-06-30 25           25               25
2458 ARH OUR LADY OF THE WAY 11203 MAIN STREET MARTIN KY 41649 FLOYD (606) 285-6400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.5791050 -82.7503510 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-y85x_rrhk~w2dk 181305 660806 2019-11-27 2019-06-30 25           25               25
2460 MCDOWELL ARH HOSPITAL 9879 KENTUCKY ROUTE 122 MC DOWELL KY 41647 FLOYD (606) 377-3400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.4571740 -82.7472640 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-igz6~ps78.wjtc 181331 661515 2019-11-27 2019-06-30 21 4         25               25
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
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
1812 INTEGRIS BASS BAPTIST HEALTH CENTER 600 SOUTH MONROE ENID OK 73701 GARFIELD (580) 233-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3899070 -97.8864990 0   47 40 40047 21420   Central Garfield County https://data.medicare.gov/resource/xubh-q36u/row-utms_e679-iry4 370016 660424 2019-11-27 2019-06-30 114 19       4 183               183
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
1840 HURLEY MEDICAL CENTER ONE HURLEY PLAZA FLINT MI 48503 GENESEE (810) 257-9000 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.0212629 -83.7046814 1 GEOMETRIC_CENTER 49 26 26049 22420 Detroit-Warren-Ann Arbor, MI Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-kud9-8wsb.pvu8 230132 661010 2019-11-27 2019-06-30 256 46 13 11   44 370 35 13           418
452 SPEARE MEMORIAL HOSPITAL 16 HOSPITAL ROAD PLYMOUTH NH 3264 GRAFTON (603) 536-1120 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7578860 -71.6948370 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-tpyx~4vjq_mct4 301311 661929 2019-11-27 2019-06-30 25           25               25
2012 MUNSON MEDICAL CENTER 1105 SIXTH STREET TRAVERSE CITY MI 49684 GRAND TRAVERSE (231) 935-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.7616450 -85.6415880 0   55 26 26055 45900   Central Grand Traverse County https://data.medicare.gov/resource/xubh-q36u/row-ytzp_khah~df5e 230097 660589 2019-11-27 2019-06-30 377 20         409 17 16           442
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
1718 SOUTHWEST HEALTH CENTER 1400 EAST SIDE RD PLATTEVILLE WI 53818 GRANT (608) 348-2331 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.7197810 -90.4557830 0   43 55 55043 38420   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-vwfv~jm7m_6m6b 521354 661836 2019-11-27 2019-06-30 25           25 10     78       113
1949 MARION GENERAL HOSPITAL 441 N WABASH AVE MARION IN 46952 GRANT (765) 660-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5638530 -85.6651390 0   53 18 18053 31980   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-562w_32w4-3n42 150011 660936 2019-11-27 2019-06-30 87 19         106   18           124
2791 TWIN LAKES REGIONAL MEDICAL CENTER 910 WALLACE AVENUE LEITCHFIELD KY 42754 GRAYSON (270) 259-9400 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.4719470 -86.2870380 0   85 21 21085         https://data.medicare.gov/resource/xubh-q36u/row-me6k_7rgh~hwhf 180070 660561 2019-11-27 2019-06-30 69 6         75               75
2857 JANE TODD CRAWFORD HOSPITAL 202-206 MILBY STREET GREENSBURG KY 42743 GREEN (270) 932-4211 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.2421240 -85.4963020 0   87 21 21087         https://data.medicare.gov/resource/xubh-q36u/row-yq9p-j8q9-m4wf 181325 661514 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
1728 ASCENSION SACRED HEART GULF 3801 E HWY 98 PORT SAINT JOE FL 32456 GULF (850) 229-5600 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7765620 -85.2876050 0   45 12 12045 37460   Outlying Gulf County https://data.medicare.gov/resource/xubh-q36u/row-2gve.rn5c.g9tq 100313 660196 2019-11-27 2019-06-30 19           19               19
2064 ST VINCENT FISHERS HOSPITAL INC 13861 OLIO ROAD FISHERS IN 46037 HAMILTON (317) 415-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9888520 -85.9188440 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-a5mj~2uur-2exn 150181 660945 2019-11-27 2019-06-30 46           46               46
2212 CHRIST HOSPITAL 2139 AUBURN AVENUE CINCINNATI OH 45219 HAMILTON (513) 585-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.1211670 -84.5085020 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-sq5c_z2tb.uff8 360163 661605 2019-11-27 2019-06-30 403 21 16   12 19 471 31 36           538
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
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
2165 AVERA HAND COUNTY MEMORIAL HOSPITAL AND CLINIC 300 W 5TH ST MILLER SD 57362 HAND (605) 853-2421 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5206230 -98.9920440 0   59 46 46059         https://data.medicare.gov/resource/xubh-q36u/row-cen8-s23k_ktis 431337 662584 2019-11-27 2019-06-30 25           25               25
3041 HARLAN ARH HOSPITAL 81 BALL PARK ROAD HARLAN KY 40831 HARLAN (606) 573-8100 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8101830 -83.3131050 0   95 21 21095         https://data.medicare.gov/resource/xubh-q36u/row-yegj_y2j5.e33p 180050 660559 2019-11-27 2019-06-30 74 7         81 30             111
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

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