items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2011-02-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 |
---|---|---|---|---|---|---|---|
4930e2df4c28d07c50e9d680352942cb2cdcdc2d | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2011-02-28-8f616a6e-24741-0 |
01d6b3645e130a75b7a52e746f5457fcc9d5c3b4 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 1 | 2011-02-28-8f616a6e-24741-0 |
ab032036a409ace7f600da21cf23f91c30d6db91 | Amount of donation or nature and value if donation in kind: £24,185 | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 3 | 2011-02-28-8f616a6e-24741-0 |
c79adf3f26df49a279265d9d36f580f61bb58f03 | Name of donor: Benson Box Ltd | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 6 | 2011-02-28-8f616a6e-24741-0 |
158017d71f75b6745024cd4dfde4044215bb76e1 | Address of donor: Interlink Way, South Bardon Hill, Coalville, Leicestershire | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 7 | 2011-02-28-8f616a6e-24741-0 |
56e4ea5f40203f5af2447fdc4041983b1252bd17 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 8 | 2011-02-28-8f616a6e-24741-0 |
0ccba948a6ed4eb142c51ae6d44a5daf06392991 | Name of donor: Mr David Wilson | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 11 | 2011-02-28-8f616a6e-24741-0 |
31a1d8e8e0b3348eafe4aa4d1bacd6da35cc593f | Address of donor: private | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 12 | 2011-02-28-8f616a6e-24741-0 |
129a990e6ca03a91e7116ec8c9e40c6e4ee2cc6d | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 13 | 2011-02-28-8f616a6e-24741-0 |
accda25c05ea90096567b9e4b4c72c2c3399e924 | Name of donor: Harlow Bros Ltd | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 16 | 2011-02-28-8f616a6e-24741-0 |
aa0907f5e0ae389d048dadf1d2c11475c0084bf4 | Address of donor: Long Whatton, Loughborough, Leicestershire LE12 5DE | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 17 | 2011-02-28-8f616a6e-24741-0 |
113dbd9ae4d17345eb5c43220547a762835f96b6 | Amount of donation or nature and value if donation in kind: £2,100 | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 18 | 2011-02-28-8f616a6e-24741-0 |
ffa5fbe83442ba4ed450e982503759e4c3c20e6a | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 20 | 2011-02-28-8f616a6e-24741-0 |
d2b72674766d49a18cb434387b87b5c6f6c83a8e | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 21 | 2011-02-28-8f616a6e-24741-0 |
86442de3f52aa528713595438a93b4a9a3e3f857 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-02-28-8f616a6e-24741-0 |
de34666c1b8c3407481950e8d026eddf9c0455b2 | Address of donor: Enterprise House, Repton Road, Westminster Industrial Estate, Measham, Swadlincote, Derbyshire DE12 7DT. | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 23 | 2011-02-28-8f616a6e-24741-0 |
b116032c5313c95d9c670db7f666c343c01e396e | Amount of donation or nature and value if donation in kind: £800 a month ongoing | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 24 | 2011-02-28-8f616a6e-24741-0 |
0548e74311e86234e2e11532915cad04202f19e3 | Date of receipt: 6 May 2010 | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 25 | 2011-02-28-8f616a6e-24741-0 |
6468af61ecd8ce345b4d6febbd8de76d258a4f21 | Date of acceptance: 6 May 2010 | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 26 | 2011-02-28-8f616a6e-24741-0 |
4a1767431bd611a5ad840f02dc0e721f5fc6db12 | Donor status: company | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 27 | 2011-02-28-8f616a6e-24741-0 |
230181edfe164cdd6a955c84c1be549c457bda9a | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 28 | 2011-02-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");