names

40 rows where place_id = 587456

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591462 1864955 1864955 defendant Flegge John, junior yeoman 587456 587456 Flegge, John, junior, of Nedham Market, Suff, yeoman 3
3591468 1864956 1864956 defendant Flegge John, junior yeoman 587456 587456 Flegge, John, junior, of Nedham Market, Suff, yeoman 3
3618001 1873250 1873250 defendant Havell or Hanell William mercer 587456 587456 Havell or Hanell, William, of Nedham Market, Suff, mercer 0
3790219 1954759 1954759 defendant Brynwyn Robert clothman 587456 587456 Brynwyn, Robert, of Nedham Market, Suff, clothman 0
3792348 1955468 1955468 defendant Raven Thomas, junior clothmaker 587456 587456 Raven, Thomas, junior, of Nedham Market, Suff, clothmaker 1
3792354 1955469 1955469 defendant Reven or Reben Thomas, junior clothmaker 587456 587456 Reven or Reben, Thomas, junior, of Nedham Market, Suff, clothmaker 1
3829512 1967120 1967120 plaintiff Damme Robert gent 587456 587456 Damme, Robert, of Nedham Market, Suff, gent 0
3883170 1984634 1984634 plaintiff Wadelond Walter gent 587456 587456 Wadelond, Walter, of Nedham Market, Suff, gent 0
3924380 1998464 1998464 defendant redmayne Richard clerk 587456 587456 redmayne, Richard, of Nedham Market, Suff, clerk 4
3956807 2009451 2009451 defendant Uttyng Edward yeoman 587456 587456 Uttyng, Edward, of Nedham Market, Suff, yeoman 0
4719849 2271552 2271552 defendant Sparwe Robert yeoman 587456 587456 Sparwe, Robert, of Nedham Market, Suff, yeoman 1
4720988 2271897 2271897 defendant Elyngham John, sen yeoman 587456 587456 Elyngham, John, sen, of Nedham Market, Suff, yeoman 2
4742242 2278220 2278220 defendant Spaprwe Robert yeoman 587456 587456 Spaprwe, Robert, of Nedham Market, Suff, yeoman 1
4744868 2279016 2279016 defendant Starwe Robert yeoman 587456 587456 Starwe, Robert, of Nedham Market, Suff, yeoman 1
4752184 2281113 2281113 defendant Turnour John yeoman 587456 587456 Turnour, John, of Nedham Market, Suff, yeoman 3
4769127 2286321 2286321 defendant Taston Thomas husbandman 587456 587456 Taston, Thomas, of Nedham Market, Suff, husbandman 0
4777821 2289055 2289055 defendant Sparwe Robert yeoman 587456 587456 Sparwe, Robert, of Nedham Market, Suff, yeoman 0
4798413 2295689 2295689 defendant Turnour John husbandman 587456 587456 Turnour, John, of Nedham Market, Suff, husbandman 4
4822177 2303014 2303014 defendant Saprwe Robert yeoman 587456 587456 Saprwe, Robert, of Nedham Market, Suff, yeoman 0
4885039 2322216 2322216 defendant Horold John   587456 587456 Horold, John, of Nedham Market, Suff, lime burner 0
4912108 2330289 2330289 defendant Sparwe John husbandman 587456 587456 Sparwe, John, of Nedham Market, Suff, husbandman 1
4946575 2340924 2340924 defendant Taston Richard yeoman 587456 587456 Taston, Richard, of Nedham Market, Suff, yeoman 1
4952761 2342783 2342783 defendant Martyn John   587456 587456 Martyn, John, of Nedham Market, Suff, "barburgh" or barber 1
4955013 2343454 2343454 defendant Page Walter yeoman 587456 587456 (Page, Walter, of Nedham Market, Suff, yeoman 5
5064572 2375943 2375943 defendant Venyour John butcher 587456 587456 Venyour, John, of Nedham Market, Suff, butcher 0
5105107 2387928 2387928 defendant Yonge Nicholas dyer 587456 587456 Yonge, Nicholas, of Nedham Market, Suff, dyer 0
5110299 2389417 2389417 defendant Yonge Nicholas dyer 587456 587456 Yonge, Nicholas, of Nedham Market, Suff, dyer 1
5113702 2390401 2390401 defendant Venyour John butcher 587456 587456 Venyour, John, of Nedham Market, Suff, butcher 0
5144427 2399529 2399529 defendant Cole John butcher 587456 587456 Cole, John, of Nedham Market, Suff, butcher 0
5262905 2434139 2434139 defendant Cole John (legal representative) 587456 587456 Cole, John, of Nedham Market, Suff, yeoman, executors of 1
5331707 2454571 2454571 defendant Bettys Robert chaplain 587456 587456 Bettys, Robert, of Nedham Market, Suff, chaplain 2
5365210 2464792 2464792 defendant Flegge John   587456 587456 Flegge, John, of Nedham Market, Suff, cloth maker 0
5430635 2484101 2484101 defendant Havell Thomas chapman 587456 587456 Havell, Thomas, of Nedham Market, Suff, chapman 1
5459528 2492761 2492761 defendant Havell Thomas chapman 587456 587456 Havell, Thomas, of Nedham Market, Suff, chapman 1
5534152 2515214 2515214 defendant Armeiard Thomas husbandman 587456 587456 Armeiard, Thomas, of Nedham Market, Suff, husbandman 4
5550858 2520285 2520285 defendant Stode Richard mercer 587456 587456 Stode, Richard, of Nedham Market, Suff, mercer 0
5566176 2524703 2524703 defendant Flegge John yeoman 587456 587456 Flegge, John, of Nedham Market, Suff, yeoman 0
5566178 2524704 2524704 defendant Flegge John yeoman 587456 587456 Flegge, John, of Nedham Market, Suff, yeoman 0
5573207 2526716 2526716 defendant Flegge John yeoman 587456 587456 Flegge, John, of Nedham Market, Suff, yeoman 0
5609428 2537846 2537846 defendant Breneleff Robert baker 587456 587456 Breneleff, Robert, of Nedham Market, Suff, baker 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);