names

20 rows where case_id = 2189708

✎ 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
4464932 2189708 2189708 plaintiff White John     White, John 0
4464933 2189708 2189708 defendant Boton John   759859 759859 Boton, John, of Aillysham 0
4464934 2189708 2189708 defendant Clerk William   613692 613692 Clerk, William, of Hadham 1
4464935 2189708 2189708 defendant Bakster Adam   759860 759860 Bakster, Adam, of Worthsted 2
4464936 2189708 2189708 defendant Frost John   633612 633612 Frost, John, of Thorp Market 3
4464937 2189708 2189708 defendant Gryme John   633612 633612 Gryme, John, of Thorp Market 4
4464938 2189708 2189708 defendant Skynner James   759861 759861 Skynner, James, of Suth Repys 5
4464939 2189708 2189708 defendant Grenewey John   759862 759862 Grenewey, John, of Weltirton 6
4464940 2189708 2189708 defendant James William   633612 633612 James, William, of Thorp market 7
4464941 2189708 2189708 defendant Grene John     Grene, John 8
4464942 2189708 2189708 defendant atte Kichyn Peter   618126 618126 atte Kichyn, Peter, of Branston 9
4464943 2189708 2189708 defendant Hert Pagaus   759863 759863 Hert, Pagaus, of Eyngworth 10
4464944 2189708 2189708 defendant Fuller John   587935 587935 Fuller, John, of Colby 11
4464945 2189708 2189708 defendant Talyser Robert     Talyser, Robert 12
4464946 2189708 2189708 defendant Haty John     Haty, John 13
4464947 2189708 2189708 defendant Heyward Henry     Heyward, Henry 14
4464948 2189708 2189708 defendant Lesyngham Thomas     Lesyngham, Thomas 15
4464949 2189708 2189708 defendant Spalle Ralph   755067 755067 Spalle, Ralph, of Worthstede 16
4464950 2189708 2189708 defendant Parent Richard   755067 755067 Parent, Richard, of Worthstede 17
4464951 2189708 2189708 defendant Story John   755067 755067 Story, John, of Worthstede 18

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