chi-councilmatic
chi-councilmatic copied to clipboard
datamade
:eyes: keep tabs on Chicago city council
this query helps find dupe bills between the two lis systems ```sql with dupes as ( select A.id as a_id, B.id as b_id from bill as A inner join bill...
it’s been productive to move the views and templates and such out of django councilmatic. another good step would be to move all possible methods from the django councilmatic models...
here's a source for the URLs http://www.chicityclerk.com/city-council-news-central/council-members Related to #109
we could use a url like this: https://chicityclerkelms.chicago.gov/Matter/?recordNumber=SO2023-0001961 i wonder what the best way to this is. at the database level, or in the app.
pretty often individual bills are rolled up into an omnibus bill. for example this one https://chicago.councilmatic.org/legislation/o2023-0001988/ was rolled into this one https://chicago.councilmatic.org/legislation/so2023-0001961 we are capturing this relationship in the scraper:...
many meetings have missing agendas. we could reconstruct the agendas by looking at what bills had actions in the relevant organization on the meeting day
it would be cool to link to the meeting when bill actions happened.
this is a pretty expensive query to do dynamically and the main reason the home page is so slow
It appears there are persistent "event" links that are used for certain types of meetings. https://twitter.com/forestgregg/status/1583636124060176385
Non-council members are showing up a little weird on their detail pages. No term info and not showing the right title/label: https://chicago.councilmatic.org/person/johnson-brandon-e5293d9f2ef3/ ...