names

13 rows where case_id = 2358968

✎ 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
5007095 2358968 2358968 plaintiff Smyth Thomas     Smyth, Thomas 0
5007096 2358968 2358968 defendant Pulton Thomas gent 586263 586263 Pulton, Thomas, of Desburgh, gent 0
5007097 2358968 2358968 defendant Nayleston Thomas yeoman 590028 590028 together with Nayleston, Thomas, of Bukby, yeoman 1
5007098 2358968 2358968 defendant Herberd William yeoman 586848 586848 Herberd, William, of Northampton, yeoman 2
5007099 2358968 2358968 defendant Nayleston Thomas yeoman 590028 590028 Nayleston, Thomas, of Bukby, yeoman 3
5007100 2358968 2358968 defendant Herbered William yeoman 586848 586848 Herbered, William, of Northampton, yeoman 4
5007101 2358968 2358968 defendant Colyn Robert husbandman 626584 626584 Colyn, Robert, of Brykkesworth, husbandman 5
5007102 2358968 2358968 defendant Kychen John husbandman 626584 626584 Kychen, John, of Brykkesworth, husbandman 6
5007103 2358968 2358968 defendant Derby John laborer 590028 590028 Derby, John, of Bukby, laborer 7
5007104 2358968 2358968 defendant Taillour Peter tailor 590028 590028 Taillour, Peter, of Bukby, tailor 8
5007105 2358968 2358968 defendant Wylkyns Thomas yeoman 834117 834117 Wylkyns, Thomas, of Newebold by Monkes Kirkeby, Warws, yeoman 9
5007106 2358968 2358968 defendant Ive Robert yeoman 640632 640632 Ive, Robert, of Welford, Nhants, yeoman 10
5007107 2358968 2358968 defendant Marteyn William husbandman 821522 821522 Marteyn, William, of Bryklesworth, Nhants, husbandman 11

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