names

160 rows where place_id = 587386

✎ 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
3591264 1864893 1864893 defendant Spore Thomas husbandman 587386 587386 Spore, Thomas, of Sparham, husbandman 0
3599967 1867645 1867645 defendant Felowe James husbandman 587386 587386 Felowe, James, of Sparham, husbandman 0
3602492 1868439 1868439 defendant Eryngton Robert husbandman 587386 587386 Eryngton, Robert, of Sparham, husbandman 6
3614255 1872125 1872125 defendant Birde Nicholas husbandman 587386 587386 Birde, Nicholas, of Sparham, husbandman 0
3622698 1874628 1874628 defendant Oldman Roger yeoman 587386 587386 Oldman, Roger, of Sparham, yeoman 1
3622703 1874629 1874629 defendant Oldman Roger yeoman 587386 587386 Oldman, Roger, of Sparham, yeoman 2
3638505 1906858 1906858 defendant Crome Richard husbandman 587386 587386 Crome, Richard, of Sparham, husbandman 3
3651959 1910958 1910958 defendant Crome Richard husbandman 587386 587386 Crome, Richard, of Sparham, husbandman 3
3702644 1927094 1927094 defendant Folkard Joan widow 587386 587386 Folkard, Joan, of Sparham, widow 0
3744968 1940332 1940332 defendant Folkard Joan widow 587386 587386 Folkard, Joan, of Sparham, widow 0
3744969 1940332 1940332 defendant Park John yeoman 587386 587386 Park, John, of Sparham, yeoman 1
3757570 1944346 1944346 defendant Parke John yeoman 587386 587386 Parke, John, of Sparham, yeoman 0
3763310 1946158 1946158 defendant Cokke John husbandman 587386 587386 Cokke, John, of Sparham, husbandman 0
3780427 1951613 1951613 defendant Gravell John husbandman 587386 587386 Gravell, John, of Sparham, husbandman 0
3781348 1951908 1951908 defendant Stermyn Agnes widow 587386 587386 Stermyn, Agnes, of Sparham, widow 4
3797945 1957255 1957255 defendant Standwyche Robert butcher 587386 587386 Standwyche, Robert, of Sparham, butcher 1
3831448 1967720 1967720 defendant Sondwyche Robert butcher 587386 587386 Sondwyche, Robert, of Sparham, butcher 1
3832084 1967939 1967939 defendant Sanwich Robert butcher 587386 587386 Sanwich, Robert, of Sparham, butcher 0
3902147 1990951 1990951 defendant Jerbryge Christopher husbandman 587386 587386 Jerbryge, Christopher, of Sparham, husbandman 0
3904074 1991604 1991604 defendant Parke John yeoman 587386 587386 Parke, John, of Sparham, yeoman 1
3943652 2004893 2004893 defendant Grenewood James husbandman 587386 587386 Grenewood, James, of Sparham, husbandman 0
3947625 2006232 2006232 defendant Dawbeney Robert yeoman 587386 587386 Dawbeney, Robert, of Sparham, yeoman 1
3977135 2016574 2016574 defendant Coo John   587386 587386 Coo, John, of Sparham, paten maker 0
3979216 2017316 2017316 defendant Harvye Edmund gent 587386 587386 Harvye, Edmund, of Sparham, gent 0
3984919 2019363 2019363 defendant Hamond John yeoman 587386 587386 Hamond, John, of Sparham, yeoman 2
3997715 2023939 2023939 defendant Sheringham Denis husbandman 587386 587386 Sheringham, Denis, of Sparham, husbandman 2
3999521 2024593 2024593 plaintiff Fytlyng Nicholas yeoman 587386 587386 Fytlyng, Nicholas, of Sparham, yeoman 0
4001380 2025272 2025272 plaintiff Hamond John yeoman 587386 587386 Hamond, John, of Sparham, yeoman 0
4017722 2031044 2031044 defendant Hamont John yeoman 587386 587386 Hamont, John, of Sparham, yeoman 0
4017724 2031045 2031045 defendant Hament John yeoman 587386 587386 Hament, John, of Sparham, yeoman 0
4021308 2032347 2032347 defendant Gryngton or Eryngton John husbandman 587386 587386 Gryngton or Eryngton, John, of Sparham, husbandman 1
4028081 2034694 2034694 defendant Broune or Brome Thomas, senior yeoman 587386 587386 Broune or Brome, Thomas, senior, of Sparham, yeoman 0
4036907 2037878 2037878 defendant Erington John yeoman 587386 587386 Erington, John, of Sparham, yeoman 0
4036908 2037878 2037878 defendant Deynes Vincent   587386 587386 Deynes, Vincent, of Sparham, rough mason 1
4055552 2044380 2044380 plaintiff Blackney or Blakeney John esq 587386 587386 Blackney or Blakeney, John, of Sparham, esq 0
4055554 2044381 2044381 plaintiff Blackney or Blakeney John esq 587386 587386 Blackney or Blakeney, John, of Sparham, esq 0
4059613 2045830 2045830 defendant Cockett Anthony gent 587386 587386 Cockett, Anthony, of Sparham, gent 0
4076007 2051716 2051716 defendant Borne Richard clerk 587386 587386 Borne, Richard, of Sparham, clerk 0
4086580 2055487 2055487 defendant Saborn William husbandman 587386 587386 Saborn, William, of Sparham, husbandman 0
4100893 2060634 2060634 defendant Fytlyn Nicholas husbandman 587386 587386 Fytlyn, Nicholas, of Sparham, husbandman 2
4100897 2060635 2060635 defendant Fitling Nicholas husbandman 587386 587386 Fitling, Nicholas, of Sparham, husbandman 2
4106983 2062793 2062793 defendant Blackeney Charles gent 587386 587386 Blackeney, Charles, of Sparham, gent 0
4121171 2067867 2067867 defendant Bourne Richard clerk 587386 587386 Bourne, Richard, of Sparham, clerk 0
4121487 2067979 2067979 defendant Blakeney Charles gent 587386 587386 Blakeney, Charles, of Sparham, gent 0
4125714 2069479 2069479 defendant Bourne Richard clerk 587386 587386 Bourne, Richard, of Sparham, clerk 0
4142827 2075666 2075666 defendant Fytlinge Nicholas spooner 587386 587386 Fytlinge, Nicholas, of Sparham, spooner 0
4142828 2075666 2075666 defendant Partryche John carpenter 587386 587386 Partryche, John, of Sparham, carpenter 1
4156855 2080477 2080477 defendant Blackney Charles gent 587386 587386 Blackney, Charles, of Sparham, gent 0
4168822 2084586 2084586 defendant Bentham Thomas   587386 587386 Bentham, Thomas, of Sparham, shepherd 1
4168825 2084587 2084587 defendant Bantam Thomas   587386 587386 Bantam, Thomas, of Sparham, shepherd 1
4182933 2089511 2089511 defendant Warcuppe William tailor 587386 587386 Warcuppe, William, of Sparham, tailor 0
4191232 2092497 2092497 defendant Blackeney John gent 587386 587386 Blackeney, John, of Sparham, gent 0
4199515 2095381 2095381 defendant Blackney Lancelot gent 587386 587386 Blackney, Lancelot, of Sparham, gent 1
4201416 2096042 2096042 defendant Blakeney Charles gent 587386 587386 Blakeney, Charles, of Sparham, gent 3
4204271 2097043 2097043 defendant Blackney Charles gent 587386 587386 Blackney, Charles, of Sparham, gent 0
4211426 2099550 2099550 defendant Atkynson John yeoman 587386 587386 Atkynson, John, of Sparham, yeoman 2
4214769 2100671 2100671 defendant Blakeney Lancelot gent 587386 587386 Blakeney, Lancelot, of Sparham, gent 3
4228263 2105367 2105367 defendant Ingledewe Richard husbandman 587386 587386 Ingledewe, Richard, of Sparham, husbandman 0
4250300 2113081 2113081 defendant Ingledewe Richard husbandman 587386 587386 Ingledewe, Richard, of Sparham, husbandman 0
4250339 2113095 2113095 defendant Thetford Lancelot gent 587386 587386 Thetford, Lancelot, of Sparham, gent 1
4254579 2114521 2114521 defendant Darbye William husbandman 587386 587386 Darbye, William, of Sparham, husbandman 0
4254581 2114521 2114521 defendant Dunham William thatcher 587386 587386 Dunham, William, of Sparham, thatcher 2
4263308 2117392 2117392 defendant Partridge John husbandman 587386 587386 Partridge, John, of Sparham, husbandman 2
4277412 2122021 2122021 defendant Blackeney Lancelot gent 587386 587386 Blackeney, Lancelot, of Sparham, gent 1
4324513 2138589 2138589 defendant Butler Henry gent 587386 587386 Butler, Henry, of Sparham, gent 0
4324741 2138668 2138668 defendant Bateman Richard husbandman 587386 587386 Bateman, Richard, of Sparham, husbandman 0
4324742 2138668 2138668 defendant Sturmyne John husbandman 587386 587386 Sturmyne, John, of Sparham, husbandman 1
4326218 2139134 2139134 defendant Blakeney Lancelot gent 587386 587386 Blakeney, Lancelot, of Sparham, gent 3
4335840 2142265 2142265 defendant Howett Richard husbandman 587386 587386 Howett, Richard, of Sparham, husbandman 3
4338943 2143375 2143375 defendant Blakney Lancelot gent 587386 587386 Blakney, Lancelot, of Sparham, gent 0
4352400 2148077 2148077 defendant Blakeney Lancelot gent 587386 587386 Blakeney, Lancelot, of Sparham, gent 0
4358974 2150375 2150375 defendant Blakney Lancelot gent 587386 587386 Blakney, Lancelot, of Sparham, gent 0
4358975 2150375 2150375 defendant Dengayn Henry gent 587386 587386 Dengayn, Henry, of Sparham, gent 1
4379148 2157625 2157625 defendant Blakeney Lancelot gent 587386 587386 Blakeney, Lancelot, of Sparham, gent 0
4383636 2159238 2159238 defendant Blakney Lancelot gent 587386 587386 Blakney, Lancelot, of Sparham, gent 0
4383637 2159238 2159238 defendant Dengayn Henry gent 587386 587386 Dengayn, Henry, of Sparham, gent 1
4390333 2161389 2161389 defendant Hewett Richard tailor 587386 587386 Hewett, Richard, of Sparham, tailor 2
4391499 2161769 2161769 defendant Sturman John husbandman 587386 587386 Sturman, John, of Sparham, husbandman 1
4391501 2161769 2161769 defendant Norton George husbandman 587386 587386 Norton, George, of Sparham, husbandman 3
4391503 2161770 2161770 defendant Sturman John husbandman 587386 587386 Sturman, John, of Sparham, husbandman 0
4391505 2161770 2161770 defendant Norton George husbandman 587386 587386 Norton, George, of Sparham, husbandman 2
4395816 2163182 2163182 defendant Thetford Christopher gent 587386 587386 Thetford, Christopher, of Sparham, gent 2
4402941 2165569 2165569 defendant Blakeny Lancelot gent 587386 587386 Blakeny, Lancelot, of of Sparham, gent 2
4406899 2166872 2166872 defendant Taylor Robert gent 587386 587386 Taylor, Robert, of Sparham, gent 0
4407430 2167047 2167047 defendant Goodwyn James yeoman 587386 587386 Goodwyn, James, of Sparham, yeoman 2
4412621 2168810 2168810 defendant Blackeney Charles gent 587386 587386 Blackeney, Charles, of Sparham, gent 2
4549512 2215793 2215793 defendant Elyot William   587386 587386 Elyot, William, of Sparham 0
4575214 2223768 2223768 defendant Cok John   587386 587386 Cok, John, of Sparham 1
4577008 2224318 2224318 defendant Colyn John   587386 587386 Colyn, John, of Sparham 2
4585076 2226754 2226754 defendant Crok Adam   587386 587386 Crok, Adam, of Sparham 0
4607423 2233430 2233430 defendant Colyns John   587386 587386 Colyns, John, of Sparham, wright 3
4636853 2242342 2242342 defendant Colyns John   587386 587386 Colyns, John, of Sparham 4
4686793 2261480 2261480 defendant Sparham William gent 587386 587386 Sparham, William, of Sparham, gent 0
4688204 2261877 2261877 defendant Cope John husbandman 587386 587386 Cope, John, of Sparham, husbandman 5
4706540 2267424 2267424 defendant Mariot Nicholas tailor 587386 587386 Mariot, Nicholas, of Sparham, tailor 2
4712748 2269300 2269300 defendant Sparham William   587386 587386 Sparham, William, of Sparham, franklin 0
4735254 2276173 2276173 defendant Sparham William   587386 587386 Sparham, William, of Sparham, franklin 0
4762592 2284279 2284279 defendant Brancastre John husbandman 587386 587386 Brancastre, John, of Sparham, husbandman 1
4817733 2301632 2301632 defendant Poye Thomas   587386 587386 Poye, Thomas, of Sparham, parson 0
4817812 2301655 2301655 defendant Burdeux John   587386 587386 Burdeux, John, of Sparham, parson 2

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