home / regmem

Menu
  • GraphQL API

members

Table actions
  • GraphQL API for members

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

48 rows where name contains "Alan"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, person_id

id ▼ name person_id
uk.org.publicwhip/member/1011 Alan Keen Alan Keen uk.org.publicwhip/person/10329
uk.org.publicwhip/member/1108 Alan Meale Alan Meale uk.org.publicwhip/person/10428
uk.org.publicwhip/member/1112 Alan Milburn Alan Milburn uk.org.publicwhip/person/10434
uk.org.publicwhip/member/1185 Alan Reid Alan Reid uk.org.publicwhip/person/11185
uk.org.publicwhip/member/1226 Alan Simpson Alan Simpson uk.org.publicwhip/person/10541
uk.org.publicwhip/member/1314 Alan Whitehead Alan Whitehead uk.org.publicwhip/person/10630
uk.org.publicwhip/member/1321 Alan Williams Alan Williams uk.org.publicwhip/person/10639
uk.org.publicwhip/member/1404 Alan Beith Alan Beith uk.org.publicwhip/person/10034
uk.org.publicwhip/member/1527 Alan Milburn Alan Milburn uk.org.publicwhip/person/10434
uk.org.publicwhip/member/1584 Alan Keen Alan Keen uk.org.publicwhip/person/10329
uk.org.publicwhip/member/1648 Alan Johnson Alan Johnson uk.org.publicwhip/person/10314
uk.org.publicwhip/member/1708 Alan Meale Alan Meale uk.org.publicwhip/person/10428
uk.org.publicwhip/member/1748 Alan Simpson Alan Simpson uk.org.publicwhip/person/10541
uk.org.publicwhip/member/179 Alan Duncan Alan Duncan uk.org.publicwhip/person/10179
uk.org.publicwhip/member/1795 Alan Duncan Alan Duncan uk.org.publicwhip/person/10179
uk.org.publicwhip/member/1828 Alan Whitehead Alan Whitehead uk.org.publicwhip/person/10630
uk.org.publicwhip/member/1864 Alan Williams Alan Williams uk.org.publicwhip/person/10639
uk.org.publicwhip/member/1887 Alan Campbell Alan Campbell uk.org.publicwhip/person/10086
uk.org.publicwhip/member/1960 Alan Reid Alan Reid uk.org.publicwhip/person/11185
uk.org.publicwhip/member/2017 Alan Haselhurst Alan Haselhurst uk.org.publicwhip/person/10263
uk.org.publicwhip/member/263 Alan Haselhurst Alan Haselhurst uk.org.publicwhip/person/10263
uk.org.publicwhip/member/291 Alan Howarth Alan Howarth uk.org.publicwhip/person/10291
uk.org.publicwhip/member/302 Alan Hurst Alan Hurst uk.org.publicwhip/person/10302
uk.org.publicwhip/member/314 Alan Johnson Alan Johnson uk.org.publicwhip/person/10314
uk.org.publicwhip/member/329 Alan Keen Alan Keen uk.org.publicwhip/person/10329
uk.org.publicwhip/member/40046 Alan Reid Alan Reid uk.org.publicwhip/person/11185
uk.org.publicwhip/member/40073 Alan Beith Alan Beith uk.org.publicwhip/person/10034
uk.org.publicwhip/member/40258 Alan Keen Alan Keen uk.org.publicwhip/person/10329
uk.org.publicwhip/member/40346 Alan Johnson Alan Johnson uk.org.publicwhip/person/10314
uk.org.publicwhip/member/40389 Alan Meale Alan Meale uk.org.publicwhip/person/10428
uk.org.publicwhip/member/40515 Alan Duncan Alan Duncan uk.org.publicwhip/person/10179
uk.org.publicwhip/member/40516 Alan Haselhurst Alan Haselhurst uk.org.publicwhip/person/10263
uk.org.publicwhip/member/40564 Alan Whitehead Alan Whitehead uk.org.publicwhip/person/10630
uk.org.publicwhip/member/40619 Alan Campbell Alan Campbell uk.org.publicwhip/person/10086
uk.org.publicwhip/member/428 Alan Meale Alan Meale uk.org.publicwhip/person/10428
uk.org.publicwhip/member/434 Alan Milburn Alan Milburn uk.org.publicwhip/person/10434
uk.org.publicwhip/member/541 Alan Simpson Alan Simpson uk.org.publicwhip/person/10541
uk.org.publicwhip/member/630 Alan Whitehead Alan Whitehead uk.org.publicwhip/person/10630
uk.org.publicwhip/member/638 Alan Williams Alan Williams uk.org.publicwhip/person/10638
uk.org.publicwhip/member/639 Alan Williams Alan Williams uk.org.publicwhip/person/10639
uk.org.publicwhip/member/724 Alan Beith Alan Beith uk.org.publicwhip/person/10034
uk.org.publicwhip/member/778 Alan Campbell Alan Campbell uk.org.publicwhip/person/10086
uk.org.publicwhip/member/86 Alan Campbell Alan Campbell uk.org.publicwhip/person/10086
uk.org.publicwhip/member/867 Alan Duncan Alan Duncan uk.org.publicwhip/person/10179
uk.org.publicwhip/member/943 Alan Haselhurst Alan Haselhurst uk.org.publicwhip/person/10263
uk.org.publicwhip/member/975 Alan Howarth Alan Howarth uk.org.publicwhip/person/10291
uk.org.publicwhip/member/986 Alan Hurst Alan Hurst uk.org.publicwhip/person/10302
uk.org.publicwhip/member/998 Alan Johnson Alan Johnson uk.org.publicwhip/person/10314

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE members (
        id VARCHAR(50) NOT NULL,
        name TEXT,
        person_id TEXT,
        PRIMARY KEY (id),
        FOREIGN KEY ("person_id") REFERENCES [people](id)
    );
Powered by Datasette · Queries took 33.696ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette