names

21 rows where place_id = 589251

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597017 1866691 1866691 defendant Ram Thomas laborer 589251 589251 Ram, Thomas, of Sutton Valance, laborer 8
3606661 1869758 1869758 plaintiff Parke William, senior yeoman 589251 589251 Parke, William, senior, of Sutton Valance, yeoman 0
3648360 1909887 1909887 defendant Hyllyngton Nicholas clerk 589251 589251 Hyllyngton, Nicholas, of Sutton Valance, clerk 0
3760337 1945237 1945237 defendant Topynden Richard husbandman 589251 589251 Topynden, Richard, of Sutton Valance, husbandman 0
3887088 1985944 1985944 defendant Turnour Thomas yeoman 589251 589251 Turnour, Thomas, of Sutton Valance, yeoman 0
4063301 2047166 2047166 defendant Franklyn Nicholas, junior gent 589251 589251 (Franklyn, Nicholas, junior, of Sutton Valance, gent 4
4084029 2054565 2054565 defendant Gowge or Goch Barnaby gent 589251 589251 Gowge or Goch, Barnaby, of Sutton Valance, gent 0
4142384 2075510 2075510 defendant Cloke Thomas gent 589251 589251 Cloke, Thomas, of Sutton Valance, gent 1
4285583 2124894 2124894 defendant Askyn Henry sherman 589251 589251 Askyn, Henry, of Sutton Valance, sherman 0
4312601 2134542 2134542 defendant Askyn Henry sherman 589251 589251 Askyn, Henry, of Sutton Valance, sherman 0
4571404 2222643 2222643 defendant Parmonter Robert   589251 589251 Parmonter, Robert, of Sutton Valance 0
4703127 2266355 2266355 defendant Clyfford William gent 589251 589251 Clyfford, William, of Sutton Valance, gent 0
4760532 2283645 2283645 defendant Rogger William husbandman 589251 589251 Rogger, William, of Sutton Valance, husbandman 1
5275440 2437885 2437885 plaintiff Soole or Scole Robert   589251 589251 Soole or Scole, Robert, of Sutton Valance 0
5343888 2458277 2458277 defendant Levenoth Thomas weaver 589251 589251 Levenoth, Thomas, of Sutton Valance, weaver 0
5460710 2493151 2493151 defendant Hadde William husbandman 589251 589251 Hadde, William, of Sutton Valance, husbandman 0
5462110 2493559 2493559 plaintiff Parke William yeoman 589251 589251 Parke, William, of Sutton Valance, yeoman 0
5462112 2493560 2493560 plaintiff Parke William yeoman 589251 589251 Parke, William, of Sutton Valance, yeoman 0
5538415 2516498 2516498 defendant Levenoth Thomas weaver 589251 589251 Levenoth, Thomas, of Sutton Valance, weaver 0
5560872 2523151 2523151 defendant Rether Nicholas husbandman 589251 589251 Rether, Nicholas, of Sutton Valance, husbandman 3
5592051 2532505 2532505 defendant Hodyfold John yeoman 589251 589251 Hodyfold, John, of Sutton Valance, yeoman 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);