items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2011-04-18-8f616a6e-24741-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
7187656e750030d6ec25ab24038d09563297fd6f | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2011-04-18-8f616a6e-24741-0 |
eb1be8f0b1e2074e85df9965725686046cf5ac0b | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 1 | 2011-04-18-8f616a6e-24741-0 |
f85dbce652f604d7c7aaa97a7432dea877830567 | Amount of donation or nature and value if donation in kind: £24,185 | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 3 | 2011-04-18-8f616a6e-24741-0 |
eaa560ee4d084d5ce3273a8f03e2738ec0f3f30e | Name of donor: Benson Box Ltd | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 6 | 2011-04-18-8f616a6e-24741-0 |
f85aa4ca6119c9625f2350c12fe84d81d3334060 | Address of donor: Interlink Way, South Bardon Hill, Coalville, Leicestershire | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 7 | 2011-04-18-8f616a6e-24741-0 |
5da966418b8538682f1f26402f97433d0eddafe7 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 8 | 2011-04-18-8f616a6e-24741-0 |
847e30b48b31d7f23b9486696dae4f1edc02e811 | Name of donor: Mr David Wilson | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 11 | 2011-04-18-8f616a6e-24741-0 |
0e4f6f431b7af025d961c1e8e6ac49d41f33a5b5 | Address of donor: private | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 12 | 2011-04-18-8f616a6e-24741-0 |
22d8929d93c1f385382e4d56b8bf2db0af17f70c | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 13 | 2011-04-18-8f616a6e-24741-0 |
2ad27280a38dda563025356019ca0b35f9f5d512 | Name of donor: Harlow Bros Ltd | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 16 | 2011-04-18-8f616a6e-24741-0 |
a214e7b7909aa2a84520325d064fa6e9557967c0 | Address of donor: Long Whatton, Loughborough, Leicestershire LE12 5DE | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 17 | 2011-04-18-8f616a6e-24741-0 |
b23f95d25c93eb42c8529e10f87e18b6618a34e2 | Amount of donation or nature and value if donation in kind: £2,100 | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 18 | 2011-04-18-8f616a6e-24741-0 |
e7cc32962f693033e2f060d85fbd817531fe9eb7 | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 20 | 2011-04-18-8f616a6e-24741-0 |
ae951661fa7399349abae89e56aa1c145f0bb32d | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-04-18-8f616a6e-24741-0 |
00a32fced89324f5791550c1b8d63f160e3517b5 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-04-18-8f616a6e-24741-0 |
3304e62ec27683e81d7b04ec71d91159c3a67d5f | Address of donor: Enterprise House, Repton Road, Westminster Industrial Estate, Measham, Swadlincote, Derbyshire DE12 7DT. | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 23 | 2011-04-18-8f616a6e-24741-0 |
4945990bdc4aa1be83481c698476035be3f53f4c | Amount of donation or nature and value if donation in kind: £800 a month ongoing | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 24 | 2011-04-18-8f616a6e-24741-0 |
9c2c4dd26f8ab5bee277f41779a9a824c58411e2 | Date of receipt: 6 May 2010 | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 25 | 2011-04-18-8f616a6e-24741-0 |
35e98ae90df40b51a2dd64a3b6d69c967131aa19 | Date of acceptance: 6 May 2010 | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 26 | 2011-04-18-8f616a6e-24741-0 |
bf40bc2b635ca2735e3232015cbb8752023031d8 | Donor status: company | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 27 | 2011-04-18-8f616a6e-24741-0 |
a38d66361bd20af7a7607ee763a5b8bbee195e74 | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 28 | 2011-04-18-8f616a6e-24741-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");