names

15 rows where case_id = 2501113

✎ 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
5487345 2501113 2501113 plaintiff Symmes Richard, senior     Symmes, Richard, senior 0
5487346 2501113 2501113 defendant Notyngham John yeoman 593341 593341 Notyngham, John, of Northourom, yeoman 0
5487347 2501113 2501113 defendant Notyngham Brian yeoman 593341 593341 Notyngham, Brian, of Northourom, yeoman 1
5487348 2501113 2501113 defendant Turton George yeoman 592530 592530 Turton, George, of Thurleston, yeoman 2
5487349 2501113 2501113 defendant Swyft Robert husbandman 641372 641372 Swyft, Robert, of Penyston, husbandman 3
5487350 2501113 2501113 defendant Rodes John husbandman 806112 806112 Rodes, John, of Oxspryng, husbandman 4
5487351 2501113 2501113 defendant Brodehede John husbandman 892468 892468 Brodehede, John, of Langfyde, husbandman 5
5487352 2501113 2501113 defendant Jenkynson Richard husbandman 812898 812898 Jenkynson, Richard, of Thurgurland, husbandman 6
5487353 2501113 2501113 defendant South Robert yeoman 850042 850042 South, Robert, of Worteley, yeoman 7
5487354 2501113 2501113 defendant Birkes John husbandman 892469 892469 Birkes, John, of Tankeresley, husbandman 8
5487355 2501113 2501113 defendant Dipsie William husbandman 635910 635910 Dipsie, William, of Darton, husbandman 9
5487356 2501113 2501113 defendant Pynnyng William husbandman 597346 597346 Pynnyng, William, of Notton, husbandman 10
5487357 2501113 2501113 defendant Hemmyngway Robert, senior yeoman 892070 892070 Hemmyngway, Robert, senior, of Southourome, yeoman 11
5487358 2501113 2501113 defendant Brigge Henry yeoman 614313 614313 Brigge, Henry, of Brereley, yeoman 12
5487359 2501113 2501113 defendant Cuppill William yeoman 614313 614313 Cuppill, William, of Brereley, yeoman 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);