names

8 rows where case_id = 2430439

✎ 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
5251069 2430439 2430439 plaintiff Wyght Robert parson of Westchepe St Peter, London   Wyght, Robert, parson of Westchepe St Peter, London, executors of 0
5251070 2430439 2430439 plaintiff Barton William chaplain of Faryngdon chantry   (Barton, William, chaplain of Faryngdon chantry 1
5251071 2430439 2430439 plaintiff Roger John chaplain of Holy Cross chantry, St Peter, Westchepe   Roger, John, chaplain of Holy Cross chantry, St Peter, Westchepe 2
5251072 2430439 2430439 defendant Queyntrell Richard husbandman 669594 669594 Queyntrell, Richard, of Woxbridge, husbandman 0
5251073 2430439 2430439 defendant Frankeley John husbandman 587523 587523 Frankeley, John, of Hamersmyth, husbandman 1
5251074 2430439 2430439 defendant Clokton Richard husbandman 669594 669594 Clokton, Richard, of Woxbridge, husbandman 2
5251075 2430439 2430439 defendant Dawe Richard husbandman 669594 669594 Dawe, Richard, of Woxbridge, husbandman 3
5251076 2430439 2430439 defendant Colman Thomas husbandman 587523 587523 Colman, Thomas, of Hamersmyth, husbandman 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);