names

14 rows where case_id = 2435985

✎ 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
5268774 2435985 2435985 plaintiff Brampton Thomas     Brampton, Thomas, on his own account 0
5268775 2435985 2435985 defendant Bysshop Nicholas yeoman 586940 586940 Bysshop, Nicholas, of Baldeswell, yeoman 0
5268776 2435985 2435985 defendant Yareham of Hyderston carpenter   Yareham, of Hyderston, carpenter 1
5268777 2435985 2435985 defendant Walter Richard butcher 586365 586365 Walter, Richard, of Wymondham, butcher 2
5268778 2435985 2435985 defendant Tegge William husbandman 621233 621233 Tegge, William, of Harsham, husbandman 3
5268779 2435985 2435985 defendant Wylde William shoemaker 586471 586471 Wylde, William, of Aylesham, shoemaker 4
5268780 2435985 2435985 defendant Neyton John husbandman 588845 588845 Neyton, John, of Grymston, husbandman 5
5268781 2435985 2435985 defendant Patryk William yeoman 594501 594501 Patryk, William, of Harple, yeoman 6
5268782 2435985 2435985 defendant Fouldon Alexander   594501 594501 Fouldon, Alexander, of Harple, plough wright 7
5268783 2435985 2435985 defendant Plumbe John husbandman 587934 587934 Plumbe, John, of Hylberworth, husbandman 8
5268784 2435985 2435985 defendant Mychell Henry husbandman 587934 587934 Mychell, Henry, of Hylberworth, husbandman 9
5268785 2435985 2435985 defendant Galt William husbandman 586877 586877 Galt, William, of Ranworth, husbandman 10
5268786 2435985 2435985 defendant Whytgowne William husbandman 588926 588926 Whytgowne, William, of North Elmham, husbandman 11
5268787 2435985 2435985 defendant Pyke Robert shoemaker 586102 586102 Pyke, Robert, of Hengham, shoemaker 12

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