names

9 rows where place_id = 602911

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3652284 1911053 1911053 defendant Cowley John yeoman 602911 602911 Cowley, John, of Byldeston, Suff, yeoman 0
4013669 2029626 2029626 defendant Marten Henry clothier 602911 602911 Marten, Henry, of Byldeston, Suff, clothier 0
4023820 2033225 2033225 defendant Kendall John yeoman 602911 602911 Kendall, John, of Byldeston, Suff, yeoman 1
4023823 2033226 2033226 defendant Kendall John yeoman 602911 602911 Kendall, John, of Byldeston, Suff, yeoman 1
4037912 2038209 2038209 plaintiff Kymbold Stephen clothier 602911 602911 Kymbold, Stephen, of Byldeston, Suff, clothier 0
4135092 2072871 2072871 defendant Barker John, junior clothier 602911 602911 Barker, John, junior, of Byldeston, Suff, clothier 2
5005115 2358393 2358393 defendant Fennyng John fuller 602911 602911 Fennyng, John, of Byldeston, Suff, fuller 11
5020156 2362783 2362783 defendant Gervays John, junior merchant 602911 602911 Gervays, John, junior, of Byldeston, Suff, merchant 1
5560269 2522965 2522965 defendant Hamund William clothmaker 602911 602911 Hamund, William, of Byldeston, Suff, clothmaker 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);