names

16 rows where place_id = 608883

✎ 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
3675920 1918506 1918506 defendant Bradford Thomas yeoman 608883 608883 Bradford, Thomas, of Dymmok, Glos, yeoman 1
3775076 1949936 1949936 defendant Baston Thomas gent 608883 608883 Baston, Thomas, of Dymmok, Glos, gent 1
3790364 1954802 1954802 defendant Brugge James gent 608883 608883 Brugge, James, of Dymmok, Glos, gent 0
3796526 1956786 1956786 defendant Barston Thomas gent 608883 608883 Barston, Thomas, of Dymmok, Glos, gent 1
3796529 1956787 1956787 defendant Barston Thomas gent 608883 608883 Barston, Thomas, of Dymmok, Glos, gent 1
3841168 1970816 1970816 defendant Barston Thomas gent 608883 608883 Barston, Thomas, of Dymmok, Glos, gent 1
3887170 1985972 1985972 defendant Bradforde Thomas yeoman 608883 608883 Bradforde, Thomas, of Dymmok, Glos, yeoman 2
3892718 1987815 1987815 defendant Barston Thomas gent 608883 608883 Barston, Thomas, of Dymmok, Glos, gent 0
3907171 1992690 1992690 defendant Barston Thomas gent 608883 608883 Barston, Thomas, of Dymmok, Glos, gent 0
3912542 1994525 1994525 defendant Barston Thomas gent 608883 608883 Barston, Thomas, of Dymmok, Glos, gent 0
3913215 1994751 1994751 defendant Barston Thomas gent 608883 608883 Barston, Thomas, of Dymmok, Glos, gent 0
4301508 2130642 2130642 defendant Baston or Barston Florence (legal representative) 608883 608883 Baston or Barston, Florence, of Dymmok, Glos, gent, executrix of 0
4780105 2289783 2289783 defendant Weneyate Thomas yeoman 608883 608883 Weneyate, Thomas, of Dymmok, Glos, yeoman 0
5082336 2381210 2381210 defendant Brygge Thomas gent 608883 608883 Brygge, Thomas, of Dymmok, Glos, gent 0
5482420 2499682 2499682 defendant Maltyn John butcher 608883 608883 Maltyn, John, of Dymmok, Glos, butcher 1
5573284 2526741 2526741 defendant Camme William husbandman 608883 608883 Camme, William, of Dymmok, Glos, husbandman 2

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