reconstruct missing agendas for events

[fgregg]

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

[fgregg]

here's an example of what this could look like.

https://puddle.bunkum.us/chicago_council-b433a98?sql=select+bill.identifier%2C+billaction.description%2C+date%2C+event.id+from+event+inner+join+eventparticipant+on+event.id+%3D+event_id+inner+join+billaction+using+%28organization_id%29+inner+join+bill+on+bill_id+%3D+bill.id+where+event.id+%3D+%27ocd-event%2F046c76a5-1b89-4def-96d0-4a5e53dd67ee%27+and+substr%28start_date%2C+1%2C+10%29+%3D+date

[fgregg]

okay, i have the query for this ready: https://github.com/datamade/chicago-council-scrapers/blob/main/scripts/reconstruct_agendas.sql

i haven't run it because we might want to think about if we want to warn users that these are inferred agendas.