items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where person_id = "uk.org.publicwhip/person/24741" and sort_order = 21 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
ab3a4ce58242b87e668c76d72cc7a8af64bd9772 | 13 July 2016, received £80 for survey completed on 10 May 2016. Hours: 30 mins. (Registered 08 September 2016) | Employment and earnings 10057ffd | 2016-10-17 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2016-10-17-10057ffd-24741-0 | |
a2e11ee8d8e1b81454252b74dec2429635b30d1e | 13 July 2016, received £80 for survey completed on 10 May 2016. Hours: 30 mins. (Registered 08 September 2016) | Employment and earnings 10057ffd | 2016-10-03 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2016-10-03-10057ffd-24741-0 | |
ad60c65f75c5c0a6068165357260e824d0a34f54 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-05-16 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-05-16-8f616a6e-24741-0 |
35fc86d33a9b6227dbcbda1de10d4dec8f34e263 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-05-03 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-05-03-8f616a6e-24741-0 |
ae951661fa7399349abae89e56aa1c145f0bb32d | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-04-18-8f616a6e-24741-0 |
b29b716159aaf33b83408c372e80f911b9d05618 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-03-28-8f616a6e-24741-0 |
f34f04d97a18cba36a9809a00320d1d5d5f0c1c2 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-03-14 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-03-14-8f616a6e-24741-0 |
d2b72674766d49a18cb434387b87b5c6f6c83a8e | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-02-28-8f616a6e-24741-0 |
d4dab4b7c3d2c51bc7245a1e6a12954ad104ae69 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-02-07 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-02-07-8f616a6e-24741-0 |
943b44b4ad2474be4f209f4d24f8f295779825de | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-01-24-8f616a6e-24741-0 |
3bf2230583ce53d32103f5f84c960867c8651235 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-01-10 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-01-10-8f616a6e-24741-0 |
9b192cd9bf1d38b3b187d2ec24212650dd08f292 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2010-12-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2010-12-20-8f616a6e-24741-0 |
0d1b1e88a461c92fdfb457810bdd8f81cd110467 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2010-12-06 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2010-12-06-8f616a6e-24741-0 |
649e7dda58ba0780e6edbb36fbaf2e621dd8f453 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2010-11-22 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2010-11-22-8f616a6e-24741-0 |
bf6b3b8d7281f84962afe815fadb5ece4eec2cb7 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2010-11-08 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2010-11-08-8f616a6e-24741-0 |
4141e1f6bb6af034afb3d17f0e7f1272fc03f952 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2010-10-25 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2010-10-25-8f616a6e-24741-0 |
53007aacf610b16efdfed93d97eeb8f6253c7326 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2010-09-06 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2010-09-06-8f616a6e-24741-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");