names

29 rows where place_id = 660651

✎ 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
3957343 2009631 2009631 defendant Barber Thomas yeoman 660651 660651 Barber, Thomas, of Melverley, yeoman 0
3964027 2012028 2012028 defendant ap Gruffyth Thomas ap John yeoman 660651 660651 ap Gruffyth, Thomas ap John, of Melverley, yeoman 0
4077509 2052246 2052246 defendant Jones Hugh yeoman 660651 660651 Jones, Hugh, of Melverley, yeoman 1
4077510 2052246 2052246 defendant vergh Meredyth Jane widow 660651 660651 vergh Meredyth, Jane, of Melverley, widow 2
4112725 2064812 2064812 defendant Jones Hugh yeoman 660651 660651 Jones, Hugh, of Melverley, yeoman 1
4112726 2064812 2064812 defendant verch Meredyth Jane widow 660651 660651 verch Meredyth, Jane, of Melverley ,widow 2
4142568 2075568 2075568 defendant ap Thomas Roger ap Jevan yeoman 660651 660651 ap Thomas, Roger ap Jevan, of Melverley, yeoman 0
4143131 2075768 2075768 defendant Jones Hugh gent 660651 660651 Jones, Hugh, of Melverley, gent 1
4178591 2087991 2087991 defendant Thornes Roger gent 660651 660651 Thornes, Roger, of Melverley, gent 0
4178592 2087991 2087991 defendant Hilton Richard husbandman 660651 660651 Hilton, Richard, of Melverley, husbandman 1
4178593 2087991 2087991 defendant Swanwicke George husbandman 660651 660651 Swanwicke, George, of Melverley, husbandman 2
4178594 2087991 2087991 defendant Lloid Edward gent 660651 660651 Lloid, Edward, of Melverley, gent 3
4191664 2092640 2092640 defendant ap Mathewe Thomas yeoman 660651 660651 ap Mathewe, Thomas, of Melverley, yeoman 0
4191665 2092640 2092640 defendant ap Gryffyth William ap David yeoman 660651 660651 ap Gryffyth, William ap David, of Melverley, yeoman 1
4221459 2102997 2102997 defendant ap Jevan Roger yeoman 660651 660651 ap Jevan, Roger, of Melverley, yeoman 1
4223741 2103788 2103788 defendant verch Griffith Alice widow 660651 660651 verch Griffith, Alice, of Melverley, widow 1
4235471 2107974 2107974 defendant ap Jevan Roger yeoman 660651 660651 ap Jevan, Roger, of Melverley, yeoman 0
4249120 2112689 2112689 defendant ap Humfrey Edward yeoman 660651 660651 ap Humfrey, Edward, of Melverley, yeoman 2
4263624 2117497 2117497 defendant ap Humfrey Edward yeoman 660651 660651 ap Humfrey, Edward, of Melverley, yeoman 2
4309599 2133517 2133517 defendant ap Jevan David yeoman 660651 660651 ap Jevan, David, of Melverley, yeoman 0
4309600 2133517 2133517 defendant ap Jevan Hugh yeoman 660651 660651 ap Jevan, Hugh, of Melverley, yeoman 1
4318863 2136711 2136711 defendant ap Jevan Roger yeoman 660651 660651 ap Jevan, Roger, of Melverley, yeoman 2
4318864 2136711 2136711 defendant ap Griffeth William ap David yeoman 660651 660651 ap Griffeth, William ap David, of Melverley, yeoman 3
4350872 2147558 2147558 defendant ap Thomas John yeoman 660651 660651 ap Thomas, John, of Melverley, yeoman 4
4359195 2150447 2150447 defendant Jones Hugh gent 660651 660651 Jones, Hugh, of Melverley, gent 0
4359196 2150447 2150447 defendant ap Howell David ap Jevan husbandman 660651 660651 ap Howell, David ap Jevan, of Melverley, husbandman 1
4370832 2154622 2154622 defendant Thornes Edward gent 660651 660651 Thornes, Edward, of Melverley, gent 0
4370833 2154622 2154622 defendant ap Owen Edward miller 660651 660651 ap Owen, Edward, of Melverley, miller 1
4372507 2155236 2155236 defendant Baker Anne widow 660651 660651 Baker, Anne, of Melverley, 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);