New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

show relations between bills #380

Open

fgregg opened this issue Oct 21, 2023 · 0 comments

Member

fgregg commented Oct 21, 2023

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment