names

199 rows where place_id = 589705

✎ 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
3598471 1867151 1867151 defendant Marchaunt Robert clerk 589705 589705 Marchaunt, Robert, of Hyndryngham, clerk 0
3605441 1869367 1869367 defendant Over Andrew husbandman 589705 589705 Over, Andrew, of Hyndryngham, husbandman 0
3616194 1872705 1872705 defendant Mason Adam husbandman 589705 589705 Mason, Adam, of Hyndryngham, husbandman 0
3616195 1872705 1872705 defendant Mason Simon husbandman 589705 589705 Mason, Simon, of Hyndryngham, husbandman 1
3616198 1872706 1872706 defendant Mason Adam husbandman 589705 589705 Mason, Adam, of Hyndryngham, husbandman 0
3616199 1872706 1872706 defendant Mason Simon   589705 589705 Mason, Simon, of Hyndryngham, mason or husbandman 1
3621880 1874385 1874385 defendant May Alexander husbandman 589705 589705 May, Alexander, of Hyndryngham, husbandman 0
3621881 1874385 1874385 defendant May Richard husbandman 589705 589705 May, Richard, of Hyndryngham, husbandman 1
3638475 1906852 1906852 defendant Marchant Robert clerk 589705 589705 Marchant, Robert, of Hyndryngham, clerk 1
3672603 1917428 1917428 defendant Wylby Margaret widow 589705 589705 Wylby, Margaret, of Hyndryngham, widow 3
3683706 1921037 1921037 defendant Mason William husbandman 589705 589705 Mason, William, of Hyndryngham, husbandman 0
3729199 1935381 1935381 defendant Multon William butcher 589705 589705 Multon, William, of Hyndryngham, butcher 0
3738061 1938120 1938120 defendant Maye Gregory husbandman 589705 589705 Maye, Gregory, of Hyndryngham, husbandman 0
3750120 1941951 1941951 defendant Mason Alexander husbandman 589705 589705 Mason, Alexander, of Hyndryngham, husbandman 2
3765427 1946850 1946850 defendant Pedder Robert husbandman 589705 589705 Pedder, Robert, of Hyndryngham, husbandman 0
3784469 1952927 1952927 defendant Mason William husbandman 589705 589705 Mason, William, of Hyndryngham, husbandman 0
3812965 1961955 1961955 defendant Mason Alexander yeoman 589705 589705 Mason, Alexander, of Hyndryngham, yeoman 0
3834654 1968773 1968773 defendant Harvy Robert clerk 589705 589705 Harvy, Robert, of Hyndryngham, clerk 0
3843741 1971574 1971574 defendant Burder William husbandman 589705 589705 Burder, William, of Hyndryngham, husbandman 0
3844653 1971870 1971870 defendant Mason Alexander husbandman 589705 589705 Mason, Alexander, of Hyndryngham, husbandman 0
3849907 1973556 1973556 defendant Cowper Christopher husbandman 589705 589705 Cowper, Christopher, of Hyndryngham, husbandman 0
3849909 1973557 1973557 defendant May William   589705 589705 May, William, of Hyndryngham, shepherd 0
3859814 1976782 1976782 defendant Burder William husbandman 589705 589705 Burder, William, of Hyndryngham, husbandman 0
3864850 1978444 1978444 defendant Maye William   589705 589705 Maye, William, of Hyndryngham, shepherd 0
3886412 1985707 1985707 defendant Mason Adam (legal representative) 589705 589705 Mason, Adam, of Hyndryngham, yeoman, executors of 0
3886413 1985707 1985707 defendant Mason William yeoman 589705 589705 (Mason, William, of Hyndryngham, yeoman 1
3886414 1985707 1985707 defendant Mason Alexander husbandman 589705 589705 Mason, Alexander, of Hyndryngham, husbandman 2
3911132 1994050 1994050 defendant Jelle Richard blacksmith 589705 589705 Jelle, Richard, of Hyndryngham, blacksmith 0
3911134 1994050 1994050 defendant Tomson Robert husbandman 589705 589705 Tomson, Robert, of Hyndryngham, husbandman 2
3917853 1996331 1996331 defendant Maye Adas yeoman 589705 589705 Maye, Adas, of Hyndryngham, yeoman 0
3917854 1996331 1996331 defendant Mason William yeoman 589705 589705 Mason, William, of Hyndryngham, yeoman 1
3917887 1996344 1996344 defendant Cowper Robert husbandman 589705 589705 Cowper, Robert, of Hyndryngham, husbandman 0
3924636 1998553 1998553 defendant Tomson John laborer 589705 589705 Tomson, John, of Hyndryngham, laborer 1
3956509 2009343 2009343 defendant Bedyngfeld Edmund esq 589705 589705 Bedyngfeld, Edmund, of Hyndryngham, esq 0
3976479 2016350 2016350 defendant Mason Adam yeoman 589705 589705 Mason, Adam, of Hyndryngham, yeoman 0
3978316 2017000 2017000 plaintiff Maye Adam   589705 589705 Maye, Adam, of Hyndryngham 0
3978318 2017000 2017000 defendant Mason Adam yeoman 589705 589705 Mason, Adam, of Hyndryngham, yeoman 0
3978321 2017000 2017000 defendant Framyngham John husbandman 589705 589705 Framyngham, John, of Hyndryngham, husbandman 3
3992370 2022037 2022037 plaintiff Burton Richard   589705 589705 Burton, Richard, of Hyndryngham 0
3992372 2022038 2022038 plaintiff Burton Richard   589705 589705 Burton, Richard, of Hyndryngham 0
3997018 2023702 2023702 defendant Fary Thomas yeoman 589705 589705 Fary, Thomas, of Hyndryngham, yeoman 0
4002003 2025495 2025495 plaintiff Hastyng Martin esq 589705 589705 Hastyng, Martin, of Hyndryngham, esq 0
4060822 2046276 2046276 defendant Mason Adam husbandman 589705 589705 Mason, Adam, of Hyndryngham, husbandman 0
4103592 2061568 2061568 defendant Manne Thomas yeoman 589705 589705 Manne, Thomas, of Hyndryngham, yeoman 2
4103866 2061658 2061658 defendant Coll Martin yeoman 589705 589705 Coll, Martin, of Hyndryngham, yeoman 0
4124778 2069155 2069155 defendant Hypgame or Hypgaine William   589705 589705 Hypgame or Hypgaine, William, of Hyndryngham, shepherd 1
4138032 2073966 2073966 defendant Reade Thomas yeoman 589705 589705 Reade, Thomas, of Hyndryngham, yeoman 0
4144238 2076142 2076142 defendant Reade Thomas yeoman 589705 589705 Reade, Thomas, of Hyndryngham, yeoman 0
4145388 2076545 2076545 defendant Bedyngfeld Edmund esq 589705 589705 Bedyngfeld, Edmund, of Hyndryngham, esq 0
4145390 2076546 2076546 defendant Bedynfeld Edmund esq 589705 589705 Bedynfeld, Edmund, of Hyndryngham, esq 0
4194653 2093687 2093687 defendant Manne William tailor 589705 589705 Manne, William, of Hyndryngham, tailor 0
4201413 2096042 2096042 defendant Sponer John blacksmith 589705 589705 Sponer, John, of Hyndryngham, blacksmith 0
4225565 2104406 2104406 defendant Wyggon Thomas yeoman 589705 589705 Wyggon, Thomas, of Hyndryngham, yeoman 0
4226310 2104675 2104675 defendant Hasting Thomas gent 589705 589705 Hasting, Thomas, of Hyndryngham, or of Dallame, Suff, gent 0
4257214 2115390 2115390 defendant Man Henry husbandman 589705 589705 Man, Henry, of Hyndryngham, sailor, son of Henry Man, of Hindringham, husbandman 0
4317196 2136126 2136126 defendant Cooke Thomas yeoman 589705 589705 (Cooke, Thomas, of Hyndryngham, yeoman 1
4395966 2163226 2163226 defendant Ayleard Simon husbandman 589705 589705 Ayleard, Simon, of Hyndryngham, husbandman 2
4424107 2172397 2172397 defendant Hervys Simon   589705 589705 Hervys, Simon, of Hyndryngham, son of Roger 0
4424109 2172397 2172397 defendant Willism Adam   589705 589705 Willism, Adam, of Hyndryngham 2
4424110 2172397 2172397 defendant Bisshop Alice   589705 589705 Bisshop, Alice, of Hyndryngham 3
4424111 2172397 2172397 defendant Lyne William   589705 589705 Lyne, William, of Hyndryngham 4
4424112 2172397 2172397 defendant Spyrell Olave   589705 589705 Spyrell, Olave, of Hyndryngham 5
4424113 2172397 2172397 defendant atte Kirk Thomas   589705 589705 atte Kirk, Thomas, of Hyndryngham 6
4424115 2172397 2172397 defendant Merval Alan   589705 589705 Merval, Alan, of Hyndryngham 8
4424116 2172397 2172397 defendant Willys Robert   589705 589705 Willys, Robert, of Hyndryngham 9
4424288 2172439 2172439 defendant Hervy Thomas   589705 589705 Hervy, Thomas, of Hyndryngham, son of Roger 0
4424289 2172439 2172439 defendant Walekyn Nicholas   589705 589705 Walekyn, Nicholas, of Hyndryngham 1
4431950 2174772 2174772 defendant Hervy Thomas   589705 589705 Hervy, Thomas, of Hyndryngham 1
4431955 2174773 2174773 defendant Hervy Thomas   589705 589705 Hervy, Thomas, of Hyndryngham 1
4433781 2175331 2175331 defendant Brice John   589705 589705 Brice, John, of Hyndryngham 2
4434032 2175403 2175403 defendant Welderkyn Nicholas   589705 589705 Welderkyn, Nicholas, of Hyndryngham 1
4438569 2181353 2181353 defendant Pryee John   589705 589705 Pryee, John, of Hyndryngham 0
4439626 2181660 2181660 defendant Prygge John   589705 589705 Prygge, John, of Hyndryngham 2
4497998 2200018 2200018 defendant Blakeman John   589705 589705 Blakeman, John, of Hyndryngham 4
4570003 2222189 2222189 defendant Goldyng Robert   589705 589705 Goldyng, Robert, of Hyndryngham 0
4573895 2223352 2223352 defendant Mason John   589705 589705 Mason, John, of Hyndryngham 0
4629762 2240231 2240231 defendant Wilbeye John   589705 589705 Wilbeye, John, of Hyndryngham, son of John 0
4650347 2246123 2246123 plaintiff Wilbeye John   589705 589705 Wilbeye, John, of Hyndryngham 0
4650349 2246124 2246124 plaintiff Wilbeye John   589705 589705 Wilbeye, John, of Hyndryngham 0
4655596 2247638 2247638 defendant Wilbeye John   589705 589705 Wilbeye, John, of Hyndryngham, franklin 3
4686244 2261299 2261299 plaintiff Shillyng John husbandman 589705 589705 Shillyng, John, of Hyndryngham, husbandman, on his own account 0
4701727 2265937 2265937 defendant Jolyf John clerk 589705 589705 Jolyf, John, of Hyndryngham, clerk 0
4701728 2265937 2265937 defendant Ambelour Nicholas   589705 589705 Ambelour, Nicholas, of Hyndryngham 1
4701729 2265937 2265937 defendant Walterkyn Thomas   589705 589705 Walterkyn, Thomas, of Hyndryngham 2
4701730 2265937 2265937 defendant Cosyn Alexander   589705 589705 Cosyn, Alexander, of Hyndryngham 3
4731376 2275014 2275014 plaintiff Morys John   589705 589705 Morys, John, of Hyndryngham 0
4731378 2275014 2275014 defendant Sparham Thomas yeoman 589705 589705 Sparham, Thomas, of Hyndryngham, yeoman 1
4735984 2276400 2276400 defendant Wilbeye Edward brother & heir of John 589705 589705 Wilbeye, Edward, of Hyndryngham, gent, brother & heir of John 0
4789869 2292903 2292903 defendant Wilbey Edward gent 589705 589705 Wilbey, Edward, of Hyndryngham, gent 0
4804974 2297761 2297761 defendant Barsham Reginald butcher 589705 589705 Barsham, Reginald, of Hyndryngham, butcher 0
4818929 2302005 2302005 defendant Sparham Robert smith 589705 589705 Sparham, Robert, of Hyndryngham, smith 0
4827524 2304656 2304656 defendant Shillyng John yeoman 589705 589705 Shillyng, John, of Hyndryngham, yeoman 3
4834495 2306797 2306797 defendant Shillyng John husbandman 589705 589705 Shillyng, John, of Hyndryngham, husbandman 2
4857693 2313786 2313786 defendant Hawe Roger yeoman 589705 589705 Hawe, Roger, of Hyndryngham, yeoman 0
4881652 2321160 2321160 defendant Morys John laborer 589705 589705 Morys, John, of Hyndryngham, laborer 5
4900112 2326664 2326664 defendant Wylbey Edward gent 589705 589705 Wylbey, Edward, of Hyndryngham, gent 0
4901146 2326976 2326976 defendant Wylby Edward gent 589705 589705 Wylby, Edward, of Hyndryngham, gent 0
4902518 2327404 2327404 defendant May John laborer 589705 589705 May, John, of Hyndryngham, laborer 1
4910334 2329750 2329750 defendant Wylbey Edward gent 589705 589705 Wylbey, Edward, of Hyndryngham, gent 0
4913923 2330862 2330862 defendant Masson John laborer 589705 589705 Masson, John, of Hyndryngham, laborer 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);