names

15 rows where case_id = 2203100

✎ 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
4508356 2203100 2203100 plaintiff Accon Lawrence     Accon, Lawrence 0
4508357 2203100 2203100 defendant Keswyk John de     Keswyk, John de 0
4508358 2203100 2203100 defendant Richardson William   605984 605984 Richardson, William, of Newcastle upon Tyne 1
4508359 2203100 2203100 defendant Smythson John     Smythson, John 2
4508360 2203100 2203100 defendant Dey William     Dey, William 3
4508361 2203100 2203100 defendant Cledde John     Cledde, John 4
4508362 2203100 2203100 defendant Monke Nicholas     Monke, Nicholas 5
4508363 2203100 2203100 defendant del Man John     del Man, John 6
4508364 2203100 2203100 defendant Cosour William     Cosour, William 7
4508365 2203100 2203100 defendant Ferrour John   598666 598666 Ferrour, John, of Newcastle 8
4508366 2203100 2203100 defendant Wetewang William     Wetewang, William 9
4508367 2203100 2203100 defendant del Welles Thomas     del Welles, Thomas 10
4508368 2203100 2203100 defendant Carter Adam   764679 764679 Carter, Adam, of Elstwyk 11
4508369 2203100 2203100 defendant Grenelef Richard     Grenelef, Richard 12
4508370 2203100 2203100 defendant Breuster John   605984 605984 Breuster, John, of Newcastle upon Tyne 13

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