names

35 rows where place_id = 589541

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597913 1866968 1866968 defendant Wollaston Thomas yeoman 589541 589541 Wollaston, Thomas, of Lempster, yeoman 0
3620967 1874121 1874121 defendant Chapman Richard mercer 589541 589541 Chapman, Richard, of Lempster, or of Presthempde, March of Wales, mercer 0
3719029 1932227 1932227 defendant Grene John tailor 589541 589541 Grene, John, of Lempster, tailor 0
3729337 1935429 1935429 defendant Hussy Thomas currier 589541 589541 Hussy, Thomas, of Lempster, currier 1
3732655 1936444 1936444 defendant Wattis Philip weaver 589541 589541 Wattis, Philip, of Lempster, weaver 0
3835521 1969049 1969049 defendant Carpenter John butcher 589541 589541 Carpenter, John, of Lempster, butcher 0
3835522 1969049 1969049 defendant Stephyns John butcher 589541 589541 Stephyns, John, of Lempster, butcher 1
3835524 1969049 1969049 defendant Lluwellan Hugh butcher 589541 589541 Lluwellan, Hugh, of Lempster, butcher 3
3851447 1974047 1974047 defendant Skarlett Walter husbandman 589541 589541 Skarlett, Walter, of Lempster, husbandman 1
3865128 1978539 1978539 defendant Agwilliam John chapman 589541 589541 Agwilliam, John, of Lempster, chapman 1
3875892 1982192 1982192 defendant Cocke John innholder 589541 589541 Cocke, John, of Lempster, innholder 0
3887356 1986035 1986035 defendant Stalward Richard husbandman 589541 589541 Stalward, Richard, of Lempster, husbandman 1
3898018 1989544 1989544 plaintiff Yong Margery widow 589541 589541 Yong, Margery, of Lempster, widow 0
3898021 1989545 1989545 plaintiff Yong Margery widow 589541 589541 Yong, Margery, of Lempster, widow 0
3980143 2017664 2017664 plaintiff Passye David mercer 589541 589541 Passye, David, of Lempster, mercer 0
4020770 2032154 2032154 defendant Blacke William yeoman 589541 589541 Blacke, William, of Lempster, yeoman 8
4053652 2043681 2043681 plaintiff ap Thomas John (legal representative) 589541 589541 ap Thomas, John, of Lempster, mercer, executors of 0
4066606 2048351 2048351 defendant Crossall John vintner 589541 589541 Crossall, John, of Lempster, vintner 1
4073733 2050899 2050899 defendant Poull Richard yeoman 589541 589541 Poull, Richard, of Lempster, yeoman 1
4293125 2127606 2127606 defendant Hyatt James gent 589541 589541 Hyatt, James, of Lempster, gent 3
4324529 2138594 2138594 defendant Hyett James gent 589541 589541 Hyett, James, of Lempster, gent 0
4399380 2164381 2164381 defendant Smyth John butcher 589541 589541 Smyth, John, of Lempster , butcher 0
4404038 2165921 2165921 defendant Ingle William butcher 589541 589541 Ingle, William, of Lempster, butcher 0
5280033 2439232 2439232 defendant Skarlette Thomas chapman 589541 589541 Skarlette, Thomas, of Lempster, chapman 0
5492996 2502814 2502814 defendant Haklet Thomas butcher 589541 589541 Haklet, Thomas, of Lempster, butcher 4
5493009 2502816 2502816 defendant Hakket Thomas butcher 589541 589541 Hakket, Thomas, of Lempster, butcher 3
5511668 2508497 2508497 plaintiff Kyng William   589541 589541 Kyng, William, of Lempster 0
5511669 2508497 2508497 defendant Waythan John yeoman 589541 589541 Waythan, John, of Lempster, yeoman 0
5511670 2508497 2508497 defendant Baker alias Godeman Richard baker 589541 589541 Baker alias Godeman, Richard, of Lempster, baker 1
5511671 2508497 2508497 defendant Dyer John chaplain 589541 589541 Dyer, John, of Lempster, chaplain 2
5511672 2508497 2508497 defendant Trene or Treve Thomas yeoman 589541 589541 Trene or Treve, Thomas, of Lempster, yeoman 3
5511673 2508497 2508497 defendant Dawes Geoffrey yeoman 589541 589541 Dawes, Geoffrey, of Lempster, yeoman 4
5515131 2509579 2509579 defendant Redeyng Philip yeoman 589541 589541 Redeyng, Philip, of Lempster, yeoman 0
5515132 2509579 2509579 defendant Howeton Thomas walker 589541 589541 Howeton, Thomas, of Lempster, walker 1
5515153 2509584 2509584 plaintiff Scarlett John   589541 589541 Scarlett, John, of Lempster 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);