names

14 rows where case_id = 2453986

✎ 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
5329803 2453986 2453986 plaintiff Banbury John     Banbury, John 0
5329804 2453986 2453986 plaintiff Smyth John     Smyth, John 1
5329805 2453986 2453986 defendant Lee Nicholas   593955 593955 Lee, Nicholas, of London, bladesmith 0
5329806 2453986 2453986 defendant Lee John cordwainer 591343 591343 Lee, John, of Chepyng Norton, Oxon, cordwainer 1
5329807 2453986 2453986 defendant Newyth John clerk 597723 597723 Newyth, John, of Homyngton, clerk 2
5329808 2453986 2453986 defendant Edmay Thomas husbandman 597723 597723 Edmay, Thomas, of Homyngton, husbandman 3
5329809 2453986 2453986 defendant Edmay John husbandman 597723 597723 Edmay, John, of Homyngton, husbandman 4
5329810 2453986 2453986 defendant Taillour William husbandman 597723 597723 Taillour, William, of Homyngton, husbandman 5
5329811 2453986 2453986 defendant Haukyns Thomas husbandman 597723 597723 Haukyns, Thomas, of Homyngton, husbandman 6
5329812 2453986 2453986 defendant Childe John, senior husbandman 597723 597723 Childe, John, senior, of Homyngton, husbandman 7
5329813 2453986 2453986 defendant Braundys John husbandman 597723 597723 Braundys, John, of Homyngton, husbandman 8
5329814 2453986 2453986 defendant Smyth Thomas husbandman 597723 597723 Smyth, Thomas, of Homyngton, husbandman 9
5329815 2453986 2453986 defendant Parkys Richard husbandman 597723 597723 Parkys, Richard, of Homyngton, husbandman 10
5329816 2453986 2453986 defendant Walton Roger husbandman 597723 597723 Walton, Roger, of Homyngton, 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);