names

176 rows where place_id = 599415

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3636689 1906266 1906266 defendant Stephyn Lawrence butcher 599415 599415 Stephyn, Lawrence, of Rye, Sussex, butcher 0
3642122 1907985 1907985 defendant Stevyns Lawrence yeoman 599415 599415 Stevyns, Lawrence, of Rye, Sussex, yeoman 0
3644365 1908655 1908655 defendant Barden Walter yeoman 599415 599415 (Barden, Walter, of Rye, Sussex, yeoman 3
3657252 1912530 1912530 defendant Sutton Nicholas merchant 599415 599415 Sutton, Nicholas, of Rye, Sussex, merchant 2
3666380 1915435 1915435 defendant Wayte William   599415 599415 Wayte, William, of Rye, Sussex, ale brewer 0
3666644 1915513 1915513 plaintiff Marchalle John   599415 599415 Marchalle, John, of Rye, Sussex 1
3669932 1916540 1916540 defendant Oxenbrege Thomas chapman 599415 599415 Oxenbrege, Thomas, of Rye, Sussex, chapman 0
3669937 1916542 1916542 defendant Oxenbrege Thomas chapman 599415 599415 Oxenbrege, Thomas, of Rye, Sussex, chapman 1
3685913 1921751 1921751 defendant Baseden Walter yeoman 599415 599415 Baseden, Walter, of Rye, Sussex, yeoman 3
3687373 1922226 1922226 defendant Edolf John yeoman 599415 599415 Edolf, John, of Rye, Sussex, yeoman 0
3697148 1925329 1925329 defendant Sutton Nicholas gent 599415 599415 Sutton, Nicholas, of Rye, Sussex, gent 0
3699742 1926147 1926147 defendant Sutton Nicholas merchant 599415 599415 Sutton, Nicholas, of Rye, Sussex, merchant 0
3706430 1928298 1928298 defendant Tolkyn Nicholas yeoman 599415 599415 Tolkyn, Nicholas, of Rye, Sussex, yeoman 2
3723449 1933602 1933602 defendant Edolff John yeoman 599415 599415 Edolff, John, of Rye, Sussex, yeoman 1
3727761 1934953 1934953 defendant Chapleyn John yeoman 599415 599415 Chapleyn, John, of Rye, Sussex, yeoman 0
3736396 1937626 1937626 plaintiff Hynghett Richard   599415 599415 Hynghett, Richard, of Rye, Sussex 0
3736617 1937703 1937703 defendant Branthwayte Simon merchant 599415 599415 Branthwayte, Simon, of Rye, Sussex, merchant 1
3738243 1938174 1938174 defendant Partryche Thomas husbandman 599415 599415 Partryche, Thomas, of Rye, Sussex, husbandman 1
3764028 1946394 1946394 defendant Peddell Richard mercer 599415 599415 Peddell, Richard, of Rye, Sussex, mercer 0
3764478 1946553 1946553 defendant Sutton Nicholas gent 599415 599415 Sutton, Nicholas, of Rye, Sussex, gent 0
3769987 1948270 1948270 defendant Barnes Robert yeoman 599415 599415 Barnes, Robert, of Rye, Sussex, yeoman 0
3782711 1952336 1952336 plaintiff Inglet Richard   599415 599415 Inglet, Richard, of Rye, Sussex 0
3783556 1952615 1952615 defendant Pedyll Richard grocer 599415 599415 Pedyll, Richard, of Rye, Sussex, grocer 0
3794290 1956088 1956088 defendant Oxenbregge Robert butcher 599415 599415 Oxenbregge, Robert, of Rye, Sussex, butcher 0
3801210 1958300 1958300 defendant Bysvyn or Bysbyn alias Bartholomewe William yeoman 599415 599415 Bysvyn or Bysbyn alias Bartholomewe, William, of Rye, Sussex, yeoman 0
3824663 1965588 1965588 defendant Morys Nicholas draper 599415 599415 Morys, Nicholas, of Rye, Sussex, draper 2
3832756 1968171 1968171 defendant Johnson alias Hayne William tailor 599415 599415 Johnson alias Hayne, William, of Rye, Sussex, tailor 1
3849150 1973331 1973331 defendant Coke Robert innholder 599415 599415 Coke, Robert, of Rye, Sussex, innholder 0
3849180 1973340 1973340 defendant Benett John brewer 599415 599415 Benett, John, of Rye, Sussex, brewer 1
3855141 1975242 1975242 defendant Lympeney John   599415 599415 Lympeney, John, of Rye, Sussex, gent, customs controller, port of Chichester 1
3855156 1975247 1975247 defendant Lympeney John   599415 599415 Lympeney, John, of Rye, Sussex, gent, customs controller, port of Chichester 2
3856249 1975574 1975574 defendant Lympeney John gent 599415 599415 Lympeney, John, of Rye, Sussex, gent 3
3856261 1975576 1975576 defendant Lympeney John gent 599415 599415 Lympeney, John, of Rye, Sussex, gent 3
3856854 1975771 1975771 defendant Inold William clerk 599415 599415 Inold, William, of Rye, Sussex, clerk 0
3858387 1976284 1976284 defendant Byrchett Thomas brewer 599415 599415 Byrchett, Thomas, of Rye, Sussex, brewer 0
3859968 1976836 1976836 defendant Stokeden John tailor 599415 599415 Stokeden, John, of Rye, Sussex, tailor 1
3860038 1976855 1976855 defendant Pedyll Richard gent 599415 599415 Pedyll, Richard, of Rye, Sussex, gent 0
3860913 1977138 1977138 defendant Byspyn Thomas yeoman 599415 599415 Byspyn, Thomas, of Rye, Sussex, yeoman 0
3860915 1977138 1977138 defendant Byspyn Margaret widow 599415 599415 Byspyn, Margaret, of Rye, Sussex, widow 2
3860919 1977139 1977139 defendant Byspyn Margaret widow 599415 599415 Byspyn, Margaret, of Rye, Sussex, widow 2
3860950 1977150 1977150 defendant Byspyn Margaret widow 599415 599415 Byspyn, Margaret, of Rye, Sussex, widow 1
3860953 1977151 1977151 defendant Byspyn Margaret widow 599415 599415 Byspyn, Margaret, of Rye, Sussex, widow 1
3863791 1978064 1978064 defendant Moreys Nicholas tailor 599415 599415 Moreys, Nicholas, of Rye, Sussex, tailor 2
3867105 1979237 1979237 defendant Byrchett Thomas brewer 599415 599415 Byrchett, Thomas, of Rye, Sussex, brewer 0
3870023 1980219 1980219 defendant Barne Robert chapman 599415 599415 Barne, Robert, of Rye, Sussex, chapman 0
3870034 1980221 1980221 defendant Barne Robert chapman 599415 599415 Barne, Robert, of Rye, Sussex, chapman 3
3882582 1984437 1984437 defendant Swan Adam chapman 599415 599415 Swan, Adam, of Rye, Sussex, chapman 0
3894347 1988326 1988326 defendant Henbery John yeoman 599415 599415 Henbery, John, of Rye, Sussex, yeoman 0
3928055 1999718 1999718 defendant Holmes Thomas gent 599415 599415 Holmes, Thomas, of Rye, Sussex, gent 0
3928067 1999723 1999723 defendant Holmes Thomas gent 599415 599415 Holmes, Thomas, of Rye, Sussex, gent 0
3930471 2000536 2000536 defendant Boteler William chapman 599415 599415 Boteler, William, of Rye, Sussex, chapman 4
3933672 2001552 2001552 defendant Tyrrott Francis fisher man 599415 599415 Tyrrott, Francis, of Rye, Sussex, fisher man 0
3933973 2001665 2001665 defendant Davison John chapman 599415 599415 Davison, John, of Rye, Sussex, chapman 1
3933978 2001666 2001666 defendant Davison John chapman 599415 599415 Davison, John, of Rye, Sussex, chapman 1
3938601 2003253 2003253 defendant Holmes John gent 599415 599415 Holmes, John, of Rye, Sussex, gent 5
3942005 2004336 2004336 defendant Davyson John mercer 599415 599415 Davyson, John, of Rye, sussex, mercer 0
3942889 2004623 2004623 defendant Davison John yeoman 599415 599415 Davison, John, of Rye, Sussex, yeoman 0
3945145 2005395 2005395 defendant Haryson Giles chapman 599415 599415 Haryson, Giles, of Rye, Sussex, chapman 4
3946856 2005969 2005969 defendant Byrde George yeoman 599415 599415 Byrde, George, of Rye, Sussex, yeoman 0
3947374 2006155 2006155 defendant Bygg William mariner 599415 599415 Bygg, William, of Rye, Sussex, mariner 0
3952807 2008053 2008053 defendant Mynge Henry merchant 599415 599415 Mynge, Henry, of Rye, Sussex, merchant 0
3958301 2009979 2009979 defendant Sadler Thomas pewterer 599415 599415 Sadler, Thomas, of Rye, Sussex, pewterer 1
3959999 2010595 2010595 defendant Davyson John chapman or yeoman 599415 599415 Davyson, John, of Rye, Sussex, chapman or yeoman 2
3967652 2013322 2013322 plaintiff Bysshope Henry   599415 599415 Bysshope, Henry, of Rye, Sussex 0
3967654 2013323 2013323 plaintiff Bysshope Henry   599415 599415 Bysshope, Henry, of Rye, Sussex 0
3970169 2014165 2014165 plaintiff Dallet John yeoman 599415 599415 Dallet, John, of Rye, Sussex, yeoman 0
3971490 2014587 2014587 defendant Bowyer William   599415 599415 Bowyer, William, of Rye, Sussex, laborer, stable man 0
3973923 2015449 2015449 defendant Mercer John chapman 599415 599415 Mercer, John, of Rye, Sussex, chapman 2
3991989 2021898 2021898 plaintiff Bruster John carpenter 599415 599415 Bruster, John, of Rye, Sussex, carpenter 0
3993792 2022530 2022530 defendant Chapman William innholder 599415 599415 Chapman, William, of Rye, Sussex, innholder 1
3993796 2022531 2022531 defendant Chapman William innkeeper 599415 599415 Chapman, William, of Rye, Sussex, innkeeper 1
3998207 2024105 2024105 defendant Gaymer Henry yeoman 599415 599415 Gaymer, Henry, of Rye, Sussex, yeoman 0
4001888 2025450 2025450 defendant Johnson John beer brewer 599415 599415 Johnson, John, of Rye, Sussex, or of Canterbury St Dunstan, Kent, beer brewer 0
4003672 2026080 2026080 defendant Page John chapman 599415 599415 Page, John, of Rye, Sussex, chapman 1
4028009 2034669 2034669 defendant Stace Richard yeoman 599415 599415 Stace, Richard, of Rye, Sussex, yeoman 0
4028011 2034670 2034670 defendant Stace Richard yeoman 599415 599415 Stace, Richard, of Rye, Sussex, yeoman 0
4029452 2035171 2035171 defendant Carr Thomas tailor 599415 599415 Carr, Thomas, of Rye, Sussex, tailor 3
4029457 2035172 2035172 defendant Carr Thomas tailor 599415 599415 Carr, Thomas, of Rye, Sussex, tailor 3
4031025 2035768 2035768 defendant Gaymer Henry yeoman 599415 599415 Gaymer, Henry, of Rye, Sussex, yeoman 0
4032819 2036392 2036392 defendant Harrys Francis yeoman 599415 599415 Harrys, Francis, of Rye, Sussex, yeoman 0
4032824 2036394 2036394 defendant Harrys Francis yeoman 599415 599415 Harrys, Francis, of Rye, Sussex, yeoman 0
4032825 2036394 2036394 defendant Mynge Henry yeoman 599415 599415 Mynge, Henry, of Rye, Sussex, yeoman 1
4051004 2042801 2042801 defendant Harrison Giles yeoman 599415 599415 Harrison, Giles, of Rye, Sussex, yeoman 1
4051009 2042802 2042802 defendant Harryson Giles yeoman 599415 599415 Harryson, Giles, of Rye, Sussex, yeoman 1
4063966 2047393 2047393 defendant Purvage Nicholas merchant 599415 599415 Purvage, Nicholas, of Rye, Sussex, merchant 0
4068235 2048939 2048939 defendant Harte Henry grocer 599415 599415 Harte, Henry, of Rye, Sussex, grocer 0
4081427 2053667 2053667 defendant Harrys Francis gent 599415 599415 Harrys, Francis, of Rye, Sussex, gent 0
4081905 2053830 2053830 defendant Larder Nicholas gent 599415 599415 (Larder, Nicholas, of Rye, Sussex, gent 1
4082123 2053906 2053906 defendant Jackson Robert gent 599415 599415 Jackson, Robert, of Rye, Sussex, gent 0
4092524 2057635 2057635 defendant Danyell Richard yeoman 599415 599415 Danyell, Richard, of Rye, Sussex, yeoman 0
4092526 2057636 2057636 defendant Davernall William   599415 599415 Davernall, William, of Rye, Sussex, gent, Jurat of Rye 0
4094220 2058268 2058268 defendant Parsall James merchant 599415 599415 Parsall, James, of Rye, Sussex, merchant 0
4096903 2059224 2059224 defendant Peersall James merchant 599415 599415 Peersall, James, of Rye, Sussex, merchant 0
4097806 2059549 2059549 defendant Gamer or Gainer Henry   599415 599415 Gamer or Gainer, Henry, of Rye, Sussex, Jurat 0
4102749 2061284 2061284 defendant Purvage Nicholas merchant 599415 599415 Purvage, Nicholas, of Rye, Sussex, merchant 0
4106302 2062543 2062543 defendant Thorpe John chapman 599415 599415 Thorpe, John, of Rye, Sussex, chapman 0
4106305 2062544 2062544 defendant Thorpe John chapman 599415 599415 Thorpe, John, of Rye, Sussex, chapman 0
4106309 2062545 2062545 defendant Thorpe John yeoman 599415 599415 Thorpe, John, of Rye, Sussex, yeoman 0
4107185 2062865 2062865 defendant Jackson Robert merchant 599415 599415 Jackson, Robert, of Rye, Sussex, merchant 0
4117644 2066607 2066607 defendant Tharpe John chapman 599415 599415 Tharpe, John, of Rye, Sussex, chapman 1

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