names

16 rows where case_id = 2030072

✎ 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
4014991 2030072 2030072 plaintiff Skynner Richard gent, attorney of the bench   Skynner, Richard, gent, attorney of the bench 0
4014992 2030072 2030072 defendant Baldwyn William husbandman 674647 674647 Baldwyn, William, of Waborne, husbandman 0
4014993 2030072 2030072 defendant Balkey John clerk 594982 594982 Balkey, John, of Byrcham, clerk 1
4014994 2030072 2030072 defendant Fuller Ralph butcher 602132 602132 Fuller, Ralph, of Cawston, butcher 2
4014995 2030072 2030072 defendant Austen John husbandman 674648 674648 Austen, John, of Newton juxta Horsforth, husbandman 3
4014996 2030072 2030072 defendant Spencer Henry gent 587283 587283 Spencer, Henry, of Honyngham, gent 4
4014997 2030072 2030072 defendant Waller John hatter 585936 585936 Waller, John, of Norwich, hatter 5
4014998 2030072 2030072 defendant Bacheler John husbandman 674649 674649 Bacheler, John, of Postwycke, husbandman 6
4014999 2030072 2030072 defendant Grygson Thomas mariner 588456 588456 Grygson, Thomas, of Yarmouth, mariner 7
4015000 2030072 2030072 defendant Dey Robert husbandman 591127 591127 Dey, Robert, of Elsyng, husbandman 8
4015001 2030072 2030072 defendant Elwyn John butcher 631033 631033 Elwyn, John, of Est Dereham, butcher 9
4015002 2030072 2030072 defendant Hodd Thomas butcher 596907 596907 Hodd, Thomas, of Ludham, butcher 10
4015003 2030072 2030072 defendant Crede James husbandman 602140 602140 Crede, James, of Wolterton, husbandman 11
4015004 2030072 2030072 defendant Arnold Thomas husbandman 674650 674650 Arnold, Thomas, of Bucnam Ferye, husbandman 12
4015005 2030072 2030072 defendant Murrell Thomas husbandman   Murrell, Thomas, husbandman 13
4015006 2030072 2030072 defendant Skerlett George husbandman 590061 590061 Skerlett, George, of Barton, husbandman 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);