names

29 rows where place_id = 650214

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3910806 1993936 1993936 defendant Lyn Thomas esq 650214 650214 Lyn, Thomas, of Bassingborne, Cams, esq 0
3979526 2017435 2017435 defendant Lynne John gent 650214 650214 Lynne, John, of Bassingborne, Cams, gent 0
4013775 2029657 2029657 defendant Braye Robert yeoman 650214 650214 Braye, Robert, of Bassingborne, Cams, or of Eton, Beds, yeoman 0
4024640 2033491 2033491 plaintiff Bolnes or Bolnest William yeoman 650214 650214 Bolnes or Bolnest, William, of Bassingborne, Cams, yeoman 0
4214851 2100695 2100695 defendant Lynne John esq 650214 650214 Lynne, John, of Bassingborne, Cams, esq 0
4217196 2101510 2101510 defendant Netlam John gent 650214 650214 Netlam, John, of Bassingborne, Cams, gent 0
4217198 2101511 2101511 defendant Netlam John gent 650214 650214 Netlam, John, of Bassingborne, Cams, gent 0
4218078 2101820 2101820 defendant Netlome John gent 650214 650214 Netlome, John, of Bassingborne, Cams, gent 0
4221533 2103022 2103022 defendant Lynge Peter gent 650214 650214 Lynge, Peter, of Bassingborne, Cams, gent 0
4224081 2103909 2103909 defendant Lynne John gent 650214 650214 Lynne, John, of Bassingborne, Cams, gent 0
4227300 2105030 2105030 defendant Netlome John gent 650214 650214 Netlome, John, of Bassingborne, Cams, gent 0
4232496 2106871 2106871 defendant Blyghton John yeoman 650214 650214 Blyghton, John, of Bassingborne, Cams, yeoman 0
4241013 2109977 2109977 defendant Lynne John gent 650214 650214 Lynne, John, of Bassingborne, Cams, gent 0
4243556 2110833 2110833 defendant Lynne John esq 650214 650214 Lynne, John, of Bassingborne, Cams, esq 0
4253225 2114074 2114074 defendant Lynge Peter gent 650214 650214 Lynge, Peter, of Bassingborne, Cams, gent 0
4253907 2114305 2114305 defendant Lynne John esq 650214 650214 Lynne, John, of Bassingborne, Cams, esq 0
4259295 2116085 2116085 defendant Lynne John esq 650214 650214 Lynne, John, of Bassingborne, Cams, esq 0
4259297 2116086 2116086 defendant Lynne John esq 650214 650214 Lynne, John, of Bassingborne, Cams, esq 0
4263468 2117445 2117445 defendant Lynn John gent 650214 650214 Lynn, John, of Bassingborne, Cams, gent 0
4263471 2117446 2117446 defendant Lynn John gent 650214 650214 Lynn, John, of Bassingborne, Cams, gent 0
4270401 2119682 2119682 defendant Lynne John esq 650214 650214 Lynne, John, of Bassingborne, Cams, esq 0
4279582 2122775 2122775 defendant Wrighte Nicholas yeoman 650214 650214 Wrighte, Nicholas, of Bassingborne, Cams, yeoman 0
4292607 2127416 2127416 defendant Netlam John gent 650214 650214 Netlam, John, of Bassingborne, Cams, gent 0
4310097 2133688 2133688 defendant Netlam John gent 650214 650214 Netlam, John, of Bassingborne, Cams, gent 0
4320825 2137376 2137376 defendant Netlam John gent 650214 650214 Netlam, John, of Bassingborne, Cams, gent 0
4335566 2142172 2142172 defendant Netlam John gent 650214 650214 Netlam, John, of Bassingborne, Cams, gent 0
4343105 2144860 2144860 defendant Lynne John esq 650214 650214 Lynne, John, of Bassingborne, Cams, esq 0
4355625 2149192 2149192 defendant Glascocke George gent 650214 650214 Glascocke, George, of Bassingborne, Cams, gent 0
4390533 2161456 2161456 defendant Waller alias Warren Richard husbandman 650214 650214 Waller alias Warren, Richard, of Bassingborne, Cams, husbandman 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);