names

33 rows where place_id = 601717

✎ 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
3646678 1909365 1909365 defendant Brende Robert barker 601717 601717 Brende, Robert, of Bungay, Suff, barker 0
3800664 1958120 1958120 defendant Bremer Nicholas raffman 601717 601717 Bremer, Nicholas, of Bungay, Suff, raffman 3
3938933 2003355 2003355 defendant Tylynham Francis merchant 601717 601717 Tylynham, Francis, of Bungay, Suff, merchant 0
3961198 2011011 2011011 defendant Potter Humphrey yeoman 601717 601717 Potter, Humphrey, of Bungay, Suff, yeoman 0
3983680 2018933 2018933 plaintiff Stacy William butcher 601717 601717 Stacy, William, of Bungay, Suff, butcher 0
3984186 2019110 2019110 plaintiff Sudburne Walter merchant 601717 601717 Sudburne, Walter, of Bungay, Suff, merchant 0
4058692 2045501 2045501 defendant Costerden Edmund draper 601717 601717 Costerden, Edmund, of Bungay, Suff, draper 0
4073711 2050889 2050889 defendant Goodall Robert gent 601717 601717 Goodall, Robert, of Bungay, Suff, gent 0
4111513 2064363 2064363 defendant Townsend Henry grocer 601717 601717 Townsend, Henry, of Bungay, Suff, grocer 0
4112585 2064758 2064758 defendant Townesend Henry grocer 601717 601717 Townesend, Henry, of Bungay, Suff, grocer 1
4156020 2080178 2080178 defendant Towneshend Henry grocer 601717 601717 Towneshend, Henry, of Bungay, Suff, grocer 2
4177937 2087756 2087756 defendant Neve Nicholas weaver 601717 601717 Neve, Nicholas, of Bungay, Suff, weaver 2
4185877 2090556 2090556 defendant Kenoo or Kenne Andrew yeoman 601717 601717 Kenoo or Kenne, Andrew, of Bungay, Suff, yeoman 0
4271099 2119910 2119910 defendant Houlbrooke Robert tailor 601717 601717 Houlbrooke, Robert, of Bungay, Suff, tailor 0
4280069 2122938 2122938 defendant Cossey Francis yeoman 601717 601717 Cossey, Francis, of Bungay, Suff, or of Ellingham, Norf, yeoman 2
4289359 2126254 2126254 defendant Folkerd George yeoman 601717 601717 Folkerd, George, of Bungay, Suff, yeoman 1
4291612 2127077 2127077 defendant Folkerd Thomas yeoman 601717 601717 Folkerd, Thomas, of Bungay, Suff, yeoman 0
4293227 2127643 2127643 defendant Sherland Paul chapman 601717 601717 Sherland, Paul, of Bungay, Suff, chapman 0
4302277 2130911 2130911 defendant Armyger John chapman 601717 601717 Armyger, John, of Bungay, Suff, chapman 1
4357317 2149787 2149787 defendant Reynold Robert gent 601717 601717 Reynold, Robert, of Bungay, Suff, gent 0
4393669 2162484 2162484 defendant Wyseman Robert joimer 601717 601717 Wyseman, Robert, of Bungay, Suff, joimer 1
4398806 2164182 2164182 defendant Bulwer Winifred widow 601717 601717 Bulwer, Winifred, of Bungay, Suff, widow 1
5268284 2435845 2435845 defendant Goodwyn John gent 601717 601717 Goodwyn, John, of Bungay, Suff, gent 1
5268287 2435846 2435846 defendant Goodwyn John gent 601717 601717 Goodwyn, John, of Bungay, Suff, gent 1
5360442 2463299 2463299 defendant Quarton Brian yeoman 601717 601717 Quarton, Brian, of Bungay, Suff, yeoman 0
5360448 2463300 2463300 defendant Qwarton Brian gent 601717 601717 Qwarton, Brian, of Bungay, Suff, gent 0
5378464 2468849 2468849 defendant Waren Robert yeoman 601717 601717 Waren, Robert, of Bungay, Suff, yeoman 0
5397723 2474420 2474420 defendant Oltun John yeoman 601717 601717 Oltun, John, of Bungay, Suff, yeoman 0
5425013 2482447 2482447 defendant Oltun John yeoman 601717 601717 Oltun, John, of Bungay, Suff, yeoman 0
5444037 2488133 2488133 defendant Loveday John esq 601717 601717 Loveday, John, of Bungay, Suff, esq 1
5456761 2491941 2491941 defendant Loveday John esq 601717 601717 Loveday, John, of Bungay, Suff, esq 1
5547697 2519342 2519342 defendant Chapeleyn alias Dam Thomas (legal representative) 601717 601717 Chapeleyn alias Dam, Thomas, of Bungay, Suff, yeoman, executors of 0
5583476 2529903 2529903 plaintiff Fuller Thomas butcher 601717 601717 Fuller, Thomas, of Bungay, Suff, butcher 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);