names

77 rows where place_id = 594791

✎ 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
3617623 1873133 1873133 defendant Peyn John merchant 594791 594791 Peyn, John, of Barkeley, merchant 1
3634350 1905540 1905540 defendant Sutton William tucker 594791 594791 Sutton, William, of Barkeley, tucker 1
3651353 1910788 1910788 defendant Spynner John husbandman 594791 594791 Spynner, John, of Barkeley, husbandman 0
3658900 1913043 1913043 plaintiff Freme William gent 594791 594791 Freme, William, of Barkeley, gent 0
3658902 1913044 1913044 plaintiff Freme William gent 594791 594791 Freme, William, of Barkeley, gent 0
3668389 1916061 1916061 defendant Smyth John butcher 594791 594791 Smyth, John, of Barkeley, butcher 0
3674947 1918193 1918193 defendant Folet John husbandman 594791 594791 Folet, John, of Barkeley, husbandman 4
3690315 1923132 1923132 defendant Solett John husbandman 594791 594791 Solett, John, of Barkeley, husbandman 4
3691373 1923461 1923461 defendant Warter William dyer 594791 594791 Warter, William, of Barkeley, dyer 1
3694114 1924363 1924363 defendant Thorpe Thomas gent 594791 594791 Thorpe, Thomas, of Barkeley, gent 0
3697376 1925398 1925398 defendant Dorney William mercer 594791 594791 Dorney, William, of Barkeley, mercer 1
3705218 1927916 1927916 defendant Folett John husbandman 594791 594791 Folett, John, of Barkeley, husbandman 4
3722562 1933317 1933317 defendant Sutton William husbandman 594791 594791 Sutton, William, of Barkeley, husbandman 0
3726338 1934507 1934507 defendant grenowe Richard weaver 594791 594791 grenowe, Richard, of Barkeley, weaver 1
3726339 1934507 1934507 defendant Dorney William weaver 594791 594791 Dorney, William, of Barkeley, weaver 2
3768859 1947908 1947908 defendant Walkeley Thomas yeoman 594791 594791 Walkeley, Thomas, of Barkeley, yeoman 0
3821465 1964607 1964607 defendant Hall Thomas mariner 594791 594791 Hall, Thomas, of Barkeley, mariner 0
3868386 1979665 1979665 defendant Atkyns Ralph husbandman 594791 594791 Atkyns, Ralph, of Barkeley, husbandman 1
3874891 1981824 1981824 defendant Deryatt Edward husbandman 594791 594791 Deryatt, Edward, of Barkeley, husbandman 0
3875661 1982105 1982105 plaintiff Freme William (legal representative) 594791 594791 Freme, William, of Barkeley, gent, executors of 0
3876554 1982405 1982405 defendant Burwell Robert weaver 594791 594791 Burwell, Robert, of Barkeley, weaver 0
3884179 1984974 1984974 defendant Gryffyn Richard husbandman 594791 594791 Gryffyn, Richard, of Barkeley, husbandman 0
3896189 1988929 1988929 defendant Thowght James husbandman 594791 594791 (Thowght, James, of Barkeley, husbandman 1
3896190 1988929 1988929 defendant Everod John husbandman 594791 594791 Everod, John, of Barkeley, husbandman 2
3917836 1996325 1996325 defendant Harmar Thomas yeoman 594791 594791 Harmar, Thomas, of Barkeley, yeoman 3
3945659 2005557 2005557 defendant Bocher Richard gent 594791 594791 Bocher, Richard, of Barkeley, gent 0
3948999 2006715 2006715 defendant Gamon John vintner 594791 594791 Gamon, John, of Barkeley, vintner 1
3985012 2019397 2019397 defendant Teysand Thomas butcher 594791 594791 Teysand, Thomas, of Barkeley, butcher 0
3991047 2021559 2021559 defendant Overleghe William yeoman 594791 594791 Overleghe, William, of Barkeley, yeoman 0
3992667 2022126 2022126 defendant Smyth Thomas husbandman 594791 594791 Smyth, Thomas, of Barkeley, husbandman 1
3992668 2022126 2022126 defendant Mallett Maurice husbandman 594791 594791 Mallett, Maurice, of Barkeley, husbandman 2
4001227 2025218 2025218 defendant Machyn William yeoman 594791 594791 Machyn, William, of Barkeley, yeoman 0
4004989 2026566 2026566 defendant Gylman James husbandman 594791 594791 Gylman, James, of Barkeley, husbandman 0
4022707 2032843 2032843 defendant Maye Robert weaver 594791 594791 Maye, Robert, of Barkeley, weaver 0
4030307 2035493 2035493 defendant Cole Maurice husbandman 594791 594791 Cole, Maurice, of Barkeley, husbandman 0
4030309 2035494 2035494 defendant Cole Maurice husbandman 594791 594791 Cole, Maurice, of Barkeley, husbandman 0
4047663 2041611 2041611 defendant Machyn William yeoman 594791 594791 Machyn, William, of Barkeley, yeoman 0
4047665 2041612 2041612 defendant Machyn William yeoman 594791 594791 Machyn, William, of Barkeley, yeoman 0
4055005 2044185 2044185 defendant Bankenett Anthony smith 594791 594791 Bankenett, Anthony, of Barkeley, smith 1
4076443 2051870 2051870 defendant Connocke John husbandman 594791 594791 Connocke, John, of Barkeley, husbandman 0
4076444 2051870 2051870 defendant Gamon John tanner 594791 594791 Gamon, John, of Barkeley, tanner 1
4082517 2054053 2054053 defendant Allen Christopher yeoman 594791 594791 Allen, Christopher, of Barkeley, yeoman 0
4092712 2057704 2057704 defendant Cole Thomas clothier 594791 594791 Cole, Thomas, of Barkeley, clothier 0
4092713 2057704 2057704 defendant Belcher John   594791 594791 Belcher, John, of Barkeley, mason 1
4092714 2057704 2057704 defendant Hill Richard   594791 594791 Hill, Richard, of Barkeley, mason 2
4111878 2064498 2064498 defendant Hall Edward yeoman 594791 594791 Hall, Edward, of Barkeley, yeoman 0
4111880 2064499 2064499 defendant Hall Edward yeoman 594791 594791 Hall, Edward, of Barkeley, yeoman 0
4128579 2070512 2070512 defendant Newboroughe George gent 594791 594791 Newboroughe, George, of Barkeley, gent 0
4157578 2080724 2080724 defendant Kent Thomas yeoman 594791 594791 Kent, Thomas, of Barkeley, yeoman 0
4157579 2080724 2080724 defendant Bradribbe David laborer 594791 594791 Bradribbe, David, of Barkeley, laborer 1
4157580 2080724 2080724 defendant Gybbons Thomas laborer 594791 594791 Gybbons, Thomas, of Barkeley, laborer 2
4157582 2080725 2080725 defendant Kent Thomas yeoman 594791 594791 Kent, Thomas, of Barkeley, yeoman 0
4157583 2080725 2080725 defendant Dewe William laborer 594791 594791 Dewe, William, of Barkeley, laborer 1
4157584 2080725 2080725 defendant Gybbons Thomas laborer 594791 594791 Gybbons, Thomas, of Barkeley, laborer 2
4164404 2083068 2083068 defendant Swanlinger or Seneger John yeoman 594791 594791 Swanlinger or Seneger, John, of Barkeley, yeoman 0
4168638 2084517 2084517 defendant Kente Thomas yeoman 594791 594791 Kente, Thomas, of Barkeley, yeoman 0
4235730 2108066 2108066 defendant Wilcocke Stephen gent 594791 594791 Wilcocke, Stephen, of Barkeley, gent 0
4240742 2109884 2109884 defendant Nelme or Neline Thomas yeoman 594791 594791 Nelme or Neline, Thomas, of Barkeley, yeoman 0
4240743 2109884 2109884 defendant Kynge William husbandman 594791 594791 Kynge, William, of Barkeley, husbandman 1
4243397 2110783 2110783 defendant Howell James mercer 594791 594791 Howell, James, of Barkeley, mercer 0
4297423 2129183 2129183 defendant Curnocke Thomas yeoman 594791 594791 Curnocke, Thomas, of Barkeley, yeoman 0
4306542 2132426 2132426 defendant Kidwallider Henry yeoman 594791 594791 Kidwallider, Henry, of Barkeley, yeoman 2
4316292 2135813 2135813 defendant Frior John yeoman 594791 594791 Frior, John, of Barkeley, yeoman 0
4319661 2136990 2136990 defendant Badmynton Thomas shoemaker 594791 594791 Badmynton, Thomas, of Barkeley, shoemaker 0
4319662 2136990 2136990 defendant Frier John shoemaker 594791 594791 Frier, John, of Barkeley, shoemaker 1
4391786 2161873 2161873 defendant Poole John, senior gent 594791 594791 Poole, John, senior, of Barkeley, gent 0
4931758 2336320 2336320 defendant Browederer Richard yeoman 594791 594791 Browederer, Richard, of Barkeley, yeoman 2
4940537 2339066 2339066 defendant Russell Thomas yeoman 594791 594791 Russell, Thomas, of Barkeley, yeoman 0
4949239 2341748 2341748 defendant Godfraye John   594791 594791 Godfraye, John, of Barkeley, holy water clerk 2
4952674 2342756 2342756 defendant Bonde William laborer 594791 594791 Bonde, William, of Barkeley, laborer 0
4952675 2342756 2342756 defendant Haywode William laborer 594791 594791 Haywode, William, of Barkeley, laborer 1
5033738 2366746 2366746 defendant Barkeley James   594791 594791 Barkeley, James, of Barkeley, knight 0
5590098 2531885 2531885 defendant Poohon or Pochon Thomas gent 594791 594791 Poohon or Pochon, Thomas, of Barkeley, gent 0
5595036 2533417 2533417 defendant Teysant Richard butcher 594791 594791 Teysant, Richard, of Barkeley, butcher 0
5595037 2533417 2533417 defendant Teysant John butcher 594791 594791 Teysant, John, of Barkeley, butcher 1
5595038 2533417 2533417 defendant Sonhenger Thomas mariner 594791 594791 Sonhenger, Thomas, of Barkeley, mariner 2
5601398 2535327 2535327 defendant Philippes Eleanor widow 594791 594791 Philippes, Eleanor, of Barkeley, widow 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);