names

32 rows where place_id = 663339

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3968471 2013605 2013605 defendant Wynson John gent 663339 663339 Wynson, John, of Comyoye, gent 1
4000771 2025043 2025043 defendant Gylbert Howell Thomas Powell yeoman 663339 663339 Gylbert, Howell Thomas Powell, of Comyoye, yeoman 0
4000772 2025043 2025043 defendant Bean John William or Wellym yeoman 663339 663339 Bean, John William or Wellym, of Comyoye, yeoman 1
4000774 2025044 2025044 defendant Gylbert Howell Thomas Powell yeoman 663339 663339 Gylbert, Howell Thomas Powell, of Comyoye, yeoman 0
4000775 2025044 2025044 defendant Bean John William yeoman 663339 663339 Bean, John William, of Comyoye, yeoman 1
4038049 2038251 2038251 defendant Gylbert Howell Thomas Powell yeoman 663339 663339 Gylbert, Howell Thomas Powell, of Comyoye, yeoman 7
4042480 2039783 2039783 defendant ap Ryce Thomas yeoman 663339 663339 ap Ryce, Thomas, of Comyoye, yeoman 3
4042493 2039784 2039784 defendant ap Ryce Thomas yeoman 663339 663339 ap Ryce, Thomas, of Comyoye, yeoman 3
4050420 2042580 2042580 defendant John Henry Thomas Philip yeoman 663339 663339 John, Henry Thomas Philip, of Comyoye, yeoman 0
4050421 2042580 2042580 defendant Gylbart Philip Harry John yeoman 663339 663339 Gylbart, Philip Harry John, of Comyoye, yeoman 1
4050422 2042580 2042580 defendant Wyllyn Margaret widow 663339 663339 Wyllyn, Margaret, of Comyoye, widow 2
4050423 2042580 2042580 defendant ap Rees Edward yeoman 663339 663339 ap Rees, Edward, of Comyoye, yeoman 3
4099363 2060097 2060097 defendant Lewys Thomas Harry husbandman 663339 663339 Lewys, Thomas Harry, of Comyoye, husbandman 1
4107408 2062937 2062937 defendant Powell Howell Gillam yeoman 663339 663339 Powell, Howell Gillam, of Comyoye, yeoman 0
4138956 2074302 2074302 defendant Watkyns Lewis yeoman 663339 663339 Watkyns, Lewis, of Comyoye, yeoman 0
4163626 2082799 2082799 defendant James John yeoman 663339 663339 James, John, of Comyoye, yeoman 0
4163628 2082799 2082799 defendant James Richard William yeoman 663339 663339 James, Richard William, of Comyoye, yeoman 2
4165107 2083302 2083302 defendant Nycholl Philip yeoman 663339 663339 Nycholl, Philip, of Comyoye, yeoman 2
4167410 2084101 2084101 defendant James George William yeoman 663339 663339 James, George William, of Comyoye, yeoman 1
4167413 2084102 2084102 defendant James George William yeoman 663339 663339 James, George William, of Comyoye, yeoman 1
4167414 2084102 2084102 defendant James Watkin William yeoman 663339 663339 James, Watkin William, of Comyoye, yeoman 2
4173033 2086023 2086023 defendant Wyllim Thomas David husbandman 663339 663339 Wyllim, Thomas David, of Comyoye, husbandman 0
4173687 2086251 2086251 defendant Powell John ap Robert Gillam yeoman 663339 663339 Powell, John ap Robert Gillam, of Comyoye, yeoman 0
4173690 2086252 2086252 defendant Powell John ap Robert Gilliam yeoman 663339 663339 Powell, John ap Robert Gilliam, of Comyoye, yeoman 0
4274274 2120948 2120948 defendant Watkyn Robert gent 663339 663339 Watkyn, Robert, of Comyoye, gent 0
4280860 2123209 2123209 defendant ap Rees John yeoman 663339 663339 ap Rees, John, of Comyoye, yeoman 0
4280867 2123211 2123211 defendant Richard William John yeoman 663339 663339 Richard, William John, of Comyoye, yeoman 0
4358581 2150240 2150240 defendant Richard William John yeoman 663339 663339 Richard, William John, of Comyoye, yeoman 1
4358584 2150241 2150241 defendant Richard William John yeoman 663339 663339 Richard, William John, of Comyoye, yeoman 1
4358616 2150252 2150252 defendant William Roger Harry yeoman 663339 663339 William, Roger Harry, of Comyoye, yeoman 1
4380591 2158167 2158167 defendant David David Prosser husbandman 663339 663339 David, David Prosser, of Comyoye, husbandman 0
4398023 2163917 2163917 defendant Lloyd John Rees ap John yeoman 663339 663339 Lloyd, John Rees ap John, of Comyoye, 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);