names

16 rows where case_id = 2022241

✎ 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
3992967 2022241 2022241 plaintiff Calmady Richard attorney of the bench   Calmady, Richard, attorney of the bench 0
3992968 2022241 2022241 defendant Gere Andrew merchant 586036 586036 Gere, Andrew, of Exeter, merchant 0
3992969 2022241 2022241 defendant Arrundell Alexander gent 669366 669366 Arrundell, Alexander, of Landylppe, Cornw, gent 1
3992970 2022241 2022241 defendant Kelly William gent 669367 669367 Kelly, William, of Ratclyffe, Devon, gent 2
3992971 2022241 2022241 defendant Stukeley Christopher gent   Stukeley, Christopher, gent 3
3992972 2022241 2022241 defendant Lyde Peter gent 669368 669368 Lyde, Peter, of Pery Pomerye, Devon, gent 4
3992973 2022241 2022241 defendant Sladd or Slade John husbandman 669369 669369 Sladd or Slade, John, of Harforde, Devon, or of Lymyngton, Soms, husbandman 5
3992974 2022241 2022241 defendant Kympe Roger husbandman 669370 669370 Kympe, Roger, of St Bodocke, Cornw, husbandman 6
3992975 2022241 2022241 defendant Chanon William gent 669371 669371 Chanon, William, of Tallyton, Devon, gent 7
3992976 2022241 2022241 defendant Davenporte John esq 669372 669372 Davenporte, John, of Davenporte, Cheshire, esq 8
3992977 2022241 2022241 defendant Howell John merchant 608735 608735 Howell, John, of Charde, Soms, merchant 9
3992978 2022241 2022241 defendant Parham John yeoman 586859 586859 Parham, John, of Salisbury, yeoman 10
3992979 2022241 2022241 defendant Cumshed Christopher yeoman 586036 586036 Cumshed, Christopher, of Exeter, yeoman 11
3992980 2022241 2022241 defendant Carwythan Robert gent 669373 669373 Carwythan, Robert, of Pongyll, Devon, gent 12
3992981 2022241 2022241 defendant Grenfyll Richard gent 669374 669374 Grenfyll, Richard, of Penheale, Cornw, gent 13
3992982 2022241 2022241 defendant Willoby John gent 669375 669375 Willoby, John, of Pyddeltowne, Dorset, gent 14

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