names

22 rows where case_id = 1925180

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3696639 1925180 1925180 plaintiff Sherborne Robert Bishop of Chichester   Sherborne, Robert, Bishop of Chichester 0
3696640 1925180 1925180 plaintiff Dawtrey John     Dawtrey, John 1
3696641 1925180 1925180 defendant Fyvyan Williamm bailiff of Petteworth, yeoman   Fyvyan, Williamm, bailiff of Petteworth, yeoman 0
3696642 1925180 1925180 defendant Obley John yeoman 613106 613106 Obley, John, of Petteworth, yeoman 1
3696643 1925180 1925180 defendant Turge William yeoman 613106 613106 Turge, William, of Petteworth, yeoman 2
3696644 1925180 1925180 defendant Bowyer Richard yeoman 613106 613106 Bowyer, Richard, of Petteworth, yeoman 3
3696645 1925180 1925180 defendant Gobill James yeoman 613106 613106 Gobill, James, of Petteworth, yeoman 4
3696646 1925180 1925180 defendant Johnson Anthony yeoman 613106 613106 Johnson, Anthony, of Petteworth, yeoman 5
3696647 1925180 1925180 defendant Bocher William yeoman 613106 613106 Bocher, William, of Petteworth, yeoman 6
3696648 1925180 1925180 defendant Bocher John     Bocher, John 7
3696649 1925180 1925180 defendant Umfrey Richard     Umfrey, Richard 8
3696650 1925180 1925180 defendant Yong William     Yong, William 9
3696651 1925180 1925180 defendant Gobill John     Gobill, John 10
3696652 1925180 1925180 defendant Ford William     Ford, William 11
3696653 1925180 1925180 defendant Bowyer William, junior     Bowyer, William, junior 12
3696654 1925180 1925180 defendant Eyre William     Eyre, William 13
3696655 1925180 1925180 defendant Portebury William     Portebury, William 14
3696656 1925180 1925180 defendant besse John yunior   besse, John, yunior 15
3696657 1925180 1925180 defendant Rykford Robert     Rykford, Robert 16
3696658 1925180 1925180 defendant Iderton John     Iderton, John 17
3696659 1925180 1925180 defendant Goffe John     Goffe, John 18
3696660 1925180 1925180 defendant Toper Thomas     Toper, Thomas 19

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