names

21 rows where case_id = 2211280

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4535201 2211280 2211280 plaintiff Shirlok Richard     Shirlok, Richard 0
4535202 2211280 2211280 defendant Smyth John   597874 597874 Smyth, John, of Stowe 0
4535203 2211280 2211280 defendant Furbisshour John     Furbisshour, John 1
4535204 2211280 2211280 defendant Kent William     Kent, William 2
4535205 2211280 2211280 defendant Furneux William     Furneux, William 3
4535206 2211280 2211280 defendant Chaloner Adam     Chaloner, Adam 4
4535207 2211280 2211280 defendant Talyour John     Talyour, John 5
4535208 2211280 2211280 defendant Hotoft Geoffrey     Hotoft, Geoffrey 6
4535209 2211280 2211280 defendant Bille Robert     Bille, Robert 7
4535210 2211280 2211280 defendant Sadelere John     Sadelere, John 8
4535211 2211280 2211280 defendant Brastrete Robert     Brastrete, Robert 9
4535212 2211280 2211280 defendant Hoo Thomas of Stowe     Hoo, Thomas of Stowe 10
4535213 2211280 2211280 defendant Wokes John     Wokes, John 11
4535214 2211280 2211280 defendant (not given) John his son   John, his son 12
4535215 2211280 2211280 defendant Barbour Walter     Barbour, Walter 13
4535216 2211280 2211280 defendant Sharp John     Sharp, John 14
4535217 2211280 2211280 defendant Mundevylle Robert     Mundevylle, Robert 15
4535218 2211280 2211280 defendant Curteys John     Curteys, John 16
4535219 2211280 2211280 defendant Gardener Robert     Gardener, Robert 17
4535220 2211280 2211280 defendant Mercer Thomas     Mercer, Thomas 18
4535221 2211280 2211280 defendant Bailly John   587061 587061 Bailly, John, of Combes 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);