names

33 rows where place_id = 617451

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632768 1905063 1905063 defendant Guldeford Edward   617451 617451 Guldeford, Edward, of Halden, Kent, knight 0
3648289 1909864 1909864 defendant Guldford Edward   617451 617451 Guldford, Edward, of Halden, Kent, knight 1
3667949 1915916 1915916 defendant Gylford Edward   617451 617451 Gylford, Edward, of Halden, Kent, knight 0
3719612 1932401 1932401 plaintiff Harnden Richard clothman 617451 617451 Harnden, Richard, of Halden, Kent, clothman 0
3719614 1932402 1932402 plaintiff Harnden Richard clothman 617451 617451 Harnden, Richard, of Halden, Kent, clothman 0
3769950 1948258 1948258 defendant Guldeford Edward   617451 617451 Guldeford, Edward, of Halden, Kent, knight 0
3769960 1948261 1948261 defendant Guldeford Edward   617451 617451 Guldeford, Edward, of Halden, Kent, knight 0
3785775 1953340 1953340 defendant Deryng John gent 617451 617451 Deryng, John, of Halden, Kent, gent 1
3808252 1960454 1960454 defendant Gylford Edward   617451 617451 Gylford, Edward, of Halden, Kent, knight 1
3812283 1961737 1961737 defendant Guldeford Edward   617451 617451 Guldeford, Edward, of Halden, Kent, knight 1
3812364 1961759 1961759 defendant Guldeford Edward   617451 617451 Guldeford, Edward, of Halden, Kent, knight 0
3812367 1961760 1961760 defendant Guldeford Edward   617451 617451 Guldeford, Edward, of Halden, Kent, knight 0
3819300 1963923 1963923 defendant Guldeford Edward   617451 617451 Guldeford, Edward, of Halden, Kent, knight 1
3832648 1968137 1968137 defendant Baker Thomas clothier 617451 617451 Baker, Thomas, of Halden, Kent, clothier 3
3832656 1968138 1968138 defendant Martyn Thomas yeoman 617451 617451 Martyn, Thomas, of Halden, Kent, yeoman 3
3834240 1968651 1968651 defendant Guldeford Edward (legal representative) 617451 617451 Guldeford, Edward, of Halden, Kent, knight, executor of 0
3863618 1978019 1978019 defendant Scott Henry yeoman 617451 617451 Scott, Henry, of Halden, Kent, yeoman 2
4007832 2027582 2027582 defendant Meyny Anthony gent 617451 617451 Meyny, Anthony, of Halden, Kent, gent 0
4007844 2027585 2027585 defendant Nethersall George gent 617451 617451 Nethersall, George, of Halden, Kent, gent 0
4129343 2070798 2070798 defendant Cowcheman Jerome mercer 617451 617451 Cowcheman, Jerome, of Halden, Kent, mercer 2
4255889 2114945 2114945 defendant Taylor Robert yeoman 617451 617451 Taylor, Robert, of Halden, Kent, yeoman 2
4255893 2114946 2114946 defendant Taylor Robert yeoman 617451 617451 Taylor, Robert, of Halden, Kent, yeoman 2
4743873 2278736 2278736 defendant Hodyngfolde Richard husbandman 617451 617451 Hodyngfolde, Richard, of Halden, Kent, husbandman 0
4807085 2298414 2298414 defendant Hodyngfeld Richard husbandman 617451 617451 Hodyngfeld, Richard, of Halden, Kent, husbandman 1
4818897 2301996 2301996 defendant Hodyngfold Richard yeoman 617451 617451 Hodyngfold, Richard, of Halden, Kent, yeoman 1
4872975 2318505 2318505 defendant Hodyngfold Richard yeoman 617451 617451 Hodyngfold, Richard, of Halden, Kent, yeoman 2
4960709 2345162 2345162 defendant Harrys Thomas clothmaker 617451 617451 Harrys, Thomas, of Halden, Kent, clothmaker 0
4973289 2348948 2348948 defendant atte Hoope William   617451 617451 atte Hoope, William, of Halden, Kent, weaver, son of atte Hoope, Richard 2
5019808 2362674 2362674 defendant Harrys Thomas husbandman 617451 617451 Harrys, Thomas, of Halden, Kent, husbandman 3
5494932 2503383 2503383 defendant Brigge Richard mercer 617451 617451 Brigge, Richard, of Halden, Kent, mercer 1
5572618 2526536 2526536 defendant Guldeford Edward   617451 617451 Guldeford, Edward, of Halden, Kent, esq, son of Guldeford, Richard, knight 0
5577738 2528107 2528107 defendant Guldeford Edward esq 617451 617451 Guldeford, Edward, of Halden, Kent, esq 0
5602850 2535776 2535776 defendant Guldeford Edward   617451 617451 Guldeford, Edward, of Halden, Kent, esq, son of Guldeford, Richard, knight 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);