items

Data source: mySociety Data · About: simonw/register-of-members-interests

42 rows where category_id = "e1068736" sorted by date descending

View and edit SQL

Suggested facets: item, date, sort_order, record_id, 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

CSV options:

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");
Powered by Datasette · Query took 20.724ms · Data source: mySociety Data · About: simonw/register-of-members-interests