names

16 rows where case_id = 2482879

✎ 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
5426516 2482879 2482879 plaintiff Crouche William     Crouche, William, on his own account 0
5426517 2482879 2482879 defendant Gloys John yeoman 602634 602634 Gloys, John, of Wyghton, Norf, yeoman 0
5426518 2482879 2482879 defendant Pakke George yeoman 598667 598667 Pakke, George, of Bedyngfeld, yeoman 1
5426519 2482879 2482879 defendant Clerk Robert husbandman 591336 591336 Clerk, Robert, of Asshefeld, husbandman 2
5426520 2482879 2482879 defendant Dey John weaver 586912 586912 Dey, John, of Melford, weaver 3
5426521 2482879 2482879 defendant Bert Thomas yeoman 883783 883783 together with Bert, Thomas, of Wattlysfeld, yeoman 4
5426522 2482879 2482879 defendant Teryngton Robert yeoman 586587 586587 Teryngton, Robert, of Rekynghale Inferior, yeoman 5
5426523 2482879 2482879 defendant Umfrey George yeoman 590853 590853 Umfrey, George, of Ratlesden, yeoman 6
5426524 2482879 2482879 defendant Caudeler John butcher 590853 590853 Caudeler, John, of Ratlesden, butcher 7
5426525 2482879 2482879 defendant Sesull John smith 590853 590853 Sesull, John, of Ratlesden, smith 8
5426526 2482879 2482879 defendant Darlee John yeoman 643453 643453 Darlee, John, of Leygham, yeoman 9
5426527 2482879 2482879 defendant Wymbyll John yeoman 586346 586346 Wymbyll, John, of Langham, yeoman 10
5426528 2482879 2482879 defendant Laurens John yeoman 592171 592171 together with Laurens, John, of Rumburgh, yeoman 11
5426529 2482879 2482879 defendant Tempell John   592596 592596 Tempell, John, of Kentford, pedlar 12
5426530 2482879 2482879 defendant Skeet William yeoman 585947 585947 Skeet, William, of Hadley, yeoman 13
5426531 2482879 2482879 defendant Baret William yeoman 586180 586180 together with Baret, William, of Bury St Edmunds, 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);