names

30 rows where place_id = 586985

✎ 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
3590142 1864554 1864554 defendant Souter or Sonter William drover 586985 586985 Souter or Sonter, William, of Waltham Abbey, drover 1
3604612 1869105 1869105 defendant Bryght John butcher 586985 586985 Bryght, John, of Waltham Abbey, butcher 1
3785977 1953411 1953411 plaintiff Greves Thomas   586985 586985 (Greves, Thomas, of Waltham Abbey 1
4286214 2125123 2125123 defendant Turner Thomas cooper 586985 586985 Turner, Thomas, of Waltham Abbey, cooper 0
4286216 2125124 2125124 defendant Turner Thomas cooper 586985 586985 Turner, Thomas, of Waltham Abbey, cooper 0
4325587 2138933 2138933 defendant Watterer Richard   586985 586985 Watterer, Richard, of Waltham Abbey, Essex yeoman 0
4622217 2237928 2237928 defendant Woderove John   586985 586985 Woderove, John, of Waltham Abbey 2
4767410 2285790 2285790 defendant Chekewell John Essex, yeoman 586985 586985 Chekewell John, of Waltham Abbey, Essex, yeoman 1
5027178 2364821 2364821 defendant Colyn William chapman 586985 586985 Colyn, William, of Waltham Abbey, chapman 0
5029016 2365356 2365356 defendant Bunne John husbandman 586985 586985 Bunne, John, of Waltham Abbey, husbandman 4
5050265 2371702 2371702 defendant Durant William tanner 586985 586985 Durant, William, of Waltham Abbey, tanner 0
5085138 2382056 2382056 defendant Waryn Richard husbandman 586985 586985 Waryn, Richard, of Waltham Abbey, husbandman 1
5085142 2382057 2382057 defendant Waryn Richard husbandman 586985 586985 Waryn, Richard, of Waltham Abbey, husbandman 1
5275166 2437812 2437812 defendant Smyth Robert yeoman 586985 586985 Smyth, Robert, of Waltham Abbey, yeoman 4
5275171 2437813 2437813 defendant Pegram William butcher 586985 586985 Pegram, William, of Waltham Abbey, butcher 3
5275172 2437813 2437813 defendant Smyth Robert yeoman 586985 586985 Smyth, Robert, of Waltham Abbey, yeoman 4
5331195 2454405 2454405 defendant Norton Robert baker 586985 586985 Norton, Robert, of Waltham Abbey, baker 0
5348881 2459780 2459780 defendant Vryght Walter butcher 586985 586985 Vryght, Walter, of Waltham Abbey, butcher 0
5353030 2461036 2461036 defendant Seryd Thomas smith 586985 586985 Seryd, Thomas, of Waltham Abbey, smith 1
5353031 2461036 2461036 defendant Forde John husbandman 586985 586985 Forde, John, of Waltham Abbey, husbandman 2
5353041 2461038 2461038 defendant Seryd Thomas smith 586985 586985 Seryd, Thomas, of Waltham Abbey, smith 1
5353042 2461038 2461038 defendant Forde John husbandman 586985 586985 Forde, John, of Waltham Abbey, husbandman 2
5371222 2466584 2466584 defendant Athelowe Thomas yeoman 586985 586985 Athelowe, Thomas, of Waltham Abbey, yeoman 1
5435032 2485406 2485406 defendant Cok Walter   586985 586985 Cok, Walter, of Waltham Abbey 0
5435034 2485407 2485407 defendant Cok Walter baker 586985 586985 Cok, Walter, of Waltham Abbey, baker 0
5437688 2486207 2486207 defendant Shawe Robert chaplain 586985 586985 Shawe, Robert, of Waltham Abbey, chaplain 2
5507059 2507116 2507116 defendant Pelgreme John butcher 586985 586985 Pelgreme, John, of Waltham Abbey, butcher 1
5507061 2507117 2507117 defendant Pylgreme John fisher 586985 586985 Pylgreme, John, of Waltham Abbey, fisher 0
5507064 2507118 2507118 defendant Pylgreme John fisher 586985 586985 Pylgreme, John, of Waltham Abbey, fisher 0
5514577 2509406 2509406 defendant Parker Richard husbandman 586985 586985 Parker, Richard, of Waltham Abbey, husbandman 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);