names

109 rows where place_id = 663941

✎ 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
3970834 2014381 2014381 defendant White John fisher 663941 663941 White, John, of Spaldinge, fisher 4
4058850 2045560 2045560 defendant Hodgeson William sherman 663941 663941 Hodgeson, William, of Spaldinge, sherman 1
4058851 2045560 2045560 defendant Horner Richard laborer 663941 663941 Horner, Richard, of Spaldinge, laborer 2
4058852 2045560 2045560 defendant Proctor John laborer 663941 663941 Proctor, John, of Spaldinge, laborer 3
4073118 2050677 2050677 plaintiff Percye Thomas gent 663941 663941 Percye, Thomas, of Spaldinge, gent 0
4082599 2054083 2054083 defendant Whitlam Simon husbandman 663941 663941 Whitlam, Simon, of Spaldinge, husbandman 1
4120373 2067561 2067561 defendant Burton John yeoman 663941 663941 Burton, John, of Spaldinge, yeoman 0
4120374 2067561 2067561 defendant Whitworth Arthur laborer 663941 663941 Whitworth, Arthur, of Spaldinge, laborer 1
4125195 2069299 2069299 defendant Mawge John yeoman 663941 663941 Mawge, John, of Spaldinge, yeoman 0
4125197 2069299 2069299 defendant Byas Rober yeoman 663941 663941 Byas, Rober, of Spaldinge, yeoman 2
4142398 2075513 2075513 defendant Spencer Gilbert yeoman 663941 663941 Spencer, Gilbert, of Spaldinge, yeoman 1
4151580 2078672 2078672 defendant Crayle John yeoman 663941 663941 Crayle, John, of Spaldinge, yeoman 0
4152210 2078883 2078883 defendant Gilson John husbandman 663941 663941 Gilson, John, of Spaldinge, husbandman 0
4152211 2078883 2078883 defendant Harryson Hugh yeoman 663941 663941 Harryson, Hugh, of Spaldinge, yeoman 1
4168238 2084378 2084378 defendant Burton James laborer 663941 663941 Burton, James, of Spaldinge, laborer 3
4219194 2102210 2102210 defendant Preston John yeoman 663941 663941 Preston, John, of Spaldinge, yeoman 0
4230662 2106222 2106222 defendant Atkynson John yeoman 663941 663941 Atkynson, John, of Spaldinge, yeoman 0
4232810 2106982 2106982 defendant Kendall Richard tailor 663941 663941 Kendall, Richard, of Spaldinge, tailor 0
4234702 2107684 2107684 defendant Dawson Henry, senior yeoman 663941 663941 Dawson, Henry, senior, of Spaldinge, yeoman 0
4234705 2107685 2107685 defendant Beckitt Thomas yeoman 663941 663941 Beckitt, Thomas, of Spaldinge, yeoman 0
4234706 2107685 2107685 defendant Greyson John shoemaker 663941 663941 Greyson, John, of Spaldinge, shoemaker 1
4235431 2107960 2107960 defendant Browne William laborer 663941 663941 Browne, William, of Spaldinge, laborer 3
4235916 2108135 2108135 defendant Brymston Nicholas yeoman 663941 663941 Brymston, Nicholas, of Spaldinge, yeoman 0
4235970 2108155 2108155 defendant Beckitt Thomas yeoman 663941 663941 Beckitt, Thomas, of Spaldinge, or of Beverley, Yorks, yeoman 0
4235971 2108155 2108155 defendant Sneath William baker 663941 663941 Sneath, William, of Spaldinge, baker 1
4236720 2108416 2108416 defendant Gamlyn Mathew gent 663941 663941 Gamlyn, Mathew, of Spaldinge, gent 0
4237230 2108608 2108608 defendant Idon Nicholas yeoman 663941 663941 Idon, Nicholas, of Spaldinge, yeoman 0
4238020 2108903 2108903 defendant Whittell or Whitwell Richard yeoman 663941 663941 Whittell or Whitwell, Richard, of Spaldinge, yeoman 0
4238021 2108903 2108903 defendant Yarwell John yeoman 663941 663941 Yarwell, John, of Spaldinge, yeoman 1
4238022 2108903 2108903 defendant Idon Nicholas innholder 663941 663941 Idon, Nicholas, of Spaldinge, innholder 2
4238237 2108982 2108982 defendant Robinson Rpbert yeoman 663941 663941 Robinson, Rpbert, of Spaldinge, yeoman 0
4239474 2109431 2109431 defendant Atkinson John yeoman 663941 663941 Atkinson, John, of Spaldinge, yeoman 0
4241470 2110131 2110131 defendant Kendall Richard tailor 663941 663941 Kendall, Richard, of Spaldinge, tailor 0
4243263 2110739 2110739 defendant Beckitt Thomas yeoman 663941 663941 Beckitt, Thomas, of Spaldinge, yeoman 0
4243264 2110739 2110739 defendant Greyson John shoemaker 663941 663941 Greyson, John, of Spaldinge, shoemaker 1
4243268 2110740 2110740 defendant Beckitt Thomas yeoman 663941 663941 Beckitt, Thomas, of Spaldinge, yeoman 0
4243269 2110740 2110740 defendant Greyson John shoemaker 663941 663941 Greyson, John, of Spaldinge, shoemaker 1
4244066 2110997 2110997 defendant Browne William laborer 663941 663941 Browne, William, of Spaldinge, laborer 2
4244071 2110998 2110998 defendant Browne William laborer 663941 663941 Browne, William, of Spaldinge, laborer 2
4244569 2111167 2111167 defendant Beckitt Thomas yeoman 663941 663941 Beckitt, Thomas, of Spaldinge, or of Beverley, Yorks, yeoman 0
4244573 2111168 2111168 defendant Beckitt Thomas yeoman 663941 663941 Beckitt, Thomas, of Spaldinge, or of Beverley, yeoman 0
4252177 2113715 2113715 defendant Jackson John gent 663941 663941 Jackson, John, of Spaldinge, gent 1
4252180 2113716 2113716 defendant Jackson John gent 663941 663941 Jackson, John, of Spaldinge, gent 1
4253043 2114010 2114010 defendant Rigdon William esq 663941 663941 Rigdon, William, of Spaldinge, esq 2
4256050 2115004 2115004 defendant Johnson Nicholas vintner 663941 663941 Johnson, Nicholas, of Spaldinge, vintner 0
4262306 2117063 2117063 defendant Gamlyn Mathew gent 663941 663941 Gamlyn, Mathew, of Spaldinge, gent 0
4262505 2117124 2117124 defendant Gamlyn Mathew gent 663941 663941 Gamlyn, Mathew, of Spaldinge, gent 0
4264503 2117769 2117769 defendant Woodley Thomas painter 663941 663941 Woodley, Thomas, of Spaldinge, painter 0
4265922 2118240 2118240 defendant Jackson John gent 663941 663941 Jackson, John, of Spaldinge, gent 1
4265925 2118241 2118241 defendant Jackson John gent 663941 663941 Jackson, John, of Spaldinge, gent 1
4265928 2118242 2118242 defendant Jackson John gent 663941 663941 Jackson John, of Spaldinge, gent 1
4267523 2118772 2118772 defendant Johnson Nicholas vintner 663941 663941 Johnson, Nicholas, of Spaldinge, vintner 2
4273615 2120725 2120725 defendant Slater Henry laborer 663941 663941 Slater, Henry, of Spaldinge, laborer 3
4274497 2121027 2121027 defendant Wardw John barker 663941 663941 Wardw, John, of Spaldinge, barker 1
4274570 2121049 2121049 defendant Sneath William yeoman 663941 663941 Sneath, William, of Spaldinge, yeoman 0
4274571 2121049 2121049 defendant Woodes Robert baker 663941 663941 Woodes, Robert, of Spaldinge, baker 1
4275992 2121552 2121552 defendant Jackson John gent 663941 663941 Jackson, John, of Spaldinge, gent 0
4275993 2121552 2121552 defendant Hobson John yeoman 663941 663941 Hobson, John, of Spaldinge, yeoman 1
4276250 2121635 2121635 defendant Foxe Thomas husbandman 663941 663941 Foxe, Thomas, of Spaldinge, husbandman 0
4280253 2122998 2122998 defendant Preston John yeoman 663941 663941 Preston, John, of Spaldinge, yeoman 0
4280305 2123014 2123014 defendant Hickson Robert yeoman 663941 663941 Hickson, Robert, of Spaldinge, yeoman 0
4281809 2123542 2123542 defendant Warde John baker 663941 663941 Warde, John, of Spaldinge, baker 2
4289899 2126448 2126448 defendant Idon Nicholas innholder 663941 663941 Idon, Nicholas, of Spaldinge, innholder 0
4290469 2126651 2126651 defendant Palmer Thomas butcher 663941 663941 Palmer, Thomas, of Spaldinge, butcher 0
4292926 2127535 2127535 defendant Idon Nicholas mercer 663941 663941 Idon, Nicholas, of Spaldinge, innholder, mercer 0
4292927 2127535 2127535 defendant Percy Thomas (legal representative) 663941 663941 Percy, Thomas, of Spaldinge, gent, executors of 1
4292928 2127535 2127535 defendant Watson William esq 663941 663941 (Watson, William, of Spaldinge, esq 2
4293684 2127805 2127805 defendant Laughton or Lofton Thomas yeoman 663941 663941 Laughton or Lofton, Thomas, of Spaldinge, yeoman 0
4295347 2128422 2128422 defendant White Ralph cooper 663941 663941 White, Ralph, of Spaldinge, cooper 0
4295348 2128422 2128422 defendant Cooke Thomas waterman 663941 663941 Cooke, Thomas, of Spaldinge, waterman 1
4295743 2128568 2128568 defendant Laughton Thomas yeoman 663941 663941 Laughton, Thomas, of Spaldinge, yeoman 0
4296749 2128935 2128935 defendant Hye John chapman 663941 663941 Hye, John, of Spaldinge, mercer, or of Wisbiche, Cams, chapman 0
4297784 2129315 2129315 defendant Langton William yeoman 663941 663941 Langton, William, of Spaldinge, yeoman 1
4297785 2129315 2129315 defendant Harpley John yeoman 663941 663941 Harpley, John, of Spaldinge, yeoman 2
4298559 2129589 2129589 defendant Idon Nicholas innholder 663941 663941 Idon, Nicholas, of Spaldinge, innholder 0
4323146 2138156 2138156 defendant Jackson John   663941 663941 Jackson, John, of Spaldinge, Lincs gent 0
4336537 2142516 2142516 defendant Midleton John yeoman 663941 663941 Midleton, John, of Spaldinge, or of Swaton, yeoman 2
4337816 2142977 2142977 defendant Wright William baker 663941 663941 Wright, William, of Spaldinge, baker 0
4339381 2143542 2143542 defendant Geye Richard yeoman 663941 663941 Geye, Richard, of Spaldinge, yeoman 1
4340734 2144033 2144033 defendant Grayson John yeoman 663941 663941 Grayson, John, of Spaldinge, yeoman 0
4341995 2144479 2144479 defendant Hardwicke William yeoman 663941 663941 Hardwicke, William, of Spaldinge, yeoman 0
4345887 2145824 2145824 defendant Woodes John butcher 663941 663941 Woodes, John, of Spaldinge, butcher 0
4348175 2146609 2146609 defendant Snethe William husbandman 663941 663941 Snethe, William, of Spaldinge, husbandman 0
4350802 2147537 2147537 defendant Browne John butcher 663941 663941 Browne, John, of Spaldinge, butcher 0
4351322 2147713 2147713 defendant Whittwell Richard husbandman 663941 663941 Whittwell , Richard, of Spaldinge, husbandman 0
4352198 2148004 2148004 defendant Helcocke John fisherman 663941 663941 Helcocke, John, of Spaldinge, fisherman 1
4352928 2148251 2148251 defendant Toplyf Thomas miller 663941 663941 Toplyf, Thomas, of Spaldinge, miller 1
4352929 2148251 2148251 defendant Harrys Richard waterman 663941 663941 Harrys, Richard, of Spaldinge, waterman 2
4353851 2148567 2148567 defendant Smyth Edward yeoman 663941 663941 Smyth, Edward, of Spaldinge, yeoman 0
4357226 2149755 2149755 defendant Whitwell Francis yeoman 663941 663941 Whitwell, Francis, of Spaldinge, yeoman 0
4357228 2149756 2149756 defendant Whitwell Richard yeoman 663941 663941 Whitwell, Richard, of Spaldinge, yeoman 0
4357231 2149757 2149757 defendant Stickney Robert yeoman 663941 663941 Stickney, Robert, of Spaldinge, yeoman 1
4357232 2149757 2149757 defendant Kendall Richard tailor 663941 663941 Kendall, Richard, of Spaldinge, tailor 2
4361218 2151175 2151175 defendant Wright William baker 663941 663941 Wright, William, of Spaldinge, baker 0
4365411 2152694 2152694 defendant Middleton William gent 663941 663941 Middleton, William, of Spaldinge, gent 1
4365741 2152787 2152787 defendant Hardwicke William yeoman 663941 663941 Hardwicke, William, of Spaldinge, yeoman 0
4367097 2153288 2153288 defendant Scothroppe Mathew yeoman 663941 663941 Scothroppe, Mathew, of Spaldinge, yeoman 0
4370077 2154355 2154355 defendant Preston John yeoman 663941 663941 Preston, John, of Spaldinge, yeoman 0
4370078 2154355 2154355 defendant Whitwell Richard yeoman 663941 663941 Whitwell, Richard, of Spaldinge, yeoman 1
4371131 2154735 2154735 defendant Dickon Richard waterman 663941 663941 Dickon, Richard, of Spaldinge, waterman 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);