names

9 rows where case_id = 1931817

✎ 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
3717649 1931817 1931817 plaintiff Dyngell Richard   587058 587058 Dyngell, Richard, of Sutton 0
3717650 1931817 1931817 defendant Dyngell Richard husbandman 599394 599394 Dyngell, Richard, of Newland, husbandman 0
3717651 1931817 1931817 defendant Dyngell John husbandman 599394 599394 Dyngell, John, of Newland, husbandman 1
3717652 1931817 1931817 defendant Dyll Robert husbandman 617070 617070 Dyll, Robert, of Batternell, husbandman 2
3717653 1931817 1931817 defendant Greffre Robert husbandman 617071 617071 Greffre, Robert, of Batternell, Northhyll, husbandman 3
3717654 1931817 1931817 defendant Brode John husbandman 617072 617072 Brode, John, of Atknoll, husbandman 4
3717655 1931817 1931817 defendant Peers Richard laborer 617073 617073 Peers, Richard, of Kerradon, laborer 5
3717656 1931817 1931817 defendant Haydon William husbandman 617074 617074 Haydon, William, of Mansan, husbandman 6
3717657 1931817 1931817 defendant Robart William miller 617075 617075 Robart, William, of Rylle, miller 7

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