names

20 rows where place_id = 636749

✎ 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
3714790 1930927 1930927 defendant Wyndham Thomas (legal representative) 636749 636749 Wyndham, Thomas, of Felbrigge, Norf, knight, executors of 0
3832451 1968070 1968070 defendant Hawke James gent 636749 636749 Hawke, James, of Felbrigge, Norf, gent 0
4129308 2070784 2070784 defendant Wyndam Roger esq 636749 636749 Wyndam, Roger, of Felbrigge, Norf, esq 0
4142697 2075615 2075615 defendant Jerveys William gent 636749 636749 Jerveys, William, of Felbrigge, Norf, gent 0
4183031 2089547 2089547 defendant Wyndam Roger esq 636749 636749 Wyndam, Roger, of Felbrigge, Norf, esq 0
4183038 2089549 2089549 defendant Wyndam Roger esq 636749 636749 Wyndam, Roger, of Felbrigge, Norf, esq 0
4298966 2129726 2129726 defendant Wyndham Roger esq 636749 636749 Wyndham, Roger, of Felbrigge, Norf, esq 0
4355301 2149074 2149074 defendant Wyndam Roger esq 636749 636749 Wyndam, Roger, of Felbrigge, Norf, esq 0
4678233 2258800 2258800 defendant Felbrigge Simon   636749 636749 Felbrigge, Simon, of Felbrigge, Norf, knight 0
4678236 2258801 2258801 defendant Felbrigge Simon   636749 636749 Felbrigge, Simon, of Felbrigge, Norf, knight 0
4855357 2313030 2313030 defendant Felbrigge Roger esq 636749 636749 Felbrigge, Roger, of Felbrigge, Norf, esq 0
4855360 2313031 2313031 defendant Felbrigge Simon   636749 636749 Felbrigge, Simon, of Felbrigge, Norf, knight 0
4879541 2320528 2320528 defendant Felbrigge Simon   636749 636749 Felbrigge, Simon, of Felbrigge, Norf, knight 0
4883323 2321708 2321708 defendant Felbrigge Roger (legal representative) 636749 636749 Felbrigge, Roger, of Felbrigge, Norf, esq, executor of 5
4889111 2323384 2323384 defendant Felbrigge Roger (legal representative) 636749 636749 Felbrigge, Roger, of Felbrigge, Norf, esq, executor of 5
5182786 2410714 2410714 defendant Wyndham John esq 636749 636749 Wyndham, John, of Felbrigge, Norf, esq 1
5203569 2416796 2416796 defendant Wyndam John esq 636749 636749 Wyndam, John, of Felbrigge, Norf, esq 1
5203572 2416797 2416797 defendant Wyndam John esq 636749 636749 Wyndam, John, of Felbrigge, Norf, esq 1
5209715 2418580 2418580 defendant Wyndham John esq 636749 636749 Wyndham, John, of Felbrigge, Norf, esq 0
5277016 2438360 2438360 defendant Wyndham John esq 636749 636749 Wyndham, John, of Felbrigge, Norf, esq 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);