items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
42 rows where category_id = "e1068736" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date, sort_order, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
907b236b98a380af75cd8b8e57eb9b5e1b7e487e | Name of donor: Phonographic Performance Ltd (PPL) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-03-11 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2013-03-11-e1068736-10314-0 |
b00bd92c15cfaba56b29107b040da855c713b732 | Address of donor : 1 Upper James Street, London W1F 9DE | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-03-11 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2013-03-11-e1068736-10314-0 |
eecbc59742862eaecad30fd825ad55bcaa91b1a7 | Amount of donation or nature and value if donation in kind: attendance at Brit Awards with my wife; value £1,996 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-03-11 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2013-03-11-e1068736-10314-0 |
7cb04ebd019db0fe86c03202005c6aae9f246624 | Date of receipt of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-03-11 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2013-03-11-e1068736-10314-0 |
f8e8a4e330b11e61710f88acf85c9471732c1a77 | Date of acceptance of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-03-11 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2013-03-11-e1068736-10314-0 |
2e225b43d42ff48a19f4bb09fd7a7e416a7c39aa | Donor status: company registration number 288046. | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-03-11 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 5 | 2013-03-11-e1068736-10314-0 |
02e377a63a64b2e5bb41859ca1474d0077261153 | (Registered 14 March 2012) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-03-11 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2013-03-11-e1068736-10314-0 |
13a7578cbd2c55449ab36f0eaf482addf0938934 | Name of donor: Phonographic Performance Ltd (PPL) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-25 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2013-02-25-e1068736-10314-0 |
2534f9d6fc256aea6dfebc4bd695d88cb2013a89 | Address of donor : 1 Upper James Street, London W1F 9DE | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-25 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2013-02-25-e1068736-10314-0 |
18b5bbc463e293f9762560a9931de5809ccac05d | Amount of donation or nature and value if donation in kind: attendance at Brit Awards with my wife; value £1,996 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-25 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2013-02-25-e1068736-10314-0 |
52a702ae53feb9fad9d68a4e4670874d19904b66 | Date of receipt of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-25 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2013-02-25-e1068736-10314-0 |
26e94b524275515082f731a304861e7dcb74fffe | Date of acceptance of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-25 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2013-02-25-e1068736-10314-0 |
33deabe743ab65ecb489240631c700f65749c157 | Donor status: company registration number 288046. | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-25 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 5 | 2013-02-25-e1068736-10314-0 |
e0c498cc490282be52fd8a7719fac084b82292d4 | (Registered 14 March 2012) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-25 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2013-02-25-e1068736-10314-0 |
b68ef8a7eb6fdc465d9fe67d8cae50e9d4f213d4 | Name of donor: Phonographic Performance Ltd (PPL) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-04 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2013-02-04-e1068736-10314-0 |
5294dec4fa9329c47b8ffb8e404a23a90f8e6013 | Address of donor : 1 Upper James Street, London W1F 9DE | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-04 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2013-02-04-e1068736-10314-0 |
6f012eb238ee88f66924b5ff88a72a33280541d9 | Amount of donation or nature and value if donation in kind: attendance at Brit Awards with my wife; value £1,996 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-04 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2013-02-04-e1068736-10314-0 |
3b31bc141da7af7203734e8fb3d1d87054d19604 | Date of receipt of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-04 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2013-02-04-e1068736-10314-0 |
899f0f1c2b54316a1e06e2bb025467754b7ca95e | Date of acceptance of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-04 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2013-02-04-e1068736-10314-0 |
e8ea135f04c4ffd171b87f711857599fe1e44574 | Donor status: company registration number 288046. | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-04 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 5 | 2013-02-04-e1068736-10314-0 |
c4d8ea8d83eae2f1b9ac9b24077b6f8143aefe70 | (Registered 14 March 2012) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2013-02-04 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2013-02-04-e1068736-10314-0 |
6c621f53b9e4e8b190546744442d7f7f004b47e2 | Name of donor: Phonographic Performance Ltd (PPL) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2012-12-19-e1068736-10314-0 |
70cfd49e3e7037135793adc24c8b8f779f7033b0 | Address of donor : 1 Upper James Street, London W1F 9DE | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2012-12-19-e1068736-10314-0 |
20bb4c1e231bb395ea9e1931f05f343120efdd8c | Amount of donation or nature and value if donation in kind: attendance at Brit Awards with my wife; value £1,996 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2012-12-19-e1068736-10314-0 |
38f8ad9cff9888cd4a6c3649544bd0e4e2232f7b | Date of receipt of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2012-12-19-e1068736-10314-0 |
1eed7453edde5a2dfafd5b74444e498078ca0ff3 | Date of acceptance of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2012-12-19-e1068736-10314-0 |
0e6bc7579ff844b815813df1ebdccb8fe80ff772 | Donor status: company registration number 288046. | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 5 | 2012-12-19-e1068736-10314-0 |
979c2992df1e98902f1b8d0b9307766bbbe54b81 | (Registered 14 March 2012) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2012-12-19-e1068736-10314-0 |
53f62ddb23e13f4d004c69c79321b1ac7b196e33 | Name of donor: Phonographic Performance Ltd (PPL) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-03 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2012-12-03-e1068736-10314-0 |
d293326d16554ff28e62b389d2e995df44d04256 | Address of donor : 1 Upper James Street, London W1F 9DE | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-03 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2012-12-03-e1068736-10314-0 |
8e9ba80157ebe409ae1f72c8ab335b6f112e40df | Amount of donation or nature and value if donation in kind: attendance at Brit Awards with my wife; value £1,996 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-03 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2012-12-03-e1068736-10314-0 |
a4d4eafd222ac49fa473f4733c896adfa284658d | Date of receipt of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-03 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2012-12-03-e1068736-10314-0 |
ae7f210db2e147d7132cf6bf60405b65ccd99f58 | Date of acceptance of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-03 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2012-12-03-e1068736-10314-0 |
8c4cf695d57b49e9c117de48173f2806e83573f6 | Donor status: company registration number 288046. | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-03 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 5 | 2012-12-03-e1068736-10314-0 |
27100fdae3dfc12d32896065088088b56abcb455 | (Registered 14 March 2012) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-12-03 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2012-12-03-e1068736-10314-0 |
8e65dbf891a92c522e67892dae3ee8c1cc870d04 | Name of donor: Phonographic Performance Ltd (PPL) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-11-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2012-11-19-e1068736-10314-0 |
d3883c96dd979faf36adbae7797369a82bb309bf | Address of donor : 1 Upper James Street, London W1F 9DE | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-11-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2012-11-19-e1068736-10314-0 |
40effc38abe8c0fce778edd578eb09bd28654b62 | Amount of donation or nature and value if donation in kind: attendance at Brit Awards with my wife; value £1,996 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-11-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2012-11-19-e1068736-10314-0 |
e5681b534ecc4ce89d8e104154041f87c6d70808 | Date of receipt of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-11-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2012-11-19-e1068736-10314-0 |
6075768be52c055e0a1e14e67e7720f33004df7f | Date of acceptance of donation: 21 February 2012 | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-11-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2012-11-19-e1068736-10314-0 |
303e11add48b85137e736ea261a9130521fa9748 | Donor status: company registration number 288046. | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-11-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 5 | 2012-11-19-e1068736-10314-0 |
d4ae2eb51c58d1d34e04fa10cd76e4ea7dd9c153 | (Registered 14 March 2012) | Gifts, benefits and hospitality (UK) Hours: 8 hrs. e1068736 | 2012-11-19 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2012-11-19-e1068736-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");