items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2014-06-30-80ef1083-10048-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
535445725a80e06285d85181143bf02c35dd7443 | Name of donor: Ergotep | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 0 | 2014-06-30-80ef1083-10048-0 |
8c1dd298d5a0a625acca1eceed41590050a1f950 | Address of donor: 539, 44 Proseč u Skutče, 119 Czech Republic | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 1 | 2014-06-30-80ef1083-10048-0 |
6a1d34fc304c11c45a88ac21806be042f9b0abe1 | Amount of donation (or estimate of the probable value): £2,638.78 | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 2 | 2014-06-30-80ef1083-10048-0 |
0c272527495bd7fd31f7980f4e17404ed689cb0a | Destination of visit: Prague | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 3 | 2014-06-30-80ef1083-10048-0 |
a7d7797ccd25f622b0bf02444d6420e232a5a616 | Date of visit: 10-13 October 2013 | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 4 | 2014-06-30-80ef1083-10048-0 |
5347bc139ff1b5036dff910250649b81ba9b3e91 | Purpose of visit: To make keynote speech at international forum on social enterprise | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 5 | 2014-06-30-80ef1083-10048-0 |
3aa873d2df48a3b39a3b1bae68e8a60c12821e94 | (Registered 30 October 2013) | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 6 | 2014-06-30-80ef1083-10048-0 |
d8d6d3b6272c7bb242976ba28191623ff9ab487d | Name of donor: Parliament of Bahrain (National Assembly & Shura Council) | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 7 | 2014-06-30-80ef1083-10048-0 |
276f7bbfefba6b9a2d4479886fa71c689ffc759a | Address of donor: Shaikh Daij Avenue, Manama, Bahrain | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 8 | 2014-06-30-80ef1083-10048-0 |
5239fffbd3c4d229b00353c1549afe00f313ed26 | Amount of donation (or estimate of the probable value): flights £4,630, accommodation £797, total £5,427 | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 9 | 2014-06-30-80ef1083-10048-0 |
1e55dc574a4c91e03263c13e19eec7affc11ba9e | Destination of visit: Bahrain | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 10 | 2014-06-30-80ef1083-10048-0 |
e99273df3f2784a71b6b411e6c8fd958747fffd4 | Date of visit: 12-16 April 2014 | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 11 | 2014-06-30-80ef1083-10048-0 |
28557bbe0696f78d354d951211e2f557e93e9620 | Purpose of visit: to discuss governance, security and human rights issues and promote UK-Bahraini relations. | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 12 | 2014-06-30-80ef1083-10048-0 |
254f5c0c23fb9760aa6c6ed3f1ccc0316916e077 | (Registered 27 May 2014) | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 13 | 2014-06-30-80ef1083-10048-0 |
64dd1c7a412b697d7b8b241beb6de805302b11a0 | Name of donor: University of Salford | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 14 | 2014-06-30-80ef1083-10048-0 |
8ae1c7717ae6c4b5f431259cee765a0c7048afc7 | Address of donor: Faraday House, Salford M5 4WT | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 15 | 2014-06-30-80ef1083-10048-0 |
7b699c27a13fedd8d3c0f873bb373f81bce8f330 | Amount of donation (or estimate of the probable value): Flight costing £335.49 and hotel costing £330; £665.49 in total | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 16 | 2014-06-30-80ef1083-10048-0 |
875b966cd1ac491ef529fe9a797510282a5185ea | Destination of visit: Isle of Man | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 17 | 2014-06-30-80ef1083-10048-0 |
24405356efefe452a86aed228351a4ebfd7a392c | Date of visit: 10-11 April 2014 | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 18 | 2014-06-30-80ef1083-10048-0 |
424c5db9122d78f1c97e9a06da12ff6a7a69d265 | Purpose of visit: In support of promotion of work of University of Salford | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 19 | 2014-06-30-80ef1083-10048-0 |
10d3bbdeebebec7bf5cbd3bb226f2fb6c6a907c3 | (Registered 9 June 2014) | Overseas visits 80ef1083 | 2014-06-30 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 20 | 2014-06-30-80ef1083-10048-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");