names

13 rows where case_id = 2344762

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4959340 2344762 2344762 plaintiff Armeston William     Armeston, William 0
4959341 2344762 2344762 defendant Norreys John esq 586152 586152 Norreys, John, of Warwick, esq 0
4959342 2344762 2344762 defendant Endelwike or Gudelwike William gent 827517 827517 Endelwike or Gudelwike, William, of Michelham, Sussex, gent 1
4959343 2344762 2344762 defendant Waterton Robert   627022 627022 Waterton, Robert, of Medley, Yorks, knight 2
4959344 2344762 2344762 defendant Lassels John   604789 604789 Lassels, John, of Pykeryng, Yorks, bailiff 3
4959345 2344762 2344762 defendant Bythebroke John prior of Nostell Priory   Bythebroke, John, prior of Nostell Priory 4
4959346 2344762 2344762 defendant Bukton Peter gent 827519 827519 Bukton, Peter, of Pykerynghythe, Yorks, gent 5
4959347 2344762 2344762 defendant Draper John draper 632040 632040 Draper, John, of Walton, Essex, draper 6
4959348 2344762 2344762 defendant Grene William husbandman 827520 827520 Grene, William, of Norhamsted, Essex, husbandman 7
4959349 2344762 2344762 defendant Bufford John yeoman 586435 586435 Bufford, John, of Leicester, yeoman 8
4959350 2344762 2344762 defendant Blysse Richard husbandman 827521 827521 Blysse, Richard, of Crydlyng, Yorks, husbandman 9
4959351 2344762 2344762 defendant Breknok John gent 585869 585869 Breknok, John, of London, gent 10
4959352 2344762 2344762 defendant William of Knottyngley Yorks, husbandman   William, of Knottyngley, Yorks, husbandman 11

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