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

212 rows where "filed_date" is on date 2019-11-26 sorted by countyequivalent

View and edit SQL

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

filed_date (date)

  • 2019-11-26 · 212
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
25 ESSENTIA HEALTH ADA 201 9TH STREET WEST ADA MN 56510 NORMAN (218) 784-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2960910 -96.5301900 0   107 27 27107         https://data.medicare.gov/resource/xubh-q36u/row-z63y_de5x~9s9u 241313 660607 2019-11-26 2019-06-30 14           14               14
218 CHI MERCY HEALTH 570 CHAUTAUQUA BLVD VALLEY CITY ND 58072 BARNES (701) 845-6400 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.9284920 -97.9949080 0   3 38 38003         https://data.medicare.gov/resource/xubh-q36u/row-pmhy~szku-z7nc 351324 662240 2019-11-26 2019-06-30 25           25               25
270 BACON COUNTY HOSPITAL 302 SOUTH WAYNE STREET ALMA GA 31510 BACON (912) 632-8961 Critical Access Hospitals Voluntary non-profit - Other TRUE 31.5391100 -82.4596870 0   5 13 13005         https://data.medicare.gov/resource/xubh-q36u/row-fsgt~f6fy~f5qx 111327 659492 2019-11-26 2019-06-30 21 4         25       88       113
291 ESSENTIA HEALTH ST MARYS - DETROIT LAKES 1027 WASHINGTON AVE DETROIT LAKES MN 56501 BECKER (218) 847-0888 Acute Care Hospitals Voluntary non-profit - Church FALSE 46.8153070 -95.8454530 0   5 27 27005         https://data.medicare.gov/resource/xubh-q36u/row-my2b~zwif~njdr 240101 660605 2019-11-26 2019-06-30 28 8         36       96       132
293 COMMUNITY HOSPITAL ASSOCIATION 26136 US HIGHWAY 59, PO BOX 107 FAIRFAX MO 64446 ATCHISON (660) 686-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3482150 -95.3973230 0   5 29 29005         https://data.medicare.gov/resource/xubh-q36u/row-kkzi.c85k.9msb 261303 660249 2019-11-26 2019-06-30 16           16               16
447 MERCY HOSPITAL CASSVILLE 94 MAIN STREET CASSVILLE MO 65625 BARRY (417) 847-6065 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.6740770 -93.8718860 0   9 29 29009         https://data.medicare.gov/resource/xubh-q36u/row-wswc_mpwv.fwbj 261317 660251 2019-11-26 2019-06-30 18           18               18
461 UPMC BEDFORD MEMORIAL 10455 LINCOLN HIGHWAY EVERETT PA 15537 BEDFORD (814) 623-6161 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0247210 -78.4332550 0   9 42 42009         https://data.medicare.gov/resource/xubh-q36u/row-a7tx_6h63.ijq9 390117 659869 2019-11-26 2019-06-30 36 4         40               40
465 LANDMANN-JUNGMAN MEMORIAL HOSPITAL - CAH 600 BILLARS ST SCOTLAND SD 57059 BON HOMME (605) 583-2226 Critical Access Hospitals Government - Local TRUE 43.1494940 -97.7281040 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-h5nm-t8q8-ubs6 431317 662141 2019-11-26 2019-06-30 25           25               25
921 CHI OAKES HOSPITAL 1200 N 7TH ST OAKES ND 58474 DICKEY (701) 742-3291 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1507960 -98.0904330 0   21 38 38021         https://data.medicare.gov/resource/xubh-q36u/row-b2w7_uuc8~i52v 351315 659999 2019-11-26 2019-06-30 20           20               20
1295 CARRINGTON HEALTH CENTER PO BOX 461 CARRINGTON ND 58421 FOSTER (701) 652-3141 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4497201 -99.1262234 1 APPROXIMATE 31 38 38031         https://data.medicare.gov/resource/xubh-q36u/row-inkg_zfig.5z7t 351318 662239 2019-11-26 2019-06-30 25           25               25
1386 CLEARWATER VALLEY HOSPITAL & CLINICS 301 CEDAR STREET OROFINO ID 83544 CLEARWATER (208) 476-4555 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4873150 -116.2599160 0   35 16 16035         https://data.medicare.gov/resource/xubh-q36u/row-4jwp-mz4f-k7tn 131320 659779 2019-11-26 2019-06-30 23           23               23
1538 MERCY MEDICAL CENTER-NEW HAMPTON 308 NORTH MAPLE AVENUE NEW HAMPTON IA 50659 CHICKASAW (641) 394-4121 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0626770 -92.3204250 0   37 19 19037         https://data.medicare.gov/resource/xubh-q36u/row-xkj8-v8qa.w84a 161331 660217 2019-11-26 2019-06-30 8           8               8
1833 ST MARY'S HOSPITAL 701 LEWISTON ST COTTONWOOD ID 83522 IDAHO (208) 962-3251 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0503710 -116.3516450 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-u7zv_7y6z_xg8a 131321 661307 2019-11-26 2019-06-30 25           25               25
1932 MILBANK AREA HOSPITAL/AVERA HEALTH 301 FLYNN DRIVE MILBANK SD 57252 GRANT (605) 432-4538 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2219130 -96.6175485 1 ROOFTOP 51 46 46051         https://data.medicare.gov/resource/xubh-q36u/row-y6xc~czq6~y94b 431326 660034 2019-11-26 2019-06-30 25           25               25
1954 ASPIRUS IRONWOOD HOSPITAL N10561 GRAND VIEW LANE IRONWOOD MI 49938 GOGEBIC (906) 932-2525 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4781930 -90.1046890 0   53 26 26053         https://data.medicare.gov/resource/xubh-q36u/row-kai4_hwh9~ugv4 231333 660107 2019-11-26 2019-06-30 20 5         25               25
1974 AVERA GREGORY HOSPITAL 400 PARK STREET POST OFFICE BOX 408 GREGORY SD 57533 GREGORY (605) 835-8394 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2319878 -99.4304377 1 ROOFTOP 53 46 46053         https://data.medicare.gov/resource/xubh-q36u/row-sxnm~ansc_ejzf 431338 662257 2019-11-26 2019-06-30 25           25       55       80
2000 FRANKLIN HOSPITAL 201 BAILEY LANE BENTON IL 62812 FRANKLIN (618) 439-3161 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.0091370 -88.9171420 0   55 17 17055         https://data.medicare.gov/resource/xubh-q36u/row-a634_xpuq_r7c9 141321 660523 2019-11-26 2019-06-30 25           25               25
2194 DEER RIVER HEALTHCARE CENTER 115 10TH AVENUE NORTHEAST DEER RIVER MN 56636 ITASCA (218) 246-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.3435030 -93.7912990 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-run4_u2tc_i8qs 241360 660613 2019-11-26 2019-06-30 20           20       32       52
2320 NELL J REDFIELD MEMORIAL HOSPITAL 150 NORTH 200 WEST MALAD ID 83252 ONEIDA (208) 766-2231 Critical Access Hospitals Government - Local TRUE 42.1896380 -112.2507590 0   71 16 16071         https://data.medicare.gov/resource/xubh-q36u/row-dtun.jgpu~2hmu 131303 662195 2019-11-26 2019-06-30 11           11       33       44
2322 PENN HIGHLANDS BROOKVILLE 100 HOSPITAL ROAD BROOKVILLE PA 15825 JEFFERSON (814) 849-2312 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.1564730 -79.0928840 0   65 42 42065         https://data.medicare.gov/resource/xubh-q36u/row-5dtj-fqtw.9nmm 391312 660451 2019-11-26 2019-06-30 25           25 10             35
2351 BOB WILSON MEMORIAL GRANT COUNTY HOSPITAL 415 N MAIN STREET ULYSSES KS 67880 GRANT (620) 356-1266 Acute Care Hospitals Proprietary TRUE 37.5839920 -101.3580130 0   67 20 20067         https://data.medicare.gov/resource/xubh-q36u/row-8mti_jcxr_myzi 170110 660091 2019-11-26 2019-06-30 26           26               26
2360 LIVINGSTON HEALTHCARE 320 ALPENGLOW LANE LIVINGSTON MT 59047 PARK (406) 222-3541 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6760430 -110.5254250 0   67 30 30067         https://data.medicare.gov/resource/xubh-q36u/row-ygth.6c69~3dyb 271317 659987 2019-11-26 2019-06-30 21 4         25               25
2467 ASPIRUS IRON RIVER HOSPITAL & CLINICS, INC 1400 W ICE LAKE ROAD IRON RIVER MI 49935 IRON (906) 265-6121 Critical Access Hospitals Voluntary non-profit - Other TRUE 46.0997200 -88.6202810 0   71 26 26071         https://data.medicare.gov/resource/xubh-q36u/row-5hmu-6w8t_e66h 231318 660105 2019-11-26 2019-06-30 22 3         25               25
2542 CHI LISBON HEALTH 905 MAIN ST LISBON ND 58054 RANSOM (701) 683-5241 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4370020 -97.6814270 0   73 38 38073         https://data.medicare.gov/resource/xubh-q36u/row-sifi~rypw~xg47 351311 662066 2019-11-26 2019-06-30 25           25               25
2700 CHRISTUS COUSHATTA HEALTH CARE CENTER 1635 MARVEL STREET COUSHATTA LA 71019 RED RIVER (318) 932-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0216580 -93.3437340 0   81 22 22081         https://data.medicare.gov/resource/xubh-q36u/row-zmg8-cgqs~6zge 191312 659797 2019-11-26 2019-06-30 25           25               25
2911 AVERA ST ANTHONY'S HOSPITAL 300 NORTH 2ND ST O' NEILL NE 68763 HOLT (402) 336-5131 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.4603380 -98.6511180 0   89 31 31089         https://data.medicare.gov/resource/xubh-q36u/row-z9z2~5zkd.wkgh 281329 660645 2019-11-26 2019-06-30 25           25               25
2945 HUMBOLDT COUNTY MEMORIAL HOSPITAL 1000 NORTH 15TH STREET HUMBOLDT IA 50548 HUMBOLDT (515) 332-4200 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.7318350 -94.2302160 0   91 19 19091         https://data.medicare.gov/resource/xubh-q36u/row-vk9h.9r4x-cbu7 161334 660218 2019-11-26 2019-06-30 17           17           28   45
2962 SHERIDAN MEMORIAL HOSPTIAL 440 W LAUREL AVE PLENTYWOOD MT 59254 SHERIDAN (406) 765-3700 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7786770 -104.5629980 0   91 30 30091         https://data.medicare.gov/resource/xubh-q36u/row-sdy5~7jt6~e9wj 271322 660411 2019-11-26 2019-06-30 19           19       45       64
3070 ST CROIX REGIONAL MEDICAL CENTER 235 STATE STREET SAINT CROIX FALLS WI 54024 POLK (715) 483-0556 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.4091340 -92.6422180 0   95 55 55095         https://data.medicare.gov/resource/xubh-q36u/row-xrt7~5aku-syxq 521337 660736 2019-11-26 2019-06-30 22 3         25               25
3239 AVERA FLANDREAU HOSPITAL - CAH 214 NORTH PRAIRIE STREET FLANDREAU SD 57028 MOODY (605) 997-2433 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0505680 -96.5909890 0   101 46 46101         https://data.medicare.gov/resource/xubh-q36u/row-2fiy.k67h.w2yb 431310 660033 2019-11-26 2019-06-30 18           18               18
3292 LINCOLN MEDICAL CENTER 106 MEDICAL CENTER BLVD FAYETTEVILLE TN 37334 LINCOLN (931) 438-1100 Acute Care Hospitals Government - Local TRUE 35.1490050 -86.5573410 0   103 47 47103         https://data.medicare.gov/resource/xubh-q36u/row-cc2v~5skb_qq6b 440102 660708 2019-11-26 2019-06-30 43 6         49               49
3326 JANE PHILLIPS NOWATA HOSPITAL, INC 237 SOUTH LOCUST STREET NOWATA OK 74048 NOWATA (918) 273-3102 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.6965140 -95.6305030 0   105 40 40105         https://data.medicare.gov/resource/xubh-q36u/row-rnwc~4b3z-5gvh 371305 660003 2019-11-26 2019-06-30 25           25               25
3378 MERCY HOSPITAL AURORA 500 PORTER AVENUE AURORA MO 65605 LAWRENCE (417) 678-2122 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.9705100 -93.7109620 0   109 29 29109         https://data.medicare.gov/resource/xubh-q36u/row-pmej_ahzh-su6w 261316 660250 2019-11-26 2019-06-30 25           25               25
3539 BARNES-KASSON COUNTY HOSPITAL 2872 TURNPIKE STREET SUSQUEHANNA PA 18847 SUSQUEHANNA (570) 853-3135 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.9473720 -75.5940160 0   115 42 42115         https://data.medicare.gov/resource/xubh-q36u/row-jek6.26ef-dwbb 391309 659886 2019-11-26 2019-06-30 21 4         25       58       83
3810 ASPIRUS ONTONAGON HOSPITAL, INC 601 S SEVENTH ST ONTONAGON MI 49953 ONTONAGON (906) 884-8000 Critical Access Hospitals Government - Local TRUE 46.8656350 -89.3029760 0   131 26 26131         https://data.medicare.gov/resource/xubh-q36u/row-zhnw-wptd-d4w4 231309 660103 2019-11-26 2019-06-30 25           25       46       71
4060 CENTRACARE HEALTH SYSTEM - LONG PRAIRIE 50 CENTRACARE DRIVE LONG PRAIRIE MN 56347 TODD (320) 732-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9733659 -94.8429923 1 ROOFTOP 153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-auf6_7hb8_cyed 241326 660609 2019-11-26 2019-06-30 14           14       70       84
4298 WEBSTER COUNTY COMMUNITY HOSPITAL P O BOX 465, 621 N FRANKLIN ST RED CLOUD NE 68970 WEBSTER (402) 746-5600 Critical Access Hospitals Government - Local TRUE 40.0915582 -98.5280755 1 ROOFTOP 181 31 31181         https://data.medicare.gov/resource/xubh-q36u/row-2g3y_shvn~j8h3 281316 660132 2019-11-26 2019-06-30 13           13               13
4450 ST CLAIRE REGIONAL MEDICAL CENTER 222 MEDICAL CIRCLE MOREHEAD KY 40351 ROWAN (606) 783-6502 Acute Care Hospitals Government - Federal TRUE 38.1800160 -83.4424540 0   205 21 21205         https://data.medicare.gov/resource/xubh-q36u/row-epvn~wthp~wxsz 180018 660556 2019-11-26 2019-06-30 76 14         90 20 10   7   3   130
4509 CHRISTUS JASPER MEMORIAL HOSPITAL 1275 MARVIN HANCOCK DRIVE JASPER TX 75951 JASPER (409) 384-5461 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.9076390 -94.0085330 0   241 48 48241         https://data.medicare.gov/resource/xubh-q36u/row-3yge~3w33.2wyx 450573 659898 2019-11-26 2019-06-30 34 6         40               40
4708 CHRISTUS MOTHER FRANCES HOSPITAL- WINNSBORO 719 WEST COKE ROAD WINNSBORO TX 75494 WOOD (903) 342-5227 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.9476430 -95.3062300 0   499 48 48499         https://data.medicare.gov/resource/xubh-q36u/row-sujf.kw2i-m7r8 451381 660335 2019-11-26 2019-06-30 23           23               23
57 ST ANTHONY NORTH HEALTH CAMPUS 14300 ORCHARD PKWY WESTMINSTER CO 80023 BROOMFIELD (720) 627-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9558100 -104.9936710 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-ids9.66gw~rrbq 60104 659640 2019-11-26 2019-06-30 72 20         92               92
120 GETTYSBURG HOSPITAL 147 GETTYS STREET GETTYSBURG PA 17325 ADAMS (717) 334-2121 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8233170 -77.2340440 0   1 42 42001 23900 Harrisburg-York-Lebanon, PA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-493f.cvfq~sac8 390065 660855 2019-11-26 2019-06-30 68 8         76               76
233 UPMC EAST 2775 MOSSIDE BOULEVARD MONROEVILLE PA 15146 ALLEGHENY (412) 357-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4370140 -79.7584580 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-dmwf~khzy.9g9v 390328 659885 2019-11-26 2019-06-30 128 8         136   20           156
238 UPMC PRESBYTERIAN SHADYSIDE 200 LOTHROP STREET PITTSBURGH PA 15213 ALLEGHENY (412) 647-8788 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4418240 -79.9607690 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-iy5a_sp2s~jx4a 390164 659874 2019-11-26 2019-06-30 971 110 32   20 30 1175 289 20           1484
239 UPMC PASSAVANT 9100 BABCOCK BOULEVARD PITTSBURGH PA 15237 ALLEGHENY (412) 367-6700 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5682350 -80.0165180 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-tred.86gw-r9r3 390107 660016 2019-11-26 2019-06-30 333 32         365   24           389
654 METHODIST HOSPITAL SOUTH 1905 HWY 97 EAST JOURDANTON TX 78026 ATASCOSA (830) 769-3515 Acute Care Hospitals Proprietary TRUE 28.9331124 -98.5260352 1 ROOFTOP 13 48 48013 41700   Outlying Atascosa County https://data.medicare.gov/resource/xubh-q36u/row-5vk8_ecmw.2bzr 450165 660714 2019-11-26 2019-06-30 61 6         67               67
715 BELLVILLE ST JOSEPH HEALTH CENTER 44 N CUMMINGS ST BELLVILLE TX 77418 AUSTIN (979) 865-3141 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9522650 -96.2607470 0   15 48 48015 26420 Houston-The Woodlands, TX Outlying Austin County https://data.medicare.gov/resource/xubh-q36u/row-dtpr-rvr9.rhky 450253 662602 2019-11-26 2019-06-30 32           32               32
285 MEDSTAR FRANKLIN SQUARE MEDICAL CENTER 9000 FRANKLIN SQUARE DRIVE BALTIMORE MD 21237 BALTIMORE (443) 777-7850 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3503350 -76.4810120 0   5 24 24005 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore County https://data.medicare.gov/resource/xubh-q36u/row-qdqy_nadx.4qry 210015 660388 2019-11-26 2019-06-30 321 26         347               347
4713 JOHNS HOPKINS BAYVIEW MEDICAL CENTER 4940 EASTERN AVENUE BALTIMORE MD 21224 BALTIMORE CITY (410) 550-0123 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2872850 -76.5521340 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-tsuu-47er~ackm 210029 661192 2019-11-26 2019-06-30 332 22 12 10 10 25 411               411
4716 MEDSTAR HARBOR HOSPITAL 3001 SOUTH HANOVER STREET BALTIMORE MD 21225 BALTIMORE CITY (410) 350-3201 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.2513490 -76.6150480 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-j3c9_gym3-5rw7 210034 659803 2019-11-26 2019-06-30 117 12         129               129
4717 MEDSTAR UNION MEMORIAL HOSPITAL 201 EAST UNIVERSITY PARKWAY BALTIMORE MD 21218 BALTIMORE CITY (410) 554-2227 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3303820 -76.6143800 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-azaj.edd6.262f 210024 660389 2019-11-26 2019-06-30 133 52         185               185
4724 MEDSTAR GOOD SAMARITAN HOSPITAL 5601 LOCH RAVEN BOULEVARD BALTIMORE MD 21239 BALTIMORE CITY (443) 444-3902 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3593010 -76.5886840 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-zvrw-pxqd~vwry 210056 659805 2019-11-26 2019-06-30 184 17         201               201
431 UNIVERSITY OF KS HLTH SYSTEM GREAT BEND CAMPUS 514 CLEVELAND STREET GREAT BEND KS 67530 BARTON (620) 792-8833 Acute Care Hospitals Proprietary TRUE 38.3562000 -98.7916190 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-ezt6_4fjw-kpxn 170191 660092 2019-11-26 2019-06-30 29 4         33               33
1041 CHRISTUS SPOHN HOSPITAL BEEVILLE 1500 E HOUSTON HWY BEEVILLE TX 78102 BEE (361) 354-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.4083530 -97.7319250 0   25 48 48025 13300   Central Bee County https://data.medicare.gov/resource/xubh-q36u/row-i8xs~bawd_cyy5 450082 659895 2019-11-26 2019-06-30 32 8         40               40
836 PAUL OLIVER MEMORIAL HOSPITAL 224 PARK AVENUE FRANKFORT MI 49635 BENZIE (231) 352-2200 Critical Access Hospitals Government - Local TRUE 44.6373760 -86.2429130 0   19 26 26019 45900   Outlying Benzie County https://data.medicare.gov/resource/xubh-q36u/row-cypk~xgkd.zsnp 231300 660598 2019-11-26 2019-06-30 8           8       36       44
110 UNM HOSPITAL 2211 LOMAS BOULEVARD NE ALBUQUERQUE NM 87106 BERNALILLO (505) 272-2111 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.0874830 -106.6181480 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-ntcm.qi4a~h9yr 320001 661059 2019-11-26 2019-06-30 345           473 82             555
1179 BAPTIST MEDICAL CENTER 111 DALLAS STREET SAN ANTONIO TX 78205 BEXAR (210) 297-8256 Acute Care Hospitals Proprietary TRUE 29.4328770 -98.4927730 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-9jbx_v3az~nwzz 450058 660466 2019-11-26 2019-06-30 1166 151         1457 38 72           1567
1187 CHRISTUS SANTA ROSA MEDICAL CENTER 2827 BABCOCK ROAD SAN ANTONIO TX 78229 BEXAR (210) 704-3342 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.5129090 -98.5915570 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-332s~bezr_i5q2 450237 660052 2019-11-26 2019-06-30 323 49       5 377               377
1188 CHILDREN'S HOSPITAL OF SAN ANTONIO 333 N SANTA ROSA ST SAN ANTONIO TX 78207 BEXAR (210) 704-3342 Childrens Voluntary non-profit - Private TRUE 29.4277960 -98.4978750 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-v67j_ia2t_8xbm 453315 660057 2019-11-26 2019-06-30 108 26       60 194               194
887 COLISEUM NORTHSIDE HOSPITAL 400 CHARTER BOULEVARD MACON GA 31210 BIBB (478) 757-8200 Acute Care Hospitals Proprietary TRUE 32.8698610 -83.6943610 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-qnzt.yc4b~gnii 110201 660371 2019-11-26 2019-06-30 75 10         85               85
888 COLISEUM MEDICAL CENTERS 350 HOSPITAL DRIVE MACON GA 31217 BIBB (478) 765-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8473150 -83.6202700 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-xqcr.fqgq_42i9 110164 660072 2019-11-26 2019-06-30 138 28       13 179 42 29           250
839 UNIVERSITY OF MISSOURI HEALTH CARE ONE HOSPITAL DRIVE COLUMBIA MO 65212 BOONE (573) 882-4141 Acute Care Hospitals Government - State TRUE 38.9386955 -92.3275514 1 ROOFTOP 19 29 29019 17860 Columbia-Moberly-Mexico, MO Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-63ac~57ef~2j52 260141 660405 2019-11-26 2019-06-30 372 82       58 530 61             591
1574 CHRISTUS ST MICHAEL HEALTH SYSTEM 2600 ST MICHAEL DR TEXARKANA TX 75504 BOWIE (903) 614-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4624900 -94.0744480 0   37 48 48037 45500   Central Bowie County https://data.medicare.gov/resource/xubh-q36u/row-ewkv~jnzh~w9wk 450801 659740 2019-11-26 2019-06-30 290 32 16   8 8 354               354
665 UCHEALTH BROOMFIELD HOSPITAL 11820 DESTINATION DRIVE BROOMFIELD CO 80021 JEFFERSON (303) 460-6000 Acute Care Hospitals Proprietary TRUE 39.9105000 -105.0932070 0   14 8 8014 19740 Denver-Aurora, CO Central Broomfield County https://data.medicare.gov/resource/xubh-q36u/row-dvb6-rzzd_er2t 60129 661295 2019-11-26 2019-06-30 22           22               22
894 BUENA VISTA REGIONAL MEDICAL CENTER 1525 WEST 5TH STREET STORM LAKE IA 50588 BUENA VISTA (712) 732-4030 Critical Access Hospitals Government - Local TRUE 42.6443560 -95.2220080 0   21 19 19021 44740   Central Buena Vista County https://data.medicare.gov/resource/xubh-q36u/row-prcs~bkcs~7h4s 161375 660220 2019-11-26 2019-06-30 20   5       25 10             35
299 VIRTUA WILLINGBORO HOSPITAL 218A SUNSET ROAD WILLINGBORO NJ 8046 BURLINGTON (609) 835-2900 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0486320 -74.8819820 0   5 34 34005 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Burlington County https://data.medicare.gov/resource/xubh-q36u/row-4ph9_abjf-fd9w 310061 660414 2019-11-26 2019-06-30 104 20         124 20             144
778 MCCULLOUGH-HYDE MEMORIAL HOSPITAL 110 NORTH POPLAR STREET OXFORD OH 45056 BUTLER (513) 524-5640 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5121800 -84.7408150 0   17 39 39017 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-tm5u.6nm2.a733 360046 660666 2019-11-26 2019-06-30 41 4         45               45
742 CHRISTUS HEALTH SHREVEPORT - BOSSIER 1453 E BERT KOUNS INDUSTRIAL DRIVE SHREVEPORT LA 71105 CADDO (318) 681-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4259620 -93.7189260 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-nnks_h7jb-jcg8 190041 660807 2019-11-26 2019-06-30 151 20       21 192   16           208
826 CHRISTUS OCHSNER ST PATRICK HOSPITAL 524 DR MICHAEL DEBAKEY STREET LAKE CHARLES LA 70601 CALCASIEU (337) 436-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2154370 -93.2276700 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-574n_fdpb-emzy 190027 659956 2019-11-26 2019-06-30 83 17         100 25 23           148
827 CHRISTUS OCHSNER LAKE AREA HOSPITAL 4200 NELSON ROAD LAKE CHARLES LA 70605 CALCASIEU (337) 474-6370 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1820710 -93.2493480 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-ziqv.tyfx-mhvz 190201 660808 2019-11-26 2019-06-30 80 8       20 108               108
370 VIRTUA OUR LADY OF LOURDES HOSPITAL 1600 HADDON AVENUE CAMDEN NJ 8103 CAMDEN (856) 580-6330 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9270330 -75.0957040 0   7 34 34007 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Camden County https://data.medicare.gov/resource/xubh-q36u/row-vyyn~ykd8-ivs3 310029 661052 2019-11-26 2019-06-30 199 21 21       257   44           301
1309 HOSPITAL UPR, DR FEDERICO TRILLA CARR 3 KM 8 3 AVE 65TH INFANTERIA BOX 6021 CAROLINA PR 984 CAROLINA (787) 757-1800 Acute Care Hospitals Proprietary FALSE 18.3808638 -65.9632825 1 RANGE_INTERPOLATED 31 72 72031 41980 San Juan-Carolina, PR Central Carolina Municipio https://data.medicare.gov/resource/xubh-q36u/row-xbn3-25u3~b8g7 400112 660876 2019-11-26 2019-06-30 210 8         233               233
1321 MERCY MEDICAL CENTER-NORTH IOWA 1000 FOURTH STREET SW MASON CITY IA 50401 CERRO GORDO (641) 428-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1483770 -93.2161020 0   33 19 19033 32380   Central Cerro Gordo County https://data.medicare.gov/resource/xubh-q36u/row-pnyf.wckq.h9kr 160064 660082 2019-11-26 2019-06-30 187 18         205   8   22       235
2550 CHRISTUS MOTHER FRANCES HOSPITAL- JACKSONVILLE 2026 S JACKSON STREET JACKSONVILLE TX 75766 CHEROKEE (903) 541-4500 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9379540 -95.2494290 0   73 48 48073 27380 Tyler-Jacksonville, TX Central Cherokee County https://data.medicare.gov/resource/xubh-q36u/row-g8ft-d3vt-ebpq 451319 659899 2019-11-26 2019-06-30 23           23               23
1170 CHESTER COUNTY HOSPITAL 701 EAST MARSHALL STREET WEST CHESTER PA 19380 CHESTER (610) 431-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9718600 -75.6009240 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-w9bi_cvpv_nst8 390179 659876 2019-11-26 2019-06-30 216 14       14 244               244
796 ST JOSEPHS HOSPITAL 2661 COUNTY HWY I CHIPPEWA FALLS WI 54729 CHIPPEWA (715) 717-7200 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.9516610 -91.3582170 0   17 55 55017 20740 Eau Claire-Menomonie, WI Central Chippewa County https://data.medicare.gov/resource/xubh-q36u/row-nahq.4tp8_ghi9 520017 661127 2019-11-26 2019-06-30 96 6         102               102
1735 MERCYONE CLINTON MEDICAL CENTER 1410 NORTH 4TH STREET CLINTON IA 52732 CLINTON (563) 244-5555 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8605430 -90.1881550 0   45 19 19045 17540 Davenport-Moline, IA-IL Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-2kgs.eg5q.xjrv 160080 660084 2019-11-26 2019-06-30 97 10         107               107
934 DIVINE SAVIOR HEALTHCARE 2817 NEW PINERY ROAD PORTAGE WI 53901 COLUMBIA (608) 742-4131 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5662780 -89.4694450 0   21 55 55021 31540 Madison-Janesville-Beloit, WI Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-qhad~azvf~jeqw 520041 661128 2019-11-26 2019-06-30 37 6         43       83   40   166
947 SHANDS LAKE SHORE REGIONAL MEDICAL CENTER 368 NE FRANKLIN ST LAKE CITY FL 32055 COLUMBIA (386) 292-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1934860 -82.6327040 0   23 12 12023 29380 Gainesville-Lake City, FL Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-vfpa_f8gy-va3h 100102 660791 2019-11-26 2019-06-30 78 9         87               87
1561 BERWICK HOSPITAL CENTER 701 EAST 16TH STREET BERWICK PA 18603 COLUMBIA (570) 759-5020 Acute Care Hospitals Proprietary TRUE 41.0701590 -76.2308040 0   37 42 42037 14100 Bloomsburg-Berwick-Sunbury, PA Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-cn25-dn3w-iqqf 390072 660695 2019-11-26 2019-06-30 77 10         87 14     240       341
1249 INGALLS MEMORIAL HOSPITAL 1 INGALLS DRIVE HARVEY IL 60426 COOK (708) 333-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6063310 -87.6594840 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-vjp9-dpap-bkr6 140191 660514 2019-11-26 2019-06-30 243 25         268 16 42           326
1250 SAINT ANTHONY HOSPITAL 2875 WEST 19TH STREET CHICAGO IL 60623 COOK (773) 521-1710 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8555380 -87.6982720 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-kqum-g8qm_qy52 140095 660928 2019-11-26 2019-06-30 94 15         109 42             151
528 SOUTHERN COOS HOSPITAL & HEALTH CENTER 900 11TH STREET SE BANDON OR 97411 COOS (541) 347-2426 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1132440 -124.4024260 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-gr9r_ty5i_3jqt 381304 660285 2019-11-26 2019-06-30 19           19               19
1614 MEADVILLE MEDICAL CENTER 751 LIBERTY STREET MEADVILLE PA 16335 CRAWFORD (814) 333-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6417880 -80.1463360 0   39 42 42039 32740 Erie-Meadville, PA Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-vxk2.xwfb.xf5v 390113 660857 2019-11-26 2019-06-30 133 12         145 28 11   32       216
1559 ST JOHN SAPULPA, INC 1004 EAST BRYAN SAPULPA OK 74066 CREEK (918) 227-8601 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9933610 -96.1001920 0   37 40 40037 46140 Tulsa-Muskogee-Bartlesville, OK Central Creek County https://data.medicare.gov/resource/xubh-q36u/row-wvjq.he32_w2jq 371312 659718 2019-11-26 2019-06-30 25           25               25
1680 CULLMAN REGIONAL MEDICAL CENTER 1912 ALABAMA HIGHWAY 157 CULLMAN AL 35058 CULLMAN (256) 737-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1985870 -86.8056410 0   43 1 1043 18980 Birmingham-Hoover-Talladega, AL Central Cullman County https://data.medicare.gov/resource/xubh-q36u/row-25az.bw5t.5dxy 10035 659467 2019-11-26 2019-06-30 133 12         145               145
1664 GOOD SAMARITAN HOSPITAL FOURTH AND WALNUT STREETS LEBANON PA 17042 LEBANON (717) 270-7500 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.1463530 -77.1285980 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-nqjx-dmqh-mzcz 390066 661094 2019-11-26 2019-06-30 127 18         145   14           159
1050 UNIVERSITY OF WI HOSPITALS & CLINICS AUTHORITY 600 HIGHLAND AVENUE MADISON WI 53792 DANE (608) 261-0025 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.0772180 -89.4290630 0   25 55 55025 31540 Madison-Janesville-Beloit, WI Central Dane County https://data.medicare.gov/resource/xubh-q36u/row-99mg_w2iz-9z6j 520098 661129 2019-11-26 2019-06-30 498     7     608 18             626
1571 SAINT THOMAS WEST HOSPITAL 4220 HARDING RD, PO BOX 380 NASHVILLE TN 37205 DAVIDSON (615) 222-2111 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.1290830 -86.8434476 1 ROOFTOP 37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-xfk3~krcg.f39q 440082 660312 2019-11-26 2019-06-30 252 88         340               340
1429 AVERA QUEEN OF PEACE 525 N FOSTER MITCHELL SD 57301 DAVISON (605) 995-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.7138420 -98.0073250 0   35 46 46035 33580   Central Davison County https://data.medicare.gov/resource/xubh-q36u/row-vs8d.p4rg.tbmc 430013 660030 2019-11-26 2019-06-30 42 8         50       84       134
2067 GREAT RIVER MEDICAL CENTER 1221 SOUTH GEAR AVENUE WEST BURLINGTON IA 52655 DES MOINES (319) 768-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8073690 -91.1702780 0   57 19 19057 15460   Central Des Moines County https://data.medicare.gov/resource/xubh-q36u/row-8pkk_2khg-h2nd 160057 660081 2019-11-26 2019-06-30 124 12         136   11   160   6   313
2137 LAKES REGIONAL HEALTHCARE 2301 HIGHWAY 71 SPIRIT LAKE IA 51360 DICKINSON (712) 336-1230 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.4183960 -95.1263120 0   59 19 19059 44020   Central Dickinson County https://data.medicare.gov/resource/xubh-q36u/row-afjd-chpt.x7ew 160124 660085 2019-11-26 2019-06-30 41   3       44               44
1380 SKY RIDGE MEDICAL CENTER 10101 RIDGEGATE PARKWAY LONE TREE CO 80124 DOUGLAS (720) 225-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.5293230 -104.8702690 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-qr62~ugzc.jjbq 60112 659642 2019-11-26 2019-06-30 214 30         272               272
2186 MERCYONE DUBUQUE MEDICAL CENTER 250 MERCY DRIVE DUBUQUE IA 52001 DUBUQUE (563) 589-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.4931450 -90.6743500 0   61 19 19061 20220   Central Dubuque County https://data.medicare.gov/resource/xubh-q36u/row-852u.y47f-95x9 160069 660083 2019-11-26 2019-06-30 142 8         150   9   20       179
1447 SACRED HEART HOSPITAL 900 W CLAIREMONT AVE EAU CLAIRE WI 54701 EAU CLAIRE (715) 717-4121 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.7934620 -91.5106560 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-4e2t_bcw7.5pgk 520013 660730 2019-11-26 2019-06-30 146 14     8   168   24           192
701 ARTESIA GENERAL HOSPITAL 702 N 13TH STREET ARTESIA NM 88210 EDDY (575) 748-3333 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8486030 -104.4127520 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-t6vu-yth8.bk8u 320030 659993 2019-11-26 2019-06-30 34           34 15             49
1638 CENTURA HEALTH-PENROSE-ST FRANCIS HEALTH SERVICES 2222 NORTH NEVADA AVE COLORADO SPRINGS CO 80907 EL PASO (719) 776-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8655680 -104.8201230 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-gqx3~746f~9uqw 60031 659763 2019-11-26 2019-06-30 354 45         445   23           468
1639 UNIVERSITY COLO HEALTH MEMORIAL HOSPITAL CENTRAL 1400 E BOULDER ST COLORADO SPRINGS CO 80909 EL PASO (719) 365-5000 Acute Care Hospitals Government - Local TRUE 38.8388120 -104.7999510 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-a2ae-uent-g89f 60022 659639 2019-11-26 2019-06-30 385 46         515   22           537
3905 BAYLOR SCOTT & WHITE MEDICAL CENTER- WAXAHACHIE 2400 N INTERSTATE HIGHWAY 35E WAXAHACHIE TX 75165 ELLIS (972) 923-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4296220 -96.8597360 0   139 48 48139 19100 Dallas-Fort Worth, TX-OK Central Ellis County https://data.medicare.gov/resource/xubh-q36u/row-9ydz_89ap~3znh 450372 659897 2019-11-26 2019-06-30 94 12         106               106
1752 DILEY RIDGE MEDICAL CENTER 7911 DILEY ROAD CANAL WINCHESTER OH 43110 FRANKLIN (614) 838-7910 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8500530 -82.7811000 0   45 39 39045 18140 Columbus-Marion-Zanesville, OH Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-82cy_fgw2.yjpg 360358 660675 2019-11-26 2019-06-30 10           10               10

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