items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2014-04-28-8f616a6e-24762-0" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
dbc0d20e78016be05f504e5387e5de485146a06a | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-04-28 | Michael Dugher uk.org.publicwhip/member/40057 | Michael Dugher uk.org.publicwhip/person/24762 | 0 | 2014-04-28-8f616a6e-24762-0 |
7bf60d239a0acceedb63a98502cc29c33359c50b | Name of donor: Barnsley East CLP | Sponsorships 8f616a6e | 2014-04-28 | Michael Dugher uk.org.publicwhip/member/40057 | Michael Dugher uk.org.publicwhip/person/24762 | 1 | 2014-04-28-8f616a6e-24762-0 |
33c13bc963d70fb51c1fd2063117f55441849de3 | Address of donor: 26 Newsome Road, Wombwell, Barnsley S73 8QS | Sponsorships 8f616a6e | 2014-04-28 | Michael Dugher uk.org.publicwhip/member/40057 | Michael Dugher uk.org.publicwhip/person/24762 | 2 | 2014-04-28-8f616a6e-24762-0 |
0002bdab410818c5123d9cfbf548ef956c2747dc | Amount of donation or nature and value if donation in kind: £10,006; money raised between 12 June 2013 and 5 August 2013 in respect of a fundraising event held on 12 June 2013 for the benefit of Barnsley East Constituency Labour Party (CLP) and the CLP of another Labour MP (£5,003 each). The money raised included one registrable donation as set out below. Part of the money will be donated to two other CLPs. | Sponsorships 8f616a6e | 2014-04-28 | Michael Dugher uk.org.publicwhip/member/40057 | Michael Dugher uk.org.publicwhip/person/24762 | 3 | 2014-04-28-8f616a6e-24762-0 |
29888f604e3d668d505a0a2fd19d84451b75572e | Donor status: unincorporated association | Sponsorships 8f616a6e | 2014-04-28 | Michael Dugher uk.org.publicwhip/member/40057 | Michael Dugher uk.org.publicwhip/person/24762 | 4 | 2014-04-28-8f616a6e-24762-0 |
476754eb38e5d96306d1cbc368dce34f0e7c5c7a | Name of donor: Mr Graham Cole | Sponsorships 8f616a6e | 2014-04-28 | Michael Dugher uk.org.publicwhip/member/40057 | Michael Dugher uk.org.publicwhip/person/24762 | 6 | 2014-04-28-8f616a6e-24762-0 |
245a769998d2e930dce04fee43694d87b321ad0c | Address of donor: private | Sponsorships 8f616a6e | 2014-04-28 | Michael Dugher uk.org.publicwhip/member/40057 | Michael Dugher uk.org.publicwhip/person/24762 | 7 | 2014-04-28-8f616a6e-24762-0 |
86ce287788b271930fcdce0aab352f9aa638d5d6 | Amount of donation or nature and value if donation in kind: £2,300 received on 5 August 2013 as the only registrable donation from a funding raising event held on 12 June 2013 for the benefit of Barnsley East CLP (£1,150) and the CLP of another Labour MP (£1,150). | Sponsorships 8f616a6e | 2014-04-28 | Michael Dugher uk.org.publicwhip/member/40057 | Michael Dugher uk.org.publicwhip/person/24762 | 8 | 2014-04-28-8f616a6e-24762-0 |
c3a525e1475afd280cdd928ed5af14756667716f | Donor status: individual | Sponsorships 8f616a6e | 2014-04-28 | Michael Dugher uk.org.publicwhip/member/40057 | Michael Dugher uk.org.publicwhip/person/24762 | 9 | 2014-04-28-8f616a6e-24762-0 |
f4f7916f0b1603f676530b8c8353543bdf3e942f | (Registered 28 August 2013) | Sponsorships 8f616a6e | 2014-04-28 | Michael Dugher uk.org.publicwhip/member/40057 | Michael Dugher uk.org.publicwhip/person/24762 | 10 | 2014-04-28-8f616a6e-24762-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");