names

18 rows where case_id = 1934998

✎ 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
3727906 1934998 1934998 plaintiff Wisman John knight   Wisman, John, knight 0
3727907 1934998 1934998 plaintiff Heydon John knight   Heydon, John, knight 1
3727908 1934998 1934998 plaintiff Wyngfeld Anthony knight   Wyngfeld, Anthony, knight 2
3727909 1934998 1934998 plaintiff Hobard James esq   Hobard, James, esq 3
3727910 1934998 1934998 defendant Tyrell Thomas clerk 586589 586589 Tyrell, Thomas, of Gyslyngham, clerk 0
3727911 1934998 1934998 defendant Geffreson William clerk 586589 586589 Geffreson, William, of Gyslyngham, clerk 1
3727912 1934998 1934998 defendant Garrard John butcher 586589 586589 Garrard, John, of Gyslyngham, butcher 2
3727913 1934998 1934998 defendant Garrard Robert laborer 586589 586589 Garrard, Robert, of Gyslyngham, laborer 3
3727914 1934998 1934998 defendant Steynor Thomas stainer 586589 586589 Steynor, Thomas, of Gyslyngham, stainer 4
3727915 1934998 1934998 defendant Smyth Richard tiler 586589 586589 Smyth, Richard, of Gyslyngham, tiler 5
3727916 1934998 1934998 defendant Dey William laborer 586589 586589 Dey, William, of Gyslyngham, laborer 6
3727917 1934998 1934998 defendant Robynson William tailor 586589 586589 Robynson, William, of Gyslyngham, tailor 7
3727918 1934998 1934998 defendant Gryffyth Robert laborer 586589 586589 Gryffyth, Robert, of Gyslyngham, laborer 8
3727919 1934998 1934998 defendant Brett William smith 586589 586589 Brett, William, of Gyslyngham, smith 9
3727920 1934998 1934998 defendant Braxstrete Simon yeoman 612986 612986 Braxstrete, Simon, of Bodysdale, yeoman 10
3727921 1934998 1934998 defendant Gasyngton William yeoman 612986 612986 Gasyngton, William, of Bodysdale, yeoman 11
3727922 1934998 1934998 defendant Typshede Robert yeoman 612986 612986 Typshede, Robert, of Bodysdale, yeoman 12
3727923 1934998 1934998 defendant Tempylman Thomas laborer 606457 606457 Tempylman, Thomas, of Thorndon, laborer 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);