items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2011-01-24-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 |
---|---|---|---|---|---|---|---|
9973fc0fb8c3cd138de81bb09d5b9732da30bd14 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2011-01-24-8f616a6e-24741-0 |
5ddc282f6d69b848053a899d73e6c26afe9c0b98 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 1 | 2011-01-24-8f616a6e-24741-0 |
6e21149525f957d26f343d49f3b569cf97d22483 | Amount of donation or nature and value if donation in kind: £24,185 | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 3 | 2011-01-24-8f616a6e-24741-0 |
9e8a13c73fbdcd4c0ac175decce0d80e3b158079 | Name of donor: Benson Box Ltd | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 6 | 2011-01-24-8f616a6e-24741-0 |
f04d2e863354fe248064fcbf3ccab5c9eb9d6420 | Address of donor: Interlink Way, South Bardon Hill, Coalville, Leicestershire | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 7 | 2011-01-24-8f616a6e-24741-0 |
b09d9a3e8fa5632b80c2b7dec097a952479566ea | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 8 | 2011-01-24-8f616a6e-24741-0 |
b0d410901e67e2892e8b5ec08f8f7a7994faa1c9 | Name of donor: Mr David Wilson | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 11 | 2011-01-24-8f616a6e-24741-0 |
88d95c33c60baaf859348995fb3ad951b1abca12 | Address of donor: private | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 12 | 2011-01-24-8f616a6e-24741-0 |
47ed02a0e35e924fac00793edbf50e2eaed82757 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 13 | 2011-01-24-8f616a6e-24741-0 |
89990efaf67ab4537f3b66b1a34770c1770fd677 | Name of donor: Harlow Bros Ltd | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 16 | 2011-01-24-8f616a6e-24741-0 |
a706c73c7617c5fe331f72f84deb4bfd2e13ada3 | Address of donor: Long Whatton, Loughborough, Leicestershire LE12 5DE | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 17 | 2011-01-24-8f616a6e-24741-0 |
14473eae8811f00b102fb817c6eb0e37e198c602 | Amount of donation or nature and value if donation in kind: £2,100 | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 18 | 2011-01-24-8f616a6e-24741-0 |
ef5835f98379857add3ce20b27e71fc9350f878f | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 20 | 2011-01-24-8f616a6e-24741-0 |
943b44b4ad2474be4f209f4d24f8f295779825de | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-01-24-8f616a6e-24741-0 |
533028b20f7c2f48dd8d84c568067c6cafe39278 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-01-24-8f616a6e-24741-0 |
661320c298beca81ee73978c5a10947154988219 | Address of donor: Enterprise House, Repton Road, Westminster Industrial Estate, Measham, Swadlincote, Derbyshire DE12 7DT. | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 23 | 2011-01-24-8f616a6e-24741-0 |
6a29424bf0c414854d55266ae6647f510ea33eee | Amount of donation or nature and value if donation in kind: £800 a month ongoing | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 24 | 2011-01-24-8f616a6e-24741-0 |
dd383bc39c6052a99f8143c1f92d76983c1e0238 | Date of receipt: 6 May 2010 | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 25 | 2011-01-24-8f616a6e-24741-0 |
e54873a23abb573ec04481daa65b5f4aa590e448 | Date of acceptance: 6 May 2010 | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 26 | 2011-01-24-8f616a6e-24741-0 |
1baa24059f988738868102de6eafa0888b6abed9 | Donor status: company | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 27 | 2011-01-24-8f616a6e-24741-0 |
17555c21c33e9f1887e6b597500d2d54615e50fe | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 28 | 2011-01-24-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");