names

14 rows where place_id = 636099

✎ 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
3828870 1966908 1966908 defendant Symondys Ralph merchant 636099 636099 Symondys, Ralph, of Claye, Norf, merchant 0
3828872 1966909 1966909 defendant Symonys Ralph merchant 636099 636099 Symonys, Ralph, of Claye, Norf, merchant 0
3982949 2018680 2018680 defendant Tevydalle Robert yeoman 636099 636099 Tevydalle, Robert, of Claye, Norf, yeoman 0
4002576 2025690 2025690 defendant Wilkynson Richard yeoman or mariner 636099 636099 Wilkynson, Richard, of Claye, Norf, yeoman or mariner 0
4062618 2046926 2046926 defendant Tayllor Ralph merchant 636099 636099 Tayllor, Ralph, of Claye, Norf, merchant 0
4079178 2052857 2052857 defendant Underwood John gent 636099 636099 Underwood, John, of Claye, Norf, gent 0
4097826 2059554 2059554 defendant Dewell John chapman 636099 636099 Dewell, John, of Claye, Norf, chapman 0
4121297 2067912 2067912 defendant Baxter William yeoman 636099 636099 Baxter, William, of Claye, Norf, yeoman 1
4121300 2067913 2067913 defendant Baxter William yeoman 636099 636099 Baxter, William, of Claye, Norf, yeoman 1
4229638 2105850 2105850 defendant Gilbarte Edward chapman 636099 636099 Gilbarte, Edward, of Claye, Norf, chapman 2
4238319 2109013 2109013 defendant Gilbarte Edward chapman 636099 636099 Gilbarte, Edward, of Claye, Norf, chapman 2
4940052 2338916 2338916 defendant Clerk Edmund husbandman 636099 636099 Clerk, Edmund, of Claye, Norf, husbandman 1
5250875 2430384 2430384 defendant Horne William yeoman 636099 636099 Horne, William, of Claye, Norf, yeoman 3
5250889 2430387 2430387 defendant Horne William yeoman 636099 636099 Horne, William, of Claye, Norf, yeoman 1

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