names

15 rows where case_id = 2244529

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4644679 2244529 2244529 plaintiff Marton Richard clerk   Marton, Richard, clerk 0
4644680 2244529 2244529 defendant Oude Henry   593363 593363 Oude, Henry, of Thrapston 0
4644681 2244529 2244529 defendant Northern Henry clerk   Northern, Henry, clerk 1
4644682 2244529 2244529 defendant Raven John     Raven, John 2
4644683 2244529 2244529 defendant Wytheryn John clerk   Wytheryn, John, clerk 3
4644684 2244529 2244529 defendant Spenser John chaplain   Spenser, John, chaplain 4
4644685 2244529 2244529 defendant Grene William clerk   Grene, William, clerk 5
4644686 2244529 2244529 defendant Wolston Robert clerk   Wolston, Robert, clerk 6
4644687 2244529 2244529 defendant Burdet John chaplain   Burdet, John, chaplain 7
4644688 2244529 2244529 defendant atte Water William clerk   atte Water, William, clerk 8
4644689 2244529 2244529 defendant Raundes John chaplain   Raundes, John, chaplain 9
4644690 2244529 2244529 defendant Staunton William formerly parson of the church of St Andrew 716874 716874 Staunton William, of Cranford, formerly parson of the church of St Andrew 10
4644691 2244529 2244529 defendant Wodeward John, sen     Wodeward, John, sen 11
4644692 2244529 2244529 defendant Haycroft Richard     Haycroft, Richard 12
4644693 2244529 2244529 defendant Crosby Richard clerk   Crosby, Richard, clerk 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);