names

21 rows where place_id = 659179

✎ 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
3951406 2007554 2007554 defendant Edward Richard yeoman 659179 659179 Edward, Richard, of Llangome, yeoman 0
3951407 2007554 2007554 defendant Rosser Philip yeoman 659179 659179 Rosser, Philip, of Llangome, yeoman 1
3971592 2014625 2014625 defendant William Thomas yeoman 659179 659179 William, Thomas, of Llangome, or of Llanveyre Iskoyde, yeoman 0
3971593 2014625 2014625 defendant Williams Thomas yeoman 659179 659179 Williams, Thomas, of Llangome, yeoman 1
3974585 2015677 2015677 defendant Williams Walter gent 659179 659179 Williams, Walter, of Llangome, gent 0
3978873 2017195 2017195 defendant Harryes Edward yeoman 659179 659179 Harryes, Edward, of Llangome, yeoman 0
3980905 2017932 2017932 defendant ap William Jenkin John yeoman 659179 659179 ap William, Jenkin John, of Llangome, yeoman 0
3980906 2017932 2017932 defendant Gybbon John gent 659179 659179 Gybbon, John, of Llangome, gent 1
3981055 2017985 2017985 defendant Jones Richard clerk 659179 659179 Jones, Richard, of Llangome, clerk 0
3988397 2020595 2020595 defendant Thomas John Howell husbandman 659179 659179 Thomas, John Howell, of Llangome, husbandman 3
3988403 2020596 2020596 defendant Thomas William yeoman 659179 659179 (Thomas, William, of Llangome, yeoman 4
4040807 2039204 2039204 defendant Wylym Morgan William yeoman 659179 659179 Wylym, Morgan William, of Llangome, yeoman 0
4065132 2047815 2047815 defendant Thomas alias Cradock george yeoman 659179 659179 Thomas alias Cradock, george, of Llangome, yeoman 0
4065135 2047815 2047815 defendant ap Howell alias Gwythur Thomas husbandman 659179 659179 ap Howell alias Gwythur, Thomas, of Llangome, husbandman 3
4065141 2047816 2047816 plaintiff Harrys George yeoman 659179 659179 Harrys, George, of Llangome, yeoman 0
4074302 2051108 2051108 defendant Morgan Thomas yeoman 659179 659179 Morgan, Thomas, of Llangome, yeoman 2
4082833 2054163 2054163 defendant Morgan John yeoman 659179 659179 Morgan, John, of Llangome, yeoman 1
4097112 2059289 2059289 defendant Thomas George yeoman 659179 659179 Thomas, George, of Llangome, yeoman 2
4152140 2078859 2078859 defendant Philip John yeoman 659179 659179 Philip, John, of Llangome, yeoman 1
4157094 2080561 2080561 defendant Gybonne John gent 659179 659179 Gybonne, John, of Llangome, gent 0
4374789 2156038 2156038 defendant Thomas Eustace tailor 659179 659179 Thomas, Eustace, of Llangome, tailor 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);