names

16 rows where place_id = 646468

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3891023 1987261 1987261 defendant Ayer Thomas mercer 646468 646468 Ayer, Thomas, of Collompton, Devon, mercer 1
3992056 2021924 2021924 plaintiff Brymlye Lawrence   646468 646468 Brymlye, Lawrence, of Collompton, Devon, "howser" 0
4019194 2031602 2031602 defendant Moore John   646468 646468 Moore, John, of Collompton, Devon, knight 0
4122804 2068446 2068446 defendant Saunder Thomas tanner 646468 646468 Saunder, Thomas, of Collompton, Devon, tanner 0
4141107 2075049 2075049 defendant Bremley Thomas clothier 646468 646468 Bremley, Thomas, of Collompton, Devon, clothier 0
4145638 2076627 2076627 defendant Cotton John tucker 646468 646468 Cotton, John, of Collompton, Devon, tucker 4
4182063 2089206 2089206 defendant Cole John husbandman 646468 646468 Cole, John, of Collompton, Devon, husbandman 1
4192110 2092802 2092802 defendant Bale Walter tucker 646468 646468 Bale, Walter, of Collompton, Devon, tucker 0
4192120 2092807 2092807 defendant Pytt John tucker 646468 646468 Pytt, John, of Collompton, Devon, tucker 0
4205324 2097412 2097412 defendant Grene Thomas yeoman 646468 646468 Grene, Thomas, of Collompton, Devon, yeoman 0
4229232 2105707 2105707 defendant Skynner James merchant 646468 646468 Skynner, James, of Collompton, Devon, merchant 0
4259082 2116009 2116009 defendant Skynner James merchant 646468 646468 Skynner, James, of Collompton, Devon, merchant 0
4301343 2130589 2130589 defendant Hayes John gent 646468 646468 Hayes, John, of Collompton, Devon, gent 0
4305878 2132195 2132195 defendant Stevens John dyer 646468 646468 Stevens, John, of Collompton, Devon, dyer 0
4332811 2141255 2141255 defendant Hacker Henry haberdasher 646468 646468 Hacker, Henry, of Collompton, Devon, haberdasher 3
4360589 2150955 2150955 defendant Style Thomas yeoman 646468 646468 Style, Thomas, of Collompton, Devon, 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);