{"build_id":11,"built_at":"2026-10-15T01:48:01.432547+00:00","funds":{"receipts":{"last":"2026-10-01","rows":2031,"first":"2023-01-31","periods":86,"not_reconciled":[{"status":"mismatch","period_end":"2025-10-31","document_id":804}],"periods_inferred":[2419,2403,2384,2290,2214,2194,1033,2173,2153,2129,2114,2084,2022,1991,1967,1920,1854,1270,1235,1194,1804,1123,1779,1101,1746,1647,638],"copies_that_disagree":[{"period_end":"2025-07-11","differences":[{"copy":"152214.35","fund":"001","kept":"152724.35"},{"copy":"35864.40","fund":"600","kept":"38368.13"},{"copy":"38846.97","fund":"610","kept":"41274.61"},{"copy":"11662.28","fund":"670","kept":"12580.15"},{"copy":"3389.73","fund":"740","kept":"3671.40"}],"document_id":966},{"period_end":"2025-10-17","differences":[{"copy":"1255940.62","fund":"001","kept":"1256167.52"},{"copy":"63674.11","fund":"600","kept":"68963.71"},{"copy":"43258.84","fund":"610","kept":"47301.72"},{"copy":"12341.02","fund":"670","kept":"14000.95"},{"copy":"3535.31","fund":"740","kept":"3880.56"}],"document_id":838},{"period_end":"2025-10-31","differences":[{"copy":"178245.72","fund":"001","kept":"173641.72"},{"copy":"101326.03","fund":"600","kept":"97564.41"},{"copy":"84254.21","fund":"610","kept":"81464.22"},{"copy":"27773.29","fund":"670","kept":"26946.68"},{"copy":"6345.43","fund":"740","kept":"6140.89"}],"document_id":804}]},"last_month":"2026-08-31","first_month":"2021-11-30","restatements":[{"net":"-410270.85","kind":"net_restatement","funds":[{"fund":"332","change":"-820541.70"},{"fund":"614","change":"410270.85"}],"month":"2021-12-01"},{"net":"12129.96","kind":"net_restatement","funds":[{"fund":"001","change":"215.36"},{"fund":"112","change":"20.67"},{"fund":"332","change":"1778.86"},{"fund":"600","change":"3858.18"},{"fund":"610","change":"4575.59"},{"fund":"670","change":"1501.00"},{"fund":"740","change":"180.30"}],"month":"2022-02-01"},{"net":"398.00","kind":"net_restatement","funds":[{"fund":"001","change":"398.00"}],"month":"2022-05-01"},{"net":"0.00","kind":"zero_sum_reclassification","funds":[{"fund":"325","change":"2001.08"},{"fund":"335","change":"-2001.08"}],"month":"2023-01-01"},{"net":"-14252.60","kind":"net_restatement","funds":[{"fund":"001","change":"-2970.23"},{"fund":"110","change":"-27577.51"},{"fund":"335","change":"55765.00"},{"fund":"600","change":"-22143.25"},{"fund":"610","change":"-28311.67"},{"fund":"670","change":"12964.24"},{"fund":"740","change":"-1979.18"}],"month":"2023-02-01"},{"net":"176.48","kind":"net_restatement","funds":[{"fund":"600","change":"176.48"}],"month":"2023-03-01"},{"net":"0.00","kind":"zero_sum_reclassification","funds":[{"fund":"001","change":"270613.81"},{"fund":"125","change":"299642.00"},{"fund":"200","change":"-570255.81"}],"month":"2023-05-01"},{"net":"0.00","kind":"zero_sum_reclassification","funds":[{"fund":"125","change":"-299642.00"},{"fund":"200","change":"299642.00"}],"month":"2023-06-01"},{"net":"-595.58","kind":"net_restatement","funds":[{"fund":"001","change":"-500.00"},{"fund":"600","change":"-95.58"}],"month":"2023-07-01"},{"net":"43.64","kind":"net_restatement","funds":[{"fund":"600","change":"14.52"},{"fund":"610","change":"25.97"},{"fund":"740","change":"3.15"}],"month":"2023-08-01"},{"net":"0.00","kind":"zero_sum_reclassification","funds":[{"fund":"001","change":"-98610.50"},{"fund":"110","change":"28.00"},{"fund":"125","change":"-1471534.00"},{"fund":"200","change":"1570144.50"},{"fund":"344","change":"-28.00"},{"fund":"600","change":"2244.00"},{"fund":"601","change":"-2244.00"},{"fund":"610","change":"-228689.63"},{"fund":"611","change":"228689.63"}],"month":"2023-10-01"},{"net":"129526.36","kind":"net_restatement","funds":[{"fund":"001","change":"129526.36"}],"month":"2023-11-01"},{"net":"0.00","kind":"zero_sum_reclassification","funds":[{"fund":"001","change":"-49092.27"},{"fund":"321","change":"46503.75"},{"fund":"333","change":"-27538.46"},{"fund":"339","change":"-46503.75"},{"fund":"600","change":"89263.81"},{"fund":"608","change":"-12633.08"}],"month":"2024-01-01"},{"net":"696.76","kind":"net_restatement","funds":[{"fund":"001","change":"122005.81"},{"fund":"110","change":"99.66"},{"fund":"125","change":"218850.00"},{"fund":"200","change":"-340602.00"},{"fund":"600","change":"55618.29"},{"fund":"610","change":"-55275.00"}],"month":"2024-08-01"},{"net":"16622.96","kind":"net_restatement","funds":[{"fund":"600","change":"16622.96"}],"month":"2024-09-01"},{"net":"179765.23","kind":"net_restatement","funds":[{"fund":"001","change":"94636.14"},{"fund":"600","change":"85129.09"}],"month":"2024-10-01"},{"net":"8630.84","kind":"net_restatement","funds":[{"fund":"001","change":"20213.52"},{"fund":"333","change":"-11487.73"},{"fund":"600","change":"-32.79"},{"fund":"610","change":"-40.16"},{"fund":"670","change":"-19.00"},{"fund":"740","change":"-3.00"}],"month":"2024-11-01"},{"net":"0.00","kind":"zero_sum_reclassification","funds":[{"fund":"001","change":"103559.83"},{"fund":"200","change":"-103559.83"}],"month":"2024-12-01"},{"net":"49024.69","kind":"net_restatement","funds":[{"fund":"001","change":"40082.32"},{"fund":"600","change":"8942.37"}],"month":"2025-01-01"},{"net":"0.00","kind":"zero_sum_reclassification","funds":[{"fund":"110","change":"-42635.00"},{"fund":"344","change":"42635.00"}],"month":"2025-02-01"},{"net":"53962.48","kind":"net_restatement","funds":[{"fund":"001","change":"39666.04"},{"fund":"600","change":"14296.44"}],"month":"2025-04-01"},{"net":"17157.95","kind":"net_restatement","funds":[{"fund":"001","change":"17138.94"},{"fund":"600","change":"19.01"}],"month":"2025-10-01"},{"net":"474.37","kind":"net_restatement","funds":[{"fund":"001","change":"222.56"},{"fund":"110","change":"-247500.00"},{"fund":"316","change":"251.81"},{"fund":"344","change":"247500.00"}],"month":"2025-12-01"},{"net":"1451.95","kind":"net_restatement","funds":[{"fund":"001","change":"1451.95"}],"month":"2026-02-01"},{"net":"2877.53","kind":"net_restatement","funds":[{"fund":"001","change":"2879.02"},{"fund":"600","change":"-1.49"}],"month":"2026-03-01"},{"net":"36937.92","kind":"net_restatement","funds":[{"fund":"001","change":"28959.57"},{"fund":"600","change":"7978.35"}],"month":"2026-04-01"},{"net":"3706.03","kind":"net_restatement","funds":[{"fund":"001","change":"3733.26"},{"fund":"600","change":"-27.23"}],"month":"2026-06-01"},{"net":"9257.77","kind":"net_restatement","funds":[{"fund":"001","change":"9053.66"},{"fund":"110","change":"178.41"},{"fund":"600","change":"25.70"}],"month":"2026-08-01"}],"balance_months":49,"missing_months":["2022-03","2022-06","2022-07","2022-08","2022-10","2022-11","2025-05","2025-07","2025-08"],"restatement_note":"As printed by the city: a month's beginning balance differs from the previous report's ending where the city reclassified money between funds (zero-sum) or restated a month (net). Fund 340 Recreation Center prints an actual ending balance of 0.00 since 2023-12 (its cash is held outside pooled cash).","continuity_breaks":[{"fund":"001","page":1,"month":"2022-02-01","beginning":"3911723.13","document_id":2676,"previous_ending":"3911507.77"},{"fund":"001","page":1,"month":"2022-05-01","beginning":"4429190.04","document_id":2567,"previous_ending":"4428792.04"},{"fund":"001","page":1,"month":"2023-02-01","beginning":"4841568.56","document_id":2402,"previous_ending":"4844538.79"},{"fund":"001","page":1,"month":"2023-05-01","beginning":"5659121.25","document_id":2260,"previous_ending":"5388507.44"},{"fund":"001","page":1,"month":"2023-07-01","beginning":"5704502.49","document_id":1032,"previous_ending":"5705002.49"},{"fund":"001","page":1,"month":"2023-10-01","beginning":"5435529.12","document_id":2063,"previous_ending":"5534139.62"},{"fund":"001","page":1,"month":"2023-11-01","beginning":"6467912.39","document_id":2021,"previous_ending":"6338386.03"},{"fund":"001","page":1,"month":"2024-01-01","beginning":"6242466.72","document_id":1944,"previous_ending":"6291558.99"},{"fund":"001","page":1,"month":"2024-08-01","beginning":"4946703.37","document_id":1100,"previous_ending":"4824697.56"},{"fund":"001","page":1,"month":"2024-10-01","beginning":"4802828.28","document_id":1686,"previous_ending":"4708192.14"},{"fund":"001","page":1,"month":"2024-11-01","beginning":"5981640.90","document_id":1646,"previous_ending":"5961427.38"},{"fund":"001","page":1,"month":"2024-12-01","beginning":"5900722.27","document_id":1601,"previous_ending":"5797162.44"},{"fund":"001","page":1,"month":"2025-01-01","beginning":"5794150.06","document_id":1545,"previous_ending":"5754067.74"},{"fund":"001","page":1,"month":"2025-04-01","beginning":"5518692.32","document_id":1293,"previous_ending":"5479026.28"},{"fund":"001","page":1,"month":"2025-10-01","beginning":"5801691.78","document_id":780,"previous_ending":"5784552.84"},{"fund":"001","page":1,"month":"2025-12-01","beginning":"6901667.56","document_id":699,"previous_ending":"6901445.00"},{"fund":"001","page":1,"month":"2026-02-01","beginning":"6236721.50","document_id":581,"previous_ending":"6235269.55"},{"fund":"001","page":1,"month":"2026-03-01","beginning":"6053376.29","document_id":518,"previous_ending":"6050497.27"},{"fund":"001","page":1,"month":"2026-04-01","beginning":"5820288.02","document_id":455,"previous_ending":"5791328.45"},{"fund":"001","page":1,"month":"2026-06-01","beginning":"6210596.22","document_id":354,"previous_ending":"6206862.96"},{"fund":"001","page":1,"month":"2026-08-01","beginning":"5716680.57","document_id":261,"previous_ending":"5707626.91"},{"fund":"110","page":1,"month":"2023-02-01","beginning":"81967.59","document_id":2402,"previous_ending":"109545.10"},{"fund":"110","page":1,"month":"2023-10-01","beginning":"7462.23","document_id":2063,"previous_ending":"7434.23"},{"fund":"110","page":1,"month":"2024-08-01","beginning":"160339.14","document_id":1100,"previous_ending":"160239.48"},{"fund":"110","page":1,"month":"2025-02-01","beginning":"42903.94","document_id":1494,"previous_ending":"85538.94"},{"fund":"110","page":1,"month":"2025-12-01","beginning":"-115340.66","document_id":699,"previous_ending":"132159.34"},{"fund":"110","page":1,"month":"2026-08-01","beginning":"322322.73","document_id":261,"previous_ending":"322144.32"},{"fund":"112","page":1,"month":"2022-02-01","beginning":"200143.64","document_id":2676,"previous_ending":"200122.97"},{"fund":"125","page":1,"month":"2023-05-01","beginning":"3030912.35","document_id":2260,"previous_ending":"2731270.35"},{"fund":"125","page":1,"month":"2023-06-01","beginning":"2791495.59","document_id":2213,"previous_ending":"3091137.59"},{"fund":"125","page":1,"month":"2023-10-01","beginning":"1335279.18","document_id":2063,"previous_ending":"2806813.18"},{"fund":"125","page":1,"month":"2024-08-01","beginning":"1408157.79","document_id":1100,"previous_ending":"1189307.79"},{"fund":"200","page":1,"month":"2023-05-01","beginning":"91440.06","document_id":2260,"previous_ending":"661695.87"},{"fund":"200","page":1,"month":"2023-06-01","beginning":"-1494315.85","document_id":2213,"previous_ending":"-1793957.85"},{"fund":"200","page":1,"month":"2023-10-01","beginning":"115271.81","document_id":2063,"previous_ending":"-1454872.69"},{"fund":"200","page":1,"month":"2024-08-01","beginning":"204830.04","document_id":1100,"previous_ending":"545432.04"},{"fund":"200","page":1,"month":"2024-12-01","beginning":"377799.07","document_id":1601,"previous_ending":"481358.90"},{"fund":"316","page":1,"month":"2025-12-01","beginning":"274147.36","document_id":699,"previous_ending":"273895.55"},{"fund":"321","page":1,"month":"2024-01-01","beginning":"-598049.78","document_id":1944,"previous_ending":"-644553.53"},{"fund":"325","page":1,"month":"2023-01-01","beginning":"-131518.75","document_id":2436,"previous_ending":"-133519.83"},{"fund":"332","page":2,"month":"2021-12-01","beginning":"-79510.70","document_id":2762,"previous_ending":"741031.00"},{"fund":"332","page":2,"month":"2022-02-01","beginning":"-97905.45","document_id":2676,"previous_ending":"-99684.31"},{"fund":"333","page":2,"month":"2024-01-01","beginning":"-240265.16","document_id":1944,"previous_ending":"-212726.70"},{"fund":"333","page":2,"month":"2024-11-01","beginning":"-300160.53","document_id":1646,"previous_ending":"-288672.80"},{"fund":"335","page":2,"month":"2023-01-01","beginning":"-1284817.54","document_id":2436,"previous_ending":"-1282816.46"},{"fund":"335","page":2,"month":"2023-02-01","beginning":"-1235842.54","document_id":2402,"previous_ending":"-1291607.54"},{"fund":"339","page":2,"month":"2024-01-01","beginning":"-60563.94","document_id":1944,"previous_ending":"-14060.19"},{"fund":"344","page":2,"month":"2023-10-01","beginning":"-96832.75","document_id":2063,"previous_ending":"-96804.75"},{"fund":"344","page":2,"month":"2025-02-01","beginning":"-7726.10","document_id":1494,"previous_ending":"-50361.10"},{"fund":"344","page":2,"month":"2025-12-01","beginning":"-75797.10","document_id":699,"previous_ending":"-323297.10"},{"fund":"600","page":2,"month":"2022-02-01","beginning":"1951264.39","document_id":2676,"previous_ending":"1947406.21"},{"fund":"600","page":2,"month":"2023-02-01","beginning":"2326087.84","document_id":2402,"previous_ending":"2348231.09"},{"fund":"600","page":2,"month":"2023-03-01","beginning":"2316158.51","document_id":2365,"previous_ending":"2315982.03"},{"fund":"600","page":2,"month":"2023-07-01","beginning":"2381746.63","document_id":1032,"previous_ending":"2381842.21"},{"fund":"600","page":2,"month":"2023-08-01","beginning":"2427585.55","document_id":2152,"previous_ending":"2427571.03"},{"fund":"600","page":2,"month":"2023-10-01","beginning":"2481914.84","document_id":2063,"previous_ending":"2479670.84"},{"fund":"600","page":2,"month":"2024-01-01","beginning":"2640187.52","document_id":1944,"previous_ending":"2550923.71"},{"fund":"600","page":2,"month":"2024-08-01","beginning":"2568416.86","document_id":1100,"previous_ending":"2512798.57"},{"fund":"600","page":2,"month":"2024-09-01","beginning":"2290650.36","document_id":1745,"previous_ending":"2274027.40"},{"fund":"600","page":2,"month":"2024-10-01","beginning":"2336525.04","document_id":1686,"previous_ending":"2251395.95"},{"fund":"600","page":2,"month":"2024-11-01","beginning":"2390870.20","document_id":1646,"previous_ending":"2390902.99"},{"fund":"600","page":2,"month":"2025-01-01","beginning":"2396897.33","document_id":1545,"previous_ending":"2387954.96"},{"fund":"600","page":2,"month":"2025-04-01","beginning":"2353416.07","document_id":1293,"previous_ending":"2339119.63"},{"fund":"600","page":2,"month":"2025-10-01","beginning":"2266922.13","document_id":780,"previous_ending":"2266903.12"},{"fund":"600","page":2,"month":"2026-03-01","beginning":"2601024.51","document_id":518,"previous_ending":"2601026.00"},{"fund":"600","page":2,"month":"2026-04-01","beginning":"2611135.66","document_id":455,"previous_ending":"2603157.31"},{"fund":"600","page":2,"month":"2026-06-01","beginning":"2687646.17","document_id":354,"previous_ending":"2687673.40"},{"fund":"600","page":2,"month":"2026-08-01","beginning":"2798632.18","document_id":261,"previous_ending":"2798606.48"},{"fund":"601","page":2,"month":"2023-10-01","beginning":"-16335.37","document_id":2063,"previous_ending":"-14091.37"},{"fund":"608","page":2,"month":"2024-01-01","beginning":"-71148.99","document_id":1944,"previous_ending":"-58515.91"},{"fund":"610","page":2,"month":"2022-02-01","beginning":"949546.18","document_id":2676,"previous_ending":"944970.59"},{"fund":"610","page":2,"month":"2023-02-01","beginning":"1793695.09","document_id":2402,"previous_ending":"1822006.76"},{"fund":"610","page":2,"month":"2023-08-01","beginning":"2053864.19","document_id":2152,"previous_ending":"2053838.22"},{"fund":"610","page":2,"month":"2023-10-01","beginning":"1955078.47","document_id":2063,"previous_ending":"2183768.10"},{"fund":"610","page":2,"month":"2024-08-01","beginning":"1984064.12","document_id":1100,"previous_ending":"2039339.12"},{"fund":"610","page":2,"month":"2024-11-01","beginning":"2201914.92","document_id":1646,"previous_ending":"2201955.08"},{"fund":"611","page":2,"month":"2023-10-01","beginning":"-676585.84","document_id":2063,"previous_ending":"-905275.47"},{"fund":"614","page":2,"month":"2021-12-01","beginning":"-384699.44","document_id":2762,"previous_ending":"-794970.29"},{"fund":"670","page":2,"month":"2022-02-01","beginning":"104290.02","document_id":2676,"previous_ending":"102789.02"},{"fund":"670","page":2,"month":"2023-02-01","beginning":"117907.39","document_id":2402,"previous_ending":"104943.15"},{"fund":"670","page":2,"month":"2024-11-01","beginning":"144040.41","document_id":1646,"previous_ending":"144059.41"},{"fund":"740","page":2,"month":"2022-02-01","beginning":"314074.14","document_id":2676,"previous_ending":"313893.84"},{"fund":"740","page":2,"month":"2023-02-01","beginning":"383152.88","document_id":2402,"previous_ending":"385132.06"},{"fund":"740","page":2,"month":"2023-08-01","beginning":"431592.60","document_id":2152,"previous_ending":"431589.45"},{"fund":"740","page":2,"month":"2024-11-01","beginning":"505725.36","document_id":1646,"previous_ending":"505728.36"}],"fund_balance_rows":3979,"funds_with_balances":78,"actual_differs_from_calculated":[{"fund":"340","page":2,"month":"2023-12-31","actual":"0.00","calculated":"-1700.00","document_id":1990},{"fund":"340","page":2,"month":"2024-06-30","actual":"0.00","calculated":"-3340.50","document_id":1149},{"fund":"340","page":2,"month":"2024-12-31","actual":"0.00","calculated":"-46053.59","document_id":1601},{"fund":"340","page":2,"month":"2025-01-31","actual":"0.00","calculated":"-22800.00","document_id":1545},{"fund":"340","page":2,"month":"2025-03-31","actual":"0.00","calculated":"-68400.00","document_id":1467},{"fund":"340","page":2,"month":"2025-04-30","actual":"0.00","calculated":"-55900.00","document_id":1293},{"fund":"340","page":3,"month":"2025-06-30","actual":"0.00","calculated":"-335713.95","document_id":967},{"fund":"340","page":2,"month":"2025-09-30","actual":"0.00","calculated":"-31457.96","document_id":1384},{"fund":"340","page":2,"month":"2025-10-31","actual":"0.00","calculated":"-195309.74","document_id":780},{"fund":"340","page":2,"month":"2025-11-30","actual":"0.00","calculated":"-1592950.79","document_id":736},{"fund":"340","page":2,"month":"2025-12-31","actual":"0.00","calculated":"-631921.58","document_id":699},{"fund":"340","page":2,"month":"2026-01-31","actual":"0.00","calculated":"-13915.20","document_id":639},{"fund":"340","page":2,"month":"2026-02-28","actual":"0.00","calculated":"11362658.17","document_id":581},{"fund":"340","page":2,"month":"2026-03-31","actual":"0.00","calculated":"-8875.75","document_id":518},{"fund":"340","page":2,"month":"2026-04-30","actual":"0.00","calculated":"-1195938.04","document_id":455},{"fund":"340","page":2,"month":"2026-05-31","actual":"0.00","calculated":"-774904.92","document_id":411},{"fund":"340","page":2,"month":"2026-06-30","actual":"0.00","calculated":"-477261.16","document_id":354},{"fund":"340","page":2,"month":"2026-07-31","actual":"0.00","calculated":"-517499.61","document_id":313},{"fund":"340","page":2,"month":"2026-08-31","actual":"0.00","calculated":"-746571.87","document_id":261}],"treasurer_reports_not_reconciled":[{"status":"checked","period_end":"2021-08-31","document_id":2940,"total_matches":false,"arithmetic_errors":[]}]},"summary":{"vendors":795,"projects":36,"anomalies":{"sequence_gaps":28,"payables_odd_lines":59,"change_order_checks":9,"fund_continuity_breaks":85,"pay_application_checks":17,"payables_problem_documents":9},"change_orders":113,"project_links":1991,"receipts_rows":2031,"payables_lines":19410,"payables_total":"64691187.76","pay_applications":274,"payables_documents":132,"fund_balance_months":49,"payables_reconciled":123},"payables":{"status":{"near":3,"garbled":1,"partial":5,"reconciled":123},"by_year":{"2018":{"lines":51,"total":"81794.09","parsed":"81794.09","printed":"81794.09","vendors":30,"coverage":1.0,"documents":1,"line_items":51,"reconciled":1,"individuals_total":"0"},"2021":{"lines":2610,"total":"4720818.87","parsed":"4690717.27","printed":"5180158.44","vendors":309,"coverage":0.9055,"documents":24,"line_items":2612,"reconciled":18,"individuals_total":"100322.43"},"2022":{"lines":1695,"total":"4008511.58","parsed":"4008511.58","printed":"4008495.60","vendors":228,"coverage":1.0,"documents":15,"line_items":1695,"reconciled":14,"individuals_total":"15117.26"},"2023":{"lines":3369,"total":"5917485.71","parsed":"5917485.71","printed":"5947980.16","vendors":309,"coverage":0.9949,"documents":23,"line_items":3369,"reconciled":22,"individuals_total":"9365.88"},"2024":{"lines":3695,"total":"8828000.66","parsed":"8858102.26","printed":"8858102.26","vendors":310,"coverage":1.0,"documents":24,"line_items":3693,"reconciled":24,"individuals_total":"14428.56"},"2025":{"lines":4206,"total":"18610254.58","parsed":"18610254.58","printed":"18610254.58","vendors":304,"coverage":1.0,"documents":25,"line_items":4206,"reconciled":24,"individuals_total":"38291.86"},"2026":{"lines":3784,"total":"22524322.27","parsed":"22524322.27","printed":"22524322.27","vendors":303,"coverage":1.0,"documents":19,"line_items":3784,"reconciled":19,"individuals_total":"13730.29"}},"documents":132,"odd_lines":[{"id":1,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"29.20","vendor":"ADVANCED… (LF-SIDEWA)","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":2,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"4172.26","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":3,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"23.66","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":4,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"21.98","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":5,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"112.67","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":6,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"320.29","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":7,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"469.06","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":8,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"187.36","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":9,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"292.96","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":10,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"2602.31","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":11,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"42.55","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":12,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"27.79","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":13,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:ALLIANT EN"],"amount":"188.80","vendor":"ALLIANT ENERGY","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":14,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"1113.00","vendor":"CARUS PHOSPHATES","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":15,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"367.00","vendor":"CARUS PHOSPHATES","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":16,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:CEDAR VAL"],"amount":"260.00","vendor":"CEDAR VALLEY HUMANE SOCI","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":17,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:CITY TRACT"],"amount":"83.90","vendor":"CITY TRACTOR CO","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":18,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"158.10","vendor":"DATA TECH…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":19,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"598.00","vendor":"DEARBORN G…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":20,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"53398.83","vendor":"ELMER' S E…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":21,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"23.75","vendor":"FORTE PAY…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":22,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"22.75","vendor":"FORTE PAY…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":23,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"50.75","vendor":"FORTE PAY…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":24,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"50.25","vendor":"FORTE PAY…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":25,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"52.25","vendor":"FORTE PAY…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":26,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:GREAT AM"],"amount":"147.00","vendor":"GREAT AMERICA FINANCIAL S","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":27,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:HAWKEYE T"],"amount":"201.00","vendor":"HAWKEYE TITLE","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":28,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:HOLLAND,"],"amount":"5657.00","vendor":"HOLLAND, MICHAEL, RAIBER","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":29,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:HOLLYWOO"],"amount":"166.00","vendor":"HOLLYWOOD GRAPHICS","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":30,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"289.65","vendor":"IOWA DEP… (TSTATE TAXE)","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":31,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:IOWA ONE"],"amount":"50.50","vendor":"IOWA ONE CALL","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":32,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:IOWA PRISO"],"amount":"243.49","vendor":"IOWA PRISON INDUSTRIES","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":33,"why":"zero_or_negative","page":1,"flags":["vendor_truncated"],"amount":"-23.96","vendor":"IPERS","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":34,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"23.99","vendor":"IPERS","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":35,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"517.99","vendor":"IPERS","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":36,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"1078.82","vendor":"IPERS","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":37,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:JOHN DEER"],"amount":"430.22","vendor":"JOHN DEERE FINANCIAL","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":38,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"102.60","vendor":"JOHNSON C… (RECORDING)","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":39,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"157.00","vendor":"JOHNSON C… (231 MAIN S)","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":40,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:MENARDS"],"amount":"836.99","vendor":"MENARDS","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":41,"why":"no_account","page":1,"flags":["vendor_truncated","vendor_from_cut:MENARDS"],"amount":"57.64","vendor":"MENARDS","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":42,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"153.43","vendor":"OFFICE… (EXP CALCULATO)","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":43,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"368.00","vendor":"RELIANCE T…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":44,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"150.00","vendor":"RELIANCE T…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":45,"why":"no_account","page":1,"flags":["vendor_truncated"],"amount":"1355.00","vendor":"RSM US PR…","post_date":null,"document_id":3642,"report_date":"2018-01-02"},{"id":46,"why":"no_account","page":2,"flags":["vendor_truncated","post_date_from_list"],"amount":"795.52","vendor":"SOLON STA…","post_date":"2018-01-02","document_id":3642,"report_date":"2018-01-02"},{"id":47,"why":"no_account","page":2,"flags":["vendor_truncated","vendor_from_cut:STOREY KE","post_date_from_list"],"amount":"255.00","vendor":"STOREY KENWORTHY/MATT P","post_date":"2018-01-02","document_id":3642,"report_date":"2018-01-02"},{"id":48,"why":"no_account","page":2,"flags":["vendor_truncated","vendor_from_cut:TALLGRASS","post_date_from_list"],"amount":"10.69","vendor":"TALLGRASS BUSINESS RESOUR","post_date":"2018-01-02","document_id":3642,"report_date":"2018-01-02"},{"id":49,"why":"no_account","page":2,"flags":["vendor_truncated","post_date_from_list"],"amount":"140.45","vendor":"USA BLUE… (I FLOOR SQL)","post_date":"2018-01-02","document_id":3642,"report_date":"2018-01-02"},{"id":50,"why":"no_account","page":2,"flags":["vendor_truncated","post_date_from_list"],"amount":"2550.00","vendor":"UTILITY SE…","post_date":"2018-01-02","document_id":3642,"report_date":"2018-01-02"},{"id":51,"why":"no_account","page":2,"flags":["vendor_truncated","post_date_from_list"],"amount":"1410.60","vendor":"WELLMAR… (I MEDICAL II)","post_date":"2018-01-02","document_id":3642,"report_date":"2018-01-02"},{"id":1041,"why":"no_account","page":1,"flags":["no_account"],"amount":"10.63","vendor":"MIDAMERICAN ENERGY","post_date":"2021-06-15","document_id":3037,"report_date":"2021-06-15"},{"id":2367,"why":"no_account","page":3,"flags":["no_account"],"amount":"6820.00","vendor":"GOODWIN LAW OFFICE PC","post_date":"2021-11-16","document_id":2848,"report_date":"2021-11-16"},{"id":2368,"why":"no_account","page":3,"flags":["no_account"],"amount":"13745.00","vendor":"MARTIN GARDNER ARCHITECTURE","post_date":"2021-11-16","document_id":2848,"report_date":"2021-11-16"},{"id":6507,"why":"zero_or_negative","page":2,"flags":[],"amount":"-568.19","vendor":"Individual (refund/reimbursement)","post_date":"2023-08-22","document_id":1028,"report_date":"2023-08-22"},{"id":8289,"why":"date","page":1,"flags":[],"amount":"125.90","vendor":"KIECK'S CAREER APPAREL","post_date":"2021-03-05","document_id":1913,"report_date":"2024-03-05"},{"id":8344,"why":"date","page":2,"flags":[],"amount":"29975.70","vendor":"MSA PROFESSIONAL SERVICES","post_date":"2021-03-05","document_id":1913,"report_date":"2024-03-05"},{"id":14784,"why":"zero_or_negative","page":6,"flags":[],"amount":"-193233.49","vendor":"MIRON CONSTRUCTION CO","post_date":"2025-10-21","document_id":844,"report_date":"2025-10-21"},{"id":16940,"why":"zero_or_negative","page":1,"flags":[],"amount":"-400.00","vendor":"VISA","post_date":"2026-04-21","document_id":524,"report_date":"2026-04-21"}],"duplicates":1,"line_flags":{"no_account":3,"amount_wrapped":1,"vendor_wrapped":1,"vendor_truncated":51,"no_payable_number":11,"ocr_noise_in_amount":1,"post_date_from_list":7,"post_date_year_fixed":4,"possible_ocr_duplicate":13,"vendor_from_cut:MENARDS":2,"vendor_from_cut:GREAT AM":1,"vendor_from_cut:HOLLAND,":1,"vendor_from_cut:HOLLYWOO":1,"vendor_from_cut:IOWA ONE":1,"vendor_from_cut:CEDAR VAL":1,"vendor_from_cut:HAWKEYE T":1,"vendor_from_cut:JOHN DEER":1,"vendor_from_cut:STOREY KE":1,"vendor_from_cut:TALLGRASS":1,"account_fund_002_under_001":1,"account_fund_340_under_110":1,"account_fund_901_under_001":1,"vendor_from_cut:ALLIANT EN":12,"vendor_from_cut:CITY TRACT":1,"vendor_from_cut:IOWA PRISO":1},"vendor_kinds":{"unknown":11,"utility":12,"business":516,"government":36,"individual":193,"sole_proprietor":27},"flagged_lines":[{"id":246,"date":"2021-02-02","page":1,"flags":["account_fund_002_under_001"],"amount":"49.51","vendor":"ALLIANT ENERGY","account":"001-199-6371","document_id":1329},{"id":409,"date":"2021-03-02","page":1,"flags":["account_fund_901_under_001"],"amount":"12.98","vendor":"ADVANCED BUSINESS SYSTEM","account":"001-650-6499","document_id":3177},{"id":430,"date":"2021-03-02","page":1,"flags":["account_fund_340_under_110"],"amount":"2335.00","vendor":"HART FREDERICK CONSULTANTS","account":"110-432-6407","document_id":3177},{"id":1041,"date":"2021-06-15","page":1,"flags":["no_account"],"amount":"10.63","vendor":"MIDAMERICAN ENERGY","account":null,"document_id":3037},{"id":1810,"date":"2021-09-21","page":1,"flags":["possible_ocr_duplicate"],"amount":"1704.00","vendor":"GRACELAND LAWN CARE","account":"001-430-6499","document_id":2934},{"id":1812,"date":"2021-09-21","page":1,"flags":["possible_ocr_duplicate"],"amount":"852.00","vendor":"GRACELAND LAWN CARE","account":"001-430-6499","document_id":2934},{"id":2367,"date":"2021-11-16","page":3,"flags":["no_account"],"amount":"6820.00","vendor":"GOODWIN LAW OFFICE PC","account":null,"document_id":2848},{"id":2368,"date":"2021-11-16","page":3,"flags":["no_account"],"amount":"13745.00","vendor":"MARTIN GARDNER ARCHITECTURE","account":null,"document_id":2848},{"id":2946,"date":"2022-02-15","page":1,"flags":["possible_ocr_duplicate"],"amount":"132.22","vendor":"VISA","account":"001-430-6505","document_id":2714},{"id":3425,"date":"2022-05-17","page":1,"flags":["possible_ocr_duplicate"],"amount":"113.20","vendor":"LOWES BUSINESS ACCOUNT","account":"001-430-6507","document_id":2597},{"id":3436,"date":"2022-05-17","page":1,"flags":["possible_ocr_duplicate"],"amount":"238.00","vendor":"VISA","account":"001-430-6599","document_id":2597},{"id":3627,"date":"2022-06-07","page":2,"flags":["possible_ocr_duplicate"],"amount":"15.98","vendor":"JOHN DEERE FINANCIAL","account":"110-210-6507","document_id":2577},{"id":3781,"date":"2022-06-21","page":3,"flags":["possible_ocr_duplicate"],"amount":"50.00","vendor":"FIRE SERVICE TRAINING BURE","account":"001-150-6230","document_id":2553},{"id":4108,"date":"2022-09-06","page":1,"flags":["possible_ocr_duplicate"],"amount":"357.00","vendor":"CINDY COFFIN","account":"001-430-6499","document_id":2496},{"id":4114,"date":"2022-09-06","page":1,"flags":["possible_ocr_duplicate"],"amount":"50.00","vendor":"FIRE SERVICE TRAINING BURE","account":"001-150-6230","document_id":2496},{"id":4247,"date":"2022-10-18","page":1,"flags":["possible_ocr_duplicate"],"amount":"34.98","vendor":"VISA","account":"001-430-6597","document_id":1058},{"id":4698,"date":"2023-02-21","page":2,"flags":["possible_ocr_duplicate"],"amount":"74.99","vendor":"JOHN DEERE FINANCIAL","account":"110-210-6507","document_id":2431},{"id":4908,"date":"2023-03-21","page":1,"flags":["possible_ocr_duplicate"],"amount":"29.66","vendor":"VISA","account":"001-430-6230","document_id":2397},{"id":5032,"date":"2023-03-21","page":4,"flags":["possible_ocr_duplicate"],"amount":"41.58","vendor":"VISA","account":"336-210-6499","document_id":2397}],"unknown_vendors":[{"name":"ELMER' S E…","lines":1,"total":"53398.83"},{"name":"STOREY KENWORTHY/MATT P","lines":106,"total":"21195.66"},{"name":"UTILITY SE…","lines":1,"total":"2550.00"},{"name":"DEARBORN G…","lines":1,"total":"598.00"},{"name":"LITTLE CLIPPERS CHILD DEV C","lines":1,"total":"569.72"},{"name":"RELIANCE T…","lines":2,"total":"518.00"},{"name":"COLD-BLOODED READHEAD L…","lines":1,"total":"325.00"},{"name":"FORTE PAY…","lines":5,"total":"199.75"},{"name":"JOHNSON C… (RECORDING)","lines":1,"total":"102.60"},{"name":"Payable Dates: 2/21/2023 - 2/21/2023","lines":1,"total":"60.45"},{"name":"ADVANCED… (LF-SIDEWA)","lines":1,"total":"29.20"}],"problem_documents":[{"date":"2021-01-19","notes":[],"parsed":"110006.72","status":"partial","printed":"216724.29","coverage":0.5076,"unparsed":89,"document_id":1349,"fund_mismatches":{"001":{"parsed":"22438.49","printed":"22881.24"},"112":{"parsed":"7047.97","printed":"7791.65"},"312":{"parsed":null,"printed":"280.00"},"320":{"parsed":null,"printed":"2524.67"},"335":{"parsed":null,"printed":"9736.91"},"600":{"parsed":"666.08","printed":"9707.32"},"610":{"parsed":"165.00","printed":"7314.20"},"614":{"parsed":"542.50","printed":"77341.62"}}},{"date":"2021-02-02","notes":[],"parsed":"60555.29","status":"partial","printed":"65153.52","coverage":0.9294,"unparsed":2,"document_id":1329,"fund_mismatches":{"110":{"parsed":"6991.96","printed":"7083.10"},"600":{"parsed":"14998.31","printed":"15505.43"},"610":{"parsed":"3281.25","printed":"7281.22"}}},{"date":"2021-02-16","notes":[],"parsed":"106084.24","status":"near","printed":"106212.73","coverage":0.9988,"unparsed":1,"document_id":3197,"fund_mismatches":{"110":{"parsed":"22882.19","printed":"23010.68"}}},{"date":"2021-03-16","notes":[],"parsed":"130680.26","status":"partial","printed":"427531.88","coverage":0.3057,"unparsed":0,"document_id":3156,"fund_mismatches":{"600":{"parsed":"5159.04","printed":"17095.46"}}},{"date":"2021-05-18","notes":[],"parsed":"107475.14","status":"partial","printed":"188400.43","coverage":0.5705,"unparsed":0,"document_id":3065,"fund_mismatches":{"001":{"parsed":"24858.37","printed":"49617.48"},"110":{"parsed":null,"printed":"12157.97"},"112":{"parsed":"1946.16","printed":"7838.20"},"610":{"parsed":null,"printed":"7980.67"},"670":{"parsed":null,"printed":"30135.50"}}},{"date":"2021-12-21","notes":[],"parsed":"159587.14","status":"near","printed":"159807.11","coverage":0.9986,"unparsed":0,"document_id":2788,"fund_mismatches":{"001":{"parsed":"44780.04","printed":"45000.01"}}},{"date":"2022-06-07","notes":[],"parsed":"131948.81","status":"near","printed":"131932.83","coverage":1.0001,"unparsed":1,"document_id":2577,"fund_mismatches":{"110":{"parsed":"10039.38","printed":"10023.40"}}},{"date":"2023-03-07","notes":[],"parsed":"225295.29","status":"partial","printed":"255789.74","coverage":0.8808,"unparsed":0,"document_id":2416,"fund_mismatches":{"617":{"parsed":null,"printed":"30494.45"}}},{"date":"2025-08-05","notes":["page 2: text layer has no character map (garbled)","page 3: text layer has no character map (garbled)","page 4: text layer has no character map (garbled)","page 5: text layer has no character map (garbled)","page 6: text layer has no character map (garbled)","page 7: text layer has no character map (garbled)","page 8: text layer has no character map (garbled)"],"parsed":null,"status":"garbled","printed":null,"coverage":null,"unparsed":0,"document_id":942,"fund_mismatches":{}}],"documents_to_reocr":[{"date":"2021-01-19","funds":{"001":{"parsed":"22438.49","printed":"22881.24"},"112":{"parsed":"7047.97","printed":"7791.65"},"312":{"parsed":null,"printed":"280.00"},"320":{"parsed":null,"printed":"2524.67"},"335":{"parsed":null,"printed":"9736.91"},"600":{"parsed":"666.08","printed":"9707.32"},"610":{"parsed":"165.00","printed":"7314.20"},"614":{"parsed":"542.50","printed":"77341.62"}},"status":"partial","coverage":0.5076,"document_id":1349},{"date":"2021-02-02","funds":{"110":{"parsed":"6991.96","printed":"7083.10"},"600":{"parsed":"14998.31","printed":"15505.43"},"610":{"parsed":"3281.25","printed":"7281.22"}},"status":"partial","coverage":0.9294,"document_id":1329},{"date":"2021-02-16","funds":{"110":{"parsed":"22882.19","printed":"23010.68"}},"status":"near","coverage":0.9988,"document_id":3197},{"date":"2021-03-16","funds":{"600":{"parsed":"5159.04","printed":"17095.46"}},"status":"partial","coverage":0.3057,"document_id":3156},{"date":"2021-05-18","funds":{"001":{"parsed":"24858.37","printed":"49617.48"},"110":{"parsed":null,"printed":"12157.97"},"112":{"parsed":"1946.16","printed":"7838.20"},"610":{"parsed":null,"printed":"7980.67"},"670":{"parsed":null,"printed":"30135.50"}},"status":"partial","coverage":0.5705,"document_id":3065},{"date":"2021-12-21","funds":{"001":{"parsed":"44780.04","printed":"45000.01"}},"status":"near","coverage":0.9986,"document_id":2788},{"date":"2022-06-07","funds":{"110":{"parsed":"10039.38","printed":"10023.40"}},"status":"near","coverage":1.0001,"document_id":2577},{"date":"2023-03-07","funds":{"617":{"parsed":null,"printed":"30494.45"}},"status":"partial","coverage":0.8808,"document_id":2416}],"meetings_without_payables":[{"date":"2021-03-30","meeting_id":538},{"date":"2021-08-04","meeting_id":170},{"date":"2022-04-19","meeting_id":148},{"date":"2022-05-11","meeting_id":145},{"date":"2022-07-19","meeting_id":139},{"date":"2022-08-16","meeting_id":137},{"date":"2022-09-20","meeting_id":135},{"date":"2022-10-04","meeting_id":134},{"date":"2022-11-01","meeting_id":131},{"date":"2022-11-15","meeting_id":130},{"date":"2022-12-06","meeting_id":128},{"date":"2022-12-20","meeting_id":685},{"date":"2023-01-03","meeting_id":127},{"date":"2024-05-28","meeting_id":82},{"date":"2024-06-17","meeting_id":320},{"date":"2025-01-30","meeting_id":378},{"date":"2025-09-08","meeting_id":394}]},"projects":{"projects":[{"name":"Deer View / Highway 6 Traffic Signalization","slug":"deer-view-hwy6-signal","links":{"motion":1,"payable":9},"status":"inactive","original":null,"last_seen":"2023-08-08","first_seen":"2019-12-03","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"Forevergreen Road Earth Stockpile / Grading","slug":"forevergreen-earth-stockpile","links":{"motion":5,"payable":17,"document":7,"agenda_item":7,"change_order":2,"pay_application":4},"status":"active","original":"138050.00","last_seen":"2026-08-05","first_seen":"2025-06-03","paid_to_date":"147103.17","contract_to_date":"152875.25","change_orders_total":"14825.25"},{"name":"2019 Improvements – Forevergreen Road","slug":"forevergreen-road-2019","links":{"motion":26,"resolution":2},"status":"complete","original":null,"last_seen":"2020-10-20","first_seen":"2018-06-18","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"Ireland Avenue Project (south)","slug":"ireland-avenue-south","links":{"motion":51},"status":"inactive","original":null,"last_seen":"2018-07-17","first_seen":"2014-09-10","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"Traffic Signals – Ireland Avenue/Roberts Ferry Road and Highway 6/Marengo Road","slug":"ireland-hwy6-traffic-signals","links":{"motion":17,"payable":4,"resolution":3},"status":"complete","original":null,"last_seen":"2021-10-05","first_seen":"2018-04-03","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"Jasper Avenue Watermain Extension","slug":"jasper-ave-watermain","links":{"motion":25,"resolution":2},"status":"inactive","original":null,"last_seen":"2014-06-25","first_seen":"2013-08-28","paid_to_date":null,"contract_to_date":null,"change_orders_total":null},{"name":"Jasper Avenue / Forevergreen Road Roundabout (28E agreement)","slug":"jasper-forevergreen-roundabout","links":{"motion":1},"status":"inactive","original":null,"last_seen":"2025-01-21","first_seen":"2025-01-21","paid_to_date":null,"contract_to_date":null,"change_orders_total":null},{"name":"Kimberlite Street – South Improvements","slug":"kimberlite-street-south","links":{"motion":12,"payable":26,"document":6,"resolution":6,"pay_application":4},"status":"complete","original":null,"last_seen":"2024-11-05","first_seen":"2024-01-23","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"North Park Road Improvements (STP-U-7662(615)--70-52)","slug":"north-park-road","links":{"motion":39,"payable":67,"document":32,"resolution":15,"agenda_item":27,"change_order":9,"pay_application":17},"status":"active","original":"5458891.91","last_seen":"2026-10-14","first_seen":"2024-06-18","paid_to_date":"5108186.91","contract_to_date":"5586976.68","change_orders_total":"104406.49"},{"name":"Original Town Urbanization – Phase One","slug":"original-town-phase-1","links":{"motion":22,"payable":5,"document":1,"resolution":1,"pay_application":1},"status":"complete","original":"1062008.00","last_seen":"2021-07-20","first_seen":"2018-05-01","paid_to_date":"1310233.78","contract_to_date":"1199014.49","change_orders_total":"137006.49"},{"name":"Original Town Urbanization – Phase Two","slug":"original-town-phase-2","links":{"motion":56,"payable":43,"document":28,"resolution":6,"change_order":15,"pay_application":12},"status":"inactive","original":"1840593.96","last_seen":"2023-08-08","first_seen":"2020-03-24","paid_to_date":"2066537.93","contract_to_date":"2067336.93","change_orders_total":"226742.97"},{"name":"Original Town Urbanization – Phase Three","slug":"original-town-phase-3","links":{"motion":29,"payable":41,"document":26,"resolution":4,"agenda_item":14,"change_order":10,"pay_application":13},"status":"active","original":"2134856.90","last_seen":"2026-10-06","first_seen":"2023-07-18","paid_to_date":"2299941.50","contract_to_date":"2346925.13","change_orders_total":"212068.23"},{"name":"2019 Park Road Paving Project","slug":"park-road-paving-2019","links":{"motion":15,"payable":1,"resolution":2},"status":"complete","original":null,"last_seen":"2021-03-05","first_seen":"2019-03-19","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"Parks and Recreation Improvement Plan – Phase 1","slug":"parks-recreation-improvements-phase-1","links":{"motion":15,"resolution":1},"status":"inactive","original":null,"last_seen":"2018-05-15","first_seen":"2016-03-08","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"Permeable Paver Parking Project","slug":"permeable-pavers","links":{"motion":14,"payable":18,"document":9,"resolution":2,"change_order":2,"pay_application":7},"status":"complete","original":"294724.66","last_seen":"2022-06-21","first_seen":"2020-11-17","paid_to_date":"387231.35","contract_to_date":"387231.35","change_orders_total":"92506.69"},{"name":"Potter Creek Interceptor Sewer","slug":"potter-creek-interceptor","links":{"motion":19,"payable":12,"document":8,"resolution":9,"change_order":3,"pay_application":5},"status":"complete","original":"1067837.60","last_seen":"2024-11-05","first_seen":"2023-02-07","paid_to_date":"1130450.40","contract_to_date":"1076377.40","change_orders_total":"8539.80"},{"name":"Public Works Building","slug":"public-works-building","links":{"motion":26,"payable":99,"document":9,"resolution":4,"pay_application":9},"status":"complete","original":"2552000.00","last_seen":"2023-11-07","first_seen":"2021-11-02","paid_to_date":"1633213.93","contract_to_date":"2579695.56","change_orders_total":"27695.56"},{"name":"Tiffin Community Recreation Center","slug":"recreation-center","links":{"motion":24,"payable":72,"document":38,"resolution":1,"agenda_item":34,"pay_application":15},"status":"active","original":"12435142.00","last_seen":"2026-10-06","first_seen":"2024-06-18","paid_to_date":"8954710.11","contract_to_date":"11393140.12","change_orders_total":"-1042001.88"},{"name":"Roberts Ferry Road Reconstruction","slug":"roberts-ferry-road-reconstruction","links":{"motion":31,"payable":6,"document":4,"resolution":2,"change_order":1,"pay_application":1},"status":"complete","original":"1455350.12","last_seen":"2021-07-20","first_seen":"2018-02-20","paid_to_date":"1409574.25","contract_to_date":"1455350.12","change_orders_total":"0"},{"name":"Roberts Ferry Road & Village Drive Traffic Signal","slug":"roberts-ferry-village-drive-signal","links":{"motion":5,"payable":1,"document":1,"resolution":5,"agenda_item":5,"pay_application":1},"status":"active","original":"367853.75","last_seen":"2026-10-06","first_seen":"2026-04-21","paid_to_date":"203474.27","contract_to_date":"367853.75","change_orders_total":"0.00"},{"name":"Roundabout Gateway Signage","slug":"roundabout-gateway-signage","links":{"motion":8,"payable":1,"document":2,"resolution":4,"change_order":1,"pay_application":1},"status":"complete","original":"11800.00","last_seen":"2021-04-06","first_seen":"2020-10-06","paid_to_date":"12720.00","contract_to_date":"12720.00","change_orders_total":"920.00"},{"name":"Tiffin Roundabout (Park Road / Highway 6, STP-A-006-7(90)--22-52)","slug":"roundabout-park-road-hwy6","links":{"motion":24,"payable":10,"document":4,"resolution":2,"change_order":2,"pay_application":1},"status":"complete","original":"3041340.31","last_seen":"2022-06-21","first_seen":"2019-03-05","paid_to_date":"3299925.03","contract_to_date":"3255700.60","change_orders_total":"6631.24"},{"name":"Sand Volleyball Courts","slug":"sand-volleyball-courts","links":{"motion":1,"document":3,"agenda_item":3,"pay_application":1},"status":"inactive","original":null,"last_seen":"2025-12-02","first_seen":"2025-09-02","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"Original Town Sanitary Sewer Inflow & Infiltration Reduction","slug":"sanitary-sewer-i-and-i-2016","links":{"motion":27,"resolution":1},"status":"complete","original":null,"last_seen":"2017-05-16","first_seen":"2016-01-19","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"Sidewalk Connection to Soccer Fields","slug":"sidewalk-to-soccer-fields","links":{"motion":8,"payable":3,"document":3,"resolution":4,"pay_application":3},"status":"complete","original":"64935.54","last_seen":"2024-12-17","first_seen":"2023-11-07","paid_to_date":"64935.54","contract_to_date":"64935.54","change_orders_total":"0.00"},{"name":"Soccer Field Parking Lot Expansion","slug":"soccer-field-parking-lot","links":{"motion":9,"document":2,"resolution":3,"pay_application":1},"status":"complete","original":"302908.39","last_seen":"2021-04-06","first_seen":"2019-03-19","paid_to_date":"302672.39","contract_to_date":"302908.39","change_orders_total":"0"},{"name":"2019 Storm Water Rehabilitation Projects","slug":"stormwater-rehabilitation-2019","links":{"motion":14,"resolution":1},"status":"complete","original":null,"last_seen":"2020-06-16","first_seen":"2019-03-19","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"Tiffin Heights West Off-Site Public Improvements (water main)","slug":"tiffin-heights-west-watermain","links":{"motion":11,"document":5,"resolution":8,"agenda_item":3,"pay_application":3},"status":"inactive","original":"870652.60","last_seen":"2025-11-04","first_seen":"2024-05-07","paid_to_date":"881593.70","contract_to_date":"884489.70","change_orders_total":"0"},{"name":"Tiffin Trail – Phase 6","slug":"trail-phase-6","links":{"motion":4,"payable":12,"document":3,"change_order":1,"pay_application":2},"status":"complete","original":"89588.50","last_seen":"2023-03-07","first_seen":"2021-05-04","paid_to_date":"84739.10","contract_to_date":"88635.76","change_orders_total":"-952.74"},{"name":"Tiffin Trail – Phase 7","slug":"trail-phase-7","links":{"motion":13,"payable":13,"document":6,"resolution":3,"pay_application":6},"status":"inactive","original":"269835.84","last_seen":"2023-03-07","first_seen":"2020-09-01","paid_to_date":"284608.24","contract_to_date":"269835.84","change_orders_total":"0"},{"name":"Trails Phase Four","slug":"trails-phase-4","links":{"motion":7},"status":"inactive","original":null,"last_seen":"2012-09-26","first_seen":"2011-02-09","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"US Highway 6 Reconstruction","slug":"us-hwy-6-reconstruction","links":{"payable":21},"status":"active","original":null,"last_seen":"2026-09-01","first_seen":"2025-03-18","paid_to_date":null,"contract_to_date":null,"change_orders_total":null},{"name":"2014 Water and Sewer Extension Project (CCA schools)","slug":"water-sewer-extension-2014","links":{"motion":55,"resolution":1},"status":"inactive","original":null,"last_seen":"2018-07-17","first_seen":"2014-06-25","paid_to_date":null,"contract_to_date":null,"change_orders_total":"0"},{"name":"Water Treatment Plant Upgrades","slug":"water-treatment-plant-upgrade","links":{"motion":33,"payable":64,"document":27,"resolution":7,"agenda_item":27,"change_order":3,"pay_application":13},"status":"active","original":"12182553.00","last_seen":"2026-10-06","first_seen":"2023-05-16","paid_to_date":"9699565.50","contract_to_date":"12202701.91","change_orders_total":"20148.91"},{"name":"Well #5 (test well, pump, controls and water main)","slug":"well-5","links":{"motion":29,"payable":67,"document":17,"resolution":10,"change_order":6,"pay_application":11},"status":"complete","original":"296015.00","last_seen":"2025-04-01","first_seen":"2021-02-02","paid_to_date":"1103712.00","contract_to_date":"335735.00","change_orders_total":"44822.49"},{"name":"Wastewater Treatment Plant Expansion – Phase Two","slug":"wwtp-phase-2","links":{"motion":41,"payable":3,"document":1,"resolution":1,"pay_application":1},"status":"complete","original":"5685007.75","last_seen":"2021-08-17","first_seen":"2017-09-05","paid_to_date":"5809635.72","contract_to_date":"5798931.95","change_orders_total":"112924.00"}],"sequence_gaps":[{"have":[2,5,6],"project":"forevergreen-road-2019","contractor":"STREB CONSTRUCTION","change_orders_missing":[1,3,4]},{"have":[3,5,6,7,8,9,10,12,13,14,15,16,17,19,20,21,22,23],"missing":[1,2,4,11,18],"project":"ireland-avenue-south","contractor":"RATHJE CONSTRUCTION"},{"have":[1,2,3,4,5,6,96],"project":"ireland-avenue-south","contractor":"RATHJE CONSTRUCTION","change_orders_missing":[7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95]},{"have":[6,7,8,9,10,11],"missing":[1,2,3,4,5],"project":"ireland-hwy6-traffic-signals","contractor":"PRICE INDUSTRIAL"},{"have":[2,3],"project":"ireland-hwy6-traffic-signals","contractor":"PRICE INDUSTRIAL","change_orders_missing":[1]},{"have":[9,11,12,13,14,15,16,17,19],"project":"north-park-road","contractor":"BOOMERANG CORP","change_orders_missing":[1,2,3,4,5,6,7,8,10,18]},{"have":[1,2,5,6,8,9,10,11],"missing":[3,4,7],"project":"original-town-phase-1","contractor":"LL PELLING"},{"have":[1,2,6,7,8],"project":"original-town-phase-1","contractor":"LL PELLING","change_orders_missing":[3,4,5]},{"have":[1,2,3,4,6,7,8,9,10,11,12,13,14,15,16,17,18],"project":"original-town-phase-2","contractor":"RATHJE CONSTRUCTION","change_orders_missing":[5]},{"have":[2],"missing":[1],"project":"original-town-phase-2","contractor":"NOLAN'S LAWN CARE"},{"have":[1,2,3,4,5,6,7,8,9,11],"project":"original-town-phase-3","contractor":"RATHJE CONSTRUCTION","change_orders_missing":[10]},{"have":[1,2,4,5,6,7,8,9,10,11,12,13,14,15,16],"missing":[3],"project":"recreation-center","contractor":"MIRON CONSTRUCTION CO"},{"have":[1,3,4,5,6,7,8,10,11,12,13],"missing":[2,9],"project":"roberts-ferry-road-reconstruction","contractor":"VIETH CONSTRUCTION CORP"},{"have":[1,3,4,7],"project":"roberts-ferry-road-reconstruction","contractor":"VIETH CONSTRUCTION CORP","change_orders_missing":[2,5,6]},{"have":[1,2,4,5,6,7,8,9,10,11,12,13,14],"missing":[3],"project":"roundabout-park-road-hwy6","contractor":"RATHJE CONSTRUCTION"},{"have":[1,2,3,5,6,7,9],"project":"roundabout-park-road-hwy6","contractor":"RATHJE CONSTRUCTION","change_orders_missing":[4,8]},{"have":[1,3,5,6,7,8,9,10,11,12,13,14,15],"missing":[2,4],"project":"sanitary-sewer-i-and-i-2016","contractor":"SULZCO LLC"},{"have":[2,3,11,94],"project":"sanitary-sewer-i-and-i-2016","contractor":"SULZCO LLC","change_orders_missing":[1,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93]},{"have":[4],"missing":[1,2,3],"project":"soccer-field-parking-lot","contractor":"LL PELLING"},{"have":[1,2,4],"project":"stormwater-rehabilitation-2019","contractor":"TRIPLE B CONSTRUCTION","change_orders_missing":[3]},{"have":[1,2,3,4,6,7],"missing":[5],"project":"trail-phase-7","contractor":"CARTER & ASSOCIATES"},{"have":[4,5,6],"missing":[1,2,3],"project":"water-sewer-extension-2014","contractor":"MAXWELL CONSTRUCTION"},{"have":[2],"missing":[1],"project":"water-sewer-extension-2014","contractor":"CORNERSTONE EXCAVATING"},{"have":[2],"project":"water-sewer-extension-2014","contractor":"CORNERSTONE EXCAVATING","change_orders_missing":[1]},{"have":[3,7,8,9,10,11,92],"missing":[1,2,4,5,6,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91],"project":"water-sewer-extension-2014","contractor":"WRH INC"},{"have":[1,3,4,5],"project":"water-sewer-extension-2014","contractor":"WRH INC","change_orders_missing":[2]},{"have":[1,2,3,4,5,6,7,8,9,10,11,13,14,15,16,18,19,20,21,22,23],"missing":[12,17],"project":"wwtp-phase-2","contractor":"PORTZEN CONSTRUCTION"},{"have":[1,2,3,4,5,6,7,96],"project":"wwtp-phase-2","contractor":"PORTZEN CONSTRUCTION","change_orders_missing":[8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95]}],"unmatched_motions":[{"why":"none","date":"2010-01-13","kind":"pay_app","text":"Adjournment – Motion made by Gericke and seconded by Petersen for approval for pay estimate to City Wide Construction for$ 74, 262. 73","numbers":[],"motion_id":104929,"candidates":[]},{"why":"alias_outside_window","date":"2010-02-10","kind":"pay_app","text":"Adjournment – Motion by Bartels and seconded by Ball to approve pay estimate# 3 for Dave Schmitt Construction for amount of$ 22,648. 95 and motion by Bartels and seconded by Petersen to approve change","numbers":[3],"motion_id":104962,"candidates":["ireland-avenue-south"]},{"why":"alias_outside_window","date":"2010-04-14","kind":"pay_app","text":"Adjournment – Motion made by Petersen and seconded by Gericke to approve final pay estimate# 4 to Dave Schmitt Construction in the amount of$ 25, 145. 19 for the 2009 Water and Sanitary Sewer along Ir","numbers":[4],"motion_id":105019,"candidates":["ireland-avenue-south","trails-phase-4"]},{"why":"none","date":"2010-09-15","kind":"change_order","text":"Adjournment – Motion made by Weipert and seconded by Petersen to approve Change Order# 1 for 2010 Street and Sidewalk Repairs","numbers":[1],"motion_id":105170,"candidates":[]},{"why":"none","date":"2013-07-10","kind":"change_order","text":"Resolution 2013- 131 Authorizing the City Administrator/Clerk to approve Change Order# 1 to LL Pelling in the amount of$ 2, 573. 24 – Motion Ryan to' amend Resolution to state \" removal and replacemen","numbers":[1],"motion_id":106078,"candidates":[]},{"why":"none","date":"2013-07-10","kind":"pay_app","text":"Resolution 2013- 132 Authorizing to Pay Estimate No. 2 t LL Pelling in the amount of 212, 764'. 33 – Motion Ryan to amend Resolution to make next payment with caveat of explanation of what change orde","numbers":[2],"motion_id":106080,"candidates":[]},{"why":"none","date":"2013-07-24","kind":"change_order","text":"L Resolution 2013- 144 Approving Change Order# 1 to Dave Schmitt Construction for – motion to adjourn, second Bartels","numbers":[1],"motion_id":106144,"candidates":[]},{"why":"none","date":"2013-07-24","kind":"pay_app","text":"M Resolution 2013- 145 Authorizing Pay Estimate to Dave Schmitt in the amount of – Motion by Ryan to approve","numbers":[],"motion_id":106145,"candidates":[]},{"why":"none","date":"2013-07-24","kind":"pay_app","text":"M Resolution 2013- 145 Authorizing Pay Estimate to Dave Schmitt in the amount of – motion to amend to approve estimate less $ 11, 160. 21 in the change order, second Bartels","numbers":[],"motion_id":106146,"candidates":[]},{"why":"none","date":"2013-07-24","kind":"change_order","text":"N-0 tels to approve, seconded by Ryan. Ryan commenting that this does not approve change order. Ayes: Kahler, Ryan, Bartels, Upton, Phillips - Nays: None. Motion carried 0. Discussion and possible act","numbers":[],"motion_id":106148,"candidates":[]},{"why":"none","date":"2013-08-14","kind":"change_order","text":"Resolution 2013- 144 Approving Dave Schmitt Construction change order of$ 11, 160. 21: Public Work Mehmen added that the stubbed out line to the water tower was extra – Motion Upton to approve, second","numbers":[],"motion_id":106179,"candidates":[]},{"why":"none","date":"2013-12-09","kind":"change_order","text":"Resolution 2013- 213 Approval of Change Order# 1 to Hagerty Earthworks LLC in the amount of 2, 950. 00 and Pay Estimate in the amount of$ 71, 305. 57 for the Water Pressure Upgrade – Motion Upton to a","numbers":[1],"motion_id":106391,"candidates":[]},{"why":"none","date":"2014-01-08","kind":"change_order","text":"Resolution 2014-002 Approving Change Order #2 in the amount of $9,770 for City Hall – Motion to approve Kahler, second Ryan. Ayes=Petersen, Kahler, Ryan, Bartels, Upton. Motion passed","numbers":[2],"motion_id":106413,"candidates":[]},{"why":"none","date":"2014-02-26","kind":"change_order","text":"B Resolution 2014- 08 Approving Change Order# 4 for the 2013 Capital Improvement – Motion to table by Ryan","numbers":[4],"motion_id":106470,"candidates":[]},{"why":"none","date":"2014-02-26","kind":"pay_app","text":"I Resolution 2014- 022 Approving the Pay Estimate and Change Order to Ha gge rty for – Motion by Upton to amend the language to read pay estimate # 2","numbers":[],"motion_id":106480,"candidates":[]},{"why":"none","date":"2014-11-12","kind":"change_order","text":"Motion to Approve Resolution 2014-157 Approving Change Order for City Park Lighting in the amount of $20,565 by Ryan","numbers":[],"motion_id":106786,"candidates":[]},{"why":"alias_outside_window","date":"2015-05-13","kind":"pay_app","text":"F Mayor- Don Goedken had discussion with the Mayor about the annexation. And the majority of other – Motion to approve Resolution 2015- 063 Approving Rathje Construction Pay Estimate # 2 for Ireland A","numbers":[2],"motion_id":107061,"candidates":["ireland-hwy6-traffic-signals"]},{"why":"none","date":"2015-11-25","kind":"pay_app","text":"K-5 Consideration of Pay Estimate # 1 — Final Payment— Pirc- Tobin – Motion to Approve by Ryan","numbers":[1],"motion_id":107336,"candidates":[]},{"why":"none","date":"2015-12-09","kind":"pay_app","text":"R-5 Consideration of Pay Estimate # 5 — Final — L.L. Pelling – Motion to Approve by Upton","numbers":[5],"motion_id":107365,"candidates":[]},{"why":"none","date":"2016-04-19","kind":"pay_app","text":"K-2 Consideration of Pay Estimate # 1 — Metro Pavers, Inc – Motion to Approve by Bartels","numbers":[1],"motion_id":107524,"candidates":[]},{"why":"none","date":"2016-05-03","kind":"pay_app","text":"K-2 Consideration of Pay Estimate # 2 — Metro Pavers, Inc – Motion to Approve by Upton","numbers":[2],"motion_id":107538,"candidates":[]},{"why":"none","date":"2016-06-14","kind":"pay_app","text":"K-2 Consideration of Pay Estimate # – Motion to Approve by Ryan. # 22—— SulzCo LLC","numbers":[],"motion_id":107576,"candidates":[]},{"why":"none","date":"2016-07-19","kind":"pay_app","text":"K-4 Consideration of Pay Estimate # 3 — Metro Pavers, Inc – Motion to Approve by Bartels","numbers":[3],"motion_id":107643,"candidates":[]},{"why":"none","date":"2016-09-01","kind":"pay_app","text":"K-2 Consideration of Pay Estimate #5 – Metro Pavers, Inc – Motion to table due to an incorrect pay estimate by Ryan","numbers":[5],"motion_id":107685,"candidates":[]},{"why":"none","date":"2016-09-06","kind":"pay_app","text":"R-3 Consideration of Pay Estimate 44 —Metro Pavers, Inc – Motion to Approve by Bartels","numbers":[4],"motion_id":107709,"candidates":[]},{"why":"none","date":"2016-10-18","kind":"pay_app","text":"K-2 Consideration of Pay Estimate 45 — Metro Pavers, Inc – Motion to table due to an incorrect pay estimate by Ryan","numbers":[5],"motion_id":107771,"candidates":[]},{"why":"none","date":"2016-11-01","kind":"pay_app","text":"J-1 Consideration of Pay Estimate 45 — Metro Pavers, Inc – Motion to Approve by Havens","numbers":[5],"motion_id":107782,"candidates":[]},{"why":"none","date":"2017-08-01","kind":"pay_app","text":"K-5 Discussion andConsideration ofPayEstimate for80/380Commerce Park LLC, Village Drive Extension (RISE Project) andCouncil Action asNeeded Motion toapprove thePayEstimate for80/380Commerce Park LLC, ","numbers":[],"motion_id":108197,"candidates":[]},{"why":"none","date":"2018-03-20","kind":"pay_app","text":"K-2 Consideration ofPayEstimate #6 –Final – Metro Pavers, Inc. –Motion toApprove byHavens. Second byRyan. Allayes, motion carried – Motion toApprove byHavens","numbers":[6],"motion_id":108624,"candidates":[]},{"why":"none","date":"2018-08-21","kind":"change_order","text":"K-1 Consideration ofPayables List –Motion toApprove asamended byHavens. Second byRyan. Allayes, motion carried. Motion toremove theRathje check 23403 for $12,657.52andrecut check forthe updated change","numbers":[],"motion_id":108902,"candidates":[]},{"why":"none","date":"2018-08-21","kind":"change_order","text":"K-1 Consideration ofPayables List –Motion toApprove asamended byHavens. Second byRyan. Allayes, motion carried. Motion toremove theRathje check 23403 for $12,657.52andrecut check forthe updated change","numbers":[],"motion_id":108903,"candidates":[]},{"why":"none","date":"2018-08-21","kind":"change_order","text":"K-3 Consideration ofChange Order #7 –Rathje Construction – Motion toApprove byRyan. Second bySchnedler. Discussion: Ben Carhoff advised thisisaChange Order from theDOT called abalancing change order. ","numbers":[7],"motion_id":108905,"candidates":[]},{"why":"none","date":"2018-08-21","kind":"pay_app","text":"K-4 Consideration ofPayEstimate #24 (Final) of $14,007.36 –Rathje Construction – Motion to Approve byRyan","numbers":[24],"motion_id":108906,"candidates":[]},{"why":"none","date":"2018-10-02","kind":"pay_app","text":"K-3 Consideration ofPayEstimate #9 –Final – Woodruff Construction – Timber Ridge Trail –Motion toApprove byUpton. Second byBartels. Allayes, motion carried – Motion toApprove byUpton","numbers":[9],"motion_id":108981,"candidates":[]},{"why":"none","date":"2018-10-16","kind":"pay_app","text":"K-2 Consideration ofPayEstimate #11 –Final – Cornerstone Excavating, Inc. –Motion toApprove by Havens. Second bySchnedler Allayes, motion carried – Motion toApprove by Havens","numbers":[11],"motion_id":108996,"candidates":[]},{"why":"ambiguous_contractor","date":"2018-12-04","kind":"pay_app","text":"K-2 Consideration ofPayEstimate #1 –Price Industrial – Motion toApprove byHavens. Second bySchnedler. Allayes, motion carried – Motion toApprove byHavens","numbers":[1],"motion_id":109054,"candidates":["ireland-hwy6-traffic-signals","deer-view-hwy6-signal"]},{"why":"ambiguous_contractor","date":"2018-12-18","kind":"change_order","text":"K-3 Consideration ofChange Order #3 –LLPelling – Motion toApprove byBartels. Second byRyan. Allayes, motion carried – Motion toApprove byBartels","numbers":[3],"motion_id":109067,"candidates":["original-town-phase-1","soccer-field-parking-lot"]},{"why":"ambiguous_contractor","date":"2018-12-18","kind":"pay_app","text":"K-4 Consideration ofPayEstimate #3 –LLPelling – Motion toApprove byRyan. Second byUpton. Allayes, motion carried – Motion toApprove byRyan","numbers":[3],"motion_id":109068,"candidates":["original-town-phase-1","soccer-field-parking-lot"]},{"why":"none","date":"2019-01-08","kind":"pay_app","text":"R-2 Consideration ofPayEstimate #1 –Dave Schmitt Construction Company – Motion toApprove by Havens. Second byBartels. Allayes, motion carried – Motion toApprove by Havens","numbers":[1],"motion_id":109085,"candidates":[]},{"why":"ambiguous_contractor","date":"2019-03-05","kind":"change_order","text":"K-3 Discussion andConsideration ofChange Order #1 –Price Electric andCouncil Action asNeeded Motion toapprove Change Order #1 –Price Electric subject tofinal plans byHavens. Second bySchnedler. Allaye","numbers":[1],"motion_id":109195,"candidates":["ireland-hwy6-traffic-signals","deer-view-hwy6-signal"]},{"why":"ambiguous_contractor","date":"2019-03-05","kind":"change_order","text":"K-4 Discussion andConsideration ofChange Order #2 –Price Electric andCouncil Action asNeeded Motion toapprove Change Order #2 –Price Electric byRyan. Second bySchnedler. Allayes, motion carried – Moti","numbers":[2],"motion_id":109196,"candidates":["ireland-hwy6-traffic-signals","deer-view-hwy6-signal"]},{"why":"ambiguous_contractor","date":"2019-04-02","kind":"pay_app","text":"K-2 Consideration ofPayEstimate #3 –Price Industrial, LLC. –Motion toApprove byRyan. Second bySchnedler. Allayes, motion carried – Motion toApprove byRyan","numbers":[3],"motion_id":109240,"candidates":["ireland-hwy6-traffic-signals","deer-view-hwy6-signal"]},{"why":"ambiguous_contractor","date":"2019-04-02","kind":"change_order","text":"K-3 Consideration ofChange Order #4 –LLPelling – Motion toApprove bySchnedler. Second byBartels. Allayes, motion carried – Motion toApprove bySchnedler","numbers":[4],"motion_id":109241,"candidates":["original-town-phase-1","soccer-field-parking-lot"]},{"why":"ambiguous_contractor","date":"2019-04-02","kind":"change_order","text":"K-4 Consideration ofChange Order #5 –LLPelling – Motion toApprove byHavens. Second byRyan. Allayes, motion carried – Motion toApprove byHavens","numbers":[5],"motion_id":109242,"candidates":["original-town-phase-1","soccer-field-parking-lot"]},{"why":"ambiguous_contractor","date":"2019-05-07","kind":"pay_app","text":"K-2 Consideration of Pay Estimate 44 — LL Pelling – Motion to Approve by Upton","numbers":[4],"motion_id":109338,"candidates":["original-town-phase-1","soccer-field-parking-lot"]},{"why":"none","date":"2019-05-07","kind":"pay_app","text":"K-4 Consideration of Pay Estimate 42 ( Final) — Dave Schmitt Construction Company – Motion to approve Dave Schmitt Construction Company Pay Estimate 42 ( Final) by Ryan","numbers":[2],"motion_id":109340,"candidates":[]},{"why":"ambiguous_contractor","date":"2019-06-04","kind":"pay_app","text":"K-4 Consideration Pay Estimate of 44 —Price Electric – Motion to Approve by Bartels","numbers":[],"motion_id":109400,"candidates":["ireland-hwy6-traffic-signals","deer-view-hwy6-signal"]},{"why":"ambiguous_contractor","date":"2019-06-18","kind":"pay_app","text":"K-4 Consideration Pay Estimate of 95— LL Pelling – Motion to Approve by Ryan","numbers":[],"motion_id":109424,"candidates":["original-town-phase-1","soccer-field-parking-lot"]},{"why":"ambiguous_contractor","date":"2019-07-16","kind":"pay_app","text":"K-6 Consideration Pay Estimate of 44 —Price Industrial – Motion to Approve by Havens","numbers":[],"motion_id":109467,"candidates":["ireland-hwy6-traffic-signals","deer-view-hwy6-signal"]},{"why":"none","date":"2019-08-06","kind":"pay_app","text":"L-4 Consideration ofPay Estimate #1 VSI&C Final Motion toApprove byHavens. Second byBartels. Allayes, motion carried – Motion toApprove byHavens","numbers":[1],"motion_id":109491,"candidates":[]},{"why":"ambiguous_contractor","date":"2019-08-20","kind":"change_order","text":"K-6 Consideration ofChange Order #1 Price Electric Motion toApprove byHavens Second byRyan Allayes, motion carried – Motion toApprove byHavens","numbers":[1],"motion_id":109519,"candidates":["ireland-hwy6-traffic-signals","deer-view-hwy6-signal"]},{"why":"ambiguous_contractor","date":"2019-09-03","kind":"pay_app","text":"K-2 Consideration ofPay Estimate #1 LLPelling, Soccer Fields Parking LotExpansion Motion toApprove byHavens Second bySchnedler Allayes, motion approved – Motion toApprove byHavens","numbers":[1],"motion_id":109531,"candidates":["original-town-phase-1","soccer-field-parking-lot"]},{"why":"ambiguous_contractor","date":"2019-11-05","kind":"pay_app","text":"K-2 Consideration ofPay Estimate #2 LLPelling, Soccer Fields Parking LotExpansion Project Motion toApprove byHavens. Second byBartels. Allayes, motion carried – Motion toApprove byHavens","numbers":[2],"motion_id":109577,"candidates":["original-town-phase-1","soccer-field-parking-lot"]},{"why":"ambiguous_contractor","date":"2020-01-07","kind":"pay_app","text":"K-2 Consideration of Pay Estimate #3 – LL Pelling, Soccer Fields Parking Lot Expansion Project – Motion to Approve by Bartels","numbers":[3],"motion_id":109666,"candidates":["original-town-phase-1","soccer-field-parking-lot"]},{"why":"none","date":"2023-05-16","kind":"change_order","text":"K-4 Discussion and Consideration of Change Order for Tiffin Fire Truck and Council Action as Needed – Motion to approve by Limkemann","numbers":[],"motion_id":111175,"candidates":[]},{"why":"none","date":"2024-11-19","kind":"pay_app","text":"K-6 Consideration of Pay Application for City’s Portion of the Watermain Connection Project at Hunt Club/Village Drive – Motion to approve by Limkemann","numbers":[],"motion_id":111846,"candidates":[]}],"change_order_checks":[{"issues":["previous 5497683.66 != change order #12 new 5500433.66"],"number":13,"project":"north-park-road","as_printed":"as printed by the city: change orders #12 and #13 were generated from the same authorized amount","contractor":"BOOMERANG CORP","document_id":621,"meeting_date":"2026-03-03"},{"issues":["previous 5500994.46 != change order #13 new 5498244.46"],"number":14,"project":"north-park-road","as_printed":null,"contractor":"BOOMERANG CORP","document_id":558,"meeting_date":"2026-04-07"},{"issues":["previous 5554449.41 != change order #15 new 5555699.41"],"number":16,"project":"north-park-road","as_printed":"as printed by the city: change orders #15 and #16 were generated from the same authorized amount","contractor":"BOOMERANG CORP","document_id":435,"meeting_date":"2026-06-02"},{"issues":["new 1824608.96 != previous 1824618.96 + amount -10000.00"],"number":1,"project":"original-town-phase-2","as_printed":null,"contractor":"RATHJE CONSTRUCTION","document_id":3174,"meeting_date":"2021-03-02"},{"issues":["previous 1814618.96 != change order #1 new 1824608.96"],"number":2,"project":"original-town-phase-2","as_printed":null,"contractor":"RATHJE CONSTRUCTION","document_id":3020,"meeting_date":"2021-07-06"},{"issues":["no amount read"],"number":1,"project":"permeable-pavers","as_printed":null,"contractor":"NOLAN'S LAWN CARE","document_id":1074,"meeting_date":"2021-10-05"},{"issues":["new 1076377.60 != previous 1079277.40 + amount -3000.00","previous 1079277.40 != change order #2 new 1079377.60"],"number":3,"project":"potter-creek-interceptor","as_printed":"as printed by the city: the form's base 1,079,277.40 differs from change order #2's printed 1,079,377.60","contractor":"BOOMERANG CORP","document_id":1164,"meeting_date":"2024-07-02"},{"issues":["no amount read"],"number":7,"project":"roberts-ferry-road-reconstruction","as_printed":null,"contractor":"VIETH CONSTRUCTION CORP","document_id":3122,"meeting_date":"2021-04-06"},{"issues":["no amount read"],"number":9,"project":"roundabout-park-road-hwy6","as_printed":null,"contractor":"RATHJE CONSTRUCTION","document_id":2649,"meeting_date":"2022-04-05"}],"unmatched_documents":[{"why":"none","date":"2023-05-16","kind":"change_order","title":"K-4 - Change Order for Tiffin Fire Truck","candidates":[],"document_id":2319}],"payables_vs_pay_apps":[{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"forevergreen-earth-stockpile","contractor":"CORNERSTONE EXCAVATING","difference":"0.00","pay_apps_payment_due_2021_on":"165337.95","payables_lines_to_contractor":"165337.95"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"ireland-hwy6-traffic-signals","contractor":"PRICE INDUSTRIAL","difference":"1000.00","pay_apps_payment_due_2021_on":"0","payables_lines_to_contractor":"1000.00"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"north-park-road","contractor":"BOOMERANG CORP","difference":"0.00","pay_apps_payment_due_2021_on":"5108157.81","payables_lines_to_contractor":"5108157.81"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"original-town-phase-1","contractor":"LL PELLING","difference":"-77765.90","pay_apps_payment_due_2021_on":"77765.90","payables_lines_to_contractor":"0"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"original-town-phase-2","contractor":"RATHJE CONSTRUCTION","difference":"0.00","pay_apps_payment_due_2021_on":"1688572.24","payables_lines_to_contractor":"1688572.24"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"original-town-phase-2","contractor":"NOLAN'S LAWN CARE","difference":"5377.44","pay_apps_payment_due_2021_on":"9798.56","payables_lines_to_contractor":"15176.00"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"original-town-phase-3","contractor":"RATHJE CONSTRUCTION","difference":"9024.72","pay_apps_payment_due_2021_on":"2290916.78","payables_lines_to_contractor":"2299941.50"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"permeable-pavers","contractor":"NOLAN'S LAWN CARE","difference":"0.00","pay_apps_payment_due_2021_on":"387231.35","payables_lines_to_contractor":"387231.35"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"potter-creek-interceptor","contractor":"BOOMERANG CORP","difference":"0.00","pay_apps_payment_due_2021_on":"1130450.40","payables_lines_to_contractor":"1130450.40"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"public-works-building","contractor":"WOODRUFF CONSTRUCTION","difference":"629942.08","pay_apps_payment_due_2021_on":"434214.77","payables_lines_to_contractor":"1064156.85"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"recreation-center","contractor":"MIRON CONSTRUCTION CO","difference":"179284.39","pay_apps_payment_due_2021_on":"8775445.72","payables_lines_to_contractor":"8954730.11"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"roberts-ferry-road-reconstruction","contractor":"VIETH CONSTRUCTION CORP","difference":"0.00","pay_apps_payment_due_2021_on":"24591.53","payables_lines_to_contractor":"24591.53"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"roberts-ferry-village-drive-signal","contractor":"NEUMILLER ELECTRIC","difference":"0.00","pay_apps_payment_due_2021_on":"203474.27","payables_lines_to_contractor":"203474.27"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"roundabout-gateway-signage","contractor":"NOLAN'S LAWN CARE","difference":"0.00","pay_apps_payment_due_2021_on":"12720.00","payables_lines_to_contractor":"12720.00"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"roundabout-park-road-hwy6","contractor":"RATHJE CONSTRUCTION","difference":"0.00","pay_apps_payment_due_2021_on":"134610.63","payables_lines_to_contractor":"134610.63"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"soccer-field-parking-lot","contractor":"LL PELLING","difference":"-15133.62","pay_apps_payment_due_2021_on":"15133.62","payables_lines_to_contractor":"0"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"tiffin-heights-west-watermain","contractor":"MAXWELL CONSTRUCTION","difference":"-881593.70","pay_apps_payment_due_2021_on":"881593.70","payables_lines_to_contractor":"0"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"trail-phase-6","contractor":"VIETH CONSTRUCTION CORP","difference":"0.00","pay_apps_payment_due_2021_on":"84739.10","payables_lines_to_contractor":"84739.10"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"trail-phase-7","contractor":"CARTER & ASSOCIATES","difference":"-199208.53","pay_apps_payment_due_2021_on":"284335.24","payables_lines_to_contractor":"85126.71"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"water-treatment-plant-upgrade","contractor":"TRICON CONSTRUCTION GROUP","difference":"0.00","pay_apps_payment_due_2021_on":"9699565.48","payables_lines_to_contractor":"9699565.48"},{"note":"payables cover 2021-2026 lists with coverage < 100% in places; a pay app approved after the newest list is not yet on a list","project":"well-5","contractor":"BOOMERANG CORP","difference":"-16212.32","pay_apps_payment_due_2021_on":"791447.95","payables_lines_to_contractor":"775235.63"}],"pay_application_checks":[{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"kimberlite-street-south","app_number":1,"as_printed":null,"contractor":"ALL AMERICAN CONCRETE","document_id":1831,"meeting_date":"2024-05-07"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"kimberlite-street-south","app_number":2,"as_printed":null,"contractor":"ALL AMERICAN CONCRETE","document_id":1184,"meeting_date":"2024-06-18"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"kimberlite-street-south","app_number":3,"as_printed":null,"contractor":"ALL AMERICAN CONCRETE","document_id":1091,"meeting_date":"2024-09-17"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"kimberlite-street-south","app_number":4,"as_printed":null,"contractor":"ALL AMERICAN CONCRETE","document_id":1697,"meeting_date":"2024-11-05"},{"issues":["previous payments 546457.19 != pay app #2 earned less retainage 546428.09"],"project":"north-park-road","app_number":3,"as_printed":null,"contractor":"BOOMERANG CORP","document_id":1014,"meeting_date":"2025-06-03"},{"issues":["staff memo amount 273423.31 != form payment due 236373.31"],"project":"original-town-phase-3","app_number":9,"as_printed":"as printed by the city: the staff memo's $273,423.31 is a typo; the form's $236,373.31 was paid","contractor":"RATHJE CONSTRUCTION","document_id":892,"meeting_date":"2025-09-16"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"public-works-building","app_number":1,"as_printed":null,"contractor":"WOODRUFF CONSTRUCTION","document_id":2692,"meeting_date":"2022-03-01"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"public-works-building","app_number":4,"as_printed":null,"contractor":"WOODRUFF CONSTRUCTION","document_id":2551,"meeting_date":"2022-06-21"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"public-works-building","app_number":11,"as_printed":null,"contractor":"WOODRUFF CONSTRUCTION","document_id":2478,"meeting_date":"2023-01-17"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"public-works-building","app_number":12,"as_printed":null,"contractor":"WOODRUFF CONSTRUCTION","document_id":2429,"meeting_date":"2023-02-21"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"public-works-building","app_number":13,"as_printed":null,"contractor":"WOODRUFF CONSTRUCTION","document_id":2395,"meeting_date":"2023-03-21"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"public-works-building","app_number":14,"as_printed":null,"contractor":"WOODRUFF CONSTRUCTION","document_id":2185,"meeting_date":"2023-08-08"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"public-works-building","app_number":15,"as_printed":null,"contractor":"WOODRUFF CONSTRUCTION","document_id":2184,"meeting_date":"2023-08-08"},{"issues":["staff memo amount 866077.46 != form payment due 1109989.94"],"project":"recreation-center","app_number":9,"as_printed":"as printed by the city: the staff memo's $866,077.46 is the work this period; the form's payment due ($1,109,989.94) was paid","contractor":"MIRON CONSTRUCTION CO","document_id":649,"meeting_date":"2026-02-17"},{"issues":["no labelled amounts read (form image without text, or an unknown form)"],"project":"sand-volleyball-courts","app_number":1,"as_printed":null,"contractor":"COURTS FORE SPORTS","document_id":765,"meeting_date":"2025-12-02"},{"issues":["staff memo amount 86715.70 != form payment due 1178412.67"],"project":"water-treatment-plant-upgrade","app_number":8,"as_printed":"as printed by the city: the staff memo's $86,715.70 is the stored-materials total; the form's payment due ($1,178,412.67) was paid","contractor":"TRICON CONSTRUCTION GROUP","document_id":501,"meeting_date":"2026-05-05"},{"issues":["contract to date 5798931.95 != original 5685007.75 + change orders 112924.00"],"project":"wwtp-phase-2","app_number":23,"as_printed":null,"contractor":"PORTZEN CONSTRUCTION","document_id":1347,"meeting_date":"2021-01-19"}]}}