names

12 rows where place_id = 837308

✎ 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
5031196 2366003 2366003 defendant Shakylton Richard husbandman 837308 837308 Shakylton, Richard, of Wedope, husbandman 0
5031202 2366003 2366003 defendant Stansfeld Thomas gent 837308 837308 Stansfeld, Thomas, of Wedope, gent 6
5031213 2366003 2366003 defendant Grenewode Henry yeoman 837308 837308 Grenewode, Henry, of Wedope, yeoman 17
5031214 2366003 2366003 defendant Gybson John yeoman 837308 837308 Gybson, John, of Wedope, yeoman 18
5031230 2366004 2366004 defendant Stansfeld Thomas gent 837308 837308 Stansfeld, Thomas, of Wedope, gent 4
5031231 2366004 2366004 defendant Shakylton Richard husbandman 837308 837308 Shakylton, Richard, of Wedope, husbandman 5
5031242 2366004 2366004 defendant Grenewode Henry yeoman 837308 837308 Grenewode, Henry, of Wedope, yeoman 16
5031243 2366004 2366004 defendant Gybson John yeoman 837308 837308 Gybson, John, of Wedope, yeoman 17
5031260 2366005 2366005 defendant Stansfeld Thomas gent 837308 837308 Stansfeld, Thomas, of Wedope, gent 4
5031261 2366005 2366005 defendant Shakylton Richard husbandman 837308 837308 Shakylton, Richard, of Wedope, husbandman 5
5031272 2366005 2366005 defendant Grenewode Henry yeoman 837308 837308 Grenewode, Henry, of Wedope, yeoman 16
5031273 2366005 2366005 defendant Gybson John yeoman 837308 837308 Gybson, John, of Wedope, yeoman 17

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