names

23 rows where place_id = 625248

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3763042 1946072 1946072 defendant Dogett Richard clothmaker 625248 625248 Dogett, Richard, of Groton, Suff, clothmaker 0
3814948 1962592 1962592 defendant Todde Edmund clothmaker 625248 625248 Todde, Edmund, of Groton, Suff, clothmaker 0
3826618 1966172 1966172 defendant Dogett Richard clothmaker 625248 625248 Dogett, Richard, of Groton, Suff, clothmaker 0
3871882 1980832 1980832 defendant Dogett Richard clothmaker 625248 625248 Dogett, Richard, of Groton, Suff, clothmaker 0
3871883 1980832 1980832 defendant Todde Edmund clothmaker 625248 625248 Todde, Edmund, of Groton, Suff, clothmaker 1
3872528 1981035 1981035 defendant Todde Edmund clothmaker 625248 625248 Todde, Edmund, of Groton, Suff, clothmaker 0
3918871 1996633 1996633 defendant Todde Edmund sherman 625248 625248 Todde, Edmund, of Groton, Suff, sherman 1
3953515 2008301 2008301 defendant Warde John, senior clothier 625248 625248 Warde, John, senior, of Groton, Suff, clothier 1
3982120 2018364 2018364 defendant Whyting John clothier 625248 625248 Whyting, John, of Groton, Suff, clothier 0
4004410 2026356 2026356 defendant Sowter John clothier 625248 625248 Sowter, John, of Groton, Suff, clothier 0
4059528 2045801 2045801 defendant Neves Arthur clothier 625248 625248 Neves, Arthur, of Groton, Suff, clothier 0
4068955 2049186 2049186 plaintiff Lappage Thomas clothier 625248 625248 Lappage, Thomas, of Groton, Suff, clothier 0
4083737 2054456 2054456 defendant Snellynge Simon clothier 625248 625248 Snellynge, Simon, of Groton, Suff, clothier 0
4294203 2128001 2128001 defendant Beryff John husbandman 625248 625248 Beryff, John, of Groton, Suff, husbandman 3
4362720 2151724 2151724 defendant Coe John clothier 625248 625248 Coe, John, of Groton, Suff, clothier 0
5047242 2370797 2370797 defendant Cos John chapman 625248 625248 Cos, John, of Groton, Suff, chapman 0
5047260 2370802 2370802 defendant Coo John chapman 625248 625248 Coo, John, of Groton, Suff, chapman 0
5070190 2377578 2377578 defendant Koo John mercer 625248 625248 Koo, John, of Groton, Suff, mercer 1
5239435 2427115 2427115 defendant Gale John clothmaker 625248 625248 Gale, John,of Groton, Suff, clothmaker 1
5500866 2505202 2505202 defendant Auncell alias Smyth John smith 625248 625248 Auncell alias Smyth, John, of Groton, Suff, smith 3
5529541 2513738 2513738 defendant Wright Thomas clothmaker 625248 625248 Wright, Thomas, of Groton, Suff, clothmaker 0
5529613 2513762 2513762 defendant Waspp John husbandman 625248 625248 Waspp, John, of Groton, Suff, husbandman 0
5557677 2522202 2522202 defendant Seman Richard yeoman 625248 625248 Seman, Richard, of Groton, Suff, yeoman 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);