items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where "date" is on date 2014-06-16 and record_id = "2014-06-16-80ef1083-10089-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 |
---|---|---|---|---|---|---|---|
c139178a0ada3c7807aa78c9e70da02d2bc6a593 | Name of donor: Taipei Representative Office | Overseas visits 80ef1083 | 2014-06-16 | Ronnie Campbell uk.org.publicwhip/member/40096 | Ronnie Campbell uk.org.publicwhip/person/10089 | 0 | 2014-06-16-80ef1083-10089-0 |
207bad3c21e5c66bdb0e5b0aaa2d4970f5811a65 | Address of donor: 50 Grosvenor Gardens, London SW1W 0EB | Overseas visits 80ef1083 | 2014-06-16 | Ronnie Campbell uk.org.publicwhip/member/40096 | Ronnie Campbell uk.org.publicwhip/person/10089 | 1 | 2014-06-16-80ef1083-10089-0 |
1d02825a71e263928f0b32c455ef33ea9c20b77b | Amount of donation (or estimate of the probable value): flights, accommodation, food and travel within the country with a total value of £3,810 | Overseas visits 80ef1083 | 2014-06-16 | Ronnie Campbell uk.org.publicwhip/member/40096 | Ronnie Campbell uk.org.publicwhip/person/10089 | 2 | 2014-06-16-80ef1083-10089-0 |
6d16eeccd6bc07cbf419f0fa91f84d20d3a271cf | Destination of visit: Taiwan | Overseas visits 80ef1083 | 2014-06-16 | Ronnie Campbell uk.org.publicwhip/member/40096 | Ronnie Campbell uk.org.publicwhip/person/10089 | 3 | 2014-06-16-80ef1083-10089-0 |
6165fdec867b33abbbb3a9859101f5fc8316cbdd | Date of visit: 2-9 September 2013 | Overseas visits 80ef1083 | 2014-06-16 | Ronnie Campbell uk.org.publicwhip/member/40096 | Ronnie Campbell uk.org.publicwhip/person/10089 | 4 | 2014-06-16-80ef1083-10089-0 |
7c45d580f73bf8e424a6390fe87bb50e948d7b43 | Purpose of visit: As a member of the All Party Light Rail Group as part of our enquiry into the growth and regeneration potential of light rail, meeting with politicians, officials and industry experts to discuss Light Rail. | Overseas visits 80ef1083 | 2014-06-16 | Ronnie Campbell uk.org.publicwhip/member/40096 | Ronnie Campbell uk.org.publicwhip/person/10089 | 5 | 2014-06-16-80ef1083-10089-0 |
2fc1716772ab3510b10aeea90ba0380487df4cfa | (Registered 10 October 2013) | Overseas visits 80ef1083 | 2014-06-16 | Ronnie Campbell uk.org.publicwhip/member/40096 | Ronnie Campbell uk.org.publicwhip/person/10089 | 6 | 2014-06-16-80ef1083-10089-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");