names

8 rows where case_id = 2301160

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4816227 2301160 2301160 plaintiff Lovell William knight   Lovell, William, knight 0
4816228 2301160 2301160 defendant Hygon Richard butcher 806737 806737 Hygon, Richard, of Shaftesbery, Dors, butcher 0
4816229 2301160 2301160 defendant Vynyng Thomas butcher 806738 806738 Vynyng, Thomas, of Shaftesbery, butcher 1
4816230 2301160 2301160 defendant Hulcote John butcher 806739 806739 Hulcote, John, of Eylyngham, Dors, butcher 2
4816231 2301160 2301160 defendant Momford William butcher 585975 585975 Momford, William, of Shaftesbury, butcher 3
4816232 2301160 2301160 defendant Lange John butcher 806740 806740 Lange, John, of Wylcanlton, soms, butcher 4
4816233 2301160 2301160 defendant Coyte William   806741 806741 Coyte, William, of Dunhed St Mary, Wilts, mason 5
4816234 2301160 2301160 defendant Bokeden John   704605 704605 Bokeden, John, of Dunhed St Andrew, servant 6

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