xlsx crash in hospital-quarterly-financial-utilization-report-sum-of-four-quarters

[rkiddy]

Not sure how we want to fix this. The create routine is getting the wrong length, but I am not sure how....

sqlalchemy.exc.DataError: (pymysql.err.DataError) (1406, "Data too long for column 'teach_rurl' at row 1")
[SQL: insert into 2013_quarter_4_sum_of_four_quarters_rev_7_15 (fac_no, fac_name, year_qtr, beg_date, end_date, op_status, county_name, hsa, hfpa, type_cntrl, type_hosp, teach_rurl, phone, address, city, zip_code, ceo, lic_beds, avl_beds, stf_beds, dis_mcar, dis_mcar_mc, dis_mcal, dis_mcal_mc, dis_cnty, dis_cnty_mc, dis_thrd, dis_thrd_mc, dis_indgnt, dis_oth, dis_tot, dis_ltc, day_mcar, day_mcar_mc, day_mcal, day_mcal_mc, day_cnty, day_cnty_mc, day_thrd, day_thrd_mc, day_indgnt, day_oth, day_tot, day_ltc, vis_mcar, vis_mcar_mc, vis_mcal, vis_mcal_mc, vis_cnty, vis_cnty_mc, vis_thrd, vis_thrd_mc, vis_indgnt, vis_oth, vis_tot, grip_mcar, grip_mcar_mc, grip_mcal, grip_mcal_mc, grip_cnty, grip_cnty_mc, grip_thrd, grip_thrd_mc, grip_indgnt, grip_oth, grip_tot, grop_mcar, grop_mcar_mc, grop_mcal, grop_mcal_mc, grop_cnty, grop_cnty_mc, grop_thrd, grop_thrd_mc, grop_indgnt, grop_oth, grop_tot, bad_debt, cadj_mcar, cadj_mcar_mc, cadj_mcal, cadj_mcal_mc, disp_855, cadj_cnty, cadj_cnty_mc, cadj_thrd, cadj_thrd_mc, char_hb, char_oth, sub_indgnt, tch_allow, tch_supp, ded_oth, ded_tot, cap_mcar, cap_mcal, cap_cnty, cap_thrd, cap_tot, net_mcar, net_mcar_mc, net_mcal, net_mcal_mc, net_cnty, net_cnty_mc, net_thrd, net_thrd_mc, net_indgnt, net_oth, net_tot, oth_op_rev, tot_op_exp, phy_comp, nonop_rev, dis_pips, day_pips, exp_pips, exp_pops, cap_exp, ending_fix_assets, disp_trnfr) values ('106301098', 'AHMC ANAHEIM REGIONAL MEDICAL CENTER', '20134', '1/1/2013', '12/31/2013', 'Open', 'Orange', '13', '1012', 'Non Profit Other', 'Comparable', '(714) 999-5102', '1111 WEST LA PALMA AVENUE', 'ANAHEIM', '92801', 'PATRICK PETRE', '223', '223', '223', '2,810', '2,645', '886', '2,132', '837', '0', '133', '2,037', '324', '500', '12,304', '0', '14,554', '10,489', '4,973', '7,977', '3,703', '2', '903', '6,920', '2,140', '1,180', '52,841', '0', '10,974', '10,415', '7,369', '15,504', '15,871', '8', '1,273', '14,512', '62', '6,511', '82,499', '258,492,600', '234,268,663', '79,775,061', '130,355,674', '63,781,107', '56,561', '13,016,670', '116,528,511', '14,316,748', '17,120,572', '927,712,167', '88,794,659', '109,013,776', '17,291,359', '78,283,438', '106,539,223', '63,388', '6,214,934', '82,498,866', '1,207,396', '23,425,718', '513,332,757', '22,006,966', '302,154,233', '301,527,873', '74,692,259', '185,746,577', '0', '161,033,748', '118,480', '15,543,494', '151,072,354', '0', '19,267,899', '0', '0', '0', '8,243,763', '1,241,407,646', '1,718,069', '0', '0', '0', '1,718,069', '45,133,026', '43,472,635', '20,008,879', '22,129,054', '8,671,829', '1,228', '3,688,109', '46,509,634', '0', '11,740,953', '201,355,347', '(360,730)', '198,970,507', '0', '729,852', '0', '0', '0', '0', '2,211,570', '14,640,645', '0', NULL)]
(Background on this error at: https://sqlalche.me/e/14/9h9h)