names

27 rows where place_id = 617204

✎ 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
3718350 1932023 1932023 defendant Stephyn Richard husbandman 617204 617204 Stephyn, Richard, of Plympton Mary, husbandman 5
3718351 1932023 1932023 defendant Hengyston William husbandman 617204 617204 Hengyston, William, of Plympton Mary, husbandman 6
3718358 1932024 1932024 defendant Stephyn Richard husbandman 617204 617204 Stephyn, Richard, of Plympton Mary, husbandman 5
3734052 1936898 1936898 defendant Algar Simon husbandman 617204 617204 Algar, Simon, of Plympton Mary, husbandman 4
3734053 1936898 1936898 defendant Stephyn Richard husbandman 617204 617204 Stephyn, Richard, of Plympton Mary, husbandman 5
3734054 1936898 1936898 defendant Hengiston William husbandman 617204 617204 Hengiston, William, of Plympton Mary, husbandman 6
3784107 1952810 1952810 defendant Odymer alias Clerk William laborer 617204 617204 Odymer alias Clerk, William, of Plympton Mary, laborer 0
3796959 1956929 1956929 defendant Alger Simon husbandman 617204 617204 Alger, Simon, of Plympton Mary, husbandman 4
3796960 1956929 1956929 defendant Stephyn Richard husbandman 617204 617204 Stephyn, Richard, of Plympton Mary, husbandman 5
3796961 1956929 1956929 defendant Hengiston William husbandman 617204 617204 Hengiston, William, of Plympton Mary, husbandman 6
3805171 1959561 1959561 defendant Hale John yeoman 617204 617204 Hale, John, of Plympton Mary, yeoman 0
3805173 1959562 1959562 defendant Hale John yeoman 617204 617204 Hale, John, of Plympton Mary, yeoman 0
3847614 1972824 1972824 defendant Hoper Richard yeoman 617204 617204 Hoper, Richard, of Plympton Mary, yeoman 0
3893956 1988202 1988202 defendant Welcombe alias Bawden William butcher 617204 617204 Welcombe alias Bawden, William, of Plympton Mary, butcher 0
3943884 2004969 2004969 defendant Holberton John, senior husbandman 617204 617204 Holberton, John, senior, of Plympton Mary, husbandman 0
3965267 2012467 2012467 defendant Hale Walter husbandman 617204 617204 Hale, Walter, of Plympton Mary, husbandman 0
3968435 2013593 2013593 defendant Hyngston John, senior yeoman 617204 617204 Hyngston, John, senior, of Plympton Mary, yeoman 1
3968436 2013593 2013593 defendant Hyngston John, junior husbandman 617204 617204 Hyngston, John, junior, of Plympton Mary, husbandman 2
3974474 2015648 2015648 defendant Lytletorre William husbandman 617204 617204 Lytletorre, William, of Plympton Mary, husbandman 0
3977772 2016795 2016795 defendant Vynecombe John husbandman 617204 617204 Vynecombe, John, of Plympton Mary, husbandman 0
4010891 2028673 2028673 plaintiff Peers Richard yeoman 617204 617204 Peers, Richard, of Plympton Mary, yeoman 0
4030280 2035483 2035483 defendant White Peter clothier 617204 617204 White, Peter, of Plympton Mary, or of Rudgewaye, clothier 0
4030281 2035483 2035483 defendant Rowe Robert clothier 617204 617204 Rowe, Robert, of Plympton Mary, clothier 1
4030621 2035612 2035612 plaintiff Elford Thomas yeoman 617204 617204 Elford, Thomas, of Plympton Mary, yeoman 0
4044001 2040306 2040306 plaintiff Pyers Richard yeoman 617204 617204 Pyers, Richard, of Plympton Mary, yeoman 0
4112349 2064674 2064674 defendant Beckhame John yeoman 617204 617204 Beckhame, John, of Plympton Mary, yeoman 0
4171935 2085645 2085645 defendant Helyer Simon husbandman 617204 617204 Helyer, Simon, of Plympton Mary, husbandman 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);