items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2010-11-08-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 |
---|---|---|---|---|---|---|---|
c6395be0c0036d4e1b03a7c585f91163a4fa013d | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 0 | 2010-11-08-8f616a6e-10063-0 |
62eca611d20d2bd9fa8c0d0e5518ea9d93079f72 | Name of donor: Peter Baines | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 1 | 2010-11-08-8f616a6e-10063-0 |
4a3a85f6b9653e7f75cc731f007992981866bc48 | Amount of donation or nature and value if donation in kind: £2000 given to constituency party | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 3 | 2010-11-08-8f616a6e-10063-0 |
9a603d43969e19ecc09f563bfae017cc84e9f494 | (Registered 14 January 2010) | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 5 | 2010-11-08-8f616a6e-10063-0 |
71bf7d3a1210a3c7d7af9ac5571d3a6555820c28 | Name of donor: Betterworld | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 6 | 2010-11-08-8f616a6e-10063-0 |
c1c2e9554de2c63e6f9fcd68826c1d1e6a33178f | Address of donor: 12 Ladbroke Road, London | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 7 | 2010-11-08-8f616a6e-10063-0 |
029ba6a612d13dd670ef07f37a34233a04927f5b | 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 | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 8 | 2010-11-08-8f616a6e-10063-0 |
e945f7ff4a94910d392475841e66e32b2d5236a4 | Name of donor: Elaine Drage | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 11 | 2010-11-08-8f616a6e-10063-0 |
6b5ce3835a7c4c20d08e2527ab6e787620b74213 | Address of donor: private. | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 12 | 2010-11-08-8f616a6e-10063-0 |
12445a7c9a327403c1af73699ac177147aed9a2b | Donor status: individual | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 14 | 2010-11-08-8f616a6e-10063-0 |
d2c4ac178e79dccb3bdcd2494946db82db645647 | Name of donor: Wallington Cars and Couriers | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 16 | 2010-11-08-8f616a6e-10063-0 |
abd84cee317efa9529545b7f7314c95219ae8c77 | Address of donor: 40 Wallington Square, Wallington, Surrey, SM6 8RG. | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 17 | 2010-11-08-8f616a6e-10063-0 |
18856d0288829d295d4f379a2288063a4453e499 | 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 | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 18 | 2010-11-08-8f616a6e-10063-0 |
417978fdf41bfa713e891c92409bfd20f49e9d62 | Donor status: company | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 19 | 2010-11-08-8f616a6e-10063-0 |
cc414569afe156cc04e5c1e9bc007f387d1ef6d8 | (Registered 25 May 2010) | Sponsorships 8f616a6e | 2010-11-08 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 20 | 2010-11-08-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");