home / regmem

items

Data source: mySociety Data

10 rows where record_id = "2012-03-19-84642823-10314-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
f96451aadf500d8187f9187a873fbe408e3f100d Amount of donation or nature and value if donation in kind: attendance at Brit Awards (with my son); value £1,996 Gifts, benefits and hospitality (UK) 84642823 2012-03-19 uk.org.publicwhip/member/40346 Alan Johnson uk.org.publicwhip/person/10314 2 2012-03-19-84642823-10314-0
9a08c00d13431efd8b479eea68a3f03c8982b8b9 Date of receipt of donation: 15 February 2011 Gifts, benefits and hospitality (UK) 84642823 2012-03-19 uk.org.publicwhip/member/40346 Alan Johnson uk.org.publicwhip/person/10314 3 2012-03-19-84642823-10314-0
0001fa098989fda1db7a2435430fd58ed1cf773e Date of acceptance of donation: 15 February 2011 Gifts, benefits and hospitality (UK) 84642823 2012-03-19 uk.org.publicwhip/member/40346 Alan Johnson uk.org.publicwhip/person/10314 4 2012-03-19-84642823-10314-0
7f9b1dd4326916fe02310707e7556c54a593887f (Registered 6 June 2011) Gifts, benefits and hospitality (UK) 84642823 2012-03-19 uk.org.publicwhip/member/40346 Alan Johnson uk.org.publicwhip/person/10314 6 2012-03-19-84642823-10314-0
441aa2f714e1a21768a4b7d5e05fb858f91afaba Name of donor: Phonographic Performance Ltd (PPL) Gifts, benefits and hospitality (UK) 84642823 2012-03-19 uk.org.publicwhip/member/40346 Alan Johnson uk.org.publicwhip/person/10314 7 2012-03-19-84642823-10314-0
3f76a5649bf7b6d68b3e4b5ff6de28a221829a6c Address of donor : 1 Upper James Street, London W1F 9DE Gifts, benefits and hospitality (UK) 84642823 2012-03-19 uk.org.publicwhip/member/40346 Alan Johnson uk.org.publicwhip/person/10314 8 2012-03-19-84642823-10314-0
c2109bc8adcd95a3592c17dd35530032422457b4 Amount of donation or nature and value if donation in kind: attendance at Brit Awards with my wife; value £1,996 Gifts, benefits and hospitality (UK) 84642823 2012-03-19 uk.org.publicwhip/member/40346 Alan Johnson uk.org.publicwhip/person/10314 9 2012-03-19-84642823-10314-0
64c487692aa20548995adc840419c1b75765e600 Date of receipt of donation: 21 February 2012 Gifts, benefits and hospitality (UK) 84642823 2012-03-19 uk.org.publicwhip/member/40346 Alan Johnson uk.org.publicwhip/person/10314 10 2012-03-19-84642823-10314-0
004fe9d96deb905e298be95a3b557fa066c9423e Date of acceptance of donation: 21 February 2012 Gifts, benefits and hospitality (UK) 84642823 2012-03-19 uk.org.publicwhip/member/40346 Alan Johnson uk.org.publicwhip/person/10314 11 2012-03-19-84642823-10314-0
43dccad581a69c70eb0378fcbd476d897af1e8cc Donor status: company registration number 288046. Gifts, benefits and hospitality (UK) 84642823 2012-03-19 uk.org.publicwhip/member/40346 Alan Johnson uk.org.publicwhip/person/10314 12 2012-03-19-84642823-10314-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 69.418ms · Data source: mySociety Data