names

18 rows where case_id = 2022242

✎ 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
3992983 2022242 2022242 plaintiff Calmady Richard attorney of the bench   Calmady, Richard, attorney of the bench 0
3992984 2022242 2022242 defendant Randall John husbandman 627121 627121 Randall, John, of Lytham, husbandman 0
3992985 2022242 2022242 defendant Colrydge Patrick husbandman 669376 669376 Colrydge, Patrick, of Lancrasse, husbandman 1
3992986 2022242 2022242 defendant Howper or Hoper Eleanor spinster 586442 586442 Howper or Hoper, Eleanor, of Honyton, or of Lymne Regis, Dorset, spinster 2
3992987 2022242 2022242 defendant Webber Humphrey husbandman 669378 669378 Webber, Humphrey, of Fenne Otterye, husbandman 3
3992988 2022242 2022242 defendant Bocher William victualer 669379 669379 Bocher, William, of Fluxston, Otterye St Mary, victualer 4
3992989 2022242 2022242 defendant Potter Richard butcher 612441 612441 Potter, Richard, of Payhembery, butcher 5
3992990 2022242 2022242 defendant Twygge Oliver yeoman 626360 626360 Twygge, Oliver, of Bradnynche, yeoman 6
3992991 2022242 2022242 defendant Twygge John yeoman 626360 626360 Twygge, John, of Bradnynche, yeoman 7
3992992 2022242 2022242 defendant Whytmore Henry husbandman 586443 586443 Whytmore, Henry, of Colyton, husbandman 8
3992993 2022242 2022242 defendant Samford Bartholomew yeoman 588292 588292 Samford, Bartholomew, of Colompton, yeoman 9
3992994 2022242 2022242 defendant Rudge Thomas yeoman 669380 669380 Rudge, Thomas, of Brodehembery, yeoman 10
3992995 2022242 2022242 defendant Adams Humphrey yeoman 614517 614517 Adams, Humphrey, of Clyst Hydon, yeoman 11
3992996 2022242 2022242 defendant Rewe Constance widow 588557 588557 Rewe, Constance, of Tyverton, widow 12
3992997 2022242 2022242 defendant Fox John husbandman 619684 619684 Fox, John, of Farryngdon, husbandman 13
3992998 2022242 2022242 defendant Josse John yeoman 669381 669381 Josse, John, of Sowthby, yeoman 14
3992999 2022242 2022242 defendant Purchase William smith 616407 616407 Purchase, William, of Wylmyngton, smith 15
3993000 2022242 2022242 defendant Chapman Thomas husbandman 669382 669382 Chapman, Thomas, of Assheraffe, husbandman 16

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