items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2011-03-28-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 |
---|---|---|---|---|---|---|---|
861c6bff912065efa38ad9701a7ee5e1f67368e0 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2011-03-28-8f616a6e-24741-0 |
5ef2ab92079357c34f51c4dd858b5f12a03360c1 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 1 | 2011-03-28-8f616a6e-24741-0 |
005fe49995f3fdd0e874e791685d1947ad6e7c37 | Amount of donation or nature and value if donation in kind: £24,185 | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 3 | 2011-03-28-8f616a6e-24741-0 |
b0f70c457cd5d4bb22df81fef73747f388633a3f | Name of donor: Benson Box Ltd | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 6 | 2011-03-28-8f616a6e-24741-0 |
41ac91ce64a243f8c7738db9f78d65b7e582a137 | Address of donor: Interlink Way, South Bardon Hill, Coalville, Leicestershire | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 7 | 2011-03-28-8f616a6e-24741-0 |
c8e8ad5fb5edcf7d60d4ff0693f0b43894693308 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 8 | 2011-03-28-8f616a6e-24741-0 |
99cafcd605d4f72b0b9e60a4858b6b021435ff3a | Name of donor: Mr David Wilson | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 11 | 2011-03-28-8f616a6e-24741-0 |
9d8e4fffd0079a6b43a9a4cad842816c1de98962 | Address of donor: private | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 12 | 2011-03-28-8f616a6e-24741-0 |
d1ea1e0c31ad122faf8261c6878b478c0f9dc668 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 13 | 2011-03-28-8f616a6e-24741-0 |
100e54c69ed6c95f598c2a7f280db9d69e7f9fc5 | Name of donor: Harlow Bros Ltd | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 16 | 2011-03-28-8f616a6e-24741-0 |
e54edf51080b453baaa4d3cc06576bb1cc1bae28 | Address of donor: Long Whatton, Loughborough, Leicestershire LE12 5DE | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 17 | 2011-03-28-8f616a6e-24741-0 |
0fe8256c6ee6cfc4111cbf64427887ea664c0121 | Amount of donation or nature and value if donation in kind: £2,100 | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 18 | 2011-03-28-8f616a6e-24741-0 |
0f78746548559c4ddaee42dc5f69c3d618cb027f | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 20 | 2011-03-28-8f616a6e-24741-0 |
b29b716159aaf33b83408c372e80f911b9d05618 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-03-28-8f616a6e-24741-0 |
488db46130830bf17fb77f5601fa23de4e4f52ee | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-03-28-8f616a6e-24741-0 |
eeed1bdb720991222d27d64fe1c770d1c9da30ba | Address of donor: Enterprise House, Repton Road, Westminster Industrial Estate, Measham, Swadlincote, Derbyshire DE12 7DT. | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 23 | 2011-03-28-8f616a6e-24741-0 |
551eb992d597bcbd34e1673a619735a36874c60d | Amount of donation or nature and value if donation in kind: £800 a month ongoing | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 24 | 2011-03-28-8f616a6e-24741-0 |
756061a7cbb1f2ce9be2954b2a8710b77290c7e2 | Date of receipt: 6 May 2010 | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 25 | 2011-03-28-8f616a6e-24741-0 |
aa6ec77a91e75bd23b4a6bb1fb6caef03a74baa7 | Date of acceptance: 6 May 2010 | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 26 | 2011-03-28-8f616a6e-24741-0 |
fd104a1e341899c44552523807ac237c40e5eade | Donor status: company | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 27 | 2011-03-28-8f616a6e-24741-0 |
913b85163c8ab5b78c2bdfd435e08eb147d5837d | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 28 | 2011-03-28-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");