names

101 rows where place_id = 780607

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4668770 2255942 2255942 defendant Plestrete Thomas draper 780607 780607 Plestrete, Thomas, of Nottingham, Notts, draper 0
4669539 2256179 2256179 defendant Appulby Robert   780607 780607 Appulby, Robert, of Nottingham, Notts, wright 0
4670060 2256339 2256339 defendant Danyell John, junior husbandman 780607 780607 Danyell, John, junior, of Nottingham, Notts, husbandman 0
4670063 2256340 2256340 defendant Danyell John, junior husbandman 780607 780607 Danyell, John, junior, of Nottingham, Notts, husbandman 0
4672035 2256902 2256902 defendant Ettewell John merchant 780607 780607 Ettewell, John, of Nottingham, Notts, merchant 0
4676673 2258321 2258321 defendant Doram John mercer 780607 780607 Doram, John, of Nottingham, Notts, mercer 2
4684487 2260751 2260751 defendant Hunt Roger yeoman 780607 780607 Hunt, Roger, of Nottingham, Notts, yeoman 0
4688416 2261944 2261944 defendant Lamley Gilbert ironmonger & yeoman 780607 780607 Lamley, Gilbert, of Nottingham, Notts, ironmonger & yeoman 0
4690137 2262471 2262471 defendant Lynby Hugh merchant 780607 780607 Lynby, Hugh, of Nottingham, Notts, merchant 0
4701393 2265838 2265838 defendant Hunt Roger mercer 780607 780607 Hunt, Roger, of Nottingham, Notts, mercer 1
4701615 2265898 2265898 defendant Danyell John, sen butcher 780607 780607 Danyell, John, sen, of Nottingham, Notts, butcher 4
4704746 2266863 2266863 defendant Cresse Hugh esq 780607 780607 Cresse, Hugh, of Nottingham, Notts, esq 2
4707961 2267860 2267860 defendant Sherman Richard sherman 780607 780607 Sherman, Richard, of Nottingham, Notts, sherman 0
4710682 2268699 2268699 defendant Hunt Roger chapman 780607 780607 Hunt, Roger, of Nottingham, Notts, chapman 1
4711107 2268828 2268828 defendant Selston Richard yeoman 780607 780607 Selston, Richard, of Nottingham, Notts, yeoman 0
4717213 2270713 2270713 defendant Bercroft Robert merchant 780607 780607 Bercroft, Robert, of Nottingham, Notts, merchant 0
4717217 2270714 2270714 defendant Bercroft Robert merchant 780607 780607 Bercroft, Robert, of Nottingham, Notts, merchant 0
4717221 2270715 2270715 defendant Bercroft Robert merchant 780607 780607 Bercroft, Robert, of Nottingham, Notts, merchant 0
4719485 2271437 2271437 defendant Thrympton Robert skinner 780607 780607 Thrympton, Robert, of Nottingham, Notts, skinner 0
4719938 2271581 2271581 defendant Hewere John chandler 780607 780607 Hewere, John, of Nottingham, Notts, chandler 2
4722329 2272307 2272307 defendant Loseland John chaplain 780607 780607 Loseland, John, of Nottingham, Notts, chaplain 3
4740807 2277828 2277828 defendant Heuster John heuster or dyer 780607 780607 Heuster, John, of Nottingham, Notts, heuster or dyer 2
4742757 2278387 2278387 defendant Manchestre John gent 780607 780607 Manchestre, John, of Nottingham, Notts, gent 0
4742759 2278388 2278388 defendant Manchestre John gent 780607 780607 Manchestre, John, of Nottingham, Notts, gent 0
4746859 2279583 2279583 defendant Mapurley John clerk 780607 780607 Mapurley, John, of Nottingham, Notts, clerk 2
4759395 2283280 2283280 defendant Rothywod Thomas merchant 780607 780607 Rothywod, Thomas, of Nottingham, Notts, merchant 1
4764341 2284843 2284843 defendant Samon John mercer 780607 780607 Samon, John, of Nottingham, Notts, mercer 2
4764664 2284935 2284935 defendant Holflete Lambert merchant 780607 780607 Holflete, Lambert, of Nottingham, Notts, merchant 0
4770216 2286658 2286658 defendant Hunt Roger mercer 780607 780607 Hunt, Roger, of Nottingham, Notts, mercer 0
4805064 2297786 2297786 defendant Belyetter Richard belyetter or bell founder 780607 780607 Belyetter, Richard, of Nottingham, Notts, belyetter or bell founder 0
4808864 2298940 2298940 defendant Kneneton Geoffrey gent 780607 780607 Kneneton, Geoffrey, of Nottingham, Notts, gent 1
4809024 2298998 2298998 defendant Pever or Penre John yeoman 780607 780607 Pever or Penre, John, of Nottingham, Notts, yeoman 1
4809191 2299050 2299050 defendant Blakeburne John dyer 780607 780607 Blakeburne, John, of Nottingham, Notts, dyer 3
4810258 2299353 2299353 defendant Trover John yeoman 780607 780607 Trover, John, of Nottingham, Notts, yeoman 0
4815508 2300955 2300955 defendant Ilkeston Simon chapman 780607 780607 Ilkeston, Simon, of Nottingham, Notts, chapman 2
4816463 2301239 2301239 defendant Colston William tanner 780607 780607 Colston, William, of Nottingham, Notts, tanner 0
4816512 2301256 2301256 defendant Colston William baker 780607 780607 Colston, William, of Nottingham, Notts, baker 0
4820225 2302396 2302396 defendant Bony or Bovy Richard chapman 780607 780607 Bony or Bovy, Richard, of Nottingham, Notts, chapman 1
4820306 2302421 2302421 defendant Hunt Richard carrier 780607 780607 Hunt, Richard, of Nottingham, Notts, carrier 1
4821418 2302782 2302782 defendant Wilburham John draper 780607 780607 Wilburham, John, of Nottingham, Notts, draper 2
4827288 2304582 2304582 defendant Osteler alias Skeldynghop John ostler 780607 780607 Osteler alias Skeldynghop, John, of Nottingham, Notts, ostler 6
4827294 2304583 2304583 defendant Osteler alias Skeldynghop John ostler 780607 780607 Osteler alias Skeldynghop, John, of Nottingham, Notts, ostler 4
4827361 2304604 2304604 defendant Ilkeston Simon mercer 780607 780607 Ilkeston, Simon, of Nottingham, Notts, mercer 0
4843768 2309572 2309572 defendant Denet William spicer 780607 780607 Denet, William, of Nottingham, Notts, spicer 0
4847083 2310589 2310589 defendant Wylford John gent 780607 780607 Wylford, John, of Nottingham, Notts, gent 0
4847086 2310590 2310590 defendant Wylford John gent 780607 780607 Wylford, John, of Nottingham, Notts, gent 0
4847089 2310591 2310591 defendant Wylfore John gent 780607 780607 Wylfore, John, of Nottingham, Notts, gent 0
4847987 2310848 2310848 defendant Preston John chapman 780607 780607 Preston, John, of Nottingham, Notts, chapman 0
4849797 2311408 2311408 defendant Calton Richard (legal representative) 780607 780607 Calton, Richard, of Nottingham, Notts, chapman, executors of 0
4853938 2312643 2312643 defendant Constable John farmer 780607 780607 Constable, John, of Nottingham, Notts, farmer 0
4853944 2312644 2312644 defendant Constabe John farmer 780607 780607 Constabe, John, of Nottingham, Notts, farmer 0
4910502 2329797 2329797 plaintiff Alestre Thomas merchant 780607 780607 Alestre, Thomas, of Nottingham, Notts, merchant 2
4912655 2330462 2330462 defendant Lymby Henry gent & clerk of the King's Treasury or Exchequer 780607 780607 Lymby, Henry, of Nottingham, Notts, gent & clerk of the King's Treasury or Exchequer 0
4917150 2331871 2331871 defendant Wilbram John draper 780607 780607 Wilbram, John, of Nottingham, Notts, draper 2
4918165 2332202 2332202 defendant Bercrofte Robert merchant 780607 780607 Bercrofte, Robert, of Nottingham, Notts, merchant 1
4920970 2333071 2333071 defendant Ewere Joan widow 780607 780607 Ewere, Joan, of Nottingham, Notts, widow 2
4920975 2333072 2333072 defendant Ewere Joan widow 780607 780607 Ewere, Joan, of Nottingham, Notts, widow 2
4920980 2333074 2333074 defendant Iremonger Thomas ironmonger 780607 780607 Iremonger, Thomas, of Nottingham, Notts, ironmonger 0
4924013 2333949 2333949 defendant Vynter Henry gent 780607 780607 Vynter, Henry, of Nottingham, Notts, gent 0
4925726 2334479 2334479 defendant Payntour Henry   780607 780607 Payntour, Henry, of Nottingham, Notts, "lodsymer" or lodefyner 0
4927263 2334965 2334965 defendant Wylbram John draper 780607 780607 Wylbram, John, of Nottingham, Notts, draper 0
4932131 2336445 2336445 defendant Wro John glover 780607 780607 Wro, John, of Nottingham, Notts, glover 1
4986517 2352895 2352895 defendant Bate John draper 780607 780607 Bate, John, of Nottingham, Notts, draper 2
4988886 2353628 2353628 defendant Dunstable John yeoman 780607 780607 Dunstable, John, of Nottingham, Notts, yeoman 1
4988959 2353637 2353637 defendant Dunstable John yeoman 780607 780607 Dunstable, John, of Nottingham, Notts, yeoman 1
4992176 2354552 2354552 defendant Asselyn Thomas tanner 780607 780607 Asselyn, Thomas, of Nottingham, Notts, tanner 0
5005691 2358561 2358561 defendant Chestrefeld Richard yeoman 780607 780607 Chestrefeld, Richard, of Nottingham, Notts, yeoman 0
5007676 2359143 2359143 defendant Pooge John gent 780607 780607 Pooge, John, of Nottingham, Notts, gent 1
5007914 2359203 2359203 defendant Mason John   780607 780607 Mason, John, of Nottingham, Notts, image maker 0
5008457 2359366 2359366 defendant Fossebrook John butcher 780607 780607 Fossebrook, John, of Nottingham, Notts, butcher 0
5154027 2402338 2402338 defendant Dirham Alice widow 780607 780607 Dirham, Alice, of Nottingham, Notts, widow 0
5154054 2402344 2402344 defendant Dirham Alice widow 780607 780607 Dirham, Alice, of Nottingham, Notts, widow 1
5154301 2402416 2402416 defendant Tomson William dyer 780607 780607 Tomson, William, of Nottingham, Notts, dyer 0
5159144 2403789 2403789 defendant Mason John painter 780607 780607 Mason, John, of Nottingham, Notts, painter 2
5169574 2406838 2406838 defendant Brynnesle John chapman 780607 780607 Brynnesle, John, of Nottingham, Notts, chapman 0
5171270 2407319 2407319 defendant Dirham Alice widow 780607 780607 Dirham, Alice, of Nottingham, Notts, widow 0
5174382 2408208 2408208 defendant Mason John painter 780607 780607 Mason, John, of Nottingham, Notts, painter 2
5174384 2408209 2408209 defendant Mason John painter 780607 780607 Mason, John, of Nottingham, Notts, painter 0
5189561 2412687 2412687 defendant Dyrham Alice widow 780607 780607 Dyrham, Alice, of Nottingham, Notts, widow 0
5193894 2413939 2413939 defendant Payntor John merchant 780607 780607 Payntor, John, of Nottingham, Notts, merchant 0
5193897 2413940 2413940 defendant Payntor John merchant 780607 780607 Payntor, John, of Nottingham, Notts, merchant 0
5193900 2413941 2413941 defendant Payntor John merchant 780607 780607 Payntor, John, of Nottingham, Notts, merchant 0
5195003 2414287 2414287 defendant Mason John painter 780607 780607 Mason, John, of Nottingham, Notts, painter 0
5198120 2415196 2415196 defendant Derham Alice   780607 780607 Derham, Alice, of Nottingham, Notts, widow, formerly wife of John Derham 3
5208447 2418197 2418197 defendant Payntor John merchant 780607 780607 Payntor, John, of Nottingham, Notts, merchant 0
5209051 2418378 2418378 defendant Mason John painter 780607 780607 Mason, John, of Nottingham, Notts, painter 0
5300733 2445182 2445182 defendant Fyssher Robert merchant 780607 780607 Fyssher, Robert, of Nottingham, Notts, merchant 1
5300752 2445187 2445187 defendant Fyssher William merchant of the Calais Staple 780607 780607 Fyssher, William, of Nottingham, Notts, merchant of the Calais Staple 0
5306439 2446913 2446913 defendant Miles Elizabeth widow 780607 780607 Miles, Elizabeth, of Nottingham, Notts, widow 2
5310572 2448197 2448197 defendant Folby Robert goldsmith 780607 780607 Folby, Robert, of Nottingham, Notts, goldsmith 0
5426046 2482744 2482744 defendant Ellershawe Henry yeoman 780607 780607 Ellershawe, Henry, of Nottingham, Notts, yeoman 0
5432846 2484791 2484791 defendant Holyngworthe John   780607 780607 Holyngworthe, John, of Nottingham, Notts, brass worker 1
5432849 2484792 2484792 defendant Selyok John braier 780607 780607 Selyok, John, of Nottingham, Notts, braier 0
5432851 2484793 2484793 defendant Tulle Robert baker 780607 780607 Tulle, Robert, of Nottingham, Notts, baker 0
5444295 2488199 2488199 defendant Ellershawe Henry yeoman 780607 780607 Ellershawe, Henry, of Nottingham, Notts, yeoman 0
5446934 2488977 2488977 defendant P_ke William chapman 780607 780607 P_ke, William, of Nottingham, Notts, chapman 1
5448829 2489542 2489542 defendant George William yeoman 780607 780607 George, William, of Nottingham, Notts, yeoman 3
5459489 2492750 2492750 defendant Peke William chapman 780607 780607 Peke, William, of Nottingham, Notts, chapman 1
5465885 2494714 2494714 defendant Pert John dyer 780607 780607 Pert, John, of Nottingham, Notts, dyer 0
5471234 2496334 2496334 defendant Peke William chapman 780607 780607 Peke, William, of Nottingham, Notts, 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);