It would be nice to add some overall stats (graphs?) to the homepage. Of various SQL statements that pull key information out of the all-time SQLite database. e.g.:
10 largest TIF rebates 2024:
select p.tif_id, total_tif_excess_taxes, county_name, city_name, tif_name, county_number
from project p, year y
where p.tif_id = y.tif_id
and tax_year = 2024
order by total_tif_excess_taxes desc
limit 13;
That could be a little HTML table I guess, summarizing the biggest ones from last year.
(From this first example we could start providing lots of insights from the database, whatever queries we think people might find interesting for the homepage. In pretty charts or whatever.)
It would be nice to add some overall stats (graphs?) to the homepage. Of various SQL statements that pull key information out of the all-time SQLite database. e.g.:
10 largest TIF rebates 2024:
That could be a little HTML table I guess, summarizing the biggest ones from last year.
(From this first example we could start providing lots of insights from the database, whatever queries we think people might find interesting for the homepage. In pretty charts or whatever.)