names

28 rows where place_id = 668438

✎ 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
3989133 2020852 2020852 defendant Hughe Philip husbandman 668438 668438 Hughe, Philip, of Llangattock Vybon Avell, husbandman 0
3989134 2020852 2020852 defendant David Philip John husbandman 668438 668438 David, Philip John, of Llangattock Vybon Avell, husbandman 1
3989135 2020852 2020852 defendant Charles William husbandman 668438 668438 William Charles, of Llangattock Vybon Avell, husbandman 2
3989136 2020852 2020852 defendant Hughe Margaret spinster 668438 668438 Hughe, Margaret, of Llangattock Vybon Avell, spinster 3
4035068 2037225 2037225 defendant William John James gent 668438 668438 William, John James, of Llangattock Vybon Avell, gent 1
4040911 2039238 2039238 defendant Watkyn Charles yeoman 668438 668438 Watkyn, Charles, of Llangattock Vybon Avell, yeoman 1
4053506 2043629 2043629 defendant Phillipp William Jenkin husbandman 668438 668438 Phillipp, William Jenkin, of Llangattock vybon Avell, husbandman 2
4053630 2043672 2043672 defendant William William Philip yeoman 668438 668438 William, William Philip, of Llangattock Vybon Avell, yeoman 0
4053631 2043672 2043672 defendant ap Richard Hopkin yeoman 668438 668438 ap Richard, Hopkin, of Llangattock Vybon Avell, yeoman 1
4080024 2053160 2053160 defendant Phillipp Hopkin William yeoman 668438 668438 Phillipp, Hopkin William, of Llangattock Vybon Avell, yeoman 0
4080025 2053160 2053160 defendant William William Philip yeoman 668438 668438 William, William Philip, of Llangattock Vybon Avell, yeoman 1
4082924 2054193 2054193 defendant Philip Hopkin William yeoman 668438 668438 Philip, Hopkin William, of Llangattock Vybon Avell, yeoman 0
4099963 2060312 2060312 defendant James John yeoman 668438 668438 James, John, of Llangattock Vybon Avell, yeoman 0
4107434 2062946 2062946 defendant verch John Anne widow 668438 668438 verch John, Anne, of Llangattock Vybon Avell, widow 0
4107435 2062946 2062946 defendant Jevan Philip laborer 668438 668438 Jevan, Philip, of Llangattock Vybon Avell, laborer 1
4107436 2062946 2062946 defendant Phylpott Robert weaver 668438 668438 Phylpott, Robert, of Llangattock Vybon Avell, weaver 2
4107437 2062946 2062946 defendant Robert Jevan laborer 668438 668438 Robert, Jevan, of Llangattock Vybon Avell, laborer 3
4114186 2065356 2065356 defendant William Philpott husbandman 668438 668438 William, Philpott, of Llangattock Vybon Avell, husbandman 1
4129756 2070954 2070954 defendant William Jenkin yeoman 668438 668438 William, Jenkin, of Llangattock Vybon Avell, yeoman 0
4129758 2070954 2070954 defendant William Robert weaver 668438 668438 William, Robert, of Llangattock Vybon Avell, weaver 2
4154109 2079531 2079531 defendant Lloyd William Thomas yeoman 668438 668438 Lloyd, William Thomas, of Llangattock Vybon Avell, yeoman 1
4154358 2079617 2079617 defendant Hewes William gent 668438 668438 Hewes, William, of Llangattock Vybon Avell, gent 1
4154366 2079619 2079619 defendant Lloyd Jenkin William Thomas yeoman 668438 668438 Lloyd, Jenkin William Thomas, of Llangattock Vybon Avell, yeoman 0
4194874 2093770 2093770 defendant Lloyd Jenkin yeman 668438 668438 Lloyd, Jenkin, of Llangattock Vybon Avell, yeman 1
4197128 2094548 2094548 defendant William William Philip yeoman 668438 668438 William, William Philip, of Llangattock Vybon Avell, yeoman 0
4197129 2094548 2094548 defendant William Jenkin yeoman 668438 668438 William, Jenkin, of Llangattock Vybon Avell, yeoman 1
4200965 2095894 2095894 defendant William William Philip yeoman 668438 668438 William, William Philip, of Llangattock Vybon Avell, yeoman 1
4212910 2100044 2100044 defendant William William Philip yeoman 668438 668438 William, William Philip, of Llangattock Vybon Avell, 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);