names

16 rows where case_id = 2181856

✎ 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
4440193 2181856 2181856 plaintiff Beaulieu Richard de     Beaulieu, Richard de 0
4440194 2181856 2181856 defendant Lodull William de   586549 586549 Lodull, William de, of Hoton 0
4440195 2181856 2181856 defendant Shayle Alexander   586549 586549 Shayle, Alexander, of Hoton 1
4440196 2181856 2181856 defendant Jacson Thomas milliner   Jacson, Thomas, milliner 2
4440197 2181856 2181856 defendant Scot John   586549 586549 Scot, John, of Hoton 3
4440198 2181856 2181856 defendant Shayle John   586549 586549 Shayle, John, of Hoton 4
4440199 2181856 2181856 defendant Nutshawe John   586549 586549 Nutshawe, John, of Hoton 5
4440200 2181856 2181856 defendant Shephird Richard   586549 586549 Shephird, Richard, of Hoton 6
4440201 2181856 2181856 defendant Kirkeby William     Kirkeby, William 7
4440202 2181856 2181856 defendant Donanby John de     Donanby, John de 8
4440203 2181856 2181856 defendant Beaulieu Robert de     Beaulieu, Robert de 9
4440204 2181856 2181856 defendant Beaulieu John de     Beaulieu, John de 10
4440205 2181856 2181856 defendant Dundrawe William de     Dundrawe, William de 11
4440206 2181856 2181856 defendant Woltoppe John     Woltoppe, John 12
4440207 2181856 2181856 defendant Joly Thomas of Hoton     Joly, Thomas of Hoton 13
4440208 2181856 2181856 defendant Colyer John     Colyer, John 14

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