names

18 rows where case_id = 2478535

✎ 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
5411966 2478535 2478535 plaintiff Crouche William     Crouche, William, on his own account 0
5411967 2478535 2478535 defendant Gloys John   602634 602634 Gloys, John, of Wyghton, Norf 0
5411968 2478535 2478535 defendant Pakke George yeoman 598667 598667 Pakke, George, of Bedyngfeld, yeoman 1
5411969 2478535 2478535 defendant Clerk (illegible) husbandman 591336 591336 Clerk, _, of Asshefeld, husbandman 2
5411970 2478535 2478535 defendant Bert Thomas yeoman 881456 881456 Bert, Thomas, of Wattlisfeld, yeoman 3
5411971 2478535 2478535 defendant Day (illegible) weaver 586912 586912 Day, _, of Melford, weaver 4
5411972 2478535 2478535 defendant Teryngton Robert   586587 586587 Teryngton, Robert, of Rekynghale Inferior 5
5411973 2478535 2478535 defendant Umfrey George yeoman 587324 587324 Umfrey, George, of Ratlysden, yeoman 6
5411974 2478535 2478535 defendant Caudeler John butcher 590853 590853 Caudeler, John, of Ratlesden, butcher 7
5411975 2478535 2478535 defendant Sesull John husbandman 590853 590853 Sesull, John, of Ratlesden, husbandman 8
5411976 2478535 2478535 defendant Cursum (illegible) draper 585936 585936 Cursum, _, of Norwich, draper 9
5411977 2478535 2478535 defendant Revell Thomas smith 597809 597809 Revell, Thomas, of Wolpet, smith 10
5411978 2478535 2478535 defendant Darlee John yeoman 643453 643453 Darlee, John, of Leygham, yeoman 11
5411979 2478535 2478535 defendant Wymbyll John yeoman 586346 586346 Wymbyll, John, of Langham, yeoman 12
5411980 2478535 2478535 defendant Laurens John yeoman 592171 592171 Laurens, John, of Rumburgh, yeoman 13
5411981 2478535 2478535 defendant Tempell John   592596 592596 Tempell, John, of Kentford, pedlar 14
5411982 2478535 2478535 defendant Baret William yeoman 586180 586180 Baret, William, of Bury St Edmunds, yeoman 15
5411983 2478535 2478535 defendant Skeet William yeoman 585947 585947 Skeet, William, of Hadley, yeoman 16

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