names

38 rows where place_id = 649455

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3906771 1992556 1992556 defendant ap Hoell Philip David yeoman 649455 649455 ap Hoell, Philip David, of Llanarth, yeoman 4
3952846 2008071 2008071 defendant James David John yeoman 649455 649455 James, David John, of Llanarth, yeoman 1
3957589 2009713 2009713 defendant David George husbandman 649455 649455 David, George, of Llanarth, husbandman 1
4053659 2043683 2043683 defendant David John Moris ap Jevan yeoman 649455 649455 David, John Moris ap Jevan, of Llanarth, yeoman 0
4053663 2043684 2043684 defendant William Robert John gent 649455 649455 William, Robert John, of Llanarth, gent 2
4053677 2043690 2043690 defendant William Philip Thomas yeoman 649455 649455 William, Philip Thomas, of Llanarth, yeoman 0
4067602 2048730 2048730 defendant ap Jevan Morgan Thomas smith 649455 649455 ap Jevan, Morgan Thomas, of Llanarth, smith 1
4069396 2049337 2049337 defendant ap Jenkin Howell John yeoman 649455 649455 ap Jenkin, Howell John, of Llanarth, yeoman 0
4075514 2051544 2051544 defendant Powell Philip gent 649455 649455 Powell, Philip, of Llanarth, gent 2
4078784 2052707 2052707 defendant Pryce John David husbandman 649455 649455 Pryce, John David, of Llanarth, husbandman 0
4078785 2052707 2052707 defendant John William yeoman 649455 649455 John, William, of Llanarth, yeoman 1
4078786 2052707 2052707 defendant verch John Alice spinster 649455 649455 verch John, Alice, of Llanarth, spinster 2
4080014 2053155 2053155 defendant Rosser Thomas William gent 649455 649455 Rosser, Thomas William, of Llanarth, gent 1
4082906 2054186 2054186 defendant Lluwellen John Thomas husbandman 649455 649455 Lluwellen, John Thomas, of Llanarth, husbandman 1
4082907 2054186 2054186 defendant Thomas Philip David husbandman 649455 649455 Thomas, Philip David, of Llanarth, husbandman 2
4110118 2063880 2063880 defendant David Philip Powell yeoman 649455 649455 David, Philip Powell, of Llanarth, yeoman 1
4116153 2066070 2066070 defendant ap Jenkyn Howell John yeoman 649455 649455 ap Jenkyn, Howell John, of Llanarth, yeoman 0
4116154 2066070 2066070 defendant Howell Philip yeoman 649455 649455 Howell, Philip, of Llanarth, yeoman 1
4116155 2066070 2066070 defendant ap Jenkyn Philip John yeoman 649455 649455 ap Jenkyn, Philip John, of Llanarth, yeoman 2
4116156 2066070 2066070 defendant Wyllym Howell John yeoman 649455 649455 Wyllym, Howell John, of Llanarth, yeoman 3
4119528 2067273 2067273 defendant Philip John yeoman 649455 649455 Philip, John, of Llanarth, yeoman 2
4153916 2079465 2079465 defendant James Anne David widow 649455 649455 James, Anne David, of Llanarth, widow 0
4190913 2092385 2092385 defendant Philip John yeoman 649455 649455 Philip, John, of Llanarth, yeoman 2
4190915 2092386 2092386 defendant Llewelyn John Thomas weaver 649455 649455 Llewelyn, John Thomas, of Llanarth, weaver 0
4190916 2092386 2092386 defendant ap John James husbandman 649455 649455 ap John, James, of Llanarth, husbandman 1
4204553 2097140 2097140 defendant Hopkyn John yeoman 649455 649455 Hopkyn, John, of Llanarth, yeoman 0
4208214 2098424 2098424 defendant Morgan Nicholas clerk 649455 649455 Morgan, Nicholas, of Llanarth, clerk 0
4213009 2100074 2100074 defendant David John William yeoman 649455 649455 David, John William, of Llanarth, yeoman 0
4213011 2100075 2100075 defendant Llewelyn John Thomas weaver 649455 649455 Llewelyn, John Thomas, of Llanarth, weaver 0
4219546 2102338 2102338 defendant Edward William gent 649455 649455 Edward, William, of Llanarth, gent 0
4220180 2102562 2102562 defendant Jenkin David Philip yeoman 649455 649455 Jenkin, David Philip, of Llanarth, yeoman 1
4222815 2103471 2103471 defendant Edmonde Maud widow 649455 649455 Edmonde, Maud, of Llanarth, widow 0
4276408 2121692 2121692 defendant ap John Philip   649455 649455 ap John, Philip, of Llanarth, mason 0
4278959 2122574 2122574 defendant John Philip yeoman 649455 649455 John, Philip, of Llanarth, yeoman 1
4280776 2123181 2123181 defendant Watkyn Howell Robert yeoman 649455 649455 Watkyn, Howell Robert, of Llanarth, yeoman 2
4335422 2142117 2142117 defendant Morgan Jane yeoman 649455 649455 Morgan, Jane, of Llanarth, yeoman 1
4375076 2156147 2156147 defendant ap John Thomas yeoman 649455 649455 ap John, Thomas, of Llanarth, yeoman 0
4375077 2156147 2156147 defendant David John William yeoman 649455 649455 David, John William, of Llanarth, 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);