items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where member_id = "uk.org.publicwhip/member/40594" and sort_order = 9 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
cafb22d176b09b72f8755da94f32bcbe864b3a6c | January 2014, 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 | 9 | 2015-01-06-1f359ece-10080-0 |
d22afb149fbd9a220c013fada3951249f43f54d6 | Donor status: company, registration 01074356 | Sponsorships 8f616a6e | 2015-01-06 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2015-01-06-8f616a6e-10080-0 |
288544e2ae337627c9e8060bbce830b219204a0a | January 2014, 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 | 9 | 2014-12-08-1f359ece-10080-0 |
bfac6ea0e5e1d9ced7c013a049277e551ce73491 | Donor status: company, registration 01074356 | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2014-12-08-8f616a6e-10080-0 |
43d033d5001574e7fb8f92db544ed7db90861592 | January 2014, 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 | 9 | 2014-11-24-1f359ece-10080-0 |
eac8d13c04bcf2d1cc1a1df2be93742bd8f23b77 | January 2014, 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 | 9 | 2014-11-10-1f359ece-10080-0 |
58ecc718f44a23a529704a7865f3405fffd34a39 | January 2014, 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 | 9 | 2014-10-27-1f359ece-10080-0 |
502e8a7c89f74d9c60b15c0da636084cea7e94ca | January 2014, 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 | 9 | 2014-10-13-1f359ece-10080-0 |
84e727f858820c36349e033bc9fec6144f809209 | January 2014, 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 | 9 | 2014-09-22-1f359ece-10080-0 |
9f0540c92b5d8ed95b72761a7a08847f67dd4f2d | January 2014, 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 | 9 | 2014-08-26-1f359ece-10080-0 |
67ac07dab6fd617277a7645f26074195a2c2ad66 | January 2014, 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 | 9 | 2014-07-28-1f359ece-10080-0 |
6b9774a20c0fcccc4e65205b592822495a62da5e | January 2014, 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 | 9 | 2014-07-14-1f359ece-10080-0 |
452e54e9a52e86abc8e576178a8a6c3c5e9cafdb | January 2014, 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 | 9 | 2014-06-30-1f359ece-10080-0 |
083bd95b93ddbc03517808f3e3cff5ad6b363936 | January 2014, 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 | 9 | 2014-06-16-1f359ece-10080-0 |
28201095c6b52637295c1b7e1bbf27c8a6dcae0f | January 2014, 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 | 9 | 2014-06-02-1f359ece-10080-0 |
c27cff05514784a3994559d446b25525cfe13cea | November 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 | 9 | 2014-05-12-1f359ece-10080-0 |
4bbf3a06f59966be7bbb34cb6fde0e6d411097c8 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2011-05-16 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2011-05-16-9e46def6-10080-0 |
c958bdb093bcba2c49492966d20abcdd421bd371 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2011-05-03 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2011-05-03-9e46def6-10080-0 |
a0b105463cd550491a1b080d4589c51421c7d521 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2011-04-18 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2011-04-18-9e46def6-10080-0 |
92b3dd3b2943d4adc083ac6ffa395ad795050754 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2011-03-28 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2011-03-28-9e46def6-10080-0 |
c5be30737ba953f7eac13402a07bb717ab203e37 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2011-03-14 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2011-03-14-9e46def6-10080-0 |
24b2a747b94bf3620c830289128d584bea4ad297 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2011-02-28-9e46def6-10080-0 |
ffaf36531fa2342d32ef456a932b6fed5f2f18c4 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2011-02-07 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2011-02-07-9e46def6-10080-0 |
f42c2f73f5bbe5ceeb7c3493638a52b4ad57e91e | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2011-01-24-9e46def6-10080-0 |
aec6f2eb327aed3826c5cc63c9daf1d2698ebf34 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2011-01-10-9e46def6-10080-0 |
84c97261007ff99f2e69898b9e549390fe3f723b | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2010-12-20 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2010-12-20-9e46def6-10080-0 |
ce49fe9183402cf11c63f915d9cfe25848401a6d | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2010-12-06 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2010-12-06-9e46def6-10080-0 |
1af5b2f18a82d9e85743015359d16e635bde6a4a | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2010-11-22 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2010-11-22-9e46def6-10080-0 |
17003e7ebc9297a195526a8ba0be677081e77490 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2010-11-08-9e46def6-10080-0 |
324c52f5edd2ce4011619ca0ddc316d7eeefb038 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2010-10-25 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2010-10-25-9e46def6-10080-0 |
f88c69c465d11a3f42d6b70a2426f4aa8f859601 | Amount of donation or nature and value if donation in kind: £2,500 donation to my constituency party | Sponsorship or financial or material support 9e46def6 | 2010-09-06 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2010-09-06-9e46def6-10080-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");