names

11 rows where place_id = 592814

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609031 1870480 1870480 defendant Butte John yeoman 592814 592814 Butte, John, of Thornegge, yeoman 0
4445145 2183453 2183453 plaintiff Counche NIcholas   592814 592814 Counche, NIcholas, of Thornegge, parson 0
4965553 2346617 2346617 defendant Hoppe Robert yeoman 592814 592814 Hoppe, Robert, of Thornegge, yeoman 0
5074922 2379005 2379005 plaintiff Wylles William   592814 592814 Wylles, William, of Thornegge 0
5142394 2398899 2398899 plaintiff Willes William   592814 592814 Willes, William, of Thornegge 0
5267573 2435618 2435618 defendant Heymes William husbandman 592814 592814 Heymes, William, of Thornegge, husbandman 0
5267577 2435619 2435619 defendant Hemles John husbandman 592814 592814 Hemles, John, of Thornegge, husbandman 2
5269225 2436105 2436105 plaintiff Butte John   592814 592814 Butte, John, of Thornegge 0
5314610 2449403 2449403 defendant Mayne Stephen baker 592814 592814 Mayne, Stephen, of Thornegge, baker 0
5505604 2506672 2506672 defendant Gogeney William gent 592814 592814 (Gogeney, William, of Thornegge, gent 3
5525857 2512679 2512679 defendant Butte James husbandman 592814 592814 Butte, James, of Thornegge, husbandman 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);