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

committee_membership (hidden)

committee_id, member_id, role

1,193 rows

gifts_fts (hidden)

name, member

Many rows

gifts_fts_docsize (hidden)

docid, size

575 rows

gifts_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

gifts_fts_segments (hidden)

blockid, block

10 rows

gifts_fts_stat (hidden)

id, value

1 row

interests_fts (hidden)

name, category, member

Many rows

interests_fts_docsize (hidden)

docid, size

1,874 rows

interests_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

interests_fts_segments (hidden)

blockid, block

31 rows

interests_fts_stat (hidden)

id, value

1 row