names

764 rows where place_id = 587882

✎ 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
3592726 1865339 1865339 defendant Broun John husbandman 587882 587882 Broun, John, of Lavenham, husbandman 0
3598318 1867102 1867102 defendant Cane or Cave Robert   587882 587882 Cane or Cave, Robert, of Lavenham, plain weaver 1
3598450 1867145 1867145 plaintiff Spryng Thomas   587882 587882 Spryng, Thomas, of Lavenham 0
3598452 1867146 1867146 plaintiff Spryng Thomas (legal representative) 587882 587882 Spryng, Thomas, of Lavenham, executors of 0
3599866 1867609 1867609 defendant Broun John husbandman 587882 587882 Broun, John, of Lavenham, husbandman 0
3605371 1869347 1869347 defendant Aleyn William sherman 587882 587882 Aleyn, William, of Lavenham, sherman 2
3605372 1869347 1869347 defendant Clogge Thomas fuller 587882 587882 Clogge, Thomas, of Lavenham, fuller 3
3605373 1869348 1869348 plaintiff Jacob William   587882 587882 Jacob, William, of Lavenham 0
3605376 1869349 1869349 plaintiff Jacob William merchant 587882 587882 Jacob, William, of Lavenham, merchant 0
3605379 1869350 1869350 plaintiff Jacon William   587882 587882 Jacon, William, of Lavenham 0
3606734 1869782 1869782 defendant Longe William husbandman 587882 587882 Longe, William, of Lavenham, husbandman 3
3607799 1870091 1870091 plaintiff Barbour Simon   587882 587882 Barbour, Simon, of Lavenham 1
3620025 1873836 1873836 plaintiff Knevet William gent 587882 587882 Knevet, William, of Lavenham, gent 0
3622229 1874487 1874487 defendant Jacob William clothmaker 587882 587882 Jacob, William, of Lavenham, clothmaker 0
3623084 1874743 1874743 defendant Dyester John clothmaker 587882 587882 Dyester, John, of Lavenham, clothmaker 0
3625673 1875565 1875565 defendant Wysse William   587882 587882 Wysse, William, of Lavenham, tile maker 3
3627665 1903514 1903514 plaintiff Breton John   587882 587882 Breton, John, of Lavenham 0
3627668 1903514 1903514 defendant Wright Simon sherman 587882 587882 Wright, Simon, of Lavenham, sherman 2
3629322 1904029 1904029 defendant Godard Augustine smith 587882 587882 Godard, Augustine, of Lavenham, smith 1
3629325 1904030 1904030 defendant Godderd Augustine smith 587882 587882 Godderd, Augustine, of Lavenham, smith 1
3633500 1905292 1905292 defendant Reyner Thomas laborer 587882 587882 Reyner, Thomas, of Lavenham, laborer 0
3633501 1905292 1905292 defendant Swanton Robert weaver 587882 587882 Swanton, Robert, of Lavenham, weaver 1
3635504 1905901 1905901 defendant Sporne Thomas yeoman 587882 587882 Sporne, Thomas, of Lavenham, yeoman 0
3635507 1905902 1905902 defendant Sporn Thomas yeoman 587882 587882 Sporn, Thomas, of Lavenham, yeoman 0
3637447 1906519 1906519 defendant Clogge Thomas fuller 587882 587882 Clogge, Thomas, of Lavenham, fuller 1
3637751 1906623 1906623 plaintiff Spryng Thomas clothmaker 587882 587882 Spryng, Thomas, of Lavenham, clothmaker 0
3637753 1906624 1906624 plaintiff Spryng Thomas clothmaker 587882 587882 Spryng, Thomas, of Lavenham, clothmaker 0
3638270 1906789 1906789 defendant Newman John tailor 587882 587882 Newman, John, of Lavenham, tailor 1
3641288 1907727 1907727 defendant Barker Robert butcher 587882 587882 Barker, Robert, of Lavenham, butcher 1
3643374 1908354 1908354 defendant Wyllymott John clothmaker 587882 587882 Wyllymott, John, of Lavenham, clothmaker 2
3643378 1908355 1908355 defendant Willymott John clothmaker 587882 587882 Willymott, John, of Lavenham, clothmaker 0
3645377 1908962 1908962 defendant Pepyr William husbandman 587882 587882 Pepyr, William, of Lavenham, husbandman 5
3645495 1908993 1908993 plaintiff Grome Robert   587882 587882 Grome, Robert, of Lavenham 0
3645499 1908994 1908994 plaintiff Grome Robert   587882 587882 Grome, Robert, of Lavenham, single man 0
3647748 1909687 1909687 defendant Joly William butcher 587882 587882 Joly, William, of Lavenham, butcher 0
3650206 1910434 1910434 defendant Robson Geoffrey sherman 587882 587882 Robson, Geoffrey, of Lavenham, sherman 4
3651086 1910707 1910707 plaintiff Spryng Thomas clothmaker 587882 587882 Spryng, Thomas, of Lavenham, clothmaker 0
3659430 1913210 1913210 defendant Willyma John   587882 587882 Willyma, John, of Lavenham, cloth maker 1
3665346 1915115 1915115 plaintiff Sperne Thomas   587882 587882 Sperne, Thomas, of Lavenham 0
3665348 1915115 1915115 defendant Rede Robert clerk 587882 587882 Rede, Robert, of Lavenham, clerk 1
3665354 1915117 1915117 plaintiff Spryng Thomas   587882 587882 Spryng, Thomas, of Lavenham 0
3665358 1915118 1915118 plaintiff Spryng Thomas   587882 587882 Spryng, Thomas, of Lavenham, cloth maker 0
3665361 1915119 1915119 plaintiff Spryng Thomas   587882 587882 Spryng, Thomas, of Lavenham, cloth maker 0
3665363 1915120 1915120 plaintiff Spryng Thomas   587882 587882 Spryng, Thomas, of Lavenham, cloth maker 0
3665368 1915122 1915122 plaintiff Spryngge Thomas   587882 587882 Spryngge, Thomas, of Lavenham, cloth maker 0
3666633 1915509 1915509 plaintiff Vyrdon John clothier 587882 587882 Vyrdon, John, of Lavenham, clothier 0
3668955 1916223 1916223 defendant Symund John, senior butcher 587882 587882 Symund, John, senior, of Lavenham, butcher 0
3668956 1916223 1916223 defendant Avery Robert fuller 587882 587882 Avery, Robert, of Lavenham, fuller 1
3668957 1916223 1916223 defendant Cowke Walter fuller 587882 587882 Cowke, Walter, of Lavenham, fuller 2
3668958 1916223 1916223 defendant Chapman Thomas tailor 587882 587882 Chapman, Thomas, of Lavenham, tailor 3
3668959 1916223 1916223 defendant Symund Simon barker 587882 587882 Symund, Simon, of Lavenham, barker 4
3674739 1918143 1918143 defendant Appylton alias Conyman John carrier 587882 587882 Appylton alias Conyman, John, of Lavenham, carrier 0
3676165 1918588 1918588 plaintiff Hunte John clothmaker 587882 587882 Hunte, John, of Lavenham, clothmaker 0
3677847 1919124 1919124 defendant Breton John carrier 587882 587882 Breton, John, of Lavenham, carrier 2
3680417 1919957 1919957 defendant Payne Robert sherman 587882 587882 Payne, Robert, of Lavenham, sherman 1
3681618 1920344 1920344 defendant Cawston William clothmaker 587882 587882 Cawston, William, of Lavenham, clothmaker 2
3681831 1920421 1920421 plaintiff Spryng Thomas   587882 587882 Spryng, Thomas, of Lavenham 0
3681834 1920422 1920422 plaintiff Spryng Thomas clothmaker 587882 587882 Spryng, Thomas, of Lavenham, clothmaker 0
3681836 1920423 1920423 plaintiff Spryng Thomas clothmaker 587882 587882 Spryng, Thomas, of Lavenham, clothmaker 0
3681838 1920424 1920424 plaintiff Spryng Thomas clothmaker 587882 587882 Spryng, Thomas, of Lavenham, clothmaker 0
3681840 1920425 1920425 plaintiff Spryng Thomas clothmaker 587882 587882 Spryng, Thomas, of Lavenham, clothmaker 0
3681842 1920426 1920426 plaintiff Spryng Thomas gent 587882 587882 Spryng, Thomas, of Lavenham, gent 0
3682346 1920580 1920580 defendant Mannok Robert husbandman 587882 587882 Mannok, Robert, of Lavenham, husbandman 0
3682347 1920580 1920580 defendant Malbond John husbandman 587882 587882 Malbond, John, of Lavenham, husbandman 1
3682361 1920585 1920585 defendant Symond Thomas carrier 587882 587882 Symond, Thomas, of Lavenham, carrier 0
3682362 1920585 1920585 defendant Chenery William husbandman 587882 587882 Chenery, William, of Lavenham, husbandman 1
3685451 1921600 1921600 defendant Waren Robert smith 587882 587882 Waren, Robert, of Lavenham, smith 0
3687723 1922328 1922328 defendant Broune Richard   587882 587882 Broune, Richard, of Lavenham, "taryer" 1
3690769 1923279 1923279 plaintiff Grome Robert   587882 587882 Grome, Robert, of Lavenham 0
3692025 1923673 1923673 defendant Sporne Thomas gent 587882 587882 Sporne, Thomas, of Lavenham, gent 0
3702707 1927118 1927118 defendant Brome Richard yeoman 587882 587882 Brome, Richard, of Lavenham, yeoman 2
3704714 1927762 1927762 plaintiff Gawge John   587882 587882 Gawge, John, of Lavenham 0
3706559 1928335 1928335 defendant Menyng John   587882 587882 Menyng, John, of Lavenham, wood setter 0
3707069 1928499 1928499 defendant Barker Anne widow 587882 587882 Barker, Anne, of Lavenham, widow 1
3707070 1928499 1928499 defendant Elyott William weaver 587882 587882 Elyott, William, of Lavenham, weaver 2
3710328 1929547 1929547 plaintiff Sexten Thomas clothmaker 587882 587882 Sexten, Thomas, of Lavenham, clothmaker 0
3717033 1931613 1931613 plaintiff Crytoft Robert, senior clothmaker 587882 587882 Crytoft, Robert, senior, of Lavenham, clothmaker 0
3717034 1931613 1931613 defendant Warde John beer brewer 587882 587882 Warde, John, of Lavenham, beer brewer 0
3720488 1932691 1932691 defendant Sharman Robert butcher 587882 587882 Sharman, Robert, of Lavenham, butcher 2
3720489 1932691 1932691 defendant Legge Henry weaver 587882 587882 Legge, Henry, of Lavenham, weaver 3
3724619 1933982 1933982 defendant Simond Robert butcher 587882 587882 Simond, Robert, of Lavenham, butcher 2
3724872 1934066 1934066 defendant Hardegrey John   587882 587882 Hardegrey, John, of Lavenham, wood setter 0
3724899 1934074 1934074 defendant Warde John beer brewer 587882 587882 Warde, John, of Lavenham, beer brewer 0
3724900 1934074 1934074 defendant Robson Geoffrey sherman 587882 587882 Robson, Geoffrey, of Lavenham, sherman 1
3724901 1934075 1934075 plaintiff Sexten Thomas clothmaker 587882 587882 Sexten, Thomas, of Lavenham, clothmaker 0
3725287 1934201 1934201 defendant Cawston William clothmaker 587882 587882 Cawston, William, of Lavenham, clothmaker 0
3725498 1934263 1934263 plaintiff Spryng Thomas (legal representative) 587882 587882 Spryng, Thomas, of Lavenham, gent, executors of 0
3732734 1936468 1936468 defendant Ward John beer brewer 587882 587882 Ward, John, of Lavenham, beer brewer 2
3733266 1936639 1936639 defendant Page William clothmaker 587882 587882 Page, William, of Lavenham, clothmaker 0
3739070 1938429 1938429 plaintiff Page William yeoman 587882 587882 Page, William, of Lavenham, yeoman 0
3739072 1938430 1938430 plaintiff Page William yeoman 587882 587882 Page, William, of Lavenham, yeoman 0
3740172 1938785 1938785 defendant Cawston William clothmaker 587882 587882 Cawston, William, of Lavenham, clothmaker 0
3740814 1938984 1938984 defendant Haldegrey John   587882 587882 Haldegrey, John, of Lavenham, wood setter 0
3749544 1941771 1941771 defendant Cutte William butcher 587882 587882 Cutte, William, of Lavenham, butcher 0
3750731 1942151 1942151 defendant Robson Geoffrey yeoman 587882 587882 Robson, Geoffrey, of Lavenham, yeoman 3
3750732 1942151 1942151 defendant Barker William weaver 587882 587882 Barker, William, of Lavenham, weaver 4
3752724 1942780 1942780 plaintiff Robson William (legal representative) 587882 587882 Robson, William, of Lavenham, clothmaker, executors of 0
3752727 1942781 1942781 plaintiff Robson William (legal representative) 587882 587882 Robson, William, of Lavenham, clothmaker, executors of 0
3753156 1942926 1942926 defendant Wyllymott John clothmaker 587882 587882 Wyllymott, John, of Lavenham, clothmaker 0
3754952 1943498 1943498 defendant Punder John weaver 587882 587882 Punder, John, of Lavenham, weaver 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);