items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2012-03-19-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 |
---|---|---|---|---|---|---|---|
b50524ccf0c537093dbc877203958f4eb5d976ed | Name of donor: | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 0 | 2012-03-19-decaa699-11093-0 |
cc18ae25f7a106abe1263581cacce6224096390d | 1) Parliamentary Committee Against Antisemitism Foundation | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 1 | 2012-03-19-decaa699-11093-0 |
d2e46ef2974b87bf80f425a4931c3a4b27a12b8b | 2) Ukranian Jewish Committee | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 2 | 2012-03-19-decaa699-11093-0 |
523250db35288695124c1e59dced19339b5adb67 | Address of donor: | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 3 | 2012-03-19-decaa699-11093-0 |
9a4447cd2d1b39ac2ec8bc22701b631d4f7f9d9e | 1) PO Box 4015, London W1A 6NH | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 4 | 2012-03-19-decaa699-11093-0 |
09065cec56297f94df02ff74c5cd0b1b034dc3b0 | 2) 1b Darvina St. 01004, Kyiv, Ukraine | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 5 | 2012-03-19-decaa699-11093-0 |
389bfe560d5d2d3636afbe543cf5725618709d27 | Amount of donation (or estimate of the probable value): | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 6 | 2012-03-19-decaa699-11093-0 |
95feee3fc3b7092cef9c78f5085627f6a24598af | 1) Flights and accommodation; £670 | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 7 | 2012-03-19-decaa699-11093-0 |
5bde016c316763dd9455e2986b7ae3838a8b6d30 | 2) Flights; £313 | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 8 | 2012-03-19-decaa699-11093-0 |
fb23487a02ea2dc85fae208eb6449f99b256ca3a | Destination of visit: Ukraine/Belarus | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 9 | 2012-03-19-decaa699-11093-0 |
58706d5107067ff53ab489e79649ff2a0242c4e0 | Date of visit: 18-22 September 2011 | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 10 | 2012-03-19-decaa699-11093-0 |
bd42fc34512d9d38096fff71ca8a0099b8fb0e42 | Purpose of visit: to attend conference and meetings on antisemitism | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 11 | 2012-03-19-decaa699-11093-0 |
2187fa011ce8df1d8797d0d057137ca04843ee56 | (Registered 13 October 2011) | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 12 | 2012-03-19-decaa699-11093-0 |
31c95cdb5e1765be58956739b2c3b5bda1c736ef | Name of donor: Majlis As Shura - Shura Council of Kingdom Saudi Arabia | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 13 | 2012-03-19-decaa699-11093-0 |
75f08cf19aab97b28339bf14c49d50d1e4a569bd | Address of donor: c/o Embassy of Saudi Arabia, 30 Charles St, London W1J 5DZ | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 14 | 2012-03-19-decaa699-11093-0 |
0f899ec5960b2f538b517ff7ed26b8bbb2ba583c | Amount of donation (or estimate of the probable value): £2,750 | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 15 | 2012-03-19-decaa699-11093-0 |
c2dc70bf780a83d4167aff9f5c2f04ca05022e5e | Destination of visit: Riyadh, Saudi Arabia | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 16 | 2012-03-19-decaa699-11093-0 |
28325330d45d80e491edf91abbd0d9d750037152 | Date of visit: 4-7 December 2011 | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 17 | 2012-03-19-decaa699-11093-0 |
56aecb85397735d8ca63eec0407ecfd7a28253d6 | 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-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 18 | 2012-03-19-decaa699-11093-0 |
8a1fce6f7d33a7cf2a66f75b60baa38ae0571bdb | (Registered 20 December 2011) | Overseas visits decaa699 | 2012-03-19 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 19 | 2012-03-19-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");