names

557 rows where place_id = 586361

✎ 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
3588524 1864055 1864055 defendant Ormesby Richard smith 586361 586361 Ormesby, Richard, of Harleston, smith 0
3588973 1864201 1864201 defendant Bonnyng Thomas smith 586361 586361 Bonnyng, Thomas, of Harleston, smith 0
3588981 1864204 1864204 defendant Wryght Richard, senior (legal representative) 586361 586361 Wryght, Richard, senior, of Harleston, yeoman, executors of 0
3588982 1864204 1864204 defendant Bacon John draper 586361 586361 (Bacon, John, of Harleston, draper 1
3588983 1864204 1864204 defendant Govet or Gobet John sherman 586361 586361 Govet or Gobet, John, of Harleston, sherman 2
3592339 1865220 1865220 plaintiff Gande or Gaude John   586361 586361 Gande or Gaude, John, of Harleston 0
3594146 1865811 1865811 defendant Skutte Robert husbandman 586361 586361 Skutte, Robert, of Harleston, husbandman 2
3598621 1867194 1867194 defendant Wryght Richard (legal representative) 586361 586361 Wryght, Richard, of Harleston, yeoman, executors of 0
3598622 1867194 1867194 defendant Bakon John draper 586361 586361 (Bakon, John, of Harleston, draper 1
3598623 1867194 1867194 defendant Govet or Gobet alias Wryght John yeoman 586361 586361 Govet or Gobet alias Wryght, John, of Harleston, yeoman 2
3598626 1867195 1867195 defendant Wryght Richard (legal representative) 586361 586361 Wryght, Richard, of Harleston, yeoman, executors of 0
3598628 1867195 1867195 defendant Gobet alias Wryght John yeoman 586361 586361 Gobet alias Wryght, John, of Harleston, yeoman 2
3598629 1867195 1867195 defendant Beer Richard baker 586361 586361 Beer, Richard, of Harleston, baker 3
3601417 1868102 1868102 defendant Wage John husbandman 586361 586361 Wage, John, of Harleston, husbandman 4
3602699 1868507 1868507 defendant Agas Robert husbandman 586361 586361 Agas, Robert, of Harleston, husbandman 3
3622684 1874625 1874625 defendant Godfrey William shipman 586361 586361 Godfrey, William, of Harleston, shipman 0
3629056 1903966 1903966 plaintiff Cook Geoffrey   586361 586361 Cook, Geoffrey, of Harleston 0
3629406 1904053 1904053 defendant Knyght John husbandman 586361 586361 Knyght, John, of Harleston, husbandman 0
3631164 1904570 1904570 plaintiff Gandy or Gaudy John (legal representative) 586361 586361 Gandy or Gaudy, John, of Harleston, yeoman, executor of 0
3631165 1904570 1904570 plaintiff Gandy or Gaudy Thomas, junior   586361 586361 Gandy or Gaudy, Thomas, junior, of Harleston, bailiff 1
3631168 1904571 1904571 defendant Warde Thomas, junior husbandman 586361 586361 Warde, Thomas, junior, of Harleston, husbandman 0
3632859 1905093 1905093 defendant Godfrey Edmund, junior husbandman 586361 586361 Godfrey, Edmund, junior, of Harleston, husbandman 0
3635166 1905796 1905796 defendant Girling Thomas yeoman 586361 586361 Girling, Thomas, of Harleston, yeoman 0
3635170 1905797 1905797 defendant Gyrlyng Thomas yeoman 586361 586361 Gyrlyng, Thomas, of Harleston, yeoman 1
3636400 1906173 1906173 defendant Godfrey Edmund merchant 586361 586361 Godfrey, Edmund, of Harleston, merchant 1
3641118 1907668 1907668 defendant Leman Thomas tanner 586361 586361 Leman, Thomas, of Harleston, tanner 0
3641691 1907858 1907858 defendant Fuller alias Taylour Richard husbandman 586361 586361 Fuller alias Taylour, Richard, of Harleston, husbandman 0
3642744 1908178 1908178 defendant Lambe Thomas yeoman 586361 586361 Lambe, Thomas, of Harleston, yeoman 0
3643281 1908323 1908323 defendant Gandy Thomas yeoman 586361 586361 Gandy, Thomas, of Harleston, yeoman 0
3644858 1908801 1908801 defendant Cooke Geoffrey yeoman 586361 586361 Cooke, Geoffrey, of Harleston, yeoman 0
3646581 1909334 1909334 plaintiff Hynde John   586361 586361 Hynde, John, of Harleston 0
3646582 1909334 1909334 defendant Cook Geoffrey yeoman 586361 586361 Cook, Geoffrey, of Harleston, yeoman 0
3650422 1910501 1910501 defendant Penne John yeoman 586361 586361 Penne, John, of Harleston, yeoman 0
3657013 1912454 1912454 defendant Bakon Richard yeoman 586361 586361 Bakon, Richard, of Harleston, yeoman 0
3659071 1913101 1913101 plaintiff Gandy Thomas   586361 586361 Gandy, Thomas, of Harleston, bailiff 0
3659072 1913101 1913101 defendant Alger Thomas   586361 586361 Alger, Thomas, of Harleston, wheel wright 0
3674095 1917938 1917938 defendant Kempe William cooper 586361 586361 Kempe, William, of Harleston, cooper 0
3674699 1918134 1918134 defendant Wylkynson Richard merchant 586361 586361 Wylkynson, Richard, of Harleston, merchant 0
3677282 1918946 1918946 plaintiff Leman Thomas (legal representative) 586361 586361 Leman, Thomas, of Harleston, tanner, executors of 0
3677285 1918946 1918946 defendant Harman John cordwainer 586361 586361 Harman, John, of Harleston, cordwainer 0
3683935 1921109 1921109 defendant Colyns Hugh husbandman 586361 586361 Colyns, Hugh, of Harleston, husbandman 0
3692184 1923723 1923723 defendant Holond John yeoman 586361 586361 Holond, John, of Harleston, yeoman 0
3702498 1927047 1927047 defendant Coke William yeoman 586361 586361 Coke, William, of Harleston, yeoman 1
3702499 1927047 1927047 defendant Hyndys John butcher 586361 586361 Hyndys, John, of Harleston, butcher 2
3702680 1927108 1927108 defendant Collyns Edward husbandman 586361 586361 Collyns, Edward, of Harleston, husbandman 0
3704847 1927809 1927809 defendant Gaudy Thomas, junior gent 586361 586361 Gaudy, Thomas, junior, of Harleston, gent 0
3704849 1927810 1927810 defendant Gaudy Thomas, junior gent 586361 586361 Gaudy, Thomas, junior, of Harleston, gent 0
3706111 1928204 1928204 defendant Meane Thomas yeoman 586361 586361 Meane, Thomas, of Harleston, yeoman 3
3706227 1928235 1928235 defendant Hyndes Robert husbandman 586361 586361 Hyndes, Robert, of Harleston, husbandman 0
3711421 1929877 1929877 defendant Collyns Edward husbandman 586361 586361 Collyns, Edward, of Harleston, husbandman 0
3724723 1934018 1934018 defendant Buttler John smith 586361 586361 Buttler, John, of Harleston, smith 1
3726367 1934516 1934516 defendant Mene John, junior husbandman 586361 586361 Mene, John, junior, of Harleston, husbandman 0
3730134 1935647 1935647 defendant Bacon Richard yeoman 586361 586361 Bacon, Richard, of Harleston, yeoman 0
3731194 1935980 1935980 defendant Shyngylwoode Richard yeoman 586361 586361 Shyngylwoode, Richard, of Harleston, yeoman 0
3736780 1937754 1937754 defendant Gawdy Thomas, junior gent 586361 586361 Gawdy, Thomas, junior, of Harleston, gent 0
3738921 1938378 1938378 defendant Dyx Alan butcher 586361 586361 Dyx, Alan, of Harleston, butcher 0
3740174 1938786 1938786 defendant Godfrey Robert mercer 586361 586361 Godfrey, Robert, of Harleston, mercer 0
3740357 1938847 1938847 defendant Goodman William (legal representative) 586361 586361 Goodman, William, of Harleston, tailor, executors of 0
3744528 1940190 1940190 defendant Gandy Thomas gent 586361 586361 Gandy, Thomas, of Harleston, gent 0
3744530 1940191 1940191 defendant Gandy Thomas gent 586361 586361 Gandy, Thomas, of Harleston, gent 0
3744950 1940325 1940325 defendant Bacon Richard yeoman 586361 586361 Bacon, Richard, of Harleston, yeoman 0
3747987 1941289 1941289 defendant Lambe Matilda (legal representative) 586361 586361 Lambe, Matilda, of Harleston, widow, administrator of 0
3748130 1941341 1941341 defendant Barkar Thomas (legal representative) 586361 586361 Barkar, Thomas, of Harleston, administrator of 1
3748131 1941341 1941341 defendant Barkar Richard butcher 586361 586361 Barkar, Richard, of Harleston, butcher 2
3752588 1942738 1942738 defendant Hylwysshe William mercer 586361 586361 Hylwysshe, William, of Harleston, mercer 0
3757543 1944336 1944336 defendant Bacon Richard yeoman 586361 586361 Bacon, Richard, of Harleston, yeoman 0
3760134 1945165 1945165 defendant Gandy Thomas, junior yeoman 586361 586361 Gandy, Thomas, junior, of Harleston, yeoman 0
3760137 1945166 1945166 defendant Gandy Thomas, junior yeoman 586361 586361 Gandy, Thomas, junior, of Harleston, yeoman 0
3766752 1947262 1947262 defendant Dixe Alan butcher 586361 586361 Dixe, Alan, of Harleston, butcher 0
3767386 1947444 1947444 defendant Bannok John cooper 586361 586361 Bannok, John, of Harleston, cooper 0
3771614 1948821 1948821 defendant Goldsmyth William husbandman 586361 586361 Goldsmyth, William, of Harleston, husbandman 0
3775505 1950080 1950080 defendant Bacon Richard gent 586361 586361 Bacon, Richard, of Harleston, gent 0
3775507 1950081 1950081 defendant Bacon Richard gent 586361 586361 Bacon, Richard, of Harleston, gent 0
3776372 1950362 1950362 defendant Goldsmyth John husbandman 586361 586361 Goldsmyth, John, of Harleston, husbandman 0
3776851 1950499 1950499 defendant Gandy Thomas gent 586361 586361 Gandy, Thomas, of Harleston, gent 0
3776852 1950499 1950499 defendant Mene Thomas husbandman 586361 586361 Mene, Thomas, of Harleston, husbandman 1
3776853 1950499 1950499 defendant Wright Robert laborer 586361 586361 Wright, Robert, of Harleston, laborer 2
3777325 1950651 1950651 defendant Goldsmyth William husbandman 586361 586361 Goldsmyth, William, of Harleston, husbandman 0
3778165 1950877 1950877 defendant Gandy Thomas, junior yeoman 586361 586361 Gandy, Thomas, junior, of Harleston, yeoman 0
3778168 1950878 1950878 defendant Gandy Thomas, junior yeoman 586361 586361 Gandy, Thomas, junior, of Harleston, yeoman 0
3780666 1951681 1951681 defendant Bacon Richard gent 586361 586361 Bacon, Richard, of Harleston, gent 0
3783153 1952489 1952489 defendant Gandy Thomas gent 586361 586361 Gandy,Thomas, of Harleston, gent 0
3783290 1952526 1952526 defendant Goldsmyth William husbandman 586361 586361 Goldsmyth, William, of Harleston, husbandman 0
3783908 1952742 1952742 plaintiff Mannok alias Barbour Robert   586361 586361 (Mannok alias Barbour, Robert, of Harleston 1
3783912 1952742 1952742 defendant Fuller William yeoman 586361 586361 Fuller, William, of Harleston, yeoman 2
3789308 1954475 1954475 defendant Goldsmyth William husbandman 586361 586361 Goldsmyth, William, of Harleston, husbandman 0
3793064 1955690 1955690 defendant Dyx Alan butcher 586361 586361 Dyx, Alan, of Harleston, butcher 0
3793921 1955967 1955967 defendant Storke John dyer 586361 586361 Storke, John, of Harleston, dyer 0
3794176 1956049 1956049 defendant Bettys William yeoman 586361 586361 Bettys, William, of Harleston, yeoman 0
3797321 1957051 1957051 defendant Goldsmyth William husbandman 586361 586361 Goldsmyth, William, of Harleston, husbandman 0
3797778 1957203 1957203 defendant Shyngylwod Richard yeoman 586361 586361 Shyngylwod, Richard, of Harleston, yeoman 0
3798405 1957400 1957400 defendant Dyx Alan butcher 586361 586361 Dyx, Alan, of Harleston, butcher 0
3814977 1962605 1962605 defendant Payn John mercer 586361 586361 Payn, John, of Harleston, mercer 0
3818643 1963734 1963734 defendant Aleyn John butcher 586361 586361 Aleyn, John, of Harleston, butcher 1
3825044 1965707 1965707 defendant Dogkette Robert yeoman 586361 586361 Dogkette, Robert, of Harleston, yeoman 0
3830810 1967519 1967519 plaintiff Gandy Thomas, senior   586361 586361 Gandy, Thomas, senior, of Harleston 0
3830811 1967519 1967519 defendant Barne Thomas mercer 586361 586361 Barne, Thomas, of Harleston, mercer 0
3833565 1968431 1968431 defendant Dyx John   586361 586361 Dyx, John, of Harleston, butcher, alias Aleyn, John, of Leystoft 0
3836969 1969470 1969470 plaintiff Saye John tanner 586361 586361 Saye, John, of Harleston, tanner 0
3840114 1970480 1970480 defendant Mynnys Richard husbandman 586361 586361 Mynnys, Richard, of Harleston, husbandman 0

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