names

21 rows where place_id = 595342

✎ 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
3620089 1873859 1873859 plaintiff Kutler John mercer 595342 595342 Kutler, John, of Ipwsich, mercer 0
3643710 1908459 1908459 defendant Nele John yeoman 595342 595342 Nele, John, of Ipwsich, yeoman 0
3652827 1911209 1911209 defendant Percyvall Richard merchant 595342 595342 Percyvall, Richard, of Ipwsich, merchant 0
3673011 1917566 1917566 defendant Albryght William chapman 595342 595342 Albryght, William, of Ipwsich, chapman 3
3680743 1920058 1920058 defendant Woode Mathew butcher 595342 595342 Woode, Mathew, of Ipwsich, butcher 1
3698864 1925860 1925860 defendant Fen Walter merchant 595342 595342 Fen, Walter, of Ipwsich, merchant 1
3758689 1944711 1944711 defendant Ponder or Pouder Emma spinster 595342 595342 Ponder or Pouder, Emma, of Ipwsich, spinster 2
3758690 1944711 1944711 defendant Ponder or Pouder Richard merchant 595342 595342 Ponder or Pouder, Richard, of Ipwsich, merchant 3
3795224 1956373 1956373 defendant Hayward Benedict clothmaker 595342 595342 Hayward, Benedict, of Ipwsich, clothmaker 0
3795226 1956374 1956374 defendant Hayward Benedict clothmaker 595342 595342 Hayward, Benedict, of Ipwsich, clothmaker 0
3800890 1958188 1958188 defendant Ponder Emma widow 595342 595342 Ponder, Emma, of Ipwsich, widow 0
3812351 1961754 1961754 defendant Heyward Benedict clothmaker 595342 595342 Heyward, Benedict, of Ipwsich, clothmaker 0
3821717 1964680 1964680 defendant Batell Robert fuller 595342 595342 Batell, Robert, of Ipwsich, fuller 1
3821718 1964680 1964680 defendant Charlys Thomas tailor 595342 595342 Charlys, Thomas, of Ipwsich, tailor 2
3824609 1965571 1965571 defendant Wyngfeld Humphrey esq 595342 595342 Wyngfeld, Humphrey, of Ipwsich, esq 2
3841012 1970758 1970758 defendant Toley Henry merchant 595342 595342 Toley, Henry, of Ipwsich, merchant 0
3924355 1998456 1998456 plaintiff Toly Henry merchant 595342 595342 Toly, Henry, of Ipwsich, merchant 0
4109134 2063521 2063521 defendant Wolverston Thomas gent 595342 595342 Wolverston, Thomas, of Ipwsich, gent 1
5236698 2426319 2426319 plaintiff Felawe Richard   595342 595342 Felawe, Richard, of Ipwsich 0
5236701 2426320 2426320 plaintiff Felawe Richard merchant 595342 595342 Felawe, Richard, of Ipwsich, merchant 0
5519682 2510991 2510991 defendant Bolle William yeoman 595342 595342 Bolle, William, of Ipwsich, 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);