names

18 rows where place_id = 610736

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3684947 1921425 1921425 defendant Potte John yeoman 610736 610736 Potte, John, of Sawston, Cams, yeoman 2
3702734 1927127 1927127 defendant Holte William gent 610736 610736 Holte, William, of Sawston, Cams, gent 3
3710585 1929633 1929633 defendant Campyon Robert yeoman 610736 610736 Campyon, Robert, of Sawston, Cams, yeoman 2
3729952 1935621 1935621 defendant Sawston William husbandman 610736 610736 Sawston, William, of Sawston, Cams, husbandman 1
3743625 1939882 1939882 defendant Holt William   610736 610736 Holt, William, of Sawston, Cams 0
3758656 1944703 1944703 defendant Saweston William gent 610736 610736 Saweston, William, of Sawston, Cams, gent 0
3777671 1950764 1950764 defendant Daile John yeoman 610736 610736 Daile, John, of Sawston, Cams, yeoman 1
3777674 1950765 1950765 defendant Daile John yeoman 610736 610736 Daile, John, of Sawston, Cams, yeoman 0
3807557 1960272 1960272 defendant Dale John yeoman 610736 610736 Dale, John, of Sawston, Cams, yeoman 0
3807562 1960273 1960273 defendant Dale John   610736 610736 Dale, John, of Sawston, Cams, yeomen 0
3835803 1969121 1969121 defendant Lokton Robert esq 610736 610736 Lokton, Robert, of Sawston, Cams, esq 0
3889905 1986863 1986863 defendant Elys Thomas husbandman 610736 610736 Elys, Thomas, of Sawston, Cams, husbandman 0
3925668 1998899 1998899 plaintiff Wulwarde John yeoman 610736 610736 Wulwarde, John, of Sawston, Cams, yeoman 0
3984656 2019270 2019270 defendant Twyford Robert gent 610736 610736 Twyford, Robert, of Sawston, Cams, gent 0
3994611 2022821 2022821 defendant Twyford Robert gent 610736 610736 Twyford, Robert, of Sawston, Cams, gent 0
4037642 2038115 2038115 defendant Holte Arthur yeoman 610736 610736 Holte, Arthur, of Sawston, Cams, yeoman 0
4132714 2072024 2072024 defendant Water Robert bricklayer 610736 610736 Water, Robert, of Sawston, Cams, bricklayer 0
4228897 2105586 2105586 defendant Harryson Roland   610736 610736 Harryson, Roland, of Sawston, Cams, clacksmith 2

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