names

22 rows where place_id = 678114

✎ 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
4029908 2035340 2035340 defendant Hadderidge Thomas husbandman 678114 678114 Hadderidge, Thomas, of Dodington, husbandman 0
4040993 2039269 2039269 plaintiff Mountgomery William gent 678114 678114 Mountgomery, William, of Dodington, gent 0
4055477 2044355 2044355 defendant Blyncow Arthur yeoman 678114 678114 Blyncow, Arthur, of Dodington, yeoman 0
4055478 2044355 2044355 defendant Edmond John gent 678114 678114 Edmond, John, of Dodington, gent 1
4067812 2048800 2048800 defendant Chambers Robert husbandman 678114 678114 Chambers, Robert, of Dodington, husbandman 0
4133706 2072389 2072389 defendant Holwill alias Clarke Richard   678114 678114 Holwill alias Clarke, Richard, of Dodington, mason 1
4133707 2072389 2072389 defendant Thomas John, junior victualer 678114 678114 Thomas, John, junior, of Dodington, yeoman, victualer 2
4148515 2077608 2077608 defendant Olyver William yeoman 678114 678114 Olyver, William, of Dodington, yeoman 1
4148516 2077608 2077608 defendant Pryer William clerk 678114 678114 Pryer, William, of Dodington, clerk 2
4148517 2077608 2077608 defendant Cole John yeoman 678114 678114 Cole, John, of Dodington, yeoman 3
4212685 2099976 2099976 defendant Smyth Henry husbandman 678114 678114 Smyth, Henry, of Dodington, husbandman 0
4230787 2106267 2106267 defendant Maryott Henry clerk 678114 678114 Maryott, Henry, of Dodington, clerk 0
4257847 2115599 2115599 defendant Mariott Henry clerk 678114 678114 Mariott, Henry, of Dodington, clerk 0
4280482 2123082 2123082 defendant Osborne John gent 678114 678114 Osborne, John, of Dodington, gent 0
4284282 2124428 2124428 defendant Dodington Edward gent 678114 678114 Dodington, Edward, of Dodington, gent 3
4331275 2140757 2140757 defendant Osborne John gent 678114 678114 Osborne, John, of Dodington, gent 0
4348198 2146618 2146618 defendant Wiles Robert, senior yeoman 678114 678114 Wiles, Robert, senior, of Dodington, yeoman 0
4363153 2151887 2151887 defendant Batten Thomas husbandman 678114 678114 Batten, Thomas, of Dodington, husbandman 0
4382408 2158817 2158817 defendant Taylard Lawrence gent 678114 678114 Taylard, Lawrence, of Dodington, gent 0
4382409 2158817 2158817 defendant Reve Thomas husbandman 678114 678114 Reve, Thomas, of Dodington, husbandman 1
4389473 2161104 2161104 defendant Batten Thomas husbandman 678114 678114 Batten, Thomas, of Dodington, husbandman 0
4404438 2166051 2166051 defendant Thomas alias Butcher John weaver 678114 678114 Thomas alias Butcher, John, of Dodington, weaver 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);