names

22 rows where place_id = 629054

✎ 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
3786043 1953426 1953426 defendant Lovell William clothier 629054 629054 Lovell, William, of Trobrigge, clothier 0
3823559 1965271 1965271 defendant Roffe John weaver 629054 629054 Roffe, John, of Trobrigge, weaver 0
4817310 2301505 2301505 defendant Wattys Thomas husbandman 629054 629054 Wattys, Thomas, of Trobrigge, husbandman 0
4870933 2317883 2317883 defendant William John weaver 629054 629054 William, John, of Trobrigge, weaver 0
4895401 2325225 2325225 defendant Lauraunce William chapman 629054 629054 Lauraunce, William, of Trobrigge, chapman 0
4898366 2326144 2326144 defendant Bocher John butcher 629054 629054 Bocher, John, of Trobrigge, butcher 3
5348494 2459670 2459670 defendant Dauntesey John gent 629054 629054 Dauntesey, John, of Trobrigge, gent 0
5348495 2459670 2459670 defendant Tanner Nicholas tanner 629054 629054 together with Tanner, Nicholas, of Trobrigge, tanner 1
5348496 2459670 2459670 defendant Touker John weaver 629054 629054 Touker, John, of Trobrigge, weaver 2
5348497 2459670 2459670 defendant Dale Richard tailor 629054 629054 Dale, Richard, of Trobrigge, tailor 3
5348498 2459670 2459670 defendant Trobelyn John weaver 629054 629054 Trobelyn, John, of Trobrigge, weaver 4
5348500 2459670 2459670 defendant Baker John baker 629054 629054 Baker, John, of Trobrigge, baker 6
5375860 2468041 2468041 plaintiff Renold William   629054 629054 Renold, William, of Trobrigge 1
5466333 2494869 2494869 defendant Wylcok William dyer 629054 629054 Wylcok, William, of Trobrigge, dyer 0
5491824 2502458 2502458 defendant Dauntesey Walter esq 629054 629054 Dauntesey, Walter, of Trobrigge, esq 0
5506659 2506997 2506997 defendant Dauntesey Walter esq 629054 629054 Dauntesey, Walter, of Trobrigge, esq 0
5530436 2514035 2514035 defendant Hall John gent 629054 629054 Hall, John, of Trobrigge, gent 0
5530438 2514035 2514035 defendant Taillour Thomas tailor 629054 629054 Taillour, Thomas, of Trobrigge, tailor 2
5581179 2529181 2529181 defendant Grevyll John weaver 629054 629054 Grevyll, John, of Trobrigge, weaver 0
5606648 2536961 2536961 defendant Kyttys Edmund husbandman 629054 629054 Kyttys, Edmund, of Trobrigge, husbandman 0
5606649 2536961 2536961 defendant Faryngton John tailor 629054 629054 Faryngton, John, of Trobrigge, tailor 1
5606650 2536961 2536961 defendant Covyn John shoemaker 629054 629054 Covyn, John, of Trobrigge, shoemaker 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);