items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where item = "14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007)" and person_id = "uk.org.publicwhip/person/10097" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
9cf0e242a9f35f8b5876ad81084c29562da69ec1 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-03-13 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-03-13-84642823-10097-0 |
4ca17ec1e35e86bc8d10dac66c6bf7d05a8b7f70 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-03-26 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-03-26-84642823-10097-0 |
5c3c94cade213eefceb2973749a57bec67804579 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-05-01 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-05-01-84642823-10097-0 |
ba7768648486ddf43be3a317471b66809573fe14 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-05-15 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-05-15-84642823-10097-0 |
2a9e4dad96a5207f084be2e17fc3b1658fe05e04 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-06-05 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-06-05-84642823-10097-0 |
2b8be97734a0d7b1a5cf47058bdd0e3c63e2e214 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-06-19 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-06-19-84642823-10097-0 |
65f090fbde02e53362e65b8ef04904a04dcc053c | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-07-03 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-07-03-84642823-10097-0 |
2e5c5a639d8810eb18ae2838b48b73651db67e4e | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-07-17 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-07-17-84642823-10097-0 |
63dadfd8d4a8011991cc3f406974947a36d224f6 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-07-30 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-07-30-84642823-10097-0 |
972dcca5e877ef81a970ed9623e4e6726dbe244b | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-08-28 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-08-28-84642823-10097-0 |
69218b55ea627a0578befdde0a99cda781617b64 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-10-09 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-10-09-84642823-10097-0 |
49b5e2e891025b5319c2a3ac31498e069eb2cbfa | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-10-23 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-10-23-84642823-10097-0 |
cb5074816623d643558bef1a55f84b27e6c50990 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-11-06 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-11-06-84642823-10097-0 |
5f9743b34cf3633be2c67b4d59da2ae3a8670e26 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-11-20 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-11-20-84642823-10097-0 |
ef116bd6a8c9086092874aa76e39e031a1c88beb | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-12-04 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-12-04-84642823-10097-0 |
0208d005634bf0520d828c98201d87ba0926d1ad | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-12-18 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2007-12-18-84642823-10097-0 |
3d9745b1f1038a02ebc58dc5c09a1e48e5789ef8 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-01-09 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2008-01-09-84642823-10097-0 |
80db044ec119d0f584e0278be27a90109dd199f9 | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-01-22 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2008-01-22-84642823-10097-0 |
0a9467c3dcb3ad7e68cd80057bdc77f6bf48054d | 14 February 2007, tickets and hospitality at the Brit Awards at Earls Court, from the British Phonographic Industry. (Registered 20 February 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-02-05 | Ian Cawsey uk.org.publicwhip/member/1452 | Ian Cawsey uk.org.publicwhip/person/10097 | 0 | 2008-02-05-84642823-10097-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");