items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where person_id = "uk.org.publicwhip/person/10071" and sort_order = 3 sorted by hash
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0f221d02e20cc7bb05da2b5aa95d56b6cb05a07c | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2010-03-24 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2010-03-24-80ef1083-10071-0 |
319cc6ef8d72dd6c6e1598e8254ff5b255caaa8b | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2009-11-25 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2009-11-25-80ef1083-10071-0 |
33e9e5498afe3e40c88c39ec825618036edd741c | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2009-12-10 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2009-12-10-80ef1083-10071-0 |
5e62e1a769082d03d25c3c107498cb3b98609e7b | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2009-10-14 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2009-10-14-80ef1083-10071-0 |
691fa8f4c457fe7bade6bb78db73fca45249210d | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2010-04-12 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2010-04-12-80ef1083-10071-0 |
77f2781cd1010f89e7dbfbf9898539bbdbe6eb74 | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2010-01-06 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2010-01-06-80ef1083-10071-0 |
7b7d38cb8d9edcf0c1ab846e0ef68f6eee098fbb | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2010-02-03 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2010-02-03-80ef1083-10071-0 |
93553cd4a1bb377c7a971e59718e0657e0ef740d | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2009-10-28 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2009-10-28-80ef1083-10071-0 |
a811df1d33afe4d10ce0d30b9736a7e004b4eee5 | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2010-03-10 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2010-03-10-80ef1083-10071-0 |
bb1bc30cd29923ff094f70d83932f6e867c7b2c8 | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2010-02-24 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2010-02-24-80ef1083-10071-0 |
d7ad4d32f1a21d12f90cc1ba30d53465be8253fb | Amount of donation (or estimate of the probable value): The total cost was £745 (£560 for 3 nights accommodation and £185 for travel within Washington) | Overseas visits 80ef1083 | 2009-11-11 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 3 | 2009-11-11-80ef1083-10071-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");