names

20 rows where place_id = 695280

✎ 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
4108677 2063358 2063358 defendant Bewell Peter husbandman 695280 695280 Bewell, Peter, of Doddington, husbandman 0
4124397 2069019 2069019 defendant Popple Christopher husbandman 695280 695280 Popple, Christopher, of Doddington, husbandman 0
4151105 2078518 2078518 defendant Chambers Henry yeoman 695280 695280 Chambers, Henry, of Doddington, yeoman 2
4151106 2078518 2078518 defendant Poppe Christopher husbandman 695280 695280 Poppe, Christopher, of Doddington, husbandman 3
4224431 2104028 2104028 defendant Backhouse alias Chamberleyn John, junior yeoman 695280 695280 Backhouse alias Chamberleyn, John, junior, of Doddington, yeoman 0
4224432 2104028 2104028 defendant Allen Edward husbandman 695280 695280 Allen, Edward, of Doddington, husbandman 1
4232908 2107018 2107018 defendant Butterton John yeoman 695280 695280 Butterton, John, of Doddington, yeoman 0
4233366 2107183 2107183 defendant Clyfton William husbandman 695280 695280 Clyfton, William, of Doddington, husbandman 0
4241888 2110279 2110279 plaintiff Clarke Robert yeoman 695280 695280 Clarke, Robert, of Doddington, yeoman 0
4256766 2115235 2115235 defendant Skelton Thomas yeoman 695280 695280 Skelton, Thomas, of Doddington, yeoman 2
4265798 2118200 2118200 defendant Ryecrofte Evan clerk 695280 695280 Ryecrofte, Evan, of Doddington, clerk 1
4278369 2122371 2122371 defendant Robert Thomas yeoman 695280 695280 Robert, Thomas, of Doddington, yeoman 1
4281025 2123264 2123264 defendant Chambers Henry yeoman 695280 695280 Chambers, Henry, of Doddington, yeoman 0
4297936 2129363 2129363 defendant Partesoyle Thomas gent 695280 695280 Partesoyle, Thomas, of Doddington, gent 0
4306432 2132390 2132390 defendant Partesoyle or Partefoyle Thomas gent 695280 695280 Partesoyle or Partefoyle, Thomas, of Doddington, gent 0
4318263 2136495 2136495 defendant Partesoyle Thomas gent 695280 695280 Partesoyle, Thomas, of Doddington, gent 0
4341450 2144285 2144285 defendant Hunte William husbandman 695280 695280 Hunte, William, of Doddington, husbandman 0
4406463 2166726 2166726 defendant Batten Thomas husbandman 695280 695280 Batten, Thomas, of Doddington, husbandman 2
4759157 2283208 2283208 defendant Edward William laborer 695280 695280 Edward, William, of Doddington, laborer 2
4761079 2283816 2283816 defendant Trulove Richard yeoman 695280 695280 Trulove, Richard, of Doddington, yeoman 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);