names

85 rows where place_id = 590368

✎ 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
3600979 1867971 1867971 plaintiff Brynkeley Richard yeoman 590368 590368 Brynkeley, Richard, of Newarke, yeoman 0
3606208 1869611 1869611 plaintiff Meryng Thomas esq 590368 590368 Meryng, Thomas, of Newarke, esq 0
3710988 1929750 1929750 defendant Penythorne William mercer 590368 590368 Penythorne, William, of Newarke, mercer 4
3710996 1929751 1929751 defendant Penythorne William mercer 590368 590368 Penythorne, William, of Newarke, mercer 4
3721057 1932881 1932881 defendant Baylye Richard laborer 590368 590368 Baylye, Richard, of Newarke, laborer 0
3721058 1932881 1932881 defendant Toller Thomas laborer 590368 590368 Toller, Thomas, of Newarke, laborer 1
3729138 1935362 1935362 defendant Lucas Richard gent 590368 590368 Lucas, Richard, of Newarke, gent 0
3730734 1935840 1935840 defendant Atkynson Ralph butcher 590368 590368 Atkynson, Ralph, of Newarke, butcher 0
3730735 1935840 1935840 defendant Utwhyt William butcher 590368 590368 Utwhyt, William, of Newarke, butcher 1
3733120 1936586 1936586 defendant Hotwyth alias Hothwett William butcher 590368 590368 Hotwyth alias Hothwett, William, of Newarke, butcher 0
3734303 1936965 1936965 defendant Hadcok John husbandman 590368 590368 Hadcok, John, of Newarke, husbandman 2
3737050 1937827 1937827 defendant Fletcher Henry   590368 590368 Fletcher, Henry, of Newarke 1
3737291 1937900 1937900 defendant Sylversedo Richard butcher 590368 590368 Sylversedo, Richard, of Newarke, butcher 0
3738204 1938162 1938162 defendant Cade Elizabeth widow 590368 590368 Cade, Elizabeth, of Newarke, widow 0
3756823 1944107 1944107 defendant Bradshawe Richard   590368 590368 Bradshawe, Richard, of Newarke, cook 0
3756901 1944134 1944134 defendant Came Henry gent 590368 590368 Came, Henry, of Newarke, gent 1
3756902 1944134 1944134 defendant Castell Henry clerk 590368 590368 Castell, Henry, of Newarke, clerk 2
3780195 1951531 1951531 plaintiff Frysby Thomas   590368 590368 Frysby, Thomas, of Newarke 0
3783266 1952518 1952518 defendant Atkynson Ralph butcher 590368 590368 Atkynson, Ralph, of Newarke, butcher 0
3795141 1956345 1956345 defendant Jakson Robert yeoman 590368 590368 Jakson, Robert, of Newarke, yeoman 0
3796651 1956831 1956831 defendant Frysby Thomas mercer 590368 590368 Frysby, Thomas, of Newarke, mercer 0
3802080 1958546 1958546 defendant Spanyng John yeoman 590368 590368 Spanyng, John, of Newarke, yeoman 1
3809721 1960929 1960929 plaintiff Bevercottys Richard gent 590368 590368 Bevercottys, Richard, of Newarke, gent 0
3811618 1961531 1961531 plaintiff Chapman Thomas draper 590368 590368 Chapman, Thomas, of Newarke, draper 0
3814835 1962553 1962553 defendant Cooke Richard baker 590368 590368 Cooke, Richard, of Newarke, baker 0
3832029 1967915 1967915 defendant Lucas Richard gent 590368 590368 Lucas, Richard, of Newarke, gent 0
3836113 1969209 1969209 defendant Tyndale Thomas dyer 590368 590368 Tyndale, Thomas, of Newarke, dyer 0
3836939 1969458 1969458 defendant Tyndale Thomas dyer 590368 590368 Tyndale, Thomas, of Newarke, dyer 0
3837646 1969683 1969683 defendant Jakson Andrew chapman 590368 590368 Jakson, Andrew, of Newarke, chapman 0
3857280 1975912 1975912 defendant Canyot Nicholas cooper 590368 590368 Canyot, Nicholas, of Newarke, cooper 0
3857281 1975912 1975912 defendant Smyth Robert mercer 590368 590368 Smyth, Robert, of Newarke, mercer 1
3861664 1977359 1977359 defendant Cooke Richard baker 590368 590368 Cooke, Richard, of Newarke, baker 0
3861665 1977359 1977359 defendant Pye Roland baker 590368 590368 Pye, Roland, of Newarke, baker 1
3888518 1986416 1986416 defendant Lyng Richard mercer 590368 590368 Lyng, Richard, of Newarke, mercer 0
3889992 1986888 1986888 defendant Cressy Barnard innholder 590368 590368 Cressy, Barnard, of Newarke, innholder 0
3890482 1987073 1987073 defendant Bolton Elias butcher 590368 590368 Bolton, Elias, of Newarke, butcher 0
3891828 1987518 1987518 plaintiff Lucas Richard gent 590368 590368 Lucas, Richard, of Newarke, gent 0
3891830 1987519 1987519 plaintiff Lucas Richard gent 590368 590368 Lucas, Richard, of Newarke, gent 0
3902590 1991097 1991097 defendant Lemyng Richard mercer 590368 590368 Lemyng, Richard, of Newarke, mercer 0
3918470 1996506 1996506 defendant Batheley Roger husbandman 590368 590368 Batheley, Roger, of Newarke, husbandman 1
3924963 1998666 1998666 defendant Batenson John innholder 590368 590368 Batenson, John, of Newarke, innholder 0
3942954 2004649 2004649 defendant Verdon Thomas tanner 590368 590368 Verdon, Thomas, of Newarke, tanner 1
3944611 2005212 2005212 plaintiff Baxter Robert   590368 590368 Baxter, Robert, of Newarke, medical doctor 0
3944613 2005212 2005212 defendant Harryson Roger roper 590368 590368 Harryson, Roger, of Newarke, roper 1
3951896 2007726 2007726 plaintiff Harreson William (legal representative) 590368 590368 Harreson, William, of Newarke, executors of 0
3957395 2009651 2009651 plaintiff Phyllipott William (legal representative) 590368 590368 Phyllipott, William, of Newarke, merchant, executors of 0
3968283 2013536 2013536 plaintiff Chapman Mathew baker 590368 590368 Chapman, Mathew, of Newarke, baker 0
3968284 2013536 2013536 plaintiff Spurr William baker 590368 590368 Spurr, William, of Newarke, baker 1
3968286 2013537 2013537 plaintiff Chapman Mathew baker 590368 590368 Chapman, Mathew, of Newarke, baker 0
3968287 2013537 2013537 plaintiff Spurr William baker 590368 590368 Spurr, William, of Newarke, baker 1
3972032 2014774 2014774 defendant Spurre William baker 590368 590368 Spurre, William, of Newarke, baker 1
3976374 2016311 2016311 plaintiff Kelsterne Edward alderman 590368 590368 Kelsterne, Edward, of Newarke, alderman 0
3976376 2016312 2016312 plaintiff Kelsterne Edward draper 590368 590368 Kelsterne, Edward, of Newarke, draper 0
3976533 2016367 2016367 plaintiff Stowe Peter   590368 590368 Stowe, Peter, of Newarke 1
3977384 2016660 2016660 plaintiff Leverton John mercer 590368 590368 Leverton, John, of Newarke, mercer 0
3983732 2018954 2018954 plaintiff Stanley William draper 590368 590368 Stanley, William, of Newarke, draper 0
3983734 2018955 2018955 plaintiff Stanley William draper 590368 590368 Stanley, William, of Newarke, draper 0
3991257 2021636 2021636 plaintiff Bradshawe Bartholomew yeoman 590368 590368 Bradshawe, Bartholomew, of Newarke, yeoman 0
4001856 2025438 2025438 plaintiff Harryson William vintner 590368 590368 Harryson, William, of Newarke, vintner 0
4044606 2040523 2040523 plaintiff Reyner John gent 590368 590368 Reyner, John, of Newarke, gent 0
4044814 2040597 2040597 defendant Laywerton or Lewerton John mercer 590368 590368 Laywerton or Lewerton, John, of Newarke, mercer 0
4044818 2040598 2040598 defendant Laywerton or Lewerton John mercer 590368 590368 Laywerton or Lewerton, John, of Newarke, mercer 0
4068577 2049048 2049048 defendant Heryng John   590368 590368 Heryng, John, of Newarke, Lincs chapman 2
4156905 2080493 2080493 defendant Newcombe Augustine yeoman 590368 590368 Newcombe, Augustine, of Newarke, yeoman 2
4362821 2151763 2151763 defendant Mason John blacksmith 590368 590368 Mason, John, of Newarke, blacksmith 0
4369695 2154218 2154218 defendant Idle Roger glover 590368 590368 Idle, Roger, of Newarke, glover 0
4406326 2166682 2166682 defendant Goddard Nicholas blacksmith 590368 590368 Goddard, Nicholas, of Newarke, blacksmith 0
4644378 2244448 2244448 defendant Tornor John tailor 590368 590368 Tornor, John, of Newarke, tailor 0
4870174 2317639 2317639 plaintiff Louthe Ralph   590368 590368 Louthe, Ralph, of Newarke 0
5016554 2361736 2361736 defendant Staley Richard yeoman 590368 590368 Staley, Richard, of Newarke, yeoman 1
5018966 2362438 2362438 defendant Rynghell John chapman 590368 590368 Rynghell, John, of Newarke, chapman 3
5019051 2362463 2362463 defendant Rynghell John chapman 590368 590368 Rynghell, John, of Newarke, chapman 3
5203786 2416858 2416858 plaintiff Herte Robert   590368 590368 Herte, Robert, of Newarke 2
5203790 2416859 2416859 plaintiff Herte Robert   590368 590368 Herte, Robert, of Newarke 2
5350769 2460351 2460351 plaintiff Cotys Richard merchant 590368 590368 Cotys, Richard, of Newarke, merchant 0
5501559 2505419 2505419 defendant Calcrofte John (legal representative) 590368 590368 Calcrofte, John, of Newarke, merchant, executor of 0
5536212 2515821 2515821 defendant Crokys Richard yeoman 590368 590368 Crokys, Richard, of Newarke, yeoman 0
5536213 2515821 2515821 defendant Came or Caine Henry yeoman 590368 590368 Came or Caine, Henry, of Newarke, yeoman 1
5536214 2515821 2515821 defendant Clerke Richard draper 590368 590368 Clerke, Richard, of Newarke, draper 2
5536215 2515821 2515821 defendant Emrose Richard yeoman 590368 590368 Emrose, Richard, of Newarke, yeoman 3
5545628 2518708 2518708 defendant Johnson Henry innholder 590368 590368 Johnson, Henry, of Newarke, innholder 0
5545630 2518709 2518709 defendant Johnson Henry innholder 590368 590368 Johnson, Henry, of Newarke, innholder 0
5545632 2518710 2518710 defendant Keyser George gent 590368 590368 Keyser, George, of Newarke, gent 0
5545633 2518710 2518710 defendant Fauconer Richard draper 590368 590368 Fauconer, Richard, of Newarke, draper 1
5577781 2528120 2528120 defendant Harde William yeoman 590368 590368 Harde, William, of Newarke, yeoman 0

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