names

15 rows where case_id = 1919020

✎ 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
3677523 1919020 1919020 plaintiff Lovell Thomas klnight, treasurer of the king's household   Lovell, Thomas, klnight, treasurer of the king's household 0
3677524 1919020 1919020 plaintiff Heron John treasurer of the chamber   Heron, John, treasurer of the chamber 1
3677525 1919020 1919020 defendant Willoughby Henry   609216 609216 Willoughby, Henry, of Wollaton, Warks, knight 0
3677526 1919020 1919020 defendant Seymour John   609217 609217 Seymour, John, of Wolsall, Wilts, knight 1
3677527 1919020 1919020 defendant Constable Robert   609218 609218 Constable, Robert, of Hothom, Yorks, knight 2
3677528 1919020 1919020 defendant Griffith Walter   609219 609219 Griffith, Walter, of Agnes Burton, Yorks, knight 3
3677529 1919020 1919020 defendant Cobham Thomas   585869 585869 Cobham, Thomas, of London, knight, Lord Cobham 4
3677530 1919020 1919020 defendant Wadham Nicholas Blundesdon, Wilts, knight   Wadham, Nicholas, Blundesdon, Wilts, knight 5
3677531 1919020 1919020 defendant Lysle John   609220 609220 Lysle, John, of Trukleston, Hants, knight 6
3677532 1919020 1919020 defendant Fetypace Thomas   606866 606866 Fetypace, Thomas, of Compton, Berks, knight 7
3677533 1919020 1919020 defendant Sand William   609221 609221 Sand, William, of la Vyne, Hants, knight 8
3677534 1919020 1919020 defendant Essex William   609955 609955 Essex, William, of Lamborn, Berks, knight 9
3677535 1919020 1919020 defendant Cokeyn Margaret widow 609223 609223 Cokeyn, Margaret, of Alington, Kent, widow 10
3677536 1919020 1919020 defendant Hill Richard gent 586255 586255 Hill, Richard, of Otford, Kent, gent 11
3677537 1919020 1919020 defendant Wyngfeld Richard gent 609224 609224 Wyngfeld, Richard, of Bonyngton, Kent, gent 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);