names

11 rows where place_id = 597495

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628809 1903885 1903885 defendant Langhorne John husbandman 597495 597495 Langhorne, John, of Butterwyke, husbandman 6
3628810 1903885 1903885 defendant Yate John husbandman 597495 597495 Yate, John, of Butterwyke, husbandman 7
3916305 1995835 1995835 defendant North John yeoman 597495 597495 North, John, of Butterwyke, yeoman 1
4671566 2256752 2256752 defendant Mone or Move John hurdsman 597495 597495 Mone or Move, John, of Butterwyke, hurdsman 4
4847992 2310849 2310849 plaintiff Kendale William   597495 597495 Kendale, William, of Butterwyke 2
5159851 2403980 2403980 plaintiff Schefeld Robert   597495 597495 Schefeld, Robert, of Butterwyke 0
5552702 2520840 2520840 defendant Loydon John husbandman 597495 597495 Loydon, John, of Butterwyke, husbandman 3
5595554 2533554 2533554 plaintiff Sheffeld Robert, junior   597495 597495 Sheffeld, Robert, junior, of Butterwyke 11
5595577 2533555 2533555 plaintiff Sheffeld Robert, junior   597495 597495 Sheffeld, Robert, junior, of Butterwyke 11
5595600 2533556 2533556 plaintiff Sheffeld Robert, junior   597495 597495 Sheffeld, Robert, junior, of Butterwyke 11
5595623 2533557 2533557 plaintiff Sheffeld Robert, junior   597495 597495 Sheffeld, Robert, junior, of Butterwyke 11

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