names

20 rows where place_id = 645070

✎ 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
3883627 1984794 1984794 plaintiff Wenman Thomas esq 645070 645070 Wenman, Thomas, of Craswell, esq 0
3964948 2012347 2012347 defendant Taylor alias Prychard Thomas tailor 645070 645070 Taylor alias Prychard, Thomas, of Craswell, tailor 1
3988302 2020564 2020564 defendant ap Rychard Lewis yeoman 645070 645070 ap Rychard, Lewis, of Craswell, yeoman 1
4010597 2028564 2028564 defendant Hugh Howell ap Richard yeoman 645070 645070 Hugh, Howell ap Richard, of Craswell, yeoman 10
4010598 2028564 2028564 defendant ap Howell Thomas yeoman 645070 645070 ap Howell, Thomas, of Craswell, yeoman 11
4019323 2031645 2031645 defendant Howell Lewis yeoman 645070 645070 Howell, Lewis, of Craswell, yeoman 0
4022229 2032678 2032678 plaintiff ap Howell Henry David yeoman 645070 645070 ap Howell, Henry David, of Craswell, yeoman 0
4022233 2032678 2032678 defendant Apowell Jenkin harry yeoman 645070 645070 Apowell, Jenkin harry, of Craswell, yeoman 2
4043791 2040236 2040236 defendant Philip William John husbandman 645070 645070 Philip, William John, of Craswell, husbandman 0
4043792 2040236 2040236 defendant Philip Griffin ap William John husbandman 645070 645070 Philip, Griffin ap William John, of Craswell, husbandman 1
4043793 2040236 2040236 defendant Philip John ao William John   645070 645070 Philip, John ao William John, of Craswell, husbandma 2
4052497 2043315 2043315 defendant William Nicholas yeoman 645070 645070 William, Nicholas, of Craswell, yeoman 1
4053418 2043599 2043599 defendant Lewis Griffin Harry husbandman 645070 645070 Lewis, Griffin Harry, of Craswell, husbandman 0
4053578 2043653 2043653 defendant ap Rychard Thomas John yeoman 645070 645070 ap Rychard, Thomas John, of Craswell, yeoman 0
4073797 2050920 2050920 defendant Mady Thomas ap Howell ap Rees yeoman 645070 645070 Mady, Thomas ap Howell ap Rees, of Craswell, yeoman 0
4107859 2063088 2063088 defendant William Griffin yeoman 645070 645070 William, Griffin, of Craswell, yeoman 1
4110618 2064054 2064054 defendant ap Richard Thomas John yeoman 645070 645070 ap Richard, Thomas John, of Craswell, yeoman 0
4116143 2066066 2066066 defendant Wyndsor Thomas husbandman 645070 645070 Wyndsor, Thomas, of Craswell, husbandman 2
4117415 2066525 2066525 defendant Harry Jenkin laborer 645070 645070 Harry, Jenkin, of Craswell, laborer 1
4236682 2108404 2108404 defendant Morgan Roger yeoman 645070 645070 Morgan, Roger, of Craswell, 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);