names

20 rows where place_id = 626102

✎ 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
3768021 1947636 1947636 defendant Lambe Henry hardwareman 626102 626102 Lambe, Henry, of Bungaye, Suff, hardwareman 2
3946357 2005799 2005799 plaintiff Button Edward yeoman 626102 626102 Button, Edward, of Bungaye, Suff, yeoman 0
3950233 2007168 2007168 defendant Sudborne Walter chandler 626102 626102 Sudborne, Walter, of Bungaye, Suff, chandler 0
3952342 2007890 2007890 defendant Woodall Hamon ironmonger 626102 626102 Woodall, Hamon, of Bungaye, Suff, ironmonger 0
3961123 2010987 2010987 defendant Ayde Joan widow 626102 626102 Ayde, Joan, of Bungaye, Suff, widow 0
4025215 2033681 2033681 plaintiff Bowebright John yeoman 626102 626102 Bowebright, John, of Bungaye, Suff, yeoman 1
4038977 2038561 2038561 defendant Edward Robert baker 626102 626102 Edward, Robert, of Bungaye, Suff, baker 0
4054865 2044132 2044132 defendant Browne William chapman 626102 626102 Browne, William, of Bungaye, Suff, chapman 0
4077436 2052219 2052219 plaintiff Spyllyng Robert blacksmith 626102 626102 Spyllyng, Robert, of Bungaye, Suff, blacksmith 0
4077441 2052220 2052220 plaintiff Spyllynge Robert blacksmith 626102 626102 Spyllynge, Robert, of Bungaye, Suff, blacksmith 0
4128050 2070321 2070321 defendant Browne Thomas husbandman 626102 626102 Browne, Thomas, of Bungaye, Suff, husbandman 1
4163035 2082607 2082607 defendant Otebye William chapman 626102 626102 Otebye, William, of Bungaye, Suff, chapman 3
4176605 2087292 2087292 defendant Downyng Thomas chapman 626102 626102 Downyng, Thomas, of Bungaye, Suff, chapman 1
4185177 2090323 2090323 defendant Calver James saddler 626102 626102 Calver, James, of Bungaye, Suff, saddler 0
4197620 2094723 2094723 defendant Creake Robert chapman 626102 626102 Creake, Robert, of Bungaye, Suff, chapman 0
4199455 2095358 2095358 defendant Huggyns Agnes widow 626102 626102 Huggyns, Agnes, of Bungaye, Suff, widow 1
4211262 2099490 2099490 defendant Costerden Edmund draper 626102 626102 Costerden, Edmund, of Bungaye, Suff, draper 0
4215044 2100765 2100765 defendant Reade John   626102 626102 Reade, John, of Bungaye, Suff, surgeon 0
4277401 2122018 2122018 defendant Bulmer Thomas gent 626102 626102 Bulmer, Thomas, of Bungaye, Suff, gent 0
4366505 2153066 2153066 defendant Bulwer Winifred widow 626102 626102 Bulwer, Winifred, of Bungaye, Suff, widow 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);