names

30 rows where place_id = 600504

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641271 1907721 1907721 defendant Taylour Thomas draper 600504 600504 Taylour, Thomas, of Lowthe, Lincs, draper 0
3700107 1926265 1926265 defendant Warde Edmund merchant 600504 600504 Warde, Edmund, of Lowthe, Lincs, merchant 5
3717190 1931663 1931663 defendant Ferrand William dyer 600504 600504 Ferrand, William, of Lowthe, Lincs, dyer 2
3717195 1931664 1931664 defendant Ferrand William dyer 600504 600504 Ferrand, William, of Lowthe, Lincs, dyer 2
3876401 1982353 1982353 defendant Misterchamber Martin gent 600504 600504 Misterchamber, Martin, of Lowthe, Lincs, gent 2
3919017 1996685 1996685 defendant Smythe John mercer 600504 600504 Smythe, John, of Lowthe, Lincs, mercer 0
3925435 1998820 1998820 defendant Dowghty Robert gent 600504 600504 Dowghty, Robert, of Lowthe, Lincs, gent 0
3953539 2008309 2008309 defendant Wayte Roger gent 600504 600504 Wayte, Roger, of Lowthe, Lincs, gent 0
3953543 2008310 2008310 defendant Wayte Roger gent 600504 600504 Wayte, Roger, of Lowthe, Lincs, gent 0
3966026 2012740 2012740 defendant Fyssher William chapman 600504 600504 Fyssher, William, of Lowthe, Lincs, chapman 2
3970165 2014163 2014163 defendant Fyssher William chapman 600504 600504 Fyssher, William, of Lowthe, Lincs, chapman 2
3999763 2024674 2024674 defendant Whyte Richard chapman 600504 600504 Whyte, Richard, of Lowthe, Lincs, chapman 0
4004682 2026450 2026450 defendant Browne George yeoman 600504 600504 Browne, George, of Lowthe, Lincs, yeoman 0
4004684 2026451 2026451 defendant Browne George yeoman 600504 600504 Browne, George, of Lowthe, Lincs, yeoman 0
4005555 2026761 2026761 defendant Graye John yeoman 600504 600504 Graye, John, of Lowthe, Lincs, yeoman 2
4020234 2031958 2031958 defendant Clarke William clerk 600504 600504 Clarke, William, of Lowthe, Lincs, clerk 0
4020236 2031959 2031959 defendant Clarke William clerk 600504 600504 Clarke, William, of Lowthe, Lincs, clerk 0
4024566 2033463 2033463 defendant White Richard chapman 600504 600504 White, Richard, of Lowthe, Lincs, chapman 0
4024568 2033464 2033464 defendant White Richard chapman 600504 600504 White, Richard, of Lowthe, Lincs, chapman 0
4049263 2042182 2042182 defendant White Richard chapman 600504 600504 White, Richard, of Lowthe, Lincs, chapman 0
4135109 2072875 2072875 defendant Barnard William butcher 600504 600504 Barnard, William, of Lowthe, Lincs, butcher 1
4140688 2074908 2074908 defendant Cooke William tailor 600504 600504 Cooke, William, of Lowthe, Lincs, tailor 2
4262934 2117266 2117266 defendant Fysher William yeoman 600504 600504 Fysher, William, of Lowthe, Lincs, yeoman 2
4273572 2120714 2120714 defendant Fysher William yeoman 600504 600504 Fysher, William, of Lowthe, Lincs, yeoman 1
4334824 2141915 2141915 defendant Newton George gent 600504 600504 Newton, George, of Lowthe, Lincs, gent 1
4342001 2144481 2144481 defendant Nevell Jervase gent 600504 600504 Nevell, Jervase, of Lowthe, Lincs, gent 2
4358164 2150093 2150093 defendant Newton George gent 600504 600504 Newton, George, of Lowthe, Lincs, gent 1
4382841 2158966 2158966 defendant Warde Henry yeoman 600504 600504 Warde, Henry, of Lowthe, Lincs, yeoman 2
4401328 2165041 2165041 defendant Nevell Jervase gent 600504 600504 Nevell, Jervase, of Lowthe, Lincs, gent 0
4402024 2165267 2165267 defendant Vanspeere Stephen yeoman 600504 600504 Vanspeere, Stephen, of Lowthe, Lincs, yeoman 2

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