names

17 rows where place_id = 600158

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3639930 1907303 1907303 defendant Gibbes John husbandman 600158 600158 Gibbes, John, of Northall, Middx, husbandman 0
3653653 1911407 1911407 defendant Gybbys John husbandman 600158 600158 Gybbys, John, of Northall, Middx, husbandman 1
3691650 1923547 1923547 defendant Vyncent Robert yeoman 600158 600158 Vyncent, Robert, of Northall, Middx, yeoman 2
3773423 1949399 1949399 defendant Turnor Thomas yeoman 600158 600158 Turnor, Thomas, of Northall, Middx, yeoman 0
3773431 1949402 1949402 defendant Turnor Thomas yeoman 600158 600158 Turnor, Thomas, of Northall, Middx, yeoman 0
3803927 1959142 1959142 defendant Turner Thomas yeoman 600158 600158 Turner, Thomas, of Northall, Middx, yeoman 1
3950047 2007100 2007100 defendant Gifford John esq 600158 600158 Gifford, John, of Northall, Middx, esq 0
3973590 2015333 2015333 plaintiff Gyfford John gent 600158 600158 Gyfford, John, of Northall, Middx, gent 0
4096310 2059012 2059012 plaintiff Gyfford John esq 600158 600158 Gyfford, John, of Northall, Middx, esq 0
4355771 2149241 2149241 defendant Randle Thomas yeoman 600158 600158 Randle, Thomas, of Northall, Middx, yeoman 0
4355774 2149241 2149241 defendant Wilmore William yeoman 600158 600158 Wilmore, William, of Northall, Middx, yeoman 3
4365266 2152640 2152640 defendant Dennys William gent 600158 600158 Dennys, William, of Northall, Middx, gent 0
4407901 2167208 2167208 defendant Pawlyn Thomas gent 600158 600158 Pawlyn, Thomas, of Northall, Middx, gent 0
4753001 2281328 2281328 defendant Grymmemsby John   600158 600158 Grymmemsby, John, of Northall, Middx, vicar 1
4753007 2281329 2281329 defendant Grymmesby John   600158 600158 Grymmesby, John, of Northall, Middx, vicar 1
4766820 2285616 2285616 defendant Constantyn William gent 600158 600158 Constantyn, William, of Northall, Middx, gent 0
5482828 2499810 2499810 defendant Vyncent Henry husbandman 600158 600158 Vyncent, Henry, of Northall, Middx, husbandman 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);