items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2013-08-27-4f1e6359-11455-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
76c55bf181779220d3b1e1480a5460f799b53a2c | Part-share of house in Luton. | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2013-08-27-4f1e6359-11455-0 |
b397c9648040d63cdc3d61a80e5d38415b470153 | McCARTNEY , Jason (Colne Valley) | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2013-08-27-4f1e6359-11455-0 |
8b1b0bbf7eedad7c04c64d33fd90166d0c0087a8 | 2. Remunerated employment, office, profession etc | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2013-08-27-4f1e6359-11455-0 |
0006e3de7e0e2f7853a8c97d827452912ee8d739 | Payments from ComRes, Four Millbank, London SW1P 3JA: | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2013-08-27-4f1e6359-11455-0 |
d7c38e4222dfbfe30ee04e9c1d693f68317f1e53 | Payment of £600 for completing eight opinion surveys between April 2012 and February 2013. Hours: 4 hrs in total. Payment donated to charity. (Registered 18 April 2013) | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2013-08-27-4f1e6359-11455-0 |
5f20e8d86d74344d3ffb785adb552becb368f467 | Payment from Ipsos MORI, 79-81 Borough Road, London SE1 1FY: | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2013-08-27-4f1e6359-11455-0 |
11d2e4881b615a7b130b0080cca3b02115c29bf4 | Payment of £150 for opinion survey. Hours: 1 hr. Payment donated to charity. (Registered 26 November 2012) | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2013-08-27-4f1e6359-11455-0 |
bb046233215c6b53f9b1b4e202207ada88a23a7e | 6. Overseas visits | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2013-08-27-4f1e6359-11455-0 |
72b5a628c668e94cd5244608b5e8e898f0ec519d | Name of donor: Kurdistan Regional Government | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2013-08-27-4f1e6359-11455-0 |
46674151b8338ea8827f6eba3968681c2e42e3b9 | Address of donor: Kurdistan Regional Government UK Representation at 4th Floor, 23 Buckingham Gate, London SW1E 6LB | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2013-08-27-4f1e6359-11455-0 |
abe4830109b7e1786ccf7593c44bdfbb836beb3f | Amount of donation (or estimate of the probable value): Travel and accommodation with an estimated value of £1,400 | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2013-08-27-4f1e6359-11455-0 |
7bcd8e84d2f93509a8e886970e41e86efecd0b49 | Destination of visit: Kurdistan region of Iraq | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2013-08-27-4f1e6359-11455-0 |
bfa69c5b08a944bb9ffb7849edb8de40558771cc | Date of visit: 31 May to 3 June 2013 | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2013-08-27-4f1e6359-11455-0 |
495c62283c0245293dbb3f1183b3d66447aa59c1 | Purpose of visit: Factfinding visit to meet senior officials, the Bishop of Erbil and civic groups, and to visit the Syrian refugee camp at Domiz | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2013-08-27-4f1e6359-11455-0 |
6fbbbe51668711e53e326f062d1da29438b22721 | (Registered 20 June 2013) | Land and Property 4f1e6359 | 2013-08-27 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2013-08-27-4f1e6359-11455-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");