items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
63 rows where category_id = "8e53f3ff" and member_id = "uk.org.publicwhip/member/40090" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
379634dfcb3be0ef9557cabe99543a005a819275 | Name of donor: Medical Aid for Palestinians | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2014-12-08-8e53f3ff-10574-0 |
3992ce8231b35380c9e2600b7d2b1c26cac0dec2 | Address of donor: 33a Islington Park Street, London N1 1QB Amount of donation (or estimate of the probable value): travel costs, accommodation and subsistence with a value of £1,175 | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2014-12-08-8e53f3ff-10574-0 |
6f63b813d2f3ffbb6db3b74bc4732bff0c853021 | Destination of visit: West Bank and Israel | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2014-12-08-8e53f3ff-10574-0 |
ff83724607baab4def1d7c02e94b65f40323c75f | Date of visit: 9-13 December 2013 | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2014-12-08-8e53f3ff-10574-0 |
85764801347ce0c729875971ef0e3074d2280115 | Purpose of visit: Fact-finding delegation organised by Council for Arab-British Understanding | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2014-12-08-8e53f3ff-10574-0 |
d05ba37b54fdddaf33c9b10c8d606565d3c388d9 | (Registered 17 December 2013) | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2014-12-08-8e53f3ff-10574-0 |
d809e626ddf5e492635e1e7cd9b5b4ba7be35515 | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2014-12-08-8e53f3ff-10574-0 | |
820b387d656f7d98d8d6a6eecd9f313fb45df6b2 | Name of donor: (1) Ardeshir Nagashineh, Chairman of Targetfollow PLC; (2) the Majlis , the Parliament of the Islamic Republic of Iran (Iran-United Kingdom Parliamentary Friendship Group) | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2014-12-08-8e53f3ff-10574-0 |
67aeb360cc4da2cf8186115a55081792bdd69268 | Address of donor: (1) Targetfollow Group Ltd, Riverside House, 11/12 Riverside Road, Norwich NR1 1SQ; (2) Baherestan Square, Tehran, Iran | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2014-12-08-8e53f3ff-10574-0 |
5a1245ef837c2cf10a3e885edb1ab6982a2a2c04 | Amount of donation (or estimate of the probable value): (1) £373.84, being the balance of the return flights from London to Tehran (via Frankfurt), Business Class, 6 and 10 January 2014. Total cost £1,623.84 – the remainder being met by a non-registrable source; (2) 4 nights hotel accommodation in Tehran at estimated cost of £392.84, plus meals and transport for 4 days at estimated cost of £300. | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2014-12-08-8e53f3ff-10574-0 |
c2290b4d54db37a404a35621e9027d055a50c438 | Destination of visit: Tehran, Iran | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2014-12-08-8e53f3ff-10574-0 |
14649192d3aef0d7552b58ddd29deb438a1ad0f0 | Date of visit: 6-10 January 2014 | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2014-12-08-8e53f3ff-10574-0 |
f04adf68b8eae2da97050ceee9e91aa49e875062 | Purpose of visit: visit by the All-Party Parliamentary Group on Iran at the invitation of the Iran-UK Parliamentary Friendship Group of the Iranian Parliament. | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2014-12-08-8e53f3ff-10574-0 |
fc752da48fe6b035915c555279a61eb294feb05e | (Registered 19 January 2014) | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2014-12-08-8e53f3ff-10574-0 |
506ba3b37c7e3731d1e4d9e749186089de1a50aa | Name of donor: Akfen Holding | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2014-12-08-8e53f3ff-10574-0 |
4ffa4bb06af141c37aa5c1ec63d3754203d8189b | Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2014-12-08-8e53f3ff-10574-0 |
294625c41d003812f949732d3cd577536af8e9c4 | Amount of donation (or estimate of the probable value): flights from Bursa to Ankara and back to Istanbul, with a value of £6,753.30 | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2014-12-08-8e53f3ff-10574-0 |
7a89524722d53e095870cdc5c4b0297646e5ee46 | Destination of visit: Ankara, Turkey | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2014-12-08-8e53f3ff-10574-0 |
f805925aa21cb5cdca3d77a72e956f8260ce7486 | Date of visit: 22 March 2014 | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2014-12-08-8e53f3ff-10574-0 |
4b78867122437b20b6b718d71f0aab59977f62ff | Purpose of visit: to meet a senior member of the Turkish government | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2014-12-08-8e53f3ff-10574-0 |
d8143d6dbd7292c271e9ce039f77600304a075c9 | (Registered 28 April 2014) | Overseas visits 8e53f3ff | 2014-12-08 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2014-12-08-8e53f3ff-10574-0 |
43344ad2951f928d5dc5cc84cc167d4eb27165c3 | Name of donor: Medical Aid for Palestinians | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2014-11-24-8e53f3ff-10574-0 |
a161fae519a672abfe2183348bb80c953c3adb30 | Address of donor: 33a Islington Park Street, London N1 1QB Amount of donation (or estimate of the probable value): travel costs, accommodation and subsistence with a value of £1,175 | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2014-11-24-8e53f3ff-10574-0 |
118409120eeef260e700b298ee758ed101c609ce | Destination of visit: West Bank and Israel | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2014-11-24-8e53f3ff-10574-0 |
1bba609a603f2dea86adf12e8ef20d5821d92488 | Date of visit: 9-13 December 2013 | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2014-11-24-8e53f3ff-10574-0 |
c7b6aa92743517d3b3ddf6d9c0f6aa35400a14b1 | Purpose of visit: Fact-finding delegation organised by Council for Arab-British Understanding | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2014-11-24-8e53f3ff-10574-0 |
9251d7c0434d39e31725fe0507ccdc4fbbe2546e | (Registered 17 December 2013) | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2014-11-24-8e53f3ff-10574-0 |
ebfa9405f101a2d6758f254423405853bd8b593e | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2014-11-24-8e53f3ff-10574-0 | |
d387fc90ce41f6be3b2b4651fb6d897c64f80d6e | Name of donor: (1) Ardeshir Nagashineh, Chairman of Targetfollow PLC; (2) the Majlis , the Parliament of the Islamic Republic of Iran (Iran-United Kingdom Parliamentary Friendship Group) | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2014-11-24-8e53f3ff-10574-0 |
d3a4794c455c40812db318b0fae162cfb67ddff6 | Address of donor: (1) Targetfollow Group Ltd, Riverside House, 11/12 Riverside Road, Norwich NR1 1SQ; (2) Baherestan Square, Tehran, Iran | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2014-11-24-8e53f3ff-10574-0 |
c87014f3c6129608e39c319c9a13038c4271f98f | Amount of donation (or estimate of the probable value): (1) £373.84, being the balance of the return flights from London to Tehran (via Frankfurt), Business Class, 6 and 10 January 2014. Total cost £1,623.84 – the remainder being met by a non-registrable source; (2) 4 nights hotel accommodation in Tehran at estimated cost of £392.84, plus meals and transport for 4 days at estimated cost of £300. | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2014-11-24-8e53f3ff-10574-0 |
7816935aa92e7570558b07cad8d3f54f6efcbf92 | Destination of visit: Tehran, Iran | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2014-11-24-8e53f3ff-10574-0 |
f83a07f3078bb4451a91a69896f763ac61190a59 | Date of visit: 6-10 January 2014 | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2014-11-24-8e53f3ff-10574-0 |
50a33ee9f2397a9474c1d8f893ef5c5355b46b10 | Purpose of visit: visit by the All-Party Parliamentary Group on Iran at the invitation of the Iran-UK Parliamentary Friendship Group of the Iranian Parliament. | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2014-11-24-8e53f3ff-10574-0 |
eb0e0e1c1045b63acf73ed735bceff4e71071f46 | (Registered 19 January 2014) | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2014-11-24-8e53f3ff-10574-0 |
c650f1a50d7df317c479e3003e11144c69e00358 | Name of donor: Akfen Holding | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2014-11-24-8e53f3ff-10574-0 |
1f11d086e4eb0f3df4f8d6a52ac318dd7c2ed9ea | Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2014-11-24-8e53f3ff-10574-0 |
366901a03c467f5bef986a7d8f3842b69e66014f | Amount of donation (or estimate of the probable value): flights from Bursa to Ankara and back to Istanbul, with a value of £6,753.30 | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2014-11-24-8e53f3ff-10574-0 |
39db40b1f5da8787c5bd33b58a63b6d81cb98b99 | Destination of visit: Ankara, Turkey | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2014-11-24-8e53f3ff-10574-0 |
5381c025cfabb3921a0439060496645c08e4718f | Date of visit: 22 March 2014 | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2014-11-24-8e53f3ff-10574-0 |
64e7a56bb2dc957c9682cd97c8eece1c154e765a | Purpose of visit: to meet a senior member of the Turkish government | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2014-11-24-8e53f3ff-10574-0 |
df48fb10799ec69945ef5d630d6204713d185d7b | (Registered 28 April 2014) | Overseas visits 8e53f3ff | 2014-11-24 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2014-11-24-8e53f3ff-10574-0 |
0d046106869fb910921a9d5fe172544116cae28f | Name of donor: Medical Aid for Palestinians | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2014-11-10-8e53f3ff-10574-0 |
21162c02f4d50577da414a7bbee69d9f7ede9fc9 | Address of donor: 33a Islington Park Street, London N1 1QB Amount of donation (or estimate of the probable value): travel costs, accommodation and subsistence with a value of £1,175 | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2014-11-10-8e53f3ff-10574-0 |
7cd7d16a91489b1913888b390c2354ba39d42592 | Destination of visit: West Bank and Israel | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2014-11-10-8e53f3ff-10574-0 |
0d32a91f4be6909e1e35766e252b33867684988b | Date of visit: 9-13 December 2013 | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2014-11-10-8e53f3ff-10574-0 |
4b14cdc38e74ed2b82592feff627d478629f7bd2 | Purpose of visit: Fact-finding delegation organised by Council for Arab-British Understanding | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2014-11-10-8e53f3ff-10574-0 |
276c54aab51e41fb8f3a7a47fa6a1fe4a37ce8b6 | (Registered 17 December 2013) | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2014-11-10-8e53f3ff-10574-0 |
9f3e80a3baff48a3ddb89cc41666c4d21c28d5b8 | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2014-11-10-8e53f3ff-10574-0 | |
ced5a5f1ed2f3404b5cf4f8d8bcc8be4453824f8 | Name of donor: (1) Ardeshir Nagashineh, Chairman of Targetfollow PLC; (2) the Majlis , the Parliament of the Islamic Republic of Iran (Iran-United Kingdom Parliamentary Friendship Group) | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2014-11-10-8e53f3ff-10574-0 |
a1ee2853fd221d858024cd0a8fae9d6536cffc3b | Address of donor: (1) Targetfollow Group Ltd, Riverside House, 11/12 Riverside Road, Norwich NR1 1SQ; (2) Baherestan Square, Tehran, Iran | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2014-11-10-8e53f3ff-10574-0 |
3663b06ebfc9c7f1e9de4175034997e78e521482 | Amount of donation (or estimate of the probable value): (1) £373.84, being the balance of the return flights from London to Tehran (via Frankfurt), Business Class, 6 and 10 January 2014. Total cost £1,623.84 – the remainder being met by a non-registrable source; (2) 4 nights hotel accommodation in Tehran at estimated cost of £392.84, plus meals and transport for 4 days at estimated cost of £300. | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2014-11-10-8e53f3ff-10574-0 |
02e633d42d89c25d44370f8c6c1584561ae829a1 | Destination of visit: Tehran, Iran | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2014-11-10-8e53f3ff-10574-0 |
0e9bc1132f6fde24ba168b20e0180e95da18ab61 | Date of visit: 6-10 January 2014 | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2014-11-10-8e53f3ff-10574-0 |
5a038f391c2aae4964144c7f56ea73a6510ca88d | Purpose of visit: visit by the All-Party Parliamentary Group on Iran at the invitation of the Iran-UK Parliamentary Friendship Group of the Iranian Parliament. | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2014-11-10-8e53f3ff-10574-0 |
fe83e611969aa24be44e3b5293ce435e012b7232 | (Registered 19 January 2014) | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2014-11-10-8e53f3ff-10574-0 |
830e5d9bf967a1ae2e87eac371bafc94408e0445 | Name of donor: Akfen Holding | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2014-11-10-8e53f3ff-10574-0 |
73eb3cab20915a1deda3b7c5fd4bbbeffb003a8a | Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2014-11-10-8e53f3ff-10574-0 |
c8292bd8750c9d391ab0b4e09b37b01064cd7cc3 | Amount of donation (or estimate of the probable value): flights from Bursa to Ankara and back to Istanbul, with a value of £6,753.30 | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2014-11-10-8e53f3ff-10574-0 |
2d3538f22f0862143fff9692445dce5cb4c9d6f0 | Destination of visit: Ankara, Turkey | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2014-11-10-8e53f3ff-10574-0 |
c3034cfd9f5e0ffa81ca47d6be06925d24d16eab | Date of visit: 22 March 2014 | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2014-11-10-8e53f3ff-10574-0 |
fc9cd93cfc591f70912753dee98e65706cad3fa6 | Purpose of visit: to meet a senior member of the Turkish government | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2014-11-10-8e53f3ff-10574-0 |
ecbc40c6fd57171135835c5a95dce388716df298 | (Registered 28 April 2014) | Overseas visits 8e53f3ff | 2014-11-10 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2014-11-10-8e53f3ff-10574-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");