names

16 rows where place_id = 657766

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3945630 2005547 2005547 defendant Hawkyne John gent 657766 657766 Hawkyne, John, of Wysbytche, Isle of Ely, Cams, gent 1
3950413 2007226 2007226 defendant Whelpdale John yeoman 657766 657766 Whelpdale, John, of Wysbytche, Isle of Ely, Cams, yeoman 0
3958856 2010180 2010180 defendant Markham Henry butcher 657766 657766 Markham, Henry, of Wysbytche, Isle of Ely, Cams, butcher 0
4026953 2034291 2034291 defendant Sparrowe Richard yeoman 657766 657766 Sparrowe, Richard, of Wysbytche, Isle of Ely, Cams, yeoman 0
4056034 2044541 2044541 defendant Story Edward yeoman 657766 657766 Story, Edward, of Wysbytche, Isle of Ely, Cams, yeoman 0
4080729 2053418 2053418 defendant Sadler Robert yeoman 657766 657766 Sadler, Robert, of Wysbytche, Isle of Ely, Cams, yeoman 0
4172554 2085861 2085861 defendant Balson Nicholas gent 657766 657766 Balson, Nicholas, of Wysbytche, Isle of Ely, Cams, gent 1
4172565 2085864 2085864 defendant Hamon William chapman 657766 657766 Hamon, William, of Wysbytche, Isle of Ely, Cams, chapman 0
4172578 2085867 2085867 defendant Robynson John, junior yeoman 657766 657766 Robynson, John, junior, of Wysbytche, Isle of Ely, Cams, yeoman 2
4177427 2087579 2087579 defendant Bradshawe Geoffrey yeoman 657766 657766 Bradshawe, Geoffrey, of Wysbytche, Isle of Ely, Cams, yeoman 0
4179702 2088373 2088373 defendant Bradshawe Geoffrey vintner 657766 657766 Bradshawe, Geoffrey, of Wysbytche, Isle of Ely, Cams, vintner 0
4195749 2094068 2094068 defendant Belson Nicholas gent 657766 657766 Belson, Nicholas, of Wysbytche, Isle of Ely, Cams, gent 1
4195760 2094071 2094071 defendant Hamon William chapman 657766 657766 Hamon, William, of Wysbytche, Isle of Ely, Cams, chapman 0
4196109 2094188 2094188 defendant Belson Nicholas gent 657766 657766 Belson, Nicholas, of Wysbytche, Isle of Ely, Cams, gent 0
4200751 2095821 2095821 defendant Bradshawe Geoffrey yeoman 657766 657766 Bradshawe, Geoffrey, of Wysbytche, Isle of Ely, Cams, yeoman 0
4204799 2097223 2097223 defendant Anderson James glover 657766 657766 Anderson, James, of Wysbytche, Isle of Ely, Cams, glover 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);