names

21 rows where case_id = 2181500

✎ 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
4439019 2181500 2181500 plaintiff atte Welle William     atte Welle, William 0
4439020 2181500 2181500 defendant Hellowe Richard   756598 756598 Hellowe, Richard, of Halyok 0
4439021 2181500 2181500 defendant Campyon John     Campyon, John 1
4439022 2181500 2181500 defendant Munke Alan     Munke, Alan 2
4439023 2181500 2181500 defendant atte Lane Richard     atte Lane, Richard 3
4439024 2181500 2181500 defendant Garneter John     Garneter, John 4
4439025 2181500 2181500 defendant Smyth William     Smyth, William 5
4439026 2181500 2181500 defendant Chauslep Bertram     Chauslep, Bertram 6
4439027 2181500 2181500 defendant Bonde Hugh     Bonde, Hugh 7
4439028 2181500 2181500 defendant Page Thomas     Page, Thomas 8
4439029 2181500 2181500 defendant Jankyn Thomas     Jankyn, Thomas 9
4439030 2181500 2181500 defendant Colyne Robert     Colyne, Robert 10
4439031 2181500 2181500 defendant Colyn Thomas     Colyn, Thomas 11
4439032 2181500 2181500 defendant Richard John     Richard, John 12
4439033 2181500 2181500 defendant Colyn Richard     Colyn, Richard 13
4439034 2181500 2181500 defendant Launden John     Launden, John 14
4439035 2181500 2181500 defendant atte Lane Robert     atte Lane, Robert 15
4439036 2181500 2181500 defendant Swan John     Swan, John 16
4439037 2181500 2181500 defendant Cartere William     Cartere, William 17
4439038 2181500 2181500 defendant Bedele Walter     Bedele, Walter 18
4439039 2181500 2181500 defendant Coursen John     Coursen, John 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);