items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2017-01-09-70b64e89-24891-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| ff2995755b3669962b8db79aa29fdf1218d1c783 | Name of lender: Lloyds Bank Address of lender: 1 City Road East, Manchester, M15 4PU Amount of loan: £5,000 authorised overdraft facility for business account (used for office costs) Date the loan was entered into: 22 July 2014 Date the loan is due to be repaid: intended overdraft review date 28 July 2016 Rate of interest: variable rates (currently 8.75% and 26.40% p/a) for, respectively, authorised and unauthorised borrowing Whether any security has been given: No (Registered 31 July 2014; updated 14 August 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-09 | Charlotte Leslie uk.org.publicwhip/person/24891 | 0 | 2017-01-09-70b64e89-24891-0 | |
| 6d8a64483cc64c5062337438b20f674b42a2357f | Name of donor: Lloyds Bank Address of donor: 1 City Road, Manchester M15 4PU Amount of donation or nature and value if donation in kind: £5,000 authorised overdraft facility for business account (used for office costs), variable rates (currently 8.75% and 26.40% p/a) for, respectively, authorised and unauthorised borrowing Date received: 28 July 2016 - 28 July 2017 Date accepted: 28 July 2016 Donor status: company, registration 2065 (Registered 12 August 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-09 | Charlotte Leslie uk.org.publicwhip/person/24891 | 1 | 2017-01-09-70b64e89-24891-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");