names

6 rows where case_id = 2402630

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5155045 2402630 2402630 plaintiff Lyhert Walter bishop of Norwich   Lyhert, Walter, bishop of Norwich 0
5155046 2402630 2402630 defendant Broun Wystanus clerk and parson of the church of St John's in Madirmarket 585936 585936 Broun, Wystanus, of Norwich, clerk and parson of the church of St John's in Madirmarket 0
5155047 2402630 2402630 defendant Neweport Robert clerk & parson 588580 588580 Neweport, Robert, of West Walton, clerk & parson 1
5155048 2402630 2402630 defendant Austyn Richard clerk & parson 657476 657476 Austyn, Richard, of Westwynch, master, clerk & parson 2
5155049 2402630 2402630 defendant Bevyr Thomas clerk & parson of St Mary's church 590306 590306 Bevyr, Thomas, of Wetyng, clerk & parson of St Mary's church 3
5155050 2402630 2402630 defendant Busshop William clerk 591123 591123 Busshop, William, of West Lexham, clerk 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);