names

15 rows where case_id = 1904328

✎ 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
3630308 1904328 1904328 plaintiff Ernley John     Ernley, John 0
3630309 1904328 1904328 defendant Edwardys John gent 597897 597897 Edwardys, John, of Oswestre, March of Wales, gent 0
3630310 1904328 1904328 defendant Burdon Thomas merchant of the staple   Burdon, Thomas, merchant of the staple, executrix of 1
3630311 1904328 1904328 defendant Burdon Rose widow 585869 585869 Burdon, Rose, of London, widow 2
3630312 1904328 1904328 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 3
3630313 1904328 1904328 defendant Baynham Alexander   614123 614123 Baynham, Alexander, of Wesbury, Glos, knight 4
3630314 1904328 1904328 defendant Conyers William   585869 585869 Conyers, William, of London, knight, Lord Conyers 5
3630315 1904328 1904328 defendant Bulmer William   643352 643352 Bulmer, William, of Wylton, Yorks, knight 6
3630316 1904328 1904328 defendant FitzWilliam Thomas gent 597902 597902 FitzWilliam, Thomas, of Horncastell, Lincs, gent 7
3630317 1904328 1904328 defendant Heron Roger gent 597903 597903 Heron, Roger, of Meldon, Northumb, gent 8
3630318 1904328 1904328 defendant Strodder Richard gent 597904 597904 Strodder, Richard, of Dudden, Northumb, gent 9
3630319 1904328 1904328 defendant Lysby William gent 597905 597905 Lysby, William, of Thornton, Northumb, gent 10
3630320 1904328 1904328 defendant (not given)   abbot of St Peters Abbey, Gloucester   St Peters Abbey, Gloucester, abbot of 11
3630321 1904328 1904328 defendant Bardney Richard abbot of Croyland Abbey   Bardney, Richard, abbot of Croyland Abbey 12
3630322 1904328 1904328 defendant (not given)   abbot of Wygmore Abbey   Wygmore Abbey, abbot of 13

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