names

16 rows where place_id = 701971

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647553 1909627 1909627 defendant Tailboys George   701971 701971 Tailboys, George, of Kyme, Lincs, knight 0
3647557 1909628 1909628 defendant Taylboys George   701971 701971 Taylboys, George, of Kyme, Lincs, knight 0
4140763 2074933 2074933 defendant Dymocke Robert esq 701971 701971 Dymocke, Robert, of Kyme, Lincs, esq 0
4406687 2166803 2166803 defendant Dymock Edward   701971 701971 Dymock, Edward, of Kyme, Lincs, knight 1
4738430 2277110 2277110 defendant Percy Richard gent 701971 701971 Percy, Richard, of Kyme, Lincs, gent 0
4753897 2281598 2281598 defendant Percy Richard gent 701971 701971 Percy, Richard, of Kyme, Lincs, gent 1
4976044 2349799 2349799 defendant Craythorn Roger chapman 701971 701971 Craythorn, Roger, of Kyme, Lincs, chapman 1
5221387 2421955 2421955 defendant Lee Nicholas yeoman 701971 701971 Lee, Nicholas, of Kyme, Lincs, yeoman 0
5274178 2437528 2437528 defendant Lee Nicholas yeoman 701971 701971 Lee, Nicholas, of Kyme, Lincs, yeoman 0
5274181 2437529 2437529 defendant Lee Nicholas yeoman 701971 701971 Lee, Nicholas, of Kyme, Lincs, yeoman 0
5275516 2437909 2437909 defendant Fryskeney Robert gent 701971 701971 Fryskeney, Robert, of Kyme, Lincs, gent 0
5291051 2442385 2442385 defendant Lee Nicholas yeoman 701971 701971 Lee, Nicholas, of Kyme, Lincs, yeoman 0
5460402 2493051 2493051 defendant Taylbos Robert   701971 701971 Taylbos, Robert, of Kyme, Lincs, knight 0
5472002 2496586 2496586 defendant Taylbos Robert   701971 701971 Taylbos, Robert, of Kyme, Lincs, knight 0
5629345 2553156 2553156 defendant Dycunson John   701971 701971 Dycunson, John, of Kyme, Lincs, wright 0
5629347 2553157 2553157 defendant Dycunson John   701971 701971 Dycunson, John, of Kyme, Lincs, wright 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);