names

14 rows where place_id = 625236

✎ 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
3762928 1946037 1946037 defendant Bate Thomas yeoman 625236 625236 Bate, Thomas, of Watlyngton, Norf, yeoman 1
3916969 1996043 1996043 defendant Hubbart John yeoman 625236 625236 Hubbart, John, of Watlyngton, Norf, yeoman 0
3916973 1996044 1996044 defendant Hubbart John yeoman 625236 625236 Hubbart, John, of Watlyngton, Norf, yeoman 0
3957979 2009854 2009854 defendant Butt William gent 625236 625236 Butt, William, of Watlyngton, Norf, gent 0
3975607 2016032 2016032 plaintiff Hurrell Richard yeoman 625236 625236 Hurrell, Richard, of Watlyngton, Norf, yeoman 0
3976506 2016358 2016358 defendant Kervyle Robert gent 625236 625236 Kervyle, Robert, of Watlyngton, Norf, gent 0
4094975 2058531 2058531 defendant Gowcell or Gawcell Thomas gent 625236 625236 Gowcell or Gawcell, Thomas, of Watlyngton, Norf, gent, son of Richard Gawcell, of Watlyngton, gent, son of Thomas Gawcell, of Thetford, gent 0
4120556 2067629 2067629 defendant Shuldham Robert gent 625236 625236 Shuldham, Robert, of Watlyngton, Norf, gent 0
4340030 2143779 2143779 defendant Reynes Robert yeoman 625236 625236 Reynes, Robert, of Watlyngton, Norf, yeoman 0
4779752 2289660 2289660 defendant Lavenham John husbandman 625236 625236 Lavenham, John, of Watlyngton, Norf, husbandman 0
5284651 2440526 2440526 defendant Sutton Thomas husbandman 625236 625236 Sutton, Thomas, of Watlyngton, Norf, husbandman 3
5358294 2462648 2462648 defendant Mannyng Thomas yeoman 625236 625236 Mannyng, Thomas, of Watlyngton, Norf, yeoman 0
5358296 2462649 2462649 defendant Mannyng Thomas yeoman 625236 625236 Mannyng, Thomas, of Watlyngton, Norf, yeoman 0
5534088 2515198 2515198 defendant Kernell Thomas gent 625236 625236 Kernell, Thomas, of Watlyngton, Norf, gent 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);