names

18 rows where case_id = 2030071

✎ 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
4014973 2030071 2030071 plaintiff Skynner Richard gent, attorney of the bench   Skynner, Richard, gent, attorney of the bench 0
4014974 2030071 2030071 defendant Angwishe Edmund mercer 674641 674641 Angwishe, Edmund, of Horsforth St Faith , mercer 0
4014975 2030071 2030071 defendant Davy Nicholas clerk 674642 674642 Davy, Nicholas, of Hadesco, clerk 1
4014976 2030071 2030071 defendant Adamson Robert clerk 593923 593923 Adamson, Robert, of Saxthorp, clerk 2
4014977 2030071 2030071 defendant Smyth William husbandman 618355 618355 Smyth, William, of Glamford, husbandman 3
4014978 2030071 2030071 defendant Gavell Roger clerk 641716 641716 Gavell, Roger, of Edgefeld, clerk 4
4014979 2030071 2030071 defendant Byllyngforth Thomas gent 586459 586459 Byllyngforth, Thomas, of Stoke, gent 5
4014980 2030071 2030071 defendant Rede Francis gent 599856 599856 Rede, Francis, of Beccles, Suff, gent 6
4014981 2030071 2030071 defendant Buttrey George tailor 585936 585936 Buttrey, George, of Norwich, tailor 7
4014982 2030071 2030071 defendant Cantrell Henry gent 594982 594982 Cantrell, Henry, of Byrcham, gent 8
4014983 2030071 2030071 defendant Bacon William gent 599088 599088 Bacon, William, of Thornage, gent 9
4014984 2030071 2030071 defendant Palmer William warrener 628427 628427 Palmer, William, of Horsforth, warrener 10
4014985 2030071 2030071 defendant Turpyn John husbandman 674643 674643 Turpyn, John, of Cosyn, husbandman 11
4014986 2030071 2030071 defendant Adams Robert husbandman 671385 671385 Adams, Robert, of Hackford, husbandman 12
4014987 2030071 2030071 defendant Wylson Anthony yeoman 674644 674644 Wylson, Anthony, of Rackey, yeoman 13
4014988 2030071 2030071 defendant Pyle Robert husbandman 600634 600634 Pyle, Robert, of Reppes, husbandman 14
4014989 2030071 2030071 defendant Monforth John husbandman 674645 674645 Monforth, John, of Owkey, husbandman 15
4014990 2030071 2030071 defendant Bacheler William husbandman 674646 674646 Bacheler, William, of Wyckhampton, husbandman 16

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