names

18 rows where place_id = 656383

✎ 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
3803870 1959124 1959124 defendant Dygby John   656383 656383 Dygby, John, of Lubbenham, Leics, esq, son of Dygby, William 0
3940012 2003679 2003679 defendant Broke Henry esq 656383 656383 Broke, Henry, of Lubbenham, Leics, esq 1
3940015 2003680 2003680 defendant Broke Henry esq 656383 656383 Broke, Henry, of Lubbenham, Leics, esq 1
3945712 2005574 2005574 defendant Broke Roger esq 656383 656383 Broke, Roger, of Lubbenham, Leics, esq 0
3945715 2005575 2005575 defendant Broke Roger esq 656383 656383 Broke, Roger, of Lubbenham, Leics, esq 0
4111319 2064297 2064297 defendant Smyth William yeoman 656383 656383 Smyth, William, of Lubbenham, Leics, yeoman 0
4345958 2145848 2145848 defendant Hart Robert yeoman 656383 656383 Hart, Robert, of Lubbenham, Leics, yeoman 1
4377849 2157147 2157147 defendant Wade Edward yeoman 656383 656383 Wade, Edward, of Lubbenham, Leics, yeoman 0
4838742 2308043 2308043 defendant Isowede Thomas husbandman 656383 656383 Isowede, Thomas, of Lubbenham, Leics, husbandman 0
5107832 2388725 2388725 defendant Rolston William husbandman 656383 656383 Rolston, William, of Lubbenham,Leics, husbandman 1
5431756 2484465 2484465 defendant Perwych Richard esq 656383 656383 Perwych, Richard, of Lubbenham, Leics, esq 1
5448074 2489313 2489313 defendant Perdeyth Richard esq 656383 656383 Perdeyth, Richard, of Lubbenham, Leics, esq 1
5460476 2493075 2493075 defendant Perwyth Richard esq 656383 656383 Perwyth, Richard, of Lubbenham, Leics, esq 1
5472061 2496603 2496603 defendant Perwyth Richard esq 656383 656383 Perwyth, Richard, of Lubbenham, Leics, esq 1
5534358 2515282 2515282 defendant Perwyche Richard, junior gent 656383 656383 Perwyche, Richard, junior, of Lubbenham, Leics, gent 0
5543625 2518111 2518111 defendant Horneby John miller 656383 656383 Horneby, John, of Lubbenham, Leics, miller 0
5633524 2554479 2554479 defendant Perwych John esq 656383 656383 Perwych, John, of Lubbenham, Leics, esq 0
5633526 2554480 2554480 defendant Perwych John esq 656383 656383 Perwych, John, of Lubbenham, Leics, esq 0

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