items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2012-01-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 |
---|---|---|---|---|---|---|---|
0136c738f2226c5ac2078e2160d4e218477afa31 | 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 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2012-01-30-84642823-10314-0 |
80ee38786bd4fc4fce71079c921ddb4351ec76a9 | Date of receipt of donation: 1 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2012-01-30-84642823-10314-0 |
aa4aba0d05d5955493abcb731d096706db64d20a | Date of acceptance of donation: 1 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2012-01-30-84642823-10314-0 |
db7ef1f9b0cc4b0dd7225db5ebc90ea3916ea699 | (Registered 10 February 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2012-01-30-84642823-10314-0 |
99910c9a0a056ff8076b1b1b8908a40b03e3e516 | Name of donor: Daily Mirror | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 7 | 2012-01-30-84642823-10314-0 |
b81f23b446240d744e5ee3f35696b04afda9273c | Address of donor : MGN Limited, One Canada Square, Canary Wharf, London E14 5AP. | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 8 | 2012-01-30-84642823-10314-0 |
0d930e9fa882083b6247b9529dc904163466e597 | 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 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 9 | 2012-01-30-84642823-10314-0 |
ba13b60003adbf4e180a51b696435b052717d55f | Date of receipt of donation: 8 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 10 | 2012-01-30-84642823-10314-0 |
f9098b1f7875edbb2f4b1965a56ff51679302e07 | Date of acceptance of donation: 8 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 11 | 2012-01-30-84642823-10314-0 |
0246d1d9811927b848b1058379661ec16c28d0b0 | Donor status: company | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 12 | 2012-01-30-84642823-10314-0 |
95f1890a7837b6ed1080c9888bee48ab3a5e5ed8 | (Registered 10 February 2011 ) | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 13 | 2012-01-30-84642823-10314-0 |
fbdc82559e62e7bd9a59429fa9731d64bc236a34 | Name of donor: Phonographic Performance Ltd (PPL) | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 14 | 2012-01-30-84642823-10314-0 |
c360999ef336d12b4ce2c144dc47e53ef867a4e5 | Address of donor : 1 Upper James Street, London W1F 9DE | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 15 | 2012-01-30-84642823-10314-0 |
4d34d0df688d19c98e926cdc78a5872779c90492 | 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 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 16 | 2012-01-30-84642823-10314-0 |
95a62da1a75a676fd357e971e07a09c1fb3cdfc8 | Date of receipt of donation: 15 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 17 | 2012-01-30-84642823-10314-0 |
f90bff4d4b42646406e860a486537feefa82b6a3 | Date of acceptance of donation: 15 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 18 | 2012-01-30-84642823-10314-0 |
755e37e50ad2b05a742afc3d33fc69cfe1a98487 | Donor status: company registration number 288046. | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 19 | 2012-01-30-84642823-10314-0 |
087aee5e31dbeac0efe5c895e91bfe09441415bf | (Registered 6 June 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 20 | 2012-01-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");