names

74 rows where place_id = 613727

✎ 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
3700017 1926239 1926239 defendant Denny John yeoman 613727 613727 Denny, John, of Denver, yeoman 2
3703647 1927421 1927421 defendant Godbody John laborer 613727 613727 Godbody, John, of Denver, laborer 1
3735057 1937204 1937204 defendant Atkyn John husbandman 613727 613727 Atkyn, John, of Denver, husbandman 0
3755913 1943804 1943804 defendant Wylloughby John gent 613727 613727 Wylloughby, John, of Denver, gent 0
3786656 1953621 1953621 defendant Guy Robert glover 613727 613727 Guy, Robert, of Denver, glover 0
3786657 1953621 1953621 defendant Orme William laborer 613727 613727 Orme, William, of Denver, laborer 1
3786659 1953621 1953621 defendant Repplenham William tailor 613727 613727 Repplenham, William, of Denver, tailor 3
3786660 1953621 1953621 defendant Colson Richard laborer 613727 613727 Colson, Richard, of Denver, laborer 4
3786661 1953621 1953621 defendant Richardson John laborer 613727 613727 Richardson, John, of Denver, laborer 5
3786662 1953621 1953621 defendant Taillour Henry laborer 613727 613727 Taillour, Henry, of Denver, laborer 6
3786664 1953622 1953622 defendant Orme Edmund husbandman 613727 613727 Orme, Edmund, of Denver, husbandman 0
3786665 1953622 1953622 defendant Reder Thomas husbandman 613727 613727 Reder, Thomas, of Denver, husbandman 1
3800723 1958139 1958139 defendant Colyn Robert, senior laborer 613727 613727 Colyn, Robert, senior, of Denver, laborer 0
3800724 1958139 1958139 defendant Goodebody John laborer 613727 613727 Goodebody, John, of Denver, laborer 1
3840718 1970663 1970663 defendant Whytby alias Dyker Robert husbandman 613727 613727 Whytby alias Dyker, Robert, of Denver, husbandman 0
3846145 1972349 1972349 defendant Tassell Thomas husbandman 613727 613727 Tassell, Thomas, of Denver, husbandman 1
3849894 1973552 1973552 defendant Drory Peter smith 613727 613727 Drory, Peter, of Denver, smith 0
3850219 1973660 1973660 defendant Menes William miller 613727 613727 Menes, William, of Denver, miller 0
3876212 1982289 1982289 defendant Dawnham William clerk 613727 613727 Dawnham, William, of Denver, clerk 1
3876213 1982289 1982289 defendant Deny John yeoman 613727 613727 Deny, John, of Denver, yeoman 2
3886241 1985650 1985650 defendant Cottys John husbandman 613727 613727 Cottys, John, of Denver, husbandman 3
3888220 1986316 1986316 defendant Cottys John husbandman 613727 613727 Cottys, John, of Denver, husbandman 1
3888221 1986316 1986316 defendant Symson William husbandman 613727 613727 Symson, William, of Denver, husbandman 2
3889738 1986804 1986804 defendant Cootys Richard husbandman 613727 613727 Cootys, Richard, of Denver, husbandman 2
3957820 2009796 2009796 defendant Hyllarye Robert gent 613727 613727 Hyllarye, Robert, of Denver, gent 0
3971409 2014557 2014557 defendant Fytche Edward husbandman 613727 613727 Fytche, Edward, of Denver, husbandman 0
3971411 2014558 2014558 defendant Wolman John clerk 613727 613727 Wolman, John, of Denver, clerk 0
3971412 2014558 2014558 defendant Perken Robert sherman 613727 613727 Perken, Robert, of Denver, sherman 1
3971413 2014558 2014558 defendant Oder William sherman 613727 613727 Oder, William, of Denver, sherman 2
3972201 2014837 2014837 defendant Hyllary Robert gent 613727 613727 Hyllary, Robert, of Denver, gent 1
3982799 2018621 2018621 defendant Wolman John clerk 613727 613727 Wolman, John, of Denver, clerk 0
3983283 2018793 2018793 defendant Martyne Robert husbandman 613727 613727 Martyne, Robert, of Denver, husbandman 0
3999855 2024713 2024713 defendant Eldyng Robert clerk 613727 613727 Eldyng, Robert, of Denver, clerk 2
4027317 2034419 2034419 defendant Claye Thomas husbandman 613727 613727 Claye, Thomas, of Denver, husbandman 0
4027324 2034421 2034421 defendant Richardson Thomas carpenter 613727 613727 Richardson, Thomas, of Denver, carpenter 0
4030589 2035601 2035601 plaintiff Egelye or Eglye Robert tailor 613727 613727 Egelye or Eglye, Robert, of Denver, tailor 0
4030590 2035601 2035601 defendant Pamplyn William yeoman 613727 613727 Pamplyn, William, of Denver, or of Swaffham Pryor, Cams, yeoman 0
4030954 2035739 2035739 plaintiff Exelye Robert tailor 613727 613727 Exelye, Robert, of Denver, tailor 0
4030955 2035739 2035739 defendant Pamplyn William yeoman 613727 613727 Pamplyn, William, of Denver, or of Swaffham Prior, Cams, yeoman 0
4050344 2042555 2042555 plaintiff Wassen Winifred widow 613727 613727 Winifred his wife, alias Winifred Balham, of Denver, widow 1
4054968 2044171 2044171 defendant Cage Thomas husbandman 613727 613727 Cage, Thomas, of Denver, husbandman 0
4056642 2044765 2044765 plaintiff Broddie Henry yeoman 613727 613727 Broddie, Henry, of Denver, yeoman 0
4063309 2047169 2047169 defendant Marten Robert husbandman 613727 613727 Marten, Robert, of Denver, husbandman 0
4063310 2047169 2047169 defendant Methwoulde alias Cooke Richard husbandman 613727 613727 together with Methwoulde alias Cooke, Richard, of Denver, husbandman 1
4063311 2047169 2047169 defendant Denny John carpenter 613727 613727 Denny, John, of Denver, carpenter 2
4063313 2047170 2047170 defendant Marton Robert husbandman 613727 613727 Marton Robert, of Denver, husbandman 0
4063314 2047170 2047170 defendant Methwold alias Cooke Richard husbandman 613727 613727 together with Methwold alias Cooke, Richard, of Denver, husbandman 1
4063315 2047170 2047170 defendant Denney John carpenter 613727 613727 Denney, John, of Denver, carpenter 2
4074542 2051197 2051197 defendant Elden Robert clerk 613727 613727 Elden, Robert, of Denver, clerk 0
4144621 2076277 2076277 defendant Kysse John yeoman 613727 613727 Kysse, John, of Denver, yeoman 0
4193592 2093328 2093328 defendant Mathewe John yeoman 613727 613727 Mathewe, John, of Denver, yeoman 0
4195991 2094152 2094152 defendant Denny John   613727 613727 Denny, John, of Denver carpenter 0
4195992 2094152 2094152 defendant Kysse John husbandman 613727 613727 Kysse, John, of Denver, husbandman 1
4211331 2099516 2099516 defendant Cheyney Thomas yeoman 613727 613727 Cheyney, Thomas, of Denver, yeoman 2
4221444 2102992 2102992 defendant Taylor Peter blacksmith 613727 613727 Taylor, Peter, of Denver, blacksmith 0
4247280 2112067 2112067 defendant Taylor Peter blacksmith 613727 613727 Taylor, Peter, of Denver, blacksmith 0
4258476 2115802 2115802 defendant Gunson Robert husbandman 613727 613727 Gunson, Robert, of Denver, husbandman 0
4258477 2115802 2115802 defendant Bennett John husbandman 613727 613727 Bennett, John, of Denver, husbandman 1
4258478 2115802 2115802 defendant Chewky John husbandman 613727 613727 Chewky, John, of Denver, husbandman 2
4258479 2115802 2115802 defendant Hakynson James husbandman 613727 613727 Hakynson, James, of Denver, husbandman 3
4978737 2350590 2350590 defendant Wotton Thomas husbandman 613727 613727 Wotton, Thomas, of Denver, husbandman 4
4997954 2356248 2356248 defendant Alby William clerk 613727 613727 Alby, William, of Denver, clerk 0
5128450 2394795 2394795 defendant Wotton Thomas yeoman 613727 613727 Wotton, Thomas, of Denver, yeoman 5
5128451 2394795 2394795 defendant Bettys Lawrence husbandman 613727 613727 Bettys, Lawrence, of Denver, husbandman 6
5128452 2394795 2394795 defendant Spryngold Thomas yeoman 613727 613727 Spryngold, Thomas, of Denver, yeoman 7
5147547 2400423 2400423 defendant Wotton Thomas yeoman 613727 613727 Wotton, Thomas, of Denver, yeoman 5
5147548 2400423 2400423 defendant Bettys Lawrence husbandman 613727 613727 Bettys, Lawrence, of Denver, husbandman 6
5147549 2400423 2400423 defendant Spryngold Thomas yeoman 613727 613727 Spryngold, Thomas, of Denver, yeoman 7
5212224 2419315 2419315 defendant Payn William clerk 613727 613727 Payn, William, of Denver, clerk 0
5218031 2421009 2421009 defendant Buttyller John yeoman 613727 613727 Buttyller, John, of Denver, yeoman 1
5281748 2439735 2439735 defendant Farley William husbandman 613727 613727 Farley, William, of Denver, husbandman 0
5281749 2439735 2439735 defendant Saunder John husbandman 613727 613727 Saunder, John, of Denver, husbandman 1
5281750 2439735 2439735 defendant Cotyn Robert husbandman 613727 613727 Cotyn, Robert, of Denver, husbandman 2
5343622 2458187 2458187 defendant Wryght Henry husbandman 613727 613727 Wryght, Henry, of Denver, husbandman 5

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);