items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2012-04-16-decaa699-11093-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 |
---|---|---|---|---|---|---|---|
dc5b941becb58c7090c727d5a09fa1d0956988e0 | Name of donor: | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 0 | 2012-04-16-decaa699-11093-0 |
7e66c347d9b4d627bb80ab0d12480aa1c148d717 | 1) Parliamentary Committee Against Antisemitism Foundation | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 1 | 2012-04-16-decaa699-11093-0 |
9004969c868c9bdb744ff4d4f3948b1fcfc2ee12 | 2) Ukranian Jewish Committee | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 2 | 2012-04-16-decaa699-11093-0 |
4ebfa5e0ed7c190003c5a6fb17bdb51ba80f4792 | Address of donor: | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 3 | 2012-04-16-decaa699-11093-0 |
5f14c8e2ab0d1b1015751e0ab7132bd887c6060d | 1) PO Box 4015, London W1A 6NH | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 4 | 2012-04-16-decaa699-11093-0 |
0ad5b0043e58592d5ef9cd5a317c56a6610c5cbe | 2) 1b Darvina St. 01004, Kyiv, Ukraine | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 5 | 2012-04-16-decaa699-11093-0 |
748062df0e859706897e4a83fee5498ef1dab130 | Amount of donation (or estimate of the probable value): | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 6 | 2012-04-16-decaa699-11093-0 |
1558672de80caef2f69c12b894a60ed8473cd251 | 1) Flights and accommodation; £670 | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 7 | 2012-04-16-decaa699-11093-0 |
063d03dbfece87920ce100f0ad7996f1f8c2a326 | 2) Flights; £313 | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 8 | 2012-04-16-decaa699-11093-0 |
cad96523d99b67d419c217a354ae8dd0c8153d6f | Destination of visit: Ukraine/Belarus | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 9 | 2012-04-16-decaa699-11093-0 |
3e2b955e6e177493fd6d0060efe024c478af31cd | Date of visit: 18-22 September 2011 | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 10 | 2012-04-16-decaa699-11093-0 |
aba8d247281345dc0e5f96d47424d70bed2d8da0 | Purpose of visit: to attend conference and meetings on antisemitism | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 11 | 2012-04-16-decaa699-11093-0 |
5f419a6cbacf5c6ebbfee0ac7336cbd1593c3149 | (Registered 13 October 2011) | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 12 | 2012-04-16-decaa699-11093-0 |
7573da3036274e83bfa6d1948daf7331b89e3723 | Name of donor: Majlis As Shura - Shura Council of Kingdom Saudi Arabia | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 13 | 2012-04-16-decaa699-11093-0 |
01453f5ee11e3be4ac9c25cab34dd2df9d3fd349 | Address of donor: c/o Embassy of Saudi Arabia, 30 Charles St, London W1J 5DZ | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 14 | 2012-04-16-decaa699-11093-0 |
26ebad190ec85fb8216c907bb3bd8835b1983f71 | Amount of donation (or estimate of the probable value): £2,750 | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 15 | 2012-04-16-decaa699-11093-0 |
06f988c0d284f2e30c449ac2b2d7e13884235fd4 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 16 | 2012-04-16-decaa699-11093-0 |
0fce3c6ee93078feaade1fa970e637e7a80d42ba | Date of visit: 4-7 December 2011 | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 17 | 2012-04-16-decaa699-11093-0 |
98d384dd1ef35357ed6173047289399913ecd782 | Purpose of visit: All Party Parliamentary Group visit to meet Members of the Shura Council, Government Ministers and various human rights groups | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 18 | 2012-04-16-decaa699-11093-0 |
c73cbfebbd0fe9e41eab5b851b51ecfb28353ff2 | (Registered 20 December 2011) | Overseas visits decaa699 | 2012-04-16 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 19 | 2012-04-16-decaa699-11093-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");