names

447 rows where place_id = 589532

✎ 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
3597884 1866960 1866960 defendant Jamys John husbandman 589532 589532 Jamys, John, of Fakenham, husbandman 2
3597885 1866960 1866960 defendant Jakson John butcher 589532 589532 Jakson, John, of Fakenham, butcher 3
3605611 1869419 1869419 defendant Proctour Thomas yeoman 589532 589532 Proctour, Thomas, of Fakenham, yeoman 4
3607260 1869935 1869935 defendant Harlwyn John draper 589532 589532 Harlwyn, John, of Fakenham, draper 0
3617077 1872964 1872964 defendant Hervy John weaver 589532 589532 Hervy, John, of Fakenham, weaver 2
3617107 1872974 1872974 defendant Jakys Thomas husbandman 589532 589532 Jakys, Thomas, of Fakenham, husbandman 2
3626336 1903095 1903095 defendant Clyfton John mercer 589532 589532 Clyfton, John, of Fakenham, mercer 0
3637850 1906653 1906653 defendant Clyfton John mercer 589532 589532 Clyfton, John, of Fakenham, mercer 0
3658542 1912925 1912925 defendant Brenetor John tailor 589532 589532 Brenetor, John, of Fakenham, tailor 0
3658543 1912925 1912925 defendant Chambleyn Robert smith 589532 589532 Chambleyn, Robert, of Fakenham, smith 1
3658544 1912925 1912925 defendant Harwyn John, junior husbandman 589532 589532 Harwyn, John, junior, of Fakenham, husbandman 2
3670328 1916672 1916672 defendant Clyfton John mercer 589532 589532 Clyfton, John, of Fakenham, mercer 0
3672748 1917483 1917483 defendant Clifton John mercer 589532 589532 Clifton, John, of Fakenham, mercer 0
3672749 1917483 1917483 defendant Broun Thomas yeoman 589532 589532 Broun, Thomas, of Fakenham, yeoman 1
3673519 1917744 1917744 defendant brevetour John tailor 589532 589532 brevetour, John, of Fakenham, tailor 0
3673521 1917745 1917745 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 0
3673527 1917747 1917747 defendant Rolf Geoffrey carpenter 589532 589532 Rolf, Geoffrey, of Fakenham, carpenter 2
3674572 1918098 1918098 plaintiff Grene Henry (legal representative) 589532 589532 Grene, Henry, of Fakenham, yeoman, executor of 0
3674574 1918098 1918098 defendant Hesylton William   589532 589532 Hesylton, William, of Fakenham, single man 0
3674653 1918123 1918123 defendant Tylney Richard merchant 589532 589532 Tylney, Richard, of Fakenham, merchant 0
3678001 1919163 1919163 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 0
3678002 1919163 1919163 defendant Harwyn John, junior yeoman 589532 589532 Harwyn, John, junior, of Fakenham, yeoman 1
3682473 1920619 1920619 defendant Feltwell Richard chaplain 589532 589532 Feltwell, Richard, of Fakenham, chaplain 0
3687734 1922332 1922332 plaintiff Colles William (legal representative) 589532 589532 Colles, William, of Fakenham, executors of 0
3687738 1922332 1922332 defendant Growte Richard draper 589532 589532 Growte, Richard, of Fakenham, draper 1
3689610 1922910 1922910 defendant Baron Robert husbandman 589532 589532 Baron, Robert, of Fakenham, husbandman 0
3689614 1922912 1922912 defendant Oxwyk John yeoman 589532 589532 Oxwyk, John, of Fakenham, yeoman 0
3694211 1924391 1924391 defendant Rolff Geoffrey carpenter 589532 589532 Rolff, Geoffrey, of Fakenham, carpenter 9
3698423 1925726 1925726 defendant Kyng John corveser 589532 589532 (Kyng, John, of Fakenham, corveser 3
3702685 1927109 1927109 defendant Moyseys John tailor 589532 589532 Moyseys, John, of Fakenham, tailor 3
3705648 1928048 1928048 defendant Clyfton John mercer 589532 589532 Clyfton, John, of Fakenham, mercer 0
3708224 1928865 1928865 defendant Rolff Geoffrey carpenter 589532 589532 Rolff, Geoffrey, of Fakenham, carpenter 4
3711107 1929786 1929786 defendant Doraunt Robert yeoman 589532 589532 Doraunt, Robert, of Fakenham, yeoman 0
3711109 1929787 1929787 defendant Oxwyke John butcher 589532 589532 Oxwyke, John, of Fakenham, butcher 0
3711619 1929946 1929946 plaintiff Tolle John (legal representative) 589532 589532 Tolle, John, of Fakenham, executor of 0
3711621 1929946 1929946 defendant Chamberleyn Robert smith 589532 589532 Chamberleyn, Robert, of Fakenham, smith 0
3711622 1929946 1929946 defendant Kente Nicholas fuller 589532 589532 Kente, Nicholas, of Fakenham, fuller 1
3717498 1931759 1931759 defendant Smyth Thomas smith 589532 589532 Smyth, Thomas, of Fakenham, smith 3
3717499 1931759 1931759 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 4
3718112 1931954 1931954 defendant Growte Richard yeoman 589532 589532 Growte, Richard, of Fakenham, yeoman 0
3723615 1933659 1933659 defendant Kent Nicholas fuller 589532 589532 Kent, Nicholas, of Fakenham, fuller 0
3730970 1935919 1935919 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 0
3730971 1935919 1935919 defendant Pecok Thomas shoemaker 589532 589532 Pecok, Thomas, of Fakenham, shoemaker 1
3732325 1936348 1936348 defendant Pecok Thomas cordwainer 589532 589532 Pecok, Thomas, of Fakenham, cordwainer 1
3732328 1936348 1936348 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 4
3733180 1936609 1936609 defendant Smyth Thomas smith 589532 589532 Smyth, Thomas, of Fakenham, smith 2
3733181 1936609 1936609 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 3
3733770 1936814 1936814 defendant Wadnew John husbandman 589532 589532 Wadnew, John, of Fakenham, husbandman 4
3741673 1939263 1939263 defendant Growte Richard draper 589532 589532 Growte, Richard, of Fakenham, draper 1
3741674 1939263 1939263 defendant Oxwyk John butcher 589532 589532 Oxwyk, John, of Fakenham, butcher 2
3741675 1939263 1939263 defendant Baron John husbandman 589532 589532 Baron, John, of Fakenham, husbandman 3
3741676 1939263 1939263 defendant Morley Robert (legal representative) 589532 589532 Morley, Robert, of Fakenham, yeoman, executor of 4
3741677 1939263 1939263 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 5
3742310 1939465 1939465 defendant Kyng John, senior shoemaker 589532 589532 Kyng, John, senior, of Fakenham, shoemaker 2
3747194 1941041 1941041 defendant Hesylton John baker 589532 589532 Hesylton, John, of Fakenham, baker 0
3748541 1941477 1941477 defendant Danham James fuller 589532 589532 Danham, James, of Fakenham, fuller 1
3748542 1941478 1941478 plaintiff Growte Richard draper 589532 589532 Growte, Richard, of Fakenham, draper 0
3748547 1941479 1941479 plaintiff Growte Richard draper 589532 589532 Growte, Richard, of Fakenham, draper 0
3748554 1941480 1941480 plaintiff Growte Richard draper 589532 589532 Growte, Richard, of Fakenham, draper 0
3754793 1943455 1943455 defendant Harwyn John husbandman 589532 589532 Harwyn, John, of Fakenham, husbandman 0
3761030 1945453 1945453 defendant Hesylton John baker 589532 589532 Hesylton, John, of Fakenham, baker 0
3761500 1945607 1945607 defendant Doraunt Robert yeoman 589532 589532 Doraunt, Robert, of Fakenham, yeoman 1
3762986 1946054 1946054 plaintiff Growt Richard draper 589532 589532 Growt, Richard, of Fakenham, draper 0
3762989 1946055 1946055 defendant Pecoke Thomas husbandman 589532 589532 Pecoke, Thomas, of Fakenham, husbandman 0
3762993 1946056 1946056 plaintiff Growte Richard draper 589532 589532 Growte, Richard, of Fakenham, draper 0
3763989 1946378 1946378 defendant Wylkynson John husbandman 589532 589532 Wylkynson, John, of Fakenham, husbandman 1
3765576 1946896 1946896 plaintiff Larwode William barker 589532 589532 Larwode, William, of Fakenham, barker 0
3767656 1947522 1947522 defendant Robyns Geoffrey carpenter 589532 589532 Robyns, Geoffrey, of Fakenham, carpenter 0
3771211 1948686 1948686 defendant Growte Richard draper 589532 589532 Growte, Richard, of Fakenham, draper 1
3771212 1948686 1948686 defendant Baron Robert husbandman 589532 589532 Baron, Robert, of Fakenham, husbandman 2
3771213 1948686 1948686 defendant Oxwyke John butcher 589532 589532 Oxwyke, John, of Fakenham, butcher 3
3771214 1948686 1948686 defendant Larwode William tanner 589532 589532 Larwode, William, of Fakenham, tanner 4
3775251 1949995 1949995 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 0
3777011 1950556 1950556 defendant Morley Robert (legal representative) 589532 589532 Morley, Robert, of Fakenham, executor of 2
3777012 1950556 1950556 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 3
3779668 1951374 1951374 defendant Harwyn John yeoman 589532 589532 Harwyn, John, of Fakenham, yeoman 0
3779763 1951404 1951404 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 0
3779764 1951404 1951404 defendant Larwode William tanner 589532 589532 Larwode, William, of Fakenham, tanner 1
3779765 1951404 1951404 defendant Smyth Thomas blacksmith 589532 589532 Smyth, Thomas, of Fakenham, blacksmith 2
3779766 1951404 1951404 defendant Dyghton Robert blacksmith 589532 589532 Dyghton, Robert, of Fakenham, blacksmith 3
3779767 1951404 1951404 defendant Benton Christopher dyer 589532 589532 Benton, Christopher, of Fakenham, dyer 4
3781822 1952060 1952060 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 0
3782440 1952250 1952250 defendant Larwode William tanner 589532 589532 Larwode, William, of Fakenham, tanner 0
3782441 1952251 1952251 plaintiff Howys Thomas (legal representative) 589532 589532 Howys, Thomas, of Fakenham, executors of 0
3782443 1952251 1952251 plaintiff Richardson Alice   589532 589532 Richardson, Alice, of Fakenham, widow of Richardson, Hugh 2
3782444 1952251 1952251 defendant Growte Richard draper 589532 589532 Growte, Richard, of Fakenham, draper 0
3785658 1953305 1953305 defendant Harwyn William husbandman 589532 589532 Harwyn, William, of Fakenham, husbandman 1
3786271 1953502 1953502 defendant Benet Robert sherman 589532 589532 Benet, Robert, of Fakenham, sherman 0
3786273 1953503 1953503 defendant Kyng John shoemaker 589532 589532 Kyng, John, of Fakenham, shoemaker 0
3788066 1954058 1954058 defendant Hesylton John husbandman 589532 589532 Hesylton, John, of Fakenham, husbandman 0
3789424 1954517 1954517 defendant Rower William plumber 589532 589532 Rower, William, of Fakenham, plumber 1
3802490 1958676 1958676 defendant Harwyn John husbandman 589532 589532 Harwyn, John, of Fakenham, husbandman 6
3802507 1958678 1958678 defendant Mabbys Geoffrey yeoman 589532 589532 Mabbys, Geoffrey, of Fakenham, yeoman 11
3808645 1960584 1960584 defendant Harlwyn John innkeeper 589532 589532 Harlwyn, John, of Fakenham, innkeeper 1
3808649 1960585 1960585 defendant Harwyn John innkeeper 589532 589532 Harwyn, John, of Fakenham, innkeeper 1
3813894 1962256 1962256 defendant Harman James glover 589532 589532 Harman, James, of Fakenham, glover 0
3813906 1962260 1962260 defendant Clyfton John mercer 589532 589532 Clyfton, John, of Fakenham, mercer 0
3815127 1962651 1962651 plaintiff Growte Richard draper 589532 589532 Growte, Richard, of Fakenham, draper 0
3815130 1962651 1962651 defendant Narburgh Thomas husbandman 589532 589532 Narburgh, Thomas, of Fakenham, husbandman 2
3815131 1962651 1962651 defendant Wheteley John tailor 589532 589532 Wheteley, John, of Fakenham, tailor 3

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