home

Menu
  • GraphQL API

regmem

Table actions
  • GraphQL API for regmem

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

Custom SQL query

Queries

  • mps_ranked_by_matching_overseas_line_items
  • mps_ranked_by_matching_shareholdings

Tables

categories

id, type, name

56 rows

items

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

1,873,669 rows

members

id, name, person_id

2,677 rows

people

id, name

1,581 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

35,351 rows

items_fts_docsize (hidden)

id, sz

1,873,669 rows

items_fts_idx (hidden)

segid, term, pgno

11,797 rows

Download SQLite DB: regmem.db 1.0 GB

Powered by Datasette · Queries took 66.751ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette