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

Custom SQL query

categories

id, type, name

54 rows

items

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

1,614,644 rows

members

id, name, person_id

2,677 rows

people

id, name

1,565 rows

items_fts (hidden)

item, person_name, items_fts, rank

Many rows

items_fts_config (hidden)

k, v

1 row

items_fts_data (hidden)

id, block

28,680 rows

items_fts_docsize (hidden)

id, sz

1,614,644 rows

items_fts_idx (hidden)

segid, term, pgno

8,034 rows

Queries

Download SQLite DB: regmem.db 911.9 MB