names

21 rows where place_id = 632884

✎ 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
3809329 1960800 1960800 defendant Mannyng Walter clothman 632884 632884 Mannyng, Walter, of Stowmarkett, Suff, clothman 0
3834382 1968697 1968697 defendant Mannyng Walter clothmaker 632884 632884 Mannyng, Walter, of Stowmarkett, Suff, clothmaker 0
3849481 1973438 1973438 defendant Man John innholder 632884 632884 Man, John, of Stowmarkett, Suff, innholder 1
3850446 1973728 1973728 defendant Symond Robert clothmaker 632884 632884 Symond, Robert, of Stowmarkett, Suff, clothmaker 0
3850448 1973729 1973729 defendant Symond Robert clothman 632884 632884 Symond, Robert, of Stowmarkett, Suff, clothman 0
3850666 1973796 1973796 defendant Symond Robert clothmaker 632884 632884 Symond, Robert, of Stowmarkett, Suff, clothmaker 0
3881952 1984221 1984221 defendant Symond Robert clothier 632884 632884 Symond, Robert, of Stowmarkett, Suff, clothier 1
3898769 1989790 1989790 defendant Fysshe John tailor 632884 632884 Fysshe, John, of Stowmarkett, Suff, tailor 4
3907157 1992684 1992684 defendant Tirrell John gent 632884 632884 Tirrell, John, of Stowmarkett, Suff, gent 0
3963752 2011924 2011924 defendant Alam or Alain Thomas shoemaker 632884 632884 Alam or Alain, Thomas, of Stowmarkett, Suff, shoemaker 0
3975368 2015951 2015951 plaintiff Howse John, senior clothier 632884 632884 Howse, John, senior, of Stowmarkett, Suff, clothier 0
3990680 2021419 2021419 defendant Gardyner John gent 632884 632884 Gardyner, John, of Stowmarkett, Suff, gent 1
4066749 2048406 2048406 plaintiff Howe John, senior clothier 632884 632884 Howe, John, senior, of Stowmarkett, Suff, clothier 0
4066751 2048407 2048407 plaintiff Howe John, senior clothier 632884 632884 Howe, John, senior, of Stowmarkett, Suff, clothier 0
4066753 2048408 2048408 plaintiff Howe John, senior clothier 632884 632884 Howe, John, senior, of Stowmarkett, Suff, clothier 0
4186190 2090653 2090653 defendant Withipoll Peter gent 632884 632884 Withipoll, Peter, of Stowmarkett, Suff, gent 2
4210428 2099206 2099206 defendant Cortnall John yeoman 632884 632884 Cortnall, John, of Stowmarkett, Suff, yeoman 0
4220923 2102813 2102813 defendant Wright Richard draper 632884 632884 Wright, Richard, of Stowmarkett, Suff, draper 0
4271383 2120005 2120005 defendant Wright Richard draper 632884 632884 Wright, Richard, of Stowmarkett, Suff, draper 0
4346604 2146065 2146065 defendant Fynche Alan innholder 632884 632884 Fynche, Alan, of Stowmarkett, Suff, innholder 1
4372871 2155373 2155373 defendant Duton Katherine widow 632884 632884 Duton, Katherine, of Stowmarkett, Suff, widow 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);