Lawrence & Kansas Civic ReportsHomeWhy Kansas power projects waitKansas peak power demandHome energy costs in Douglas CountyData centers and Kansas home electric billsIs Lawrence's new building code adding homes?How Lawrence fixes streets and pipesAll amendmentsTransit report
Douglas County Energy Costs

Methods

Made by AI agents, with a person directing and checking the work.

How this was made

AI agents found and downloaded the public data, ran the analysis, made the charts and wrote the text. A person set the questions, directed the work and checked the results. Every number traces to a listed source file, automated checks run before each build, and corrections are logged in Amendments. No surveys, interviews or site visits were done.

Approach

Energy burden is total home energy spending divided by total income for a group of homes, as in the DOE LEAD Tool. We used LEAD's 2022 Kansas census-tract file, which splits each tract's homes by income (as a share of the federal poverty level), owner or renter, building age, building type and main heating fuel. Program facts come from the agencies that run the programs. Scenario costs multiply published per-home figures by local counts.

Automated checks (latest run)

[PASS] 1 blanks: tract_table                                     27 rows (expect 27); blank: []; dup: []
[PASS] 1 blanks: out/scenarios.csv                               4 rows
[PASS] 1 blanks: out/lead_burden_by_fpl.csv                      5 rows
[PASS] 1 blanks: out/lowincome_burden_by_area.csv                3 rows
[PASS] 1 blanks: out/summary_numbers.csv                         13 rows
[PASS] 2 totals: LEAD tracts vs LEAD county file                 tracts 49,605 vs county 49,605
[PASS] 2 totals: tract_table vs raw                              49,605 vs 49,605 (rounding tolerance 27)
[PASS] 2 totals: LEAD 2022 vs ACS 2023 households                LEAD 49,605 vs ACS 49,939 (-0.7%, tolerance 3%, different survey years)
[PASS] 2 totals: summary households                              49,605
[PASS] 3 reality: LEAD elec vs EIA-861 EKC 2022 bill             LEAD Douglas $1,262/yr vs EKC $1,550/yr, ratio 0.81 (tolerance 0.75-1.25) FLAG: >15% gap, noted in report limits
[PASS] 3 reality: KS LIEAP reach vs national 17.2% (Urban 2023)  22.8% vs 17.2% (tolerance 10 pts)
[PASS] 4 assumptions.md                                          all items present (the author to review)
[PASS] 5 MOE/flags                                               MOE present for all ACS estimates; 13/27 tracts flagged
[PASS] 6 cleanup                                                 no 0-byte files; 29 raw files read-only
[PASS] 7 provenance                                              all data files in sources.md; all outputs have sidecars
[PASS] 8 history timeline                                        timeline vs newest out file out/scenarios.csv.meta.txt
[PASS] 9 citations                                               15 cited sources all in sources.md; unused: []
[PASS] 10 site                                                   placeholders []; AI note on every page: True

Assumptions

Data

Program figures

Scenarios

Dates