names

14 rows where case_id = 2418041

✎ 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
5207888 2418041 2418041 plaintiff Notyngham William     Notyngham, William 0
5207889 2418041 2418041 defendant Yong John     Yong, John 0
5207890 2418041 2418041 defendant Redysdale John     Redysdale, John 1
5207891 2418041 2418041 defendant Wetwang Edward     Wetwang, Edward 2
5207892 2418041 2418041 defendant Mappas John     Mappas, John 3
5207893 2418041 2418041 defendant Pykden Robert     Pykden, Robert 4
5207894 2418041 2418041 defendant Roose William     Roose, William 5
5207895 2418041 2418041 defendant Shrygley John gent 857963 857963 Shrygley, John, of Makkesfeld, Cheshire, gent 6
5207896 2418041 2418041 defendant Downes Geoffrey gent 859466 859466 Downes, Geoffrey, of Stopper, Cheshire, gent 7
5207897 2418041 2418041 defendant Dymmok John gent 592302 592302 Dymmok, John, of Fryskeney, Lincs, gent 8
5207898 2418041 2418041 defendant Cawod William merchant 600449 600449 Cawod, William, of Boston, Lincs, merchant 9
5207899 2418041 2418041 defendant Brompton William     Brompton, William 10
5207900 2418041 2418041 defendant Goldyng William     Goldyng, William 11
5207901 2418041 2418041 defendant each of Kyngeston upon Hull   merchant   each of Kyngeston upon Hull, merchant 12

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