names

38 rows where case_id = 2453341

✎ 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
5327628 2453341 2453341 plaintiff Vernon Richard esq   Vernon, Richard, esq 0
5327629 2453341 2453341 defendant Furnesse Elias cordwainer 873855 873855 Furnesse, Elias, of Huklawe, Hope, cordwainer 0
5327630 2453341 2453341 defendant Rutter Thomas husandman 873855 873855 Rutter, Thomas, of Huklawe, Hope, husandman 1
5327631 2453341 2453341 defendant Barker Robert husbandman 873855 873855 Barker, Robert, of Huklawe, Hope, husbandman 2
5327632 2453341 2453341 defendant Hall Thomas yeoman 593236 593236 Hall, Thomas, of Bradwall, yeoman 3
5327633 2453341 2453341 defendant Middelton Robert yeoman 593236 593236 Middelton, Robert, of Bradwall, yeoman 4
5327634 2453341 2453341 defendant Middelton John husbandman 593236 593236 Middelton, John, of Bradwall, husbandman 5
5327635 2453341 2453341 defendant Slakke Richard yeoman 593236 593236 Slakke, Richard, of Bradwall, yeoman 6
5327636 2453341 2453341 defendant Poynton William yeoman 873855 873855 Poynton, William, of Huklawe, Hope, yeoman 7
5327637 2453341 2453341 defendant Slakke William yeoman 873856 873856 together with Slakke, William, of Shatton, Hope, yeoman 8
5327638 2453341 2453341 defendant Marshall John yeoman 873857 873857 Marshall, John, of Burgh, Hope, yeoman 9
5327639 2453341 2453341 defendant Marshall Nicholas husbandman 873858 873858 Marshall, Nicholas, of Abney, Hope, husbandman 10
5327640 2453341 2453341 defendant Marshall William laborer 873858 873858 Marshall, William, of Abney, Hope, laborer 11
5327641 2453341 2453341 defendant Holme Nicholas laborer 873857 873857 Holme, Nicholas, of Burgh, Hope, laborer 12
5327642 2453341 2453341 defendant Aleyn Hugh laborer 591227 591227 Aleyn, Hugh, of Hope, laborer 13
5327643 2453341 2453341 defendant Syward Nicholas yeoman 593236 593236 Syward, Nicholas, of Bradwall, yeoman 14
5327644 2453341 2453341 defendant Bradwall Thomas yeoman 593236 593236 Bradwall, Thomas, of Bradwall, yeoman 15
5327645 2453341 2453341 defendant Marshall Elias yeoman 593236 593236 Marshall, Elias, of Bradwall, yeoman 16
5327646 2453341 2453341 defendant Burton John husbandman 593236 593236 Burton, John, of Bradwall, husbandman 17
5327647 2453341 2453341 defendant Elotte William husbandman 593236 593236 Elotte, William, of Bradwall, husbandman 18
5327648 2453341 2453341 defendant Tounende William yeoman 593236 593236 Tounende, William, of Bradwall, yeoman 19
5327649 2453341 2453341 defendant Tounende Nicholas yeoman 593236 593236 Tounende, Nicholas, of Bradwall, yeoman 20
5327650 2453341 2453341 defendant Cokke Edward husbandman 593479 593479 Cokke, Edward, of Castelton, husbandman 21
5327651 2453341 2453341 defendant Hawe Hugh husbandman 593236 593236 Hawe, Hugh, of Bradwall, husbandman 22
5327652 2453341 2453341 defendant Elotte Robert husbandman 593236 593236 Elotte, Robert, of Bradwall, husbandman 23
5327653 2453341 2453341 defendant Cokke John husbandman 593236 593236 Cokke, John, of Bradwall, husbandman 24
5327654 2453341 2453341 defendant Cokke Richard yeoman 593236 593236 Cokke, Richard, of Bradwall, yeoman 25
5327655 2453341 2453341 defendant Hawe Richard yeoman 593236 593236 Hawe, Richard, of Bradwall, yeoman 26
5327656 2453341 2453341 defendant Burton Henry yeoman 586344 586344 Burton, Henry, of Burton, yeoman 27
5327657 2453341 2453341 defendant Eyre Thurstan yeoman 593236 593236 Eyre, Thurstan, of Bradwall, yeoman 28
5327658 2453341 2453341 defendant Tasker Thomas husbandman 593236 593236 Tasker, Thomas, of Bradwall, husbandman 29
5327659 2453341 2453341 defendant Iryssh William husbandman 593236 593236 Iryssh, William, of Bradwall, husbandman 30
5327660 2453341 2453341 defendant Johnson Hugh yeoman 593236 593236 Johnson, Hugh, of Bradwall, yeoman 31
5327661 2453341 2453341 defendant Smyth William husbandman 593236 593236 Smyth, William, of Bradwall, husbandman 32
5327662 2453341 2453341 defendant Hawe Thomas yeoman 593236 593236 Hawe, Thomas, of Bradwall, yeoman 33
5327663 2453341 2453341 defendant Bradwall Hugh yeoman 593236 593236 Bradwall, Hugh, of Bradwall, yeoman 34
5327664 2453341 2453341 defendant Bagshawe William yeoman 873859 873859 Bagshawe, William, of Berwaltone, yeoman 35
5327665 2453341 2453341 defendant Thomasson William husbandman 593236 593236 Thomasson, William, of Bradwall, husbandman 36

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