names

198 rows where place_id = 591562

✎ 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
3604185 1868974 1868974 defendant Falk Joan   591562 591562 Falk, Joan, of Lewes, Sussex, widow, formerly Arnoldson, Joan 1
3604832 1869178 1869178 defendant Pulpute John chapman 591562 591562 Pulpute, John, of Lewes, Sussex, chapman 1
3604856 1869185 1869185 defendant Pulpytte John chapman 591562 591562 Pulpytte, John, of Lewes, Sussex, chapman 0
3607718 1870067 1870067 defendant Best Thomas (legal representative) 591562 591562 Best, Thomas, of Lewes, Sussex, gent, executor of 1
3654325 1911613 1911613 plaintiff (not given) John prior of Ashdowne or Asthdon 591562 591562 Ashdowne or Asthdon, John, of Lewes, Sussex, prior of the Monastery of St Pancras 0
3654329 1911614 1911614 plaintiff (not given) John prior of Ashdowne or Asthdon 591562 591562 Ashdowne or Asthdon, John, of Lewes, Sussex, prior of the Monastery of St Pancras 0
3675119 1918247 1918247 defendant Tykeragge Richard   591562 591562 Tykeragge, Richard, of Lewes, Sussex, "rypyer" 2
3680938 1920119 1920119 defendant at Wode William chaundler 591562 591562 at Wode, William, of Lewes, Sussex, chaundler 0
3680941 1920120 1920120 defendant Awdeley John chandler 591562 591562 Awdeley, John, of Lewes, Sussex, chandler 0
3681015 1920139 1920139 defendant Cheverton John yeoman of the crown 591562 591562 Cheverton, John, of Lewes, Sussex, yeoman of the crown 0
3692309 1923764 1923764 defendant Chaldwykk Peter yeoman 591562 591562 Chaldwykk, Peter, of Lewes, Sussex, yeoman 3
3723926 1933763 1933763 defendant Ive John draper 591562 591562 Ive, John, of Lewes, Sussex, draper 0
3741592 1939240 1939240 defendant Pers Agnes   591562 591562 Pers, Agnes, of Lewes, Sussex, widow of Pers, Richard, of Lewes 0
3749038 1941629 1941629 defendant Savell Leonard clerk 591562 591562 Savell, Leonard, of Lewes, Sussex, clerk 0
3752714 1942776 1942776 defendant Walsted alias Fleccher John yeoman 591562 591562 Walsted alias Fleccher, John, of Lewes, Sussex, yeoman 0
3784137 1952822 1952822 defendant Slotter Thomas innholder 591562 591562 Slotter, Thomas, of Lewes, Sussex, innholder 2
3790418 1954823 1954823 defendant Pruly John merchant 591562 591562 Pruly, John, of Lewes, Sussex, merchant 1
3797517 1957116 1957116 defendant Priour John tailor 591562 591562 Priour, John, of Lewes, Sussex, tailor 0
3797521 1957117 1957117 defendant Pryour John tailor 591562 591562 Pryour, John, of Lewes, Sussex, tailor 0
3805720 1959734 1959734 defendant Frankewell Alice widow 591562 591562 Frankewell, Alice, of Lewes, Sussex, widow 0
3815590 1962792 1962792 defendant Bust John butcher 591562 591562 Bust, John, of Lewes, Sussex, butcher 3
3815866 1962865 1962865 defendant Hall John gent 591562 591562 Hall, John, of Lewes, Sussex, gent 2
3819051 1963850 1963850 plaintiff Morley Robert gent 591562 591562 Morley, Robert, of Lewes, Sussex, gent 0
3821496 1964618 1964618 defendant Tyceherst John fletcher 591562 591562 Tyceherst, John, of Lewes, Sussex, fletcher 1
3828167 1966677 1966677 defendant Frankewell Richard yeoman 591562 591562 Frankewell, Richard, of Lewes, Sussex, yeoman 0
3829142 1966996 1966996 defendant Walkestede John beer brewer 591562 591562 Walkestede, John, of Lewes, Sussex, beer brewer 1
3831954 1967891 1967891 defendant Thursbe James husbandman 591562 591562 Thursbe, James, of Lewes, Sussex, husbandman 1
3835302 1968981 1968981 defendant Pryour John chapman 591562 591562 Pryour, John, of Lewes, Sussex, chapman 0
3835595 1969069 1969069 defendant Colbrand Thoms esq 591562 591562 Colbrand, Thoms, of Lewes, Sussex, esq 0
3837716 1969709 1969709 defendant Baker John clerk 591562 591562 Baker, John, of Lewes, Sussex, clerk 0
3843933 1971642 1971642 defendant Hollstocke Thomas tailor 591562 591562 Hollstocke, Thomas, of Lewes, Sussex, tailor 1
3854405 1975015 1975015 defendant Flussher John chapman 591562 591562 Flussher, John, of Lewes, Sussex, chapman 0
3856603 1975690 1975690 defendant Oteley Richard yeoman 591562 591562 Oteley, Richard, of Lewes, Sussex, yeoman 1
3858408 1976290 1976290 defendant Wylkyns Jown yeoman 591562 591562 Wylkyns, Jown, of Lewes, Sussex, yeoman 2
3859980 1976839 1976839 defendant Hollstocke Thomas tailor 591562 591562 Hollstocke, Thomas, of Lewes, Sussex, tailor 1
3880283 1983659 1983659 defendant Flussher John chapman 591562 591562 Flussher, John, of Lewes, Sussex, chapman 1
3930938 2000687 2000687 plaintiff Datnor John mercer 591562 591562 Datnor, John, of Lewes, Sussex, mercer 0
3937078 2002733 2002733 defendant Sinderforthe Richard tailor 591562 591562 Sinderforthe, Richard, of Lewes, Sussex, tailor 0
3942317 2004442 2004442 defendant Sherman John yeoman 591562 591562 Sherman, John, of Lewes, Sussex, yeoman 2
3951837 2007704 2007704 defendant Bocher John tailor 591562 591562 Bocher, John, of Lewes, Sussex, tailor 0
3953975 2008462 2008462 defendant Bucher John tailor 591562 591562 Bucher, John, of Lewes, Sussex, tailor 0
3955090 2008843 2008843 defendant Croydon John shoemaker 591562 591562 Croydon, John, of Lewes, Sussex, shoemaker 2
3959545 2010430 2010430 defendant Peverell John clerk 591562 591562 Peverell, John, of Lewes, Sussex, clerk 3
3961737 2011205 2011205 defendant Pryor John yeoman 591562 591562 Pryor, John, of Lewes, Sussex, yeoman 2
3964804 2012299 2012299 defendant Malle Richard draper 591562 591562 Malle, Richard, of Lewes, Sussex, draper 0
3972126 2014812 2014812 defendant Kydder John tailor 591562 591562 Kydder, John, of Lewes, Sussex, tailor 1
3973597 2015336 2015336 defendant Pryour Nicholas merchant 591562 591562 Pryour, Nicholas, of Lewes, Sussex, merchant 0
3987009 2020094 2020094 defendant Duffyld Thomas mercer 591562 591562 Duffyld, Thomas, of Lewes, Sussex, mercer 0
3999781 2024682 2024682 defendant Taylor Richard blacksmith 591562 591562 Taylor, Richard, of Lewes, Sussex, blacksmith 0
4033989 2036810 2036810 defendant Marshall Thomas chapman 591562 591562 Marshall, Thomas, of Lewes, Sussex, chapman 3
4033993 2036811 2036811 defendant Marshall Thomas chapman 591562 591562 Marshall, Thomas, of Lewes, Sussex, chapman 2
4055238 2044269 2044269 defendant Treaves Hugh   591562 591562 Treaves, Hugh, of Lewes, Sussex, gent, notary public 0
4057260 2044982 2044982 defendant Lyse Robert yeoman 591562 591562 Lyse, Robert, of Lewes, Sussex, yeoman 2
4069158 2049261 2049261 defendant Jurden John clerk 591562 591562 Jurden, John, of Lewes, Sussex, clerk 0
4069288 2049300 2049300 defendant Bonde Hugh mercer 591562 591562 Bonde, Hugh, of Lewes, Sussex, mercer 0
4069848 2049500 2049500 defendant Sherman Thomas, junior gent 591562 591562 Sherman, Thomas, junior, of Lewes, Sussex, gent 0
4069850 2049501 2049501 defendant Kydder John tailor 591562 591562 Kydder, John, of Lewes, Sussex, tailor 0
4073098 2050668 2050668 defendant Kydder John draper 591562 591562 Kydder, John, of Lewes, Sussex, draper 0
4099986 2060321 2060321 defendant Fuller William merchant 591562 591562 Fuller, William, of Lewes, Sussex, merchant 2
4102805 2061304 2061304 defendant Glanfilde John   591562 591562 Glanfilde, John, of Lewes, Sussex, slat layer 0
4107177 2062862 2062862 defendant Kidder John draper 591562 591562 Kidder, John, of Lewes, Sussex, draper 0
4136203 2073294 2073294 defendant Sherman Thomas, junior gent 591562 591562 Sherman, Thomas, junior, of Lewes, Sussex, gent 0
4151146 2078527 2078527 defendant Sherman Thomas gent 591562 591562 Sherman, Thomas, of Lewes, Sussex, gent 0
4153848 2079443 2079443 defendant Claggett Robert haberdasher 591562 591562 Claggett, Robert, of Lewes, Sussex, haberdasher 0
4160491 2081742 2081742 defendant Sherman Thomas, junior gent 591562 591562 Sherman, Thomas, junior, of Lewes, Sussex, gent 0
4166306 2083708 2083708 defendant Lucas John yeoman 591562 591562 Lucas, John, of Lewes, Sussex, yeoman 0
4178146 2087827 2087827 defendant Archer Gargus   591562 591562 Archer, Gargus , of Lewes, Sussex, mason 0
4182160 2089238 2089238 defendant Stanfeld John merchant 591562 591562 Stanfeld, John, of Lewes, Sussex, merchant 0
4206211 2097718 2097718 defendant Morley Anthony gent 591562 591562 Morley, Anthony, of Lewes, Sussex, or of Llannonno, Glamorgan, gent 0
4234415 2107578 2107578 defendant Palmer William victualer 591562 591562 Palmer, William, of Lewes, Sussex, victualer 1
4248177 2112378 2112378 defendant Morley Anthony gent 591562 591562 Morley, Anthony, of Lewes, Sussex, gent 0
4258405 2115777 2115777 defendant Fraunces Thomas gent 591562 591562 Fraunces, Thomas, of Lewes, Sussex, gent 3
4258410 2115778 2115778 defendant Fraunces Thomas gent 591562 591562 Fraunces, Thomas, of Lewes, Sussex, gent 3
4264705 2117837 2117837 defendant Luxford Thomas gent 591562 591562 Luxford, Thomas, of Lewes, Sussex, gent 0
4268775 2119150 2119150 defendant Pymbell Peter chapman 591562 591562 Pymbell, Peter, of Lewes, Sussex, chapman 0
4282238 2123686 2123686 defendant Burrell William vintner 591562 591562 Burrell, William, of Lewes, Sussex, vintner 0
4282526 2123791 2123791 defendant Harman John, junior merchant 591562 591562 Harman, John, junior, of Lewes, Sussex, merchant 0
4306950 2132572 2132572 defendant Goringe George esq 591562 591562 Goringe, George, of Lewes, Sussex, esq 0
4323516 2138285 2138285 defendant Snellinge Richard gent 591562 591562 Snellinge, Richard, of Lewes, Sussex, or of Porteslade, gent 0
4338755 2143307 2143307 defendant Batcheler John chapman 591562 591562 Batcheler, John, of Lewes, Sussex, chapman 2
4374079 2155800 2155800 defendant Lettys George currier 591562 591562 Lettys, George, of Lewes, Sussex, currier 1
4386684 2160224 2160224 defendant Norton George grocer 591562 591562 Norton, George, of Lewes, Sussex, grocer 0
4498909 2200296 2200296 defendant Hore Robert   591562 591562 Hore, Robert, of Lewes, Sussex, burgess 1
4658527 2248547 2248547 defendant Lardener Robert skinner 591562 591562 Lardener, Robert, of Lewes, Sussex, skinner 0
4658534 2248548 2248548 defendant Lardener Robert skinner 591562 591562 Lardener, Robert, of Lewes, Sussex, skinner 0
4679770 2259287 2259287 defendant Sheppestere William husbandman 591562 591562 Sheppestere, William, of Lewes, Sussex,husbandman 0
4683895 2260571 2260571 defendant Weer Richard yeoman 591562 591562 Weer, Richard, of Lewes, Sussex, yeoman 3
4700002 2265422 2265422 defendant Maryot John yeoman 591562 591562 Maryot, John, of Lewes, Sussex, yeoman 0
4725646 2273306 2273306 defendant Penenet or Pevenet John draper 591562 591562 Penenet or Pevenet, John, of Lewes, Sussex, draper 2
4728284 2274090 2274090 defendant Mounden Thomas   591562 591562 Mounden, Thomas, of Lewes, Sussex, brass worker 0
4728287 2274091 2274091 defendant Mounden Thomas brasier 591562 591562 Mounden, Thomas, of Lewes, Sussex, brasier 0
4728604 2274185 2274185 defendant Ifeld Walter draper 591562 591562 Ifeld, Walter, of Lewes, Sussex, draper 0
4730403 2274706 2274706 defendant Lardener Thomas chapman 591562 591562 Lardener, Thomas, of Lewes, Sussex, chapman 3
4744120 2278806 2278806 defendant Grene John butcher 591562 591562 Grene, John, of Lewes, Sussex, butcher 1
4744142 2278813 2278813 defendant Grene John butcher 591562 591562 Grene, John, of Lewes, Sussex, butcher 1
4744143 2278813 2278813 defendant Fuller John butcher 591562 591562 Fuller, John, of Lewes, Sussex, butcher 2
4747248 2279700 2279700 defendant Ifeld Walter draper 591562 591562 Ifeld, Walter, of Lewes, Sussex, draper 0
4747249 2279700 2279700 defendant Ifeld Richard draper 591562 591562 Ifeld, Richard, of Lewes, Sussex, draper 1
4791375 2293395 2293395 defendant Byrchet John painter 591562 591562 Byrchet, John, of Lewes, Sussex, painter 5
4791382 2293396 2293396 defendant Byrchet John painter 591562 591562 Byrchet, John, of Lewes, Sussex, painter 5

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