names

787 rows where place_id = 587114

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590507 1864675 1864675 defendant Trote William mercer 587114 587114 Trote, William, of Bodmyn, mercer 0
3590508 1864675 1864675 defendant Richard John mercer 587114 587114 Richard, John, of Bodmyn, mercer 1
3592522 1865276 1865276 plaintiff Glyn John merchant 587114 587114 Glyn, John, of Bodmyn, merchant 0
3592523 1865276 1865276 defendant Credowe Ralph yeoman 587114 587114 Credowe, Ralph, of Bodmyn, yeoman 0
3593640 1865645 1865645 defendant Jenyn Odo saddler 587114 587114 Jenyn, Odo, of Bodmyn, saddler 0
3593641 1865645 1865645 defendant Cokke William merchant 587114 587114 Cokke, William, of Bodmyn, merchant 1
3593642 1865645 1865645 defendant Pole William skinner 587114 587114 Pole, William, of Bodmyn, skinner 2
3593646 1865646 1865646 defendant Jenyn Odo saddler 587114 587114 Jenyn, Odo, of Bodmyn, saddler 2
3593647 1865646 1865646 defendant Cokke William merchant 587114 587114 Cokke, William, of Bodmyn, merchant 3
3593648 1865646 1865646 defendant Pole William skinner 587114 587114 Pole, William, of Bodmyn, skinner 4
3596507 1866540 1866540 defendant Trote William, junior mercer 587114 587114 Trote, William, junior, of Bodmyn, mercer 0
3599357 1867442 1867442 defendant Southwod Thomas gent 587114 587114 Southwod, Thomas, of Bodmyn, gent 0
3599915 1867629 1867629 plaintiff Wattys John   587114 587114 Wattys, John, of Bodmyn 0
3599919 1867630 1867630 plaintiff Wattys John   587114 587114 Wattys, John, of Bodmyn 0
3599924 1867631 1867631 plaintiff Wattys John   587114 587114 Wattys, John, of Bodmyn 0
3599926 1867632 1867632 plaintiff Wattys John merchant 587114 587114 Wattys, John, of Bodmyn, merchant 0
3599928 1867633 1867633 plaintiff Wattys John merchant 587114 587114 Wattys, John, of Bodmyn, merchant 0
3600594 1867832 1867832 defendant Tankerd Nicholas cordwainer 587114 587114 Tankerd, Nicholas, of Bodmyn, cordwainer 4
3601161 1868027 1868027 defendant Cokke William merchant 587114 587114 Cokke, William, of Bodmyn, merchant 0
3601163 1868028 1868028 defendant Cokke William merchant 587114 587114 Cokke, William, of Bodmyn, merchant 0
3601885 1868244 1868244 defendant Cokke William yeoman 587114 587114 Cokke, William, of Bodmyn, yeoman 0
3604713 1869137 1869137 defendant Caredowe Ralph innholder 587114 587114 Caredowe, Ralph, of Bodmyn, innholder 0
3607423 1869981 1869981 defendant Cokke William merchant 587114 587114 Cokke, William, of Bodmyn, merchant 0
3610865 1871069 1871069 defendant Rothyn Thomas husbandman 587114 587114 Rothyn, Thomas, of Bodmyn, husbandman 0
3610866 1871069 1871069 defendant Renaweden Richard, junior miller 587114 587114 Renaweden, Richard, junior, of Bodmyn, miller 1
3611662 1871315 1871315 defendant Tankard John clerk 587114 587114 Tankard, John, of Bodmyn, clerk 0
3611663 1871315 1871315 defendant Tankard Henry chaplain 587114 587114 Tankard, Henry, of Bodmyn, chaplain 1
3611664 1871315 1871315 defendant Colyn Thomas smith 587114 587114 Colyn, Thomas, of Bodmyn, smith 2
3611665 1871315 1871315 defendant Colepet John weaver 587114 587114 Colepet, John, of Bodmyn, weaver 3
3611666 1871315 1871315 defendant Blygh Richard draper 587114 587114 Blygh, Richard, of Bodmyn, draper 4
3611667 1871315 1871315 defendant Tankard Nicholas cordwainer 587114 587114 Tankard, Nicholas, of Bodmyn, cordwainer 5
3621465 1874254 1874254 plaintiff Newehall John   587114 587114 Newehall, John, of Bodmyn 0
3621466 1874254 1874254 defendant Peryn alias Hogge Martin weaver 587114 587114 Peryn alias Hogge, Martin, of Bodmyn, weaver 0
3626814 1903237 1903237 defendant Wyott Richard cordwainer 587114 587114 Wyott, Richard, of Bodmyn, cordwainer 0
3626815 1903237 1903237 defendant Northey William draper 587114 587114 Northey, William, of Bodmyn, draper 1
3629446 1904065 1904065 defendant Nicoll William   587114 587114 Nicoll, William, of Bodmyn, surgeon 3
3630003 1904236 1904236 defendant Seggemore William merchant 587114 587114 Seggemore, William, of Bodmyn, merchant 0
3634054 1905449 1905449 defendant Rose Stephen butcher 587114 587114 Rose, Stephen, of Bodmyn, butcher 0
3634055 1905449 1905449 defendant Pawle David mercer 587114 587114 Pawle, David, of Bodmyn, mercer 1
3634056 1905449 1905449 defendant Trote William, junior yeoman 587114 587114 Trote, William, junior, of Bodmyn, yeoman 2
3635560 1905926 1905926 defendant Jenyn Udo saddler 587114 587114 Jenyn, Udo, of Bodmyn, saddler 0
3635561 1905926 1905926 defendant Thomas John widow 587114 587114 Thomas, John, of Bodmyn, widow 1
3635562 1905926 1905926 defendant Plympton Thomas   587114 587114 Plympton, Thomas, of Bodmyn, mason 2
3636503 1906210 1906210 defendant Coche John butcher 587114 587114 Coche, John, of Bodmyn, butcher 0
3638049 1906719 1906719 defendant Seggemoure William mercer 587114 587114 Seggemoure, William, of Bodmyn, mercer 0
3638050 1906719 1906719 defendant Tankard Nicholas cordwainer 587114 587114 Tankard, Nicholas, of Bodmyn, cordwainer 1
3641385 1907759 1907759 defendant Tomlyn John, junior laborer 587114 587114 Tomlyn, John, junior, of Bodmyn, laborer 0
3641386 1907759 1907759 defendant Gere Thomas, junior laborer 587114 587114 Gere, Thomas, junior, of Bodmyn, laborer 1
3645287 1908935 1908935 defendant Huchyn John yeoman 587114 587114 Huchyn, John, of Bodmyn, yeoman 0
3645288 1908935 1908935 defendant Huchyn Richard yeoman 587114 587114 Huchyn, Richard, of Bodmyn, yeoman 1
3647396 1909574 1909574 defendant Rawlyn John tanner 587114 587114 Rawlyn, John, of Bodmyn, tanner 0
3647397 1909574 1909574 defendant Hancok Richard yeoman 587114 587114 Hancok, Richard, of Bodmyn, yeoman 1
3649018 1910081 1910081 defendant Trote alias Trett Thomas gent 587114 587114 Trote alias Trett, Thomas, of Bodmyn, gent 0
3649023 1910083 1910083 defendant Trote Thomas gent 587114 587114 Trote, Thomas, of Bodmyn, gent 0
3652090 1911001 1911001 defendant Hardwarman Peter haberdasher 587114 587114 Hardwarman, Peter, of Bodmyn, haberdasher 0
3652094 1911003 1911003 defendant Sagemore William merchant 587114 587114 Sagemore, William, of Bodmyn, merchant 0
3652418 1911090 1911090 defendant Martyn William, junior husbandman 587114 587114 Martyn, William, junior, of Bodmyn, husbandman 1
3652970 1911260 1911260 defendant Renowdyn Richard yeoman 587114 587114 (Renowdyn, Richard, of Bodmyn, yeoman 1
3654475 1911659 1911659 defendant Gyll Bartholomew   587114 587114 Gyll, Bartholomew, of Bodmyn, "holyer" 0
3655624 1912022 1912022 defendant Wodcok John yeoman 587114 587114 Wodcok, John, of Bodmyn, yeoman 0
3660654 1913596 1913596 defendant Penheskyn Nicholas   587114 587114 Penheskyn, Nicholas, of Bodmyn 0
3661236 1913792 1913792 defendant Trote William yeoman 587114 587114 Trote, William, of Bodmyn, yeoman 0
3661245 1913794 1913794 defendant Frenche John tanner 587114 587114 Frenche, John, of Bodmyn, tanner 0
3661246 1913794 1913794 defendant Hary Stephen laborer 587114 587114 Hary, Stephen, of Bodmyn, laborer 1
3661259 1913797 1913797 defendant Lavedewyn John   587114 587114 Lavedewyn, John, of Bodmyn, frankelyn 0
3663669 1914571 1914571 defendant Philip Margery widow 587114 587114 Philip, Margery, of Bodmyn, widow 2
3666624 1915504 1915504 defendant Harry Nicholas, senior tanner 587114 587114 Harry, Nicholas, senior, of Bodmyn, tanner 0
3676765 1918768 1918768 defendant Lavydywyn John   587114 587114 Lavydywyn, John, of Bodmyn, franklin 0
3676791 1918776 1918776 defendant Gunner John tucker 587114 587114 Gunner, John, of Bodmyn, tucker 4
3678887 1919464 1919464 defendant Blygh Richard, senior draper 587114 587114 Blygh, Richard, senior, of Bodmyn, draper 0
3682840 1920740 1920740 defendant Bryand John miller 587114 587114 Bryand, John, of Bodmyn, miller 0
3686062 1921800 1921800 defendant Cowche John laborer 587114 587114 Cowche, John, of Bodmyn, laborer 0
3690016 1923036 1923036 defendant Opy Thomas   587114 587114 Opy, Thomas, of Bodmyn, mason 0
3690017 1923036 1923036 defendant Wyllet Bartholomew yeoman 587114 587114 Wyllet, Bartholomew, of Bodmyn, yeoman 1
3693709 1924226 1924226 defendant Chaundeler William chapman 587114 587114 Chaundeler, William, of Bodmyn, chapman 0
3698431 1925729 1925729 defendant Lethlyan Richard smith 587114 587114 Lethlyan, Richard, of Bodmyn, smith 0
3698432 1925729 1925729 defendant Mason William   587114 587114 Mason, William, of Bodmyn, mason 1
3699088 1925922 1925922 plaintiff Whyte John merchant 587114 587114 Whyte, John, of Bodmyn, merchant 0
3700635 1926446 1926446 defendant Lavedwyn John gent 587114 587114 Lavedwyn, John, of Bodmyn, gent 1
3702141 1926929 1926929 defendant Coche William, senior butcher 587114 587114 Coche, William, senior, of Bodmyn, butcher 0
3702941 1927189 1927189 defendant Trote Alice widow 587114 587114 Trote, Alice, of Bodmyn, widow 0
3702942 1927189 1927189 defendant Borowe John mercer 587114 587114 Borowe, John, of Bodmyn, mercer 1
3703047 1927227 1927227 defendant Borowe John mercer 587114 587114 Borowe, John, of Bodmyn, mercer 0
3703048 1927227 1927227 defendant Vyvyan John yeoman 587114 587114 Vyvyan, John, of Bodmyn, yeoman 1
3704685 1927752 1927752 defendant Glyn John gent 587114 587114 Glyn, John, of Bodmyn, gent 0
3704803 1927794 1927794 plaintiff Glyn John merchant 587114 587114 Glyn, John, of Bodmyn, merchant 0
3704804 1927794 1927794 defendant Baron Nicholas mercer 587114 587114 Baron, Nicholas, of Bodmyn, mercer 0
3708936 1929087 1929087 defendant Edycott Thomas yeoman 587114 587114 Edycott, Thomas, of Bodmyn, yeoman 0
3713680 1930575 1930575 defendant Russell John draper 587114 587114 Russell, John, of Bodmyn, draper 1
3715347 1931083 1931083 defendant Rechard John (legal representative) 587114 587114 Rechard, John, of Bodmyn, merchant, administratrix of 0
3715348 1931083 1931083 defendant Rechard Blanche widow 587114 587114 Rechard, Blanche, of Bodmyn, widow 1
3717751 1931853 1931853 plaintiff Elyn John merchant 587114 587114 Elyn, John, of Bodmyn, merchant 0
3717752 1931853 1931853 defendant Baron Nicholas mercer 587114 587114 Baron, Nicholas, of Bodmyn, mercer 0
3717856 1931887 1931887 defendant Kyllygrewe Alexander gent 587114 587114 Kyllygrewe, Alexander, of Bodmyn, gent 0
3718787 1932156 1932156 defendant Byttok John pewterer 587114 587114 Byttok, John, of Bodmyn, pewterer 0
3720504 1932695 1932695 defendant Rosy Stephen butcher 587114 587114 Rosy, Stephen, of Bodmyn, butcher 0
3725704 1934327 1934327 defendant Free Matilda widow 587114 587114 Free, Matilda, of Bodmyn, widow 0
3726663 1934601 1934601 plaintiff Trefrey John (legal representative) 587114 587114 Trefrey, John, of Bodmyn, executor of 0
3727476 1934870 1934870 defendant Androwe William tanner 587114 587114 Androwe, William, of Bodmyn, tanner 0
3727477 1934870 1934870 defendant White Thomas baker 587114 587114 White, Thomas, of Bodmyn, baker 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);