items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
36 rows where person_id = "uk.org.publicwhip/person/10080" and sort_order = 7 sorted by member_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
f9adf7e71eda9748392883f0614a3170552f9e94 | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2010-09-06 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2010-09-06-9e46def6-10080-0 |
c5f9f2e637fba9cc9797220f337a4f6e053d58c3 | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2010-10-25-9e46def6-10080-0 |
bc333fd5dc895e62933787d2ddbc7262cc02b9ad | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2010-11-08-9e46def6-10080-0 |
ae8bf888e756f03efa62c3a6492134c4284dce96 | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2010-11-22-9e46def6-10080-0 |
eb6263b57b5f966ea71a170b434360710a36bbfb | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2010-12-06 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2010-12-06-9e46def6-10080-0 |
582b7fde497daa58d7e18242e6eecd81c302232f | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2010-12-20 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2010-12-20-9e46def6-10080-0 |
c9581b959009e7ea17a02eb5fda75db1dabde378 | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2011-01-10-9e46def6-10080-0 |
08ea22ddb8928be3c2ac205be08a8b202682f0fa | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2011-01-24-9e46def6-10080-0 |
944654fedb5bb6a7549dde28832d9f39ea1e359c | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2011-02-07 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2011-02-07-9e46def6-10080-0 |
0bd1ab10a25682875a74a2532f277e2d900f781f | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2011-02-28-9e46def6-10080-0 |
0cdd51bdee0c7c50f44877435a3f402614d10ef0 | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2011-03-14 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2011-03-14-9e46def6-10080-0 |
feaec08a6a3962aa733751941c13e483facad731 | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2011-03-28 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2011-03-28-9e46def6-10080-0 |
f65ccdf9dee59c659fc7734109bfc6495043949f | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2011-04-18 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2011-04-18-9e46def6-10080-0 |
d50bbcbc30f3ce114ee16aadfe8c24b7e63cfeec | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2011-05-03 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2011-05-03-9e46def6-10080-0 |
a7a7d7a3215b167af16d9f89e688f0ab8a731cfe | Name of donor: Betterworld Co. | Sponsorship or financial or material support 9e46def6 | 2011-05-16 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2011-05-16-9e46def6-10080-0 |
a0ea821cef9509f85340abfc2179c8b50ee4d6ee | May 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-05-12 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-05-12-1f359ece-10080-0 |
5c54edd3e087d3640e9869a08b70f05b4177a2cf | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-02 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-06-02-1f359ece-10080-0 |
d54ec27e9ebf87d3aa1fa3b88027bee5308fc498 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-06-16-1f359ece-10080-0 |
6e6a4b36beef24911b6c72755e8a4ab6b5176369 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-06-30-1f359ece-10080-0 |
005dfd4349ac88bf78f010da765c97a01fe9a0f5 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-07-14-1f359ece-10080-0 |
ef59ce3bf165f8d2034dbf044c7667380c67a755 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-07-28 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-07-28-1f359ece-10080-0 |
ce41675cc2841702fa17e4e6567ed85cc9bf2a21 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-08-26 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-08-26-1f359ece-10080-0 |
942c2c7ddd7425f42036e8bdd92439882e1d2ff3 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-09-22 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-09-22-1f359ece-10080-0 |
2a32a7c553363d985fa19c03b4df7fe6b0f971c6 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-10-13 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-10-13-1f359ece-10080-0 |
764492eb2d09100c1dbe86dab7a312290359ef42 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-10-27 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-10-27-1f359ece-10080-0 |
ca02311fffcaf4113e11638241ff73a92842b9c3 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-11-10 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-11-10-1f359ece-10080-0 |
b306b2e572a8917625ab801d50984d3c7617cbd8 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-11-24-1f359ece-10080-0 |
07c040196a636d1a17ad10c446b0eea7e37c62d7 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-12-08-1f359ece-10080-0 |
a2007cf04bd5b636d9d8383bf5e836d9f2f3678a | Address of donor: St George’s House, Station Approach, Cheam SM2 7AT | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-12-08-8f616a6e-10080-0 |
319b54fe1ad52646cc7f0363f5624e2ce2180f50 | August 2013, payment of £75. Hours: 30 mins. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-01-06 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2015-01-06-1f359ece-10080-0 |
0bc49bb0d5442d2261189fa3cfb5dc0d6970d6d1 | Address of donor: St George’s House, Station Approach, Cheam SM2 7AT | Sponsorships 8f616a6e | 2015-01-06 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2015-01-06-8f616a6e-10080-0 |
2884f9d74aecea3cbf8b04ca5821417dfc0ddf7b | May 2014, payment of £75. Hours: 30 mins. (Registered 16 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-01-26 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2015-01-26-1f359ece-10080-1 |
e30a74bcb766033bf9439f1e5f5caa489547c44c | May 2014, payment of £75. Hours: 30 mins. (Registered 16 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-02-09 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2015-02-09-1f359ece-10080-1 |
b36c9046ee68789d4cd374d1d8f9dd98ff5b2b9d | May 2014, payment of £75. Hours: 30 mins. (Registered 16 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-02-23 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2015-02-23-1f359ece-10080-1 |
f47d0b5edd9a893943ee4c500918d7ea22878edd | May 2014, payment of £75. Hours: 30 mins. (Registered 16 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2015-03-09-1f359ece-10080-1 |
3ffc10e14665a31fc202eb7c488708834476b594 | May 2014, payment of £75. Hours: 30 mins. (Registered 16 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2015-03-30-1f359ece-10080-1 |
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");