names

22 rows where case_id = 1929800

✎ 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
3711148 1929800 1929800 plaintiff Strangways Giles knight   Strangways, Giles, knight 0
3711149 1929800 1929800 plaintiff Wylloughby Richard esq   Wylloughby, Richard, esq 1
3711150 1929800 1929800 plaintiff Wylloughby Nicholas esq   Wylloughby, Nicholas, esq 2
3711151 1929800 1929800 defendant Warman William husbandman 592519 592519 Warman, William, of Wyke, husbandman 0
3711152 1929800 1929800 defendant Jakson Geoffrey tailor 601610 601610 Jakson, Geoffrey, of Mylborn Porte, tailor 1
3711153 1929800 1929800 defendant Freman Reginald husbandman 601610 601610 Freman, Reginald, of Mylborn Porte, husbandman 2
3711154 1929800 1929800 defendant Brownyng John husbandman 601610 601610 Brownyng, John, of Mylborn Porte, husbandman 3
3711155 1929800 1929800 defendant Tanner Nicholas tanner 601610 601610 Tanner, Nicholas, of Mylborn Porte, tanner 4
3711156 1929800 1929800 defendant Pranker Thomas husbandman 601610 601610 Pranker, Thomas, of Mylborn Porte, husbandman 5
3711157 1929800 1929800 defendant Lodbroke William innholder 601610 601610 Lodbroke, William, of Mylborn Porte, innholder 6
3711158 1929800 1929800 defendant Elys John weaver 601610 601610 Elys, John, of Mylborn Porte, weaver 7
3711159 1929800 1929800 defendant White Richard laborer 601610 601610 White, Richard, of Mylborn Porte, laborer 8
3711160 1929800 1929800 defendant Leyseter Hugh laborer 601610 601610 Leyseter, Hugh, of Mylborn Porte, laborer 9
3711161 1929800 1929800 defendant Brownyng John laborer 601610 601610 Brownyng, John, of Mylborn Porte, laborer 10
3711162 1929800 1929800 defendant Togood John husbandman 601610 601610 Togood, John, of Mylborn Porte, husbandman 11
3711163 1929800 1929800 defendant Kneller Robert husbandman 601610 601610 Kneller, Robert, of Mylborn Porte, husbandman 12
3711164 1929800 1929800 defendant Hodder William butcher 601610 601610 Hodder, William, of Mylborn Porte, butcher 13
3711165 1929800 1929800 defendant Smyth Thomas smith 601610 601610 Smyth, Thomas, of Mylborn Porte, smith 14
3711166 1929800 1929800 defendant Dollyng Hugh husbandman 601610 601610 Dollyng, Hugh, of Mylborn Porte, husbandman 15
3711167 1929800 1929800 defendant Golbert Walter husbandman 601610 601610 Golbert, Walter, of Mylborn Porte, husbandman 16
3711168 1929800 1929800 defendant Heryot JOhn tanner 601610 601610 Heryot, JOhn, of Mylborn Porte, tanner 17
3711169 1929800 1929800 defendant Benet John laborer 601610 601610 Benet, John, of Mylborn Porte, laborer 18

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