names

12 rows where place_id = 608229

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3672745 1917482 1917482 defendant Iden John husbandman 608229 608229 Iden, John, of Norton, Norf, husbandman 1
3937742 2002956 2002956 defendant Cowle Christopher gent 608229 608229 Cowle, Christopher, of Norton, Norf, gent 0
4040445 2039074 2039074 defendant Benson Richard esq 608229 608229 Benson, Richard, of Norton, Norf, esq 0
4276816 2121820 2121820 defendant Bullock Thomas weaver 608229 608229 Bullock, Thomas, of Norton, Norf, weaver 2
4308590 2133155 2133155 defendant Bullock George yeoman 608229 608229 Bullock, George, of Norton, Norf, yeoman 1
4674288 2257566 2257566 defendant Carman Edmund yeoman 608229 608229 (Carman, Edmund, of Norton, Norf, yeoman 1
4836759 2307464 2307464 defendant Crane John esq 608229 608229 Crane, John, of Norton, Norf, esq 1
4836807 2307474 2307474 defendant Crane John esq 608229 608229 Crane, John, of Norton, Norf, esq 1
4857837 2313820 2313820 defendant Weston Alexander husbandman 608229 608229 Weston, Alexander, of Norton, Norf, husbandman 3
4941888 2339452 2339452 defendant Crane John esq 608229 608229 Crane, John, of Norton, Norf, esq 3
5001812 2357428 2357428 defendant Cole John husbandman 608229 608229 Cole, John, of Norton, Norf, husbandman 2
5564955 2524335 2524335 defendant Smyth Robert husbandman 608229 608229 Smyth, Robert, of Norton, Norf, husbandman 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);