items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where item = "(Registered 22 June 2010)" and person_id = "uk.org.publicwhip/person/10329" sorted by hash
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
021bb92111b968316c4c2ad7c749dcc6632e7874 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-02-07 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-02-07-8f616a6e-10329-0 |
04865bcf9c76bcdf4aaf107deda21bab3d33c546 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-01-24 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-01-24-8f616a6e-10329-0 |
0ed1d81f3c27f235756c8f4f759f602866464b92 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-04-18 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-04-18-8f616a6e-10329-0 |
2790794b592da5dfa61b8c3a924b0835269f27f2 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-10-25 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-10-25-8f616a6e-10329-0 |
2b2c0c3741f2f416604b625b49e01e93d4e5ba75 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-12-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-12-20-8f616a6e-10329-0 |
510098cd8b51b9c95e742771d220abba86afdb53 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-06-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-06-20-8f616a6e-10329-0 |
6205047d0861878102af46dfa25e8cbd9a0f5679 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-01-10 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-01-10-8f616a6e-10329-0 |
72c4fa00865a3aefbe22667a69b6d4ef9c2c4424 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-11-08 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-11-08-8f616a6e-10329-0 |
790a40033f2ee18cc693947a12bf0a5e7134126a | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-09-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-09-06-8f616a6e-10329-0 |
7e6c03cc935a9223aa1a680ca82c853fa2917331 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-11-22 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-11-22-8f616a6e-10329-0 |
80261f934c8b885993355ef2cd6b648d4fd99d73 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-02-28 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-02-28-8f616a6e-10329-0 |
a50ef7cee5fa8c037705983bab902aaa86570afb | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-06-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-06-06-8f616a6e-10329-0 |
a860666874e445740ef8124c472e388b369133f4 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-05-16 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-05-16-8f616a6e-10329-0 |
b0ba4286ac5eaeb39593c3d742b772cc074e14fe | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-12-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-12-06-8f616a6e-10329-0 |
b66a05654b3d9e57819837a0c46daca5fef8a642 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-03-28 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-03-28-8f616a6e-10329-0 |
c50ec5320b8b41bdd38e3501bbe3dec4cf75e19b | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-03-14 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-03-14-8f616a6e-10329-0 |
d6594229d9ebebccabab64b5e43017061f4e83ca | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-05-03 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-05-03-8f616a6e-10329-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE items ( hash VARCHAR(40) NOT NULL, item TEXT, category_id TEXT, date TEXT, member_id TEXT, person_id TEXT, sort_order INTEGER, record_id TEXT, PRIMARY KEY (hash), FOREIGN KEY ("category_id") REFERENCES [categories](id), FOREIGN KEY ("member_id") REFERENCES [members](id), FOREIGN KEY ("person_id") REFERENCES [people](id) ); CREATE INDEX items_date ON items("date"); CREATE INDEX items_category_id ON items("category_id"); CREATE INDEX items_member_id ON items("member_id"); CREATE INDEX items_person_id ON items("person_id"); CREATE INDEX items_record_id ON items("record_id");