names

15 rows where case_id = 2529962

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5583650 2529962 2529962 plaintiff Gell John     Gell, John 0
5583651 2529962 2529962 defendant Chetyll Thomas miner 770861 770861 Chetyll, Thomas, of Wykesworth, miner 0
5583652 2529962 2529962 defendant Beyghton Richard butcher 770861 770861 Beyghton, Richard, of Wykesworth, butcher 1
5583653 2529962 2529962 defendant Somer Christopher butcher 770861 770861 Somer, Christopher, of Wykesworth, butcher 2
5583654 2529962 2529962 defendant Hill Geoffrey miner 770861 770861 Hill, Geoffrey, of Wykesworth, miner 3
5583655 2529962 2529962 defendant Nowton Thomas tailor 770861 770861 Nowton, Thomas, of Wykesworth, tailor 4
5583656 2529962 2529962 defendant Alsop Robert husbandman 600385 600385 Alsop, Robert, of Alderwaslee, husbandman 5
5583657 2529962 2529962 defendant Marsshe William miner 598843 598843 Marsshe, William, of Bonsale, miner 6
5583658 2529962 2529962 defendant Hallem Ralph miner 598843 598843 Hallem Ralph, of Bonsale, miner 7
5583659 2529962 2529962 defendant Wollowe John miner 598843 598843 Wollowe, John, of Bonsale, miner 8
5583660 2529962 2529962 defendant Oliver John miner 770861 770861 Oliver, John, of Wykesworth, miner 9
5583661 2529962 2529962 defendant Wodwysse William miner 591263 591263 Wodwysse, William, of Cromford, miner 10
5583662 2529962 2529962 defendant Smyth Thomas miner 638994 638994 Smyth, Thomas, of Carsyngton, miner 11
5583663 2529962 2529962 defendant Stere Edward miner 593361 593361 Stere, Edward, of Derley, miner 12
5583664 2529962 2529962 defendant Sellers William miner 902769 902769 Sellers, William, of Spondan, miner 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);