names

2,049,671 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587383 1863695 1863695 defendant Fysshecok Robert clothmaker 585863 585863 Fysshecok, Robert, of Bedynden, clothmaker 0
3587384 1863695 1863695 defendant Andrewson Robert fuller 585864 585864 Andrewson, Robert, of Cranebroke, fuller 1
3587385 1863696 1863696 defendant Smyth John yeoman 585865 585865 Smyth, John, of Kyngeston Bowecy, yeoman 0
3587386 1863696 1863696 defendant Berd Edward yeoman 585866 585866 Berd, Edward, of Shermanbury, yeoman 1
3587387 1863697 1863697 defendant Smyth Thomas yeoman 585867 585867 Smyth, Thomas, of Maughfeld, yeoman 0
3587388 1863698 1863698 defendant Palmer John husbandman 585868 585868 Palmer, John, of Chepsted, Kent, husbandman 0
3587389 1863699 1863699 defendant Toft Henry gent 585869 585869 Toft, Henry, of London, gent 0
3587390 1863700 1863700 defendant Bevyn or Benyn Thomas mercer 585870 585870 Bevyn or Benyn, Thomas, of Brygewater, Soms, mercer 0
3587391 1863700 1863700 defendant Best Richard merchant 585871 585871 Best, Richard, of Taunton, Soms, merchant 1
3587392 1863701 1863701 plaintiff A Berough Thomas     A Berough, Thomas 0
3587393 1863701 1863701 defendant Draner or Draver John clothmaker 585864 585864 Draner or Draver, John, of Cranebroke, clothmaker 0
3587394 1863702 1863702 plaintiff A Berowe Arnold     A Berowe, Arnold 0
3587395 1863702 1863702 defendant Dod Hamon husbandman 585872 585872 Dod, Hamon, of Wy, husbandman 0
3587396 1863702 1863702 defendant Coke William tanner 585872 585872 Coke, William, of Wy, tanner 1
3587397 1863703 1863703 plaintiff A Boure Thomas     A Boure, Thomas 0
3587398 1863703 1863703 defendant Brette John husbandman 585873 585873 Brette, John, of High Crosse, Stondon, husbandman 0
3587399 1863704 1863704 plaintiff A Laweton Hugh gent   A Laweton, Hugh, gent 0
3587400 1863704 1863704 defendant Brusellys James tailor 585874 585874 Brusellys, James, of Hatfeld Peverell, Essex, tailor 0
3587401 1863705 1863705 plaintiff A Lee Edward     A Lee, Edward 0
3587402 1863705 1863705 defendant Norton Stephen   589249 589249 Norton, Stephen, of Chart juxta Sutton Valance, getn 0
3587403 1863705 1863705 defendant Hooke Alexander laborer 585876 585876 Hooke, Alexander, of Ottham, laborer 1
3587404 1863705 1863705 defendant Sagge Thomas laborer 585877 585877 Sagge, Thomas, of Chart, laborer 2
3587405 1863706 1863706 plaintiff A Sandon Henry, junior son of A Sandon, Henry, senior   A Sandon, Henry, junior, son of A Sandon, Henry, senior 0
3587406 1863706 1863706 defendant Lane Richard tailor 585878 585878 Lane, Richard, of Basyngbourn, Cams, tailor 0
3587407 1863707 1863707 plaintiff A Wode John     A Wode, John 0
3587408 1863707 1863707 defendant Cokerham Robert husbandman 585879 585879 Cokerham, Robert, of Nymet Episcopi, husbandman 0
3587409 1863708 1863708 plaintiff Abell Isbel (legal representative)   Abell, Isbel, executrix of Abell, William, executor of 0
3587410 1863708 1863708 plaintiff Parker Thomas ironmonger 585869 585869 Parker, Thomas, of London, ironmonger 1
3587411 1863708 1863708 defendant Osborne Isabel chapman 616353 616353 Osborne, Isabel, of Colbroke, Middx, widow of Osborne, Nicholas, of Colbroke, chapman 0
3587412 1863708 1863708 defendant Twichener John draper 585881 585881 Twichener, John, of Wokyngham, Berks, draper 1
3587413 1863708 1863708 defendant Morys William fuller 585882 585882 Morys, William, of Wokyngham, fuller 2
3587414 1863708 1863708 defendant Lane John   585869 585869 Lane, John, of London, gent, registrar for Bishop of Lincoln 3
3587415 1863709 1863709 plaintiff Abell Rrobert yeoman 585884 585884 Abell, Rrobert, of Mullberton, yeoman 0
3587416 1863709 1863709 defendant Tiryngton Robert yeoman 585885 585885 Tiryngton, Robert, of Wikewode, yeoman 0
3587417 1863710 1863710 plaintiff Abraham Thomas grocer 585869 585869 Abraham, Thomas, of London, grocer 0
3587418 1863710 1863710 defendant Mugge Walter gent 585886 585886 Mugge, Walter, of Guldeford, Surrey, gent 0
3587419 1863710 1863710 defendant Daweson William dyer 585887 585887 Daweson, William, of Guldeford, dyer 1
3587420 1863710 1863710 defendant Alby John carpenter 585888 585888 Alby, John, of Maidstone, Kent, carpenter 2
3587421 1863711 1863711 plaintiff Abraham Thomas grocer 585869 585869 Abraham, Thomas, of London, grocer 0
3587422 1863711 1863711 defendant Mugge Walter gent 585886 585886 Mugge, Walter, of Guldeford, Surrey, gent 0
3587423 1863711 1863711 defendant Daweson William dyer 585887 585887 Daweson, William, of Guldeford, dyer 1
3587424 1863711 1863711 defendant Lilly John carpenter 585888 585888 Lilly, John, of Maidstone, Kent, carpenter 2
3587425 1863712 1863712 plaintiff Abraham Thomas grocer 585869 585869 Abraham, Thomas, of London, grocer 0
3587426 1863712 1863712 defendant Rayner Andrew chapman 585889 585889 Rayner, Andrew, of Some, Isle of Ely, Cams, chapman 0
3587427 1863712 1863712 defendant Snell John chapman 585890 585890 Snell, John, of Hampsted Marchall, Berks, chapman 1
3587428 1863712 1863712 defendant Bray Peter chapman 585891 585891 Bray, Peter, of Hampsted Marchall, chapman 2
3587429 1863713 1863713 plaintiff Abraham Thomas grocer 585869 585869 Abraham, Thomas, of London, grocer 0
3587430 1863713 1863713 defendant Robynson Thomas mercer 585892 585892 Robynson, Thomas, of Welwyn, Herts, mercer 0
3587431 1863714 1863714 plaintiff Abson Richard clerk   Abson, Richard, clerk 0
3587432 1863714 1863714 defendant Smyth Robert husbandman 585893 585893 Smyth, Robert, of Barnby on Donne, husbandman 0
3587433 1863714 1863714 defendant Norton Thomas husbandman 585894 585894 Norton, Thomas, of Carcroft, Suston, husbandman 1
3587434 1863715 1863715 plaintiff Abson William     Abson, William 0
3587435 1863715 1863715 defendant Bussell Robert, junior laborer 585895 585895 Bussell, Robert, junior, of Mekesburgh, laborer 0
3587436 1863715 1863715 defendant Sheperd John husbandman 585895 585895 Sheperd, John, of Mekesburgh, husbandman 1
3587437 1863716 1863716 plaintiff Abson William     Abson, William 0
3587438 1863716 1863716 defendant Bussell Robert, junior laborer 585895 585895 Bussell, Robert, junior, of Mekesburgh, laborer 0
3587439 1863716 1863716 defendant Sheperd John nailer 585895 585895 Sheperd, John, of Mekesburgh, husbandman, son of Sheperd, John, nailer 1
3587440 1863717 1863717 plaintiff Ackelane Baldwin     Ackelane, Baldwin 0
3587441 1863717 1863717 defendant Gay John gent 585897 585897 Gay, John, of Parkeham, Devon, gent 0
3587442 1863718 1863718 plaintiff Ackelane Baldwin     Ackelane, Baldwin 0
3587443 1863718 1863718 defendant Gay John gent 585897 585897 Gay, John, of Parkeham, Devon, gent 0
3587444 1863719 1863719 plaintiff Acton dmund gent   Acton, dmund, gent 0
3587445 1863719 1863719 defendant Elyot Lawrence maltman 585898 585898 Elyot, Lawrence, of Shytlyngton, maltman 0
3587446 1863720 1863720 plaintiff Acton John     Acton, John 0
3587447 1863720 1863720 defendant Cony William yeoman 585899 585899 Cony, William, of Shordyche, yeoman 0
3587448 1863721 1863721 plaintiff Acton John     Acton, John 0
3587449 1863721 1863721 defendant Cony William yeoman 585899 585899 Cony, William, of Shordyche, yeoman 0
3587450 1863722 1863722 plaintiff Acton John     Acton, John 0
3587451 1863722 1863722 defendant Cony William yeoman 585899 585899 Cony, William, of Shordyche, yeoman 0
3587452 1863723 1863723 plaintiff Adam John     Adam, John 0
3587453 1863723 1863723 defendant Gardener Richard chaplain 585900 585900 Gardener, Richard, of Saham Tony, chaplain 0
3587454 1863724 1863724 plaintiff Adam William     Adam, William 0
3587455 1863724 1863724 defendant Reyner William baker 585901 585901 Reyner, William, of Burwell, baker 0
3587456 1863725 1863725 plaintiff Adamason William clerk   Adamason, William, clerk 0
3587457 1863725 1863725 defendant Tomlyn John laborer 585902 585902 Tomlyn, John, of Reynham, laborer 0
3587458 1863726 1863726 plaintiff Adarle Joan former wife of Brocas, William, of Hants, esq   Adarle, Joan, former wife of Brocas, William, of Hants, esq, executors of 0
3587459 1863726 1863726 plaintiff Isham Richard gent   (Isham, Richard, gent 1
3587460 1863726 1863726 plaintiff Quynby Henry     Quynby, Henry 2
3587461 1863726 1863726 defendant Thorncombe Robert husbandman 585903 585903 Thorncombe, Robert, of Shaldeford, Surrey, husbandman 0
3587462 1863727 1863727 plaintiff Ade John     Ade, John 0
3587463 1863727 1863727 defendant Swyft Thomas yeoman 585904 585904 Swyft, Thomas, of Berton Bendyche, yeoman 0
3587464 1863727 1863727 defendant Warthyll Thomas clerk 585904 585904 Warthyll, Thomas, of Berton Bendyche, clerk 1
3587465 1863727 1863727 defendant Wodecok John yeoman 585905 585905 Wodecok, John, of Lytelport, Isle of Ely, Cams, yeoman 2
3587466 1863727 1863727 defendant Bryggesley John mariner 585906 585906 Bryggesley, John, of West Lynne, mariner 3
3587467 1863727 1863727 defendant Johnson alias Wysbyche John waterman 585907 585907 Johnson alias Wysbyche, John, of Bishops Lenn, waterman 4
3587468 1863728 1863728 plaintiff Ade John     Ade, John 0
3587469 1863728 1863728 defendant Whyte Edmund roper 585907 585907 Whyte, Edmund, of Bishops Lenn, roper 0
3587470 1863728 1863728 defendant Amy William husbandman 585908 585908 Amy, William, of Hyllyngton, husbandman 1
3587471 1863728 1863728 defendant Sherman William yeoman 585909 585909 Sherman, William, of Boxworth, Cams, yeoman 2
3587472 1863728 1863728 defendant Joote John yeoman 585910 585910 Joote, John, of Fulburn, Cams, yeoman 3
3587473 1863729 1863729 plaintiff Adgore Gregory     Adgore, Gregory 0
3587474 1863729 1863729 defendant Both Philip     Both, Philip 0
3587475 1863729 1863729 defendant Wode Thomas     Wode, Thomas 1
3587476 1863729 1863729 defendant Shakylden John     Shakylden, John 2
3587477 1863729 1863729 defendant Smyth Henry     Smyth, Henry 3
3587478 1863730 1863730 plaintiff Adyffe or Adysse Richard tailor 585869 585869 Adyffe or Adysse, Richard, of London, tailor 0
3587479 1863730 1863730 defendant Savage Robert yeoman 585911 585911 Savage, Robert, of Mortlake, Middx, yeoman 0
3587480 1863731 1863731 plaintiff Adys Miles     Adys, Miles 0
3587481 1863731 1863731 defendant Richardson William brewer 585912 585912 Richardson, William, of Highgate, Haryngay, brewer 0
3587482 1863731 1863731 defendant Savage John yeoman 585912 585912 Savage, John, of Highgate, Haryngay, yeoman 1

Next page

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