names

16 rows where case_id = 2245045

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4646509 2245045 2245045 plaintiff Pykeryng Richard     Pykeryng, Richard 0
4646510 2245045 2245045 defendant Wandesford Richard   594932 594932 Wandesford, Richard, of Neuby 0
4646511 2245045 2245045 defendant Wandesford Alice     Alice, his wife 1
4646512 2245045 2245045 defendant Wandesford Robert son of R_   Wandesford, Robert, son of R_ 2
4646513 2245045 2245045 defendant Wandesford Margaret     Wandesford, Margaret 3
4646514 2245045 2245045 defendant Milner Thomas   594932 594932 Milner, Thomas, of Neuby 4
4646515 2245045 2245045 defendant Sanden Thomas     Sanden, Thomas 5
4646516 2245045 2245045 defendant Sanden Agnes     Agnes, his wife 6
4646517 2245045 2245045 defendant Lesset Robert     Lesset, Robert 7
4646518 2245045 2245045 defendant Lesset Margaret     Margaret, his wife 8
4646519 2245045 2245045 defendant Molyn Robert     Molyn, Robert 9
4646520 2245045 2245045 defendant Molyn Joan     Joan, his wife 10
4646521 2245045 2245045 defendant Danby Thomas     Danby, Thomas 11
4646522 2245045 2245045 defendant Pothowe Thomas     Pothowe, Thomas 12
4646523 2245045 2245045 defendant Duchwayt William     Duchwayt, William 13
4646524 2245045 2245045 defendant Grene Roger     Grene, Roger 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);