names

35 rows where place_id = 600122

✎ 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
3639783 1907253 1907253 defendant Robuk Robert husbandman 600122 600122 Robuk, Robert, of Wentworth, husbandman 0
3706843 1928427 1928427 defendant Key Edmund husbandman 600122 600122 Key, Edmund, of Wentworth, husbandman 0
3721227 1932941 1932941 defendant Wentworth Thomas esq 600122 600122 Wentworth, Thomas, of Wentworth, esq 1
3727575 1934906 1934906 plaintiff Wentworth Thomas esq 600122 600122 Wentworth, Thomas, of Wentworth, esq 0
3755281 1943606 1943606 plaintiff Wentworth Thomas esq 600122 600122 Wentworth, Thomas, of Wentworth, esq 0
3800226 1957990 1957990 defendant Sclater Thomas weaver 600122 600122 Sclater, Thomas, of Wentworth, weaver 5
3800227 1957990 1957990 defendant Owleley Thomas collier 600122 600122 Owleley, Thomas, of Wentworth, collier 6
3806861 1960053 1960053 defendant Wyles William laborer 600122 600122 Wyles, William, of Wentworth, laborer 0
3824547 1965551 1965551 plaintiff Wentworth Thomas esq 600122 600122 Wentworth, Thomas, of Wentworth, esq 0
3883886 1984882 1984882 defendant Hawslyn Thomas yeoman 600122 600122 Hawslyn, Thomas, of Wentworth, yeoman 0
3883888 1984882 1984882 defendant Alott John (legal representative) 600122 600122 Alott, John, of Wentworth, yeoman, administratrix of 2
3883889 1984882 1984882 defendant Alott Isabel widow 600122 600122 Alott, Isabel, of Wentworth, widow 3
3922981 1997995 1997995 defendant Adamson Richard laborer 600122 600122 Adamson, Richard, of Wentworth, laborer 0
3922984 1997995 1997995 defendant Berdselff John laborer 600122 600122 Berdselff, John, of Wentworth, laborer 3
3922985 1997995 1997995 defendant Illyngworth Reginald laborer 600122 600122 Illyngworth, Reginald, of Wentworth, laborer 4
3922989 1997996 1997996 defendant Nobyll Hugh laborer 600122 600122 Nobyll, Hugh, of Wentworth, laborer 0
4019815 2031816 2031816 plaintiff Wentworth Thomas esq 600122 600122 Wentworth, Thomas, of Wentworth, esq 0
4024635 2033488 2033488 defendant Hawslyn Humphrey yeoman 600122 600122 Hawslyn, Humphrey, of Wentworth, yeoman 7
4029751 2035280 2035280 plaintiff Denman Brian gent 600122 600122 Denman, Brian, of Wentworth, gent 0
4050869 2042752 2042752 plaintiff Wentworth Thomas esq 600122 600122 Wentworth, Thomas, of Wentworth, esq 0
4116675 2066260 2066260 plaintiff Wentworth Thomas esq 600122 600122 Wentworth Thomas, of Wentworth, esq 0
4118436 2066885 2066885 defendant Hyllynworth William laborer 600122 600122 Hyllynworth, William, of Wentworth, laborer 2
4138909 2074289 2074289 defendant Crowder Edward yeoman 600122 600122 Crowder, Edward, of Wentworth, yeoman 0
4176888 2087386 2087386 defendant Hawslyn Humphrey nailer 600122 600122 Hawslyn, Humphrey, of Wentworth, nailer 1
4229983 2105973 2105973 defendant Jessopp Brian yeoman 600122 600122 Jessopp, Brian, of Wentworth, or of Spittlehouse, yeoman 1
4714495 2269863 2269863 defendant Wentworth William de gent 600122 600122 Wentworth, William de, of Wentworth, gent 0
4773954 2287835 2287835 defendant Haweselyn William yeoman 600122 600122 Haweselyn, William, of Wentworth, yeoman 1
4773955 2287835 2287835 defendant Stode William yeoman 600122 600122 Stode, William, of Wentworth, yeoman 2
4865957 2316326 2316326 plaintiff Grene William   600122 600122 Grene, William, of Wentworth 0
4865963 2316327 2316327 plaintiff Grene William   600122 600122 Grene, William, of Wentworth 0
5099843 2386392 2386392 defendant Stede William yeoman 600122 600122 Stede, William, of Wentworth, yeoman 0
5099844 2386392 2386392 defendant Gre- William   600122 600122 Gre-, William, of Wentworth, board cleaver 1
5099846 2386392 2386392 defendant Horsley Richard laborer 600122 600122 Horsley, Richard, of Wentworth, laborer 3
5099847 2386392 2386392 defendant Seygnyour William slater 600122 600122 Seygnyour, William, of Wentworth, slater 4
5562550 2523647 2523647 defendant Axe Christopher collier 600122 600122 Axe, Christopher, of Wentworth, collier 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);