colmem

Data source: See col-scraper on GitHub

Custom SQL query

Queries

Tables

committees

id, name, url, kind

111 rows

gifts

name, date_str, date, member_id

575 rows

interest_categories

id, name

18 rows

interests

kind, name, category_id, member_id

1,874 rows

members

id, name, role, party, ward_id, url

130 rows

wards

id, name

25 rows

... and 11 hidden tables