names

430 rows where place_id = 586231

✎ 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
3588222 1863970 1863970 defendant Elwyn Thomas husbandman 586231 586231 Elwyn, Thomas, of Wygenhale, husbandman 0
3606533 1869715 1869715 defendant Carvell Humphrey gent 586231 586231 Carvell, Humphrey, of Wygenhale, gent 0
3606534 1869715 1869715 defendant Elwyn William gent 586231 586231 Elwyn, William, of Wygenhale, gent 1
3606809 1869801 1869801 defendant Herdwyk William clerk 586231 586231 Herdwyk, William, of Wygenhale St German, clerk 8
3613597 1871899 1871899 defendant Acre Simon husbandman 586231 586231 Acre, Simon, of Wygenhale, husbandman 0
3613599 1871899 1871899 defendant Shotysham Peter husbandman 586231 586231 Shotysham, Peter, of Wygenhale, husbandman 2
3613600 1871899 1871899 defendant Launde Peter husbandman 586231 586231 Launde, Peter, of Wygenhale, husbandman 3
3614661 1872238 1872238 defendant Elwyn William gent 586231 586231 Elwyn, William, of Wygenhale, gent 1
3619999 1873826 1873826 defendant Feryour John butcher 586231 586231 Feryour, John, of Wygenhale, butcher 0
3622349 1874525 1874525 defendant Benet William husbandman 586231 586231 Benet, William, of Wygenhale, husbandman 3
3622384 1874539 1874539 defendant Parker Robert   586231 586231 Parker, Robert, of Wygenhale, tile burner 0
3624437 1875178 1875178 defendant Smyth Robert (legal representative) 586231 586231 Smyth, Robert, of Wygenhale, yeoman, executors of 0
3624666 1875251 1875251 defendant Tullyat William yeoman 586231 586231 Tullyat, William, of Wygenhale St German, yeoman 0
3624670 1875251 1875251 defendant Ryches John gent 586231 586231 Ryches, John, of Wygenhale St German, gent 4
3633376 1905251 1905251 plaintiff Kervyle Humphrey esq 586231 586231 Kervyle, Humphrey, of Wygenhale, esq 0
3633378 1905252 1905252 plaintiff Kervyle Humphrey esq 586231 586231 Kervyle, Humphrey, of Wygenhale, esq 0
3633379 1905252 1905252 plaintiff Elwyn William gent 586231 586231 Elwyn, William, of Wygenhale, gent 1
3636062 1906071 1906071 defendant Smyth Robert husbandman 586231 586231 Smyth, Robert, of Wygenhale, husbandman 2
3636063 1906071 1906071 defendant Fraunceys Thomas brickmaker 586231 586231 Fraunceys, Thomas, of Wygenhale, brickmaker 3
3636065 1906072 1906072 defendant Feryer John yeoman 586231 586231 Feryer, John, of Wygenhale, yeoman 0
3636066 1906072 1906072 defendant Smyth Robert husbandman 586231 586231 Smyth, Robert, of Wygenhale, husbandman 1
3636067 1906072 1906072 defendant Aparys John husbandman 586231 586231 Aparys, John, of Wygenhale, husbandman 2
3636071 1906073 1906073 defendant Smyth Robert husbandman 586231 586231 Smyth, Robert, of Wygenhale, husbandman 1
3636073 1906074 1906074 plaintiff Prentys William   586231 586231 Prentys, William, of Wygenhale 0
3636075 1906075 1906075 plaintiff Prentys William yeoman 586231 586231 Prentys, William, of Wygenhale, yeoman 0
3636078 1906076 1906076 plaintiff Prentys William yeoman 586231 586231 Prentys, William, of Wygenhale, yeoman 0
3636080 1906076 1906076 defendant Gylbert Robert husbandman 586231 586231 Gylbert, Robert, of Wygenhale, husbandman 1
3636084 1906076 1906076 defendant Fraunceys Robert husbandman 586231 586231 Fraunceys, Robert, of Wygenhale, husbandman 5
3636085 1906077 1906077 plaintiff Prentys William yeoman 586231 586231 Prentys, William, of Wygenhale, yeoman 0
3640837 1907579 1907579 defendant Prentys William yeoman 586231 586231 Prentys, William, of Wygenhale, yeoman 0
3644195 1908617 1908617 defendant Prentys William yeoman 586231 586231 Prentys, William, of Wygenhale, yeoman 0
3649493 1910230 1910230 defendant Wryght George carpenter 586231 586231 Wryght, George, of Wygenhale, carpenter 0
3655204 1911885 1911885 defendant Nevery Thomas husbandman & miller 586231 586231 Nevery, Thomas, of Wygenhale, husbandman & miller 0
3661866 1913998 1913998 defendant Illa alias Luter John yeoman 586231 586231 Illa alias Luter, John, of Wygenhale, yeoman 0
3663907 1914653 1914653 defendant Prentys John tailor 586231 586231 Prentys, John, of Wygenhale, tailor 2
3676779 1918774 1918774 plaintiff Kervile Humphrey esq 586231 586231 Kervile, Humphrey, of Wygenhale, esq 0
3676782 1918775 1918775 defendant Whittyll John husbandman 586231 586231 Whittyll, John, of Wygenhale, husbandman 0
3676783 1918775 1918775 defendant Halydale John husbandman 586231 586231 Halydale, John, of Wygenhale, husbandman 1
3676784 1918775 1918775 defendant Peerson John husbandman 586231 586231 Peerson, John, of Wygenhale, husbandman 2
3677772 1919096 1919096 defendant Pers Thomas husbandman 586231 586231 Pers, Thomas, of Wygenhale, husbandman 1
3688212 1922463 1922463 defendant Boteler Gilbert yeoman 586231 586231 Boteler, Gilbert, of Wygenhale, yeoman 0
3693366 1924139 1924139 defendant Pers Thomas yeoman 586231 586231 Pers, Thomas, of Wygenhale, yeoman 0
3694434 1924464 1924464 defendant Woodrose or Woodrofe John laborer 586231 586231 Woodrose or Woodrofe, John, of Wygenhale, laborer 0
3705192 1927910 1927910 defendant Peers William husbandman 586231 586231 Peers, William, of Wygenhale, husbandman 0
3705193 1927910 1927910 defendant Harpeley Robert, junior yeoman 586231 586231 Harpeley, Robert, junior, of Wygenhale St German, yeoman 1
3705194 1927910 1927910 defendant Harpeley Robert, senior husbandman 586231 586231 Harpeley, Robert, senior, of Wygenhale, husbandman 2
3723954 1933773 1933773 defendant Karvyle Humphrey, junior gent 586231 586231 Karvyle, Humphrey, junior, of Wygenhale, gent 0
3723955 1933773 1933773 defendant Peers John husbandman 586231 586231 Peers, John, of Wygenhale, husbandman 1
3767688 1947530 1947530 defendant Shreff German husbandman 586231 586231 Shreff, German, of Wygenhale St German, husbandman 1
3783216 1952503 1952503 plaintiff Kervyle Humphrey, senior (legal representative) 586231 586231 Kervyle, Humphrey, senior, of Wygenhale, esq, executor of 0
3797331 1957055 1957055 defendant Miller Thomas husbandman 586231 586231 Miller, Thomas, of Wygenhale, husbandman 0
3797332 1957055 1957055 defendant Barbour Robert tailor 586231 586231 Barbour, Robert, of Wygenhale, tailor 1
3799618 1957805 1957805 plaintiff Karvyle Humphrey, senior (legal representative) 586231 586231 Karvyle, Humphrey, senior, of Wygenhale, esq, executors of 0
3799624 1957806 1957806 plaintiff Karvyle Humphrey, senior (legal representative) 586231 586231 Karvyle, Humphrey, senior, of Wygenhale, esq, executors of 0
3803050 1958856 1958856 defendant Punder William husbandman 586231 586231 Punder, William, of Wygenhale, husbandman 0
3815202 1962672 1962672 defendant Waller John husbandman 586231 586231 Waller, John, of Wygenhale, husbandman 1
3817227 1963304 1963304 defendant Wright Thomas husbandman 586231 586231 Wright, Thomas, of Wygenhale, husbandman 1
3820439 1964276 1964276 plaintiff Prentyse Thomas gent 586231 586231 Prentyse, Thomas, of Wygenhale, gent 0
3820441 1964277 1964277 plaintiff Prentyse Thomas gent 586231 586231 Prentyse, Thomas, of Wygenhale, gent 0
3829759 1967199 1967199 defendant Peers William husbandman 586231 586231 Peers, William, of Wygenhale St Peter, husbandman 0
4018467 2031338 2031338 defendant Flegge Richard yeoman 586231 586231 Flegge, Richard, of Wygenhale St Peter, yeoman 1
4040828 2039211 2039211 defendant Hatley Robert butcher 586231 586231 Hatley, Robert, of Wygenhale St German, butcher 2
4415335 2169692 2169692 defendant Blower John   586231 586231 Blower, John, of Wygenhale, son of William 0
4418330 2170615 2170615 defendant Avelot William   586231 586231 Avelot, William, of Wygenhale 2
4418797 2170746 2170746 defendant Howard Thomas   586231 586231 Howard, Thomas, of Wygenhale, son of William 0
4418799 2170746 2170746 defendant Howard John   586231 586231 Howard, John, of Wygenhale, son of William 2
4421887 2171723 2171723 plaintiff Debene Thomas   586231 586231 Debene, Thomas, of Wygenhale, son of Thomas 0
4423077 2172079 2172079 defendant Scop John   586231 586231 Scop, John, of wygenhale 0
4423103 2172082 2172082 defendant Cort John   586231 586231 Cort, John, of Wygenhale 18
4424292 2172441 2172441 plaintiff Howard Thomas   586231 586231 Howard, Thomas, of Wygenhale, son of William 0
4424294 2172441 2172441 plaintiff Howard John   586231 586231 Howard, John, of Wygenhale, son of William 2
4429685 2174074 2174074 defendant Avelot William   586231 586231 Avelot, William, of Wygenhale 2
4434992 2175706 2175706 defendant Aleyn John   586231 586231 Aleyn, John, of Wygenhale 2
4434996 2175707 2175707 defendant Aleyn John   586231 586231 Aleyn, John, of Wygenhale 2
4441397 2182250 2182250 plaintiff Boston Margaret de   586231 586231 Boston, Margaret de, of Wygenhale, formerly wife of Thomas 0
4441398 2182250 2182250 defendant Warenn William de   586231 586231 Warenn, William de, of Wygenhale, son of William 0
4442162 2182479 2182479 defendant Roberd Richard   586231 586231 Roberd, Richard, of Wygenhale 0
4451749 2185521 2185521 defendant Haward Ralph   586231 586231 Haward, Ralph, of Wygenhale 0
4451838 2185553 2185553 defendant Howard Randolf   586231 586231 Howard, Randolf, of Wygenhale;Slenk, William 0
4452748 2185871 2185871 defendant Grey Thomas   586231 586231 Grey, Thomas, of Wygenhale 0
4462180 2188868 2188868 plaintiff Collesson John   586231 586231 Collesson, John, of Wygenhale 1
4479981 2194405 2194405 plaintiff Kervyle John   586231 586231 Kervyle, John, of Wygenhale, on his own account 0
4508596 2203166 2203166 defendant Mason Benedict   586231 586231 Mason, Benedict, of Wygenhale 0
4550263 2216029 2216029 defendant Gebon Roger   586231 586231 Gebon, Roger, of Wygenhale 0
4551334 2216354 2216354 defendant Daddy William   586231 586231 Daddy, William, of Wygenhale 1
4557016 2218120 2218120 defendant Prentes Henry   586231 586231 Prentes, Henry, of Wygenhale 0
4571005 2222498 2222498 defendant Kervyle Robert   586231 586231 Kervyle, Robert, of Wygenhale 0
4573372 2223203 2223203 defendant Rumneye John   586231 586231 Rumneye, John, of Wygenhale 0
4575293 2223786 2223786 defendant Sherman Thomas   586231 586231 Sherman, Thomas, of Wygenhale 4
4583874 2226372 2226372 defendant Gery Edmund   586231 586231 Gery, Edmund, of Wygenhale 1
4583877 2226373 2226373 defendant Gery Edmund   586231 586231 Gery, Edmund, of Wygenhale 1
4600882 2231501 2231501 defendant Toope William   586231 586231 Toope, William, of Wygenhale 0
4600883 2231501 2231501 defendant Bonde William   586231 586231 Bonde, William, of Wygenhale 1
4608378 2233731 2233731 defendant Ely John   586231 586231 Ely, John, of Wygenhale 2
4623100 2238202 2238202 defendant Frere Simon   586231 586231 Frere, Simon, of Wygenhale, servant of John 0
4626884 2239350 2239350 defendant Cantele William   586231 586231 Cantele, William, of Wygenhale 0
4626885 2239350 2239350 defendant Demanye John   586231 586231 Demanye, John, of Wygenhale 1
4626888 2239351 2239351 defendant York Stephen   586231 586231 (York, Stephen, of Wygenhale 1
4630861 2240544 2240544 defendant Leeke John   586231 586231 Leeke, John, of Wygenhale 1
4640336 2243287 2243287 defendant Horsete John   586231 586231 Horsete, John, of Wygenhale 0

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