names

39 rows where place_id = 602041

✎ 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
3648189 1909830 1909830 defendant Chauncy John (legal representative) 602041 602041 Chauncy, John, of Porton, gent, executor of 0
3648190 1909830 1909830 defendant Chauncy John gent 602041 602041 Chauncy, John, of Porton, gent 1
3662779 1914278 1914278 defendant Gemokdon Edmund yeoman 602041 602041 Gemokdon, Edmund, of Porton, yeoman 2
3671215 1916970 1916970 plaintiff Chancy John gent 602041 602041 Chancy, John, of Porton, gent 0
3687246 1922189 1922189 defendant Gylbert John husbandman 602041 602041 Gylbert, John, of Porton, husbandman 0
3687247 1922189 1922189 defendant Gylbert Peter husbandman 602041 602041 Gylbert, Peter, of Porton, husbandman 1
3694704 1924548 1924548 defendant Wymbleton William, junior husbandman 602041 602041 Wymbleton, William, junior, of Porton, husbandman 1
4189772 2091918 2091918 defendant Creswell Peter husbandman 602041 602041 Creswell, Peter, of Porton, husbandman 1
4189773 2091918 2091918 defendant Hyscox Richard husbandman 602041 602041 Hyscox, Richard, of Porton, husbandman 2
4234274 2107522 2107522 defendant Gomeldon William gent 602041 602041 Gomeldon, William, of Porton, gent 0
4234276 2107523 2107523 defendant Gomeldon William gent 602041 602041 Gomeldon, William, of Porton, gent 0
4237973 2108884 2108884 defendant Wymbleton Nicholas yeoman 602041 602041 Wymbleton, Nicholas, of Porton, yeoman 1
4252960 2113983 2113983 defendant Gomeldon or Gombleton William gent 602041 602041 Gomeldon or Gombleton, William, of Porton, gent 0
4252962 2113984 2113984 defendant Gomeldon William gent 602041 602041 Gomeldon, William, of Porton, gent 0
4271011 2119878 2119878 defendant Wymbleton Nicholas yeoman 602041 602041 Wymbleton, Nicholas, of Porton, yeoman 1
4271458 2120032 2120032 defendant Gomelton William   602041 602041 Gomelton, William, of Porton, Wilts gent 0
4298204 2129458 2129458 defendant Gomeldon William gent 602041 602041 Gomeldon, William, of Porton, gent 0
4322296 2137872 2137872 defendant Gomyldon William gent 602041 602041 Gomyldon, William, of Porton, gent 0
4354687 2148869 2148869 defendant Gomeldon William, junior gent 602041 602041 Gomeldon, William, junior, of Porton, gent 0
4354691 2148871 2148871 defendant Gomeldon William gent 602041 602041 Gomeldon, William, of Porton, gent 0
4364106 2152218 2152218 defendant Dennys Edmund yeoman 602041 602041 Dennys, Edmund, of Porton, yeoman 0
4411185 2168328 2168328 defendant Gomeldon William gent 602041 602041 Gomeldon, William, of Porton, gent 2
4529345 2209461 2209461 defendant Lok William   602041 602041 Lok, William, of Porton 0
4826554 2304340 2304340 defendant Adam William husbandman 602041 602041 Adam, William, of Porton, husbandman 1
4834451 2306782 2306782 plaintiff Cranburn John clerk 602041 602041 Cranburn, John, of Porton, clerk 0
4852719 2312274 2312274 defendant Adam William husbandman 602041 602041 Adam, William, of Porton, husbandman 1
4853140 2312399 2312399 defendant Santes John tailor 602041 602041 Santes, John, of Porton, tailor 1
4880646 2320856 2320856 defendant Adam William husbandman 602041 602041 Adam, William, of Porton, husbandman 0
4899130 2326370 2326370 defendant Beelde Thomas husbandman 602041 602041 Beelde, Thomas, of Porton, husbandman 2
4956640 2343942 2343942 defendant Pane Thomas clerk 602041 602041 Pane, Thomas, of Porton, clerk 0
5102273 2387083 2387083 defendant Chancy Nicholas gent 602041 602041 Chancy, Nicholas, of Porton, gent 0
5102274 2387083 2387083 defendant Chancy John, junior gent 602041 602041 Chancy, John, junior, of Porton, gent 1
5125899 2394062 2394062 defendant Chancy Nicholas gent 602041 602041 Chancy, Nicholas, of Porton, gent 0
5125901 2394062 2394062 defendant Chancy John gent 602041 602041 Chancy, John, of Porton, junior, gent 2
5126076 2394109 2394109 defendant Chancy Nicholas   602041 602041 Chancy, Nicholas, of Porton 0
5308222 2447491 2447491 defendant Almayne William husbandman 602041 602041 Almayne, William, of Porton, husbandman 1
5431169 2484264 2484264 defendant Bele Edmund husbandman 602041 602041 Bele, Edmund, of Porton, husbandman 0
5452560 2490648 2490648 defendant Ba_ Morris husbandman 602041 602041 Ba_, Morris, of Porton, husbandman 1
5568228 2525250 2525250 plaintiff Cowell Thomas   602041 602041 Cowell, Thomas, of Porton 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);