names

19 rows where place_id = 659755

✎ 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
3953697 2008367 2008367 defendant Hullyn Jenkyn William Thomas yeoman 659755 659755 Hullyn, Jenkyn William Thomas, of Comcarvan, yeoman 9
3953829 2008411 2008411 defendant Hullyn Jenkyn William Thomas yeoman 659755 659755 Hullyn, Jenkyn William Thomas, of Comcarvan, yeoman 9
3953840 2008412 2008412 defendant Hullyn Jenkyn William Thomas yeoman 659755 659755 Hullyn, Jenkyn William Thomas, of Comcarvan, yeoman 9
3962824 2011588 2011588 defendant Willym John husbandman 659755 659755 Willym, John, of Comcarvan, husbandman 0
4026509 2034130 2034130 defendant Yoroth Edmund John gent 659755 659755 Yoroth, Edmund John, of Comcarvan, gent 0
4035074 2037227 2037227 defendant Yoroth Edmund John gent 659755 659755 Yoroth, Edmund John, of Comcarvan, gent 1
4035075 2037227 2037227 defendant ap John John yeoman 659755 659755 ap John, John, of Comcarvan, yeoman 2
4035076 2037227 2037227 defendant David Thomas ap Powell husbandman 659755 659755 David, Thomas ap Powell, of Comcarvan, husbandman 3
4065858 2048084 2048084 defendant Thomas Richard William husbandman 659755 659755 Thomas, Richard William, of Comcarvan, husbandman 3
4066872 2048448 2048448 defendant Howell John John yeoman 659755 659755 Howell, John John, of Comcarvan, yeoman 0
4201963 2096232 2096232 defendant Thomas Richard William yeoman 659755 659755 Thomas, Richard William, of Comcarvan, yeoman 0
4201964 2096232 2096232 defendant Thomas John William yeoman 659755 659755 Thomas, John William, of Comcarvan, yeoman 1
4218564 2101992 2101992 defendant David Thomas husbandman 659755 659755 David, Thomas, of Comcarvan, husbandman 0
4218569 2101993 2101993 defendant Price Thomas laborer 659755 659755 Price, Thomas, of Comcarvan, laborer 1
4278764 2122509 2122509 defendant Paske John William yeoman 659755 659755 Paske, John William, of Comcarvan, yeoman 0
4278775 2122514 2122514 defendant Paske Jenkin William yeoman 659755 659755 Paske, Jenkin William, of Comcarvan, yeoman 0
4278778 2122515 2122515 defendant Prosser Charles yeoman 659755 659755 Prosser, Charles, of Comcarvan, yeoman 0
4279482 2122744 2122744 defendant William George clerk 659755 659755 William, George, of Comcarvan, clerk 0
4351123 2147643 2147643 defendant Tayler Richard Morgan yeoman 659755 659755 Tayler, Richard Morgan, of Comcarvan, yeoman 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);