names

37 rows where case_id = 2467667

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5374616 2467667 2467667 plaintiff Parsons or Person Christopher clerk   Parsons or Person, Christopher, clerk 0
5374617 2467667 2467667 defendant Hesketh John gent 604626 604626 Hesketh, John, of Whalley, Lancs, gent 0
5374618 2467667 2467667 defendant Shotilworth Gilbert gent 689596 689596 Shotilworth, Gilbert, of Whalley, gent 1
5374619 2467667 2467667 defendant Shotilworth Robert gent 879641 879641 Shotilworth, Robert, of Blackburn, Lancs, gent 2
5374620 2467667 2467667 defendant Levesey Percival gent 667292 667292 Levesey, Percival, of Blackburn, gent 3
5374621 2467667 2467667 defendant Cunteclyff Richard gent 879642 879642 Cunteclyff, Richard, of Cuntclyff, Lancs, gent 4
5374622 2467667 2467667 defendant Parker Giles yeoman 879643 879643 Parker, Giles, of Hurrokford, Lancs, yeoman 5
5374623 2467667 2467667 defendant Crummok Robert yeoman 689596 689596 Crummok, Robert, of Whalley, yeoman 6
5374624 2467667 2467667 defendant Forster Henry yeoman 689596 689596 Forster, Henry, of Whalley, yeoman 7
5374625 2467667 2467667 defendant Couper Christopher yeoman 689596 689596 Couper, Christopher, of Whalley, yeoman 8
5374626 2467667 2467667 defendant Couper William laborer 689596 689596 Couper, William, of Whalley, laborer 9
5374627 2467667 2467667 defendant Coke William yeoman 689596 689596 Coke, William, of Whalley, yeoman 10
5374628 2467667 2467667 defendant Shagh John yeoman 689596 689596 Shagh, John, of Whalley, yeoman 11
5374629 2467667 2467667 defendant Wolton James yeoman 689596 689596 Wolton, James, of Whalley, yeoman 12
5374630 2467667 2467667 defendant Wolton John yeoman 689596 689596 Wolton, John, of Whalley, yeoman 13
5374631 2467667 2467667 defendant Wolton Ralph yeoman 689596 689596 Wolton, Ralph, of Whalley, yeoman 14
5374632 2467667 2467667 defendant Grenefeld Thomas   879644 879644 Grenefeld, Thomas, of Whalley, yeoamn 15
5374633 2467667 2467667 defendant Fole Robert yeoman 689596 689596 Fole, Robert, of Whalley, yeoman 16
5374634 2467667 2467667 defendant Pollard George yeoman 689596 689596 Pollard, George, of Whalley, yeoman 17
5374635 2467667 2467667 defendant Thornekar Thomas yeoman 689596 689596 Thornekar, Thomas, of Whalley, yeoman 18
5374636 2467667 2467667 defendant Deuherst Thomas yeoman 689596 689596 Deuherst, Thomas, of Whalley, yeoman 19
5374637 2467667 2467667 defendant Crauyn Henry laborer 689596 689596 Crauyn, Henry, of Whalley, laborer 20
5374638 2467667 2467667 defendant Crauyn William yeoman 689596 689596 Crauyn, William, of Whalley, yeoman 21
5374639 2467667 2467667 defendant Rauyn William yeoman 689596 689596 Rauyn, William, of Whalley, yeoman 22
5374640 2467667 2467667 defendant Clayton Ellis laborer 689596 689596 Clayton, Ellis, of Whalley, laborer 23
5374641 2467667 2467667 defendant Clayton Robert souter 689596 689596 Clayton, Robert, of Whalley, souter 24
5374642 2467667 2467667 defendant Robynson Nicholas laborer 689596 689596 Robynson, Nicholas, of Whalley, laborer 25
5374643 2467667 2467667 defendant Couper John yeoman 689596 689596 Couper, John, of Whalley, yeoman 26
5374644 2467667 2467667 defendant Deuhurst Nicholas yeoman 689596 689596 Deuhurst, Nicholas, of Whalley, yeoman 27
5374645 2467667 2467667 defendant Deyne John yeoman 689596 689596 Deyne, John, of Whalley, yeoman 28
5374646 2467667 2467667 defendant Mitton William laborer 879645 879645 Mitton, William, of Wiswall, Lancs, laborer 29
5374647 2467667 2467667 defendant Mitton John laborer 879646 879646 Mitton, John, of Wiswall, laborer 30
5374648 2467667 2467667 defendant Whiteacre James yeoman 879647 879647 Whiteacre, James, of Henthorn, Lancs, yeoman 31
5374649 2467667 2467667 defendant Hancok Robert laborer 689596 689596 Hancok, Robert, of Whalley, laborer 32
5374650 2467667 2467667 defendant Croke Christopher laborer 879648 879648 Croke, Christopher, of Billyngton, Lancs, laborer 33
5374651 2467667 2467667 defendant Wode Robert laborer 822185 822185 Wode, Robert, of Penulton, Lancs, laborer 34
5374652 2467667 2467667 defendant Shotilworth Oliver   689596 689596 Shotilworth, Oliver, of Whalley, yeoman & lots & lots more of the Forest of Bowland, apparently in Yorkshire 35

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