names

28 rows where case_id = 1911009

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3652115 1911009 1911009 plaintiff Tresythny John     Tresythny, John 0
3652116 1911009 1911009 defendant Vathy William yeoman 590651 590651 Vathy, William, of St Dey, yeoman 0
3652117 1911009 1911009 defendant Hucka John Jacke     Hucka, John Jacke 1
3652118 1911009 1911009 defendant Thomas William     Thomas, William 2
3652119 1911009 1911009 defendant Tateryne William     Tateryne, William 3
3652120 1911009 1911009 defendant William John     William, John 4
3652121 1911009 1911009 defendant Thomas Nicholas     Thomas, Nicholas 5
3652122 1911009 1911009 defendant Gorebewe John     Gorebewe, John 6
3652123 1911009 1911009 defendant Houper Lawrence     Houper, Lawrence 7
3652124 1911009 1911009 defendant Vathy John     Vathy, John 8
3652125 1911009 1911009 defendant Oby Simon Jankyn   602876 602876 Oby, Simon Jankyn, of Talgolowe 9
3652126 1911009 1911009 defendant Wolcok Nicholas     Wolcok, Nicholas 10
3652127 1911009 1911009 defendant Rycoll John Rawlyn     Rycoll, John Rawlyn 11
3652128 1911009 1911009 defendant Thomas Drew     Thomas, Drew 12
3652129 1911009 1911009 defendant Talgolowe James     Talgolowe, James 13
3652130 1911009 1911009 defendant Lokkyer John     Lokkyer, John 14
3652131 1911009 1911009 defendant Hamlyn John Jack     Hamlyn, John Jack 15
3652132 1911009 1911009 defendant trenowyth John     trenowyth, John 16
3652133 1911009 1911009 defendant Opy Thomas     Opy, Thomas 17
3652134 1911009 1911009 defendant Trevethen Henry     Trevethen, Henry 18
3652135 1911009 1911009 defendant Jankyn Henry     Jankyn, Henry 19
3652136 1911009 1911009 defendant Laurens Thomas Jack     Laurens, Thomas Jack 20
3652137 1911009 1911009 defendant Mercer John     Mercer, John 21
3652138 1911009 1911009 defendant Cardrewe Michael     Cardrewe, Michael 22
3652139 1911009 1911009 defendant Jachamlyn Thomas     Jachamlyn, Thomas 23
3652140 1911009 1911009 defendant Perkyn Peter     Perkyn, Peter 24
3652141 1911009 1911009 defendant Engothell Benedict     Engothell, Benedict 25
3652142 1911009 1911009 defendant Panter Nicholas     Panter, Nicholas 26

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