names

17 rows where place_id = 646701

✎ 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
3892418 1987713 1987713 defendant ap Philip thomas ap Keyney clerk 646701 646701 ap Philip, thomas ap Keyney, of Llanvapley, clerk 10
4066942 2048474 2048474 defendant Lewes Richard gent 646701 646701 Lewes, Richard, of Llanvapley, gent 0
4067930 2048839 2048839 defendant Morgan Howell ap Rees yeoman 646701 646701 Morgan, Howell ap Rees, of Llanvapley, yeoman 1
4073382 2050768 2050768 defendant Jones Richard yeoman 646701 646701 Jones, Richard, of Llanvapley, yeoman 2
4081616 2053728 2053728 defendant Thomas William yeoman 646701 646701 Thomas, William, of Llanvapley, yeoman 0
4081619 2053729 2053729 defendant Thomas Thomas yeoman 646701 646701 Thomas, Thomas, of Llanvapley, yeoman 0
4083045 2054230 2054230 defendant Exhan Richard John yeoman 646701 646701 Exhan, Richard John, of Llanvapley, yeoman 1
4104640 2061941 2061941 defendant James William yeoman 646701 646701 James, William, of Llanvapley, yeoman 1
4107432 2062945 2062945 defendant Thomas Lewis yeoman 646701 646701 Thomas, Lewis, of Llanvapley, yeoman 1
4114215 2065366 2065366 defendant Morgan Richard John yeoman 646701 646701 Morgan, Richard John, of Llanvapley, yeoman 3
4153469 2079310 2079310 defendant John Jenkin yeoman 646701 646701 John, Jenkin, of Llanvapley, yeoman 0
4153470 2079310 2079310 defendant verch Jenkyn Katherine widow 646701 646701 verch Jenkyn, Katherine, of Llanvapley, widow 1
4157943 2080848 2080848 defendant William Robert John gent 646701 646701 William, Robert John, of Llanvapley, gent 0
4163660 2082810 2082810 defendant Appowell William John yeoman 646701 646701 Appowell, William John, of Llanvapley, yeoman 0
4222182 2103249 2103249 defendant William Richard yeoman 646701 646701 William, Richard, of Llanvapley, yeoman 1
4223357 2103662 2103662 defendant Yghan Richard John yeoman 646701 646701 Yghan, Richard John, of Llanvapley, yeoman 0
4358596 2150246 2150246 defendant Vaughan Thomas Prichard yeoman 646701 646701 Vaughan, Thomas Prichard, of Llanvapley, yeoman 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);