names

84 rows where place_id = 627268

✎ 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
3775241 1949991 1949991 defendant Pullayn Agnes widow 627268 627268 Pullayn, Agnes, of Lowthe, widow 0
3816069 1962928 1962928 defendant Thomson Alexander cordwainer 627268 627268 Thomson, Alexander, of Lowthe, cordwainer 0
3828229 1966699 1966699 defendant Siston John   627268 627268 Siston, John, of Lowthe, freemason 0
3830131 1967323 1967323 plaintiff Etton John esq 627268 627268 Etton, John, of Lowthe, esq 0
3859457 1976652 1976652 plaintiff Asseby William mercer 627268 627268 Asseby, William, of Lowthe, mercer 1
3859458 1976652 1976652 plaintiff Spencer Robert draper 627268 627268 Spencer, Robert, of Lowthe, draper 2
3859459 1976652 1976652 plaintiff Spencer Thomas draper 627268 627268 Spencer, Thomas, of Lowthe, draper 3
3859460 1976652 1976652 plaintiff Beverlaye Richard mercer 627268 627268 Beverlaye, Richard, of Lowthe, mercer 4
3872247 1980942 1980942 defendant Clatercote Richard butcher 627268 627268 Clatercote, Richard, of Lowthe, butcher 3
3878801 1983160 1983160 defendant Proctor William weaver 627268 627268 Proctor, William, of Lowthe, weaver 0
3878802 1983160 1983160 defendant Akered Robert   627268 627268 Akered, Robert, of Lowthe, card maker 1
3883634 1984795 1984795 defendant Syll Richard smith 627268 627268 Syll, Richard, of Lowthe, smith 1
3899189 1989934 1989934 defendant Elwold Anne   627268 627268 Elwold, Anne, of Lowthe, "votissa" 0
3915827 1995673 1995673 plaintiff Doughtie Robert gent 627268 627268 Doughtie, Robert, of Lowthe, gent 0
3915846 1995678 1995678 plaintiff Doughtye Robert gent 627268 627268 Doughtye, Robert, of Lowthe, gent 0
3936206 2002434 2002434 defendant Spencer Robert draper 627268 627268 Spencer, Robert, of Lowthe, draper 0
3970241 2014190 2014190 defendant Blansherd Gilbert mercer 627268 627268 Blansherd, Gilbert, of Lowthe, mercer 0
3973987 2015472 2015472 defendant Odlyn Robert joiner 627268 627268 Odlyn, Robert, of Lowthe, joiner 0
3984326 2019157 2019157 defendant Barnard William yeoman 627268 627268 Barnard, William, of Lowthe, yeoman 1
3984335 2019160 2019160 plaintiff Symcott William gent 627268 627268 Symcott, William, of Lowthe, gent 0
4012611 2029234 2029234 defendant Holdernes Richard merchant of the staple 627268 627268 Holdernes, Richard, of Lowthe, merchant of the staple 0
4016971 2030772 2030772 plaintiff Symon William gent 627268 627268 Symon, William, of Lowthe, gent 0
4019967 2031869 2031869 defendant Ormesby William gent 627268 627268 Ormesby, William, of Lowthe, gent 0
4077963 2052421 2052421 defendant Collingwood George weaver 627268 627268 Collingwood, George, of Lowthe, weaver 0
4079635 2053016 2053016 defendant Denyson Edward tanner 627268 627268 Denyson, Edward, of Lowthe, tanner 0
4112115 2064590 2064590 defendant Dover Robert yeoman 627268 627268 Dover, Robert, of Lowthe, yeoman 0
4114140 2065338 2065338 defendant Stubbes Ralph yeoman 627268 627268 Stubbes, Ralph, of Lowthe, yeoman 1
4124356 2069004 2069004 defendant Osborne Richard yeoman 627268 627268 Osborne, Richard, of Lowthe, yeoman 0
4135111 2072875 2072875 defendant Jones John gent 627268 627268 Jones, John, of Lowthe, gent 3
4169186 2084724 2084724 defendant Wood alias Doffe Thomas tailor 627268 627268 Wood alias Doffe, Thomas, of Lowthe, tailor 0
4170147 2085052 2085052 defendant Fysher William yeoman 627268 627268 Fysher, William, of Lowthe, yeoman 0
4170149 2085053 2085053 defendant Pelson Richard clerk 627268 627268 Pelson, Richard, of Lowthe, clerk 0
4172890 2085971 2085971 defendant Ormesbe William   627268 627268 Ormesbe, William, of Lowthe, gent, administrators of 0
4172892 2085971 2085971 defendant Ormesbe Isabel widow 627268 627268 Ormesbe, Isabel, of Lowthe, widow 2
4172894 2085972 2085972 defendant Ormsbe William   627268 627268 Ormsbe, William, of Lowthe, gent, administrators of 0
4172896 2085972 2085972 defendant Ormsbe Isabel widow 627268 627268 Ormsbe, Isabel, of Lowthe, widow 2
4183595 2089748 2089748 defendant Calthorpe Thomas yeoman 627268 627268 Calthorpe, Thomas, of Lowthe, yeoman 0
4183703 2089787 2089787 defendant Glaceboroughe Edward weaver 627268 627268 Glaceboroughe, Edward, of Lowthe, weaver 1
4183707 2089788 2089788 defendant Glaceboroughe Edward weaver 627268 627268 Glaceboroughe, Edward, of Lowthe, weaver 1
4184725 2090165 2090165 defendant Fisher William yeoman 627268 627268 Fisher, William, of Lowthe, yeoman 0
4184727 2090166 2090166 defendant Fysher William yeoman 627268 627268 Fysher, William, of Lowthe, yeoman 0
4185160 2090315 2090315 defendant Drystrawe alias Dryster John yeoman 627268 627268 Drystrawe alias Dryster, John, of Lowthe, yeoman 2
4185201 2090331 2090331 defendant White George yeoman 627268 627268 White, George, of Lowthe, yeoman 0
4185887 2090558 2090558 defendant Holland William yeoman 627268 627268 Holland, William, of Lowthe, yeoman 5
4185903 2090562 2090562 defendant Holland William yeoman 627268 627268 Holland, William, of Lowthe, yeoman 4
4186830 2090879 2090879 defendant Drystrawe alias Dryster John yeoman 627268 627268 Drystrawe alias Dryster, John, of Lowthe, yeoman 2
4187921 2091274 2091274 defendant Douse or Donse Thomas tailor 627268 627268 Douse or Donse, Thomas, of Lowthe, tailor 0
4189025 2091647 2091647 defendant Woode Thomas vintner 627268 627268 Woode, Thomas, of Lowthe, vintner 0
4189026 2091647 2091647 defendant Dykes Robert mercer 627268 627268 Dykes, Robert, of Lowthe, mercer 1
4190779 2092337 2092337 defendant Nicolles John yeoman 627268 627268 Nicolles, John, of Lowthe, yeoman 0
4207826 2098294 2098294 defendant White Lawrence yeoman 627268 627268 White, Lawrence, of Lowthe, yeoman 0
4209757 2098969 2098969 defendant Jackeson William carpenter 627268 627268 Jackeson, William, of Lowthe, carpenter 0
4213617 2100284 2100284 defendant White Lawrence yeoman 627268 627268 White, Lawrence, of Lowthe, yeoman 0
4230025 2105991 2105991 defendant Cooke Robert yeoman 627268 627268 Cooke, Robert, of Lowthe, yeoman 0
4236107 2108198 2108198 defendant Watson Alexander yeoman 627268 627268 Watson, Alexander, of Lowthe, yeoman 0
4236183 2108224 2108224 defendant Tayler Richard butcher 627268 627268 Tayler, Richard, of Lowthe, butcher 0
4236235 2108243 2108243 defendant Whittington Elizabeth widow 627268 627268 Whittington, Elizabeth, of Lowthe, widow 1
4237676 2108772 2108772 defendant Martindale William butcher 627268 627268 Martindale, William, of Lowthe, butcher 0
4264241 2117688 2117688 defendant Wright Richard yeoman 627268 627268 Wright, Richard, of Lowthe, yeoman 1
4264243 2117688 2117688 defendant Maberley Lawrence laborer 627268 627268 Maberley, Lawrence, of Lowthe, laborer 3
4272339 2120322 2120322 defendant Bucke John draper 627268 627268 Bucke, John, of Lowthe, draper 0
4274350 2120975 2120975 defendant Ogarde Andrew gent 627268 627268 Ogarde, Andrew, of Lowthe, or of Leckborne, gent 1
4274358 2120976 2120976 defendant Kennythorpe Oliver butcher 627268 627268 (Kennythorpe, Oliver, of Lowthe, butcher 4
4281318 2123372 2123372 defendant Kennethorpe Oliver yeoman 627268 627268 Kennethorpe, Oliver, of Lowthe, or of Great Carlton, yeoman 0
4281351 2123383 2123383 defendant Plumtree Christopher yeoman 627268 627268 Plumtree, Christopher, of Lowthe, yeoman 0
4284892 2124645 2124645 defendant Heneage George gent 627268 627268 Heneage, George, of Lowthe, or of Bennyngworthe, gent 0
4284901 2124648 2124648 defendant Heneage George gent 627268 627268 Heneage, George, of Lowthe, or of Benningworthe, gent 0
4297193 2129098 2129098 defendant Bollys Richard, junior gent 627268 627268 Bollys, Richard, junior, of Lowthe, or of Thorpe Hall, gent 0
4304569 2131735 2131735 defendant Sowthwell Richard, senior esq 627268 627268 Sowthwell, Richard, senior, of Lowthe, or of St Faithes, Norf, esq 0
4335216 2142053 2142053 defendant Eidson or Gidson Christopher laborer 627268 627268 Eidson or Gidson, Christopher, of Lowthe, laborer 1
4335217 2142053 2142053 defendant Bostocke James laborer 627268 627268 Bostocke, James, of Lowthe, laborer 2
4348661 2146789 2146789 defendant White Lawrence innholder 627268 627268 White, Lawrence, of Lowthe, innholder 0
4354207 2148701 2148701 defendant Browne Thomas shoemaker 627268 627268 Browne, Thomas, of Lowthe, shoemaker 0
4364393 2152323 2152323 defendant Shepheelde Gregory hatter 627268 627268 Shepheelde, Gregory, of Lowthe, hatter 0
4365894 2152839 2152839 defendant Mickelborowe Leonard gent 627268 627268 Mickelborowe, Leonard, of Lowthe, gent 0
4372696 2155312 2155312 defendant Ellise Thomas glover 627268 627268 Ellise, Thomas, of Lowthe, glover 2
4382275 2158771 2158771 defendant Warde Ralph alebrewer 627268 627268 Warde, Ralph, of Lowthe, alebrewer 0
4382842 2158966 2158966 defendant Jones Henry yeoman 627268 627268 Jones, Henry, of Lowthe, yeoman 3
4590588 2228415 2228415 plaintiff Markeby William brasier 627268 627268 Markeby, William, of Lowthe, brasier 0
4621792 2237800 2237800 defendant Flete John   627268 627268 Flete, John, of Lowthe 0
4660932 2249245 2249245 defendant de Aumery Robert saddler 627268 627268 de Aumery, Robert, of Lowthe, saddler 0
5519598 2510963 2510963 plaintiff Beverle Thomas chapman 627268 627268 Beverle, Thomas, of Lowthe, chapman 0
5558449 2522417 2522417 defendant Smyth Robert yeoman 627268 627268 Smyth, Robert, of Lowthe, yeoman 0
5558450 2522417 2522417 defendant Bele William tailor 627268 627268 Bele, William, of Lowthe, tailor 1

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