names

143 rows where place_id = 618231

✎ 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
3723516 1933625 1933625 plaintiff Payne Walter yeoman 618231 618231 Payne, Walter, of Swaffham Markett, yeoman 0
3744293 1940113 1940113 defendant Owold John tanner 618231 618231 Owold, John, of Swaffham Markett, tanner 1
3747664 1941189 1941189 defendant Walden John yeoman 618231 618231 Walden, John, of Swaffham Markett, yeoman 0
3751947 1942525 1942525 defendant Danyell Ralph gent 618231 618231 Danyell, Ralph, of Swaffham Markett, gent 0
3761561 1945629 1945629 defendant Chapman Robert yeoman 618231 618231 Chapman, Robert, of Swaffham Markett, yeoman 0
3775053 1949929 1949929 defendant Blake Robert woolman 618231 618231 Blake, Robert, of Swaffham Markett, woolman 2
3783786 1952695 1952695 defendant Lovence Walter husbandman 618231 618231 Lovence, Walter, of Swaffham Markett, husbandman 0
3799621 1957805 1957805 defendant Bryall or Byrall Theobald   618231 618231 Bryall or Byrall, Theobald, of Swaffham Markett, surgeon 0
3799938 1957899 1957899 defendant Leveold or Leneold John sminner 618231 618231 Leveold or Leneold, John, of Swaffham Markett, sminner 0
3821134 1964505 1964505 defendant Cressy John mercer 618231 618231 Cressy, John, of Swaffham Markett, mercer 4
3841449 1970904 1970904 defendant Carter William yeoman 618231 618231 Carter, William, of Swaffham Markett, yeoman 1
3841450 1970904 1970904 defendant Tame Edmund yeoman 618231 618231 Tame, Edmund, of Swaffham Markett, yeoman 2
3841454 1970905 1970905 defendant Tebald Robert yeoman 618231 618231 Tebald, Robert, of Swaffham Markett, yeoman 0
3851577 1974081 1974081 plaintiff Payn Walter (legal representative) 618231 618231 Payn, Walter, of Swaffham Markett, executor of 0
3873236 1981265 1981265 defendant Walter William husbandman 618231 618231 Walter, William, of Swaffham Markett, husbandman 0
3875972 1982215 1982215 defendant Orwell William gent 618231 618231 Orwell, William, of Swaffham Markett, gent 0
3875973 1982215 1982215 defendant Palmer John laborer 618231 618231 Palmer, John, of Swaffham Markett, laborer 1
3875974 1982215 1982215 defendant Purvys John laborer 618231 618231 Purvys, John, of Swaffham Markett, laborer 2
3878814 1983165 1983165 defendant Orwell William gent 618231 618231 Orwell, William, of Swaffham Markett, gent 0
3879679 1983459 1983459 defendant Awpe John saddler 618231 618231 Awpe, John, of Swaffham Markett, saddler 3
3883953 1984904 1984904 defendant Lawes Henry yeoman 618231 618231 Lawes, Henry, of Swaffham Markett, yeoman 2
3893221 1987970 1987970 defendant Calson Clement laborer 618231 618231 Calson, Clement, of Swaffham Markett, laborer 0
3893222 1987970 1987970 defendant Chapman Richard laborer 618231 618231 Chapman, Richard, of Swaffham Markett, laborer 1
3893223 1987970 1987970 defendant Warner alias Erles Thomas laborer 618231 618231 Warner alias Erles, Thomas, of Swaffham Markett, laborer 2
3893224 1987970 1987970 defendant Antyngham John laborer 618231 618231 Antyngham, John, of Swaffham Markett, laborer 3
3893225 1987970 1987970 defendant Aylmer Robert laborer 618231 618231 Aylmer, Robert, of Swaffham Markett, laborer 4
3893226 1987970 1987970 defendant Anderson John laborer 618231 618231 Anderson, John, of Swaffham Markett, laborer 5
3893227 1987970 1987970 defendant Mumerye Henry laborer 618231 618231 Mumerye, Henry, of Swaffham Markett, laborer 6
3896519 1989043 1989043 defendant Ryplyngham Agnes widow 618231 618231 Ryplyngham, Agnes, of Swaffham Markett, widow 1
3897662 1989427 1989427 defendant Lether Alan husbandman 618231 618231 Lether, Alan, of Swaffham Markett, husbandman 4
3897928 1989514 1989514 defendant Lebold John skinner 618231 618231 Lebold, John, of Swaffham Markett, skinner 1
3905614 1992147 1992147 defendant Dawes alias Lawes John   618231 618231 Dawes alias Lawes, John, of Swaffham Markett, tallow chandler 2
3908768 1993227 1993227 defendant Davy Thomas butcher 618231 618231 Davy, Thomas, of Swaffham Markett, butcher 3
3923785 1998259 1998259 defendant Lenowe Walter yeoman 618231 618231 Lenowe, Walter, of Swaffham Markett, yeoman 0
3923788 1998260 1998260 defendant Lenowe Walter yeoman 618231 618231 Lenowe, Walter, of Swaffham Markett, yeoman 0
3946907 2005987 2005987 defendant Grene William yeoman 618231 618231 Grene, William, of Swaffham Markett, yeoman 0
3946908 2005987 2005987 defendant Grene Robert yeoman 618231 618231 Grene, Robert, of Swaffham Markett, yeoman 1
3948833 2006659 2006659 defendant Morrell Robert, senior (legal representative) 618231 618231 Morrell, Robert, senior, of Swaffham Markett, tanner, executrix of 0
3948834 2006659 2006659 defendant Morrell Elizabeth widow 618231 618231 Morrell, Elizabeth, of Swaffham Markett, widow 1
3948836 2006660 2006660 defendant Myles William (legal representative) 618231 618231 Myles, William, of Swaffham Markett, sherman, executors of 0
3948838 2006660 2006660 defendant Morrell Robert (legal representative) 618231 618231 Morrell, Robert, of Swaffham Markett, tanner, executrix of 2
3948839 2006660 2006660 defendant Morrell Elizabeth widow 618231 618231 Morrell, Elizabeth, of Swaffham Markett, widow 3
3955191 2008880 2008880 defendant Yonges William husbandman 618231 618231 Yonges, William, of Swaffham Markett, husbandman 0
3955192 2008880 2008880 defendant Kaymer George   618231 618231 Kaymer, George, of Swaffham Markett, ploughwright 1
3963992 2012016 2012016 plaintiff Anthony Arthur   618231 618231 Anthony, Arthur, of Swaffham Markett 0
3973848 2015421 2015421 defendant Pratt John yeoman 618231 618231 Pratt, John, of Swaffham Markett, yeoman 3
4001292 2025241 2025241 plaintiff Halman Thomas shoemaker 618231 618231 Halman, Thomas, of Swaffham Markett, shoemaker 0
4001293 2025241 2025241 defendant Tanne Thomas shoemaker 618231 618231 Tanne, Thomas, of Swaffham Markett, shoemaker 0
4015065 2030076 2030076 defendant Lawes John yeoman 618231 618231 Lawes, John, of Swaffham Markett, yeoman 16
4015659 2030298 2030298 plaintiff Snellynge Richard smith 618231 618231 Snellynge, Richard, of Swaffham Markett, smith 0
4015660 2030298 2030298 defendant Watt John smith 618231 618231 Watt, John, of Swaffham Markett, smith 0
4015661 2030298 2030298 defendant Tan Thomas shoemaker 618231 618231 Tan, Thomas, of Swaffham Markett, shoemaker 1
4020776 2032157 2032157 defendant Tanne Thomas shoemaker 618231 618231 Tanne, Thomas, of Swaffham Markett, shoemaker 0
4020777 2032157 2032157 defendant James John husbandman 618231 618231 James, John, of Swaffham Markett, husbandman 1
4022055 2032619 2032619 defendant Bunfan Robert, junior husbandman 618231 618231 Bunfan, Robert, junior, of Swaffham Markett, husbandman 0
4022056 2032619 2032619 defendant Bunfan Robert, senior husbandman 618231 618231 Bunfan, Robert, senior, of Swaffham Markett, husbandman 1
4022060 2032620 2032620 defendant Bunsan Robert, senior husbandman 618231 618231 Bunsan, Robert, senior, of Swaffham Markett, husbandman 0
4022061 2032620 2032620 defendant Bunsan Robert, junior husbandman 618231 618231 Bunsan, Robert, junior, of Swaffham Markett, husbandman 1
4022154 2032653 2032653 plaintiff Anthony Arthur saddler 618231 618231 Anthony, Arthur, of Swaffham Markett, saddler 0
4022155 2032653 2032653 defendant Tanne Thomas yeoman 618231 618231 Tanne, Thomas, of Swaffham Markett, yeoman 0
4043992 2040302 2040302 plaintiff Pyckes Richard fishmonger 618231 618231 Pyckes, Richard, of Swaffham Markett, innholder, fishmonger 0
4045942 2040997 2040997 defendant Leman Walter merchant 618231 618231 Leman, Walter, of Swaffham Markett, merchant 0
4052574 2043342 2043342 defendant Slappe John husbandman 618231 618231 Slappe, John, of Swaffham Markett, husbandman 0
4053283 2043550 2043550 defendant Beverley John mercer 618231 618231 Beverley, John, of Swaffham Markett, mercer 8
4054685 2044065 2044065 defendant Bunfanne Robert, senior husbandman 618231 618231 Bunfanne, Robert, senior, of Swaffham Markett, husbandman 1
4055420 2044333 2044333 defendant Atmere John husbandman 618231 618231 Atmere, John, of Swaffham Markett, husbandman 3
4061262 2046434 2046434 defendant Page Henry yeoman 618231 618231 Page, Henry, of Swaffham Markett, yeoman 1
4061263 2046434 2046434 defendant Bett alias Sucklyng Robert yeoman 618231 618231 Bett alias Sucklyng, Robert, of Swaffham Markett, yeoman 2
4065089 2047801 2047801 defendant Atmere or Mere Simon husbandman 618231 618231 Atmere or Mere, Simon, of Swaffham Markett, husbandman 1
4071192 2050001 2050001 plaintiff Morell John tanner 618231 618231 Morell, John, of Swaffham Markett, tanner 0
4071193 2050001 2050001 defendant Tanne Edmund (legal representative) 618231 618231 Tanne, Edmund, of Swaffham Markett, cordwainer, executors of 0
4071194 2050001 2050001 defendant Tanne Ellen widow 618231 618231 (Tanne, Ellen, of Swaffham Markett, widow 1
4071195 2050001 2050001 defendant Tanne Thomas yeoman 618231 618231 Tanne, Thomas, of Swaffham Markett, yeoman 2
4079092 2052823 2052823 defendant Wentlond John cordwainer 618231 618231 Wentlond, John, of Swaffham Markett, cordwainer 1
4084584 2054763 2054763 defendant Bunfan Alice widow 618231 618231 Bunfan, Alice, of Swaffham Markett, widow 0
4088914 2056339 2056339 defendant Greve John husbandman 618231 618231 Greve, John, of Swaffham Markett, husbandman 2
4096282 2059000 2059000 defendant Cooty William husbandman 618231 618231 Cooty, William, of Swaffham Markett, husbandman 0
4096891 2059221 2059221 defendant Warner Ralph cordwainer 618231 618231 Warner, Ralph, of Swaffham Markett, cordwainer 3
4098537 2059807 2059807 defendant Rust Thomas fishmonger 618231 618231 Rust, Thomas, of Swaffham Markett, fishmonger 0
4101834 2060965 2060965 defendant Cockerton John husbandman 618231 618231 Cockerton, John, of Swaffham Markett, husbandman 1
4101835 2060965 2060965 defendant Overton Christopher husbandman 618231 618231 Overton, Christopher, of Swaffham Markett, husbandman 2
4101836 2060965 2060965 defendant Parker George husbandman 618231 618231 Parker, George, of Swaffham Markett, husbandman 3
4111301 2064290 2064290 defendant Daynes Thomas carpenter 618231 618231 Daynes, Thomas, of Swaffham Markett, carpenter 0
4131197 2071477 2071477 defendant Lawes William chandler 618231 618231 Lawes, William, of Swaffham Markett, chandler 0
4134458 2072655 2072655 defendant Morrell John tanner 618231 618231 Morrell, John, of Swaffham Markett, tanner 0
4155176 2079903 2079903 defendant Pepper Thomas husbandman 618231 618231 Pepper, Thomas, of Swaffham Markett, husbandman 1
4171060 2085359 2085359 defendant Cotes William husbandman 618231 618231 Cotes, William, of Swaffham Markett, husbandman 1
4209883 2099017 2099017 defendant Purveys Christopher blacksmith 618231 618231 Purveys, Christopher, of Swaffham Markett, blacksmith 0
4209884 2099017 2099017 defendant Pykas Robert tailor 618231 618231 Pykas, Robert, of Swaffham markett, tailor 1
4215265 2100835 2100835 defendant Cannon Simon yeoman 618231 618231 Cannon, Simon, of Swaffham Markett, yeoman 0
4220914 2102809 2102809 defendant Pyckeryng Walter yeoman 618231 618231 Pyckeryng, Walter, of Swaffham Markett, yeoman 2
4220915 2102809 2102809 defendant Gyles Richard yeoman 618231 618231 Gyles, Richard, of Swaffham Markett, yeoman 3
4222047 2103202 2103202 defendant Cannon Simon yeoman 618231 618231 Cannon, Simon, of Swaffham Markett, yeoman 1
4229151 2105677 2105677 defendant Roote David fishmonger 618231 618231 Roote, David, of Swaffham Markett, fishmonger 0
4229152 2105677 2105677 defendant Chante Nicholas fishmonger 618231 618231 Chante, Nicholas, of Swaffham Markett, fishmonger 1
4229153 2105677 2105677 defendant Reder John yeoman 618231 618231 Reder, John, of Swaffham Markett, yeoman 2
4231599 2106553 2106553 defendant Parlett John husbandman 618231 618231 Parlett, John, of Swaffham Markett, husbandman 0
4231600 2106553 2106553 defendant Creake Thomas husbandman 618231 618231 Creake, Thomas, of Swaffham Markett, husbandman 1
4233044 2107064 2107064 defendant Daynes Thomas carpenter 618231 618231 Daynes, Thomas, of Swaffham Markett, carpenter 0
4244074 2110999 2110999 defendant Thurkle Ciprian husbandman 618231 618231 Thurkle, Ciprian, of Swaffham Markett, husbandman 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);