names

17 rows where place_id = 608042

✎ 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
3671942 1917224 1917224 defendant Rolleston William yeoman 608042 608042 Rolleston, William, of Codsall, yeoman 0
3715492 1931132 1931132 defendant Andrewes Alexander husbandman 608042 608042 Andrewes, Alexander, of Codsall, husbandman 0
3719116 1932260 1932260 defendant Roulston William yeoman 608042 608042 Roulston, William, of Codsall, yeoman 0
3887557 1986089 1986089 defendant Roltston William husbandman 608042 608042 Roltston, William, of Codsall, husbandman 1
3895326 1988643 1988643 defendant Barker John yeoman 608042 608042 Barker, John, of Codsall, yeoman 1
4056353 2044655 2044655 defendant Parker Walter yeoman 608042 608042 Parker, Walter, of Codsall, yeoman 2
4158748 2081134 2081134 defendant Glover Hugh yeoman 608042 608042 Glover, Hugh, of Codsall, yeoman 0
4158749 2081134 2081134 defendant Glover Edward yeoman 608042 608042 Glover, Edward, of Codsall, yeoman 1
4169598 2084873 2084873 defendant Wood Richard gent 608042 608042 Wood, Richard, of Codsall, gent 2
4174616 2086591 2086591 defendant Wood Richard gent 608042 608042 Wood, Richard, of Codsall, gent 0
4183550 2089729 2089729 defendant Androwes John yeoman 608042 608042 Androwes, John, of Codsall, yeoman 1
4206504 2097821 2097821 defendant Andrewes John yeoman 608042 608042 Andrewes, John, of Codsall, yeoman 1
4221522 2103018 2103018 defendant Brooke Alan gent 608042 608042 Brooke, Alan, of Codsall, gent 0
4337473 2142843 2142843 defendant Wood alias Deane Edward gent 608042 608042 Wood alias Deane, Edward, of Codsall, gent 0
4343921 2145155 2145155 defendant Wood Edward gent 608042 608042 Wood, Edward, of Codsall, gent 1
4412180 2168666 2168666 defendant Hartley Edward yeoman 608042 608042 Hartley, Edward, of Codsall, yeoman 0
5579894 2528793 2528793 defendant Andrewas Alexander tailor 608042 608042 Andrewas, Alexander, of Codsall, tailor 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);