names

13 rows where case_id = 2462198

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5356819 2462198 2462198 plaintiff Martyn John     Martyn, John 0
5356820 2462198 2462198 defendant Ive John esq 826793 826793 Ive, John, of Magna Fymbergh, esq 0
5356821 2462198 2462198 defendant Ive Robert gent 586818 586818 Ive, Robert, of Stowemarket, gent 1
5356822 2462198 2462198 defendant Holm John (legal representative) 586824 586824 Holm, John, of Cretyngham, gent, executors of 2
5356823 2462198 2462198 defendant Holm William yeoman 586824 586824 (Holm, William, of Cretyngham, yeoman 3
5356824 2462198 2462198 defendant Mors John yeoman 591805 591805 Mors, John, of Otley, yeoman 4
5356825 2462198 2462198 defendant Stede John yeoman 586470 586470 Stede, John, of Colchester, yeoman 5
5356826 2462198 2462198 defendant Rolcrosse Roger yeoman 587921 587921 Rolcrosse, Roger, of Stanton, yeoman 6
5356827 2462198 2462198 defendant Fyske William pedder 587187 587187 Fyske, William, of Laxfeld, pedder 7
5356828 2462198 2462198 defendant Bateman Thomas weaver 585947 585947 Bateman, Thomas, of Hadley, weaver 8
5356829 2462198 2462198 defendant Kyrkhous Robert yeoman 586134 586134 Kyrkhous, Robert, of Ipswich, yeoman 9
5356830 2462198 2462198 defendant Reydon William yeoman 586824 586824 Reydon, William, of Cretyngham, yeoman 10
5356831 2462198 2462198 defendant Leche John barker 591511 591511 Leche, John, of Stratford, barker 11

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