names

379 rows where place_id = 591728

✎ 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
3605364 1869345 1869345 defendant Westclyve John gent 591728 591728 Westclyve, John, of Sandwich, gent 0
3605365 1869345 1869345 defendant Broke Thomas draper 591728 591728 Broke, Thomas, of Sandwich, draper 1
3610825 1871053 1871053 defendant Drury Richard gent 591728 591728 Drury, Richard, of Sandwich, gent 0
3621933 1874403 1874403 defendant Jolyff Richard yeoman 591728 591728 Jolyff, Richard, of Sandwich, yeoman 4
3625479 1875508 1875508 defendant Burner Thomas, senior brewer 591728 591728 Burner, Thomas, senior, of Sandwich, brewer 0
3633614 1905324 1905324 plaintiff Langeley John esq 591728 591728 Langeley, John, of Sandwich, esq 0
3638152 1906750 1906750 plaintiff Sygo John merchant 591728 591728 Sygo, John, of Sandwich, merchant 0
3650429 1910502 1910502 defendant Robynson alias Tayllor William mariner 591728 591728 Robynson alias Tayllor, William, of Sandwich, mariner 0
3663055 1914356 1914356 defendant Penell Jerome merchant 591728 591728 Penell, Jerome, of Sandwich, merchant 1
3663059 1914357 1914357 defendant Penell Jerome merchant 591728 591728 Penell, Jerome, of Sandwich, merchant 2
3663984 1914679 1914679 defendant Iden Richard grocer 591728 591728 Iden, Richard, of Sandwich, grocer 0
3712596 1930255 1930255 defendant Wade William butcher 591728 591728 Wade, William, of Sandwich, butcher 0
3714920 1930962 1930962 defendant Patche Thomas yeoman 591728 591728 Patche, Thomas, of Sandwich, yeoman 2
3714921 1930962 1930962 defendant Cockys John gent 591728 591728 Cockys, John, of Sandwich, gent 3
3734230 1936947 1936947 plaintiff Frevell Joan widow 591728 591728 Frevell, Joan, of Sandwich, widow 0
3745167 1940394 1940394 defendant Patche Thomas yeoman 591728 591728 Patche, Thomas, of Sandwich, yeoman 2
3745168 1940394 1940394 defendant Cockys John gent 591728 591728 Cockys, John, of Sandwich, gent 3
3754167 1943250 1943250 defendant Engeham Vincent gent 591728 591728 Engeham, Vincent, of Sandwich, gent 0
3756187 1943894 1943894 defendant Prentys John husbandman 591728 591728 Prentys, John, of Sandwich, husbandman 1
3791345 1955128 1955128 defendant Prentys John husbandman 591728 591728 Prentys, John, of Sandwich, husbandman 0
3794819 1956250 1956250 defendant Petyman Thomas tailor 591728 591728 Petyman, Thomas, of Sandwich St Peter, tailor 3
3800796 1958163 1958163 plaintiff Manwood Roger   591728 591728 Manwood, Roger, of Sandwich 0
3800972 1958214 1958214 plaintiff Master John   591728 591728 Master, John, of Sandwich 0
3800974 1958215 1958215 plaintiff Master John   591728 591728 Master, John, of Sandwich 0
3800990 1958219 1958219 defendant Goddard Thomas yeoman 591728 591728 Goddard, Thomas, of Sandwich, yeoman 0
3815416 1962738 1962738 plaintiff Hall James yeoman 591728 591728 Hall, James, of Sandwich, yeoman 0
3837450 1969621 1969621 plaintiff Somer John (legal representative) 591728 591728 Somer, John, of Sandwich, administrator of 0
3837457 1969622 1969622 plaintiff Somer John (legal representative) 591728 591728 Somer, John, of Sandwich, administrator of 0
3837464 1969623 1969623 plaintiff Somer John (legal representative) 591728 591728 Somer, John, of Sandwich, administrator of 0
3894421 1988350 1988350 plaintiff Rolffe Thomas gent 591728 591728 Rolffe, Thomas, of Sandwich, gent 0
3898208 1989609 1989609 plaintiff Alee John yeoman 591728 591728 Alee, John, of Sandwich, yeoman 0
3898212 1989610 1989610 plaintiff Alee John yeoman 591728 591728 Alee, John, of Sandwich, yeoman 0
3934012 2001674 2001674 plaintiff Harryson Robert   591728 591728 Harryson, Robert, of Sandwich 0
3942190 2004407 2004407 defendant Awood Lawrence gunner 591728 591728 Awood, Lawrence, of Sandwich, gunner 0
3942406 2004471 2004471 defendant Bachelar Giles   591728 591728 Bachelar, Giles, of Sandwich, rope maker 3
3948744 2006628 2006628 defendant Dunffell Henry baker 591728 591728 Dunffell, Henry, of Sandwich, baker 1
3950018 2007088 2007088 defendant Harryson Robert merchant 591728 591728 Harryson, Robert, of Sandwich, merchant 0
3957048 2009531 2009531 plaintiff Patche Thomas (legal representative) 591728 591728 Patche, Thomas, of Sandwich, gent, executors of 0
3971150 2014465 2014465 plaintiff Dycker Stephen merchant 591728 591728 Dycker, Stephen, of Sandwich, merchant 0
3995638 2023184 2023184 plaintiff Crippes Thomas yeoman 591728 591728 Crippes, Thomas, of Sandwich, yeoman 0
4005079 2026603 2026603 plaintiff Kempe Christopher draper 591728 591728 Kempe, Christopher, of Sandwich, draper 0
4017293 2030891 2030891 plaintiff Tenshe Richard merchant 591728 591728 Tenshe, Richard, of Sandwich, merchant 0
4025049 2033619 2033619 defendant Boreman William grocer 591728 591728 Boreman, William, of Sandwich, grocer 1
4027374 2034439 2034439 plaintiff Chilton John   591728 591728 Chilton, John, of Sandwich 0
4042597 2039822 2039822 plaintiff Paternoster John merchant 591728 591728 Paternoster, John, of Sandwich, merchant 0
4045066 2040690 2040690 defendant Hussey Henry tailor 591728 591728 Hussey, Henry, of Sandwich, tailor 0
4046184 2041076 2041076 plaintiff Curtopp Jerome merchant 591728 591728 (Curtopp, Jerome, of Sandwich, merchant 1
4049234 2042170 2042170 plaintiff Trypp John merchant 591728 591728 Trypp, John, of Sandwich, merchant 0
4056256 2044623 2044623 plaintiff Lee John gent 591728 591728 Lee, John, of Sandwich, gent 1
4124208 2068946 2068946 defendant Aeles Giles merchant 591728 591728 Aeles, Giles, of Sandwich, merchant 2
4150156 2078190 2078190 defendant Tyssar Thomas clothier 591728 591728 Tyssar, Thomas, of Sandwich, clothier 0
4154208 2079567 2079567 defendant Wymates Augustine   591728 591728 Wymates, Augustine, of Sandwich, gent, attorney 1
4158391 2081006 2081006 defendant Fynche John (legal representative) 591728 591728 Fynche, John, of Sandwich, gent, executrix of 0
4254707 2114565 2114565 defendant Rooke Stephen, junior chapman 591728 591728 Rooke, Stephen, junior, of Sandwich, chapman 1
4267329 2118708 2118708 defendant Rooke Stephen, junior chapman 591728 591728 Rooke, Stephen, junior, of Sandwich, chapman 1
4289294 2126229 2126229 defendant Boteman John yeoman 591728 591728 Boteman, John, of Sandwich, yeoman 0
4289296 2126230 2126230 defendant Boteman John yeoman 591728 591728 Boteman, John, of Sandwich, yeoman 0
4318598 2136618 2136618 defendant Brokert Charles beer brewer 591728 591728 Brokert, Charles, of Sandwich, beer brewer 0
4319204 2136831 2136831 defendant Wilde Thomas merchant 591728 591728 Wilde, Thomas, of Sandwich, merchant 0
4325617 2138943 2138943 defendant Wylde Thomas grocer 591728 591728 Wylde, Thomas, of Sandwich, grocer 2
4328184 2139742 2139742 defendant Colbrand Nicholas merchant 591728 591728 Colbrand, Nicholas, of Sandwich, merchant 0
4332865 2141274 2141274 defendant Colbrand Nicholas merchant 591728 591728 Colbrand, Nicholas, of Sandwich, merchant 1
4370894 2154647 2154647 defendant Maye Richard yeoman 591728 591728 Maye, Richard, of Sandwich, yeoman 0
4393039 2162283 2162283 defendant Rogers John mariner 591728 591728 Rogers, John, of Sandwich, mariner 2
4402501 2165421 2165421 defendant Waferer Thomas yeoman 591728 591728 Waferer, Thomas, of Sandwich, yeoman 1
4402502 2165421 2165421 defendant Nowell Thomas merchant 591728 591728 Nowell, Thomas, of Sandwich, merchant 2
4415988 2169887 2169887 defendant Gylot Thomas   591728 591728 Gylot, Thomas, of Sandwich 0
4443056 2182790 2182790 defendant Frese John   591728 591728 Frese, John, of Sandwich 0
4443060 2182790 2182790 defendant Seman John   591728 591728 Seman, John, of Sandwich 4
4447554 2184150 2184150 plaintiff Elys Thomas   591728 591728 Elys, Thomas, of Sandwich 0
4456645 2187104 2187104 plaintiff Olyver William   591728 591728 Olyver, William, of Sandwich 0
4475103 2192884 2192884 plaintiff Elys Thomas (legal representative) 591728 591728 Elys, Thomas, of Sandwich, executors of 0
4475252 2192940 2192940 defendant Piryton John   591728 591728 Piryton, John, of Sandwich 0
4483847 2195646 2195646 defendant Botry Thomas   591728 591728 Botry, Thomas, of Sandwich 1
4484046 2195702 2195702 defendant Delyt Robert   591728 591728 Delyt, Robert, of Sandwich 0
4492656 2198404 2198404 defendant atte Pette Philip   591728 591728 (atte Pette, Philip, of Sandwich 1
4496724 2199644 2199644 plaintiff Cundy Peter (legal representative) 591728 591728 Cundy, Peter, of Sandwich, executors of 0
4496728 2199644 2199644 defendant Fowe John   591728 591728 Fowe, John, of Sandwich 1
4500498 2200777 2200777 plaintiff Ive Richard   591728 591728 Ive, Richard, of Sandwich 0
4503841 2201763 2201763 defendant Godard John   591728 591728 Godard, John, of Sandwich 0
4505938 2202368 2202368 plaintiff Styll John   591728 591728 Styll, John, of Sandwich 0
4528478 2209188 2209188 plaintiff Martham John (legal representative) 591728 591728 Martham, John, of Sandwich, executors of 0
4536723 2211762 2211762 plaintiff Stille John   591728 591728 Stille, John, of Sandwich 0
4542659 2213592 2213592 defendant B_rd_ John   591728 591728 B_rd_, John, of Sandwich 0
4546666 2214882 2214882 defendant Salesbery Robert   591728 591728 Salesbery, Robert, of Sandwich 0
4550758 2216177 2216177 defendant Godard John   591728 591728 Godard, John, of Sandwich 2
4552282 2216668 2216668 plaintiff Faversham John   591728 591728 Faversham, John, of Sandwich 0
4555267 2217582 2217582 plaintiff Hedon Robert   591728 591728 Hedon, Robert, of Sandwich 0
4559123 2218808 2218808 plaintiff Martham John (legal representative) 591728 591728 Martham, John, of Sandwich, executors of 0
4559128 2218808 2218808 defendant Couper Richard   591728 591728 Couper, Richard, of Sandwich 0
4559129 2218809 2218809 plaintiff Martham John (legal representative) 591728 591728 Martham, John, of Sandwich, executors of 0
4559135 2218810 2218810 plaintiff Martham John (legal representative) 591728 591728 Martham, John, of Sandwich, executors of 0
4559140 2218810 2218810 defendant Couper Richard   591728 591728 Couper, Richard, of Sandwich 0
4563418 2220130 2220130 plaintiff Trycche John   591728 591728 Trycche, John, of Sandwich 1
4563421 2220131 2220131 plaintiff Trycche John   591728 591728 Trycche, John, of Sandwich 1
4577279 2224413 2224413 defendant Pawsherst John   591728 591728 Pawsherst, John, of Sandwich 0
4578886 2224877 2224877 defendant Pecke Robert   591728 591728 Pecke, Robert, of Sandwich 3
4578892 2224878 2224878 defendant Peeke Robert   591728 591728 Peeke, Robert, of Sandwich 3
4590641 2228434 2228434 plaintiff Martham John (legal representative) 591728 591728 Martham, John, of Sandwich, executors of 0
4590647 2228435 2228435 plaintiff Martham John (legal representative) 591728 591728 Martham, John, of Sandwich, executors of 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);