names

21 rows where place_id = 593246

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611049 1871132 1871132 defendant Bothe John gent 593246 593246 Bothe, John, of Staley, gent 7
3617331 1873044 1873044 defendant Bothe John gent 593246 593246 Bothe, John, of Staley, gent 1
3617338 1873045 1873045 defendant Bothe John gent 593246 593246 Bothe, John, of Staley, gent 1
3630485 1904366 1904366 defendant Stanshall William husbandman 593246 593246 Stanshall, William, of Staley, husbandman 3
3630487 1904366 1904366 defendant Stanshall Thomas husbandman 593246 593246 Stanshall, Thomas, of Staley, husbandman 5
3872448 1981009 1981009 defendant Bakwell John chaplain 593246 593246 Bakwell, John, of Staley, chaplain 0
3909807 1993588 1993588 defendant Bromehed Thomas clerk 593246 593246 Bromehed, Thomas, of Staley, clerk 0
3943687 2004905 2004905 defendant Ellys John husbandman 593246 593246 Ellys, John, of Staley, husbandman 1
4309091 2133335 2133335 defendant Turner Thomas yeoman 593246 593246 Turner, Thomas, of Staley, yeoman 0
4323194 2138172 2138172 defendant Turner Thomas yeoman 593246 593246 Turner, Thomas, of Staley, yeoman 0
4960026 2344964 2344964 defendant Wright William husbandman 593246 593246 Wright, William, of Staley, husbandman 0
4971836 2348506 2348506 defendant Holyngworth John, junior   593246 593246 Holyngworth, John, junior, of Staley, franklin 0
5032375 2366347 2366347 defendant Hanson Richard husbandman 593246 593246 Hanson, Richard, of Staley, husbandman 2
5087150 2382622 2382622 defendant Callall Richard chaplain 593246 593246 Callall, Richard, of Staley, chaplain 0
5087151 2382622 2382622 defendant Parker John   593246 593246 Parker, John, of Staley, wheelwright 1
5087152 2382622 2382622 defendant Marten Richard husbandman 593246 593246 Marten, Richard, of Staley, husbandman 2
5087154 2382623 2382623 defendant Callall Richard chaplain 593246 593246 Callall, Richard, of Staley, chaplain 0
5087155 2382623 2382623 defendant Parker John   593246 593246 Parker, John, of Staley, wheelwright 1
5087156 2382623 2382623 defendant Marten Richard husbandman 593246 593246 Marten, Richard, of Staley, husbandman 2
5629395 2553177 2553177 defendant Gescok John butcher 593246 593246 Gescok, John, of Staley, butcher 0
5629396 2553177 2553177 defendant Bocher Richard butcher 593246 593246 Bocher, Richard, of Staley, butcher 1

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