names

21 rows where place_id = 657883

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3946155 2005732 2005732 defendant Hervy Robert husbandman 657883 657883 Hervy, Robert, of Probus, husbandman 1
3946156 2005732 2005732 defendant Hervy John laborer 657883 657883 Hervy, John, of Probus, laborer 2
4016974 2030773 2030773 defendant Vyoure or Vycure John husbandman 657883 657883 Vyoure or Vycure, John, of Probus, husbandman 0
4042406 2039766 2039766 defendant Cowarthen John tanner 657883 657883 Cowarthen, John, of Probus, tanner 0
4046280 2041112 2041112 defendant Vygure John husbandman 657883 657883 Vygure, John, of Probus, husbandman 0
4079313 2052902 2052902 defendant Androwe Thomas yeoman 657883 657883 Androwe, Thomas, of Probus, yeoman 0
4181603 2089051 2089051 defendant Mewdowe Peter husbandman 657883 657883 Mewdowe, Peter, of Probus, husbandman 0
4181604 2089051 2089051 defendant Jocke John husbandman 657883 657883 Jocke, John, of Probus, husbandman 1
4196522 2094327 2094327 defendant Dyer Richard husbandman 657883 657883 Dyer, Richard, of Probus, husbandman 0
4196523 2094327 2094327 defendant Stephen John husbandman 657883 657883 Stephen, John, of Probus, husbandman 1
4196525 2094328 2094328 defendant Dyer Richard husbandman 657883 657883 Dyer, Richard, of Probus, husbandman 0
4196526 2094328 2094328 defendant Stephyn John husbandman 657883 657883 Stephyn, John, of Probus, husbandman 1
4214540 2100592 2100592 defendant Herle Thomas esq 657883 657883 Herle, Thomas, of Probus, esq 2
4240872 2109932 2109932 defendant Mychell John husbandman 657883 657883 Mychell, John, of Probus, husbandman 1
4240873 2109932 2109932 defendant Drewe John husbandman 657883 657883 Drewe, John, of Probus, husbandman 2
4310751 2133904 2133904 defendant Herell Thomas esq 657883 657883 Herell, Thomas, of Probus, esq 0
4311784 2134257 2134257 defendant Harry alias Porthe Walter yeoman 657883 657883 Harry alias Porthe, Walter, of Probus, yeoman 0
4322102 2137810 2137810 defendant Clarke Abraham clerk 657883 657883 Clarke, Abraham, of Probus, clerk 1
4381227 2158397 2158397 defendant Williams Thomas yeoman 657883 657883 Williams, Thomas, of Probus, yeoman 0
4381228 2158397 2158397 defendant Williams Thomas, junior   657883 657883 Williams, Thomas, junior, of Probus, yeoman, his son 1
4385609 2159870 2159870 defendant Squier Thomas   657883 657883 Squier, Thomas, of Probus 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);