names

9 rows where place_id = 678388

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4031094 2035791 2035791 defendant Lane Thomas brewer 678388 678388 Lane, Thomas, of Wysbytche, brewer 1
4047734 2041637 2041637 plaintiff Story Edward senior   678388 678388 Story, Edward senior, of Wysbytche 0
4061193 2046411 2046411 defendant Hodgeson William husbandman 678388 678388 Hodgeson, William, of Wysbytche, husbandman 1
4083245 2054297 2054297 defendant Leveredge Robert tailor 678388 678388 Leveredge, Robert, of Wysbytche, tailor 0
4109509 2063663 2063663 defendant Ansley or Ausley Henry husbandman or haberdasher 678388 678388 Ansley or Ausley, Henry, of Wysbytche, or of Newton, Isle of Ely, Cams, husbandman or haberdasher 0
4195761 2094071 2094071 defendant Page John husbandman 678388 678388 Page, John, of Wysbytche, husbandman 1
4195776 2094075 2094075 defendant Pelham William yeoman 678388 678388 Pelham, William, of Wysbytche, yeoman 0
4196111 2094188 2094188 defendant Ganton or Gauton Peter chandler 678388 678388 Ganton or Gauton, Peter, of Wysbytche, chandler 2
4207099 2098026 2098026 defendant Clarke William husbandman 678388 678388 Clarke, William, of Wysbytche, husbandman 2

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