items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2011-11-29-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 |
---|---|---|---|---|---|---|---|
f57191534d68be7a5dfb071dec52f2d7a2d561ec | 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-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2011-11-29-84642823-10314-0 |
825c01182e3f4ce47dd37b87262e46f903449a60 | Date of receipt of donation: 1 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2011-11-29-84642823-10314-0 |
38e32433ecb7298a8747f266bdedf4e62ee07e9a | Date of acceptance of donation: 1 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2011-11-29-84642823-10314-0 |
24d12252586b8d7e69718580cfda07dbd60a855c | (Registered 10 February 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2011-11-29-84642823-10314-0 |
d8da18e84a9993bf5e8f924a977d24318521581b | Name of donor: Daily Mirror | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 7 | 2011-11-29-84642823-10314-0 |
6012e33c81153972abbec4f0b8f11ba4fb8121e9 | Address of donor : MGN Limited, One Canada Square, Canary Wharf, London E14 5AP. | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 8 | 2011-11-29-84642823-10314-0 |
0093511f9587a15ed30e4fbe5c3c95d4eefb95d4 | 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-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 9 | 2011-11-29-84642823-10314-0 |
e6be73b19d2c806b72d54e75599dc4b8e0298c37 | Date of receipt of donation: 8 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 10 | 2011-11-29-84642823-10314-0 |
646d452c7cb9b2ad134a967686eaeebc8e1d19ac | Date of acceptance of donation: 8 November 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 11 | 2011-11-29-84642823-10314-0 |
fdbe1d368853b0d3202e47af422b2eca0be8ebce | Donor status: company | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 12 | 2011-11-29-84642823-10314-0 |
294019a16cc5a89a5b4559a8cda11e5f31483ffb | (Registered 10 February 2011 ) | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 13 | 2011-11-29-84642823-10314-0 |
fb6d6956646716c6403b9804746d131ea9b89f20 | Name of donor: Phonographic Performance Ltd (PPL) | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 14 | 2011-11-29-84642823-10314-0 |
e1f8f3959e97b0c2584d5bee1f85320a23815f53 | Address of donor : 1 Upper James Street, London W1F 9DE | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 15 | 2011-11-29-84642823-10314-0 |
0a2ca8d60f89f1aeb4ecc06677ab6a92b2783f50 | 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-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 16 | 2011-11-29-84642823-10314-0 |
f3e8cc4e446e05624da57718895399d1b59d995d | Date of receipt of donation: 15 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 17 | 2011-11-29-84642823-10314-0 |
1a04477db118c674fd5c0d4f972e5a3f7d0226ab | Date of acceptance of donation: 15 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 18 | 2011-11-29-84642823-10314-0 |
f2e72d99339bffbf3f854f3b1cdf318a3750f140 | Donor status: company registration number 288046. | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 19 | 2011-11-29-84642823-10314-0 |
0304baf56541a6a77b4424ad87751dcf9c8500f8 | (Registered 6 June 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 20 | 2011-11-29-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");