names

14 rows where case_id = 2208524

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4526357 2208524 2208524 plaintiff Kyllyhelan James     Kyllyhelan, James 0
4526358 2208524 2208524 defendant Kayentre Wardanowe John     Kayentre Wardanowe, John 0
4526359 2208524 2208524 defendant Gounar Mathew   766264 766264 Gounar, Mathew, of Treglewar 1
4526360 2208524 2208524 defendant Plenche Thomas     Plenche, Thomas 2
4526361 2208524 2208524 defendant Jully Nicholas weaver   Jully, Nicholas, weaver 3
4526362 2208524 2208524 defendant Webber John     Webber, John 4
4526363 2208524 2208524 defendant Henry John shoemaker   Henry, John, shoemaker 5
4526364 2208524 2208524 defendant Kerver Philip   766265 766265 Kerver, Philip, of Kenegy 6
4526365 2208524 2208524 defendant Jonwan Gilbert   766269 766269 Jonwan, Gilbert, of Treworgonowe 7
4526366 2208524 2208524 defendant Bucher Silvester   766270 766270 Bucher, Silvester, of Comron, Coly, John, of Bostagek 8
4526367 2208524 2208524 defendant Goof Ralph   597064 597064 Goof, Ralph, of Redruth 9
4526368 2208524 2208524 defendant Enore John   766268 766268 Enore, John, of Penbro 10
4526369 2208524 2208524 defendant Gothell John   766263 766263 together with Gothell, John, of Neulyn 11
4526370 2208524 2208524 defendant Mere Robert   766263 766263 Mere, Robert, of Neulyn 12

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);