names

31 rows where place_id = 598234

✎ 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
3631670 1904717 1904717 defendant Bradwey John yeoman 598234 598234 Bradwey, John, of Campden, Glos, yeoman 1
3671725 1917142 1917142 defendant Porter Richard gent 598234 598234 Porter, Richard, of Campden, Glos, gent 0
3677420 1918989 1918989 defendant Porter Richard gent 598234 598234 Porter, Richard, of Campden, Glos, gent 1
3677425 1918990 1918990 defendant Porter Richard gent 598234 598234 Porter, Richard, of Campden, Glos, gent 1
3714735 1930909 1930909 defendant Porter Richard (legal representative) 598234 598234 Porter, Richard, of Campden, Glos, gent, administratrix of 0
3714751 1930916 1930916 defendant Porter Richard (legal representative) 598234 598234 Porter, Richard, of Campden, Glos, gent, administrator of Porter, William, sergeant at arms, administratrix of 0
3853765 1974811 1974811 defendant Ley Richard miller 598234 598234 Ley, Richard, of Campden, Glos, miller 0
3866706 1979098 1979098 defendant Freman Thomas yeoman 598234 598234 Freman, Thomas, of Campden, Glos, yeoman 3
3868561 1979724 1979724 defendant Porter Henry gent 598234 598234 Porter, Henry, of Campden, Glos, gent 3
3872496 1981027 1981027 plaintiff Boner Thomas yeoman 598234 598234 Boner, Thomas, of Campden, Glos, yeoman 0
3872500 1981028 1981028 plaintiff Boner Thomas yeoman 598234 598234 Boner, Thomas, of Campden, Glos, yeoman 0
3952505 2007945 2007945 defendant Horne Roger butcher 598234 598234 Horne, Roger, of Campden, Glos, butcher 0
3957520 2009696 2009696 defendant ap Rice Thomas yeoman 598234 598234 ap Rice, Thomas, of Campden, Glos, yeoman 0
4152732 2079065 2079065 defendant Smyth Thomas gent 598234 598234 Smyth, Thomas, of Campden, Glos, gent 0
4206196 2097713 2097713 defendant Smythe Thomas gent 598234 598234 Smythe, Thomas, of Campden, Glos, gent 0
4389859 2161231 2161231 defendant Smythe Thomas esq 598234 598234 Smythe, Thomas, of Campden, Glos, esq 1
4778688 2289316 2289316 defendant Grenell or Grevell Richard gent 598234 598234 Grenell or Grevell, Richard, of Campden, Glos, gent 3
4944297 2340191 2340191 defendant Wode Richard chapman 598234 598234 Wode, Richard, of Campden, Glos, chapman 0
4944407 2340228 2340228 defendant atte Wode Richard chapman 598234 598234 atte Wode, Richard, of Campden, Glos, chapman 0
4981376 2351350 2351350 defendant Bonefaunt John chapman 598234 598234 Bonefaunt, John, of Campden, Glos, chapman 4
4981382 2351351 2351351 defendant Bonefaunt John chapman 598234 598234 Bonefaunt, John, of Campden, Glos, chapman 4
5025760 2364433 2364433 defendant Dyer Adam   598234 598234 Dyer, Adam, of Campden, Glos, dyer, administrators of 0
5232015 2424934 2424934 defendant Wakefeld Henry gent 598234 598234 Wakefeld, Henry, of Campden, Glos, gent 0
5240566 2427454 2427454 defendant Willey Thomas clothman 598234 598234 Willey, Thomas, of Campden, Glos, clothman 1
5264422 2434629 2434629 defendant Pastorne or Pascorne Thomas husbandman 598234 598234 Pastorne or Pascorne, Thomas, of Campden, Glos, husbandman 0
5280566 2439392 2439392 defendant West Robert yeoman 598234 598234 West, Robert, of Campden, Glos, yeoman 0
5570390 2525909 2525909 defendant Wytley Thomas clerk 598234 598234 Wytley, Thomas, of Campden, Glos, clerk 1
5570924 2526055 2526055 defendant Porter Richard gent 598234 598234 Porter, Richard, of Campden, Glos, gent 0
5585226 2530447 2530447 defendant Whitby Thomas clerk 598234 598234 Whitby, Thomas, of Campden, Glos, clerk 2
5585232 2530448 2530448 defendant Whitby Thomas clerk 598234 598234 Whitby, Thomas, of Campden, Glos, clerk 0
5585240 2530449 2530449 defendant Whitby Thomas clerk 598234 598234 Whitby, Thomas, of Campden, Glos, clerk 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);