names

38 rows where place_id = 636249

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3829786 1967209 1967209 defendant ap Thomas John husbandman 636249 636249 ap Thomas, John, of Bredwardyn, husbandman 0
3872346 1980974 1980974 defendant Molde John clerk 636249 636249 Molde, John, of Bredwardyn, clerk 1
3932795 2001272 2001272 defendant ap Richard Arnold husbandman 636249 636249 ap Richard, Arnold, of Bredwardyn, husbandman 2
3955321 2008931 2008931 defendant ap Thomas John yeoman 636249 636249 ap Thomas, John, of Bredwardyn, yeoman 0
3967135 2013132 2013132 defendant Thomas John husbandman 636249 636249 Thomas, John, of Bredwardyn, husbandman 0
3967136 2013132 2013132 defendant Thomas alias Veyne Joan widow 636249 636249 Thomas alias Veyne, Joan, of Bredwardyn, widow 1
3967138 2013133 2013133 defendant ap John Philip husbandman 636249 636249 ap John, Philip, of Bredwardyn, husbandman 0
3967139 2013133 2013133 defendant Adams James husbandman 636249 636249 Adams, James, of Bredwardyn, husbandman 1
3968979 2013766 2013766 defendant Phelpott Thomas yeoman 636249 636249 Phelpott, Thomas, of Bredwardyn, yeoman 1
3975163 2015878 2015878 defendant Wallewyn William gent 636249 636249 Wallewyn, William, of Bredwardyn, gent 0
3975164 2015878 2015878 defendant Wallewyn George gent 636249 636249 Wallewyn, George, of Bredwardyn, gent 1
3975684 2016054 2016054 defendant Turnor Henry husbandman 636249 636249 Turnor, Henry, of Bredwardyn, husbandman 0
3982109 2018359 2018359 defendant Vaughan Walter esq 636249 636249 Vaughan, Walter, of Bredwardyn, esq 1
3984956 2019377 2019377 defendant Walwyn Margaret widow 636249 636249 Walwyn, Margaret, of Bredwardyn, widow 1
3984957 2019377 2019377 defendant Adams James yeoman 636249 636249 Adams, James, of Bredwardyn, yeoman 2
3984958 2019377 2019377 defendant Thatcher alias Richard Roger husbandman 636249 636249 Thatcher alias Richard, Roger, of Bredwardyn, husbandman 3
3984959 2019377 2019377 defendant Thomas John yeoman 636249 636249 Thomas, John, of Bredwardyn, yeoman 4
3986286 2019842 2019842 defendant Beny George husbandman 636249 636249 Beny, George, of Bredwardyn, husbandman 3
3987810 2020385 2020385 defendant Adams Margery widow 636249 636249 Adams, Margery, of Bredwardyn, widow 0
3989212 2020881 2020881 defendant Lewys David husbandman or yeoman 636249 636249 Lewys, David, of Bredwardyn, husbandman or yeoman 1
3989215 2020882 2020882 defendant Lewys David yeoman 636249 636249 Lewys, David, of Bredwardyn, yeoman 1
4001102 2025173 2025173 defendant Harryes William John husbandman 636249 636249 Harryes, William John, of Bredwardyn, husbandman 0
4023222 2033015 2033015 defendant ap John Jevan yeoman 636249 636249 ap John, Jevan, of Bredwardyn, yeoman 0
4054194 2043887 2043887 plaintiff Baker John   636249 636249 Baker, John, of Bredwardyn 0
4054196 2043887 2043887 defendant ap Prychard Thomas husbandman 636249 636249 ap Prychard, Thomas, of Bredwardyn, husbandman 1
4061290 2046442 2046442 defendant Adams Thomas husbandman 636249 636249 Adams, Thomas, of Bredwardyn, husbandman 5
4088309 2056112 2056112 defendant Vaughan Watkin esq 636249 636249 Vaughan, Watkin, of Bredwardyn, esq 0
4111041 2064198 2064198 defendant Chabnor Henry yeoman 636249 636249 Chabnor, Henry, of Bredwardyn, yeoman 0
4111042 2064198 2064198 defendant Apprichard Arnold yeoman 636249 636249 Apprichard, Arnold, of Bredwardyn, yeoman 1
4111044 2064199 2064199 defendant Watkyn Philip weaver 636249 636249 Watkyn, Philip, of Bredwardyn, weaver 0
4134504 2072670 2072670 defendant Harries William John husbandman 636249 636249 Harries, William John, of Bredwardyn, husbandman 3
4158496 2081042 2081042 defendant Harries William John husbandman 636249 636249 Harries, William John, of Bredwardyn, husbandman 3
4314222 2135082 2135082 defendant ap Richard Thomas carpenter 636249 636249 ap Richard, Thomas, of Bredwardyn, carpenter 0
4317936 2136384 2136384 defendant Prichard or ap Richard Thomas yeoman 636249 636249 Prichard or ap Richard, Thomas, of Bredwardyn, yeoman 1
4319030 2136772 2136772 defendant ap Adam Thomas John husbandman 636249 636249 ap Adam, Thomas John, of Bredwardyn, husbandman 0
5251043 2430432 2430432 defendant Smyth Thomas yeoman 636249 636249 Smyth, Thomas, of Bredwardyn, yeoman 2
5251044 2430432 2430432 defendant ap Lluwellan Walter yeoman 636249 636249 ap Lluwellan, Walter, of Bredwardyn, yeoman 3
5635874 2555180 2555180 defendant Wardeyn William yeoman 636249 636249 Wardeyn, William, of Bredwardyn, yeoman 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);