Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

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

View and edit SQL

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

filed_date (date)

  • 2019-12-03 · 165
Link rowid hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds ▼ icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
3233 WILLS EYE HOSPITAL 840 WALNUT STREET PHILADELPHIA PA 19107 PHILADELPHIA (215) 440-3100 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9482710 -75.1557000 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-nxn5~vwjj_bn3j 390331 660449 2019-12-03 2019-06-30 4           4               4
3173 UNITY MEDICAL CENTER 164 W 13TH STREET GRAFTON ND 58237 WALSH (701) 352-1620 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4114840 -97.4138290 0   99 38 38099         https://data.medicare.gov/resource/xubh-q36u/row-xvyg.2uq7_fcwn 351320 660660 2019-12-03 2019-06-30 14           14               14
4024 CORDELL MEMORIAL HOSPITAL 1220 NORTH GLENN ENGLISH STREET CORDELL OK 73632 WASHITA (580) 832-3339 Critical Access Hospitals Government - Local TRUE 35.3025240 -98.9875950 0   149 40 40149         https://data.medicare.gov/resource/xubh-q36u/row-k6qa-iqdm.jnj9 371325 660005 2019-12-03 2019-06-30 14           14               14
4099 ST ELIZABETH MEDICAL CENTER 1200 GRANT BLVD W WABASHA MN 55981 WABASHA (651) 565-4531 Critical Access Hospitals Proprietary TRUE 44.3864160 -92.0491400 0   157 27 27157 40340 Rochester-Austin, MN Outlying Wabasha County https://data.medicare.gov/resource/xubh-q36u/row-diq7.k9ja_4m53 241335 661737 2019-12-03 2019-06-30 14           14       100       114
883 GLENN MEDICAL CENTER 1133 W SYCAMORE ST WILLOWS CA 95988 GLENN (530) 934-1818 Critical Access Hospitals Government - Federal TRUE 39.5204670 -122.2081200 0   21 6 6021         https://data.medicare.gov/resource/xubh-q36u/row-7nst_26uq.zcvx 51306 662484 2019-12-03 2019-06-30 15           15               15
1645 HERINGTON MUNICIPAL HOSPITAL 100 E HELEN STREET HERINGTON KS 67449 DICKINSON (785) 258-2207 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.6795610 -96.9422740 0   41 20 20041         https://data.medicare.gov/resource/xubh-q36u/row-sgwx~evd5.tciy 171340 661326 2019-12-03 2019-06-30 15           15               15
884 SAN LUIS VALLEY HEALTH CONEJOS COUNTY HOSPITAL 19021 US HIGHWAY 285 LA JARA CO 81140 CONEJOS (719) 274-5121 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.2637500 -105.9640950 0   21 8 8021         https://data.medicare.gov/resource/xubh-q36u/row-2ncf.isv7_93r9 61308 662179 2019-12-03 2019-06-30 17           17               17
3005 SUNNYVIEW HOSPITAL AND REHABILITATION CENTER 1270 BELMONT AVENUE SCHENECTADY NY 12308 SCHENECTADY (518) 386-3580 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.8222290 -73.9138600 0   93 36 36093 10580 Albany-Schenectady, NY Central Schenectady County https://data.medicare.gov/resource/xubh-q36u/row-7q97_97wq-vj47 330406 661755 2019-12-03 2019-06-30 17           17   98           115
3474 BEACHAM MEMORIAL HOSPITAL 205 N CHERRY STREET MAGNOLIA MS 39652 PIKE (601) 783-2353 Acute Care Hospitals Proprietary FALSE 31.1456260 -90.4592900 0   113 28 28113 32620   Central Pike County https://data.medicare.gov/resource/xubh-q36u/row-3dmz-gqww~dtyc 250049 660400 2019-12-03 2019-06-30 17           17 14             31
1350 BUCYRUS COMMUNITY HOSPITAL 629 NORTH SANDUSKY AVENUE BUCYRUS OH 44820 CRAWFORD (419) 562-4677 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.8156980 -82.9756040 0   33 39 39033 15340 Mansfield-Ashland-Bucyrus, OH Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-aujg-sixr-jmqg 361316 661617 2019-12-03 2019-06-30 19 6         25               25
2381 SUMMERSVILLE REGIONAL MEDICAL CENTER 400 FAIRVIEW HEIGHTS ROAD SUMMERSVILLE WV 26651 NICHOLAS (304) 872-2891 Critical Access Hospitals Government - Local TRUE 38.2919030 -80.8311360 0   67 54 54067         https://data.medicare.gov/resource/xubh-q36u/row-a2eh.63jr_sfyc 511322 661675 2019-12-03 2019-06-30 19 6         25       52       77
3901 AVITA ONTARIO 715 RICHLAND MALL ONTARIO OH 44906 RICHLAND (567) 307-7666 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7724080 -82.5932600 0   139 39 39139 31900 Mansfield-Ashland-Bucyrus, OH Central Richland County https://data.medicare.gov/resource/xubh-q36u/row-vdni.wbw2~6kux 360365 661613 2019-12-03 2019-06-30 19 7         26               26
3450 CONEMAUGH MEYERSDALE MEDICAL CENTER 200 HOSPITAL DRIVE MEYERSDALE PA 15552 SOMERSET (814) 634-5911 Critical Access Hospitals Proprietary TRUE 39.8092810 -79.0253380 0   111 42 42111 43740 Johnstown-Somerset, PA Central Somerset County https://data.medicare.gov/resource/xubh-q36u/row-zfec_mecz_mmru 391302 660304 2019-12-03 2019-06-30 20           20               20
2086 FULTON COUNTY MEDICAL CENTER 214 PEACH ORCHARD ROAD MCCONNELLSBURG PA 17233 FULTON (717) 485-3155 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.9367160 -78.0090000 0   57 42 42057         https://data.medicare.gov/resource/xubh-q36u/row-wvyv.r4u3.6wb9 391303 660450 2019-12-03 2019-06-30 21           21       67       88
2658 EASTERN OKLAHOMA MEDICAL CENTER 105 WALL STREET POTEAU OK 74953 LE FLORE (918) 647-8161 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.0439790 -94.6128340 0   79 40 40079 22900   Outlying Le Flore County https://data.medicare.gov/resource/xubh-q36u/row-4db9~xpsx-e222 371337 662241 2019-12-03 2019-06-30 21 4         25 10             35
2989 MERCY MEDICAL CENTER MT SHASTA 914 PINE STREET MOUNT SHASTA CA 96067 SISKIYOU (530) 926-6111 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.3177640 -122.3215540 0   93 6 6093         https://data.medicare.gov/resource/xubh-q36u/row-z3p6.8j4z_mz6s 51319 662174 2019-12-03 2019-06-30 21 4         25               25
3273 BELL HOSPITAL 901 LAKESHORE DRIVE ISHPEMING MI 49849 MARQUETTE (906) 486-4431 Critical Access Hospitals Proprietary TRUE 46.4986650 -87.6829930 0   103 26 26103 32100   Central Marquette County https://data.medicare.gov/resource/xubh-q36u/row-ag2p-d743~hfr4 231321 661204 2019-12-03 2019-06-30 21   4       25               25
3797 KETCHIKAN MEDICAL CENTER 3100 TONGASS AVENUE KETCHIKAN AK 99901 KETCHIKAN GATEWAY (907) 225-5171 Critical Access Hospitals Voluntary non-profit - Church TRUE 55.3527170 -131.6860490 0   130 2 2130 28540   Central Ketchikan Gateway Borough https://data.medicare.gov/resource/xubh-q36u/row-qt33-ugsf~ggm9 21311 661277 2019-12-03 2019-06-30 21 4         25       29       54
872 JOHNSON COUNTY HEALTHCARE CENTER 497 WEST LOTT BUFFALO WY 82834 JOHNSON (307) 684-5521 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.3497880 -106.7072480 0   19 56 56019         https://data.medicare.gov/resource/xubh-q36u/row-jfvm_9yjt_xtnf 531308 662298 2019-12-03 2019-06-30 22           22           3   69
1349 GALION COMMUNITY HOSPITAL 269 PORTLAND WAY SOUTH GALION OH 44833 CRAWFORD (419) 468-4841 Critical Access Hospitals Voluntary non-profit - Church FALSE 40.7311430 -82.8032960 0   33 39 39033 15340 Mansfield-Ashland-Bucyrus, OH Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-5krw_yxr7-22n8 361325 661619 2019-12-03 2019-06-30 22 3         25   10           35
3965 RHEA MEDICAL CENTER 9400 RHEA COUNTY HIGHWAY DAYTON TN 37321 RHEA (423) 775-1121 Critical Access Hospitals Government - Local TRUE 35.5303740 -84.9823340 0   143 47 47143 19420 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Rhea County https://data.medicare.gov/resource/xubh-q36u/row-nzwz~fwja_c4gt 441310 661109 2019-12-03 2019-06-30 22 3         25               25
451 ALICE PECK DAY MEMORIAL HOSPITAL 10 ALICE PECK DAY DRIVE LEBANON NH 3766 GRAFTON (603) 448-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6402930 -72.2643660 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-t8xb_fse9~ukfj 301305 661743 2019-12-03 2019-06-30 24           24               24
3751 MERCY HEALTH LAKESHORE CAMPUS 72 SOUTH STATE STREET SHELBY MI 49455 OCEANA (231) 861-2156 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6070530 -86.3651500 0   127 26 26127         https://data.medicare.gov/resource/xubh-q36u/row-4je3~28uk~h2y8 231320 661203 2019-12-03 2019-06-30 24           24               24
3940 ARKANSAS CHILDREN'S NORTHWEST, INC 2601 GENE GEORGE BOULEVARD SPRINGDALE AR 72762 WASHINGTON (479) 725-6800 Childrens Voluntary non-profit - Private TRUE 36.1633250 -94.1926020 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ancy_ajta_8yhj 43301 660747 2019-12-03 2019-06-30 24           24               24
319 CAMDEN GENERAL HOSPITAL 175 HOSPITAL DRIVE CAMDEN TN 38320 BENTON (731) 584-0109 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.0557800 -88.1075170 0   5 47 47005         https://data.medicare.gov/resource/xubh-q36u/row-rp5g~twzk~kf69 441316 660045 2019-12-03 2019-06-30 25           25               25
365 BROADWATER HEALTH CENTER 110 N OAK ST TOWNSEND MT 59644 BROADWATER (406) 266-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3213540 -111.5164280 0   7 30 30007         https://data.medicare.gov/resource/xubh-q36u/row-3bqc_c9ze~3cij 271333 662052 2019-12-03 2019-06-30 25           25               25
406 MARK TWAIN MEDICAL CENTER 768 MOUNTAIN RANCH RD SAN ANDREAS CA 95249 CALAVERAS (209) 754-2515 Critical Access Hospitals Voluntary non-profit - Other FALSE 38.1909730 -120.6706610 0   9 6 6009         https://data.medicare.gov/resource/xubh-q36u/row-vzvr.d5an~vpec 51332 660493 2019-12-03 2019-06-30 25           25               25
436 BUNKIE GENERAL HOSPITAL 427 EVERGREEN STREET BUNKIE LA 71322 AVOYELLES (318) 346-6681 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.9524260 -92.1766470 0   9 22 22009         https://data.medicare.gov/resource/xubh-q36u/row-56d9~jh8q~59bh 191311 662210 2019-12-03 2019-06-30 25           25               25
474 MEMORIAL HOSPITAL OF CONVERSE COUNTY 111 SOUTH 5TH STREET DOUGLAS WY 82633 CONVERSE (307) 358-2122 Critical Access Hospitals Government - Local TRUE 42.7588050 -105.3812790 0   9 56 56009         https://data.medicare.gov/resource/xubh-q36u/row-zei4~mbih_rgkv 531302 662095 2019-12-03 2019-06-30 25           25               25
738 NORTH CADDO MEDICAL CENTER 815 SOUTH PINE STREET VIVIAN LA 71082 CADDO (318) 375-3235 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.8634600 -93.9877170 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-b4zm~5u3q.sne4 191304 662209 2019-12-03 2019-06-30 25           25               25
2268 HOLDENVILLE GENERAL HOSPITAL 100 MCDOUGAL DRIVE HOLDENVILLE OK 74848 HUGHES (405) 379-4200 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.0882130 -96.3782650 0   63 40 40063         https://data.medicare.gov/resource/xubh-q36u/row-sj8k.rz7i~rzh6 371321 660004 2019-12-03 2019-06-30 25           25               25
2311 SALEM MEMORIAL DISTRICT HOSPITAL PO BOX 774, SALEM MO 65560 DENT (573) 729-6626 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6604402 -91.5692851 1 ROOFTOP 65 29 29065         https://data.medicare.gov/resource/xubh-q36u/row-wiw4-tpja~sz74 261318 661354 2019-12-03 2019-06-30 25           25           18   43
2415 BOLIVAR GENERAL HOSPITAL 650 NUCKOLLS ROAD BOLIVAR TN 38008 HARDEMAN (731) 658-3100 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.2679530 -89.0005770 0   69 47 47069         https://data.medicare.gov/resource/xubh-q36u/row-xpdy_i9ip-a66t 441320 660046 2019-12-03 2019-06-30 25           25               25
2555 LAWRENCE MEMORIAL HOSPITAL 1309 WEST MAIN STREET WALNUT RIDGE AR 72476 LAWRENCE (870) 886-1200 Critical Access Hospitals Government - Local TRUE 36.0747010 -90.9669820 0   75 5 5075         https://data.medicare.gov/resource/xubh-q36u/row-jpmn_3ec8~urk8 41309 661136 2019-12-03 2019-06-30 25           25               25
2636 PRESTON MEMORIAL HOSPITAL 150 MEMORIAL DRIVE KINGWOOD WV 26537 PRESTON (304) 329-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4656410 -79.6763980 0   77 54 54077 34060 Morgantown-Fairmont, WV Outlying Preston County https://data.medicare.gov/resource/xubh-q36u/row-6xzk~kxqz_ca3u 511312 661674 2019-12-03 2019-06-30 25           25               25
2993 ST VINCENT DUNN HOSPITAL INC 1600 23RD ST BEDFORD IN 47421 LAWRENCE (812) 276-1065 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8534880 -86.4931940 0   93 18 18093 13260 Bloomington-Bedford, IN Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-i3na-nck9_frex 151335 661320 2019-12-03 2019-06-30 25           25               25
3806 MITCHELL COUNTY REGIONAL HEALTH 616 NORTH EIGHTH STREET OSAGE IA 50461 MITCHELL (641) 732-6000 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.2890760 -92.8094820 0   131 19 19131         https://data.medicare.gov/resource/xubh-q36u/row-vd49.a3jn-dt4a 161323 661180 2019-12-03 2019-06-30 25           25               25
3809 MARY BRECKINRIDGE ARH HOSPITAL 130 KATE IRELAND DRIVE HYDEN KY 41749 LESLIE (606) 672-2901 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1638890 -83.3783600 0   131 21 21131         https://data.medicare.gov/resource/xubh-q36u/row-ms82.xh5f.a6zw 181316 661511 2019-12-03 2019-06-30 25           25               25
3825 ST MARY'S GOOD SAMARITAN HOSPITAL 5401 LAKE OCONEE PARKWAY GREENSBORO GA 30642 GREENE (706) 453-7331 Critical Access Hospitals Proprietary TRUE 33.4799210 -83.2416450 0   133 13 13133         https://data.medicare.gov/resource/xubh-q36u/row-bqbp~uisy-u894 111329 660372 2019-12-03 2019-06-30 25           25               25
4014 FLOYD VALLEY HEALTHCARE 714 LINCOLN ST NE LE MARS IA 51031 PLYMOUTH (712) 546-7871 Critical Access Hospitals Proprietary TRUE 42.7972800 -96.1559900 0   149 19 19149 43580 Sioux City-Vermillion, IA-SD-NE Outlying Plymouth County https://data.medicare.gov/resource/xubh-q36u/row-dyg7.rs5y.hwrt 161368 661183 2019-12-03 2019-06-30 25           25               25
4104 TRINITY HOSPITAL TWIN CITY 819 NORTH FIRST STREET DENNISON OH 44621 TUSCARAWAS (740) 922-2800 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.4014640 -81.3358740 0   157 39 39157 35420 Cleveland-Akron-Canton, OH Central Tuscarawas County https://data.medicare.gov/resource/xubh-q36u/row-yjye.hnn5~27ky 361302 661614 2019-12-03 2019-06-30 25           25               25
4207 ST FRANCIS MEDICAL CENTER 2400 ST FRANCIS DRIVE BRECKENRIDGE MN 56520 WILKIN (218) 643-3000 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.2913140 -96.5904330 0   167 27 27167 47420 Fargo-Wahpeton, ND-MN Outlying Wilkin County https://data.medicare.gov/resource/xubh-q36u/row-z674~sdts.8mhw 241377 661740 2019-12-03 2019-06-30 25           25       80       105
4231 SCOTT COUNTY HOSPITAL 201 ALBERT AVENUE SCOTT CITY KS 67871 SCOTT (620) 872-5811 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.4848700 -100.9035000 0   171 20 20171         https://data.medicare.gov/resource/xubh-q36u/row-3s9g-yvmr~yjua 171372 661186 2019-12-03 2019-06-30 25           25               25
4245 ST VINCENT WARRICK 1116 MILLIS AVE BOONVILLE IN 47601 WARRICK (812) 897-4800 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.0413560 -87.2633740 0   173 18 18173 21780   Central Warrick County https://data.medicare.gov/resource/xubh-q36u/row-7qwf.qysm-8pah 151325 661170 2019-12-03 2019-06-30 25           25 10             35
4266 MORGAN COUNTY ARH HOSPITAL 476 LIBERTY ROAD WEST LIBERTY KY 41472 MORGAN (606) 743-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9201370 -83.2662760 0   175 21 21175         https://data.medicare.gov/resource/xubh-q36u/row-aia2-xvbh~gtxt 181307 662531 2019-12-03 2019-06-30 25           25               25
4010 CHAMBERS MEMORIAL HOSPITAL 719 DETROIT STREET DANVILLE AR 72833 YELL (479) 495-2241 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0548230 -93.3885430 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-d59r_eigs_n4bw 40011 660743 2019-12-03 2019-06-30 30           30 12             42
1848 MISSISSIPPI METHODIST REHAB CTR 1350 E WOODROW WILSON DR JACKSON MS 39216 HINDS (601) 981-2611 Acute Care Hospitals Voluntary non-profit - Private FALSE 32.3268300 -90.1721800 0   49 28 28049 27140 Jackson-Vicksburg-Brookhaven, MS Central Hinds County https://data.medicare.gov/resource/xubh-q36u/row-msuq_x57k.afv9 250152 659986 2019-12-03 2019-06-30 31           31   93       60   184
4318 WEST TENNESSEE HEALTHCARE VOLUNTEER HOSPITAL 161 MOUNT PELIA RD MARTIN TN 38237 WEAKLEY (731) 479-6057 Acute Care Hospitals Proprietary TRUE 36.3335690 -88.8690220 0   183 47 47183 32280 Martin-Union City, TN-KY Central Weakley County https://data.medicare.gov/resource/xubh-q36u/row-iygg-58mk_mp93 440061 661653 2019-12-03 2019-06-30 32 6         38               38
2568 SOUTHWELL MEDICAL, A CAMPUS OF TRMC 260 MJ TAYLOR ROAD ADEL GA 31620 COOK (229) 896-8077 Acute Care Hospitals Proprietary TRUE 31.1091810 -83.4263720 0   75 13 13075         https://data.medicare.gov/resource/xubh-q36u/row-9kgg_7cj7~n9m2 110101 660504 2019-12-03 2019-06-30 33           33 12     95       140
1729 TANNER MEDICAL CENTER VILLA RICA 601 DALLAS HIGHWAY VILLA RICA GA 30180 CARROLL (770) 456-3101 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7429920 -84.9194770 0   45 13 13045 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Carroll County https://data.medicare.gov/resource/xubh-q36u/row-r7tm_8s6b-q394 110015 660366 2019-12-03 2019-06-30 34 6         40 92             132
2060 GRAHAM HOSPITAL ASSOCIATION 210 WEST WALNUT STREET CANTON IL 61520 FULTON (309) 647-5240 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5532930 -90.0381150 0   57 17 17057 15900 Peoria-Canton, IL Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-xkp5.fehw.8cwr 140001 661308 2019-12-03 2019-06-30 38 5         43       20 18     81
1400 GERALD CHAMPION REGIONAL MEDICAL CENTER 2669 NORTH SCENIC DRIVE ALAMOGORDO NM 88310 OTERO (575) 443-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9268620 -105.9339170 0   35 35 35035 10460   Central Otero County https://data.medicare.gov/resource/xubh-q36u/row-jeb6-3eqs_s323 320004 659992 2019-12-03 2019-06-30 40 10         50 36 12           98
4682 VAL VERDE REGIONAL MEDICAL CENTER 801 BEDELL AVE DEL RIO TX 78840 VAL VERDE (830) 775-8566 Acute Care Hospitals Proprietary TRUE 29.3744250 -100.8930340 0   465 48 48465 19620   Central Val Verde County https://data.medicare.gov/resource/xubh-q36u/row-vvbk~jkwv.nw4c 450154 660322 2019-12-03 2019-06-30 40 7         47           1   48
644 CONEMAUGH NASON MEDICAL CENTER 105 NASON DRIVE ROARING SPRING PA 16673 BLAIR (814) 224-2141 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3380670 -78.3889450 0   13 42 42013 11020   Central Blair County https://data.medicare.gov/resource/xubh-q36u/row-q5b2-s4qk-jc5a 390062 660015 2019-12-03 2019-06-30 41 4         45               45
1782 ATLANTIC GENERAL HOSPITAL 9733 HEALTHWAY DRIVE BERLIN MD 21811 WORCESTER (410) 641-9600 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3386040 -75.2104720 0   47 24 24047 41540   Outlying Worcester County https://data.medicare.gov/resource/xubh-q36u/row-kz7f~bne7-xch9 210061 660098 2019-12-03 2019-06-30 42 6         48               48
140 SAN LUIS VALLEY HEALTH 106 BLANCA AVE ALAMOSA CO 81101 ALAMOSA (719) 589-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4723600 -105.8837120 0   3 8 8003         https://data.medicare.gov/resource/xubh-q36u/row-bztx~k7ma~ri7p 60008 661701 2019-12-03 2019-06-30 43 6         49               49
593 LONGS PEAK HOSPITAL 1750 EAST KEN PRATT BOULEVARD LONGMONT CO 80504 BOULDER (720) 718-3005 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1621720 -105.0581160 1 ROOFTOP 13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-i5b6~xwcd-bndp 60128 661294 2019-12-03 2019-06-30 44 6         50               50
1975 MILAN GENERAL HOSPITAL 4039 HIGHLAND ST MILAN TN 38358 GIBSON (731) 686-1591 Acute Care Hospitals Government - Local TRUE 35.9133110 -88.7534950 0   53 47 47053         https://data.medicare.gov/resource/xubh-q36u/row-b2mu-x63s-nuvr 440060 660042 2019-12-03 2019-06-30 44 3         47               47
4361 COVENANT HOSPITAL PLAINVIEW 2601 DIMMITT RD PLAINVIEW TX 79072 HALE (806) 296-5531 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2072140 -101.7316260 0   189 48 48189 38380   Central Hale County https://data.medicare.gov/resource/xubh-q36u/row-3bv3~8kd2-nnfr 450539 661663 2019-12-03 2019-06-30 44 5         49               49
3305 ELBERT MEMORIAL HOSPITAL 4 MEDICAL DRIVE ELBERTON GA 30635 ELBERT (706) 213-2535 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1130680 -82.8756010 0   105 13 13105         https://data.medicare.gov/resource/xubh-q36u/row-qihd.4t9x~yppv 110026 660503 2019-12-03 2019-06-30 48 4         52               52
3587 ST MARY'S SACRED HEART HOSPITAL, INC 367 CLEAR CREEK PARKWAY LAVONIA GA 30553 FRANKLIN (706) 356-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.4394850 -83.1308550 0   119 13 13119         https://data.medicare.gov/resource/xubh-q36u/row-tqnr-ai73~p7se 110027 660367 2019-12-03 2019-06-30 48 8         56               56
4483 COVENANT HOSPITAL LEVELLAND 1900 COLLEGE AVE LEVELLAND TX 79336 HOCKLEY (806) 894-4963 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5732730 -102.3677550 0   219 48 48219 30220 Lubbock-Levelland, TX Central Hockley County https://data.medicare.gov/resource/xubh-q36u/row-n4is.u6n3_9my2 450755 660473 2019-12-03 2019-06-30 48           48               48
2966 EAGLEVILLE HOSPITAL 100 EAGLEVILLE RD EAGLEVILLE PA 19408 MONTGOMERY (215) 539-6000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.1558800 -75.4119200 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-zvfs.t6e9.gp6r 390278 660447 2019-12-03 2019-06-30 49           49 34             83
2466 NEW ORLEANS EAST HOSPITAL 5620 READ BLVD NEW ORLEANS LA 70127 ORLEANS (504) 592-6600 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.0307380 -89.9715830 0   71 22 22071 35380 New Orleans-Metairie-Hammond, LA-MS Central Orleans Parish https://data.medicare.gov/resource/xubh-q36u/row-n3g7_ie2c.v7eh 190313 662208 2019-12-03 2019-06-30 50           50               50
296 CHESHIRE MEDICAL CENTER 580 COURT STREET KEENE NH 3431 CHESHIRE (603) 354-5400 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9498540 -72.2907250 0   5 33 33005 28300   Central Cheshire County https://data.medicare.gov/resource/xubh-q36u/row-xyq5~7j27.ews5 300019 661742 2019-12-03 2019-06-30 59 27         86   24           110
132 IVINSON MEMORIAL HOSPITAL 255 N 30TH LARAMIE WY 82072 ALBANY (307) 755-4600 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.3113900 -105.5575120 0   1 56 56001 29660   Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-ptq5-c827_j29e 530025 660342 2019-12-03 2019-06-30 62 4         66 10     10       86
3999 ASCENSION RIVER DISTRICT HOSPITAL 4100 RIVER RD EAST CHINA MI 48054 ST. CLAIR (810) 329-7111 Acute Care Hospitals Government - Hospital District or Authority FALSE 42.7865050 -82.4782080 0   147 26 26147 19820 Detroit-Warren-Ann Arbor, MI Outlying St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-kcai_xx52-e2uf 230241 661538 2019-12-03 2019-06-30 62 3         65               65
2079 LEXINGTON MEMORIAL HOSPITAL INC 250 HOSPITAL DRIVE PO BOX 1817 LEXINGTON NC 27293 DAVIDSON (336) 248-5161 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8027540 -80.2872240 0   57 37 37057 49180 Greensboro--Winston-Salem--High Point, NC Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-ndpr~q5bq~7gpt 340096 661576 2019-12-03 2019-06-30 64 16         80               80
2534 OCHSNER LSU HEALTH MONROE 4864 JACKSON STREET MONROE LA 71202 OUACHITA (318) 330-7000 Acute Care Hospitals Proprietary TRUE 32.4514640 -92.1055480 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-3rna_5eu4.fbeq 190011 660999 2019-12-03 2019-06-30 68 12         93 26             119
4422 ST LUKE'S HOSPITAL AT THE VINTAGE 20171 CHASEWOOD PARK DRIVE HOUSTON TX 77070 HARRIS (832) 534-5000 Acute Care Hospitals Proprietary TRUE 29.9894890 -95.5702480 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-68e3-j3wm_u7j8 670075 661132 2019-12-03 2019-06-30 70 12         86               86
489 BROWARD HEALTH IMPERIAL POINT 6401 N FEDERAL HWY FORT LAUDERDALE FL 33308 BROWARD (954) 776-8500 Acute Care Hospitals Government - Hospital District or Authority FALSE 26.2068810 -80.1080570 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-bdjf.gjbn-c4jh 100200 661482 2019-12-03 2019-06-30 72 10         129 45             174
3414 ST JOHNS PLEASANT VALLEY HOSPITAL 2309 ANTONIO AVE CAMARILLO CA 93010 VENTURA (805) 389-5800 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2429650 -119.0183060 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-t2cn.wci4_rvdy 50616 662168 2019-12-03 2019-06-30 73 8         81       74       155
3694 WARREN GENERAL HOSPITAL TWO CRESCENT PARK WEST WARREN PA 16365 WARREN (814) 723-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8431152 -79.1555220 1 ROOFTOP 123 42 42123 47620   Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-cza6_xsbu-7xn7 390146 660444 2019-12-03 2019-06-30 79 6         85               85
3829 WHITESBURG ARH HOSPITAL 240 HOSPITAL ROAD WHITESBURG KY 41858 LETCHER (606) 633-3500 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.1118200 -82.8136120 0   133 21 21133         https://data.medicare.gov/resource/xubh-q36u/row-pqne.4qjx-j597 180002 662525 2019-12-03 2019-06-30 84 6         90               90
2556 ST MARY'S MEDICAL CENTER 450 STANYAN ST SAN FRANCISCO CA 94117 SAN FRANCISCO (415) 668-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7738400 -122.4544950 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-icvs_wkwy~esyb 50457 661289 2019-12-03 2019-06-30 94 19         113 22 24           159
1327 LANE REGIONAL MEDICAL CENTER 6300 MAIN STREET ZACHARY LA 70791 E. BATON ROUGE (225) 658-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.6499570 -91.1367470 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-6rne~rwgc-e8xv 190020 659955 2019-12-03 2019-06-30 95 8       2 113   30   39       182
1765 WEST TENNESSEE HEALTHCARE DYERSBURG HOSPITAL 400 EAST TICKLE STREET DYERSBURG TN 38024 DYER (731) 285-2410 Acute Care Hospitals Proprietary TRUE 36.0473580 -89.3805900 0   45 47 47045 20540   Central Dyer County https://data.medicare.gov/resource/xubh-q36u/row-rkhu_ciht-shk2 440072 661654 2019-12-03 2019-06-30 95 14         109               109
2133 ST MARY'S HOSPITAL 1230 BAXTER STREET ATHENS GA 30606 CLARKE (706) 389-3930 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9459290 -83.4044670 0   59 13 13059 12020 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Clarke County https://data.medicare.gov/resource/xubh-q36u/row-sxr7_vrrg_xb9c 110006 660364 2019-12-03 2019-06-30 97 68         165   20       83   268
3051 TRUMAN MEDICAL CENTER LAKEWOOD 7900 LEE'S SUMMIT RD KANSAS CITY MO 64139 JACKSON (816) 404-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9735830 -94.3904070 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xhfv_9j22.vn6f 260102 661352 2019-12-03 2019-06-30 97 8         110       188       298
308 NORTH CENTRAL BRONX HOSPITAL 3424 KOSSUTH AVENUE & 210TH STREET BRONX NY 10467 BRONX (212) 519-5000 Acute Care Hospitals Government - Local TRUE 40.8804709 -73.8811305 1 RANGE_INTERPOLATED 5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-kzjb-7xtm_jntx 330385 661753 2019-12-03 2019-06-30 98 20       12 130 70             200
2339 MERCY HOSPITAL OF FOLSOM 1650 CREEKSIDE DRIVE FOLSOM CA 95630 SACRAMENTO (916) 983-7400 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6711250 -121.1458330 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-uh5k-64gy~w35r 50414 662163 2019-12-03 2019-06-30 98 8         106               106
2998 ASCENSION BRIGHTON CENTER FOR RECOVERY 12851 GRAND RIVER RD BRIGHTON MI 48116 LIVINGSTON (810) 227-1211 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.5176600 -83.6945230 0   93 26 26093 19820 Detroit-Warren-Ann Arbor, MI Outlying Livingston County https://data.medicare.gov/resource/xubh-q36u/row-qf5d-9hbt_ivvy 230279 661539 2019-12-03 2019-06-30 99           99               99
2047 SIERRA NEVADA MEMORIAL HOSPITAL 155 GLASSON WAY GRASS VALLEY CA 95945 NEVADA (530) 274-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.2289490 -121.0472640 0   57 6 6057 46020 Sacramento-Roseville, CA Central Nevada County https://data.medicare.gov/resource/xubh-q36u/row-tqcx-33m6.phqg 50150 662470 2019-12-03 2019-06-30 100 4         104               104
267 BAYHEALTH HOSPITAL, SUSSEX CAMPUS 100 WELLNESS WAY MILFORD DE 19963 SUSSEX (302) 422-3311 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8868357 -75.3911438 1 ROOFTOP 5 10 10005 41540   Central Sussex County https://data.medicare.gov/resource/xubh-q36u/row-pqau~nrba-tybq 80009 661150 2019-12-03 2019-06-30 105 9         114   42           156
199 SAINT ROSE DOMINICAN HOSPITALS - SAN MARTIN CAMPUS 8280 W WARM SPRINGS ROAD LAS VEGAS NV 89113 CLARK (702) 492-8509 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.0555450 -115.2713230 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-sdqu.kd85~4dy8 290053 662224 2019-12-03 2019-06-30 106 24         136               136
1240 LOYOLA GOTTLIEB MEMORIAL HOSPITAL 701 WEST NORTH AVE MELROSE PARK IL 60160 COOK (708) 681-3200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9083420 -87.8411010 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-f9em_zs87~xp9w 140008 662196 2019-12-03 2019-06-30 109 16         125 12 20   34       191
3254 JOHNS HOPKINS ALL CHILDREN'S HOSPITAL 501 SIXTH AVENUE SOUTH SAINT PETERSBURG FL 33701 PINELLAS (813) 898-7451 Childrens Voluntary non-profit - Other TRUE 27.7642490 -82.6410120 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-rxaq~253f.593c 103300 661485 2019-12-03 2019-06-30 112 28 22     97 259               259
4152 HSHS ST ELIZABETH'S HOSPITAL ONE ST ELIZABETH BOULEVARD O FALLON IL 62269 ST. CLAIR (618) 234-2120 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.5836880 -89.9322498 1 ROOFTOP 163 17 17163 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-pfxz-kai8~phvk 140187 661498 2019-12-03 2019-06-30 112 16         128   16           144
2560 SAINT FRANCIS MEMORIAL HOSPITAL 900 HYDE ST SAN FRANCISCO CA 94109 SAN FRANCISCO (415) 353-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7895610 -122.4171120 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-qjay~rve8~yys3 50152 662020 2019-12-03 2019-06-30 122 18   16     156 35 20           211
2813 METHODIST RICHARDSON MEDICAL CENTER 2831 E PRESIDENT GEORGE BUSH HIGHWAY RICHARDSON TX 75082 COLLIN (469) 204-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9961430 -96.6691760 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-stfg-vvxf_2h9k 450537 660472 2019-12-03 2019-06-30 125 25         172 51             223
2972 LANSDALE HOSPITAL 100 MEDICAL CAMPUS DRIVE LANSDALE PA 19446 MONTGOMERY (215) 368-2100 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.2512000 -75.2715230 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-47ck-pm39.hwef 390012 660851 2019-12-03 2019-06-30 126 14         140               140
497 BROWARD HEALTH CORAL SPRINGS 3000 CORAL HILLS DR CORAL SPRINGS FL 33065 BROWARD (954) 344-3000 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.2687790 -80.2541610 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-8hk9~vqe6-vica 100276 662357 2019-12-03 2019-06-30 130 16 35       196               196
4314 DUKE HEALTH RALEIGH HOSPITAL 3400 WAKE FOREST RD RALEIGH NC 27609 WAKE (919) 954-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8289980 -78.6195490 0   183 37 37183 39580 Raleigh-Durham-Chapel Hill, NC Central Wake County https://data.medicare.gov/resource/xubh-q36u/row-9wbx_2nwt_jp4q 340073 661575 2019-12-03 2019-06-30 133 42         175               175
779 WEST CHESTER HOSPITAL, LLC 7700 UNIVERSITY DRIVE WEST CHESTER OH 45069 BUTLER (513) 298-7700 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3582480 -84.3671700 0   17 39 39017 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-zbwb-99pw~8xag 360354 661612 2019-12-03 2019-06-30 135 18         153               153
1730 TANNER MEDICAL CENTER - CARROLLTON 705 DIXIE STREET CARROLLTON GA 30117 CARROLL (770) 836-9580 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5705550 -85.0724640 0   45 13 13045 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Carroll County https://data.medicare.gov/resource/xubh-q36u/row-7yah~3pv6~c65g 110011 660365 2019-12-03 2019-06-30 135 12   10     157               157
4561 COVENANT CHILDRENS HOSPITAL 4015 22ND PLACE LUBBOCK TX 79410 LUBBOCK (806) 725-7975 Childrens Voluntary non-profit - Private TRUE 33.5741410 -101.9004260 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-a699~c7jg~uc7g 453306 660895 2019-12-03 2019-06-30 138 20       46 204               204
705 CHI ST ALEXIUS HEALTH 900 E BROADWAY BISMARCK ND 58501 BURLEIGH (701) 530-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.8063690 -100.7770750 0   15 38 38015 13900   Central Burleigh County https://data.medicare.gov/resource/xubh-q36u/row-i4ue-xmjd.qmkx 350002 662065 2019-12-03 2019-06-30 142 39         181 25     19       225
1237 THOREK MEMORIAL HOSPITAL 850 W IRVING PARK RD CHICAGO IL 60613 COOK (312) 525-6780 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9545560 -87.6508990 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-5qet-q6ur~zveq 140115 661719 2019-12-03 2019-06-30 146 10         156               156
2719 TRINITY MEDICAL CTR EAST &TRINITY MEDICAL CTR WEST 380 SUMMIT AVENUE STEUBENVILLE OH 43952 JEFFERSON (740) 283-7000 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.3562240 -80.6251030 0   81 39 39081 48260 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-cspg~w9hw.v43j 360211 661610 2019-12-03 2019-06-30 151 12     8   171 20 20   50       261
4054 IOWA LUTHERAN HOSPITAL 700 EAST UNIVERSITY AVENUE DES MOINES IA 50316 POLK (515) 263-5612 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6003930 -93.6107560 0   153 19 19153 19780 Des Moines-Ames-West Des Moines, IA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-5ngf-z47j-y8jb 160024 661322 2019-12-03 2019-06-30 151 10         161 12     16       189

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