items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2011-03-28-8f616a6e-10063-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
c6b025db7f407243138e3a7198be0eae25f4b9fb | 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 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 0 | 2011-03-28-8f616a6e-10063-0 |
0f627b698facce0e45874561395f12139b2593b5 | Name of donor: Peter Baines | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 1 | 2011-03-28-8f616a6e-10063-0 |
977f45d734b9a12fe60600f9442d8b3980e0de45 | Amount of donation or nature and value if donation in kind: £2000 given to constituency party | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 3 | 2011-03-28-8f616a6e-10063-0 |
11ee59b746dd24e17e9d60decf7684149f31918b | (Registered 14 January 2010) | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 5 | 2011-03-28-8f616a6e-10063-0 |
f57e7666a46b707290c7d87cb5654bbe7527a33c | Name of donor: Betterworld | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 6 | 2011-03-28-8f616a6e-10063-0 |
abadd0bd7660bebb54c33e259e0ed731d166c5c4 | Address of donor: 12 Ladbroke Road, London | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 7 | 2011-03-28-8f616a6e-10063-0 |
ca0dfbd09ef3de262752853cf0a88250340b9a79 | Amount of donation or nature and value if donation in kind: £2,500. (This donation was made to the constituency party, which will report it to the Electoral Commission.) | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 8 | 2011-03-28-8f616a6e-10063-0 |
c770dbee1f27785280aea254fdf6a630ce49c442 | Name of donor: Elaine Drage | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 11 | 2011-03-28-8f616a6e-10063-0 |
b7209b2dcf041dec2d75fe4302c42b3c2d84a5bf | Address of donor: private. | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 12 | 2011-03-28-8f616a6e-10063-0 |
bfbd2b83dc67385d8bf3810c72701e7b2a63b7c6 | Donor status: individual | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 14 | 2011-03-28-8f616a6e-10063-0 |
49fb921b7db8a2da1bdf2014358a41dd8ba6cac2 | Name of donor: Wallington Cars and Couriers | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 16 | 2011-03-28-8f616a6e-10063-0 |
15778d10e963f0689f4e47ffe565d141955de80f | Address of donor: 40 Wallington Square, Wallington, Surrey, SM6 8RG. | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 17 | 2011-03-28-8f616a6e-10063-0 |
81dadfbe099e49b8b5e71677683d6ab7107722fa | Amount of donation or nature and value if donation in kind: £2,000. (This donation was made to the constituency party, which will report it to the Electoral Commission.) | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 18 | 2011-03-28-8f616a6e-10063-0 |
2036b4e23364780dc146e14d689cabae95fd8a62 | Donor status: company | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 19 | 2011-03-28-8f616a6e-10063-0 |
bd5e09bbd22b823718fdefc768c9565275d7cd0b | (Registered 25 May 2010) | Sponsorships 8f616a6e | 2011-03-28 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 20 | 2011-03-28-8f616a6e-10063-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");