names

15 rows where place_id = 658359

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3948059 2006387 2006387 defendant Fyshe Thomas yeoman 658359 658359 Fyshe, Thomas, of Boreham, Essex, yeoman 0
4014954 2030064 2030064 defendant Canceller James gent 658359 658359 Canceller, James, of Boreham, Essex, clerk, gent 1
4018227 2031244 2031244 plaintiff Twedy Richard esq 658359 658359 Twedy, Richard, of Boreham, Essex, esq 0
4042402 2039764 2039764 defendant Canceller James clerk 658359 658359 Canceller, James, of Boreham, Essex, clerk 0
4046334 2041133 2041133 defendant Canceller James clerk 658359 658359 Canceller, James, of Boreham, Essex, clerk 0
4113834 2065231 2065231 defendant Drane Michael yeoman 658359 658359 Drane, Michael, of Boreham, Essex, yeoman 0
4717722 2270877 2270877 defendant Pole John yeoman 658359 658359 Pole, John, of Boreham, Essex, yeoman 0
4717724 2270878 2270878 defendant Pole John yeoman 658359 658359 Pole, John, of Boreham, Essex, yeoman 0
5075104 2379055 2379055 defendant Alred Richard (legal representative) 658359 658359 Alred, Richard, of Boreham, Essex, esq, executors of 0
5271338 2436710 2436710 defendant (not given) John vicar of Taylard 658359 658359 Taylard, John, of Boreham, Essex, vicar of St Andrew's church 0
5272076 2436916 2436916 defendant Tayllard John   658359 658359 Tayllard, John, of Boreham, Essex, vicar 0
5272082 2436917 2436917 defendant Tayllard John   658359 658359 Tayllard, John, of Boreham, Essex, vicar 0
5324395 2452383 2452383 defendant Waleys John husbandman 658359 658359 Waleys, John, of Boreham, Essex, husbandman 0
5606465 2536910 2536910 defendant John Hugh clerk 658359 658359 John, Hugh, of Boreham, Essex, clerk 0
5606468 2536911 2536911 defendant John Hugh clerk 658359 658359 John, Hugh, of Boreham, Essex, clerk 0

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