names

15 rows where case_id = 2187389

✎ 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
4457600 2187389 2187389 plaintiff Peynteney John chaplain   Peynteney, John, chaplain 0
4457601 2187389 2187389 defendant Deynys John     Deynys, John 0
4457602 2187389 2187389 defendant Hyngham John de     Hyngham, John de 1
4457603 2187389 2187389 defendant Stracour John     Stracour, John 2
4457604 2187389 2187389 defendant Wright Hugh   599846 599846 Wright, Hugh, of Sperham 3
4457605 2187389 2187389 defendant Millgate Reginald de     Millgate, Reginald de 4
4457606 2187389 2187389 defendant Odus Nicholas     Odus, Nicholas 5
4457607 2187389 2187389 defendant Hoddys John     Hoddys, John 6
4457608 2187389 2187389 defendant Brykke Adam     Brykke, Adam 7
4457609 2187389 2187389 defendant Pagard Henry     Pagard, Henry 8
4457610 2187389 2187389 defendant Ofeveryon Robert     Ofeveryon, Robert 9
4457611 2187389 2187389 defendant Franey John     Franey, John 10
4457612 2187389 2187389 defendant Suched John     Suched, John 11
4457613 2187389 2187389 defendant Goudwyn John     Goudwyn, John 12
4457614 2187389 2187389 defendant Goudwyn Richard son of John   Goudwyn, Richard, son of John 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);