names

21 rows where place_id = 767749

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4542786 2213632 2213632 defendant Walpole Roger   767749 767749 Walpole, Roger, of Hemgrave 0
4685111 2260945 2260945 defendant Payn Robert yeoman 767749 767749 Payn, Robert, of Hemgrave, yeoman 0
4777589 2288987 2288987 defendant Hethe Thomas esq 767749 767749 Hethe, Thomas, of Hemgrave, esq 0
4803150 2297179 2297179 defendant Hethe Thomas esq 767749 767749 Hethe, Thomas, of Hemgrave, esq 0
4889544 2323526 2323526 defendant Hethe Thomas esq 767749 767749 Hethe, Thomas,of Hemgrave, esq 1
4890443 2323779 2323779 defendant Fyssher Nicholas clerk 767749 767749 Fyssher, Nicholas, of Hemgrave, clerk 1
4890448 2323779 2323779 defendant Wysman John miller 767749 767749 Wysman, John, of Hemgrave, miller 6
4890449 2323779 2323779 defendant Wyseman William husbandman 767749 767749 Wyseman, William, of Hemgrave, husbandman 7
4890452 2323779 2323779 defendant Fysshere Edmund husbandman 767749 767749 Fysshere, Edmund, of Hemgrave, husbandman 10
4890453 2323779 2323779 defendant Fysshere Robert yeoman 767749 767749 Fysshere, Robert, of Hemgrave, yeoman 11
4891079 2323951 2323951 defendant Fyssher Nicholas clerk 767749 767749 Fyssher, Nicholas, of Hemgrave, clerk 1
4891084 2323951 2323951 defendant Wysman John miller 767749 767749 Wysman, John, of Hemgrave, miller 6
4891085 2323951 2323951 defendant Wyseman William husbandman 767749 767749 Wyseman, William, of Hemgrave, husbandman 7
4891088 2323951 2323951 defendant Fysshere Edmund husbandman 767749 767749 Fysshere, Edmund, of Hemgrave, husbandman 10
4891089 2323951 2323951 defendant Fysshere Robert yeoman 767749 767749 Fysshere, Robert, of Hemgrave, yeoman 11
4906460 2328608 2328608 defendant Fysshere Nicholas clerk 767749 767749 Fysshere, Nicholas, of Hemgrave, clerk 0
4937639 2338147 2338147 defendant Hethe Anne widow 767749 767749 Hethe, Anne, of Hemgrave, widow 1
4989245 2353718 2353718 defendant Trumyngdon Walter   767749 767749 (Trumyngdon, Walter, of Hemgrave, knight 1
5030447 2365777 2365777 defendant Trumpyngton Walter   767749 767749 Trumpyngton, Walter, of Hemgrave, knight 1
5250042 2430122 2430122 defendant Wyseman John husbandman 767749 767749 Wyseman, John, of Hemgrave, husbandman 1
5250047 2430123 2430123 defendant Wyseman John husbandman 767749 767749 Wyseman, John, of Hemgrave, husbandman 1

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