names

21 rows where case_id = 2181501

✎ 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
4439040 2181501 2181501 plaintiff atte Welle William     atte Welle, William 0
4439041 2181501 2181501 defendant Hellowe Richard   756598 756598 Hellowe, Richard, of Halyok 0
4439042 2181501 2181501 defendant Campyon John     Campyon, John 1
4439043 2181501 2181501 defendant Munke Alan     Munke, Alan 2
4439044 2181501 2181501 defendant atte Lane Richard     atte Lane, Richard 3
4439045 2181501 2181501 defendant Garneter John     Garneter, John 4
4439046 2181501 2181501 defendant Smyth William     Smyth, William 5
4439047 2181501 2181501 defendant Hanslep Peter     Hanslep, Peter 6
4439048 2181501 2181501 defendant Bonde Hugh     Bonde, Hugh 7
4439049 2181501 2181501 defendant Page Thomas     Page, Thomas 8
4439050 2181501 2181501 defendant Jankyn Thomas     Jankyn, Thomas 9
4439051 2181501 2181501 defendant Colyn Robert     Colyn, Robert 10
4439052 2181501 2181501 defendant Colyn Thomas     Colyn, Thomas 11
4439053 2181501 2181501 defendant Richard John     Richard, John 12
4439054 2181501 2181501 defendant Colyn Richard     Colyn, Richard 13
4439055 2181501 2181501 defendant Lamden John     Lamden, John 14
4439056 2181501 2181501 defendant atte Lane Robert     atte Lane, Robert 15
4439057 2181501 2181501 defendant Swan John     Swan, John 16
4439058 2181501 2181501 defendant Cartere William     Cartere, William 17
4439059 2181501 2181501 defendant Bedele Walter     Bedele, Walter 18
4439060 2181501 2181501 defendant Cursson John     Cursson, 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);