names

34 rows where place_id = 597840

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3630069 1904252 1904252 defendant Selewyn Richard gent 597840 597840 Selewyn, Richard, of Feltwell, Norf, gent 0
3648898 1910044 1910044 defendant Holeour Thomas husbandman 597840 597840 Holeour, Thomas, of Feltwell, Norf, husbandman 0
3657699 1912658 1912658 defendant Trodys Alexander clerk 597840 597840 Trodys, Alexander, of Feltwell, Norf, clerk 0
3657847 1912704 1912704 defendant Toke Robert (legal representative) 597840 597840 Toke, Robert, of Feltwell, Norf, mercer, executor of 0
3820857 1964415 1964415 defendant Moundeford Francis esq 597840 597840 Moundeford, Francis, of Feltwell, Norf, esq 0
3820926 1964439 1964439 defendant Moundeford Francis esq 597840 597840 Moundeford, Francis, of Feltwell, Norf, esq 3
3836355 1969277 1969277 defendant Moundeford Francis esq 597840 597840 Moundeford, Francis, of Feltwell, Norf, esq 3
3852411 1974358 1974358 defendant Moundford Francis esq 597840 597840 Moundford, Francis, of Feltwell, Norf, esq 0
3871430 1980691 1980691 defendant Dey Thomas husbandman 597840 597840 Dey, Thomas, of Feltwell, Norf, husbandman 2
3871457 1980698 1980698 defendant Tailour Richard clerk 597840 597840 Tailour, Richard, of Feltwell, Norf, clerk 0
3876154 1982272 1982272 defendant Dey William yeoman 597840 597840 Dey, William, of Feltwell, Norf, yeoman 2
3961531 2011133 2011133 defendant Flud Richard grocer 597840 597840 Flud, Richard, of Feltwell, Norf, grocer 0
3961534 2011134 2011134 defendant Flud Richard grocer 597840 597840 Flud, Richard, of Feltwell, Norf, grocer 0
4061412 2046485 2046485 defendant Moundforde Osbert esq 597840 597840 (Moundforde, Osbert, of Feltwell, Norf, esq 1
4220998 2102838 2102838 defendant Turner John yeoman 597840 597840 Turner, John, of Feltwell, Norf, yeoman 2
4306526 2132422 2132422 defendant Cutler Nicholas gent 597840 597840 Cutler, Nicholas, of Feltwell, Norf, or of Eye, Suff, gent 0
4400040 2164601 2164601 defendant Cutler Nicholas gent 597840 597840 Cutler, Nicholas, of Feltwell, Norf, gent 0
4875385 2319258 2319258 defendant Skynner Richard, senior husbandman 597840 597840 Skynner, Richard, senior, of Feltwell, Norf, husbandman 1
4889037 2323362 2323362 defendant Croke Robert   597840 597840 Croke, Robert, of Feltwell, Norf 1
4957097 2344078 2344078 defendant Mounford Adam gent 597840 597840 together with Mounford, Adam, of Feltwell, Norf, gent 3
4957101 2344079 2344079 defendant Mountford Adam gent 597840 597840 Mountford, Adam, of Feltwell, Norf, gent 2
4959765 2344885 2344885 defendant Carle John clerk 597840 597840 Carle, John, of Feltwell, Norf, clerk 0
4963291 2345930 2345930 defendant Crowe Robert clerk 597840 597840 Crowe, Robert, of Feltwell, Norf, clerk 1
4995363 2355456 2355456 defendant Hoslyn John yeoman 597840 597840 Hoslyn, John, of Feltwell, Norf, yeoman 0
5001002 2357171 2357171 defendant Crowe Robert   597840 597840 Crowe, Robert, of Feltwell, Norf, parson 2
5278977 2438962 2438962 defendant Ward Gregory husbandman 597840 597840 Ward, Gregory, of Feltwell, Norf, husbandman 5
5320984 2451368 2451368 defendant Chynchbold William yeoman 597840 597840 Chynchbold, William, of Feltwell, Norf, yeoman 0
5320987 2451369 2451369 defendant Chynchbold William yeoman 597840 597840 Chynchbold, William, of Feltwell, Norf, yeoman 0
5528402 2513421 2513421 defendant Taillour Alexander yeoman 597840 597840 Taillour, Alexander, of Feltwell, Norf, yeoman 1
5558173 2522341 2522341 defendant Selwyn Richard gent 597840 597840 Selwyn, Richard, of Feltwell, Norf, gent 4
5573190 2526709 2526709 defendant Johnson Lawrence yeoman 597840 597840 Johnson, Lawrence, of Feltwell, Norf, yeoman 0
5573194 2526711 2526711 defendant Forrest Robert husbandman 597840 597840 Forrest, Robert, of Feltwell, Norf, husbandman 0
5587723 2531176 2531176 defendant Johnson Lawrence yeoman 597840 597840 Johnson, Lawrence, of Feltwell, Norf, yeoman 0
5587725 2531177 2531177 defendant Johnson Lawrence yeoman 597840 597840 Johnson, Lawrence, of Feltwell, Norf, 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);