names

16 rows where place_id = 596843

✎ 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
3626369 1903105 1903105 defendant Pakyn Thomas yeoman 596843 596843 Pakyn, Thomas, of Chayley, yeoman 0
3654416 1911642 1911642 defendant Pakyn Thomas yeoman 596843 596843 Pakyn, Thomas, of Chayley, yeoman 0
3792923 1955641 1955641 defendant Barnard John yeoman 596843 596843 Barnard, John, of Chayley, yeoman 0
4073006 2050643 2050643 defendant Barneden John yeoman 596843 596843 Barneden, John, of Chayley, yeoman 1
4094485 2058367 2058367 defendant Plomerden John husbandman 596843 596843 Plomerden, John, of Chayley, husbandman 2
4108357 2063245 2063245 defendant Barrenden John yeoman 596843 596843 Barrenden, John, of Chayley, yeoman 0
4174870 2086678 2086678 defendant Barneden John yeoman 596843 596843 Barneden, John, of Chayley, yeoman 2
4182579 2089384 2089384 defendant Michelborne Richard gent 596843 596843 Michelborne, Richard, of Chayley, gent 2
4225365 2104340 2104340 defendant Smythe John (legal representative) 596843 596843 Smythe, John, of Chayley, yeoman, administratrix of 0
4225366 2104340 2104340 defendant Smythe Margaret widow 596843 596843 Smythe, Margaret, of Chayley, widow 1
4225797 2104486 2104486 defendant Knyghte John husbandman 596843 596843 Knyghte, John, of Chayley, husbandman 3
4252694 2113887 2113887 defendant Knyghte John husbandman 596843 596843 Knyghte, John, of Chayley, husbandman 3
4370750 2154592 2154592 defendant Copperd John glover 596843 596843 Copperd, John, of Chayley, glover 0
4370752 2154593 2154593 defendant Coppard John glover 596843 596843 Coppard, John, of Chayley, glover 0
4378985 2157563 2157563 defendant Uden Francis yeoman 596843 596843 Uden, Francis, of Chayley, or of Lyndfeld, yeoman 0
5578542 2528360 2528360 defendant Pakyn Thomas yeoman 596843 596843 Pakyn, Thomas, of Chayley, 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);