names

6 rows where case_id = 2184853

✎ 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
4449697 2184853 2184853 plaintiff Grafton John de master of the Hospital of St John Baptist 586848 586848 Grafton, John de, of Northampton, master of the Hospital of St John Baptist 0
4449698 2184853 2184853 defendant Wryght John   638187 638187 Wryght, John, of Bleseworth 0
4449699 2184853 2184853 defendant Flesshewer John   638187 638187 Flesshewer, John, of Bleseworth 1
4449700 2184853 2184853 defendant Hoppere Richard     Hoppere, Richard 2
4449701 2184853 2184853 defendant Nicole John     Nicole, John 3
4449702 2184853 2184853 defendant Huchonnes John     Huchonnes, John 4

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