search

datamade / chi-councilmatic

:eyes: keep tabs on Chicago city council
https://chicago.councilmatic.org/
MIT License
24 stars 16 forks source link

recent meetings sometimes do not have attendance data posted yet #310

Closed fgregg closed 1 year ago

fgregg commented 1 year ago

Some of the meetings in December still do not have attendance data available from the Legistar system. (i confirmed this is true, and not a scraper bug)

https://chicago.councilmatic.org/event/committee-on-committees-and-rules-898a1ec7155c/

Let's change the language that we are showing to something like.

"Attendance was not taken for this event or has not been posted by the Clerk's office" Screenshot 2022-12-23 at 14-30-50 Committee on Committees and Rules Event - Chicago Councilmatic

fgregg commented 1 year ago

about 1/4 meetings don't have rollcalls. :(

https://puddle.bunkum.us/chicago_council-2c401e3?sql=select+count%28distinct+event.id%29%2C+count%28distinct+event.id%29+filter+%28where+eventparticipant.id+is+null%29+from+event+left+join+eventparticipant+on+event.id+%3D+event_id+and+entity_type+%3D+%27person%27+where+status+%3D+%27passed%27+and+start_date+%3E+2019%3B