names

26 rows where place_id = 646695

✎ 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
3892412 1987713 1987713 defendant ap Howell Thomas Lluwellan yeoman 646695 646695 ap Howell, Thomas Lluwellan, of Llangeby, yeoman 4
3955976 2009161 2009161 defendant Thomas Howel yeoman 646695 646695 Thomas, Howel, of Llangeby, yeoman 0
3955977 2009161 2009161 defendant Thomas Edward yeoman 646695 646695 Thomas, Edward, of Llangeby, yeoman 1
3978928 2017216 2017216 defendant Thomas alias Bontt Edward husbandman 646695 646695 Thomas alias Bontt, Edward, of Llangeby, husbandman 0
3978929 2017216 2017216 defendant Edward Tricheron husbandman 646695 646695 Edward, Tricheron, of Llangeby, husbandman 1
3978930 2017216 2017216 defendant Lawrens Howell husbandman 646695 646695 Lawrens, Howell, of Llangeby, husbandman 2
4008706 2027877 2027877 defendant ap John Richard yeoman 646695 646695 ap John, Richard, of Llangeby, yeoman 0
4021119 2032275 2032275 defendant ap John Richard yeoman 646695 646695 ap John, Richard, of Llangeby, yeoman 0
4021144 2032281 2032281 defendant ap John Richard yeoman 646695 646695 ap John, Richard, of Llangeby, yeoman 0
4071223 2050012 2050012 defendant Harry John yeoman 646695 646695 Harry, John, of Llangeby, yeoman 0
4107425 2062943 2062943 defendant Jones Charles yeoman 646695 646695 Jones, Charles, of Llangeby, yeoman 0
4114154 2065343 2065343 defendant Lewys John husbandman 646695 646695 Lewys, John, of Llangeby, husbandman 1
4114200 2065362 2065362 defendant verch Jevan Elizabeth widow 646695 646695 verch Jevan, Elizabeth, of Llangeby, widow 0
4154172 2079556 2079556 defendant Jeyne Richard yeoman 646695 646695 Jeyne, Richard, of Llangeby, yeoman 0
4206799 2097922 2097922 defendant ap John John yeoman 646695 646695 ap John, John, of Llangeby, yeoman 0
4211635 2099619 2099619 defendant Meredyth Rawling Thomas yeoman 646695 646695 Meredyth, Rawling Thomas, of Llangeby, yeoman 1
4212919 2100047 2100047 defendant ap Jevan David Thomas yeoman 646695 646695 ap Jevan, David Thomas, of Llangeby, yeoman 1
4278967 2122576 2122576 defendant John Leonard Philip yeoman 646695 646695 John, Leonard Philip, of Llangeby, yeoman 1
4278969 2122576 2122576 defendant Philip Thomas Morgan yeoman 646695 646695 Philip, Thomas Morgan, of Llangeby, yeoman 3
4279952 2122900 2122900 defendant Morgan Edward yeoman 646695 646695 Morgan, Edward, of Llangeby, yeoman 0
4282809 2123889 2123889 defendant Edwardes Griffin yeoman 646695 646695 Edwardes, Griffin, of Llangeby, yeoman 0
4282810 2123889 2123889 defendant ap John John yeoman 646695 646695 ap John, John, of Llangeby, yeoman 1
4370157 2154387 2154387 defendant Phillipp Jenkin yeoman 646695 646695 Phillipp, Jenkin, of Llangeby, yeoman 0
4370159 2154387 2154387 defendant Phillipp John Jenkin yeoman 646695 646695 Phillipp, John Jenkin, of Llangeby, yeoman 2
4370249 2154419 2154419 defendant Philip John Jenkin yeoman 646695 646695 Philip, John Jenkin, of Llangeby, yeoman 2
4381455 2158474 2158474 defendant Bean William John tailor 646695 646695 Bean, William John, of Llangeby, tailor 2

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);