names

14 rows where case_id = 1933164

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3722062 1933164 1933164 plaintiff Malyn John abbot of Waltham Holy Cross   Malyn, John, abbot of Waltham Holy Cross 0
3722063 1933164 1933164 defendant Foster Thomas yeoman 617950 617950 Foster, Thomas, of Endefylde, Middx, yeoman 0
3722064 1933164 1933164 defendant Maxfeld Robert yeoman 591239 591239 Maxfeld, Robert, of Hakeney, Middx, yeoman 1
3722065 1933164 1933164 defendant Gosnall John brewer 602940 602940 Gosnall, John, of Hakney, brewer 2
3722066 1933164 1933164 defendant Hedy John hakeneyman 587486 587486 Hedy, John, of Hakeney, hakeneyman 3
3722067 1933164 1933164 defendant Swete John husbandman 617951 617951 Swete, John, of Hekeney, husbandman 4
3722068 1933164 1933164 defendant Walker Clement husbandman 595206 595206 Walker, Clement, of Walcomstowe, husbandman 5
3722069 1933164 1933164 defendant Fotherley David showmaker 617952 617952 Fotherley, David, of Stratford Langford, showmaker 6
3722070 1933164 1933164 defendant Samon John innholder 617953 617953 Samon, John, of Waltham, Herts, innholder 7
3722071 1933164 1933164 defendant Sawtre Thomas, senior husbandman 587871 587871 Sawtre, Thomas, senior, of Waltham Holy Cross, husbandman 8
3722072 1933164 1933164 defendant Warbek John laborer 587871 587871 Warbek, John, of Waltham Holy Cross, laborer 9
3722073 1933164 1933164 defendant Watson George yeoman   Watson, George, yeoman 10
3722074 1933164 1933164 defendant Neuman Roger laborer   Neuman, Roger, laborer 11
3722075 1933164 1933164 defendant Grene William laborer   Grene, William, laborer 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);