names

203 rows where place_id = 596911

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626611 1903175 1903175 defendant Walker Thomas miller 596911 596911 Walker, Thomas, of Richmond, miller 0
3626616 1903176 1903176 defendant Walker Thomas miller 596911 596911 Walker, Thomas, of Richmond, miller 0
3626617 1903176 1903176 defendant Nellson William   596911 596911 Nellson, William, of Richmond, mustard maker 1
3657533 1912617 1912617 plaintiff Dalby Thomas clerk & arch deacon 596911 596911 Dalby, Thomas, of Richmond, clerk & arch deacon 0
3657537 1912618 1912618 plaintiff (not given) Thomas prior of Dalby 596911 596911 Dalby, Thomas, of Richmond, clerk & arch deacon & prior of the Collegiate church of St John, Beverley 0
3659269 1913154 1913154 defendant Ewbanke John yeoman 596911 596911 Ewbanke, John, of Richmond, yeoman 2
3662540 1914202 1914202 defendant Ewbanke John yeoman 596911 596911 Ewbanke, John, of Richmond, yeoman 2
3663194 1914407 1914407 defendant Marsyn Margaret   596911 596911 Marsyn, Margaret, of Richmond, Lady & widow 0
3667534 1915787 1915787 defendant Ewbancke John yeoman 596911 596911 Ewbancke, John, of Richmond, yeoman 2
3682063 1920497 1920497 defendant Cowlyng William capper 596911 596911 Cowlyng, William, of Richmond, capper 3
3682064 1920497 1920497 defendant Leyng Thomas capper 596911 596911 Leyng, Thomas, of Richmond, capper 4
3688698 1922626 1922626 defendant Warcop George yeoman 596911 596911 Warcop, George, of Richmond, yeoman 0
3688699 1922626 1922626 defendant Ullok Thomas yeoman 596911 596911 Ullok, Thomas, of Richmond, yeoman 1
3688700 1922626 1922626 defendant Ekyngton Robert yeoman 596911 596911 Ekyngton, Robert, of Richmond, yeoman 2
3688701 1922626 1922626 defendant Ubank John yeoman 596911 596911 Ubank, John, of Richmond, yeoman 3
3769564 1948141 1948141 defendant Trystram William clerk 596911 596911 Trystram, William, of Richmond, clerk 1
3785963 1953408 1953408 defendant Clerk Robert yeoman 596911 596911 Clerk, Robert, of Richmond, yeoman 1
3787371 1953843 1953843 defendant Sawer Richard (legal representative) 596911 596911 Sawer, Richard, of Richmond, mercer, administrator of 0
3787372 1953843 1953843 defendant Tristram William clerk 596911 596911 Tristram, William, of Richmond, clerk 1
3943381 2004800 2004800 defendant Plomer Hugh chapman 596911 596911 Plomer, Hugh, of Richmond, chapman 3
3998083 2024072 2024072 plaintiff Ewbank Ralph chapman 596911 596911 Ewbank, Ralph, of Richmond, chapman 0
4003783 2026119 2026119 plaintiff Wraye Thomas gent 596911 596911 Wraye, Thomas, of Richmond, gent 2
4003791 2026120 2026120 plaintiff Wraye Thomas gent 596911 596911 Wraye, Thomas, of Richmond, gent 2
4030944 2035734 2035734 plaintiff Ewbanke Ralph chapman 596911 596911 Ewbanke, Ralph, of Richmond, chapman 0
4030946 2035735 2035735 plaintiff Ewbanke Ralph chapman 596911 596911 Ewbanke, Ralph, of Richmond, chapman 0
4044904 2040631 2040631 defendant Hall John yeoman 596911 596911 Hall, John, of Richmond, yeoman 0
4062038 2046708 2046708 plaintiff Ewbancke Ralph merchant 596911 596911 Ewbancke, Ralph, of Richmond, merchant 0
4062040 2046709 2046709 plaintiff Ewbancke Ralph merchant 596911 596911 Ewbancke, Ralph, of Richmond, merchant 0
4062042 2046710 2046710 plaintiff Ewbanke Ralph merchant 596911 596911 Ewbanke, Ralph, of Richmond, merchant 0
4088383 2056139 2056139 defendant Awderson Richard shoemaker 596911 596911 Awderson, Richard, of Richmond, shoemaker 0
4090593 2056919 2056919 plaintiff Cottrell James gent 596911 596911 Cottrell, James, of Richmond, gent 0
4111621 2064406 2064406 plaintiff Slinger Bartholomew yeoman 596911 596911 Slinger, Bartholomew, of Richmond, yeoman 0
4111662 2064421 2064421 plaintiff Slynger Bartholomew yeoman 596911 596911 Slynger, Bartholomew, of Richmond, yeoman 0
4132874 2072086 2072086 defendant Atkynson William   596911 596911 Atkynson, William, of Richmond, jerkin maker 0
4150426 2078279 2078279 defendant Moyser Lawrence gent 596911 596911 Moyser, Lawrence, of Richmond, gent 0
4222296 2103289 2103289 defendant Huchinson Arthur chapman 596911 596911 Huchinson, Arthur, of Richmond, chapman 0
4223078 2103561 2103561 defendant Pearson Marmaduke merchant 596911 596911 Pearson, Marmaduke, of Richmond, merchant 0
4223079 2103561 2103561 defendant Pearson Robert draper 596911 596911 Pearson, Robert, of Richmond, draper 1
4244392 2111099 2111099 defendant Wollans Richard draper 596911 596911 Wollans, Richard, of Richmond, draper 1
4249309 2112752 2112752 defendant Jeffreyson Peter yeoman 596911 596911 Jeffreyson, Peter, of Richmond, yeoman 0
4249338 2112762 2112762 defendant Atkynson Edward yeoman 596911 596911 Atkynson, Edward, of Richmond, or of Killington, Westmor, yeoman 0
4251101 2113347 2113347 defendant Hawarde Henry gent 596911 596911 Hawarde, Henry, of Richmond, gent 1
4262223 2117037 2117037 defendant Wilson Anthony yeoman 596911 596911 Wilson, Anthony, of Richmond, yeoman 0
4262224 2117037 2117037 defendant Wetherell John   596911 596911 Wetherell, John, of Richmond, yeoman, sailor 1
4262227 2117038 2117038 defendant Wilson Anthony yeoman 596911 596911 Wilson, Anthony, of Richmond, yeoman 0
4262228 2117038 2117038 defendant Wetherell John   596911 596911 Wetherell, John, of Richmond, yeoman, sailor 1
4262453 2117109 2117109 defendant Jeffrason Peter gent 596911 596911 Jeffrason, Peter, of Richmond, gent 0
4262458 2117110 2117110 defendant Jeffrason Peter gent 596911 596911 Jeffrason, Peter, of Richmond, gent 0
4263773 2117541 2117541 defendant Jeffreyson Peter yeoman 596911 596911 Jeffreyson, Peter, of Richmond, yeoman 0
4264376 2117728 2117728 defendant Jefferson Peter yeoman 596911 596911 Jefferson, Peter, of Richmond, yeoman 2
4264377 2117728 2117728 defendant Moyses James chapman 596911 596911 Moyses, James, of Richmond, chapman 3
4293657 2127795 2127795 defendant Willance Richard draper 596911 596911 Willance, Richard, of Richmond, draper 1
4293658 2127795 2127795 defendant Cowlinge Cuthbert vintner 596911 596911 Cowlinge, Cuthbert, of Richmond, vintner 2
4307819 2132876 2132876 defendant Willance Richard gent 596911 596911 Willance, Richard, of Richmond, gent 0
4307821 2132877 2132877 defendant Pearson Marmaduke mercer 596911 596911 Pearson, Marmaduke, of Richmond, mercer 0
4309663 2133539 2133539 plaintiff Ascoughe Christopher gent 596911 596911 Ascoughe, Christopher, of Richmond, gent 0
4310407 2133796 2133796 defendant Ewbancke Ralph gent 596911 596911 (Ewbancke, Ralph, of Richmond, gent 1
4314916 2135327 2135327 defendant Cowlinge Cuthbert vintner 596911 596911 Cowlinge, Cuthbert, of Richmond, gent, vintner 1
4317521 2136244 2136244 defendant Moizes or Moires James chapman 596911 596911 Moizes or Moires, James, of Richmond, chapman 0
4318626 2136627 2136627 defendant Bartlett Thomas dyer 596911 596911 Bartlett, Thomas, of Richmond, dyer 0
4318627 2136627 2136627 defendant Hord Richard tanner 596911 596911 Hord, Richard, of Richmond, tanner 1
4318628 2136627 2136627 defendant Cookeson William cordwainer 596911 596911 Cookeson, William, of Richmond, cordwainer 2
4318629 2136627 2136627 defendant Todd Lancelot glover 596911 596911 Todd, Lancelot, of Richmond, glover 3
4318631 2136628 2136628 defendant Brafferton William yeoman 596911 596911 Brafferton, William, of Richmond, yeoman 0
4318632 2136628 2136628 defendant Bland Geoffrey yeoman 596911 596911 Bland, Geoffrey, of Richmond, yeoman 1
4318634 2136629 2136629 defendant Croke Thomas   596911 596911 Croke, Thomas, of Richmond, surgeon 0
4318635 2136629 2136629 defendant Lange Thomas yeoman 596911 596911 Lange, Thomas, of Richmond, yeoman 1
4318636 2136629 2136629 defendant Fawcett Reginald cordwainer 596911 596911 Fawcett, Reginald, of Richmond, cordwainer 2
4318637 2136629 2136629 defendant Fawcett Christopher chapman 596911 596911 Fawcett, Christopher, of Richmond, chapman 3
4318646 2136632 2136632 defendant Sigesweke Christopher yeoman 596911 596911 Sigesweke, Christopher, of Richmond, yeoman 0
4318647 2136632 2136632 defendant Pinckney Charles glover 596911 596911 Pinckney, Charles, of Richmond, glover 1
4318648 2136632 2136632 defendant Barnes Richard yeoman 596911 596911 Barnes, Richard, of Richmond, yeoman 2
4321083 2137470 2137470 defendant Willance Richard draper 596911 596911 Willance, Richard, of Richmond, draper 0
4321085 2137470 2137470 defendant Hutchinson Arthur mercer 596911 596911 Hutchinson, Arthur, of Richmond, mercer 2
4322153 2137827 2137827 defendant Anton Gregory yeoman 596911 596911 Anton, Gregory, of Richmond, yeoman 0
4322534 2137948 2137948 defendant Atkinson Francis cordwainer 596911 596911 Atkinson, Francis, of Richmond, cordwainer 2
4322590 2137970 2137970 defendant Willans Richard draper 596911 596911 Willans Richard, of Richmond, draper 0
4325155 2138795 2138795 defendant Willance Richard draper 596911 596911 Willance, Richard, of Richmond, draper 1
4325156 2138795 2138795 defendant Cowlinge Cuthbert vintner 596911 596911 Cowlinge, Cuthbert, of Richmond, vintner 2
4335632 2142193 2142193 defendant Burrell James capper 596911 596911 Burrell, James, of Richmond, capper 1
4346373 2145989 2145989 defendant Dawson Christopher laborer 596911 596911 Dawson, Christopher, of Richmond, laborer 0
4348526 2146737 2146737 defendant Todd Lancelot glover 596911 596911 Todd, Lancelot, of Richmond, glover 0
4348527 2146737 2146737 defendant Allen Leonard tailor 596911 596911 Allen, Leonard, of Richmond, tailor 1
4348528 2146737 2146737 defendant Benton Reginald yeoman 596911 596911 Benton, Reginald, of Richmond, yeoman 2
4350436 2147416 2147416 defendant Corner Henry tailor 596911 596911 Corner, Henry, of Richmond, tailor 0
4350437 2147416 2147416 defendant Mounckton Thomas glover 596911 596911 Mounckton, Thomas, of Richmond, glover 1
4356986 2149674 2149674 defendant Pearson Marmaduke mercer 596911 596911 Pearson, Marmaduke, of Richmond, mercer 0
4358882 2150342 2150342 defendant Burrell James capper 596911 596911 Burrell, James, of Richmond, capper 1
4374520 2155948 2155948 defendant Benton Reginald yeoman 596911 596911 Benton, Reginald, of Richmond, yeoman 0
4374521 2155948 2155948 defendant Paycocke Mathew yeoman 596911 596911 Paycocke, Mathew, of Richmond, yeoman 1
4374522 2155948 2155948 defendant Thompson Richard yeoman 596911 596911 Thompson, Richard, of Richmond, yeoman 2
4374535 2155951 2155951 defendant Hodgeson John yeoman 596911 596911 Hodgeson, John, of Richmond, yeoman 0
4397484 2163737 2163737 defendant Willance Richard draper 596911 596911 Willance, Richard, of Richmond, draper 0
4397485 2163737 2163737 defendant Pearson Marmaduke mercer 596911 596911 Pearson, Marmaduke, of Richmond, mercer 1
4398428 2164055 2164055 defendant Walton Nicholas cooper 596911 596911 Walton, Nicholas, of Richmond, cooper 0
4398429 2164055 2164055 defendant Langstaff Robert laborer 596911 596911 Langstaff, Robert, of Richmond, laborer 1
4400102 2164623 2164623 defendant Kaxe Henry husbandman 596911 596911 Kaxe, Henry, of Richmond, husbandman 0
4400524 2164768 2164768 defendant Todd Lancelot glover 596911 596911 Todd, Lancelot, of Richmond, glover 0
4400525 2164768 2164768 defendant Allen Leonard tailor 596911 596911 Allen, Leonard, of Richmond, tailor 1
4400526 2164768 2164768 defendant Benton Reginald yeoman 596911 596911 Benton, Reginald, of Richmond, yeoman 2

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