names

18 rows where case_id = 2013758

✎ 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
3968939 2013758 2013758 plaintiff Colbarne Edward gent   Colbarne, Edward, gent 0
3968940 2013758 2013758 defendant Russell John clerk 597105 597105 Russell, John, of Colwich, clerk 0
3968941 2013758 2013758 defendant Tyttensore Thomas yeoman 610147 610147 Tyttensore, Thomas, of Magna Fenton, yeoman 1
3968942 2013758 2013758 defendant Cowper Robert husbandman 663462 663462 Cowper, Robert, of Ridware Maveson, husbandman 2
3968943 2013758 2013758 defendant Trentham Thomas esq 663463 663463 Trentham, Thomas, of Roseter, esq 3
3968944 2013758 2013758 defendant Macclesfeld Ralph gent 660093 660093 Macclesfeld, Ralph, of Meare, gent 4
3968945 2013758 2013758 defendant Pattrycke William butcher 597441 597441 Pattrycke, William, of Leeke, butcher 5
3968946 2013758 2013758 defendant Woodcock Nicholas gent 599622 599622 Woodcock, Nicholas, of Elforde, gent 6
3968947 2013758 2013758 defendant Mytton alias Harpesfeld Edward esq 586386 586386 Mytton alias Harpesfeld, Edward, of Weston under Liziarde, esq 7
3968948 2013758 2013758 defendant Porter John glasier 663465 663465 Porter, John, of Bromley Paget, glasier 8
3968949 2013758 2013758 defendant Lane George yeoman 663466 663466 Lane, George, of Handesworthe, yeoman 9
3968950 2013758 2013758 defendant Coke Cassandra widow 663467 663467 Coke, Cassandra, of Quesall, widow 10
3968951 2013758 2013758 defendant Ballard John yeoman 590430 590430 Ballard, John, of Lichfeld, yeoman 11
3968952 2013758 2013758 defendant Ballard Gregory yeoman 590430 590430 Ballard, Gregory, of Lichfeld, yeoman 12
3968953 2013758 2013758 defendant Hyll Robert gent 611503 611503 Hyll, Robert, of Adderston, Warks, gent 13
3968954 2013758 2013758 defendant Marten James   601537 601537 Marten, James, of Wall, physician 14
3968955 2013758 2013758 defendant Stonyng Thomas clerk 595741 595741 Stonyng, Thomas, of Nuneton, clerk 15
3968956 2013758 2013758 defendant Stockdale John yeoman 587089 587089 Stockdale, John, of Burton on Trent, yeoman 16

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);