items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-84642823-10777-2" sorted by category_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
b273656bbd682fcc9f2dd397aea2393eb8af7b49 | Name of donor: Original BTC Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 0 | 2015-03-30-84642823-10777-2 |
0970c05fcd1411293246e65183b38e5e85224d19 | Address of donor: Units 21/22, Avenue One, Station Lane, Witney OX28 4XZ | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 1 | 2015-03-30-84642823-10777-2 |
f8f44ccec8fc8f2e7fb9fdb9d5bb1897ceb003ba | Amount of donation or nature and value if donation in kind: two lamps, total value £749 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 2 | 2015-03-30-84642823-10777-2 |
b5a400941b3b8a962692781e24be9a1f360229ed | Date of receipt of donation: 10 October 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 3 | 2015-03-30-84642823-10777-2 |
94ea5a2952b1896c4e8221fad766166014fe9713 | Date of acceptance of donation: 10 October 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 4 | 2015-03-30-84642823-10777-2 |
bc3a20a87e053d37c34e3ce2a04f324ade1c6137 | Donor status: company, registration 3650223 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 5 | 2015-03-30-84642823-10777-2 |
907a377fc56dc531631b3d6fa531a0a086ff6769 | (Registered 6 November 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 6 | 2015-03-30-84642823-10777-2 |
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");