items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2012-06-25-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 |
---|---|---|---|---|---|---|---|
ebb3dd524ca6c6385f7eb0de0986a410bf3618c1 | Name of donor: | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 0 | 2012-06-25-80ef1083-24798-0 |
434e7a519722d6d0a348be1c929632582be9f027 | 1) Tibet Society UK | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 1 | 2012-06-25-80ef1083-24798-0 |
18541caf312b8c0200f2ccaae9ac4c245eadb41a | 2) Tibetan Parliament in exile | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 2 | 2012-06-25-80ef1083-24798-0 |
35034b1797a7ead229a7992024e95ee17eacef09 | Address of donor: | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 3 | 2012-06-25-80ef1083-24798-0 |
7d7b91791e237fecd192cbec60efff8c3f2b8912 | 1) Unit 9, 139 Fonthill Road, Finsbury Park, London N4 3HF | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 4 | 2012-06-25-80ef1083-24798-0 |
077fbe168ce8bdd4cb4273e6a0d2d95379478d66 | 2) H-10 2nd Floor, Lajpat Nagar III, New Delhi, 11024, India | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 5 | 2012-06-25-80ef1083-24798-0 |
0d4169c6b6a393b0a0078802ab7e409eef06b3d4 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 6 | 2012-06-25-80ef1083-24798-0 |
4ce1b140a7fc4a55ff87d1a78e0bd88d5bd129a9 | 1) £724.64 | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 7 | 2012-06-25-80ef1083-24798-0 |
4233a96ba2d064f5d7315d4cfa659ecb1082246e | 2) £150.58 | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 8 | 2012-06-25-80ef1083-24798-0 |
8d2486a7d41015202f9effa359fb9a07f08bc0a5 | Destination of visit: Dharamsala and McLeod Ganj, India | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 9 | 2012-06-25-80ef1083-24798-0 |
ff4fda1c0128e168d7cc76012eacf9257355ca45 | Date of visit: 1-8 October 2011 | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 10 | 2012-06-25-80ef1083-24798-0 |
033d8e48f412f6b76703fc9745629c031b517e92 | 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-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 11 | 2012-06-25-80ef1083-24798-0 |
1f6bdf277ea3ee93edf40c5ce528be1e36f219d3 | (Registered 31 October 2011) | Overseas visits 80ef1083 | 2012-06-25 | Nicholas Dakin uk.org.publicwhip/member/40520 | Nicholas Dakin uk.org.publicwhip/person/24798 | 12 | 2012-06-25-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");