names

27 rows where place_id = 618790

✎ 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
3681639 1920351 1920351 defendant Brereton William   618790 618790 (Brereton, William, of Brereton, Cheshire, knight 1
3726421 1934531 1934531 defendant Brereton William gent 618790 618790 Brereton, William, of Brereton, Cheshire, gent 0
3742159 1939414 1939414 defendant Brereton William gent 618790 618790 Brereton, William, of Brereton, Cheshire, gent 0
3746051 1940668 1940668 defendant Brereton William   618790 618790 Brereton, William, of Brereton, Cheshire, knight 3
3797802 1957210 1957210 defendant Smyth Thomas clerk 618790 618790 Smyth, Thomas, of Brereton, Cheshire, clerk 2
3861826 1977415 1977415 defendant Walshe John yeoman 618790 618790 Walshe, John, of Brereton, Cheshire, yeoman 0
3875907 1982195 1982195 defendant Walshe John yeoman 618790 618790 Walshe, John, of Brereton, Cheshire, yeoman 1
3884117 1984957 1984957 defendant Brereton William   618790 618790 Brereton, William, of Brereton, Cheshire, knight 0
3884123 1984958 1984958 defendant Brereton William   618790 618790 Brereton, William, of Brereton, Cheshire, knight 0
3945364 2005464 2005464 plaintiff Bossume Richard (legal representative) 618790 618790 Bossume, Richard, of Brereton, Cheshire, executors of 0
3953038 2008128 2008128 defendant Brereton William (legal representative) 618790 618790 Brereton, William, of Brereton, Cheshire, knight, executors of 0
3978848 2017183 2017183 defendant Mynshyne Randolph yeoman 618790 618790 Mynshyne, Randolph, of Brereton, Cheshire, yeoman 2
3996083 2023352 2023352 plaintiff Dale John yeoman 618790 618790 Dale, John, of Brereton, Cheshire, yeoman 0
4038639 2038458 2038458 defendant Paver James   618790 618790 Paver, James, of Brereton, Cheshire, gent, administrators of 0
4325776 2138996 2138996 defendant Llanden William gent 618790 618790 Llanden, William, of Brereton, Cheshire, gent 1
4395450 2163063 2163063 defendant Brereton William   618790 618790 Brereton, William, of Brereton, Cheshire, knight 0
4824417 2303691 2303691 defendant Savage John, junior esq 618790 618790 Savage, John, junior, of Brereton, Cheshire, esq 1
5100832 2386658 2386658 defendant de Brereton William esq 618790 618790 de Brereton, William, of Brereton, Cheshire, esq 1
5222918 2422417 2422417 defendant Brereton William   618790 618790 Brereton, William,of Brereton, Cheshire, knight 0
5223548 2422575 2422575 defendant Brereton William   618790 618790 Brereton, William, of Brereton, Cheshire, knight 0
5331701 2454570 2454570 defendant Radclyff John gent 618790 618790 Radclyff, John, of Brereton, Cheshire, gent 0
5340482 2457224 2457224 defendant Brereton Andrew esq 618790 618790 Brereton, Andrew, of Brereton, Cheshire, esq 0
5340486 2457225 2457225 defendant Brereton William   618790 618790 Brereton, William, of Brereton, Cheshire, knight 0
5340489 2457226 2457226 defendant Brereton William   618790 618790 Brereton, William, of Brereton, Cheshire, knight 0
5340493 2457227 2457227 defendant Brereton William   618790 618790 Brereton, William, of Brereton, Cheshire, knight 0
5340497 2457228 2457228 defendant Brereton Andrew esq 618790 618790 Brereton, Andrew, of Brereton, Cheshire, esq 0
5340501 2457229 2457229 defendant Brereton William   618790 618790 Brereton, William, of Brereton, Cheshire, knight 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);