names

101 rows where place_id = 598218

✎ 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
3631606 1904700 1904700 defendant Hobson George husbandman 598218 598218 Hobson, George, of Stanley, husbandman 0
3685934 1921758 1921758 defendant Bradford Brian gent 598218 598218 Bradford, Brian, of Stanley, gent 0
3689993 1923029 1923029 defendant Bradford Brian gent 598218 598218 Bradford, Brian, of Stanley, gent 0
3811507 1961491 1961491 plaintiff Chaloner John (legal representative) 598218 598218 Chaloner, John, of Stanley, esq, administrator of 0
3872082 1980893 1980893 defendant Wylowys Thomas clothmaker 598218 598218 Wylowys, Thomas, of Stanley, clothmaker 0
3875904 1982194 1982194 defendant Weytley Richard, junior husbandman 598218 598218 Weytley, Richard, junior, of Stanley, husbandman 4
3897046 1989230 1989230 defendant Wilson Thomas yeoman 598218 598218 Wilson, Thomas,of Stanley, yeoman 0
3897358 1989332 1989332 defendant Brigges Robert husbandman 598218 598218 Brigges, Robert, of Stanley, husbandman 1
3966983 2013082 2013082 defendant Wylcock John clothier 598218 598218 Wylcock, John, of Stanley, clothier 0
4023701 2033183 2033183 defendant Calverley Walter esq 598218 598218 Calverley, Walter, of Stanley, esq 1
4054251 2043909 2043909 plaintiff Baker William tailor 598218 598218 Baker, William, of Stanley, tailor 0
4071890 2050247 2050247 defendant Moseley William husbandman 598218 598218 Moseley, William, of Stanley, husbandman 0
4071891 2050247 2050247 defendant Brygges Ralph husbandman 598218 598218 Brygges, Ralph, of Stanley, husbandman 1
4087172 2055702 2055702 defendant Tucker Henry husbandman 598218 598218 Tucker, Henry, of Stanley, or of Stalbrydge Weston, Dorset, husbandman 0
4111881 2064499 2064499 defendant Hyggens James yeoman 598218 598218 Hyggens, James, of Stanley, yeoman 1
4144870 2076366 2076366 defendant Powtrell Elizabeth widow 598218 598218 Powtrell, Elizabeth, of Stanley, widow 0
4144871 2076366 2076366 defendant Manyfolde Ralph husbandman 598218 598218 Manyfolde, Ralph, of Stanley, husbandman 1
4144872 2076366 2076366 defendant Hollingworthe William husbandman 598218 598218 Hollingworthe, William, of Stanley, husbandman 2
4144873 2076366 2076366 defendant Saunderson Robert husbandman 598218 598218 Saunderson, Robert, of Stanley, husbandman 3
4150002 2078135 2078135 defendant Gresbrooke Hugh yeoman 598218 598218 Gresbrooke, Hugh, of Stanley, yeoman 0
4163420 2082729 2082729 defendant Harmer Richard gent 598218 598218 Harmer, Richard, of Stanley, gent 0
4172967 2085997 2085997 defendant Batten John yeoman 598218 598218 Batten, John, of Stanley, yeoman 1
4223425 2103684 2103684 defendant Tofte Nicholas dyer 598218 598218 Tofte, Nicholas, of Stanley, dyer 0
4223427 2103684 2103684 defendant Tofte William husbandman 598218 598218 Tofte, William, of Stanley, husbandman 2
4292140 2127260 2127260 defendant Sugden Alan yeoman 598218 598218 Sugden, Alan, of Stanley, yeoman 0
4312274 2134428 2134428 defendant Fermhaughe William yeoman 598218 598218 Fermhaughe, William, of Stanley, yeoman 1
4326066 2139088 2139088 defendant Feringhaughe William yeoman 598218 598218 Feringhaughe, William, of Stanley, yeoman 2
4329888 2140296 2140296 defendant Myller Thomas miller 598218 598218 Myller, Thomas, of Stanley, miller 0
4329890 2140296 2140296 defendant Mollett William husbandman 598218 598218 Mollett, William, of Stanley, husbandman 2
4536593 2211723 2211723 defendant Dycher Edward welshman 598218 598218 Dycher, Edward, of Stanley, welshman 0
4604851 2232689 2232689 defendant Nicolas John   598218 598218 Nicolas, John, of Stanley 1
4618948 2236918 2236918 defendant Jay Thomas   598218 598218 Jay, Thomas, of Stanley 1
4634243 2241551 2241551 defendant Ellond Adam   598218 598218 Ellond, Adam, of Stanley 0
4634247 2241551 2241551 defendant Gibbes John   598218 598218 Gibbes, John, of Stanley 4
4674817 2257736 2257736 defendant Bune John husbandman 598218 598218 Bune, John, of Stanley, husbandman 2
4674818 2257736 2257736 defendant Gune Alice laborer 598218 598218 Gune, Alice, of Stanley, laborer 3
4674820 2257736 2257736 defendant Poket William husbandman 598218 598218 Poket, William, of Stanley, husbandman 5
4674821 2257736 2257736 defendant Tytyn-- John husbandman 598218 598218 Tytyn--, John, of Stanley, husbandman 6
4677761 2258663 2258663 defendant Erle Robert gent 598218 598218 Erle, Robert, of Stanley, gent 0
4691344 2262816 2262816 defendant Atkynson Robert husbandman 598218 598218 Atkynson, Robert, of Stanley, husbandman 0
4695743 2264151 2264151 defendant Strynger John collier 598218 598218 Strynger, John, of Stanley, collier 0
4708418 2267998 2267998 defendant Whitmay John tanner 598218 598218 Whitmay, John, of Stanley, tanner 0
4744922 2279029 2279029 defendant Hobson William husbandman 598218 598218 Hobson, William, of Stanley, husbandman 0
4744923 2279029 2279029 defendant Marsshal John husbandman 598218 598218 Marsshal, John, of Stanley, husbandman 1
4744924 2279029 2279029 defendant Felyp John husbandman 598218 598218 Felyp, John, of Stanley, husbandman 2
4744925 2279029 2279029 defendant Tityng John husbandman 598218 598218 Tityng, John, of Stanley, husbandman 3
4750943 2280759 2280759 defendant Persones Aukerus   598218 598218 Persones, Aukerus, of Stanley, mason 1
4754207 2281695 2281695 defendant Gunne Joan widow 598218 598218 Gunne, Joan, of Stanley, widow 0
4754208 2281695 2281695 defendant Gunne William husbandman 598218 598218 Gunne, William, of Stanley, husbandman 1
4754209 2281695 2281695 defendant Gunne John husbandman 598218 598218 Gunne, John, of Stanley, husbandman 2
4757454 2282707 2282707 defendant Abraham Robert husbandman 598218 598218 Abraham, Robert, of Stanley, husbandman 1
4787042 2292011 2292011 defendant Poket William husbandman 598218 598218 Poket, William, of Stanley, husbandman 1
4787043 2292011 2292011 defendant Philip John husbandman 598218 598218 Philip, John, of Stanley, husbandman 2
4787044 2292011 2292011 defendant Marsshall John husbandman 598218 598218 Marsshall, John, of Stanley, husbandman 3
4795062 2294600 2294600 defendant Mathewe Philip mercer 598218 598218 Mathewe, Philip, of Stanley, mercer 1
4795663 2294797 2294797 defendant Bremmour Thomas tanner 598218 598218 Bremmour, Thomas, of Stanley, tanner 0
4824832 2303804 2303804 plaintiff Tintern Thomas   598218 598218 Tintern, Thomas, of Stanley, abbot 0
4825982 2304159 2304159 defendant Bateman John husbandman 598218 598218 Bateman, John, of Stanley, husbandman 0
4834328 2306746 2306746 defendant Hankok Oliver husbandman 598218 598218 Hankok, Oliver, of Stanley, husbandman 1
4835102 2306979 2306979 defendant Crase Thomas husbandman 598218 598218 Crase, Thomas, of Stanley, husbandman 0
4840019 2308427 2308427 defendant Dune John husbandman 598218 598218 Dune, John, of Stanley, husbandman 2
4861350 2314918 2314918 defendant Hankok Oliver husbandman 598218 598218 Hankok, Oliver, of Stanley, husbandman 1
4904847 2328115 2328115 defendant Carlese Thomas yeoman 598218 598218 Carlese, Thomas, of Stanley, yeoman 0
4912260 2330334 2330334 defendant Norton Thomas yeoman 598218 598218 Norton, Thomas, of Stanley, yeoman 9
4917120 2331862 2331862 defendant Tintern Thomas   598218 598218 Tintern, Thomas, of Stanley, abbot of the monastery 0
4962235 2345607 2345607 defendant Barnet John chaplain 598218 598218 Barnet, John, of Stanley, chaplain 0
4980833 2351197 2351197 defendant Forthey John husbandman 598218 598218 Forthey, John, of Stanley, husbandman 0
4980835 2351198 2351198 defendant Forthey John husbandman 598218 598218 Forthey, John, of Stanley, husbandman 0
4980836 2351198 2351198 defendant Moreman John husbandman 598218 598218 Moreman, John, of Stanley, husbandman 1
5050022 2371627 2371627 defendant Yewcotes John yeoman 598218 598218 Yewcotes, John, of Stanley, yeoman 1
5050419 2371749 2371749 plaintiff Tintern Thomas   598218 598218 Tintern, Thomas, of Stanley, abbot of the monastery of the BM 0
5097634 2385734 2385734 defendant Polleyn Thomas esq 598218 598218 Polleyn, Thomas, of Stanley, gent, or of Wynchecombe, esq 1
5114748 2390727 2390727 plaintiff Marlar William   598218 598218 Marlar, William, of Stanley, or of Stodeley, gatekeeper or husbandman, executorsof 0
5119186 2392040 2392040 defendant Bunny John gent 598218 598218 Bunny, John, of Stanley, gent 0
5129716 2395180 2395180 defendant Ayglad Ralph   598218 598218 Ayglad, Ralph, of Stanley 1
5129733 2395182 2395182 defendant Hobson John yeoman 598218 598218 Hobson, John, of Stanley, yeoman 10
5140076 2398198 2398198 defendant Lestowe Benedict husbandman 598218 598218 Lestowe, Benedict, of Stanley, husbandman 0
5161101 2404346 2404346 defendant Lescow Benedict husbandman 598218 598218 Lescow, Benedict, of Stanley, husbandman 0
5197026 2414873 2414873 defendant Lostowe Benedict husbandman 598218 598218 Lostowe, Benedict, of Stanley, husbandman 0
5246477 2429133 2429133 defendant Hobson John chaplain 598218 598218 Hobson, John, of Stanley, chaplain 0
5266394 2435238 2435238 plaintiff Vardesans Thomas   598218 598218 Vardesans, Thomas, of Stanley 0
5279270 2439037 2439037 defendant Gaukethorp Richard   598218 598218 Gaukethorp, Richard, of Stanley, minstrel 0
5283964 2440336 2440336 defendant Halewell Hames husbandman 598218 598218 Halewell, Hames, of Stanley, husbandman 0
5314986 2449534 2449534 defendant Stevyns John husbandman 598218 598218 Stevyns, John, of Stanley, husbandman 0
5328943 2453735 2453735 defendant Kent Simon husbandman 598218 598218 Kent, Simon, of Stanley, husbandman 0
5342504 2457854 2457854 defendant Kent Simon husbandman 598218 598218 Kent, Simon, of Stanley, husbandman 0
5342506 2457855 2457855 defendant Kent Simon husbandman 598218 598218 Kent, Simon, of Stanley, husbandman 0
5343934 2458290 2458290 defendant Peion Richard husbandman 598218 598218 Peion, Richard, of Stanley, husbandman 1
5343935 2458290 2458290 defendant Smyth John husbandman 598218 598218 Smyth, John, of Stanley, husbandman 2
5343937 2458291 2458291 defendant Rose Nicholas husbandman 598218 598218 Rose, Nicholas, of Stanley, husbandman 0
5374714 2467688 2467688 defendant Bydyll John husbandman 598218 598218 Bydyll, John, of Stanley, husbandman 1
5417435 2480133 2480133 defendant Bedyll John husbandman 598218 598218 Bedyll, John, of Stanley, husbandman 0
5429441 2483739 2483739 defendant Knyght John husbandman 598218 598218 Knyght, John, of Stanley, husbandman 5
5446434 2488828 2488828 defendant K_ John husbandman 598218 598218 K_, John, of Stanley, husbandman 5
5469126 2495693 2495693 defendant Horton John   598218 598218 Horton, John, of Stanley, abbot 0
5469131 2495694 2495694 defendant Horton John   598218 598218 Horton, John, of Stanley, abbot of the monastery of the BM 0
5469136 2495695 2495695 defendant Horton John   598218 598218 Horton, John, of Stanley, abbot of the monastery of the BM 0
5582137 2529481 2529481 defendant Bunny Richard gent 598218 598218 Bunny, Richard, of Stanley, gent 1
5588091 2531288 2531288 defendant Merler Thomas yeoman 598218 598218 Merler, Thomas, of Stanley, yeoman 0
5624681 2551654 2551654 defendant Wallot Henry husbandman 598218 598218 Wallot, Henry, of Stanley, husbandman 9

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