names

20 rows where place_id = 608901

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3676004 1918532 1918532 defendant Judson John weaver 608901 608901 Judson, John, of Esyngwold, weaver 0
3906626 1992509 1992509 defendant Letheley Thomas yeoman 608901 608901 Letheley, Thomas, of Esyngwold, yeoman 0
3996807 2023624 2023624 defendant Froste Richard laborer 608901 608901 Froste, Richard, of Esyngwold, laborer 0
4475649 2193065 2193065 defendant Huddeson John   608901 608901 Huddeson, John, of Esyngwold, son of Roger 5
4533805 2210839 2210839 defendant Attekynson Richard   608901 608901 Attekynson, Richard, of Esyngwold 0
4549158 2215673 2215673 defendant del Brigge John tailor 608901 608901 del Brigge, John, of Esyngwold, tailor 0
4835968 2307231 2307231 defendant Hoggeson John yeoman 608901 608901 Hoggeson, John, of Esyngwold, yeoman 1
4849578 2311343 2311343 defendant Barker John tanner 608901 608901 Barker, John, of Esyngwold, tanner 1
4911234 2330019 2330019 defendant HIlton John   608901 608901 HIlton, John, of Esyngwold, vicar 13
4945947 2340718 2340718 defendant Wyldon William husbandman 608901 608901 Wyldon, William, of Esyngwold, husbandman 0
5041950 2369192 2369192 plaintiff Coupar William   608901 608901 Coupar, William, of Esyngwold 0
5287081 2441233 2441233 defendant Chase Thomas gent 608901 608901 Chase, Thomas, of Esyngwold, gent 1
5306116 2446818 2446818 defendant Esyngwold John gent 608901 608901 Esyngwold, John, of Esyngwold, formerly of Newerk, Notts, gent 1
5403959 2476204 2476204 defendant Barkesworth John gent 608901 608901 (Barkesworth, John, of Esyngwold, gent 1
5537792 2516308 2516308 defendant Cateryk William clerk 608901 608901 Cateryk, William, of Esyngwold, clerk 0
5602987 2535820 2535820 defendant Penkney Robert yeoman 608901 608901 Penkney, Robert, of Esyngwold, yeoman 3
5602988 2535820 2535820 defendant Lethley Robert yeoman 608901 608901 Lethley, Robert, of Esyngwold, yeoman 4
5602989 2535820 2535820 defendant Derby Hugh yeoman 608901 608901 Derby, Hugh, of Esyngwold, yeoman 5
5602990 2535820 2535820 defendant Cundall Richard yeoman 608901 608901 Cundall, Richard, of Esyngwold, yeoman 6
5636671 2555414 2555414 defendant Nelson Thomas husbandman 608901 608901 Nelson, Thomas, of Esyngwold, husbandman 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);