names

14 rows where case_id = 2453985

✎ 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
5329789 2453985 2453985 plaintiff Banbury John     Banbury, John 0
5329790 2453985 2453985 plaintiff Smyth John     Smyth, John 1
5329791 2453985 2453985 defendant Lee Nicholas   593955 593955 Lee, Nicholas, of London, bladesmith 0
5329792 2453985 2453985 defendant Lee John cordwainer 591343 591343 Lee, John, of Chepyng Norton, Oxon, cordwainer 1
5329793 2453985 2453985 defendant Newyth John clerk 597723 597723 Newyth, John, of Homyngton, clerk 2
5329794 2453985 2453985 defendant Edmay Thomas husbandman 597723 597723 Edmay, Thomas, of Homyngton, husbandman 3
5329795 2453985 2453985 defendant Edmay John husbandman 597723 597723 Edmay, John, of Homyngton, husbandman 4
5329796 2453985 2453985 defendant Taillour William husbandman 597723 597723 Taillour, William, of Homyngton, husbandman 5
5329797 2453985 2453985 defendant Haukyns Thomas husbandman 597723 597723 Haukyns, Thomas, of Homyngton, husbandman 6
5329798 2453985 2453985 defendant Childe John, senior husbandman 597723 597723 Childe, John, senior, of Homyngton, husbandman 7
5329799 2453985 2453985 defendant Braundys John husbandman 597723 597723 Braundys, John, of Homyngton, husbandman 8
5329800 2453985 2453985 defendant Smyth Thomas husbandman 597723 597723 Smyth, Thomas, of Homyngton, husbandman 9
5329801 2453985 2453985 defendant Parkys Richard husbandman 597723 597723 Parkys, Richard, of Homyngton, husbandman 10
5329802 2453985 2453985 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);