names

17 rows where case_id = 2533214

✎ 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
5594358 2533214 2533214 plaintiff Bastard Richard     Bastard, Richard 0
5594359 2533214 2533214 defendant Pratte Richard yeoman 609141 609141 Pratte, Richard, of Wymbottesham, yeoman 0
5594360 2533214 2533214 defendant Cony William administrators of   Cony, William, administrators of 1
5594361 2533214 2533214 defendant Kervile Humphrey gent 586231 586231 (Kervile, Humphrey, of Wygenhale, gent 2
5594362 2533214 2533214 defendant Elwyn William gent 586231 586231 Elwyn, William, of Wygenhale, gent 3
5594363 2533214 2533214 defendant Perys Edmund husbandman 586231 586231 Perys, Edmund, of Wygenhale, husbandman 4
5594364 2533214 2533214 defendant Perys Margaret Margaret, of Wygenhale, widow   Margaret his wife, formerly Cony, Margaret, of Wygenhale, widow 5
5594365 2533214 2533214 defendant Brampton Richard vicar of Tylney, administrators of   Brampton, Richard, vicar of Tylney, administrators of 6
5594366 2533214 2533214 defendant Newman Robert clerk 585907 585907 (Newman, Robert, of Bishops Lenn, clerk 7
5594367 2533214 2533214 defendant Conyngton or Covyngton John yeoman 585907 585907 Conyngton or Covyngton, John, of Bishops Lenn, yeoman 8
5594368 2533214 2533214 defendant Porte Agnes widow 586304 586304 Porte, Agnes, of Fordham, Cams, widow 9
5594369 2533214 2533214 defendant Russell Robert, junior (legal representative)   Russell, Robert, junior, executor of Russell, Robert, senior, executors of 10
5594370 2533214 2533214 defendant Porte Richard clerk 588755 588755 (Porte, Richard, of Teryngton, clerk 11
5594371 2533214 2533214 defendant Lynghoke John yeoman 588755 588755 Lynghoke, John, of Teryngton, yeoman 12
5594372 2533214 2533214 defendant Dykon Thomas yeoman 588755 588755 Dykon, Thomas, of Teryngton, yeoman 13
5594373 2533214 2533214 defendant Borowe John (legal representative)   Borowe, John, executor of Borowe, Simon, of Bishops Lenn, merchant, executors of 14
5594374 2533214 2533214 defendant Wylliamson Simon sherman 585907 585907 (Wylliamson, Simon, of Bishops Lenn, sherman 15

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