names

15 rows where case_id = 2002170

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3935450 2002170 2002170 plaintiff Kyme William gent   Kyme, William, gent 0
3935451 2002170 2002170 defendant Hayborn Thomas cooper 585869 585869 Hayborn, Thomas, of London, cooper 0
3935452 2002170 2002170 defendant Ocker John husbandman 655224 655224 Ocker, John, of Asheby by Partnay, Lincs, husbandman 1
3935453 2002170 2002170 defendant Wrenche James merchant 600449 600449 Wrenche, James, of Boston, Lincs, merchant 2
3935454 2002170 2002170 defendant Darnell Christiane widow 655225 655225 Darnell, Christiane, of Panton, Lincs, widow 3
3935455 2002170 2002170 defendant Phyllyppes Hugh   600449 600449 Phyllyppes, Hugh, of Boston, Lincs, inn holder 4
3935456 2002170 2002170 defendant Hussey Jane widow 642384 642384 Hussey, Jane, of Lynwood, Lincs, widow 5
3935457 2002170 2002170 defendant Newcombe Reginald of Ednham Lincs, gent   Newcombe, Reginald of Ednham, Lincs, gent 6
3935458 2002170 2002170 defendant Catterton Richard yeoman 655227 655227 Catterton, Richard, of Alforde, Lincs, yeoman 7
3935459 2002170 2002170 defendant Foller William gent 655228 655228 Foller, William, of Fullaby, Lincs, gent 8
3935460 2002170 2002170 defendant Eyre Percival yeoman 586286 586286 Eyre, Percival, of Boston, yeoman 9
3935461 2002170 2002170 defendant Hall Richard gent 655229 655229 Hall, Richard, of Westmorland, gent 10
3935462 2002170 2002170 defendant Pulvertoste or Pulvertofte Thomas esq 655230 655230 Pulvertoste or Pulvertofte, Thomas, of Barham, Lincs, esq 11
3935463 2002170 2002170 defendant Barkworth John yeoman 655231 655231 Barkworth, John, of Salfletby, Lincs, yeoman 12
3935464 2002170 2002170 defendant Johnson Hugh yeoman 587053 587053 Johnson, Hugh, of Sutton, Lincs, yeoman 13

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