names

15 rows where case_id = 2241277

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4633283 2241277 2241277 plaintiff Warthewyk George de     Warthewyk, George de 0
4633284 2241277 2241277 defendant Milner Thomas   643567 643567 Milner, Thomas, of Karlyll 0
4633285 2241277 2241277 defendant Clapamman Richard     Clapamman, Richard 1
4633286 2241277 2241277 defendant Thomlynson John   622943 622943 Thomlynson, John, of Hayton 2
4633287 2241277 2241277 defendant Benson John     Benson, John 3
4633288 2241277 2241277 defendant Cisson John     Cisson, John 4
4633289 2241277 2241277 defendant Westgarth John     Westgarth, John 5
4633290 2241277 2241277 defendant Topclif John     Topclif, John 6
4633291 2241277 2241277 defendant Sclater William   776393 776393 together with Sclater, William, of Karlyll or Carllsle 7
4633292 2241277 2241277 defendant Aykhed Robert     Aykhed, Robert 8
4633293 2241277 2241277 defendant Boweston William   765096 765096 Boweston, William, of Crosseby 9
4633294 2241277 2241277 defendant Saundreson Richard     Saundreson, Richard 10
4633295 2241277 2241277 defendant Atkynson John   765096 765096 Atkynson, John, of Crosseby 11
4633296 2241277 2241277 defendant Blaklok John     Blaklok, John 12
4633297 2241277 2241277 defendant del Gylle John     del Gylle, John 13

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