items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2012-03-19-84642823-24945-0" sorted by hash
This data as json, CSV (advanced)
date (date) 1 ✖
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
000c10672ae17740ec3c79e692bd521c63c80a36 | Address of donor : 748 High Road, London N17 0AP | Gifts, benefits and hospitality (UK) 84642823 | 2012-03-19 | Bob Blackman uk.org.publicwhip/member/40300 | Bob Blackman uk.org.publicwhip/person/24945 | 1 | 2012-03-19-84642823-24945-0 |
014d86cc21fbe9f05041043f4e5748c8a0e8039b | (Registered 14 March 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2012-03-19 | Bob Blackman uk.org.publicwhip/member/40300 | Bob Blackman uk.org.publicwhip/person/24945 | 6 | 2012-03-19-84642823-24945-0 |
69da35d670b3aa73f159f6b30a816e732771fc36 | Amount of donation or nature and value if donation in kind: copy of "Opus", history of Tottenham Hotspur Football Club; commercial value £4,000 | Gifts, benefits and hospitality (UK) 84642823 | 2012-03-19 | Bob Blackman uk.org.publicwhip/member/40300 | Bob Blackman uk.org.publicwhip/person/24945 | 2 | 2012-03-19-84642823-24945-0 |
931d67820c40a8820d16e8fd86ed95bcdf9b561b | Donor status: company, registration number UC354931 | Gifts, benefits and hospitality (UK) 84642823 | 2012-03-19 | Bob Blackman uk.org.publicwhip/member/40300 | Bob Blackman uk.org.publicwhip/person/24945 | 5 | 2012-03-19-84642823-24945-0 |
a620c7b8e60f2f672fe09c9ab8f974cd6eef89b5 | Name of donor: Tottenham Hotspur Football Club | Gifts, benefits and hospitality (UK) 84642823 | 2012-03-19 | Bob Blackman uk.org.publicwhip/member/40300 | Bob Blackman uk.org.publicwhip/person/24945 | 0 | 2012-03-19-84642823-24945-0 |
da546d5961a4792dc933d248fabed08e686d5aff | Date of receipt of donation: 24 December 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2012-03-19 | Bob Blackman uk.org.publicwhip/member/40300 | Bob Blackman uk.org.publicwhip/person/24945 | 3 | 2012-03-19-84642823-24945-0 |
f2cd95e3f71b62ad0d339aef4ba1e3aa41e1d421 | Date of acceptance of donation: 31 January 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2012-03-19 | Bob Blackman uk.org.publicwhip/member/40300 | Bob Blackman uk.org.publicwhip/person/24945 | 4 | 2012-03-19-84642823-24945-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");