names

6 rows where case_id = 2043645

✎ 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
4053550 2043645 2043645 plaintiff ap Owen John (legal representative) 751231 751231 ap Owen, John, of Busshopps Castle, Salop, gent, administrator of 0
4053551 2043645 2043645 plaintiff ap Owen Edward     ap Owen, Edward 1
4053552 2043645 2043645 defendant Russell John mercer 669854 669854 Russell, John, of Bysshopps Castell, Salop, mercer 0
4053553 2043645 2043645 defendant ap Hoell William or William ap Holl ap Lluwellen Meredithe, of of Penegos, Montgomery, gent   ap Hoell, William, or William ap Holl ap Lluwellen Meredithe, of of Penegos, Montgomery, gent 1
4053554 2043645 2043645 defendant Dackyn Griffin ap Hugh yeoman 683339 683339 Dackyn, Griffin ap Hugh, of Manllowys, Merioneth, yeoman 2
4053555 2043645 2043645 defendant ap Ryce Jevan gent 683340 683340 ap Ryce, Jevan, of or Jevan ap Rees ap David ap Lluwellen Towne, Merioneth, gent 3

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