items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
39 rows where person_id = "uk.org.publicwhip/person/10397" and sort_order = 8 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
89eb18daad3a70355181d3e176043454cbbd4edc | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-07-29 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-07-29-10057ffd-10397-0 | |
ba5c9a1cacdc5527c346184f151756d010a966b9 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-07-15 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-07-15-10057ffd-10397-0 | |
7634fc721fa0fa808ed92ccca9211940ea099a37 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-07-01 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-07-01-10057ffd-10397-0 | |
4fefaf9612baea0a782554ccc79bc7d40874435d | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-06-17 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-06-17-10057ffd-10397-0 | |
7e5f8f0b831d8d0850a6c88b4628efd7dcb0a258 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-06-03 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-06-03-10057ffd-10397-0 | |
94d5b5df94c8be91799e9cf650b9bf8687a604a3 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-05-20 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-05-20-10057ffd-10397-0 | |
0ab70510b04b3ce1b4eb48cf1bcbc653c6eb006d | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-05-07 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-05-07-10057ffd-10397-0 | |
6027f9de09d3e4b0628d99428ebd09f01a1ee786 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-04-23 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-04-23-10057ffd-10397-0 | |
b363b39a595959b5e382b02f01ceb6e0eb4189f6 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-04-01 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-04-01-10057ffd-10397-0 | |
42d951d805885292c75c84728ddc8467b4b01386 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-03-18 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-03-18-10057ffd-10397-0 | |
fe917de4bc528a1bd40ae6033e0f810f60c861ef | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-01-21 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-01-21-10057ffd-10397-0 | |
46c035a0e1ff1ee48eaf3bd97cb0fbc7ea5e8527 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2019-01-07 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2019-01-07-10057ffd-10397-0 | |
9659a6d94e6792e2c2c9e1fa784f7758f2be2b7d | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2018-12-17 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2018-12-17-10057ffd-10397-0 | |
8568bbc6b27b298ad9f07ee0c952dba6b4c50e15 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2018-12-03 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2018-12-03-10057ffd-10397-0 | |
94dc4866b90ad5d9ae4a9d7d3167fdae3c7eca97 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2018-11-19 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2018-11-19-10057ffd-10397-0 | |
ba857640262c6e6be06b6254a4d834cfd7c52fa7 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2018-10-29 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2018-10-29-10057ffd-10397-0 | |
6f4a4834f54ffe5c98ff070379581be577ab228c | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2018-10-15 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2018-10-15-10057ffd-10397-0 | |
755d19dd9ce24287752b1030007294d97437b6a0 | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2018-10-01 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2018-10-01-10057ffd-10397-0 | |
cf78afcdc9700d3ccaf675b59a5b27edaa7dbe7d | 27 August 2018, payment of £75. Hours: 30 mins. (Registered 04 September 2018) | Employment and earnings 10057ffd | 2018-09-10 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2018-09-10-10057ffd-10397-0 | |
adf4d40cd565665b6811b077903e9ee0569e817b | (Registered 13 October 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-12-13-84642823-10397-0 |
af7e738e1a379ce0287b2a6aa756a229246bb064 | (Registered 13 October 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-11-29-84642823-10397-0 |
3208ea24d365b00df13c254878fc7e316374ccb8 | (Registered 13 October 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-16 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-11-16-84642823-10397-0 |
9cb23df1a68ef1e5e77380b91d83c3e12d622f2d | (Registered 13 October 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-10-31 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-10-31-84642823-10397-0 |
8361aa9a9302194ebbe26c54b0724530f731b70d | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2011-06-06 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-06-06-8f616a6e-10397-0 |
7cb8322fab01a54943b0613ad5cd6d84b75a140b | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2011-05-16 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-05-16-8f616a6e-10397-0 |
3bb59ef0d6aeb7c7c5e5fecb28032621691d4ae9 | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2011-05-03 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-05-03-8f616a6e-10397-0 |
4fcd91523f88ee0d86b0b9f91685ce11ebb55318 | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2011-04-18 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-04-18-8f616a6e-10397-0 |
8038b1c5e4c7e4e80cfcf5a0ca60a2e35dd7f20b | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2011-03-28 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-03-28-8f616a6e-10397-0 |
83f44b5b08ffe686bac7d6b036e0685a1a5e0e65 | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2011-03-14 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-03-14-8f616a6e-10397-0 |
de770ee6f8549d620c101cb649acc0a0cdc3d20a | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2011-02-28 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-02-28-8f616a6e-10397-0 |
3110742a47b07fd7c450729a53db2ca29d48ea16 | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2011-02-07 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-02-07-8f616a6e-10397-0 |
4f25a4738d4da3cd0d43eb5cd71e87794b1bfe12 | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2011-01-24 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-01-24-8f616a6e-10397-0 |
49594a5b6045eb88424a23c14d3b14d930f6eaf3 | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2011-01-10 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2011-01-10-8f616a6e-10397-0 |
1b375cc3b281d0d728995c1d4115ca69daf58045 | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2010-12-20-8f616a6e-10397-0 |
1ece84baeaf945890786eaf56b051a8431ba5c3f | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2010-12-06 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2010-12-06-8f616a6e-10397-0 |
1da46be15742bf90bd1b02bf19fd778ae8edd54d | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2010-11-22 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2010-11-22-8f616a6e-10397-0 |
db74beef3a320da1cc028591345ed41dd3950445 | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2010-11-08 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2010-11-08-8f616a6e-10397-0 |
c593c35cb8dfd7a40ce656fa635e20c43d15470a | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2010-10-25 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2010-10-25-8f616a6e-10397-0 |
b1fb5653d39b4545510232409cbae84d8b664717 | Amount of donation or nature and value if donation in kind: £4,000. | Sponsorships 8f616a6e | 2010-09-06 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 8 | 2010-09-06-8f616a6e-10397-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");