names

31 rows where place_id = 590329

✎ 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
3600661 1867852 1867852 defendant Segyr John mercer 590329 590329 Segyr, John, of Wyndam, mercer 0
3600663 1867853 1867853 defendant Segyr John mercer 590329 590329 Segyr, John, of Wyndam, mercer 0
3903441 1991377 1991377 defendant Toly Robert   590329 590329 Toly, Robert, of Wyndam, "raffman" 2
3927672 1999591 1999591 defendant Sharpe John tailor 590329 590329 Sharpe, John, of wyndam, tailor 4
3944807 2005284 2005284 defendant Warbutton Peter draper 590329 590329 Warbutton, Peter, of Wyndam, draper 1
3947475 2006190 2006190 defendant Knyght alias Kett Thomas butcher 590329 590329 Knyght alias Kett, Thomas, of Wyndam, butcher 0
3948105 2006401 2006401 defendant Castelton William tailor 590329 590329 Castelton, William, of Wyndam, tailor 4
3954579 2008673 2008673 defendant Wiseman Thomas yeoman 590329 590329 Wiseman, Thomas, of Wyndam, yeoman 2
3960473 2010763 2010763 defendant Colyour Richard husbandman 590329 590329 Colyour, Richard, of Wyndam, husbandman 1
3962897 2011617 2011617 defendant Chapman Thomas yeoman 590329 590329 Chapman, Thomas, of Wyndam, yeoman 0
3972943 2015111 2015111 defendant Rede Thomas blacksmith 590329 590329 Rede, Thomas, of Wyndam, blacksmith 2
3980266 2017708 2017708 defendant Rowse John yeoman 590329 590329 Rowse, John, of Wyndam, yeoman 1
4090582 2056913 2056913 defendant Kellam or Killam Thomas yeoman 590329 590329 Kellam or Killam, Thomas, of Wyndam, yeoman 0
4148392 2077567 2077567 defendant Folsham alias Smyth Alexander baker 590329 590329 Folsham alias Smyth, Alexander, of Wyndam, baker 1
4165559 2083454 2083454 defendant Smyth Richard yeoman 590329 590329 Smyth, Richard, of Wyndam, yeoman 0
4166757 2083868 2083868 defendant Marten Thomas   590329 590329 Marten, Thomas, of Wyndam, wheelwright 1
4193417 2093264 2093264 defendant Male Robert husbandman 590329 590329 Male, Robert, of Wyndam, husbandman 1
4243444 2110799 2110799 defendant Flowerdewe John laborer 590329 590329 Flowerdewe, John, of Wyndam, laborer 0
4243447 2110800 2110800 defendant Flowerdewe John laborer 590329 590329 Flowerdewe, John, of Wyndam, laborer 0
4253783 2114259 2114259 defendant Flowerdewe John laborer 590329 590329 Flowerdewe, John, of Wyndam, laborer 0
4255918 2114955 2114955 defendant Stewarde Geoffrey chapman 590329 590329 Stewarde, Geoffrey, of Wyndam, chapman 2
4285968 2125038 2125038 defendant Hast Katherine widow 590329 590329 Hast, Katherine, of Wyndam, widow 1
4331948 2140980 2140980 defendant Dynne John gent 590329 590329 Dynne, John, of Wyndam, gent 0
4332135 2141046 2141046 defendant Chamberlyn William husbandman 590329 590329 Chamberlyn, William, of Wyndam, husbandman 3
4339169 2143460 2143460 defendant Hamond Robert yeoman 590329 590329 Hamond, Robert, of Wyndam, yeoman 0
4398320 2164019 2164019 defendant Payne William yeoman 590329 590329 Payne, William, of Wyndam, yeoman 0
5028549 2365225 2365225 plaintiff Motte Alan chapman 590329 590329 Motte, Alan, of Wyndam, chapman 0
5028552 2365226 2365226 plaintiff Motte Alan chapman 590329 590329 Motte, Alan, of Wyndam, chapman 0
5029087 2365382 2365382 defendant Lyne Richard carpenter 590329 590329 Lyne, Richard, of Wyndam, carpenter 0
5074369 2378834 2378834 defendant Lotte John hosier 590329 590329 Lotte, John, of Wyndam, hosier 0
5282276 2439875 2439875 defendant Reynold Thomas yeoman 590329 590329 Reynold, Thomas, of Wyndam, yeoman 1

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);