items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
54 rows where record_id = "2013-05-07-1f359ece-10050-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 |
---|---|---|---|---|---|---|---|
c38c3fa9be866d7408be129d6655c862f143b9f2 | Payments for articles published by The Yorkshire Post, Wellington Street, Leeds LS1 1RF: | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 0 | 2013-05-07-1f359ece-10050-0 |
87745eec9df9f4274c9a2d307f5d6345100763f6 | 23 July 2012, I received a payment of £150. Hours: 3 hrs. (Registered 20 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 1 | 2013-05-07-1f359ece-10050-0 |
0233ac505c0c7373e8396049547977eca1b82204 | 13 August 2012, I received a payment of £150. Hours: 2 hrs. (Registered 20 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 2 | 2013-05-07-1f359ece-10050-0 |
794490e6e3f0bca3beba19be75547883cba76a43 | 12 November 2012, I received a payment of £150. Hours: 2.5 hrs. (Registered 22 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 3 | 2013-05-07-1f359ece-10050-0 |
7ef0bf32f30c9e0e5d9454bd753d7039d98b8179 | 4 February 2013, I received a payment of £300 for two articles. Hours: 6 hrs. (Registered 14 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 4 | 2013-05-07-1f359ece-10050-0 |
cb764d71f30afab3d9c36b3d046a92248b25ebd2 | 2 April 2013, I received a payment of £180 for articles written. Hours: 2.5 hrs. (Registered 17 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 5 | 2013-05-07-1f359ece-10050-0 |
d3e590fe6516e63b5449692030533ed21246712f | 8 April 2013, I received a payment of £150 for an article. Hours: 2.5 hrs. (Registered 30 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 6 | 2013-05-07-1f359ece-10050-0 |
b66817fc7d0289ec8b5448437e03ae9dfea4aa39 | Payments for articles written for Associated Newspapers Ltd, 2 Derry Street, London W8 5TT: | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 7 | 2013-05-07-1f359ece-10050-0 |
d34bc6dabe416a66f5664d32fe755bb2d9482109 | 23 April 2012, I received £3,000 for articles. Hours: 5 hrs. (Registered 3 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 8 | 2013-05-07-1f359ece-10050-0 |
f228f2b0c8c8de3dfeb8b25ede79fe5737f77356 | 21 May 2012, I received £3,000 for articles. Hours: 5 hrs. (Registered 6 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 9 | 2013-05-07-1f359ece-10050-0 |
06050520b267aac5ae25d1a044bfedc86216b125 | 25 June 2012, I received £3,000 for articles. Hours: 5 hrs. (Registered 5 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 10 | 2013-05-07-1f359ece-10050-0 |
5cb04ca9190a2be2dd300681365e31f9486bed66 | 23 July 2012, I received £3,000 for articles. Hours: 7 hrs. (Registered 20 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 11 | 2013-05-07-1f359ece-10050-0 |
ea5030f177d1427d93e414c10cf79c2f17942afd | 24 August 2012, I received £3,000 for articles. Hours: 5 hrs. (Registered 7 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 12 | 2013-05-07-1f359ece-10050-0 |
18d7ce9ce4565615d4cc430b2e6d309573a8bd06 | 1 October 2012, I received £3,000 for articles. Hours: 5 hrs. (Registered 4 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 13 | 2013-05-07-1f359ece-10050-0 |
c6cbc584e481644e7d43850e3d33d273c4b3efe0 | 10 December 2012, I received £3,000 for articles. Hours: 5 hrs. (Registered 18 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 14 | 2013-05-07-1f359ece-10050-0 |
e5dcd93b7c5f4311a4ac208bcd4f43842d1f9cb9 | 10 December 2012, I received £3,000 for articles. Hours: 6 hrs. (Registered 19 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 15 | 2013-05-07-1f359ece-10050-0 |
97999587a33bc50fee554796343faf7c457a9383 | 25 March 2013, I received £3,000 for articles. Hours: 8 hrs. (Registered 27 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 16 | 2013-05-07-1f359ece-10050-0 |
dcd90f6074eb21d45c5a3fc8d132a3a90d4ead8c | 25 March 2013, I received £3,000 for articles. Hours: 6 hrs. (Registered 5 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 17 | 2013-05-07-1f359ece-10050-0 |
77e1558608c955c40952a3f2cd78d3fdc9a6e947 | 25 March 2013, I received £3,000 for articles. Hours: 7 hrs. (Registered 10 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 18 | 2013-05-07-1f359ece-10050-0 |
c005acd20cbcffb0999f62a3a1f1b858ce5d37b0 | 25 March 2013, I received £2,000 for articles. Hours: 3 hrs. (Registered 17 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 19 | 2013-05-07-1f359ece-10050-0 |
8555f069eb292af102c0fa9e1973b61d9a13bb5d | 22 April 2013, I received £2,000 for articles. Hours: 5 hrs. (Registered 30 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 20 | 2013-05-07-1f359ece-10050-0 |
0668e047cbbb0c92c17dcfc119398c57475b05e3 | Payments from BBC: | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 21 | 2013-05-07-1f359ece-10050-0 |
c43e97af7245ff7ca832a0d29a1c5ff3560fe99b | 6 November 2012, I received £250 for taking part in the Sunday Morning Live Programme. Address of payer: Broadcasting House, Portland Place, London W1AA 1AA. Hours: 24 hrs. (Registered 22 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 22 | 2013-05-07-1f359ece-10050-0 |
ab9167ea3c8f10586f8b8fbf3a7e518640c92222 | Articles for the Radio Times. Address: Immediate Media Co Ltd, Media Centre, 201 Wood Lane , London W12 7TQ : | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 23 | 2013-05-07-1f359ece-10050-0 |
cddb1cddb10c8dea6de310a69650162857e6dd00 | A donation of £400 was made to charity for an article I wrote for The Radio Times. Address: Immediate Media Co Ltd, Media Centre, 201 Wood Lane, London W12 7TQ. Hours: 2.5 hrs. (Registered 22 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 24 | 2013-05-07-1f359ece-10050-0 |
003b54ebce0a37c39b9ee6d1b82303f88aa567f2 | 10 August 2012, I received £400 for an article. Hours: 3 hrs. (Registered 7 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 25 | 2013-05-07-1f359ece-10050-0 |
491200fe588294b552010352e6b70e68a591de81 | 28 September 2012, I received £400 for an article. Hours: 2.5 hrs. (Registered 9 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 26 | 2013-05-07-1f359ece-10050-0 |
1dbbc77896b25ac955585d10505907539728c7e4 | 16 July 2012, I received £4,250 for giving a speech at an event hosted by the Chartered Institute of Public Finance and Accountancy (CIPFA), 3 Robert Street, London WC2N 6RL. Hours: 6 hrs. (Registered 20 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 27 | 2013-05-07-1f359ece-10050-0 |
01741360433119d7509174ea8cc885cd4018e097 | Payments for articles written for Building Magazine, Ludgate House, 245 Blackfriars Road, London SE1 9UY: | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 28 | 2013-05-07-1f359ece-10050-0 |
103fe1924cf0d90f272f6f2d012ebf986b762bfa | 10 October 2012, I received £500 for an article. Hours: 3 hrs. (Registered 30 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 29 | 2013-05-07-1f359ece-10050-0 |
d2b7fbc5f020854f75f606eadc266dfc7d06def2 | 22 October 2012, I received £500 for an article. Hours: 3 hrs. (Registered 12 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 30 | 2013-05-07-1f359ece-10050-0 |
abef41e7a3c85a44cd7921395a06114376a5ae95 | 22 March 2013, I received £500 for an article. Hours: 3 hrs. (Registered 5 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 31 | 2013-05-07-1f359ece-10050-0 |
4cf56232b7a49422081a54482b966f29cc6611d4 | 14 August 2012, I received £350 from The Times Educational Supplement, Sovereign Park, Lathkill Street, Market Harborough, Lecistershire LE16 9EF, for an article. Hours: 3 hrs. (Registered 7 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 32 | 2013-05-07-1f359ece-10050-0 |
2fdef54601c9c398e69559e6f958465ea0e2f7c1 | Payments from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 33 | 2013-05-07-1f359ece-10050-0 |
71287e6a53ed5d4df733df33cce408801f1604e8 | 27 September 2012, I received £90 for an article. Hours: 2 hrs. (Registered 4 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 34 | 2013-05-07-1f359ece-10050-0 |
c8bdeec717d5765fcf1987eded845362aa39c947 | 9 January 2013, I received £310 for an article. Hours: 2 hrs. (Registered 11 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 35 | 2013-05-07-1f359ece-10050-0 |
910eb0089e7c5fee6794c26d960794de6a6be680 | 25 September 2012, I received 6 bottles of wine, approximate cost of £120, for a speech I gave at Devonshire House, One Heddon Street, London W1B 4BD. Hours: 2 hrs. (Registered 12 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 36 | 2013-05-07-1f359ece-10050-0 |
570714c085fb59c995c6ff816997ff51401e44e5 | On 6 October 2012 I gave two speeches for Cunard, Carnival House, 100 Harbour Parade, Southampton, Hampshire SO15 1ST, for which I received flights to New York and accommodation and food for two people on a one way sailing from New York to Southampton, to the approximate value of £7,000. Hours: 5 hrs. (Registered 9 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 37 | 2013-05-07-1f359ece-10050-0 |
70e724be4b5cccd571228051d859a40482feba99 | 18 October 2012, I received £5,000 from Security Partnership Ltd, Unit 5, Winnersh Fields, Gazelle Close, Winnersh, Reading RG41 5QS, for a speech. Hours: 5 hrs. (Registered 30 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 38 | 2013-05-07-1f359ece-10050-0 |
60c983a216cbe1eb1ec8ef41cdddb1e5252f0318 | 5 November 2012, the Centre for Social Justice, Victoria Charity Centre, 11 Belgrave Road, London SW1V 1RB, donated £5,000 as a one off payment to charity for intermittent advice and being part of their advisory board. Hours: 3 hrs per session, 3 times a year. (Registered 22 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 39 | 2013-05-07-1f359ece-10050-0 |
f2cff22a8f858532384dff3b5fc4f8cf82f8e3b9 | 11 December 2012, I received £4,250 from Education Investor Magazine, Investor Publishing, Greener House, 66-68 Haymarket, London SW1Y 4RF, for hosting their awards ceremony. Hours: 6 hrs. (Registered 18 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 40 | 2013-05-07-1f359ece-10050-0 |
a11799300b65e8e9e9af43bb539e51e8be2aa29e | 11 December 2012, I received £3,825 from the Catering Equipment Suppliers Association, 3 Albert Embankment, London SE1 7SL, for a speech. Hours: 8 hrs. (Registered 18 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 41 | 2013-05-07-1f359ece-10050-0 |
66dd9e285ad1b9c9dd82f14e8802b81ab86ac86e | 11 December 2012, I took part in a seminar for Websense, 420 Thames Valley Park, Reading, Berks RG6 1PU, for which they agreed to donate £1,000 to a charity. Hours: 5 hrs. (Registered 18 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 42 | 2013-05-07-1f359ece-10050-0 |
dcfd3056f9422924c87e3b4998809f624c0910aa | 18 December 2012, I received £4,250 for a speech at an event organised by Runwood Care Home Group Ltd. Address: Runwood Homes, Runwood House, 107 London Road, Hadleigh, Benfleet, Essex, SS7 2QL. Hours: 8 hrs. (Registered 11 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 43 | 2013-05-07-1f359ece-10050-0 |
4fe7bee8dea19141efb6e7f75b2a25b1bc3eff89 | 28 January 2013, I received £4,250 from Civica PLC, 2 Burston Road, London SW15 6AR, for taking part in a panel debate. Hours: 7 hrs. (Registered 14 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 44 | 2013-05-07-1f359ece-10050-0 |
18e98330eed2598e22ff45175738278b8cf3c7c9 | 15 February 2013, I received £250 from the University of East Anglia, Norwich Research Park, Norwich, Norfolk NR4 7TJ, for a lecture. Hours: 11 hrs. (Registered 22 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 45 | 2013-05-07-1f359ece-10050-0 |
f23fd12f360ed7b4935e2d961418b018a7e10ddf | 19 March 2013, I received £5,525 from Pearson PLC, Ludgate House, 245 Blackfriars Road, London SE1 9UY, for speaking at two conferences organised by Pearson PLC. Hours: 9 hrs. (Registered 5 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 46 | 2013-05-07-1f359ece-10050-0 |
e4ffc529aad2b7ae6692f25ea2f298083cc1f4cf | 22 March 2013, I received £500 from Building Magazine (Ludgate House, 245 Blackfriars Road, London SE1 9UY) for an article I wrote. Hours: 4 hrs. (Registered 10 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 47 | 2013-05-07-1f359ece-10050-0 |
134300a0620e77bee4501693903ea67636e365f5 | 25 March 2013, I received £2,000 from Roy Newey Growth Partnership (28 School Lane, Hartford, Cheshire CW8 1PE) for a speech. Hours: 6 hrs. (Registered 10 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 48 | 2013-05-07-1f359ece-10050-0 |
d4b0cd98bddfc9bcc32bc8edc38a083c9a501b15 | 26 March 2013, I received £2,677 from Liverpool Mutual Homes, Commutation Plaza, Commutation Row, Liverpool L3 8QF for a speech I gave. Hours: 8 hrs. (Registered 17 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 49 | 2013-05-07-1f359ece-10050-0 |
b21895039c8dff1997e2ef7e3e8a291ca31be8cf | 22 March 2013, I received £500 from Building Magazine , Ludgate House, 245 Blackfriars Road, London SE1 9UY, for an article I wrote. Hours: 2.5 hrs. (Registered 17 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 50 | 2013-05-07-1f359ece-10050-0 |
40672fefe3ae4b7d6d515bb3f4a555aa020a6bea | 23 April 2013, I received £400 from The Sunday Times, 3 Thomas More Square, London E98 1RL, for an article. Hours: 3 hrs. (Registered 30 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 51 | 2013-05-07-1f359ece-10050-0 |
93492b045b7e155a42f9d6949ff2e9537cad362d | 8. Land and Property | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 52 | 2013-05-07-1f359ece-10050-0 |
d51e14037132a9e43bb7ba89b0d50eac8146cfbb | House in London, from which rental income is received. | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | David Blunkett uk.org.publicwhip/member/40527 | David Blunkett uk.org.publicwhip/person/10050 | 53 | 2013-05-07-1f359ece-10050-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");