names

14 rows where case_id = 2283653

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4760552 2283653 2283653 plaintiff Culwen Christopher de knight   Culwen, Christopher de, knight 0
4760553 2283653 2283653 defendant Chapman Richard yeoman 590660 590660 Chapman, Richard, of Carlisle, yeoman 0
4760554 2283653 2283653 defendant Aleynesson John yeoman 600403 600403 Aleynesson, John, of Hoghton, yeoman 1
4760555 2283653 2283653 defendant Hakson John yeoman 591013 591013 Hakson John, of Staynton, yeoman 2
4760556 2283653 2283653 defendant Person John husbandman 778734 778734 Person, John, of Etardby, husbandman 3
4760557 2283653 2283653 defendant Lowre Nicholas husbandman 591013 591013 Lowre, Nicholas, of Staynton, husbandman 4
4760558 2283653 2283653 defendant Boureste John yeoman 591013 591013 Boureste, John, of Staynton, yeoman 5
4760559 2283653 2283653 defendant Penreth Robert yeoman 591013 591013 Penreth, Robert, of Staynton, yeoman 6
4760560 2283653 2283653 defendant Penreth Robert yeoman 781144 781144 Penreth, Robert, of Corkeby, yeoman 7
4760561 2283653 2283653 defendant Walker Robert yeoman 798204 798204 Walker, Robert, of Briggend, yeoman 8
4760562 2283653 2283653 defendant Wode John yeoman 760887 760887 Wode, John, of Gillesland, yeoman 9
4760563 2283653 2283653 defendant Atkynesson John yeoman 758342 758342 Atkynesson, John, of Trethirman, yeoman 10
4760564 2283653 2283653 defendant Nuthed Robert yeoman 758342 758342 Nuthed, Robert, of Trethirman, yeoman 11
4760565 2283653 2283653 defendant Jonesson Robert yeoman 588641 588641 Jonesson, Robert, of Denton, yeoman 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);