hospital_data
Data source: Big Local News · About: big-local-datasette
40 rows where "filed_date" is on date 2019-12-03 and hospital_type = "Critical Access Hospitals"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, all_beds, filed_date (date), fy_end_date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
319 | 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 | 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 | 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 | 436 | BUNKIE GENERAL HOSPITAL | 427 EVERGREEN STREET | BUNKIE | LA | 71322 | AVOYELLES | (318) 346-6681 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 30.9524260 | -92.1766470 | 0 | 9 | 22 | 22009 | https://data.medicare.gov/resource/xubh-q36u/row-56d9~jh8q~59bh | 191311 | 662210 | 2019-12-03 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
451 | 451 | ALICE PECK DAY MEMORIAL HOSPITAL | 10 ALICE PECK DAY DRIVE | LEBANON | NH | 3766 | GRAFTON | (603) 448-3121 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 43.6402930 | -72.2643660 | 0 | 9 | 33 | 33009 | 17200 | Central | Grafton County | https://data.medicare.gov/resource/xubh-q36u/row-t8xb_fse9~ukfj | 301305 | 661743 | 2019-12-03 | 2019-06-30 | 24 | 24 | 24 | ||||||||||||||
474 | 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 | 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 | ||||||||||||||
872 | 872 | JOHNSON COUNTY HEALTHCARE CENTER | 497 WEST LOTT | BUFFALO | WY | 82834 | JOHNSON | (307) 684-5521 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 44.3497880 | -106.7072480 | 0 | 19 | 56 | 56019 | https://data.medicare.gov/resource/xubh-q36u/row-jfvm_9yjt_xtnf | 531308 | 662298 | 2019-12-03 | 2019-06-30 | 22 | 22 | 3 | 69 | ||||||||||||||||
883 | 883 | GLENN MEDICAL CENTER | 1133 W SYCAMORE ST | WILLOWS | CA | 95988 | GLENN | (530) 934-1818 | Critical Access Hospitals | Government - Federal | TRUE | 39.5204670 | -122.2081200 | 0 | 21 | 6 | 6021 | https://data.medicare.gov/resource/xubh-q36u/row-7nst_26uq.zcvx | 51306 | 662484 | 2019-12-03 | 2019-06-30 | 15 | 15 | 15 | |||||||||||||||||
884 | 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 | |||||||||||||||||
1349 | 1349 | GALION COMMUNITY HOSPITAL | 269 PORTLAND WAY SOUTH | GALION | OH | 44833 | CRAWFORD | (419) 468-4841 | Critical Access Hospitals | Voluntary non-profit - Church | FALSE | 40.7311430 | -82.8032960 | 0 | 33 | 39 | 39033 | 15340 | Mansfield-Ashland-Bucyrus, OH | Central | Crawford County | https://data.medicare.gov/resource/xubh-q36u/row-5krw_yxr7-22n8 | 361325 | 661619 | 2019-12-03 | 2019-06-30 | 22 | 3 | 25 | 10 | 35 | |||||||||||
1350 | 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 | ||||||||||||
1645 | 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 | |||||||||||||||||
2086 | 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 | ||||||||||||||||
2268 | 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 | 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 | |||||||||||||||
2381 | 2381 | SUMMERSVILLE REGIONAL MEDICAL CENTER | 400 FAIRVIEW HEIGHTS ROAD | SUMMERSVILLE | WV | 26651 | NICHOLAS | (304) 872-2891 | Critical Access Hospitals | Government - Local | TRUE | 38.2919030 | -80.8311360 | 0 | 67 | 54 | 54067 | https://data.medicare.gov/resource/xubh-q36u/row-a2eh.63jr_sfyc | 511322 | 661675 | 2019-12-03 | 2019-06-30 | 19 | 6 | 25 | 52 | 77 | |||||||||||||||
2415 | 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 | 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 | 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 | |||||||||||||
2658 | 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 | 2989 | MERCY MEDICAL CENTER MT SHASTA | 914 PINE STREET | MOUNT SHASTA | CA | 96067 | SISKIYOU | (530) 926-6111 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 41.3177640 | -122.3215540 | 0 | 93 | 6 | 6093 | https://data.medicare.gov/resource/xubh-q36u/row-z3p6.8j4z_mz6s | 51319 | 662174 | 2019-12-03 | 2019-06-30 | 21 | 4 | 25 | 25 | ||||||||||||||||
2993 | 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 | |||||||||||||
3173 | 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 | |||||||||||||||||
3273 | 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 | |||||||||||||
3450 | 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 | |||||||||||||
3751 | 3751 | MERCY HEALTH LAKESHORE CAMPUS | 72 SOUTH STATE STREET | SHELBY | MI | 49455 | OCEANA | (231) 861-2156 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 43.6070530 | -86.3651500 | 0 | 127 | 26 | 26127 | https://data.medicare.gov/resource/xubh-q36u/row-4je3~28uk~h2y8 | 231320 | 661203 | 2019-12-03 | 2019-06-30 | 24 | 24 | 24 | |||||||||||||||||
3797 | 3797 | KETCHIKAN MEDICAL CENTER | 3100 TONGASS AVENUE | KETCHIKAN | AK | 99901 | KETCHIKAN GATEWAY | (907) 225-5171 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 55.3527170 | -131.6860490 | 0 | 130 | 2 | 2130 | 28540 | Central | Ketchikan Gateway Borough | https://data.medicare.gov/resource/xubh-q36u/row-qt33-ugsf~ggm9 | 21311 | 661277 | 2019-12-03 | 2019-06-30 | 21 | 4 | 25 | 29 | 54 | ||||||||||||
3806 | 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 | 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 | 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 | |||||||||||||||||
3965 | 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 | ||||||||||||
4014 | 4014 | FLOYD VALLEY HEALTHCARE | 714 LINCOLN ST NE | LE MARS | IA | 51031 | PLYMOUTH | (712) 546-7871 | Critical Access Hospitals | Proprietary | TRUE | 42.7972800 | -96.1559900 | 0 | 149 | 19 | 19149 | 43580 | Sioux City-Vermillion, IA-SD-NE | Outlying | Plymouth County | https://data.medicare.gov/resource/xubh-q36u/row-dyg7.rs5y.hwrt | 161368 | 661183 | 2019-12-03 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||
4024 | 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 | 4099 | ST ELIZABETH MEDICAL CENTER | 1200 GRANT BLVD W | WABASHA | MN | 55981 | WABASHA | (651) 565-4531 | Critical Access Hospitals | Proprietary | TRUE | 44.3864160 | -92.0491400 | 0 | 157 | 27 | 27157 | 40340 | Rochester-Austin, MN | Outlying | Wabasha County | https://data.medicare.gov/resource/xubh-q36u/row-diq7.k9ja_4m53 | 241335 | 661737 | 2019-12-03 | 2019-06-30 | 14 | 14 | 100 | 114 | ||||||||||||
4104 | 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 | 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 | 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 | 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 | 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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );