names

29 rows where case_id = 2387100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5102356 2387100 2387100 plaintiff Berkeley James knight   Berkeley, James, knight 0
5102357 2387100 2387100 defendant Unssher William gent 593634 593634 Unssher, William, of Berkeley, gent 0
5102358 2387100 2387100 defendant Nelme or Neline Thomas yeoman 593634 593634 Nelme or Neline, Thomas, of Berkeley, yeoman 1
5102359 2387100 2387100 defendant Goton Thomas yeoman 589309 589309 Goton, Thomas, of Neuport, yeoman 2
5102360 2387100 2387100 defendant Man John husbandman 603036 603036 Man, John, of Hurste, husbandman 3
5102361 2387100 2387100 defendant Knyg or Kyng John baker 593634 593634 Knyg or Kyng, John, of Berkeley, baker 4
5102362 2387100 2387100 defendant Lee Richard yeoman 593634 593634 Lee, Richard, of Berkeley, yeoman 5
5102363 2387100 2387100 defendant Boweyer John, senior dyer 593634 593634 Boweyer, John, senior, of Berkeley, dyer 6
5102364 2387100 2387100 defendant Boweyer William dyer 593634 593634 Boweyer, William,of Berkeley, dyer 7
5102365 2387100 2387100 defendant Kyng Richard baker 593634 593634 Kyng, Richard, of Berkeley, baker 8
5102366 2387100 2387100 defendant Everard John husbandman 602254 602254 Everard, John, of Hynton, husbandman 9
5102367 2387100 2387100 defendant Milward William husbandman 626001 626001 Milward, William, of Slymbrygge, husbandman 10
5102368 2387100 2387100 defendant James William laborer 768996 768996 James, William, of Cambrigge, laborer 11
5102369 2387100 2387100 defendant Atkyns John carpenter 607411 607411 Atkyns, John, of Camme, carpenter 12
5102370 2387100 2387100 defendant Lewes John tucker 590141 590141 Lewes, John, of Dursley, tucker 13
5102371 2387100 2387100 defendant Taillour Henry husbandman 607411 607411 Taillour, Henry, of Camme, husbandman 14
5102372 2387100 2387100 defendant Rawyn Richard husbandman 607411 607411 Rawyn, Richard, of Camme, husbandman 15
5102373 2387100 2387100 defendant Yoman Richard husbandman 607411 607411 Yoman, Richard, of Camme, husbandman 16
5102374 2387100 2387100 defendant Selyman John husbandman 607411 607411 Selyman, John, of Camme, husbandman 17
5102375 2387100 2387100 defendant Pegeler William husbandman 607411 607411 Pegeler, William, of Camme, husbandman 18
5102376 2387100 2387100 defendant Huggyons John husbandman 607411 607411 Huggyons, John, of Camme, husbandman 19
5102377 2387100 2387100 defendant Honyburne Walter clerk 846595 846595 Honyburne, Walter, of Braddeston, clerk 20
5102378 2387100 2387100 defendant Botiller John, junior husbandman 592837 592837 Botiller, John, junior, of Hamme, husbandman 21
5102379 2387100 2387100 defendant Malette Richard yeoman 606673 606673 Malette, Richard, of Hull, yeoman 22
5102380 2387100 2387100 defendant Malette John husbandman 592837 592837 Malette, John, of Hamme, husbandman 23
5102381 2387100 2387100 defendant Pewessy Robert clerk 593634 593634 Pewessy, Robert, of Berkeley, clerk 24
5102382 2387100 2387100 defendant Payn John baker 585925 585925 Payn, John, of Bristol, baker 25
5102383 2387100 2387100 defendant Byford John yeoman 626001 626001 Byford, John, of Slymbrygge, yeoman 26
5102384 2387100 2387100 defendant Sake Richard laborer 603036 603036 Sake, Richard, of Hurste, laborer 27

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