names

13 rows where case_id = 2491939

✎ 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
5456740 2491939 2491939 plaintiff Cokayn Thomas     Cokayn, Thomas 0
5456741 2491939 2491939 defendant Coton Thomas yeoman 586028 586028 Coton, Thomas, of Tamworth, yeoman 0
5456742 2491939 2491939 defendant Coton Roger yeoman 586028 586028 Coton, Roger, of Tamworth, yeoman 1
5456743 2491939 2491939 defendant Goldson Nicholas yeoman 889567 889567 Goldson, Nicholas, of Pollysseworth, yeoman 2
5456744 2491939 2491939 defendant Clowys John husbandman 889568 889568 Clowys, John, of Dastall, husbandman 3
5456745 2491939 2491939 defendant Clowys Robert husbandman 889568 889568 Clowys, Robert, of Dastall, husbandman 4
5456746 2491939 2491939 defendant Halle John husbandman 889568 889568 Halle, John, of Dastall, husbandman 5
5456747 2491939 2491939 defendant Hertyll John husbandman 598161 598161 Hertyll, John, of Clyffe, husbandman 6
5456748 2491939 2491939 defendant Boteler William jun, of Watteley, husbandman   Boteler, William, jun, of Watteley, husbandman 7
5456749 2491939 2491939 defendant Vyncent Nicholas husbandman 889569 889569 Vyncent, Nicholas, of Whatteley, husbandman 8
5456750 2491939 2491939 defendant Scalys Henry husbandman 606776 606776 Scalys, Henry, of Warton, husbandman 9
5456751 2491939 2491939 defendant Hamond William husbandman 606776 606776 Hamond, William, of Warton, husbandman 10
5456752 2491939 2491939 defendant Kynge Roger husbandman 628062 628062 Kynge, 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);