names

14 rows where case_id = 2312131

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4852246 2312131 2312131 plaintiff Warner Robert     Warner, Robert 0
4852247 2312131 2312131 defendant Helmeslay William chapman 700327 700327 Helmeslay, William, of Locton, chapman 0
4852248 2312131 2312131 defendant Langton John yeoman 613126 613126 Langton, John, of Santon, yeoman 1
4852249 2312131 2312131 defendant Day John husbandman 770092 770092 Day, John, of Populton, husbandman 2
4852250 2312131 2312131 defendant Beverlay Alice formerly wife of Robert, of Wakefeld, widow   Beverlay, Alice, formerly wife of Robert, of Wakefeld, widow 3
4852251 2312131 2312131 defendant Hesyll Richard   586887 586887 Hesyll, Richard, of Wakefeld, mustard maker 4
4852252 2312131 2312131 defendant Lyster Anne dyer 586093 586093 Lyster, Anne, of Selby, dyer 5
4852253 2312131 2312131 defendant Ronyng or Rovyng Anne widow 586093 586093 Ronyng or Rovyng, Anne, of Selby, widow 6
4852254 2312131 2312131 defendant Kyrkby Roger yeoman 586093 586093 Kyrkby, Roger, of Selby, yeoman 7
4852255 2312131 2312131 defendant Scalys John yeoman 586093 586093 Scalys, John, of Selby, yeoman 8
4852256 2312131 2312131 defendant Forster Helen widow 812814 812814 Forster, Helen, of Camylsford, widow 9
4852257 2312131 2312131 defendant Symson John husbandman 812815 812815 Symson, John, of Newehawe, husbandman 10
4852258 2312131 2312131 defendant Godfray John chapman 589774 589774 Godfray, John, of Swynflete, chapman 11
4852259 2312131 2312131 defendant Merylot Henry walker 812816 812816 Merylot, Henry, of Bawetery, walker 12

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