home / regmem

items

Data source: mySociety Data

8 rows where record_id = "2012-01-30-8f616a6e-10326-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
0007d687ac28d99477b9324c7abf0dba022bc628 Support in the capacity as an MP: Sponsorships 8f616a6e 2012-01-30 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 0 2012-01-30-8f616a6e-10326-0
c49040d2fbaceb4108cc1e0f5e83da4ddca39698 Name of donor: Politicshome Sponsorships 8f616a6e 2012-01-30 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 1 2012-01-30-8f616a6e-10326-0
f11f7e826310358dbd3f5f8d7cd97e07ecfe4cee Address of donor: 5 The Sanctuary, London SW1P 3JS Sponsorships 8f616a6e 2012-01-30 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 2 2012-01-30-8f616a6e-10326-0
8e50507c14bf2d62898de22709ff1715e5be02a1 Amount of donation or nature and value if donation in kind: free use of Politicshome ‘pro’ service for Tessa Jowell and up to four members of staff, each subscription worth £424.68 +VAT; total value £2,123.40+VAT Sponsorships 8f616a6e 2012-01-30 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 3 2012-01-30-8f616a6e-10326-0
a1c9ea927ad94eb96bac5b769a8c9202ef241cd9 Date of receipt: August 2010 Sponsorships 8f616a6e 2012-01-30 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 4 2012-01-30-8f616a6e-10326-0
727039cab5f650ef8de849814d0a52f2ca645916 Date of acceptance: October 2010 Sponsorships 8f616a6e 2012-01-30 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 5 2012-01-30-8f616a6e-10326-0
b5552a08a4625e4f620ffe59124c51611720cfc6 Donor status: company, registration 07053138 Sponsorships 8f616a6e 2012-01-30 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 6 2012-01-30-8f616a6e-10326-0
815f825cc8f762eeaaa9cd5fb20887f4d515b9e8 (Registered 4 November 2010) Sponsorships 8f616a6e 2012-01-30 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 7 2012-01-30-8f616a6e-10326-0

Advanced export

JSON shape: default, array, object

CSV options:

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)
    )
Powered by Datasette · Query took 5.652ms · Data source: mySociety Data