names

16 rows where case_id = 2289783

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4780103 2289783 2289783 plaintiff Brugge Giles esq   Brugge, Giles, esq 0
4780104 2289783 2289783 plaintiff Blunt James     Blunt, James 1
4780105 2289783 2289783 defendant Weneyate Thomas yeoman 608883 608883 Weneyate, Thomas, of Dymmok, Glos, yeoman 0
4780106 2289783 2289783 defendant Weneyate Richard yeoman 596734 596734 Weneyate, Richard, of Dymmok, yeoman 1
4780107 2289783 2289783 defendant Weneyate Edmund yeoman 596734 596734 Weneyate, Edmund, of Dymmok, yeoman 2
4780108 2289783 2289783 defendant Hale William husbandman 596734 596734 Hale, William, of Dymmok, husbandman 3
4780109 2289783 2289783 defendant Chanfrey Thomas husbandman 596734 596734 Chanfrey, Thomas, of Dymmok, husbandman 4
4780110 2289783 2289783 defendant Grombage Thomas husbandman 596734 596734 Grombage, Thomas, of Dymmok, husbandman 5
4780111 2289783 2289783 defendant Pous or Pons John husbandman 596734 596734 Pous or Pons, John, of Dymmok, husbandman 6
4780112 2289783 2289783 defendant Ferer Richard yeoman 596734 596734 Ferer, Richard, of Dymmok, yeoman 7
4780113 2289783 2289783 defendant Wele Henry husbandman 596734 596734 Wele, Henry, of Dymmok, husbandman 8
4780114 2289783 2289783 defendant Drewe John husbandman 596734 596734 Drewe, John, of Dymmok, husbandman 9
4780115 2289783 2289783 defendant Drewe William husbandman 634538 634538 Drewe, William, of Preston, Glos, husbandman 10
4780116 2289783 2289783 defendant Drewe Thomas husbandman 587004 587004 Drewe, Thomas, of Preston, husbandman 11
4780117 2289783 2289783 defendant Loteby Thomas husbandman 587004 587004 Loteby, Thomas, of Preston, husbandman 12
4780118 2289783 2289783 defendant Petur Philip husbandman 587004 587004 Petur, Philip, of Preston, husbandman 13

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);