items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where member_id = "uk.org.publicwhip/member/1864" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
3172781b393b417c3e4ba5725df74572a199ab25 | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-09-03 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-09-03-84642823-10639-0 |
5127470588df57672b276f694bb51082bb1df32f | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-07-22 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-07-22-84642823-10639-0 |
4c8f90d31ed81af799c20143aa704a1b29a2b56c | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-07-08 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-07-08-84642823-10639-0 |
b32d4390d61162ca54dca381036d471256c799cd | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-06-16 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-06-16-84642823-10639-0 |
2784a2efe6e6ee412a87fd424b3a13a40c3c5e5d | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-04-23 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-04-23-84642823-10639-0 |
67501eee52284eb4eedcdc8e691eed50e7fc1abb | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-03-25 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-03-25-84642823-10639-0 |
69800003ded4ab62f72758a14886dd30dd089ac7 | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-03-11 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-03-11-84642823-10639-0 |
08ed0344cd264f06a2bf9c8abd827ecf4f01d567 | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-02-26 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-02-26-84642823-10639-0 |
baf28421caeb338df01cb809042f041b3d6666a2 | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-02-05 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-02-05-84642823-10639-0 |
dd90d3abf0627274069f3c8399c24890c4fc022a | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-01-22 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-01-22-84642823-10639-0 |
484a9181060fbaa1c558d75db81f0dc4e7736497 | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-01-09 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2008-01-09-84642823-10639-0 |
6bf65cfd30fd9337d0b6076269a70a8e895b9fe6 | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-12-18 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2007-12-18-84642823-10639-0 |
74da39cc3e73f0308a3f5b3e0b501880296c0080 | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-12-04 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2007-12-04-84642823-10639-0 |
371dd40dddead04be198ba603a7b9440c1f25d2a | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-11-20 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2007-11-20-84642823-10639-0 |
8404a61cc36dcacc8beac9d5dd63231552b65288 | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-11-06 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2007-11-06-84642823-10639-0 |
03f084ffb48a53d25b7f72fc819080b7df444ecf | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-10-23 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2007-10-23-84642823-10639-0 |
c6acf4adaccfeec8c241e3b12f244633e8e32347 | 25 July 2007, my wife and I were upgraded from World Traveller Plus to Club Class on our return flight with British Airways from Washington to Heathrow. (Registered 3 September 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-10-09 | Alan Williams uk.org.publicwhip/member/1864 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2007-10-09-84642823-10639-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");