names

13 rows where case_id = 2013752

✎ 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
3968906 2013752 2013752 plaintiff Colbarne Edward     Colbarne, Edward 0
3968907 2013752 2013752 defendant Russell John clerk 598911 598911 Russell, John, of Colwyche, clerk 0
3968908 2013752 2013752 defendant Cowper Robert husbandman 663454 663454 Cowper, Robert, of Rydware Meveson, husbandman 1
3968909 2013752 2013752 defendant Patricke William butcher 597328 597328 Patricke, William, of Leke, butcher 2
3968910 2013752 2013752 defendant Woodcocke Nicholas gent 599622 599622 Woodcocke, Nicholas, of Elforde, gent 3
3968911 2013752 2013752 defendant Porter John glasier 663455 663455 Porter, John, of Bromley Pagett, glasier 4
3968912 2013752 2013752 defendant Lane George yeoman 621391 621391 Lane, George, of Handesworth, yeoman 5
3968913 2013752 2013752 defendant Coke Cassandra widow 602113 602113 Coke, Cassandra, of Gnossall, widow 6
3968914 2013752 2013752 defendant Bollarde John yeoman 590430 590430 Bollarde, John, of Lichfeld, yeoman 7
3968915 2013752 2013752 defendant Hyll Robert gent 611503 611503 Hyll, Robert, of Adderston, Warks, gent 8
3968916 2013752 2013752 defendant Marten James   601537 601537 Marten, James, of Wall, physician 9
3968917 2013752 2013752 defendant Stonyng Thomas clerk 595741 595741 Stonyng, Thomas, of Nuneton, clerk 10
3968918 2013752 2013752 defendant Stockdayle John yeoman 587089 587089 Stockdayle, John, of Burton on Trent, yeoman 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);