names

16 rows where case_id = 2016417

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3976669 2016417 2016417 plaintiff Kyme William gent   Kyme, William, gent 0
3976670 2016417 2016417 defendant Cawood John gent 585932 585932 Cawood, John, of Kingston on Hull, gent 0
3976671 2016417 2016417 defendant Bryan John gent 638888 638888 Bryan, John, of Bullyngbroke, Lincs, gent 1
3976672 2016417 2016417 defendant Dytton Thomas yeoman 586286 586286 Dytton, Thomas, of Boston, yeoman 2
3976673 2016417 2016417 defendant Furreby John shoemaker 610026 610026 Furreby, John, of Barrowe, Lincs, shoemaker 3
3976674 2016417 2016417 defendant Wyatson Lawrence husbandman 665380 665380 Wyatson, Lawrence, of Fryskeney, Loncs, husbandman 4
3976675 2016417 2016417 defendant Goggell Ancelm husbandman 665381 665381 Goggell, Ancelm, of Legborne, Lincs, husbandman 5
3976676 2016417 2016417 defendant Edmond Thomas yeoman 588081 588081 Edmond, Thomas, of Cambridge, yeoman 6
3976677 2016417 2016417 defendant Grene Philip yeoman 617865 617865 Grene, Philip, of Assheby, Lincs, yeoman 7
3976678 2016417 2016417 defendant Acred John yeoman 665382 665382 Acred, John, of Burrowe in the Marshe, Lincs, yeoman 8
3976679 2016417 2016417 defendant Broke Willima yeoman 626007 626007 Broke, Willima, of Conysby, Lincs, yeoman 9
3976680 2016417 2016417 defendant Caborne John Lincs, yeoman 587620 587620 Caborne John, of Saltfletby, Lincs, yeoman 10
3976681 2016417 2016417 defendant Wrenche James merchant 585869 585869 Wrenche, James, of London, merchant 11
3976682 2016417 2016417 defendant Kedby William yeoman 598296 598296 Kedby, William, of Spaldyng, Lincs, yeoman 12
3976683 2016417 2016417 defendant Gotesm William Lincs, yeoman 608362 608362 Gotesm William, of Borne, Lincs, yeoman 13
3976684 2016417 2016417 defendant Hartleye Thomas yeoman 621036 621036 Hartleye, Thomas, of Swynshed, Lincs, yeoman 14

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