items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2011-12-13-84642823-10314-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 |
---|---|---|---|---|---|---|---|
9ebb1746949930f2631878a2441717740b2afb2b | Amount of donation or nature and value if donation in kind: Music Industry Trust dinner (with my wife); value £700 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2011-12-13-84642823-10314-0 |
870b1fe420b22ebe0a5598286322dc583ec8ffc6 | Date of receipt of donation: 1 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2011-12-13-84642823-10314-0 |
c1618a6694f66b5274fe47c3bfb4068145230911 | Date of acceptance of donation: 1 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2011-12-13-84642823-10314-0 |
69b0a9daae085fa6ca78d4c972a82e2fc01d084d | (Registered 10 February 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2011-12-13-84642823-10314-0 |
5f109dd19d5bff8c3ac2af56c70a90edbe6ab130 | Name of donor: Daily Mirror | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 7 | 2011-12-13-84642823-10314-0 |
96dd663eb7be784b8bdd92aeb08ffb6e8bdaf1be | Address of donor : MGN Limited, One Canada Square, Canary Wharf, London E14 5AP. | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 8 | 2011-12-13-84642823-10314-0 |
0b8cd3c0cd56cbeaf5dc3b0353421a5a1d289cd6 | Amount of donation or nature and value if donation in kind: attendance at Daily Mirror Pride of Britain awards; value in excess of £660 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 9 | 2011-12-13-84642823-10314-0 |
38b61056f295f880815e1d2c6341f34dcc599cec | Date of receipt of donation: 8 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 10 | 2011-12-13-84642823-10314-0 |
aec07cf801744b22ac14a81474a83f6f03536989 | Date of acceptance of donation: 8 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 11 | 2011-12-13-84642823-10314-0 |
2c9f3d3274654d3a7752b986e0eba6ba1eadaa42 | Donor status: company | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 12 | 2011-12-13-84642823-10314-0 |
1a6a4b4e3436b2ac83f22b493c640de67e73cacb | (Registered 10 February 2011 ) | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 13 | 2011-12-13-84642823-10314-0 |
26e2b83af74a0cbcdd29e57a591b5cdf91f53510 | Name of donor: Phonographic Performance Ltd (PPL) | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 14 | 2011-12-13-84642823-10314-0 |
bc10eb6ec36a285d060a8c14c3ef89ec808a7581 | Address of donor : 1 Upper James Street, London W1F 9DE | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 15 | 2011-12-13-84642823-10314-0 |
197601a64a26dacbfabbde5defdf8b6ca1d5c3a2 | Amount of donation or nature and value if donation in kind: attendance at Brit Awards (with my son); value £1,996 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 16 | 2011-12-13-84642823-10314-0 |
e0f8b2655ba8ecb0d5d1f3e3b8cffea8cdaee614 | Date of receipt of donation: 15 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 17 | 2011-12-13-84642823-10314-0 |
c2ab183203b850838eae0e1fc0760d12af2c5781 | Date of acceptance of donation: 15 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 18 | 2011-12-13-84642823-10314-0 |
3de57cd5fb870d99649ff67d637082eb446d54dd | Donor status: company registration number 288046. | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 19 | 2011-12-13-84642823-10314-0 |
59d5def460f00e60f3cd75296595ce160a37be09 | (Registered 6 June 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 20 | 2011-12-13-84642823-10314-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");