city_council

Custom SQL query

Tables

items

id, name, ayes, nays, majority

1,131 rows

meetings

date, name

262 rows

votes

id, councilmember, item, vote

5,401 rows

items_fts (hidden)

name, items_fts, rank

1,131 rows

items_fts_config (hidden)

k, v

1 row

items_fts_data (hidden)

id, block

25 rows

items_fts_docsize (hidden)

id, sz

1,131 rows

items_fts_idx (hidden)

segid, term, pgno

23 rows

Download SQLite DB: city_council.db 780.0 KB