names

13 rows where case_id = 2495560

✎ 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
5468645 2495560 2495560 plaintiff Cokayn Thomas     Cokayn, Thomas 0
5468646 2495560 2495560 defendant Coton Stephen yeoman 586028 586028 Coton, Stephen, of Tamworth, yeoman 0
5468647 2495560 2495560 defendant Coton Roger yeoman 586028 586028 Coton, Roger, of Tamworth, yeoman 1
5468648 2495560 2495560 defendant Goldson Nicholas yeoman 890714 890714 Goldson, Nicholas, of Pollysseworthe, yeoman 2
5468649 2495560 2495560 defendant Clowye John husbandman 890715 890715 Clowye, John, of Dastel, husbandman 3
5468650 2495560 2495560 defendant Clowys Robert husbandman 889568 889568 Clowys, Robert, of Dastall, husbandman 4
5468651 2495560 2495560 defendant Halle John husbandman 889568 889568 Halle, John, of Dastall, husbandman 5
5468652 2495560 2495560 defendant Hertyll John husbandman 598161 598161 Hertyll, John, of Clyffe, husbandman 6
5468653 2495560 2495560 defendant Boteler William jun, of Attele, husbandman   Boteler, William, jun, of Attele, husbandman 7
5468654 2495560 2495560 defendant Vyncent Nicholas husbandman 890716 890716 Vyncent, Nicholas, of Watteley, husbandman 8
5468655 2495560 2495560 defendant Salys Henry husbandman 606776 606776 Salys, Henry, of Warton, husbandman 9
5468656 2495560 2495560 defendant Hamond William husbandman 606776 606776 Hamond, William, of Warton, husbandman 10
5468657 2495560 2495560 defendant Rynge Roger husbandman 628062 628062 Rynge, Roger, of Alstre, 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);