names

27 rows where case_id = 2211279

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4535174 2211279 2211279 plaintiff Shirlok Richard     Shirlok, Richard 0
4535175 2211279 2211279 defendant Elyngham Thomas   592146 592146 Elyngham, Thomas, of Nedham 0
4535176 2211279 2211279 defendant Barbour John     Barbour, John 1
4535177 2211279 2211279 defendant Sparowe John   592146 592146 Sparowe, John, of Nedham 2
4535178 2211279 2211279 defendant Whyte Richard     Whyte, Richard 3
4535179 2211279 2211279 defendant White William servant of Richard White   White, William, servant of Richard White 4
4535180 2211279 2211279 defendant Elyngham John     together with Elyngham, John 5
4535181 2211279 2211279 defendant Smyth John   597874 597874 Smyth, John, of Stowe 6
4535182 2211279 2211279 defendant Furbisshour John     Furbisshour, John 7
4535183 2211279 2211279 defendant Kent William     Kent, William 8
4535184 2211279 2211279 defendant Furneux William     Furneux, William 9
4535185 2211279 2211279 defendant Chaloner Adam     Chaloner, Adam 10
4535186 2211279 2211279 defendant Talyour John     Talyour, John 11
4535187 2211279 2211279 defendant Hotoft Geoffrey     Hotoft, Geoffrey 12
4535188 2211279 2211279 defendant Bille Robert     Bille, Robert 13
4535189 2211279 2211279 defendant Sadelere John     Sadelere, John 14
4535190 2211279 2211279 defendant Brastrete Robert     Brastrete, Robert 15
4535191 2211279 2211279 defendant Hooe Thomas of Stowe     Hooe, Thomas of Stowe 16
4535192 2211279 2211279 defendant Wokes John     Wokes, John 17
4535193 2211279 2211279 defendant (not given) John his son   John, his son 18
4535194 2211279 2211279 defendant Barbour Walter     Barbour, Walter 19
4535195 2211279 2211279 defendant Sharp John     Sharp, John 20
4535196 2211279 2211279 defendant Mundevylle Robert     Mundevylle, Robert 21
4535197 2211279 2211279 defendant Curteys John     Curteys, John 22
4535198 2211279 2211279 defendant Gardener Robert     Gardener, Robert 23
4535199 2211279 2211279 defendant Mercer Thomas     Mercer, Thomas 24
4535200 2211279 2211279 defendant Bailly John   587061 587061 Bailly, John, of Combes 25

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