names

21 rows where place_id = 585924

✎ 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
3587514 1863742 1863742 defendant Smert Thomas gent 585924 585924 Smert, Thomas, of Thornbury, Glos, gent 0
3637803 1906643 1906643 defendant Walwyn Nicholas clerk 585924 585924 Walwyn, Nicholas, of Thornbury, Glos, clerk 0
3755953 1943814 1943814 defendant Gilbert Robert clerk 585924 585924 Gilbert, Robert, of Thornbury, Glos, clerk 0
3827983 1966618 1966618 defendant Baker Thomas clothier 585924 585924 Baker, Thomas, of Thornbury, Glos, clothier 1
3966176 2012799 2012799 defendant Dayngarfyld Thomas   585924 585924 Dayngarfyld, Thomas, of Thornbury, Glos, linen draper 0
4037273 2037995 2037995 plaintiff Jones John, junior clothier 585924 585924 Jones, John, junior, of Thornbury, Glos, clothier 0
4199075 2095232 2095232 defendant Poynte Francis gent 585924 585924 Poynte, Francis, of Thornbury, Glos, gent 0
4204023 2096959 2096959 defendant Dossell Thomas weaver 585924 585924 Dossell, Thomas, of Thornbury, Glos, weaver 1
4250514 2113161 2113161 defendant Seaborne alias Hopkins Richard weaver 585924 585924 Seaborne alias Hopkins, Richard, of Thornbury, Glos, weaver 1
4250517 2113162 2113162 defendant Seaborne alias Hopkins Richard weaver 585924 585924 Seaborne alias Hopkins, Richard, of Thornbury, Glos, weaver 1
4252491 2113825 2113825 defendant Jones Philip clothier 585924 585924 Jones, Philip, of Thornbury, Glos, clothier 0
4273813 2120787 2120787 defendant Joanes Philip chapman 585924 585924 Joanes, Philip, of Thornbury, Glos, chapman 1
4344946 2145509 2145509 defendant Kinge William yeoman 585924 585924 Kinge, William, of Thornbury, Glos, yeoman 3
4359488 2150551 2150551 defendant Hilpe John gent 585924 585924 Hilpe, John, of Thornbury, Glos, gent 0
4372203 2155124 2155124 defendant Lewis Edward yeoman 585924 585924 Lewis, Edward, of Thornbury, Glos, yeoman 0
5021992 2363323 2363323 defendant Cokkes William clerk 585924 585924 Cokkes, William, of Thornbury, Glos, clerk 0
5034062 2366827 2366827 defendant Danyell John draper 585924 585924 Danyell, John, of Thornbury, Glos, draper 0
5344053 2458318 2458318 defendant Messynger alias Chapman David (legal representative) 585924 585924 Messynger alias Chapman, David, of Thornbury, Glos, mercer, executors of 1
5542016 2517631 2517631 defendant Blount Humphrey esq 585924 585924 Blount, Humphrey, of Thornbury, Glos, esq 0
5542018 2517632 2517632 defendant Blount Humphrey esq 585924 585924 Blount, Humphrey, of Thornbury, Glos, esq 0
5571826 2526299 2526299 defendant Mathewe Robert gent 585924 585924 Mathewe, Robert, of Thornbury, Glos, gent 1

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