chi-councilmatic icon indicating copy to clipboard operation
chi-councilmatic copied to clipboard

show relations between bills

Open fgregg opened this issue 8 months ago • 0 comments

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:

https://puddle.bunkum.us/chicago_council-b578309?sql=select+id%2C+identifier%2C+legislative_session%2C+relation_type%2C+bill_id%2C+related_bill_id+from+relatedbill+where+%22bill_id%22+%3D+%27ocd-bill%2Fdd72064a-c1a9-4c0a-868c-7dbc3a85d46c%27+OR+related_bill_id+%3D+%27ocd-bill%2Fdd72064a-c1a9-4c0a-868c-7dbc3a85d46c%27+order+by+id+limit+101

but we are not showing this

(actually there's a problem with this data in puddle as we are showing a circular relationship, but we'll deal with that later)

fgregg avatar Oct 21 '23 11:10 fgregg