names

22 rows where case_id = 1930414

✎ 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
3713078 1930414 1930414 plaintiff Wyndesore Andrew knight   Wyndesore, Andrew, knight 0
3713079 1930414 1930414 defendant Myll William gent 616182 616182 Myll, William, of Gretham, gent 0
3713080 1930414 1930414 defendant Appysley William, senior gent 613661 613661 Appysley, William, senior, of Amberley, gent 1
3713081 1930414 1930414 defendant Broker Thomas tanner 596605 596605 Broker, Thomas, of Parham, tanner 2
3713082 1930414 1930414 defendant Charilman Robert husbandman 616182 616182 Charilman, Robert, of Gretham, husbandman 3
3713083 1930414 1930414 defendant Charilman Henry husbandman 616182 616182 Charilman, Henry, of Gretham, husbandman 4
3713084 1930414 1930414 defendant Broker Robert tanner 596605 596605 Broker, Robert, of Parham, tanner 5
3713085 1930414 1930414 defendant Smyth Gabriel tanner 596605 596605 Smyth, Gabriel, of Parham, tanner 6
3713086 1930414 1930414 defendant Smyth Richard tanner 596605 596605 Smyth, Richard, of Parham, tanner 7
3713087 1930414 1930414 defendant Bacheler Henry husbandman 596605 596605 Bacheler, Henry, of Parham, husbandman 8
3713088 1930414 1930414 defendant Duke Edmund husbandman 596605 596605 Duke, Edmund, of Parham, husbandman 9
3713089 1930414 1930414 defendant Duke Edward, junior husbandman 596605 596605 Duke, Edward, junior, of Parham, husbandman 10
3713090 1930414 1930414 defendant Duke John, senior husbandman 616183 616183 Duke, John, senior, of Rekham, husbandman 11
3713091 1930414 1930414 defendant Wyker Richard husbandman 596605 596605 Wyker, Richard, of Parham, husbandman 12
3713092 1930414 1930414 defendant Morrell Richard carpenter 616184 616184 Morrell, Richard, of Weygonholt, carpenter 13
3713093 1930414 1930414 defendant Scutte John husbandman 616185 616185 Scutte, John, of Weygenholt, husbandman 14
3713094 1930414 1930414 defendant Patche Edward husbandman 609479 609479 Patche, Edward, of Thakam, husbandman 15
3713095 1930414 1930414 defendant Laurence John husbandman 609479 609479 Laurence, John, of Thakam, husbandman 16
3713096 1930414 1930414 defendant Sterte William smith 616186 616186 Sterte, William, of Storyton, smith 17
3713097 1930414 1930414 defendant Eston William smith 616186 616186 Eston, William, of Storyton, smith 18
3713098 1930414 1930414 defendant Mare William husbandman 616186 616186 Mare, William, of Storyton, husbandman 19
3713099 1930414 1930414 defendant Chapham Richard husbandman 616187 616187 Chapham, Richard, of Hurston, Storyton, husbandman 20

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