items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2012-11-19-80ef1083-10076-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 |
---|---|---|---|---|---|---|---|
387d41fa768834d3a6c87f2acbbf0af72734f111 | Name of donor: Sir Joseph Hotung Programme | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 0 | 2012-11-19-80ef1083-10076-0 |
0792e3f8647d37bacdd36f1c64117dbb9898188d | Address of donor: School of Oriental and African Studies, Thornhaugh Street, Russell Square, London WC1H 0XG | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 1 | 2012-11-19-80ef1083-10076-0 |
d54e1bb9c9bd6daf727658d3d4ae7c33aa9b85a2 | Amount of donation (or estimate of the probable value): travel costs, accommodation and subsistence; value £2,000 | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 2 | 2012-11-19-80ef1083-10076-0 |
7e9fcbc532d0f728cc478e3676229add95e424aa | Destination of visit: Gaza and Egypt | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 3 | 2012-11-19-80ef1083-10076-0 |
f3713ccd467020b6c5749b3edaf8a4935d575f8d | Date of visit: 8-12 March 2012 | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 4 | 2012-11-19-80ef1083-10076-0 |
8c1d0c7f85ae61c734552306d95e89bd3f5d2f25 | Purpose of visit: delegation to Gaza and Egypt with the Britain Palestine All-Party Parliamentary Group | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 5 | 2012-11-19-80ef1083-10076-0 |
2fb98555a723951ded7a21eb6cb6b3454dfdb63b | (Registered 21 March 2012) | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 6 | 2012-11-19-80ef1083-10076-0 |
e0805211f39065bdf8ba4fd51e898494d41167e8 | Name of donor: Jordanian House of Representatives | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 7 | 2012-11-19-80ef1083-10076-0 |
c9fc7bf035e57d06cab536afff9fee7ba8a199d4 | Address of donor: Al Umah Street, Amman, Jordan | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 8 | 2012-11-19-80ef1083-10076-0 |
fff792f58e1af252192e54dfc2d075db57acad55 | Amount of donation: £2,029.45, to cover travel costs, accommodation, subsistence and internal tours | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 9 | 2012-11-19-80ef1083-10076-0 |
3d5d827d884b0c27e10d9b3e9449195736b2b3fb | Destination of visit: Jordan | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 10 | 2012-11-19-80ef1083-10076-0 |
57b751fee5c863dba4c701aafdf177344d30f734 | Date of visit: 8 – 14 April 2012 | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 11 | 2012-11-19-80ef1083-10076-0 |
70e49913944d0e09e4fe1e7577a07519ca7197ca | Purpose of visit: All-Party Parliamentary Jordan Group Delegation | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 12 | 2012-11-19-80ef1083-10076-0 |
29fb1d2bc05a40e57b060dd25ede0a86245804a8 | (Registered 3 May 2012) | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 13 | 2012-11-19-80ef1083-10076-0 |
e8e43b08f5ea4c00f6b5421feb5ee0da9d17ee71 | Name of donor: Embassy of the State of Qatar | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 14 | 2012-11-19-80ef1083-10076-0 |
e9e6000393c106d4e919ba6c0ca7d84e7d814582 | Address of donor: 1 South Audley St, London W1K 1NB | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 15 | 2012-11-19-80ef1083-10076-0 |
f35c618ed8c2cc4c2d3140d72e7746815c84c3e6 | Amount of donation (or estimate of the probable value): flights and accommodation with an estimated value of £3,860 | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 16 | 2012-11-19-80ef1083-10076-0 |
ccff4d4461c7226af9798bddb5607b91892d3829 | Destination of visit: Doha, Qatar | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 17 | 2012-11-19-80ef1083-10076-0 |
5b2fb258072761ff277e5b3c893606a70210a5eb | Date of visit:19-22 May 2012 | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 18 | 2012-11-19-80ef1083-10076-0 |
d507f109b716e450e5d8bb4fd91a9396f97de827 | Purpose of visit: to attend 2012 Doha forum | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 19 | 2012-11-19-80ef1083-10076-0 |
bc3b56e411e74176b4d6279b4eb9500c2ba41d1e | (Registered 6 July 2012) | Overseas visits 80ef1083 | 2012-11-19 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 20 | 2012-11-19-80ef1083-10076-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");