items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2014-06-30-84642823-10013-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 |
---|---|---|---|---|---|---|---|
6baae60e46b822586de52b6faa66156575894dae | Name of donor: British-Turkish Tatlidil | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2014-06-30-84642823-10013-0 |
cdd2aceb2263028331300bbd2d2ebdda30159487 | Amount of donation or nature and value if donation in kind: for two people, hotel accommodation in Edinburgh with a value of £500; travel with a value of £385.60 and food with a value of £728; total value of £1,613 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2014-06-30-84642823-10013-0 |
f9b4e990eff9d3ed3ebc15ef535b333c40262543 | Date of receipt of donation: 1-3 November 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 3 | 2014-06-30-84642823-10013-0 |
56825654f7461e922dbc7838bb922328ea146c84 | Date of acceptance of donation: 1-3 November 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 4 | 2014-06-30-84642823-10013-0 |
00d0785668751b998344f48b9e6198f2570def46 | Name of donor: Tertulias | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 7 | 2014-06-30-84642823-10013-0 |
6d3e19773871ac0d219372da76dca9378285c6c8 | Address of donor: 48 Desning Hall Cottages, Higham, Suffolk IP28 6PB | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 8 | 2014-06-30-84642823-10013-0 |
73894ee3e3ac949894360e61538411789f40bc8f | Amount of donation or nature and value if donation in kind: for two people, hotel accommodation in Oxford with a value of £480; travel with a value of £85.14 and food with a value of £514; total value of £1,079.14 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 9 | 2014-06-30-84642823-10013-0 |
a6afa0cda15edc135fe48cc468e7be8ca31bccb9 | Date of receipt of donation: 22-24 November 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 10 | 2014-06-30-84642823-10013-0 |
4facd9860d0ba0c101feb3e922b3bc998061e355 | Date of acceptance of donation: 22-24 November 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 11 | 2014-06-30-84642823-10013-0 |
df9faed2b6927ef8ef766c69d850a29c6dbc90e9 | Donor status: unincorporated association. | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 12 | 2014-06-30-84642823-10013-0 |
be791ab42ff60d740cfac7bfda55a81928b9d271 | (Registered 11 December 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 13 | 2014-06-30-84642823-10013-0 |
5cf6e3b687af4f542949c14e3463d4db61488861 | Name of donor: Bechtel Management Company Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 14 | 2014-06-30-84642823-10013-0 |
9633d29b8fcfe400290e6e21895f89cb3aec42c6 | Address of donor: 245 Hammersmith Road, London W6 8DP | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 15 | 2014-06-30-84642823-10013-0 |
123ad30afc76ef327bc2305da635142b8cf15750 | Amount of donation or nature and value if donation in kind: tickets for me and my wife to the opening night of the Chelsea Flower Show, to a total value of £1,250 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 16 | 2014-06-30-84642823-10013-0 |
971ad40de46f2c982469dc76064365801b3049c3 | Date of receipt of donation: 29 April 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 17 | 2014-06-30-84642823-10013-0 |
7c60614fe67f116c2febd36a8fe46ed472a4a6a2 | Date of acceptance of donation: 19 May 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 18 | 2014-06-30-84642823-10013-0 |
296d62ccf84fc2902a2627db9ecf2d9e59dc888e | Donor status: company, registration 4252526 | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 19 | 2014-06-30-84642823-10013-0 |
2846ac3fda23a3d79f4fa0b533dcf5f4fb7ea734 | (Registered 28 May 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2014-06-30 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 20 | 2014-06-30-84642823-10013-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");