names

33 rows where place_id = 599162

✎ 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
3635563 1905926 1905926 defendant Spernell William yeoman 599162 599162 Spernell, William, of Saltasshe, yeoman 3
3635564 1905926 1905926 defendant Clemowe Martin yeoman 599162 599162 Clemowe, Martin, of Saltasshe, yeoman 4
3647780 1909698 1909698 defendant Orenge Richard merchant 599162 599162 Orenge, Richard, of Saltasshe, merchant 0
3730231 1935682 1935682 defendant Phelip Matilda widow 599162 599162 Phelip, Matilda, of Saltasshe, widow 1
3793997 1955986 1955986 defendant Campell John yeoman 599162 599162 Campell, John, of Saltasshe, yeoman 1
3793998 1955986 1955986 defendant Beyll William yeoman 599162 599162 Beyll, William, of Saltasshe, yeoman 2
3793999 1955986 1955986 defendant Pollard Stephen yeoman 599162 599162 Pollard, Stephen, of Saltasshe, yeoman 3
4578805 2224855 2224855 defendant Baker Richard   599162 599162 Baker, Richard, of Saltasshe 0
4578812 2224856 2224856 defendant Baker Richard   599162 599162 Baker, Richard, of Saltasshe 0
4686359 2261341 2261341 defendant Pyke John yeoman 599162 599162 Pyke, John, of Saltasshe, yeoman 0
4766100 2285387 2285387 defendant Webbe John, sen mariner 599162 599162 Webbe, John, sen, of Saltasshe, mariner 0
4790502 2293122 2293122 defendant Webbe John, senior mariner 599162 599162 Webbe, John, senior, of Saltasshe, mariner 0
4860328 2314590 2314590 defendant Perys John chaplain 599162 599162 Perys, John, of Saltasshe, chaplain 6
4866235 2316407 2316407 defendant Jevyll William mercer 599162 599162 Jevyll, William, of Saltasshe, mercer 0
4866237 2316407 2316407 defendant Wase John tailor 599162 599162 Wase, John, of Saltasshe, tailor 2
4969023 2347698 2347698 defendant Eston alias Skynner John skinner 599162 599162 Eston alias Skynner, John, of Saltasshe, skinner 0
4983385 2351938 2351938 defendant Walter John butcher 599162 599162 Walter, John, of Saltasshe, butcher 0
4990386 2354035 2354035 defendant Benet John mariner 599162 599162 Benet, John, of Saltasshe, mariner 0
5024627 2364115 2364115 defendant Slog Richard mariner 599162 599162 Slog, Richard, of Saltasshe, mariner 0
5024628 2364115 2364115 defendant Slog John, junior mariner 599162 599162 Slog, John, junior, of Saltasshe, mariner 1
5053949 2372776 2372776 defendant Turner Richard yeoman 599162 599162 Turner, Richard, of Saltasshe, yeoman 7
5125873 2394054 2394054 defendant Godyng William merchant 599162 599162 Godyng, William, of Saltasshe, merchant 0
5132915 2396119 2396119 defendant Godyng William merchant 599162 599162 Godyng, William, of Saltasshe, merchant 0
5133305 2396229 2396229 defendant Godyng William   599162 599162 Godyng, William, of Saltasshe 0
5141964 2398768 2398768 defendant Gylle Richard yeoman 599162 599162 Gylle, Richard, of Saltasshe, yeoman 0
5152701 2401931 2401931 defendant Goddyng William merchant 599162 599162 Goddyng, William, of Saltasshe, merchant 0
5311280 2448403 2448403 defendant Revyll Thomas merchant 599162 599162 Revyll, Thomas, of Saltasshe, merchant 0
5389592 2472084 2472084 defendant Kendale Thomas merchant 599162 599162 Kendale, Thomas, of Saltasshe, merchant 0
5413596 2478992 2478992 defendant Smyth Thomas smith 599162 599162 Smyth, Thomas, of Saltasshe, smith 0
5476705 2498029 2498029 defendant Wetton John merchant 599162 599162 Wetton, John, of Saltasshe, merchant 4
5484676 2500340 2500340 defendant Kendale Thomas merchant 599162 599162 Kendale, Thomas, of Saltasshe, merchant 1
5502557 2505717 2505717 defendant Leche Thomas yeoman 599162 599162 Leche, Thomas, of Saltasshe, yeoman 1
5569755 2525723 2525723 defendant Marshall Alvered (legal representative) 599162 599162 Marshall, Alvered, of Saltasshe, mariner, executors of 3

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);