names

17 rows where case_id = 2158551

✎ 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
4381664 2158551 2158551 plaintiff Wilson William     Wilson, William 0
4381665 2158551 2158551 defendant Wytham Ellen widow 709388 709388 Wytham, Ellen, of Ledston, widow 0
4381666 2158551 2158551 defendant Wytham Robert gent 709388 709388 Wytham, Robert, of Ledston, gent 1
4381667 2158551 2158551 defendant Wytham Henry gent 709388 709388 Wytham, Henry, of Ledston, gent 2
4381668 2158551 2158551 defendant Brere John yeoman 709388 709388 Brere, John, of Ledston, yeoman 3
4381669 2158551 2158551 defendant Sugden James yeoman 709388 709388 Sugden, James, of Ledston, yeoman 4
4381670 2158551 2158551 defendant Stilling James yeoman 709388 709388 Stilling, James, of Ledston, yeoman 5
4381671 2158551 2158551 defendant Burman Thomas husbandman 741298 741298 Burman, Thomas, of Ledsham, husbandman 6
4381672 2158551 2158551 defendant Arthington Robert husbandman 741298 741298 Arthington, Robert, of Ledsham, husbandman 7
4381673 2158551 2158551 defendant Wilburne John husbandman 741298 741298 Wilburne, John, of Ledsham, husbandman 8
4381674 2158551 2158551 defendant Hunter John husbandman 741298 741298 Hunter, John, of Ledsham, husbandman 9
4381675 2158551 2158551 defendant Gillyam Robert husbandman 741298 741298 Gillyam, Robert, of Ledsham, husbandman 10
4381676 2158551 2158551 defendant Belhouse William husbandman 741298 741298 Belhouse, William, of Ledsham, husbandman 11
4381677 2158551 2158551 defendant Wilburne Robert husbandman 741298 741298 Wilburne, Robert, of Ledsham, husbandman 12
4381678 2158551 2158551 defendant Johnson Thomas husbandman 741298 741298 Johnson, Thomas, of Ledsham, husbandman 13
4381679 2158551 2158551 defendant Wilburne William husbandman 741298 741298 Wilburne, William, of Ledsham, husbandman 14
4381680 2158551 2158551 defendant Ashton Robert husbandman 741298 741298 Ashton, Robert, of Ledsham, husbandman 15

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