names

29 rows where case_id = 2387099

✎ 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
5102327 2387099 2387099 plaintiff Berkeley James knight   Berkeley, James, knight 0
5102328 2387099 2387099 defendant Unssher William gent 593634 593634 Unssher, William, of Berkeley, gent 0
5102329 2387099 2387099 defendant Neline or Nelme Thomas yeoman 593634 593634 Neline or Nelme, Thomas, of Berkeley, yeoman 1
5102330 2387099 2387099 defendant Ecton Thomas yeoman 626088 626088 Ecton, Thomas, of Neuporte, yeoman 2
5102331 2387099 2387099 defendant Man John husbandman 603036 603036 Man, John, of Hurste, husbandman 3
5102332 2387099 2387099 defendant Knyg or Kyng John baker 593634 593634 Knyg or Kyng, John, of Berkeley, baker 4
5102333 2387099 2387099 defendant Lee Richard yeoman 593634 593634 Lee, Richard, of Berkeley, yeoman 5
5102334 2387099 2387099 defendant Boweyer John, senior dyer 593634 593634 Boweyer, John, senior, of Berkeley, dyer 6
5102335 2387099 2387099 defendant Boweyer William dyer 593634 593634 Boweyer, William, of Berkeley, dyer 7
5102336 2387099 2387099 defendant Kyng Richard baker 593634 593634 Kyng, Richard, of Berkeley, baker 8
5102337 2387099 2387099 defendant Everard John husbandman 602254 602254 Everard, John, of Hynton, husbandman 9
5102338 2387099 2387099 defendant Milward William husbandman 611758 611758 Milward, William, of Slymbrigge, husbandman 10
5102339 2387099 2387099 defendant James William laborer 768996 768996 James, William, of Cambrigge, laborer 11
5102340 2387099 2387099 defendant Atkyns John carpenter 607411 607411 Atkyns, John, of Camme, carpenter 12
5102341 2387099 2387099 defendant Lewes John tucker 590141 590141 Lewes, John, of Dursley, tucker 13
5102342 2387099 2387099 defendant Taillour Henry husbandman 607411 607411 Taillour, Henry, of Camme, husbandman 14
5102343 2387099 2387099 defendant Rakeyn Richard husbandman 607411 607411 Rakeyn, Richard, of Camme, husbandman 15
5102344 2387099 2387099 defendant Yoman Richard husbandman 607411 607411 Yoman, Richard, of Camme, husbandman 16
5102345 2387099 2387099 defendant Solyman John   607411 607411 Solyman, John, of Camme 17
5102346 2387099 2387099 defendant Pegeler William husbandman 607411 607411 Pegeler, William, of Camme, husbandman 18
5102347 2387099 2387099 defendant Huggyns John husbandman 607411 607411 Huggyns, John, of Camme, husbandman 19
5102348 2387099 2387099 defendant Honyburne Walter clerk 846595 846595 Honyburne, Walter, of Braddeston, clerk 20
5102349 2387099 2387099 defendant Botiller John, junior husbandman 592837 592837 Botiller, John, junior, of Hamme, husbandman 21
5102350 2387099 2387099 defendant Malette Richard husbandman 606673 606673 Malette, Richard, of Hull, husbandman 22
5102351 2387099 2387099 defendant Malette John husbandman 592837 592837 Malette, John, of Hamme, husbandman 23
5102352 2387099 2387099 defendant Pewesey Robert clerk 593634 593634 Pewesey, Robert, of Berkeley, clerk 24
5102353 2387099 2387099 defendant Payn John baker 585925 585925 Payn, John, of Bristol, baker 25
5102354 2387099 2387099 defendant Byford John   846596 846596 Byford, John, of Slymbrigge, yeoma 26
5102355 2387099 2387099 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);