names

291 rows where place_id = 586262

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588304 1863994 1863994 defendant Meres Thomas gent 586262 586262 Meres, Thomas, of Kyrton, gent 0
3591405 1864937 1864937 defendant Chapman John mercer 586262 586262 Chapman, John, of Kyrton, mercer 1
3610628 1870992 1870992 defendant Robertis Simon husbandman 586262 586262 Robertis, Simon, of Kyrton, husbandman 0
3611788 1871354 1871354 defendant Tyson Robert weaver 586262 586262 Tyson, Robert, of Kyrton, weaver 0
3615695 1872553 1872553 defendant Cony Thomas husbandman 586262 586262 Cony, Thomas, of Kyrton, husbandman 0
3623153 1874763 1874763 defendant Wylson Reginald husbandman 586262 586262 Wylson, Reginald, of Kyrton, husbandman 0
3626157 1903043 1903043 defendant Elryke alias Arley Thomas   586262 586262 Elryke alias Arley, Thomas, of Kyrton 1
3630245 1904307 1904307 defendant Thomson John yeoman 586262 586262 Thomson, John, of Kyrton, yeoman 0
3630600 1904399 1904399 defendant Darley John shoemaker 586262 586262 Darley, John, of Kyrton, shoemaker 2
3631055 1904536 1904536 defendant Elryk Thomas yeoman 586262 586262 Elryk, Thomas, of Kyrton, yeoman 0
3631831 1904763 1904763 defendant Hopkynson Alan husbandman 586262 586262 Hopkynson, Alan, of Kyrton, husbandman 0
3631835 1904765 1904765 defendant Elryk Thomas yeoman 586262 586262 Elryk, Thomas, of Kyrton, yeoman 0
3638141 1906746 1906746 defendant Olyver John yeoman 586262 586262 Olyver, John, of Kyrton, yeoman 1
3647829 1909716 1909716 defendant Heyland Robert husbandman 586262 586262 Heyland, Robert, of Kyrton, husbandman 0
3647830 1909716 1909716 defendant Heyland Alan husbandman 586262 586262 Heyland, Alan, of Kyrton, husbandman 1
3656725 1912358 1912358 defendant Oliver John yeoman 586262 586262 Oliver, John, of Kyrton, yeoman 0
3660675 1913602 1913602 defendant Serell James chaplain 586262 586262 Serell, James, of Kyrton, chaplain 0
3668196 1916001 1916001 defendant Rawe John miller 586262 586262 Rawe, John, of Kyrton, miller 0
3668197 1916001 1916001 defendant Ansley Thomas dyer 586262 586262 Ansley, Thomas, of Kyrton, dyer 1
3668536 1916118 1916118 defendant Hampton Richard yeoman 586262 586262 Hampton, Richard, of Kyrton, yeoman 0
3669208 1916307 1916307 defendant Wyndeby William butcher 586262 586262 Wyndeby, William, of Kyrton, butcher 1
3669686 1916459 1916459 defendant Helyer John weaver 586262 586262 Helyer, John, of Kyrton, weaver 0
3670788 1916825 1916825 defendant Bysshop Joan widow 586262 586262 Bysshop, Joan, of Kyrton, widow 0
3672122 1917280 1917280 defendant Robert John butcher 586262 586262 Robert, John, of Kyrton, butcher 0
3672123 1917280 1917280 defendant Cloysse John butcher 586262 586262 Cloysse, John, of Kyrton, butcher 1
3672124 1917280 1917280 defendant Dart Roger butcher 586262 586262 Dart, Roger, of Kyrton, butcher 2
3677245 1918929 1918929 defendant Cowle Richard husbandman 586262 586262 Cowle, Richard, of Kyrton, husbandman 0
3679826 1919754 1919754 defendant Mathu John cordwainer 586262 586262 Mathu, John, of Kyrton, cordwainer 0
3680456 1919968 1919968 defendant Trobok John, senior husbandman 586262 586262 Trobok, John, senior, of Kyrton, husbandman 2
3684034 1921140 1921140 defendant Moore John laborer 586262 586262 Moore, John, of Kyrton, laborer 0
3686913 1922071 1922071 defendant Budde William yeoman 586262 586262 (Budde, William, of Kyrton, yeoman 1
3687597 1922294 1922294 defendant Hoffegray John chaplain 586262 586262 Hoffegray, John, of Kyrton, chaplain 0
3687598 1922294 1922294 defendant Lee Elias weaver 586262 586262 Lee, Elias, of Kyrton, weaver 1
3688132 1922440 1922440 defendant Thaccher Nicholas husbandman 586262 586262 Thaccher, Nicholas, of Kyrton, husbandman 1
3688686 1922623 1922623 defendant Smyth John husbandman 586262 586262 Smyth, John, of Kyrton, husbandman 2
3688733 1922638 1922638 defendant Bronde Thomas husbandman 586262 586262 Bronde, Thomas, of Kyrton, husbandman 1
3690000 1923032 1923032 defendant Bunkes Thomas tailor 586262 586262 Bunkes, Thomas, of Kyrton, tailor 0
3690278 1923121 1923121 defendant Tomson John husbandman 586262 586262 Tomson, John, of Kyrton, husbandman 0
3693968 1924316 1924316 defendant Dyer Joan widow 586262 586262 Dyer, Joan, of Kyrton, widow 1
3693969 1924316 1924316 defendant Dyer Robert weaver 586262 586262 Dyer, Robert, of Kyrton, weaver 2
3694784 1924576 1924576 defendant Dowrysche Thomas gent 586262 586262 Dowrysche, Thomas, of Kyrton, gent 0
3696246 1925047 1925047 defendant Wonston John currier 586262 586262 Wonston, John, of Kyrton, currier 0
3697739 1925514 1925514 plaintiff Thorneton Robert   586262 586262 Thorneton, Robert, of Kyrton 0
3697740 1925514 1925514 defendant Stevynson Robert   586262 586262 Stevynson, Robert, of Kyrton 0
3699263 1925983 1925983 defendant Darte Roger yeoman 586262 586262 Darte, Roger, of Kyrton, yeoman 2
3701135 1926603 1926603 defendant Robert John butcher 586262 586262 Robert, John, of Kyrton, butcher 0
3701139 1926605 1926605 defendant Olyver John yeoman 586262 586262 Olyver, John, of Kyrton, yeoman 0
3701479 1926710 1926710 defendant Pope Joan widow 586262 586262 Pope, Joan, of Kyrton, widow 0
3701480 1926710 1926710 defendant Pope Henry yeoman 586262 586262 Pope, Henry, of Kyrton, yeoman 1
3703959 1927519 1927519 defendant Skutte John husbandman 586262 586262 Skutte, John, of Kyrton, husbandman 0
3704305 1927647 1927647 defendant Roche Peter   586262 586262 Roche, Peter, of Kyrton, husbandman, son of Alice, daughter of Bate, Richard 0
3708551 1928973 1928973 defendant Eylound or Gylound Robert, junior husbandman 586262 586262 Eylound or Gylound, Robert, junior, of Kyrton, husbandman 0
3709092 1929143 1929143 defendant Stone Richard husbandman 586262 586262 Stone, Richard, of Kyrton, husbandman 0
3712785 1930315 1930315 defendant Darte Roger yeoman 586262 586262 Darte, Roger, of Kyrton, yeoman 0
3712786 1930315 1930315 defendant Capener Roger husbandman 586262 586262 Capener, Roger, of Kyrton, husbandman 1
3716847 1931558 1931558 defendant Robert John butcher 586262 586262 Robert, John, of Kyrton, butcher 0
3716849 1931559 1931559 defendant Serle Walter yeoman 586262 586262 Serle, Walter, of Kyrton, yeoman 0
3716851 1931559 1931559 defendant Robert John butcher 586262 586262 (Robert, John, of Kyrton, butcher 2
3724007 1933793 1933793 defendant Knyght John husbandman 586262 586262 Knyght, John, of Kyrton, husbandman 2
3724882 1934068 1934068 defendant Mortymer William husbandman 586262 586262 Mortymer, William, of Kyrton, husbandman 0
3725756 1934344 1934344 defendant Wethyrbroke Hugh chaplain 586262 586262 Wethyrbroke, Hugh, of Kyrton, chaplain 0
3725757 1934344 1934344 defendant Philipp Robert husbandman 586262 586262 Philipp, Robert, of Kyrton, husbandman 1
3725758 1934344 1934344 defendant Pytwode Henry   586262 586262 Pytwode, Henry, of Kyrton, groom 2
3725759 1934344 1934344 defendant Wresford Nicholas   586262 586262 Wresford, Nicholas, of Kyrton, groom 3
3725760 1934344 1934344 defendant Mortymer Roger husbandman 586262 586262 Mortymer, Roger, of Kyrton, husbandman 4
3725761 1934344 1934344 defendant West William husbandman 586262 586262 West, William, of Kyrton, husbandman 5
3726542 1934559 1934559 defendant Loveles John husbandman 586262 586262 Loveles, John, of Kyrton, husbandman 0
3726543 1934559 1934559 defendant Langrake Richard husbandman 586262 586262 Langrake, Richard, of Kyrton, husbandman 1
3726544 1934559 1934559 defendant Langrake Simon husbandman 586262 586262 Langrake, Simon, of Kyrton, husbandman 2
3726545 1934559 1934559 defendant Bele Thomas husbandman 586262 586262 Bele, Thomas, of Kyrton, husbandman 3
3726546 1934559 1934559 defendant Johnson Richard laborer 586262 586262 Johnson, Richard, of Kyrton, laborer 4
3727707 1934935 1934935 plaintiff Whalley Thomas   586262 586262 Whalley, Thomas, of Kyrton, administrators of 0
3729271 1935407 1935407 defendant Serell John husbandman 586262 586262 Serell, John, of Kyrton, husbandman 0
3729272 1935407 1935407 defendant Edbery Robert husbandman 586262 586262 Edbery, Robert, of Kyrton, husbandman 1
3729273 1935407 1935407 defendant Whytrowe Nicholas husbandman 586262 586262 Whytrowe, Nicholas, of Kyrton, husbandman 2
3729274 1935407 1935407 defendant Pruddon Thomas husbandman 586262 586262 Pruddon, Thomas, of Kyrton, husbandman 3
3729275 1935407 1935407 defendant Grauntlond Thomas husbandman 586262 586262 Grauntlond, Thomas, of Kyrton, husbandman 4
3729276 1935407 1935407 defendant Gold John husbandman 586262 586262 Gold, John, of Kyrton, husbandman 5
3729277 1935407 1935407 defendant Gate John husbandman 586262 586262 Gate, John, of Kyrton, husbandman 6
3729278 1935407 1935407 defendant Browne Baldwin husbandman 586262 586262 Browne, Baldwin, of Kyrton, husbandman 7
3729279 1935407 1935407 defendant Bett or Bea John husbandman 586262 586262 Bett or Bea, John, of Kyrton, husbandman 8
3729280 1935407 1935407 defendant Pope Giles husbandman 586262 586262 Pope, Giles, of Kyrton, husbandman 9
3731763 1936165 1936165 plaintiff Kyng Edmund   586262 586262 Kyng, Edmund, of Kyrton 1
3731779 1936170 1936170 defendant Dart Roger butcher 586262 586262 Dart, Roger, of Kyrton, butcher 0
3731780 1936170 1936170 defendant Olyver John yeoman 586262 586262 Olyver, John, of Kyrton, yeoman 1
3732514 1936400 1936400 defendant Serle Walter yeoman 586262 586262 Serle, Walter, of Kyrton, yeoman 0
3733072 1936568 1936568 defendant Hopkynson Thomas husbandman 586262 586262 Hopkynson, Thomas, of Kyrton, husbandman 0
3735277 1937268 1937268 defendant Drewe Richard laborer 586262 586262 Drewe, Richard, of Kyrton, laborer 1
3735278 1937268 1937268 defendant Medeley Thomas pardoner 586262 586262 Medeley, Thomas, of Kyrton, pardoner 2
3740693 1938951 1938951 defendant Cony Richard husbandman 586262 586262 Cony, Richard, of Kyrton, husbandman 0
3740823 1938986 1938986 defendant Mortymer William husbandman 586262 586262 Mortymer, William, of Kyrton, husbandman 0
3740826 1938987 1938987 defendant Mortymer William husbandman 586262 586262 Mortymer, William, of Kyrton, husbandman 0
3745445 1940480 1940480 defendant Spycer John cordwainer 586262 586262 Spycer, John, of Kyrton, cordwainer 0
3747433 1941111 1941111 defendant Warner Thomas husbandman 586262 586262 Warner, Thomas, of Kyrton, husbandman 0
3755861 1943785 1943785 defendant Domysday John laborer 586262 586262 Domysday, John, of Kyrton, laborer 0
3755862 1943785 1943785 defendant May Richard laborer 586262 586262 May, Richard, of Kyrton, laborer 1
3755869 1943788 1943788 plaintiff Wyse Thomas clerk 586262 586262 Wyse, Thomas, of Kyrton, clerk 0
3778958 1951139 1951139 defendant Lambert John yeoman 586262 586262 Lambert, John, of Kyrton, yeoman 0
3778960 1951140 1951140 defendant Lambert John yeoman 586262 586262 Lambert, John, of Kyrton, yeoman 0
3786615 1953609 1953609 defendant Wardall William husbandman 586262 586262 Wardall, William, of Kyrton, husbandman 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);