hospital_data
Data source: Big Local News · About: big-local-datasette
37 rows where "filed_date" is on date 2019-12-02 and hospital_ownership = "Voluntary non-profit - Church"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, icu_beds, coronary_beds, surg_icu_beds, oth_spec_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
119 | 119 | SAINT ALPHONSUS MEDICAL CENTER - BAKER CITY, INC | 3325 POCAHONTAS ROAD | BAKER CITY | OR | 97814 | BAKER | (541) 524-7744 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 44.7961200 | -117.8462850 | 0 | 1 | 41 | 41001 | https://data.medicare.gov/resource/xubh-q36u/row-yt65-wbpr_7cai | 381315 | 661086 | 2019-12-02 | 2019-06-30 | 19 | 2 | 21 | 21 | ||||||||||||||||
814 | 814 | SAINT AGNES MEDICAL CENTER | 1303 E HERNDON AVE | FRESNO | CA | 93710 | FRESNO | (559) 450-3000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 36.8371020 | -119.7658780 | 0 | 19 | 6 | 6019 | 23420 | Fresno-Madera, CA | Central | Fresno County | https://data.medicare.gov/resource/xubh-q36u/row-m6yb~w6hh~ku8s | 50093 | 662016 | 2019-12-02 | 2019-06-30 | 345 | 27 | 13 | 385 | 385 | |||||||||||
843 | 843 | CHI HEALTH GOOD SAMARITAN | P O BOX 1990, 10 EAST 31ST ST | KEARNEY | NE | 68848 | BUFFALO | (308) 865-7100 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 40.7076254 | -99.0818136 | 1 | ROOFTOP | 19 | 31 | 31019 | 28260 | Central | Buffalo County | https://data.medicare.gov/resource/xubh-q36u/row-k4e3_xakc.p7ct | 280009 | 661546 | 2019-12-02 | 2019-06-30 | 201 | 16 | 10 | 227 | 12 | 239 | ||||||||||
1066 | 1066 | SAINT ALPHONSUS MEDICAL CENTER - NAMPA | 4300 E FLAMINGO AVE | NAMPA | ID | 83687 | CANYON | (208) 205-0050 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 43.5963320 | -116.5191740 | 0 | 27 | 16 | 16027 | 14260 | Boise City-Mountain Home-Ontario, ID-OR | Outlying | Canyon County | https://data.medicare.gov/resource/xubh-q36u/row-ei4u.dihn_gvat | 130013 | 660927 | 2019-12-02 | 2019-06-30 | 74 | 18 | 4 | 96 | 96 | |||||||||||
1068 | 1068 | ST JOSEPHS HOSPITAL | 9515 HOLY CROSS LN | BREESE | IL | 62230 | CLINTON | (618) 526-4511 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 38.6251540 | -89.5249440 | 0 | 27 | 17 | 17027 | 41180 | St. Louis-St. Charles-Farmington, MO-IL | Outlying | Clinton County | https://data.medicare.gov/resource/xubh-q36u/row-pzsx~2awp~chq9 | 140145 | 662043 | 2019-12-02 | 2019-06-30 | 46 | 46 | 46 | |||||||||||||
1122 | 1122 | CHI ST VINCENT MORRILTON | #4 HOSPITAL DRIVE | MORRILTON | AR | 72110 | CONWAY | (501) 977-2300 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 35.1699700 | -92.7217020 | 0 | 29 | 5 | 5029 | https://data.medicare.gov/resource/xubh-q36u/row-jajp~f47n.nife | 41324 | 660162 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
1243 | 1243 | PRESENCE RESURRECTION MEDICAL CENTER | 7435 W TALCOTT AVENUE | CHICAGO | IL | 60631 | COOK | (773) 774-8000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 41.9884580 | -87.8125700 | 0 | 31 | 17 | 17031 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Cook County | https://data.medicare.gov/resource/xubh-q36u/row-pehm~qnk2_vxey | 140117 | 662042 | 2019-12-02 | 2019-06-30 | 186 | 41 | 227 | 47 | 274 | |||||||||||
1244 | 1244 | PRESENCE SAINT FRANCIS HOSPITAL | 355 RIDGE AVE | EVANSTON | IL | 60202 | COOK | (847) 316-4000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 42.0239510 | -87.6851590 | 0 | 31 | 17 | 17031 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Cook County | https://data.medicare.gov/resource/xubh-q36u/row-ytv8~95dy~j47j | 140080 | 662040 | 2019-12-02 | 2019-06-30 | 155 | 16 | 181 | 181 | ||||||||||||
1245 | 1245 | PRESENCE SAINT JOSEPH HOSPITAL - CHICAGO | 2900 NORTH LAKE SHORE DRIVE | CHICAGO | IL | 60657 | COOK | (773) 665-3000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 41.9339280 | -87.6364180 | 0 | 31 | 17 | 17031 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Cook County | https://data.medicare.gov/resource/xubh-q36u/row-5jgf-ct8j~vsky | 140224 | 661871 | 2019-12-02 | 2019-06-30 | 258 | 19 | 277 | 10 | 26 | 313 | ||||||||||
1246 | 1246 | PRESENCE SAINTS MARY AND ELIZABETH MEDICAL CENTER | 2233 W DIVISION ST | CHICAGO | IL | 60622 | COOK | (312) 770-2000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 41.9031040 | -87.6832130 | 0 | 31 | 17 | 17031 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Cook County | https://data.medicare.gov/resource/xubh-q36u/row-zjn9~e8qn.h99n | 140180 | 661868 | 2019-12-02 | 2019-06-30 | 344 | 26 | 370 | 14 | 15 | 30 | 429 | |||||||||
1274 | 1274 | HOLY CROSS HOSPITAL | 1500 FOREST GLEN ROAD | SILVER SPRING | MD | 20910 | MONTGOMERY | (301) 754-7000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 39.0160550 | -77.0341980 | 0 | 31 | 24 | 24031 | 47900 | Washington-Baltimore-Arlington, DC-MD-VA-WV-PA | Central | Montgomery County | https://data.medicare.gov/resource/xubh-q36u/row-nztz.3ybb.dqym | 210004 | 659967 | 2019-12-02 | 2019-06-30 | 349 | 46 | 46 | 441 | 441 | |||||||||||
1324 | 1324 | OUR LADY OF THE LAKE REGIONAL MEDICAL CENTER | 5000 HENNESSY BLVD | BATON ROUGE | LA | 70808 | E. BATON ROUGE | (225) 765-6565 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 30.4013180 | -91.1115280 | 0 | 33 | 22 | 22033 | 12940 | Central | East Baton Rouge Parish | https://data.medicare.gov/resource/xubh-q36u/row-fxjt_dffw~6nnz | 190064 | 661187 | 2019-12-02 | 2019-06-30 | 660 | 43 | 24 | 773 | 70 | 33 | 876 | ||||||||||
1537 | 1537 | MEMORIAL HOSPITAL AND HEALTH CARE CENTER | 800 W 9TH ST | JASPER | IN | 47546 | DUBOIS | (812) 996-2345 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 38.3937430 | -86.9412810 | 0 | 37 | 18 | 18037 | 27540 | Central | Dubois County | https://data.medicare.gov/resource/xubh-q36u/row-znqj_58gv~pyf2 | 150115 | 660942 | 2019-12-02 | 2019-06-30 | 85 | 26 | 111 | 19 | 8 | 14 | 152 | ||||||||||
1608 | 1608 | PEACE HARBOR MEDICAL CENTER | 400 9TH STREET | FLORENCE | OR | 97439 | LANE | (541) 997-8412 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 43.9745890 | -124.1174640 | 0 | 39 | 41 | 41039 | 21660 | Central | Lane County | https://data.medicare.gov/resource/xubh-q36u/row-3bhj~d2nf.qxkv | 381316 | 662244 | 2019-12-02 | 2019-06-30 | 21 | 21 | 21 | ||||||||||||||
1753 | 1753 | SAINT ALPHONSUS MEDICAL CENTER - ONTARIO, INC | 351 SW 9TH STREET | ONTARIO | OR | 97914 | MALHEUR | (541) 881-7000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 44.0254480 | -116.9751330 | 0 | 45 | 41 | 41045 | 36620 | Boise City-Mountain Home-Ontario, ID-OR | Central | Malheur County | https://data.medicare.gov/resource/xubh-q36u/row-pp3w.967e-e52h | 380052 | 661085 | 2019-12-02 | 2019-06-30 | 36 | 8 | 44 | 44 | ||||||||||||
1834 | 1834 | ST ANTHONYS MEMORIAL HOSPITAL | 503 N MAPLE STREET | EFFINGHAM | IL | 62401 | EFFINGHAM | (217) 342-2121 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 39.1244960 | -88.5492740 | 0 | 49 | 17 | 17049 | 20820 | Central | Effingham County | https://data.medicare.gov/resource/xubh-q36u/row-se8h.a4r7-s6mp | 140032 | 661718 | 2019-12-02 | 2019-06-30 | 123 | 10 | 133 | 133 | |||||||||||||
1889 | 1889 | CHI ST. VINCENT HOSPITAL HOT SPRINGS | 300 WERNER STREET | HOT SPRINGS | AR | 71903 | GARLAND | (501) 622-1000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 34.4660350 | -93.0663960 | 0 | 51 | 5 | 5051 | 26300 | Hot Springs-Malvern, AR | Central | Garland County | https://data.medicare.gov/resource/xubh-q36u/row-pyjq_z3nz-ckdj | 40026 | 662146 | 2019-12-02 | 2019-06-30 | 204 | 25 | 229 | 229 | ||||||||||||
2023 | 2023 | CHI HEALTH LAKESIDE | 16901 LAKESIDE HILLS CT | OMAHA | NE | 68130 | DOUGLAS | (402) 717-8167 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 41.2390400 | -96.1805320 | 0 | 55 | 31 | 31055 | 36540 | Omaha-Council Bluffs-Fremont, NE-IA | Central | Douglas County | https://data.medicare.gov/resource/xubh-q36u/row-m36s-dsun.h9q7 | 280130 | 661035 | 2019-12-02 | 2019-06-30 | 92 | 16 | 108 | 108 | ||||||||||||
2643 | 2643 | ST VINCENT JENNINGS HOSPITAL INC | 301 HENRY ST | NORTH VERNON | IN | 47265 | JENNINGS | (812) 352-4200 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 39.0112590 | -85.6403740 | 0 | 79 | 18 | 18079 | 35860 | Indianapolis-Carmel-Muncie, IN | Central | Jennings County | https://data.medicare.gov/resource/xubh-q36u/row-pwb4.5pm6~qqy5 | 151303 | 660947 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||
2653 | 2653 | CHI HEALTH ST FRANCIS | 2620 WEST FAIDLEY AVE | GRAND ISLAND | NE | 68803 | HALL | (308) 384-4600 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 40.9242670 | -98.3708870 | 0 | 79 | 31 | 31079 | 24260 | Central | Hall County | https://data.medicare.gov/resource/xubh-q36u/row-rgs4_gs84~mfkz | 280023 | 661547 | 2019-12-02 | 2019-06-30 | 115 | 16 | 9 | 140 | 12 | 34 | 186 | ||||||||||
2892 | 2892 | PRESENCE SAINT JOSEPH HOSPITAL - ELGIN | 77 N AIRLITE STREET | ELGIN | IL | 60123 | KANE | (847) 695-3200 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 42.0362420 | -88.3279340 | 0 | 89 | 17 | 17089 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Kane County | https://data.medicare.gov/resource/xubh-q36u/row-f78t~a38y-jgzx | 140217 | 661870 | 2019-12-02 | 2019-06-30 | 129 | 15 | 144 | 40 | 184 | |||||||||||
2893 | 2893 | PRESENCE MERCY MEDICAL CENTER | 1325 N HIGHLAND AVENUE | AURORA | IL | 60506 | KANE | (630) 859-2222 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 41.7869060 | -88.3289090 | 0 | 89 | 17 | 17089 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Kane County | https://data.medicare.gov/resource/xubh-q36u/row-hbw3.udek.9cfk | 140174 | 662046 | 2019-12-02 | 2019-06-30 | 172 | 16 | 188 | 68 | 256 | |||||||||||
3038 | 3038 | ST VINCENT MERCY HOSPITAL | 1331 S A ST | ELWOOD | IN | 46036 | MADISON | (765) 552-4743 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 40.2760200 | -85.8440050 | 0 | 95 | 18 | 18095 | 26900 | Indianapolis-Carmel-Muncie, IN | Outlying | Madison County | https://data.medicare.gov/resource/xubh-q36u/row-kkqs-e5m3-4c2r | 151308 | 660949 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||
3324 | 3324 | CHI ST ALEXIUS HEALTH WILLISTON | 1301 15TH AVE W | WILLISTON | ND | 58801 | WILLIAMS | (701) 774-7400 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 48.1543320 | -103.6454370 | 0 | 105 | 38 | 38105 | 48780 | Central | Williams County | https://data.medicare.gov/resource/xubh-q36u/row-2m99~vhsx_qu32 | 351334 | 662569 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | ||||||||||||||
3356 | 3356 | AVERA GETTYSBURG HOSPITAL | 606 EAST GARFIELD | GETTYSBURG | SD | 57442 | POTTER | (605) 765-2480 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 45.0135510 | -99.9481280 | 0 | 107 | 46 | 46107 | https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p | 431302 | 660878 | 2019-12-02 | 2019-06-30 | 10 | 10 | 50 | 60 | ||||||||||||||||
3578 | 3578 | ST VINCENT MEDICAL CENTER/NORTH | 2215 WILDWOOD AVENUE | SHERWOOD | AR | 72120 | PULASKI | (501) 552-7100 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 34.8143780 | -92.2075140 | 0 | 119 | 5 | 5119 | 30780 | Little Rock-North Little Rock, AR | Central | Pulaski County | https://data.medicare.gov/resource/xubh-q36u/row-92it.v7ju~ja3t | 40137 | 659915 | 2019-12-02 | 2019-06-30 | 45 | 14 | 59 | 59 | ||||||||||||
3588 | 3588 | ST JOSEPH'S HOSPITAL | 12866 TROXLER AVENUE | HIGHLAND | IL | 62249 | MADISON | (618) 651-2600 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 38.7570770 | -89.6673580 | 0 | 119 | 17 | 17119 | 41180 | St. Louis-St. Charles-Farmington, MO-IL | Central | Madison County | https://data.medicare.gov/resource/xubh-q36u/row-9pm4-6ca4.6gzh | 141336 | 661881 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||
3814 | 3814 | CHI HEALTH ST MARY'S | 1301 GRUNDMAN BLVD | NEBRASKA CITY | NE | 68410 | OTOE | (402) 873-3321 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 40.6581520 | -95.8621090 | 0 | 131 | 31 | 31131 | https://data.medicare.gov/resource/xubh-q36u/row-6z57~cf6y.zams | 281342 | 661042 | 2019-12-02 | 2019-06-30 | 18 | 18 | 18 | |||||||||||||||||
3897 | 3897 | CHI HEALTH PLAINVIEW | P O BOX 489, 704 NORTH THIRD ST | PLAINVIEW | NE | 68769 | PIERCE | (402) 582-4245 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 42.3587128 | -97.7857721 | 1 | ROOFTOP | 139 | 31 | 31139 | 35740 | Outlying | Pierce County | https://data.medicare.gov/resource/xubh-q36u/row-dyfy-rvq7~3hjd | 281346 | 661043 | 2019-12-02 | 2019-06-30 | 15 | 15 | 15 | |||||||||||||
4062 | 4062 | CHI HEALTH MIDLANDS | 11111 SOUTH 84TH ST | PAPILLION | NE | 68046 | SARPY | (402) 593-3000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 41.1368660 | -96.0428250 | 0 | 153 | 31 | 31153 | 36540 | Omaha-Council Bluffs-Fremont, NE-IA | Central | Sarpy County | https://data.medicare.gov/resource/xubh-q36u/row-kx48-5ytk-a4rz | 280105 | 661550 | 2019-12-02 | 2019-06-30 | 28 | 28 | 28 | |||||||||||||
4140 | 4140 | ST JOSEPH MERCY HOSPITAL | 5301 E HURON RIVER DR | ANN ARBOR | MI | 48106 | WASHTENAW | (734) 712-3456 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 42.2618030 | -83.6598190 | 0 | 161 | 26 | 26161 | 11460 | Detroit-Warren-Ann Arbor, MI | Central | Washtenaw County | https://data.medicare.gov/resource/xubh-q36u/row-2ct6~hcva-wfxq | 230156 | 661012 | 2019-12-02 | 2019-06-30 | 389 | 20 | 6 | 20 | 15 | 450 | 24 | 33 | 507 | |||||||
4230 | 4230 | ST VINCENT WILLIAMSPORT HOSPITAL INC | 412 N MONROE ST | WILLIAMSPORT | IN | 47993 | WARREN | (765) 762-4000 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 40.2904700 | -87.2958190 | 0 | 171 | 18 | 18171 | https://data.medicare.gov/resource/xubh-q36u/row-hngk~n78p-82t8 | 151307 | 660948 | 2019-12-02 | 2019-06-30 | 16 | 16 | 16 | |||||||||||||||||
4387 | 4387 | PRESENCE SAINT JOSEPH MEDICAL CENTER | 333 N MADISON ST | JOLIET | IL | 60435 | WILL | (815) 725-7133 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 41.5282480 | -88.1346450 | 0 | 197 | 17 | 17197 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Will County | https://data.medicare.gov/resource/xubh-q36u/row-fsnj.jnbg.2wfj | 140007 | 661717 | 2019-12-02 | 2019-06-30 | 326 | 33 | 24 | 383 | 41 | 424 | ||||||||||
4425 | 4425 | CHI ST LUKE'S HEALTH BAYLOR COLLEGE OF MEDICINE ME | 7200 CAMBRIDGE, 11TH FLOOR | HOUSTON | TX | 77030 | HARRIS | (832) 355-1000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 29.6988180 | -95.3938620 | 0 | 201 | 48 | 48201 | 26420 | Houston-The Woodlands, TX | Central | Harris County | https://data.medicare.gov/resource/xubh-q36u/row-77i8-gn8q~45g2 | 450193 | 661413 | 2019-12-02 | 2019-06-30 | 475 | 144 | 18 | 637 | 24 | 661 | ||||||||||
4570 | 4570 | MADISON ST JOSEPH HEALTH CENTER | 100 WEST CROSS STREET | MADISONVILLE | TX | 77864 | MADISON | (936) 348-2631 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 30.9420460 | -95.9099560 | 0 | 313 | 48 | 48313 | https://data.medicare.gov/resource/xubh-q36u/row-nns8-bhuk_vxd6 | 451316 | 660055 | 2019-12-02 | 2019-06-30 | 15 | 15 | 15 | |||||||||||||||||
4634 | 4634 | TEXAS HEALTH HARRIS METHODIST FORT WORTH | 1301 PENNSYLVANIA AVENUE | FORT WORTH | TX | 76104 | TARRANT | (817) 250-2100 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 32.7384800 | -97.3393130 | 0 | 439 | 48 | 48439 | 19100 | Dallas-Fort Worth, TX-OK | Central | Tarrant County | https://data.medicare.gov/resource/xubh-q36u/row-5nda.skwh.p2ty | 450135 | 661412 | 2019-12-02 | 2018-09-30 | 500 | 22 | 12 | 662 | 662 | |||||||||||
4719 | 4719 | MERCY MEDICAL CENTER INC | 301 SAINT PAUL PLACE | BALTIMORE | MD | 21202 | BALTIMORE CITY | (410) 332-9237 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 39.2925500 | -76.6135500 | 0 | 510 | 24 | 24510 | 12580 | Washington-Baltimore-Arlington, DC-MD-VA-WV-PA | Central | Baltimore city | https://data.medicare.gov/resource/xubh-q36u/row-xtwd_r83t~vzt6 | 210008 | 662123 | 2019-12-02 | 2019-06-30 | 152 | 22 | 200 | 29 | 229 |
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 );