names

30 rows where place_id = 606076

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3663940 1914664 1914664 defendant Reyd Geoffrey turner 606076 606076 Reyd, Geoffrey, of Nacton, turner 0
3671822 1917184 1917184 defendant Blomfeld George yeoman 606076 606076 Blomfeld, George, of Nacton, yeoman 0
3725254 1934186 1934186 defendant Hadge John fuller 606076 606076 Hadge, John, of Nacton, fuller 0
3740211 1938797 1938797 defendant Sylveryn George (legal representative) 606076 606076 Sylveryn, George, of Nacton, fisherman, executors of 0
3740212 1938797 1938797 defendant Castell Thomas mariner 606076 606076 (Castell, Thomas, of Nacton, mariner 1
3778552 1951005 1951005 defendant Dameron John, junior laborer or mariner 606076 606076 Dameron, John, junior, of Nacton, laborer or mariner 2
3791502 1955181 1955181 defendant Falstolf George esq 606076 606076 Falstolf, George, of Nacton, esq 0
3791504 1955182 1955182 defendant Fastolff George esq 606076 606076 Fastolff, George, of Nacton, esq 0
3791507 1955183 1955183 defendant Ussherwood Robert yeoman 606076 606076 Ussherwood, Robert, of Nacton, yeoman 1
3809898 1960980 1960980 defendant Thurston Robert yeoman 606076 606076 Thurston, Robert, of Nacton, yeoman 0
3821719 1964680 1964680 defendant Summer Hugh clerk 606076 606076 Summer, Hugh, of Nacton, clerk 3
3836076 1969197 1969197 defendant Hamond John husbandman 606076 606076 Hamond, John, of Nacton, husbandman 1
3869809 1980146 1980146 defendant Cullyng George   606076 606076 Cullyng, George, of Nacton, twill weaver 2
3903112 1991269 1991269 defendant Rede Richard   606076 606076 Rede, Richard, of Nacton, twill weaver 0
3919575 1996877 1996877 defendant Broke Robert gent 606076 606076 Broke, Robert, of Nacton, gent 0
3923213 1998075 1998075 defendant Dawes Henry husbandman 606076 606076 Dawes, Henry, of Nacton, husbandman 0
3996514 2023512 2023512 defendant Ussherwood alias Thurston Thomas husbandman 606076 606076 Ussherwood alias Thurston, Thomas, of Nacton, husbandman 2
4007310 2027395 2027395 defendant Ussherwood alias Thurston Thomas husbandman 606076 606076 Ussherwood alias Thurston, Thomas, of Nacton, husbandman 0
4007312 2027396 2027396 defendant Ussherwood alias Thurston John yeoman 606076 606076 Ussherwood alias Thurston, John, of Nacton, yeoman 0
4008065 2027648 2027648 defendant Ussherwoode alias Thurston John yeoman 606076 606076 Ussherwoode alias Thurston, John, of Nacton, yeoman 0
4008066 2027648 2027648 defendant Ussherwoode Thomas husbandman 606076 606076 Ussherwoode, Thomas, of Nacton, husbandman 1
4063728 2047316 2047316 defendant Tame Robert husbandman 606076 606076 Tame, Robert, of Nacton, husbandman 2
4098050 2059630 2059630 defendant Duffyn William yeoman 606076 606076 (Duffyn, William, of Nacton, yeoman 3
4101824 2060963 2060963 defendant Durrant John husbandman 606076 606076 Durrant, John, of Nacton, husbandman 1
4123475 2068699 2068699 defendant Woode John laborer 606076 606076 Woode, John, of Nacton, laborer 2
4283482 2124127 2124127 defendant Colman George barber 606076 606076 Colman, George, of Nacton, barber 0
4410580 2168128 2168128 defendant Moyse John yeoman 606076 606076 Moyse, John, of Nacton, or of Hallowtree, yeoman 0
4526854 2208676 2208676 defendant Gouke Robert   606076 606076 Gouke, Robert, of Nacton 0
5137024 2397343 2397343 defendant Average or Anerage William   606076 606076 Average or Anerage, William, of Nacton, parson 2
5221524 2421991 2421991 defendant Reed John tailor 606076 606076 Reed, John, of Nacton, tailor 4

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