items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2011-08-30-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 |
---|---|---|---|---|---|---|---|
47e8eb6ce5a37e2779bed5c27bf8f3b107f873ca | 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-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2011-08-30-84642823-10314-0 |
3495b909c01c19aa707998b8792c8ab73593cf38 | Date of receipt of donation: 1 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2011-08-30-84642823-10314-0 |
23dfcacf9b74e6ed3600a952faa9a5d0094dc875 | Date of acceptance of donation: 1 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2011-08-30-84642823-10314-0 |
3f58e1bf665b5983564fec83096f7686678c2db6 | (Registered 10 February 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2011-08-30-84642823-10314-0 |
5acf5c00fd9cc4f6cb940ee9e69bdad2358c71c3 | Name of donor: Daily Mirror | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 7 | 2011-08-30-84642823-10314-0 |
cd415eb2cf82abd19d6f351be3a8e8c2fe3d1241 | Address of donor : MGN Limited, One Canada Square, Canary Wharf, London E14 5AP. | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 8 | 2011-08-30-84642823-10314-0 |
17736ed6b1aaccbc6f35c97e7bc839592eb5a862 | 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-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 9 | 2011-08-30-84642823-10314-0 |
d5429559965b2cf157083dd37c18e65aa6a64b79 | Date of receipt of donation: 8 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 10 | 2011-08-30-84642823-10314-0 |
01bdf3bc997272a55c1b3831702d8da4a559614e | Date of acceptance of donation: 8 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 11 | 2011-08-30-84642823-10314-0 |
c9d8152a24930a29b3b995d0e6b00384deef2073 | Donor status: company | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 12 | 2011-08-30-84642823-10314-0 |
b96670af11943c451149714934b1f76cddbc5e73 | (Registered 10 February 2011 ) | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 13 | 2011-08-30-84642823-10314-0 |
7df0a8ad84b0e282b3b6a4d392895496302179f9 | Name of donor: Phonographic Performance Ltd (PPL) | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 14 | 2011-08-30-84642823-10314-0 |
994144cdddd3581986ef9cd56cd40d1e684c6119 | Address of donor : 1 Upper James Street, London W1F 9DE | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 15 | 2011-08-30-84642823-10314-0 |
81e2259ac95604ba999065a1d4d02215559b36b3 | 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-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 16 | 2011-08-30-84642823-10314-0 |
b28e0d4727a48dc09b97d8a2c6a79f2ed647909b | Date of receipt of donation: 15 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 17 | 2011-08-30-84642823-10314-0 |
b26c0f5fa30911b150d378b316f6a3abcdee06ce | Date of acceptance of donation: 15 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 18 | 2011-08-30-84642823-10314-0 |
e60c054038224d30eaaba4db6680467293056d4a | Donor status: company registration number 288046. | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 19 | 2011-08-30-84642823-10314-0 |
185aef78607a0ebc24bac32c5ffb9b926ffd5e5e | (Registered 6 June 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-08-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 20 | 2011-08-30-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");