items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
1 row where item = "A joint donation of £5,000 was made by Mr. Lincoln Fraser and Mr. David Willerton, local businessmen, to the Gainsborough Conservative Association Fighting Fund, administered by the Association, out of which my election campaign expenses were paid. (Registered 15 October 2001)" and member_id = "uk.org.publicwhip/member/1039" 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 |
---|---|---|---|---|---|---|---|
c2ddbfb83a5cdbc231a5f1cdc27a5ebc9519facb | A joint donation of £5,000 was made by Mr. Lincoln Fraser and Mr. David Willerton, local businessmen, to the Gainsborough Conservative Association Fighting Fund, administered by the Association, out of which my election campaign expenses were paid. (Registered 15 October 2001) | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Edward Leigh uk.org.publicwhip/member/1039 | Edward Leigh uk.org.publicwhip/person/10352 | 1 | 2002-05-14-9e46def6-10352-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");