names

16 rows where place_id = 596861

✎ 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
3626430 1903121 1903121 defendant Cradeley John yeoman 596861 596861 Cradeley, John, of Weddesbury, yeoman 0
3634372 1905549 1905549 defendant Cradeley John yeoman 596861 596861 Cradeley, John, of Weddesbury, yeoman 0
3638899 1906990 1906990 defendant Cradeley John yeoman 596861 596861 Cradeley, John, of Weddesbury, yeoman 0
3638901 1906991 1906991 defendant Cradeley John yeoman 596861 596861 Cradeley, John, of Weddesbury, yeoman 0
3638903 1906992 1906992 defendant Cradeley John yeoman 596861 596861 Cradeley, John, of Weddesbury, yeoman 0
3659952 1913370 1913370 defendant Warner Thomas tanner 596861 596861 Warner, Thomas, of Weddesbury, tanner 4
3725549 1934281 1934281 defendant More John smith 596861 596861 More, John, of Weddesbury, smith 0
3750583 1942100 1942100 defendant Byram Henry husbandman 596861 596861 Byram, Henry, of Weddesbury, husbandman 0
3776775 1950481 1950481 defendant Cresswell William laborer 596861 596861 Cresswell, William, of Weddesbury, laborer 3
3794145 1956037 1956037 defendant Byrom Henry yeoman 596861 596861 Byrom, Henry, of Weddesbury, yeoman 0
3878565 1983076 1983076 defendant Pershowse John yeoman 596861 596861 Pershowse, John, of Weddesbury, yeoman 1
4790028 2292953 2292953 defendant Martyn William yeoman 596861 596861 Martyn, William, of Weddesbury, yeoman 0
5196490 2414725 2414725 defendant de la Rewe Peter baker 596861 596861 de la Rewe, Peter, of Weddesbury, baker 1
5312488 2448770 2448770 defendant Austen John yeoman 596861 596861 Austen, John, of Weddesbury, yeoman 1
5368425 2465738 2465738 defendant Broke Richard grasier 596861 596861 Broke, Richard, of Weddesbury, grasier 0
5584286 2530151 2530151 defendant Manys John potter 596861 596861 Manys, John, of Weddesbury, potter 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);