items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
170 rows where record_id = "2010-10-25-8f616a6e-11545-0" sorted by sort_order descending
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order ▲ | record_id |
---|---|---|---|---|---|---|---|
2cb31decc341bcc614012edf0d390d59b75fc8cd | Donor status: company, registration number 04166416 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 145 | 2010-10-25-8f616a6e-11545-0 |
76e39b67488d0fd21fd5d652a1908d93c654a4e4 | Address of donor: Richard House, Winckley Square, Preston, Lancashire PR1 3HP. | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 141 | 2010-10-25-8f616a6e-11545-0 |
205e28e35436c741c0ed97c4bc23c1f8292c404b | Name of donor: Landlegend Ltd | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 140 | 2010-10-25-8f616a6e-11545-0 |
05c2ce7a8b728e7ae58cd64a3fbb587c0a553e6e | Donor status: company, registration number 02722448 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 138 | 2010-10-25-8f616a6e-11545-0 |
305f982f22d307d48cf751fa0e24f6c27123327f | Amount of donation or nature and value if donation in kind: £25,000 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 135 | 2010-10-25-8f616a6e-11545-0 |
444bd0513c75dd522622daad9853a1733bbdcf82 | Address of donor: 6th Floor, Ingeni Building, 17 Broadwick Building, London W1F 0AX. | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 134 | 2010-10-25-8f616a6e-11545-0 |
bf6db880256e3aa6207c110fe17f8b06fad8a0b9 | Name of donor: GLC Ltd | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 133 | 2010-10-25-8f616a6e-11545-0 |
423c812dbe3ad75fa12f15d69dd08eab935995b4 | Amount of donation or nature and value if donation in kind: auction prize worth £2,000 for a fundraising dinner | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 128 | 2010-10-25-8f616a6e-11545-0 |
88aa39a391804fbcc5011673d5a25ec6553cefec | Name of donor: Clive Jones | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 126 | 2010-10-25-8f616a6e-11545-0 |
d991a5cd012125f6251b04246b4316f39266048b | Date of receipt: 29 July 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 122 | 2010-10-25-8f616a6e-11545-0 |
097b87ebc7c32b537b4ee0306756709aa9dabf99 | Amount of donation or nature and value if donation in kind: £2,000 cash donation | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 121 | 2010-10-25-8f616a6e-11545-0 |
6357da191e9e087b49c61cf7c2db1249148ab8dd | Date of acceptance: 2 August 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 116 | 2010-10-25-8f616a6e-11545-0 |
c17411c90cb8c1fd2cb679d39d92734e9800506e | Date of receipt: 27 July 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 115 | 2010-10-25-8f616a6e-11545-0 |
f277876e54dfc8bbb2a065b5f611c1542d886eeb | Amount of donation or nature and value if donation in kind: £1,501 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 114 | 2010-10-25-8f616a6e-11545-0 |
f3320149c7e62daddaa45d67c4e5216374d0ad1c | Name of donor: Anthony Burton | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 112 | 2010-10-25-8f616a6e-11545-0 |
ab68847f8cde0a29fe53c36d9830b06064a3b0e2 | Date of acceptance: 17 August 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 109 | 2010-10-25-8f616a6e-11545-0 |
8090c8e29c772ecf6cc7d6925f7643f9226f5fd0 | Date of receipt: 12 August 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 108 | 2010-10-25-8f616a6e-11545-0 |
64134e2671a8d6627ee6f83f067e5bade74072c7 | Amount of donation or nature and value if donation in kind: £100,000 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 107 | 2010-10-25-8f616a6e-11545-0 |
36151ee03e6f0ebc2fec320eb73d636ddaf1b62a | Address of donor: 35 King Street, Covent Garden, London WC2E 8JG. | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 106 | 2010-10-25-8f616a6e-11545-0 |
1c25250faf785913d277a0a4ed6f4a4ffbd697b4 | Name of donor: Unite | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 105 | 2010-10-25-8f616a6e-11545-0 |
8b7a574ac08e32ff61edbd4deea1b4ed3103d858 | Date of acceptance: 28 August 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 102 | 2010-10-25-8f616a6e-11545-0 |
ec18c9145754b7fae6751e3890b7a2589feaa437 | Date of receipt: 20 August 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 101 | 2010-10-25-8f616a6e-11545-0 |
5bcadd34f07cff388d4e6c671f6361cc53155513 | Address of donor: UCATT House, 177 Abbeville Road, London SW4 9RL. | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 99 | 2010-10-25-8f616a6e-11545-0 |
0a4500dd44d5c5febbc3c8af508755b32ee1bd8e | Name of donor: Union of Construction, Allied Trades and Technicians | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 98 | 2010-10-25-8f616a6e-11545-0 |
0a5ca95d6ec70b6beda2442699040bd6de8aae28 | Name of donor: Flora Fraser Soros | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 91 | 2010-10-25-8f616a6e-11545-0 |
b7df1c34af33f40e888d06bb6c540bea13babb64 | (Registered 29 July 2010) | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 90 | 2010-10-25-8f616a6e-11545-0 |
792f35da094e2431964be0c92eceb6a91ab2a93a | Date of acceptance: 9 July 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 88 | 2010-10-25-8f616a6e-11545-0 |
b04bf4634a44172dd66924874ae31630e9d7ffe6 | Date of receipt: 9 July 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 87 | 2010-10-25-8f616a6e-11545-0 |
66a845f00542dedbb1b1e6f4fd0f06adf8195610 | Donor status: company No 03408967 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 82 | 2010-10-25-8f616a6e-11545-0 |
6302f9f35180d998f2ff252c0d4ba9f1bf9c0593 | Date of acceptance: 22 July 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 81 | 2010-10-25-8f616a6e-11545-0 |
7b7d7973e3ba581b5afbb53b9cf9710f149cf6dd | Date of receipt: 22 July 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 80 | 2010-10-25-8f616a6e-11545-0 |
fb58239e0f5b364d9ef0b2dc866ac2eac4099b47 | Address of donor: 14 St Mary’s Street Stamford Lincs PE9 2DF | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 78 | 2010-10-25-8f616a6e-11545-0 |
fc4e9c579e4d4aa66f5583c9fe372acef9820784 | Name of donor: Betterworld Limited | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 77 | 2010-10-25-8f616a6e-11545-0 |
bb770496915540e0fec3e44fe5d67b5b3acb02d0 | Donor status: trade union | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 75 | 2010-10-25-8f616a6e-11545-0 |
62f66041920a36dc4b4b2dbe1d394d74696f2c55 | Amount of donation or nature and value if donation in kind: £28,000 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 72 | 2010-10-25-8f616a6e-11545-0 |
31abfff977acf163a8e3d775454d33810b734f47 | Address of donor: 22/24 Worple Road The Ridgeway Wimbledon London SW19 4DD | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 71 | 2010-10-25-8f616a6e-11545-0 |
815d9c0116f0fb821dc9d4ce90bf96ecfd665784 | Name of donor: GMB | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 70 | 2010-10-25-8f616a6e-11545-0 |
2cbf0b2698af061aab64ecd4b67b5cc50699e45e | Donor status: company No 04683806 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 68 | 2010-10-25-8f616a6e-11545-0 |
92643bd219a44d6c520b663e4c6f1da7846db07b | Address of donor: Wellington House Cliff Parade Bruntcliffe Road Morley Leeds LS27 0RY | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 64 | 2010-10-25-8f616a6e-11545-0 |
d3e27be51e9ba49d9f96cd3953f6b403a4a72c67 | Name of donor: QHotels Group Limited | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 63 | 2010-10-25-8f616a6e-11545-0 |
2fa07337ae01cb9e21be85c10dcb991edc591c3f | (Registered 15 July 2010) | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 62 | 2010-10-25-8f616a6e-11545-0 |
c841945eaf52568b0b0d75ecde4a56c4eca58c51 | Date of acceptance: 11 June 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 60 | 2010-10-25-8f616a6e-11545-0 |
991a9f5fac7b073f6880ba0f1287abf61742176e | Date of receipt: 1 June 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 59 | 2010-10-25-8f616a6e-11545-0 |
cc658c85a00e3881bacffa2271bb55b96319b65a | Amount of donation or nature and value if donation in kind: office space for three months, value £2,250 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 58 | 2010-10-25-8f616a6e-11545-0 |
d5d200d1310241031b2e97d22d0b9fe384094aef | Name of donor: Roland Marcelin-Horne | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 56 | 2010-10-25-8f616a6e-11545-0 |
76e04b1f7dee3caeae18ffbb0561f484acf193f2 | Date of acceptance: 21 June 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 53 | 2010-10-25-8f616a6e-11545-0 |
0cbf07be067e118ab55e5abae136e67dae41ec1f | Date of receipt: 21 June 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 52 | 2010-10-25-8f616a6e-11545-0 |
92bf579c6fed301dc4057b371d995571e3ca1599 | Name of donor: Emily Thornberry | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 49 | 2010-10-25-8f616a6e-11545-0 |
76365ffce8a1082fd41a7bee9073496b3fe4bb85 | Date of acceptance: 12 July 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 46 | 2010-10-25-8f616a6e-11545-0 |
40099f7154cab5921b1b030d61424893421b57b2 | Date of receipt: 12 July 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 45 | 2010-10-25-8f616a6e-11545-0 |
4ed5c83800cf1aef3c9bf057c29cce4469b37b65 | Amount of donation or nature and value if donation in kind: £2,200 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 44 | 2010-10-25-8f616a6e-11545-0 |
af35fb54e57a051af2a36bfd8cee0d280f8b466e | Name of donor: Mark Latham | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 42 | 2010-10-25-8f616a6e-11545-0 |
db2ba190b5d0747b408484797583857f68043cd1 | (Registered 18 June 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 41 | 2010-10-25-8f616a6e-11545-0 |
c617d1b65c6570509d24b4939a4ea8c54592a958 | Name of donor: Stewart Thornton | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 35 | 2010-10-25-8f616a6e-11545-0 |
00099bce929bf778b45a14f9b3bd95ca1f8f6506 | (Registered 18 June 2010) | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 34 | 2010-10-25-8f616a6e-11545-0 |
3d046b6156cd4dff9550741c03ac622a50438eff | Name of donor: Margaret Thornton | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 28 | 2010-10-25-8f616a6e-11545-0 |
b016519c38f817c968fa4a9a2782653fad317b7a | Date of acceptance: 7 June 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 25 | 2010-10-25-8f616a6e-11545-0 |
20650cbe90a3873ecc38092f4470204eb0267f82 | Date of receipt: 7 June 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 24 | 2010-10-25-8f616a6e-11545-0 |
08143a3cb88f0b7fa09033af5e68ee3d247e266e | Name of donor: Lord Evans of Watford | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 21 | 2010-10-25-8f616a6e-11545-0 |
cd30e58eaa1bac04d59208509dcbd6374ba6bf57 | Date of acceptance: 4 June 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 18 | 2010-10-25-8f616a6e-11545-0 |
e5f5933303c5c5f0854d79ff660a5216c7c13ee8 | Date of receipt: 25 May 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 17 | 2010-10-25-8f616a6e-11545-0 |
4cf46f4b1ba8a47e0eca8eaedb201f95a6d2a5c7 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 16 | 2010-10-25-8f616a6e-11545-0 |
58af3fd3b04a7651a0b7b692bbb0875da9e4260a | Date of acceptance: 21 May 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 11 | 2010-10-25-8f616a6e-11545-0 |
bfd54caf65aa483f046bbca606f35ee11ce5848d | Date of receipt: 21 May 2010 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 10 | 2010-10-25-8f616a6e-11545-0 |
5cf621c04aa1cbc6dddf4a1a31e08fc6135bf7b4 | Name of donor: Ann Limb | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 7 | 2010-10-25-8f616a6e-11545-0 |
2eb2232ec887fac9ce8256f8aefe4289fa573e80 | Donations to support my campaign for leadership of the Labour Party: | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 6 | 2010-10-25-8f616a6e-11545-0 |
094c7a85cd86a9ed1b0e05a57e0649e9f7c8230d | Amount of donation or nature and value if donation in kind: donation of £2,000 | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 3 | 2010-10-25-8f616a6e-11545-0 |
8084777d0bb851e9bd90ea5765933733b2a15a90 | Address of donor: 35 King Street London WC2E 8JG | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 2 | 2010-10-25-8f616a6e-11545-0 |
525f9fa86ba7579cfa4fda1462c8752b0cbc6b6e | Name of donor: UNITE | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 1 | 2010-10-25-8f616a6e-11545-0 |
f956110cfd21a63384dc604367548d59d9e1df0e | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-10-25 | Edward Miliband uk.org.publicwhip/member/40208 | Ed Miliband uk.org.publicwhip/person/11545 | 0 | 2010-10-25-8f616a6e-11545-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");