names

38 rows where place_id = 593048

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610204 1870855 1870855 defendant Lavynder William clothier 593048 593048 Lavynder, William, of Pensford, Soms, clothier 0
3616561 1872814 1872814 defendant Preston John clothier 593048 593048 Preston, John, of Pensford, Soms, clothier 1
3616564 1872815 1872815 defendant Preston John clothier 593048 593048 Preston, John, of Pensford, Soms, clothier 1
3634550 1905609 1905609 defendant Launder William clothier 593048 593048 Launder, William, of Pensford, Soms, clothier 4
3634557 1905611 1905611 defendant Launder William clothier 593048 593048 Launder, William, of Pensford, Soms, clothier 1
3804248 1959261 1959261 defendant Peryn John yeoman 593048 593048 Peryn, John, of Pensford, Soms, yeoman 2
3881222 1983986 1983986 defendant Gage Richard yeoman 593048 593048 Gage, Richard, of Pensford, Soms, yeoman 0
3890535 1987094 1987094 defendant Tanner John tanner 593048 593048 Tanner, John, of Pensford, Soms, tanner 0
4086293 2055371 2055371 defendant Bysse William yeoman 593048 593048 Bysse, William, of Pensford, ,Soms, yeoman 0
4664908 2250504 2250504 defendant Forde John chapman 593048 593048 Forde, John, of Pensford, Soms, chapman 4
4735882 2276374 2276374 defendant Teste John husbandman 593048 593048 Teste, John, of Pensford, Soms, husbandman 0
4762447 2284239 2284239 defendant Blakemore William merchant 593048 593048 Blakemore, William, of Pensford, Soms, merchant 0
4779675 2289631 2289631 defendant Wattes John dyer 593048 593048 Wattes, John, of Pensford, Soms, dyer 1
4779678 2289632 2289632 defendant Wattes John dyer 593048 593048 Wattes, John, of Pensford, Soms, dyer 1
4873169 2318559 2318559 defendant Wattes John tucker 593048 593048 Wattes, John, of Pensford, Soms, tucker 0
4889139 2323392 2323392 defendant Estby John yeoman 593048 593048 Estby, John, of Pensford, Soms, yeoman 0
4899184 2326387 2326387 defendant Estby John yeoman 593048 593048 Estby, John, of Pensford, Soms, yeoman 0
4939837 2338849 2338849 defendant Estby John yeoman 593048 593048 Estby, John, of Pensford, Soms, yeoman 2
4954637 2343344 2343344 defendant Mabill John merchant 593048 593048 Mabill, John, of Pensford, Soms, merchant 1
4976532 2349940 2349940 defendant Selewode John   593048 593048 Selewode, John, of Pensford, Soms, or of Bristol, parish clerk 1
4989817 2353871 2353871 defendant Piers John draper 593048 593048 Piers, John, of Pensford, Soms, draper 3
4990015 2353925 2353925 defendant Pyers John draper 593048 593048 Pyers, John, of Pensford, Soms, draper 3
4994851 2355312 2355312 defendant Redewyk John hostiller 593048 593048 Redewyk, John, of Pensford, Soms, hostiller 1
5016796 2361807 2361807 defendant Pyers John draper 593048 593048 Pyers, John, of Pensford, Soms, draper 0
5117541 2391563 2391563 defendant Martyn Robert yeoman 593048 593048 Martyn, Robert, of Pensford, Soms, yeoman 1
5117549 2391565 2391565 defendant Martyn Robert yeoman 593048 593048 Martyn, Robert, of Pensford, Soms, yeoman 1
5194170 2414028 2414028 defendant Lewys Robert chapman 593048 593048 Lewys, Robert, of Pensford, Soms, chapman 2
5208593 2418242 2418242 defendant Lewys Robert chapman 593048 593048 Lewys, Robert, of Pensford, Soms, chapman 2
5208600 2418243 2418243 defendant Lewys Robert chapman 593048 593048 Lewys, Robert, of Pensford, Soms, chapman 2
5450721 2490102 2490102 defendant Kene Richard clothman 593048 593048 Kene, Richard, of Pensford, Soms, clothman 0
5462857 2493803 2493803 defendant Kene Richard clothman 593048 593048 Kene, Richard, of Pensford, Soms, clothman 0
5474955 2497491 2497491 defendant Barstapill John miller 593048 593048 Barstapill, John, of Pensford, Soms, miller 0
5509803 2507900 2507900 defendant Fluet Richard clothier 593048 593048 Fluet, Richard, of Pensford, Soms, clothier 1
5569944 2525786 2525786 defendant Lawnder William clothman 593048 593048 Lawnder, William, of Pensford, Soms, clothman 1
5596880 2533943 2533943 defendant Smyth William weaver 593048 593048 Smyth, William, of Pensford, Soms, weaver 0
5598591 2534441 2534441 defendant Boteller alias Smyth William clothier 593048 593048 Boteller alias Smyth, William, of Pensford, Soms, clothier 0
5602433 2535655 2535655 defendant Perryn John clothman 593048 593048 Perryn, John, of Pensford, Soms, clothman 1
5605052 2536451 2536451 defendant Raglond John clothman 593048 593048 Raglond, John, of Pensford, Soms, clothman 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);