names

46 rows where place_id = 603317

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654152 1911561 1911561 defendant Cotterell John husbandman 603317 603317 Cotterell, John, of Tonworth, husbandman 1
3655516 1911984 1911984 defendant Grene Thomas husbandman 603317 603317 Grene, Thomas, of Tonworth, husbandman 0
3710418 1929577 1929577 defendant Whateley Thomas husbandman 603317 603317 Whateley, Thomas, of Tonworth, husbandman 0
3741229 1939115 1939115 defendant Edwardys William (legal representative) 603317 603317 Edwardys, William, of Tonworth, executrix of 0
3741230 1939115 1939115 defendant Edwardys Joan widow 603317 603317 Edwardys, Joan, of Tonworth, widow 1
3748480 1941458 1941458 defendant Praty Robert husbandman 603317 603317 Praty, Robert, of Tonworth, husbandman 0
3795258 1956383 1956383 defendant Baron John laborer 603317 603317 Baron, John, of Tonworth, laborer 2
3813426 1962117 1962117 defendant Hunt John yeoman 603317 603317 Hunt, John, of Tonworth, yeoman 0
3813427 1962117 1962117 defendant Hunt Katherine widow 603317 603317 Hunt, Katherine, of Tonworth, widow 1
3816964 1963212 1963212 defendant Shudale William yeoman 603317 603317 Shudale, William, of Tonworth, yeoman 0
3849501 1973444 1973444 defendant Fulwod Richard gent 603317 603317 Fulwod, Richard, of Tonworth, gent 0
3849502 1973444 1973444 defendant Hay John yeoman 603317 603317 Hay, John, of Tonworth, yeoman 1
3857873 1976102 1976102 defendant Cottrell Thomas husbandman 603317 603317 Cottrell, Thomas, of Tonworth, husbandman 0
3864639 1978371 1978371 defendant Fullwood Richard gent 603317 603317 Fullwood, Richard, of Tonworth, gent 0
3864641 1978372 1978372 defendant Fullwood Richard gent 603317 603317 Fullwood, Richard, of Tonworth, gent 0
3870477 1980366 1980366 defendant Waryng Thomas yeoman 603317 603317 Waryng, Thomas, of Tonworth, yeoman 2
4145086 2076442 2076442 defendant Baumford John carpenter 603317 603317 Baumford, John, of Tonworth, carpenter 0
4558551 2218627 2218627 defendant atte Welle William   603317 603317 atte Welle, William, of Tonworth 0
4668430 2255838 2255838 defendant Sydenhale Thomas esq 603317 603317 Sydenhale, Thomas, of Tonworth, esq 0
4680818 2259622 2259622 defendant Warner Richard husbandman 603317 603317 Warner, Richard, of Tonworth, husbandman 0
4706520 2267420 2267420 defendant Warner Richard husbandman 603317 603317 Warner, Richard, of Tonworth, husbandman 0
4999935 2356857 2356857 defendant Sawyer Thomas husbandman 603317 603317 Sawyer, Thomas, of Tonworth, husbandman 0
5018810 2362388 2362388 defendant Sydonhale Thomas collier 603317 603317 Sydonhale, Thomas, of Tonworth, collier 1
5031474 2366063 2366063 defendant Broune John husbandman 603317 603317 Broune, John, of Tonworth, husbandman 1
5042771 2369444 2369444 defendant Person Richard   603317 603317 Person, Richard, of Tonworth, parson 0
5051712 2372123 2372123 defendant Greweley John husbandman 603317 603317 Greweley, John, of Tonworth, husbandman 4
5051717 2372124 2372124 defendant Breweley John husbandman 603317 603317 Breweley, John, of Tonworth, husbandman 3
5114934 2390782 2390782 defendant Waryng Richard carpenter 603317 603317 Waryng, Richard, of Tonworth, carpenter 2
5141533 2398639 2398639 defendant Fulwode Richard esq 603317 603317 Fulwode, Richard, of Tonworth, esq 2
5162641 2404793 2404793 defendant Fulwode Richard esq 603317 603317 Fulwode, Richard, of Tonworth, esq 1
5176610 2408843 2408843 defendant Fulwode Richard esq 603317 603317 Fulwode, Richard, of Tonworth, esq 1
5191176 2413160 2413160 defendant Whicherley Richard yeoman 603317 603317 Whicherley, Richard, of Tonworth, yeoman 0
5336895 2456101 2456101 defendant Parker Thomas, junior gent 603317 603317 Parker, Thomas, junior, of Tonworth, gent, son of Parker, Thomas, senior, gent 0
5356226 2462026 2462026 defendant Norys John husbandman 603317 603317 Norys, John, of Tonworth, husbandman 2
5364561 2464576 2464576 defendant Dolphyn Richard smith 603317 603317 Dolphyn, Richard, of Tonworth, smith 1
5534272 2515254 2515254 plaintiff Archer John esq 603317 603317 Archer, John, of Tonworth, esq 0
5534276 2515255 2515255 plaintiff Archer John esq 603317 603317 Archer, John, of Tonworth, esq 0
5541954 2517605 2517605 defendant Waren John husbandman 603317 603317 Waren, John, of Tonworth, husbandman 0
5544619 2518426 2518426 defendant Boteler Richard gent 603317 603317 Boteler, Richard, of Tonworth, gent 0
5544648 2518434 2518434 defendant Archer John gent 603317 603317 Archer, John, of Tonworth, gent 0
5544649 2518434 2518434 defendant Parsons William yeoman 603317 603317 Parsons, William, of Tonworth, yeoman 1
5544650 2518434 2518434 defendant Sheldon John yeoman 603317 603317 Sheldon, John, of Tonworth, yeoman 2
5544654 2518435 2518435 defendant Parsons William yeoman 603317 603317 Parsons, William, of Tonworth, yeoman 0
5544655 2518435 2518435 defendant Sheldon John yeoman 603317 603317 Sheldon, John, of Tonworth, yeoman 1
5544656 2518435 2518435 defendant Archer John gent 603317 603317 Archer, John, of Tonworth, gent 2
5572294 2526451 2526451 defendant Archer John esq 603317 603317 Archer, John, of Tonworth, esq 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);