names

25 rows where place_id = 593147

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610688 1871009 1871009 defendant Sherley Edmund tailor 593147 593147 Sherley, Edmund, of Huntley, tailor 1
3692083 1923692 1923692 defendant Phippys John husbandman 593147 593147 Phippys, John, of Huntley, husbandman 4
3692084 1923692 1923692 defendant Phippys Richard husbandman 593147 593147 Phippys, Richard, of Huntley, husbandman 5
3751048 1942260 1942260 defendant Draper Thomas husbandman 593147 593147 Draper, Thomas, of Huntley, husbandman 3
3809745 1960937 1960937 defendant Robert John tailor 593147 593147 Robert, John, of Huntley, tailor 1
3888098 1986275 1986275 defendant Byrd John, senior yeoman 593147 593147 Byrd, John, senior, of Huntley, yeoman 1
3888099 1986275 1986275 defendant Byrd Philip, junior yeoman 593147 593147 Byrd, Philip, junior, of Huntley, yeoman 2
3897130 1989257 1989257 defendant Byrde John, senior yeoman 593147 593147 Byrde, John, senior, of Huntley, yeoman 0
3897145 1989262 1989262 defendant Haye William, junior yeoman 593147 593147 Haye, William, junior, of Huntley, yeoman 0
3897148 1989263 1989263 defendant Syngulton Christopher yeoman 593147 593147 Syngulton, Christopher, of Huntley, yeoman 0
3904909 1991901 1991901 defendant Hooper William laborer 593147 593147 Hooper, William, of Huntley, laborer 5
4035039 2037214 2037214 defendant Fowle William yeoman 593147 593147 Fowle, William, of Huntley, yeoman 0
4035727 2037453 2037453 defendant Fowle William yeoman 593147 593147 Fowle, William, of Huntley, yeoman 0
4082158 2053928 2053928 defendant Draper Thomas yeoman 593147 593147 Draper, Thomas, of Huntley, yeoman 0
4082159 2053928 2053928 defendant Draper John yeoman 593147 593147 Draper, John, of Huntley, yeoman 1
4087942 2055980 2055980 defendant Byrde John yeoman 593147 593147 Byrde, John, of Huntley, yeoman 0
4087943 2055980 2055980 defendant Baker Thomas yeoman 593147 593147 Baker, Thomas, of Huntley, yeoman 1
4177642 2087656 2087656 defendant Thorne John carrier 593147 593147 Thorne, John, of Huntley, carrier 0
4181667 2089073 2089073 defendant Byrde Thomas husbandman 593147 593147 Byrde, Thomas, of Huntley, husbandman 3
4208085 2098387 2098387 defendant Byrde Thomas collier 593147 593147 Byrde, Thomas, of Huntley, collier 0
4813267 2300264 2300264 plaintiff Hert John   593147 593147 Hert, John, of Huntley 0
4910255 2329722 2329722 defendant Boner or bover Geoffrey tailor 593147 593147 with Boner or bover, Geoffrey, of Huntley, tailor 1
5270879 2436580 2436580 defendant Bryd Thomas husbandman 593147 593147 Bryd, Thomas, of Huntley, husbandman 0
5278374 2438784 2438784 defendant Nursse Margery laborer 593147 593147 Nursse, Margery, of Huntley, laborer 1
5278376 2438784 2438784 defendant Belet Richard gent 593147 593147 Belet, Richard, of Huntley, gent 3

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