names

6 rows where case_id = 2463063

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5359672 2463063 2463063 plaintiff Rogers John     Rogers, John 0
5359673 2463063 2463063 defendant Brewes William yeoman 588667 588667 Brewes, William, of Stratford on Avon, yeoman 0
5359674 2463063 2463063 defendant Bukden Roger wheeler 588667 588667 Bukden, Roger, of Stratford on Avon, wheeler 1
5359675 2463063 2463063 defendant Knyght William husbandman 595043 595043 Knyght, William, of Claredon, husbandman 2
5359676 2463063 2463063 defendant Robyns John barber 588667 588667 Robyns, John, of Stratford on Avon, barber 3
5359677 2463063 2463063 defendant Pryket John wheeler 588667 588667 Pryket, John, of Stratford on Avon, wheeler 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);