names

16 rows where case_id = 2194169

✎ 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
4479256 2194169 2194169 plaintiff Hull Robert     Hull, Robert 0
4479257 2194169 2194169 defendant Assherugg John     Assherugg, John 0
4479258 2194169 2194169 defendant Brouneswill John     Brouneswill, John 1
4479259 2194169 2194169 defendant Lymeger John   586489 586489 Lymeger, John, of Holbeton 2
4479260 2194169 2194169 defendant Alard William     Alard, William 3
4479261 2194169 2194169 defendant Cook John     Cook, John 4
4479262 2194169 2194169 defendant Adam Thomas     Adam, Thomas 5
4479263 2194169 2194169 defendant Bilke John     Bilke, John 6
4479264 2194169 2194169 defendant Taillour Thomas     Taillour, Thomas 7
4479265 2194169 2194169 defendant Bokeram John     Bokeram, John 8
4479266 2194169 2194169 defendant Hawekyn John     Hawekyn, John 9
4479267 2194169 2194169 defendant Jemyn Isaak     Jemyn, Isaak 10
4479268 2194169 2194169 defendant North Adam     North, Adam 11
4479269 2194169 2194169 defendant Longeman John     Longeman, John 12
4479270 2194169 2194169 defendant Pouche John     Pouche, John 13
4479271 2194169 2194169 defendant Damarle Isabell formerly wife of John   with Damarle, Isabell, formerly wife of 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);