items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2012-06-11-80ef1083-24798-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
ea324b4a52ee74cb115b788908ef383354573f03 | Name of donor: | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 0 | 2012-06-11-80ef1083-24798-0 |
92e2853d40f300ccd10d94e48c526e35b315e8b8 | 1) Tibet Society UK | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 1 | 2012-06-11-80ef1083-24798-0 |
c70e0273118b55e940778b0cdba6737fbcbd95d6 | 2) Tibetan Parliament in exile | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 2 | 2012-06-11-80ef1083-24798-0 |
738c5208f2821236e4fe88f9be73cb468c91b0ea | Address of donor: | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 3 | 2012-06-11-80ef1083-24798-0 |
1887a763fd25d397b6c8723b47b8aa120922d025 | 1) Unit 9, 139 Fonthill Road, Finsbury Park, London N4 3HF | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 4 | 2012-06-11-80ef1083-24798-0 |
60482adc4139cc1ae8a77656853ad3b398464c86 | 2) H-10 2nd Floor, Lajpat Nagar III, New Delhi, 11024, India | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 5 | 2012-06-11-80ef1083-24798-0 |
be23d1ff3de8237ef30be387d1ab2d0c67e8c32c | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 6 | 2012-06-11-80ef1083-24798-0 |
e0e450cc20cc914ddba41985a5977f5dc6c4c0f1 | 1) £724.64 | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 7 | 2012-06-11-80ef1083-24798-0 |
85145c78030a779bf8fc169cee5da645209ba617 | 2) £150.58 | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 8 | 2012-06-11-80ef1083-24798-0 |
987bccec4e4a7b0c85f0b0eb48cb2c577dade200 | Destination of visit: Dharamsala and McLeod Ganj, India | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 9 | 2012-06-11-80ef1083-24798-0 |
96c60f07fb3aa817d2100b211eda4207c077961f | Date of visit: 1-8 October 2011 | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 10 | 2012-06-11-80ef1083-24798-0 |
dd155e37bc6fecbe34025bea349698f5c9e929a5 | Purpose of visit: to meet the Tibetan parliament and Government in exile; to improve understanding by British MPs of the issues affecting Tibet; to further the exchange programme between British and Tibetan MPs; to have an audience with his Holiness the Dalai Lama. | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 11 | 2012-06-11-80ef1083-24798-0 |
ffa91a653475afbe59349d760afe7cdab3ce72e3 | (Registered 31 October 2011) | Overseas visits 80ef1083 | 2012-06-11 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 12 | 2012-06-11-80ef1083-24798-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");