names

58 rows where place_id = 616407

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3714217 1930745 1930745 defendant Webbe Nicholas miller 616407 616407 Webbe, Nicholas, of Wylmyngton, miller 1
3785929 1953394 1953394 defendant Goodborowe Stephen husbandman 616407 616407 Goodborowe, Stephen, of Wylmyngton, husbandman 2
3807753 1960311 1960311 defendant Grene James yeoman 616407 616407 Grene, James, of Wylmyngton, yeoman 4
3992999 2022242 2022242 defendant Purchase William smith 616407 616407 Purchase, William, of Wylmyngton, smith 15
4077591 2052274 2052274 defendant Wenham William butcher 616407 616407 Wenham, William, of Wylmyngton, or of Lewes, butcher 0
4087074 2055670 2055670 defendant Wysall William clerk 616407 616407 Wysall, William, of Wylmyngton, clerk 0
4107067 2062821 2062821 defendant Wysall William clerk 616407 616407 Wysall, William, of Wylmyngton, clerk 0
4136556 2073418 2073418 defendant Wade Edmund yeoman 616407 616407 Wade, Edmund, of Wylmyngton, yeoman 1
4140544 2074860 2074860 defendant Wysehall William clerk 616407 616407 Wysehall, William, of Wylmyngton, clerk 0
4169962 2084987 2084987 defendant Watt Thomas laborer 616407 616407 Watt, Thomas, of Wylmyngton, laborer 3
4173619 2086227 2086227 defendant Dufford John yeoman 616407 616407 Dufford, John, of Wylmyngton, yeoman 0
4184218 2089976 2089976 defendant Carpenter William husbandman 616407 616407 Carpenter, William, of Wylmyngton, husbandman 1
4189010 2091640 2091640 defendant George Robert husbandman 616407 616407 George, Robert, of Wylmyngton, husbandman 3
4227242 2105007 2105007 defendant Wrenne or Renne John   616407 616407 Wrenne or Renne, John, of Wylmyngton husbandman 1
4227243 2105007 2105007 defendant Goodwyn Walter husbandman 616407 616407 Goodwyn, Walter, of Wylmyngton, husbandman 2
4229903 2105941 2105941 defendant Marshall Thomas yeoman 616407 616407 Marshall, Thomas, of Wylmyngton, yeoman 0
4267822 2118872 2118872 defendant Wrenne John husbandman 616407 616407 Wrenne, John, of Wylmyngton, husbandman 1
4267823 2118872 2118872 defendant Goodwyn Walter husbandman 616407 616407 Goodwyn, Walter, of Wylmyngton, husbandman 2
4363444 2152000 2152000 defendant Gladherst Henry husbandman 616407 616407 Gladherst, Henry, of Wylmyngton, husbandman 1
4363445 2152000 2152000 defendant Bowrman James laborer 616407 616407 Bowrman, James, of Wylmyngton, laborer 2
4363446 2152000 2152000 defendant Strelley Richard laborer 616407 616407 Strelley, Richard, of Wylmyngton, laborer 3
4363447 2152000 2152000 defendant Polley Richard laborer 616407 616407 Polley, Richard, of Wylmyngton, laborer 4
4363448 2152000 2152000 defendant Kyrke Martin laborer 616407 616407 Kyrke, Martin, of Wylmyngton, laborer 5
4364210 2152257 2152257 defendant Coplande John husbandman 616407 616407 Coplande, John, of Wylmyngton, husbandman 0
4584647 2226618 2226618 defendant Bodman John   616407 616407 Bodman, John, of Wylmyngton 0
4646873 2245147 2245147 defendant atte Welle William   616407 616407 atte Welle, William, of Wylmyngton 5
4656487 2247925 2247925 defendant Sutton Richard laborer 616407 616407 Sutton, Richard, of Wylmyngton, laborer 0
4664566 2250397 2250397 defendant Osbarn Thomas   616407 616407 Osbarn, Thomas, of Wylmyngton, "cornleder" 1
4667537 2255565 2255565 defendant Rouberd Simon husbandman 616407 616407 Rouberd, Simon, of Wylmyngton, husbandman 4
4683104 2260330 2260330 defendant Sutton Richard butcher 616407 616407 Sutton, Richard, of Wylmyngton, butcher 2
4851304 2311854 2311854 defendant Pynsoule John   616407 616407 Pynsoule, John, of Wylmyngton, tile maker 1
4871876 2318178 2318178 defendant Balon Clemence   616407 616407 Balon, Clemence, of Wylmyngton, widow of Balon, John 0
4872884 2318472 2318472 defendant Marys John husbandman 616407 616407 Marys, John, of Wylmyngton, husbandman 0
4882447 2321422 2321422 defendant Lucy Robert tanner 616407 616407 Lucy, Robert, of Wylmyngton, tanner 1
4882448 2321422 2321422 defendant Rycheman Robert husbandman 616407 616407 Rycheman, Robert, of Wylmyngton, husbandman 2
4920540 2332935 2332935 defendant Lok (illegible) yeoman 616407 616407 Lok, ---, of Wylmyngton, yeoman 2
4970776 2348201 2348201 defendant Safford John husbandman 616407 616407 Safford, John, of Wylmyngton, husbandman 0
5022727 2363559 2363559 defendant Markeley John husbandman 616407 616407 Markeley, John, of Wylmyngton, husbandman 0
5052526 2372347 2372347 defendant Fanceby or Fauceby John husbandman 616407 616407 Fanceby or Fauceby, John, of Wylmyngton, husbandman 3
5109896 2389322 2389322 defendant Clerk Thomas (legal representative) 616407 616407 Clerk, Thomas, of Wylmyngton, husbandman, executrix of 2
5109897 2389322 2389322 defendant Clerk Agnes widow 616407 616407 Clerk, Agnes, of Wylmyngton, widow 3
5263914 2434473 2434473 defendant atte Bern Stephen husbandman 616407 616407 atte Bern, Stephen, of Wylmyngton, husbandman 0
5263915 2434473 2434473 defendant atte Bern Thomas husbandman 616407 616407 atte Bern, Thomas, of Wylmyngton, husbandman 1
5263917 2434474 2434474 defendant atte Bern Stephen husbandman 616407 616407 atte Bern, Stephen, of Wylmyngton, husbandman 0
5263918 2434474 2434474 defendant atte Bern Thomas husbandman 616407 616407 atte Bern, Thomas, of Wylmyngton, husbandman 1
5278246 2438735 2438735 defendant Mobbys William husbandman 616407 616407 Mobbys, William, of Wylmyngton, husbandman 1
5307218 2447160 2447160 defendant Clerke William yeoman 616407 616407 Clerke, William, of Wylmyngton, yeoman 0
5319231 2450845 2450845 defendant Paslade William carpenter 616407 616407 Paslade, William, of Wylmyngton, carpenter 0
5339642 2456972 2456972 defendant Goodboure Thomas husbandman 616407 616407 Goodboure, Thomas, of Wylmyngton, husbandman 2
5349057 2459832 2459832 defendant Laury Thomas yeoman 616407 616407 Laury, Thomas, of Wylmyngton, yeoman 0
5383789 2470447 2470447 defendant Aleyn John husbandman 616407 616407 Aleyn, John, of Wylmyngton, husbandman 0
5395615 2473826 2473826 defendant Aleyn alias Telyng John husbandman 616407 616407 Aleyn alias Telyng, John, of Wylmyngton, husbandman 0
5537580 2516243 2516243 defendant Goudborowe John yeoman 616407 616407 Goudborowe, John, of Wylmyngton, yeoman 0
5540686 2517216 2517216 defendant Clerke John yeoman 616407 616407 Clerke, John, of Wylmyngton, yeoman 0
5540688 2517217 2517217 defendant Clerke John yeoman 616407 616407 Clerke, John, of Wylmyngton, yeoman 0
5560498 2523030 2523030 defendant Godbour John, senior yeoman 616407 616407 Godbour, John, senior, of Wylmyngton, yeoman 0
5566951 2524929 2524929 defendant Lambe Thomas husbandman 616407 616407 Lambe, Thomas, of Wylmyngton, husbandman 2
5588531 2531418 2531418 defendant Lambe Thomas yeoman 616407 616407 Lambe, Thomas, of Wylmyngton, yeoman 1

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