names

21 rows where case_id = 2222827

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4572059 2222827 2222827 plaintiff Armeston William gent   Armeston, William, gent 0
4572060 2222827 2222827 defendant Broun John   770861 770861 Broun, John, of Wykesworth 0
4572061 2222827 2222827 defendant Lewyther Robert     Lewyther, Robert 1
4572062 2222827 2222827 defendant Pole John de la     Pole, John de la 2
4572063 2222827 2222827 defendant Nedham John de   592146 592146 Nedham, John de, of Nedham 3
4572064 2222827 2222827 defendant Dether Thomas     together with Dether, Thomas 4
4572065 2222827 2222827 defendant Steverdale John de     Steverdale, John de 5
4572066 2222827 2222827 defendant Leche William   641476 641476 Leche, William, of Baslowe 6
4572067 2222827 2222827 defendant Ipstone John de     Ipstone, John de 7
4572068 2222827 2222827 defendant Holylegh Thomas de     Holylegh, Thomas de 8
4572069 2222827 2222827 defendant Whiteleg Hugh     Whiteleg, Hugh 9
4572070 2222827 2222827 defendant Bayle Nicholas   770862 770862 Bayle, Nicholas, of Pylsboure 10
4572071 2222827 2222827 defendant del Hyde William     del Hyde, William 11
4572072 2222827 2222827 defendant Calton John de   770863 770863 Calton, John de, of Cal_ 12
4572073 2222827 2222827 defendant Menrell John   770853 770853 Menrell, John, of Calnore 13
4572074 2222827 2222827 defendant Ryley William de   770853 770853 Ryley, William de, of Calnore 14
4572075 2222827 2222827 defendant Wales John de   770853 770853 Wales, John de, of Calnore 15
4572076 2222827 2222827 defendant Hobson Thomas     Hobson, Thomas 16
4572077 2222827 2222827 defendant del _ William     del _, William 17
4572078 2222827 2222827 defendant Henreson Henry   770864 770864 Henreson, Henry, of Steverdale 18
4572079 2222827 2222827 defendant Blaunche Henry     Blaunche, Henry 19

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