names

16 rows where case_id = 2245210

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4647105 2245210 2245210 plaintiff Rygge Margaret   777589 777589 Rygge, Margaret, of Thramston, formerly wife of Robert 0
4647106 2245210 2245210 defendant Morley Thomas lord of Morley, knight   Morley, Thomas, lord of Morley, knight 0
4647107 2245210 2245210 defendant Thorp Edmund de knight   Thorp, Edmund de, knight 1
4647108 2245210 2245210 defendant Morley Robert de knight   Morley, Robert de, knight 2
4647109 2245210 2245210 defendant Phelipp William knight   Phelipp, William, knight 3
4647110 2245210 2245210 defendant Philipp John knight   Philipp, John, knight 4
4647111 2245210 2245210 defendant Fastolf John     Fastolf, John 5
4647112 2245210 2245210 defendant Clifton John de     Clifton, John de 6
4647113 2245210 2245210 defendant Reve Robert clerk   Reve, Robert, clerk 7
4647114 2245210 2245210 defendant Wilbeye John master of the chantry 597283 597283 Wilbeye, John, of Metyngham, master of the chantry 8
4647115 2245210 2245210 defendant Hevenyngham John knight   Hevenyngham, John, knight 9
4647116 2245210 2245210 defendant Norwych John     Norwych, John 10
4647117 2245210 2245210 defendant Danyell Richard     Danyell, Richard 11
4647118 2245210 2245210 defendant Tolle John     Tolle, John 12
4647119 2245210 2245210 defendant Marche Wiliam de     Marche, Wiliam de 13
4647120 2245210 2245210 defendant Savage William     Savage, William 14

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