names

16 rows where case_id = 2241276

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4633267 2241276 2241276 plaintiff Warthewyk George     Warthewyk, George 0
4633268 2241276 2241276 defendant Milner Thomas   590660 590660 Milner, Thomas, of Carlisle 0
4633269 2241276 2241276 defendant Blayklok Thomas     together with Blayklok, Thomas 1
4633270 2241276 2241276 defendant Adamman Thomas     Adamman, Thomas 2
4633271 2241276 2241276 defendant Wilson John     Wilson, John 3
4633272 2241276 2241276 defendant Beverley John     Beverley, John 4
4633273 2241276 2241276 defendant Walby Henry     Walby, Henry 5
4633274 2241276 2241276 defendant Moston Thomas     Moston, Thomas 6
4633275 2241276 2241276 defendant Shaghe John de     Shaghe, John de 7
4633276 2241276 2241276 defendant Atkynson John   765096 765096 Atkynson, John, of Crosseby 8
4633277 2241276 2241276 defendant Henryson John   765096 765096 Henryson, John, of Crosseby 9
4633278 2241276 2241276 defendant Dykson Richard   765096 765096 Dykson, Richard, of Crosseby 10
4633279 2241276 2241276 defendant Milner Thomas   764652 764652 Milner, Thomas, of Corkby 11
4633280 2241276 2241276 defendant Reynaldson Adam     Reynaldson, Adam 12
4633281 2241276 2241276 defendant Walker William   765096 765096 Walker, William, of Crosseby 13
4633282 2241276 2241276 defendant Richardson John   776392 776392 Richardson, John, of Lynstok 14

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);