names

21 rows where case_id = 2401091

✎ 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
5149850 2401091 2401091 plaintiff Eure Ralph esq   Eure, Ralph, esq 0
5149851 2401091 2401091 defendant Dalton Thomas esq 830005 830005 Dalton, Thomas, of Kyrkeby Mysperton, esq 0
5149852 2401091 2401091 defendant Dalton John tiler 830005 830005 together with Dalton, John, of Kyrkeby Mysperton, tiler 1
5149853 2401091 2401091 defendant Clerk Thomas   830005 830005 Clerk, Thomas, of Kyrkeby Mysperton, parish clerk 2
5149854 2401091 2401091 defendant Clerk John yeoman 830005 830005 Clerk, John, of Kyrkeby Mysperton, servant of William Barker, of New Malton, yeoman 3
5149855 2401091 2401091 defendant Parou John smith 591382 591382 Parou, John, of New Malton, smith 4
5149856 2401091 2401091 defendant Hunt John panyer man 591382 591382 Hunt, John, of New Malton, panyer man 5
5149857 2401091 2401091 defendant Mason Edmund tailor 593427 593427 Mason, Edmund, of Old Malton, tailor 6
5149858 2401091 2401091 defendant Warde John yeoman 755342 755342 Warde, John, of Wellum, yeoman 7
5149859 2401091 2401091 defendant Hall John shoemaker 587727 587727 Hall, John, of Pykeryng, shoemaker 8
5149860 2401091 2401091 defendant West William forester 587727 587727 West, William, of Pykeryng, forester 9
5149861 2401091 2401091 defendant Colt John sawyer 587727 587727 Colt, John, of Pykeryng, sawyer 10
5149862 2401091 2401091 defendant Dodmor Henry laborer 587727 587727 Dodmor, Henry, of Pykeryng, laborer 11
5149863 2401091 2401091 defendant Semer Thomas milner   Semer, Thomas, milner 12
5149864 2401091 2401091 defendant Fyssher Richard panyer man   Fyssher, Richard, panyer man 13
5149865 2401091 2401091 defendant Taillour John tailor   Taillour, John, tailor 14
5149866 2401091 2401091 defendant Taillour William tailor   Taillour, William, tailor 15
5149867 2401091 2401091 defendant Dauson Lawrence laborer   Dauson, Lawrence, laborer 16
5149868 2401091 2401091 defendant Day Thomas miller   Day, Thomas, miller 17
5149869 2401091 2401091 defendant Kirkeby John yeoman 853389 853389 Kirkeby, John, of Thornton, in Pykerynglith, yeoman 18
5149870 2401091 2401091 defendant Boterler Alexander weaver 853389 853389 Boterler, Alexander, of Thornton, in Pykerynglith, weaver 19

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