items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
70 rows where person_id = "uk.org.publicwhip/person/10397" and sort_order = 2 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 |
---|---|---|---|---|---|---|---|
bfc7c3779098b43b12ef761e849c0ea81ffe219a | Payments from ComRes, Four Millbank, London SW1P 3JA for opinion surveys. Fees donated to local charities: | Employment and earnings 10057ffd | 2019-11-05 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-11-05-10057ffd-10397-0 | |
313e571e6746548afabf152b56681a8ac2975baa | Payments from ComRes, Four Millbank, London SW1P 3JA for opinion surveys. Fees donated to local charities: | Employment and earnings 10057ffd | 2019-10-21 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-10-21-10057ffd-10397-0 | |
1179499e59b9d25d87bd8a6fe3121dc5ecb599ca | Payments from ComRes, Four Millbank, London SW1P 3JA for opinion surveys. Fees donated to local charities: | Employment and earnings 10057ffd | 2019-09-30 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-09-30-10057ffd-10397-0 | |
65968fa84bf3e0b78c9bcb11d760991a8651a965 | Payments from ComRes, Four Millbank, London SW1P 3JA for opinion surveys. Fees donated to local charities: | Employment and earnings 10057ffd | 2019-09-16 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-09-16-10057ffd-10397-0 | |
154d243fde1b276d7d1a4cc0295a4d74760145ca | Payments from ComRes, Four Millbank, London SW1P 3JA for opinion surveys. Fees donated to local charities: | Employment and earnings 10057ffd | 2019-09-02 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-09-02-10057ffd-10397-0 | |
c856b47a20a5950aa0d57878874651acbaabf568 | Payments from ComRes, Four Millbank, London SW1P 3JA for opinion surveys. Fees donated to local charities: | Employment and earnings 10057ffd | 2019-08-12 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-08-12-10057ffd-10397-0 | |
61dceca880a5b9f15c7174f21afdb88733529ccf | 8 February 2019, received £200. Hours: 1.5 hrs. (Registered 06 March 2019) | Employment and earnings 10057ffd | 2019-07-29 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-07-29-10057ffd-10397-0 | |
66ddee415c0801b25758d81e04bebba65b99d73e | 8 February 2019, received £200. Hours: 1.5 hrs. (Registered 06 March 2019) | Employment and earnings 10057ffd | 2019-07-15 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-07-15-10057ffd-10397-0 | |
0ef4e74a24b374bd44b08c894a8e51f05c361d62 | 8 February 2019, received £200. Hours: 1.5 hrs. (Registered 06 March 2019) | Employment and earnings 10057ffd | 2019-07-01 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-07-01-10057ffd-10397-0 | |
d9771a4d366ff15f3a86915865ca11fc60187679 | 8 February 2019, received £200. Hours: 1.5 hrs. (Registered 06 March 2019) | Employment and earnings 10057ffd | 2019-06-17 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-06-17-10057ffd-10397-0 | |
65c2c14f9e1d437f82cbb416dde787d27bebeed8 | 8 February 2019, received £200. Hours: 1.5 hrs. (Registered 06 March 2019) | Employment and earnings 10057ffd | 2019-06-03 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-06-03-10057ffd-10397-0 | |
8b076e0e472dc1072997c2557e6924bf5d0ed078 | 8 February 2019, received £200. Hours: 1.5 hrs. (Registered 06 March 2019) | Employment and earnings 10057ffd | 2019-05-20 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-05-20-10057ffd-10397-0 | |
9744603be848a82bcedfb7ab0a841aa7ce67223c | 8 February 2019, received £200. Hours: 1.5 hrs. (Registered 06 March 2019) | Employment and earnings 10057ffd | 2019-05-07 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-05-07-10057ffd-10397-0 | |
771fb5ab2be67202d0eff57ef49204046eb73c17 | 8 February 2019, received £200. Hours: 1.5 hrs. (Registered 06 March 2019) | Employment and earnings 10057ffd | 2019-04-23 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-04-23-10057ffd-10397-0 | |
c6f8805d79ae1191d1a615a1ef2e0c5c08ef86cd | 8 February 2019, received £200. Hours: 1.5 hrs. (Registered 06 March 2019) | Employment and earnings 10057ffd | 2019-04-01 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-04-01-10057ffd-10397-0 | |
0686b3df06d7a32aea652f12b7313b82d4224457 | 8 February 2019, received £200. Hours: 1.5 hrs. (Registered 06 March 2019) | Employment and earnings 10057ffd | 2019-03-18 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-03-18-10057ffd-10397-0 | |
ae3e0dc744f66cc4fcb7a3038ac9c6d87a1c9cf6 | Payments from ComRes, Four Millbank, London SW1P 3JA for opinion surveys. Fees donated to local charities: | Employment and earnings 10057ffd | 2019-03-04 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-03-04-10057ffd-10397-0 | |
bf38817c18f8a76b756dbc4ba19f5b5e2726b89c | Payments from ComRes, Four Millbank, London SW1P 3JA for opinion surveys. Fees donated to local charities: | Employment and earnings 10057ffd | 2019-02-18 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-02-18-10057ffd-10397-0 | |
2b7ead04778598e71f7cda383a975f33bccf69d6 | Payments from ComRes, Four Millbank, London SW1P 3JA for opinion surveys. Fees donated to local charities: | Employment and earnings 10057ffd | 2019-02-04 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-02-04-10057ffd-10397-0 | |
931e895770a3dd0c7a3782803b264a2054e30fa7 | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2019-01-21 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-01-21-10057ffd-10397-0 | |
f8ffacd6d960ebd72c2099bee0c1f637d565db9d | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2019-01-07 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2019-01-07-10057ffd-10397-0 | |
ff27a689b5ef259a4eb7b995670929bb424aab03 | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2018-12-17 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2018-12-17-10057ffd-10397-0 | |
8ef833360d06314a686fe78d0a6a1bee1c1c101b | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2018-12-03-10057ffd-10397-0 | |
fc58ab538ec92f0e2aec2df5fb5bb0414db3263c | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2018-11-19 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2018-11-19-10057ffd-10397-0 | |
93368d080c46af22d7f44b33210b53f3e1a2bf75 | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2018-10-29 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2018-10-29-10057ffd-10397-0 | |
f4ea82888717a94bb985c131a064dbdd6a4f15da | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2018-10-15 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2018-10-15-10057ffd-10397-0 | |
1a4d71c0c02fb24c389637f3ca4fae16802ded3c | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2018-10-01 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2018-10-01-10057ffd-10397-0 | |
9cb29fda051d8b9868f64d79f5fa80ada22c582f | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2018-09-10 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2018-09-10-10057ffd-10397-0 | |
3e724343f9cd4c49a53eebf9931d329a7efacba2 | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2018-08-13 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2018-08-13-10057ffd-10397-0 | |
f16f5509dc4deb38e6131e034a514ece8c90fba9 | 5 July 2018, received £200. Hours: 1.5 hrs. (Registered 11 July 2018) | Employment and earnings 10057ffd | 2018-07-16 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2018-07-16-10057ffd-10397-0 | |
4bedfb6c46f6fa9c7eb8cd7b4bf8e14e4eea48fa | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-12-19 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-12-19-80ef1083-10397-0 |
6f6a9130144cefca0262837b4e023f4b9b1bdd20 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-12-03 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-12-03-80ef1083-10397-0 |
4873b00cf9c88a938648c6e4aae78b0f60f7422a | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-11-19 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-11-19-80ef1083-10397-0 |
da10c005c3294427950b4d15adf24ad0e06324a4 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-11-05 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-11-05-80ef1083-10397-0 |
4172cf35ef24f8b58ca2845a073b31b772c4fbf2 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-10-22 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-10-22-80ef1083-10397-0 |
2714ae027c797daa75f14a9a11f9f9d206343b97 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-10-01 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-10-01-80ef1083-10397-0 |
397b5ccd35343e45ed53b19a51dea809fe38bbd2 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-09-03 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-09-03-80ef1083-10397-0 |
41bf1680c902c18ca99e565a89c69f2046fdb74f | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-07-30 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-07-30-80ef1083-10397-0 |
a55aab3942e9545effc2abbdaf5d1d4aebb35788 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-07-09 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-07-09-80ef1083-10397-0 |
88a0d931a3cadfa72ae71996dfc15d5ad1136b39 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-06-25 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-06-25-80ef1083-10397-0 |
57b348eb2346ddc29b4200c11dfb696ec7e4f451 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-06-11 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-06-11-80ef1083-10397-0 |
934f9826cfaa1b5cb601ea92a515f18f8446828a | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-05-14 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-05-14-80ef1083-10397-0 |
bf2d88514efe9ba690d9bcb361b4b138e3b0d7c9 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-04-30 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-04-30-80ef1083-10397-0 |
d113075cfd3bb8ff72c51270b2f0b82efa65d807 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-04-16 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-04-16-80ef1083-10397-0 |
0431a0cd5c3619bf7db1120e0e97514fe4e6e542 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-03-19 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-03-19-80ef1083-10397-0 |
82e34a646eac60904fe59a6aeaf2197c5cf5a87a | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-03-05 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-03-05-80ef1083-10397-0 |
fcf7350f5e3838b240d7f9e808e3c9a3a0d2b4e8 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-02-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-02-20-80ef1083-10397-0 |
614cc9fc1417b5777131aa291be298f3300babcf | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-01-30 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-01-30-80ef1083-10397-0 |
d23ff74be45b19c773db509f55d6d7ffdfa19749 | Amount of donation (or estimate of the probable value): Exact amount unknown but between £1,500 and £2,000 | Overseas visits 80ef1083 | 2012-01-13 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2012-01-13-80ef1083-10397-0 |
6c14674996c4756a1b12036c40feb0cb6c1d3db4 | Name of donor: Mr Michael Hintze | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2011-12-13-84642823-10397-0 |
6a390acf38839d5a73dc8a1b92b070eb1b68676e | Name of donor: Mr Michael Hintze | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2011-11-29-84642823-10397-0 |
49934a2238064f17f25e298bb44c0bce50d4c632 | Name of donor: Mr Michael Hintze | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-16 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2011-11-16-84642823-10397-0 |
b8979d7b9a51f25c3319d3023e2b503c86ca19e2 | Name of donor: Mr Michael Hintze | Gifts, benefits and hospitality (UK) 84642823 | 2011-10-31 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2011-10-31-84642823-10397-0 |
fdca741e9bcd6123e4987f606ebc8127d1897c46 | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2010-10-25 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2010-10-25-84642823-10397-0 |
f4ce70632b7f6698f73e95349bffa8436cbfd6cb | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2010-09-06 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2010-09-06-84642823-10397-0 |
70fc8bd9140a8390e8e9198804ac288d785ef3e1 | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2010-04-12-84642823-10397-0 |
ded5ca0608c25d33ae7ce10e12eab8a44c01d495 | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2010-03-24 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2010-03-24-84642823-10397-0 |
56ec7fce7eb99d6d022c928878936c3c41039236 | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2010-03-10 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2010-03-10-84642823-10397-0 |
0255afe1c24ffac828efe857a55988f435dc876a | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-24 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2010-02-24-84642823-10397-0 |
cdcfe8fb37c47178f5f19c5f9b7b57ebb6f1bad2 | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-03 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2010-02-03-84642823-10397-0 |
9c34bb1653ebef1d2621717700fc879173d72916 | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2010-01-06 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2010-01-06-84642823-10397-0 |
64225762bce2aceb41dc6ec76483a87a4781af2c | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2009-12-10 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2009-12-10-84642823-10397-0 |
acb740f8e190405c4e0439a2e5b143a240b41349 | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2009-11-25 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2009-11-25-84642823-10397-0 |
2ef7b51dd221f736c22e1db9bd010531db033f33 | Address of donor : Norder House, Beech Lawn, Green Lane, Derby, Derbyshire DE56 1BY | Gifts, benefits and hospitality (UK) 84642823 | 2009-11-11 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2009-11-11-84642823-10397-0 |
7725694d372f99531a7098f8a9bdfc46b5388db3 | Longcliffe Quarries. | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2006-05-12-9e46def6-10397-0 |
4ee9e903208db3eae4670620ecded84f2610d0b5 | Longcliffe Quarries. | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2006-03-24-9e46def6-10397-0 |
98de343f0b88f036a8d1522a5284fc23588f841f | Longcliffe Quarries. | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2006-02-14-9e46def6-10397-0 |
5721d227e937020fd0308b1f60145ab122b47ce9 | Longcliffe Quarries. | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2006-02-13-9e46def6-10397-0 |
ab25569b3f547b8d571ab9ec72ce132b11162aa1 | Longcliffe Quarries. | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2005-12-14-9e46def6-10397-0 |
de9ca7086645241711e8acb3b439c4a27fb71e78 | Longcliffe Quarries. | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Patrick McLoughlin uk.org.publicwhip/member/1536 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 2 | 2005-11-01-9e46def6-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");