home / regmem

items

Data source: mySociety Data

7 rows where record_id = "2014-11-24-84642823-11545-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
4f3e9931973d717cfd22a6a273585f9158569910 Name of donor: British Airways plc Gifts, benefits and hospitality (UK) 84642823 2014-11-24 uk.org.publicwhip/member/40208 Ed Miliband uk.org.publicwhip/person/11545 0 2014-11-24-84642823-11545-0
e41a3e6879db417f5ea94e7febd96bc6dcd80380 Address of donor: Waterside, PO Box 365, Harmondsworth, UB7 0GB Gifts, benefits and hospitality (UK) 84642823 2014-11-24 uk.org.publicwhip/member/40208 Ed Miliband uk.org.publicwhip/person/11545 1 2014-11-24-84642823-11545-0
07c8aed8136c3ccccd0b028e1ed3e7a6789bb886 Amount of donation or nature and value if donation in kind: Amount of donation or nature and value if donation in kind: short notice upgrades for me on return flights from London to Johannesburg and for my wife on outward flight only; 3 upgrades with a total estimated value of between £1,347 and £5,866. Gifts, benefits and hospitality (UK) 84642823 2014-11-24 uk.org.publicwhip/member/40208 Ed Miliband uk.org.publicwhip/person/11545 2 2014-11-24-84642823-11545-0
e360c34c056b53c0a15a588a42499ce086bb978a Date of receipt of donation: 9 and 10 December 2013 Gifts, benefits and hospitality (UK) 84642823 2014-11-24 uk.org.publicwhip/member/40208 Ed Miliband uk.org.publicwhip/person/11545 3 2014-11-24-84642823-11545-0
00011f2f5f0affc642ce0011d2b9ddd4ad137c65 Date of acceptance of donation: 10 December 2013 Gifts, benefits and hospitality (UK) 84642823 2014-11-24 uk.org.publicwhip/member/40208 Ed Miliband uk.org.publicwhip/person/11545 4 2014-11-24-84642823-11545-0
e5e6b7b72f2f7499be79a4137565b5bf8d057380 Donor status: company, registration 1777777 Gifts, benefits and hospitality (UK) 84642823 2014-11-24 uk.org.publicwhip/member/40208 Ed Miliband uk.org.publicwhip/person/11545 5 2014-11-24-84642823-11545-0
9da7ad6b382df848becff1ef0ad2d06c8bccf3e5 (Registered 27 December 2013) Gifts, benefits and hospitality (UK) 84642823 2014-11-24 uk.org.publicwhip/member/40208 Ed Miliband uk.org.publicwhip/person/11545 6 2014-11-24-84642823-11545-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 50.276ms · Data source: mySociety Data