items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
121 rows where member_id = "uk.org.publicwhip/member/40674" and person_id = "uk.org.publicwhip/person/10057" sorted by date descending
This data as json, CSV (advanced)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
acee6823f39097049e64bceac3c1d28e23b8893a | Payment of £75 from on 31 August 2011 from Populus, 10 Northburgh Street, London EC1V 0AT, for participation in research project on 21 June 2011. Hours: 25 mins. (Registered 5 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-09-28 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 1 | 2011-09-28-1f359ece-10057-0 |
c7c58db7ead861420328b1115a0976512b61d5d1 | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-09-28 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-09-28-1f359ece-10057-0 |
aede0d8dcc5fda372cde1b8192e2408e333978d3 | Streetbook Ltd. | Shareholdings 5b34324e | 2011-08-30 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-08-30-5b34324e-10057-0 |
cd5fc8a47094f98f77cd1ee5f7d64fae1c726a95 | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-08-30 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-08-30-1f359ece-10057-0 |
2ba5215c3049403d8161ad5739bbd660739f963e | Streetbook Ltd. | Shareholdings 5b34324e | 2011-07-19 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-07-19-5b34324e-10057-0 |
b55d6ade908693b9fbf65f83b3b28a77e10d2461 | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-07-19-1f359ece-10057-0 |
140c6dc23d56a8a607d0259e114552fb4b3d4950 | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-07-06-1f359ece-10057-0 |
a8e0bf3eba6ef0ddc350fc1feec1509f225e92e0 | Streetbook Ltd. | Shareholdings 5b34324e | 2011-07-06 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-07-06-5b34324e-10057-0 |
53efae460eb7efe816de67836535df5817d5d5ce | Streetbook Ltd. | Shareholdings 5b34324e | 2011-06-20 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-06-20-5b34324e-10057-0 |
97b8b8b459ff7d1e07e7e2fa8174e7ff20f1457e | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-06-20-1f359ece-10057-0 |
1589f1b61db8afca6eb5c73eca70c0473b626764 | Streetbook Ltd. | Shareholdings 5b34324e | 2011-06-06 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-06-06-5b34324e-10057-0 |
d0b64881a804b1ada861848f04b56ac40d9c2c7b | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-06-06-1f359ece-10057-0 |
0757f500992fa93e3bcd29dac57c7e0b5296f2e9 | Streetbook Ltd. | Shareholdings 5b34324e | 2011-05-16 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-05-16-5b34324e-10057-0 |
37dac0000fef2b6c952bbe5802601d214700791b | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-05-16-1f359ece-10057-0 |
ecb2c8ad0417c2e2a0f6089fb15570edba8efd75 | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-05-03-1f359ece-10057-0 |
fce35f646a17a43147b31034c34fdcbf953ddffe | Streetbook Ltd. | Shareholdings 5b34324e | 2011-05-03 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-05-03-5b34324e-10057-0 |
51a889ead359d240f767b357e8dfaad71ca77e8d | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-04-18-1f359ece-10057-0 |
86666b62cca9a89a32283b728fa8a056bc536bf7 | Streetbook Ltd. | Shareholdings 5b34324e | 2011-04-18 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-04-18-5b34324e-10057-0 |
60ebfeca51df6620232df30ae3e5e9481cf79f57 | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-03-28-1f359ece-10057-0 |
e60eb5c4e99fb37f877284ae037b4e1bff850949 | Streetbook Ltd. | Shareholdings 5b34324e | 2011-03-28 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-03-28-5b34324e-10057-0 |
7c71265fc1ff0dee7b3f5be313022c0eff7ae205 | Payment of £350 from The Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an obituary in December 2010. Hours: 10 hrs. (Registered 14 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-03-14-1f359ece-10057-0 |
91001689f7a900be91259bf80fbe7f3eeb1d4f07 | Streetbook Ltd. | Shareholdings 5b34324e | 2011-03-14 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-03-14-5b34324e-10057-0 |
3b765d7653f81bd96a7d4e01e126a8ad7dd63a28 | Streetbook Ltd. | Shareholdings 5b34324e | 2011-02-28 | Peter Bottomley uk.org.publicwhip/member/40674 | Peter Bottomley uk.org.publicwhip/person/10057 | 0 | 2011-02-28-5b34324e-10057-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");