names

31 rows where place_id = 587690

✎ 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
3592156 1865166 1865166 defendant Okey Thomas husbandman 587690 587690 Okey, Thomas, of Frampton on Severne, husbandman 0
3592157 1865166 1865166 defendant Hill John tucker 587690 587690 Hill, John, of Frampton on Severne, tucker 1
3597342 1866787 1866787 defendant Vaughan John weaver 587690 587690 Vaughan, John, of Frampton on Severne, weaver 0
3617622 1873133 1873133 defendant Obey Thomas husbandman 587690 587690 Obey, Thomas, of Frampton on Severne, husbandman 0
3683287 1920895 1920895 defendant Staple Robert fuller 587690 587690 Staple, Robert, of Frampton on Severne, fuller 0
3742062 1939384 1939384 defendant Bougham John husbandman 587690 587690 Bougham, John, of Frampton on Severne, husbandman 0
3742064 1939385 1939385 defendant Boughan John husbandman 587690 587690 Boughan, John, of Frampton on Severne, husbandman 0
3828049 1966639 1966639 defendant Sutler Richard yeoman 587690 587690 Sutler, Richard, of Frampton on Severne, yeoman 1
3916007 1995739 1995739 defendant Davys Richard husbandman 587690 587690 Davys, Richard, of Frampton on Severne, husbandman 0
3920999 1997371 1997371 defendant Bayly John husbandman 587690 587690 Bayly, John, of Frampton on Severne, husbandman 0
4002653 2025719 2025719 defendant Adys John yeoman 587690 587690 Adys, John, of Frampton on Severne, yeoman 0
4002654 2025719 2025719 defendant Lewes Thomas husbandman 587690 587690 Lewes, Thomas, of Frampton on Severne, husbandman 1
4027862 2034613 2034613 plaintiff Codington Giles gent 587690 587690 Codington, Giles, of Frampton on Severne, gent 0
4397716 2163814 2163814 defendant Addysse John gent 587690 587690 Addysse, John, of Frampton on Severne, gent 0
4397717 2163814 2163814 defendant Bense Edward innholder 587690 587690 Bense, Edward, of Frampton on Severne, innholder 1
4600138 2231267 2231267 defendant Hatherley Walter chaplain 587690 587690 Hatherley, Walter, of Frampton on Severne, chaplain 0
4887094 2322804 2322804 defendant Northern John husbandman 587690 587690 Northern, John, of Frampton on Severne, husbandman 3
5029669 2365547 2365547 defendant Pryde John yeoman 587690 587690 Pryde, John, of Frampton on Severne, yeoman 1
5031585 2366101 2366101 defendant Horner John, junior   587690 587690 Horner, John, junior, of Frampton on Severne 0
5242654 2428062 2428062 defendant Coke William, junior yeoman 587690 587690 Coke, William, junior, of Frampton on Severne, yeoman 0
5242655 2428062 2428062 defendant Coke John yeoman 587690 587690 Coke, John, of Frampton on Severne, yeoman 1
5242656 2428062 2428062 defendant Doppyng John yeoman 587690 587690 Doppyng, John, of Frampton on Severne, yeoman 2
5339751 2457008 2457008 defendant Hochyns Thomas, senior husbandman 587690 587690 Hochyns, Thomas, senior, of Frampton on Severne, husbandman 0
5339752 2457008 2457008 defendant Hochyns Thomas, junior husbandman 587690 587690 Hochyns, Thomas, junior, of Frampton on Severne, husbandman 1
5572514 2526502 2526502 defendant Smyth Henry (legal representative) 587690 587690 Smyth, Henry, of Frampton on Severne, yeoman, executors of 0
5572515 2526502 2526502 defendant Lawnder Thomas yeoman 587690 587690 (Lawnder, Thomas, of Frampton on Severne, yeoman 1
5572526 2526507 2526507 defendant Smyth Henry (legal representative) 587690 587690 Smyth, Henry, of Frampton on Severne, yeoman, executors of 0
5572527 2526507 2526507 defendant Lawnder Thomas yeoman 587690 587690 (Lawnder, Thomas, of Frampton on Severne, yeoman 1
5573632 2526854 2526854 defendant Cokkys John husbandman 587690 587690 Cokkys, John, of Frampton on Severne, husbandman 0
5580325 2528928 2528928 defendant Smyth John yeoman 587690 587690 Smyth, John, of Frampton on Severne, yeoman 3
5606874 2537039 2537039 defendant Sotteler William yeoman 587690 587690 Sotteler, William, of Frampton on Severne, yeoman 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);