names

43 rows where place_id = 636241

✎ 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
3829747 1967196 1967196 defendant Ferrour Edward gent 636241 636241 Ferrour, Edward, of Gressenhall, gent 0
3856284 1975584 1975584 defendant Dey John husbandman 636241 636241 Dey, John, of Gressenhall, husbandman 0
3856288 1975585 1975585 defendant Dey John husbandman 636241 636241 Dey, John, of Gressenhall, husbandman 0
3917983 1996381 1996381 defendant Trenche Edmund yeoman 636241 636241 Trenche, Edmund, of Gressenhall, yeoman 1
3930560 2000563 2000563 defendant Shortyng Nicholas carpenter 636241 636241 Shortyng, Nicholas, of Gressenhall, carpenter 4
3944199 2005076 2005076 defendant Bache John tailor 636241 636241 Bache, John, of Gressenhall, tailor 0
3944202 2005077 2005077 defendant Batch or Bath John tailor 636241 636241 Batch or Bath, John, of Gressenhall, tailor 0
3944401 2005140 2005140 defendant Mayneforde John yeoman 636241 636241 Mayneforde, John, of Gressenhall, yeoman 0
3947087 2006046 2006046 defendant Dey John husbandman 636241 636241 Dey, John, of Gressenhall, husbandman 1
3952021 2007771 2007771 defendant Franklyn Richard clerk 636241 636241 Franklyn, Richard, of Gressenhall, clerk 0
3952022 2007771 2007771 defendant Trenche John yeoman 636241 636241 together with Trenche, John, of Gressenhall, yeoman 1
3952026 2007773 2007773 defendant Trenche John yeoman 636241 636241 Trenche, John, of Gressenhall, yeoman 0
3952465 2007930 2007930 defendant Bache John tailor 636241 636241 Bache, John, of Gressenhall, tailor 3
3952727 2008025 2008025 defendant Harward Clement gent 636241 636241 Harward, Clement, of Gressenhall, gent 0
3952728 2008025 2008025 defendant Sowgate Robert laborer 636241 636241 together with Sowgate, Robert, of Gressenhall, laborer 1
3958659 2010104 2010104 defendant Bache John tailor 636241 636241 Bache, John, of Gressenhall, tailor 0
3959101 2010267 2010267 defendant Barrett William (legal representative) 636241 636241 Barrett, William, of Gressenhall, husbandman, executors of 0
3959102 2010267 2010267 defendant Barrett Thomas husbandman 636241 636241 (Barrett, Thomas, of Gressenhall, husbandman 1
3961340 2011061 2011061 defendant Ferrour John yeoman 636241 636241 Ferrour, John, of Gressenhall, yeoman 0
3961341 2011062 2011062 plaintiff Trenche John   636241 636241 Trenche, John, of Gressenhall 0
3961342 2011062 2011062 defendant Barrett William (legal representative) 636241 636241 Barrett, William, of Gressenhall, husbandman, executors of 0
3961343 2011062 2011062 defendant Barrett Thomas husbandman 636241 636241 (Barrett, Thomas, of Gressenhall, husbandman 1
3961344 2011062 2011062 defendant Barrett Emma widow 636241 636241 Barrett, Emma, of Gressenhall, widow 2
3967901 2013401 2013401 defendant Collyson Thomas tanner 636241 636241 Collyson, Thomas, of Gressenhall, tanner 0
3983451 2018857 2018857 defendant Farwell William yeoman 636241 636241 Farwell, William, of Gressenhall, yeoman 1
4014804 2030008 2030008 defendant Frary John yeoman 636241 636241 Frary, John, of Gressenhall, yeoman 0
4031995 2036110 2036110 defendant Daye Henry tailor 636241 636241 Daye, Henry, of Gressenhall, tailor 0
4061181 2046407 2046407 defendant Warner Thomas baker 636241 636241 Warner, Thomas, of Gressenhall, baker 3
4061186 2046408 2046408 defendant Warner John husbandman 636241 636241 Warner, John, of Gressenhall, husbandman 3
4077444 2052221 2052221 defendant Frary John yeoman 636241 636241 Frary, John, of Gressenhall, yeoman 0
4094382 2058330 2058330 defendant Warner John, senior husbandman 636241 636241 Warner, John, senior, of Gressenhall, husbandman 2
4101823 2060963 2060963 defendant Ferror John yeoman 636241 636241 Ferror, John, of Gressenhall, yeoman 0
4147657 2077322 2077322 defendant Taylor George yeoman 636241 636241 Taylor, George, of Gressenhall, yeoman 0
4163578 2082782 2082782 defendant Farrour John, junior yeoman 636241 636241 Farrour, John, junior, of Gressenhall, yeoman 0
4226168 2104625 2104625 defendant Curson Robert yeoman 636241 636241 Curson, Robert, of Gressenhall, yeoman 0
4226169 2104625 2104625 defendant Branson Thomas yeoman 636241 636241 together with Branson, Thomas, of Gressenhall, yeoman 1
4226170 2104625 2104625 defendant Cresse Thomas yeoman 636241 636241 Cresse, Thomas, of Gressenhall, yeoman 2
4226171 2104625 2104625 defendant Clarke John yeoman 636241 636241 Clarke, John, of Gressenhall, yeoman 3
4229657 2105855 2105855 defendant Byrde Edmund yeoman 636241 636241 Byrde, Edmund, of Gressenhall, yeoman 0
4288743 2126031 2126031 defendant Stywarde Thomas gent 636241 636241 Stywarde, Thomas, of Gressenhall, gent 0
4396099 2163270 2163270 defendant Hekelton Thomas husbandman 636241 636241 Hekelton, Thomas, of Gressenhall, husbandman 0
4401333 2165043 2165043 defendant Scott Edmund turner 636241 636241 Scott, Edmund, of Gressenhall, turner 0
4407199 2166971 2166971 defendant Welles Thomas glover 636241 636241 Welles, Thomas, of Gressenhall, glover 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);