names

18 rows where place_id = 609402

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3678276 1919261 1919261 defendant Staleman Thomas yeoman 609402 609402 Staleman, Thomas, of Byddynden, yeoman 0
3693902 1924297 1924297 defendant Brykynden Robert laborer 609402 609402 Brykynden, Robert, of Byddynden, laborer 0
3700956 1926548 1926548 plaintiff Beste William   609402 609402 Beste, William, of Byddynden 0
3707898 1928767 1928767 defendant Reynold William yeoman 609402 609402 Reynold, William, of Byddynden, yeoman 0
3714543 1930846 1930846 plaintiff Best William   609402 609402 Best, William, of Byddynden 0
3784699 1953003 1953003 plaintiff Meyne John yeoman or gent 609402 609402 Meyne, John, of Byddynden, yeoman or gent 0
3861444 1977288 1977288 defendant Gylham Thomas weaver 609402 609402 Gylham, Thomas, of Byddynden, weaver 3
3862092 1977508 1977508 defendant Gyllam Thomas weaver 609402 609402 Gyllam, Thomas, of Byddynden, weaver 1
3875027 1981874 1981874 defendant Love William butcher 609402 609402 Love, William, of Byddynden, butcher 2
3885643 1985455 1985455 plaintiff Best John   609402 609402 Best, John, of Byddynden, administrators of 0
3885645 1985455 1985455 defendant Best Gregory clothmaker and weaver 609402 609402 Best, Gregory, of Byddynden, clothmaker and weaver 0
3899449 1990029 1990029 defendant Best John   609402 609402 Best, John, of Byddynden, clothmaker, administrators of 0
3958535 2010054 2010054 defendant Frende William clothier 609402 609402 Frende, William, of Byddynden, clothier 1
4085911 2055239 2055239 plaintiff Boddynden William (legal representative) 609402 609402 Boddynden, William, of Byddynden, clothier, executor of 0
4859959 2314482 2314482 defendant Strode John   609402 609402 Strode, John, of Byddynden 0
5299423 2444806 2444806 defendant Cretynden Robert yeoman 609402 609402 Cretynden, Robert, of Byddynden, yeoman 0
5602463 2535664 2535664 defendant Meryell John yeoman 609402 609402 Meryell, John, of Byddynden, yeoman 1
5602464 2535664 2535664 defendant Horden John wheeler 609402 609402 Horden, John, of Byddynden, wheeler 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);