regmem

Data source: mySociety Data · About: simonw/register-of-members-interests

Custom SQL query

categories

id, type, name

54 rows

items

hash, item, category_id, date, member_id, person_id, sort_order, record_id

1,595,437 rows

members

id, name, person_id

2,677 rows

people

id, name

1,565 rows

items_fts (hidden)

item, person_name

Many rows

items_fts_config (hidden)

k, v

1 row

items_fts_data (hidden)

id, block

28,777 rows

items_fts_docsize (hidden)

id, sz

1,595,437 rows

items_fts_idx (hidden)

segid, term, pgno

14,486 rows

Queries

Download SQLite DB: regmem.db 900.7 MB