names

17 rows where place_id = 612986

✎ 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
3695985 1924984 1924984 defendant Wykys William husbandman 612986 612986 Wykys, William, of Bodysdale, husbandman 0
3697988 1925596 1925596 defendant Forthe William yeoman 612986 612986 Forthe, William, of Bodysdale, yeoman 0
3727920 1934998 1934998 defendant Braxstrete Simon yeoman 612986 612986 Braxstrete, Simon, of Bodysdale, yeoman 10
3727921 1934998 1934998 defendant Gasyngton William yeoman 612986 612986 Gasyngton, William, of Bodysdale, yeoman 11
3727922 1934998 1934998 defendant Typshede Robert yeoman 612986 612986 Typshede, Robert, of Bodysdale, yeoman 12
3732259 1936330 1936330 defendant Warde John shoemaker 612986 612986 Warde, John, of Bodysdale, shoemaker 0
3750100 1941945 1941945 defendant Coterell Richard husbandman 612986 612986 Coterell, Richard, of Bodysdale, husbandman 1
3755874 1943789 1943789 defendant Braxstrete Simon yeoman 612986 612986 Braxstrete, Simon, of Bodysdale, yeoman 1
3780416 1951609 1951609 defendant Smyth Robert yeoman 612986 612986 Smyth, Robert, of Bodysdale, yeoman 3
3780451 1951618 1951618 defendant Smyth Robert yeoman 612986 612986 Smyth, Robert, of Bodysdale, yeoman 3
3807981 1960387 1960387 defendant Braxstrete Simon yeoman 612986 612986 Braxstrete, Simon, of Bodysdale, yeoman 0
3849491 1973441 1973441 defendant Harvy John gent 612986 612986 Harvy, John, of Bodysdale, gent 0
3859036 1976515 1976515 defendant Page William gent 612986 612986 Page, William, of Bodysdale, gent 1
3983584 2018898 2018898 defendant Peke Henry yeoman 612986 612986 Peke, Henry, of Bodysdale, yeoman 0
4168182 2084356 2084356 defendant Peake Henry yeoman 612986 612986 Peake, Henry, of Bodysdale, yeoman 1
5523228 2512095 2512095 defendant Nyll John husbandman 612986 612986 Nyll, John, of Bodysdale, husbandman 0
5523229 2512095 2512095 defendant Bolle John husbandman 612986 612986 Bolle, John, of Bodysdale, husbandman 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);