names

49 rows where place_id = 660739

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3957670 2009743 2009743 defendant Watkyn John yeoman 660739 660739 Watkyn, John, of Trevethyn, yeoman 0
3957671 2009743 2009743 defendant ap John Lewis yeoman 660739 660739 ap John, Lewis, of Trevethyn, yeoman 1
3961328 2011058 2011058 plaintiff Treharen Edward John husbandman 660739 660739 Treharen, Edward John, of Trevethyn, husbandman 0
3977168 2016584 2016584 plaintiff Lawrens John ap Rosser husbandman 660739 660739 Lawrens, John ap Rosser, of Trevethyn, husbandman 0
3977169 2016584 2016584 defendant Treheron Edward yeoman 660739 660739 Treheron, Edward, of Trevethyn, yeoman 0
3977170 2016584 2016584 defendant Treheron Roger yeoman 660739 660739 Treheron, Roger, of Trevethyn, yeoman 1
3977171 2016584 2016584 defendant Treheron Edward john yeoman 660739 660739 Treheron, Edward john, of Trevethyn, yeoman 2
4037099 2037932 2037932 defendant Yghan John David Powell yeoman 660739 660739 Yghan, John David Powell, of Trevethyn, yeoman 0
4069404 2049340 2049340 defendant Myryck David Jenkin David husbandman 660739 660739 Myryck, David Jenkin David, of Trevethyn, husbandman 0
4069405 2049340 2049340 defendant David William Roger yeoman 660739 660739 David, William Roger, of Trevethyn, yeoman 1
4069406 2049340 2049340 defendant Thomas William husbandman 660739 660739 Thomas, William, of Trevethyn, husbandman 2
4069407 2049340 2049340 defendant Thomas Richard husbandman 660739 660739 Thomas, Richard, of Trevethyn, husbandman 3
4083185 2054273 2054273 defendant ap Morgan Morgan John husbandman 660739 660739 ap Morgan, Morgan John, of Trevethyn, husbandman 0
4083186 2054273 2054273 defendant ap Gwyllym William Edward gent 660739 660739 ap Gwyllym, William Edward, of Trevethyn, gent 1
4097125 2059294 2059294 defendant Thomas Lluwellen yeoman 660739 660739 Thomas, Lluwellen, of Trevethyn, yeoman 2
4118553 2066930 2066930 defendant ap David David husbandman 660739 660739 ap David, David, of Trevethyn, husbandman 0
4118555 2066930 2066930 defendant verch Philip Jenetta widow 660739 660739 verch Philip, Jenetta, of Trevethyn, widow 2
4128469 2070472 2070472 defendant Edmond Roger Philip yeoman 660739 660739 Edmond, Roger Philip, of Trevethyn, yeoman 2
4142665 2075602 2075602 defendant Auston Richard yeoman 660739 660739 Auston, Richard, of Trevethyn, yeoman 0
4142666 2075602 2075602 defendant Rychard John yeoman 660739 660739 Rychard, John, of Trevethyn, yeoman 1
4151828 2078752 2078752 defendant Treharn Edward John yeoman 660739 660739 Treharn, Edward John, of Trevethyn, yeoman 0
4157411 2080663 2080663 defendant Robert William husbandman 660739 660739 Robert, William, of Trevethyn, husbandman 0
4163444 2082739 2082739 defendant Howell John William yeoman 660739 660739 Howell, John William, of Trevethyn, yeoman 0
4163445 2082739 2082739 defendant William Rice yeoman 660739 660739 William, Rice, of Trevethyn, yeoman 1
4163446 2082739 2082739 defendant Jenkyn Lewis David yeoman 660739 660739 Jenkyn, Lewis David, of Trevethyn, yeoman 2
4163447 2082739 2082739 defendant Edward Anthony yeoman 660739 660739 Edward, Anthony, of Trevethyn, yeoman 3
4167521 2084134 2084134 defendant Edward Edward William gent 660739 660739 (Edward, Edward William, of Trevethyn, gent 2
4186038 2090606 2090606 defendant Adam William Watkyn husbandman 660739 660739 Adam, William Watkyn, of Trevethyn, husbandman 0
4189414 2091797 2091797 defendant Jenkyn James gent 660739 660739 Jenkyn, James, of Trevethyn, gent 0
4201693 2096137 2096137 defendant Watkyn David John yeoman 660739 660739 Watkyn, David John, of Trevethyn, yeoman 0
4201942 2096224 2096224 defendant David William Rosser yeoman 660739 660739 David, William Rosser, of Trevethyn, yeoman 0
4201943 2096224 2096224 defendant John Maredith laborer 660739 660739 John, Maredith, of Trevethyn, laborer 1
4211170 2099463 2099463 defendant Watkyn David John husbandman 660739 660739 Watkyn, David John, of Trevethyn, husbandman 0
4211171 2099463 2099463 defendant David Watkin laborer 660739 660739 David, Watkin, of Trevethyn, laborer 1
4211172 2099463 2099463 defendant ap John Thomas laborer 660739 660739 ap John, Thomas, of Trevethyn, laborer 2
4218468 2101958 2101958 defendant David John Philip yeoman 660739 660739 David, John Philip, of Trevethyn, yeoman 0
4218469 2101958 2101958 defendant Watkyn Jenkin Richard yeoman 660739 660739 Watkyn, Jenkin Richard, of Trevethyn, yeoman 1
4218471 2101958 2101958 defendant Jevan Philip jenkin yeoman 660739 660739 Jevan, Philip jenkin, of Trevethyn, yeoman 3
4358604 2150249 2150249 defendant ap Owen Thomas yeoman 660739 660739 ap Owen, Thomas, of Trevethyn, yeoman 2
4358605 2150249 2150249 defendant ap Owen Willam Prees yoeman 660739 660739 ap Owen, Willam Prees, of Trevethyn, yoeman 3
4358657 2150265 2150265 defendant Edward Thomas William yeoman 660739 660739 Edward, Thomas William, of Trevethyn, yeoman 2
4360759 2151020 2151020 defendant ap Jevan William Edward yeoman 660739 660739 ap Jevan, William Edward, of Trevethyn, yeoman 1
4376021 2156489 2156489 defendant Griffith Rice yeoman 660739 660739 Griffith, Rice, of Trevethyn, yeoman 0
4376022 2156489 2156489 defendant Rosser Morgan yeoman 660739 660739 Rosser, Morgan, of Trevethyn, yeoman 1
4376023 2156489 2156489 defendant Monmoth William smith 660739 660739 Monmoth, William, of Trevethyn, smith 2
4376024 2156489 2156489 defendant Prichard Watkin David yeoman 660739 660739 Prichard, Watkin David, of Trevethyn, yeoman 3
4378219 2157278 2157278 defendant David Roger John yeoman 660739 660739 David, Roger John, of Trevethyn, yeoman 0
4379224 2157650 2157650 defendant Rosser Rethergh yeoman 660739 660739 Rosser, Rethergh, of Trevethyn, yeoman 2
4380612 2158174 2158174 defendant ap John George yeoman 660739 660739 ap John, George, of Trevethyn, yeoman 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);