names

16 rows where case_id = 2461281

✎ 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
5353878 2461281 2461281 plaintiff Gryffyth Walter knight   Gryffyth, Walter, knight 0
5353879 2461281 2461281 plaintiff Scrop Richard esq   Scrop, Richard, esq 1
5353880 2461281 2461281 plaintiff Scrop Robert esq   Scrop, Robert, esq 2
5353881 2461281 2461281 plaintiff Savyle John esq   Savyle, John, esq 3
5353882 2461281 2461281 plaintiff Lascy or Lasty Thomas esq   Lascy or Lasty, Thomas, esq 4
5353883 2461281 2461281 defendant Bank Peter gent 876785 876785 Bank, Peter, of Allerton by the Water juxta Castelford, gent 0
5353884 2461281 2461281 defendant Bank Richard gent 876785 876785 Bank, Richard, of Allerton by the Water juxta Castelford, gent 1
5353885 2461281 2461281 defendant Dekonson John husbandman 876785 876785 Dekonson, John, of Allerton by the Water juxta Castelford, husbandman 2
5353886 2461281 2461281 defendant Storre John husbandman 758704 758704 Storre, John, of Allerton by the Water, husbandman 3
5353887 2461281 2461281 defendant Freman Thomas husbandman 758704 758704 Freman, Thomas, of Allerton by the Water, husbandman 4
5353888 2461281 2461281 defendant Topclyf Robert yeoman 600403 600403 Topclyf, Robert, of Hoghton, yeoman 5
5353889 2461281 2461281 defendant Topclyf William husbandman 876786 876786 Topclyf, William, of Aykyton, husbandman 6
5353890 2461281 2461281 defendant Milner Thomas husbandman 876786 876786 Milner, Thomas, of Aykyton, husbandman 7
5353891 2461281 2461281 defendant Snytall John husbandman 593651 593651 Snytall, John, of Knottyngley, husbandman 8
5353892 2461281 2461281 defendant Snytall Thomas husbandman 586908 586908 Snytall, Thomas, of Metheley, husbandman 9
5353893 2461281 2461281 defendant Lound Robert husbandman 586908 586908 Lound, Robert, of Metheley, husbandman 10

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