names

10 rows where place_id = 679682

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4037253 2037988 2037988 defendant Smyth Walter husbandman 679682 679682 Smyth, Walter, of Hanam, husbandman 0
4476016 2193165 2193165 plaintiff Forde William   679682 679682 Forde, William, of Hanam 0
4786823 2291937 2291937 defendant Fyppes John husbandman 679682 679682 Fyppes, John, of Hanam, husbandman 0
4858568 2314054 2314054 defendant Fyppys John husbandman 679682 679682 Fyppys, John, of Hanam, husbandman 1
4862895 2315380 2315380 defendant Forde John husbandman 679682 679682 Forde, John, of Hanam, husbandman 0
4895030 2325112 2325112 plaintiff Smyth William   679682 679682 Smyth, William, of Hanam 0
4895032 2325112 2325112 defendant Smyth John   679682 679682 Smyth, John, of Hanam, bailiff 1
4946995 2341051 2341051 defendant Phippes John husbandman 679682 679682 Phippes, John, of Hanam, husbandman 0
4953140 2342904 2342904 defendant Arnold Thomas   679682 679682 Arnold, Thomas, of Hanam, "tryakylmonger" 0
4999293 2356662 2356662 defendant Fyppes John husbandman 679682 679682 Fyppes, John, of Hanam, 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);