names

17 rows where place_id = 626977

✎ 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
3773499 1949423 1949423 defendant Codenham Thomas gent 626977 626977 Codenham, Thomas, of Stoven, gent 0
3893331 1988003 1988003 defendant Codenham Thomas gent 626977 626977 Codenham, Thomas, of Stoven, gent 0
4064711 2047668 2047668 defendant Wright Thomas husbandman 626977 626977 Wright, Thomas, of Stoven, husbandman 0
4064712 2047668 2047668 defendant Tyrpyn John husbandman 626977 626977 Tyrpyn, John, of Stoven, husbandman 1
4213448 2100222 2100222 defendant Wryght Thomas yeoman 626977 626977 Wryght, Thomas, of Stoven, yeoman 0
4281995 2123604 2123604 defendant Chamber or Chambers John   626977 626977 Chamber or Chambers, John, of Stoven 0
4303555 2131368 2131368 defendant Barnes James yeoman 626977 626977 Barnes, James, of Stoven, yeoman 2
4304145 2131582 2131582 defendant Barnes James yeoman 626977 626977 Barnes, James, of Stoven, yeoman 1
4307629 2132807 2132807 defendant Barnes James yeoman 626977 626977 Barnes, James, of Stoven, yeoman 3
4320650 2137313 2137313 defendant Chambers John yeoman 626977 626977 Chambers, John, of Stoven, yeoman 0
4326623 2139264 2139264 defendant Barnes James yeoman 626977 626977 Barnes, James, of Stoven, yeoman 2
4329266 2140101 2140101 defendant Barnes James yeoman 626977 626977 Barnes, James, of Stoven, yeoman 1
4329269 2140102 2140102 defendant Barnes James yeoman 626977 626977 Barnes, James, of Stoven, yeoman 1
4334386 2141778 2141778 defendant Barnes James yeoman 626977 626977 Barnes, James, of Stoven, yeoman 0
5057140 2373717 2373717 defendant Codenham Robert husbandman 626977 626977 Codenham, Robert, of Stoven, husbandman 3
5212847 2419502 2419502 plaintiff Bedon William (legal representative) 626977 626977 Bedon, William, of Stoven, executors of 0
5452689 2490687 2490687 defendant Levy John husbandman 626977 626977 Levy, John, of Stoven, husbandman 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);