names

107 rows where place_id = 588447

✎ 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
3594544 1865923 1865923 defendant Pey Robert   588447 588447 Pey, Robert, of Aylysham, mason 1
3594545 1865923 1865923 defendant Wattys alias Walterys Alan husbandman 588447 588447 Wattys alias Walterys, Alan, of Aylysham, husbandman 2
3605159 1869278 1869278 defendant Mayne William baker 588447 588447 Mayne, William, of Aylysham, baker 0
3605197 1869291 1869291 plaintiff Howard Richard baker 588447 588447 Howard, Richard, of Aylysham, baker 0
3605199 1869292 1869292 plaintiff Howard Richard baker 588447 588447 Howard, Richard, of Aylysham, baker 0
3605202 1869293 1869293 plaintiff Howard Richard baker 588447 588447 Howard, Richard, of Aylysham, baker 0
3620184 1873889 1873889 defendant Kyd Thomas butcher 588447 588447 Kyd, Thomas, of Aylysham, butcher 4
3622693 1874627 1874627 defendant Croppe Richard husbandman 588447 588447 Croppe, Richard, of Aylysham, husbandman 0
3654831 1911770 1911770 defendant Tylney John   588447 588447 Tylney, John, of Aylysham, worsted weaver 2
3693740 1924237 1924237 defendant Croppe Richard raffman 588447 588447 Croppe, Richard, of Aylysham, raffman 0
3767762 1947555 1947555 plaintiff Norgate Robert (legal representative) 588447 588447 Norgate, Robert, of Aylysham, mercer, executors of 0
3767767 1947555 1947555 defendant Tooke Richard husbandman 588447 588447 Tooke, Richard, of Aylysham, husbandman 0
3768045 1947641 1947641 defendant Pecke Edmund clerk 588447 588447 Pecke, Edmund, of Aylysham, clerk 0
3768046 1947641 1947641 defendant Tolwyn John yeoman 588447 588447 Tolwyn, John, of Aylysham, yeoman 1
3771603 1948818 1948818 defendant Hille Thomas, junior tanner 588447 588447 Hille, Thomas, junior, of Aylysham, tanner 0
3776612 1950430 1950430 defendant Norgate Robert (legal representative) 588447 588447 Norgate, Robert, of Aylysham, mercer, executor of 0
3776613 1950430 1950430 defendant Norgate John yeoman 588447 588447 Norgate, John, of Aylysham, yeoman 1
3786034 1953424 1953424 defendant Colet Christopher yeoman 588447 588447 Colet, Christopher, of Aylysham, yeoman 3
3789540 1954555 1954555 plaintiff Toly Nicholas   588447 588447 Toly, Nicholas, of Aylysham 0
3789541 1954555 1954555 defendant Kyng Walter baker 588447 588447 Kyng, Walter, of Aylysham, baker 0
3790534 1954863 1954863 defendant Kyng alias Anyson Walter baker 588447 588447 Kyng alias Anyson, Walter, of Aylysham, baker 0
3791593 1955210 1955210 plaintiff Wythe Edmund   588447 588447 Wythe, Edmund, of Aylysham 0
3791595 1955211 1955211 plaintiff Wythe Edmund   588447 588447 Wythe, Edmund, of Aylysham 0
3825672 1965883 1965883 defendant Pyllet John, senior husbandman 588447 588447 Pyllet, John, senior, of Aylysham, husbandman 0
3831178 1967640 1967640 defendant Caly John smith 588447 588447 Caly, John, of Aylysham, smith 1
3831188 1967644 1967644 defendant Purse John smith 588447 588447 Purse, John, of Aylysham, smith 1
3834865 1968845 1968845 defendant Welton John   588447 588447 Welton, John, of Aylysham, worsted weaver 0
3844278 1971761 1971761 defendant Cobler Andrew cobbler 588447 588447 Cobler, Andrew, of Aylysham, cobbler 2
3857764 1976066 1976066 plaintiff Barker John mercer 588447 588447 Barker, John, of Aylysham, mercer 0
3857768 1976066 1976066 defendant Passhewater John butcher 588447 588447 Passhewater, John, of Aylysham, butcher 3
3862785 1977746 1977746 plaintiff Hawkyns Robert (legal representative) 588447 588447 Hawkyns, Robert, of Aylysham, executors of 0
3862789 1977747 1977747 plaintiff Hawkyns Robert (legal representative) 588447 588447 Hawkyns, Robert, of Aylysham, executors of 0
3870467 1980364 1980364 plaintiff Clampe Edward husbandman 588447 588447 Clampe, Edward, of Aylysham, husbandman 1
3870468 1980364 1980364 defendant Wygotte Robert   588447 588447 Wygotte, Robert, of Aylysham, worsted weaver 0
3870470 1980364 1980364 defendant Passhwater John butcher 588447 588447 Passhwater, John, of Aylysham, butcher 2
3870524 1980379 1980379 defendant Palmer John husbandman 588447 588447 Palmer, John, of Aylysham, husbandman 0
3871841 1980820 1980820 plaintiff Barker John, senior   588447 588447 Barker, John, senior, of Aylysham 0
3873109 1981221 1981221 defendant Matsale alias Bocher Thomas butcher 588447 588447 Matsale alias Bocher, Thomas, of Aylysham, butcher 0
3884364 1985038 1985038 plaintiff Wyth Edmund, senior   588447 588447 Wyth, Edmund, senior, of Aylysham 0
3896440 1989015 1989015 defendant Damyett Richard   588447 588447 Damyett, Richard, of Aylysham, wool chapman 0
3896441 1989015 1989015 defendant Drory Henry   588447 588447 Drory, Henry, of Aylysham, ploughwright 1
3898511 1989715 1989715 defendant Woode John (legal representative) 588447 588447 Woode, John, of Aylysham, yeoman, executors of 1
3906398 1992429 1992429 plaintiff Marsham Robert   588447 588447 Marsham, Robert, of Aylysham 0
3906400 1992430 1992430 plaintiff Marsham Robert   588447 588447 Marsham, Robert, of Aylysham 0
3913098 1994712 1994712 plaintiff Barker Henry mercer 588447 588447 Barker, Henry, of Aylysham, mercer 0
3924216 1998409 1998409 plaintiff Thirkyll Nicholas clerk 588447 588447 Thirkyll, Nicholas, of Aylysham, clerk 0
3939308 2003452 2003452 defendant Marsham Robert   588447 588447 Marsham, Robert, of Aylysham, worsted weaver 0
3957833 2009801 2009801 defendant Mundy Thomas miller 588447 588447 Mundy, Thomas, of Aylysham, husbandman, miller 0
3968274 2013533 2013533 defendant Woodward John mercer 588447 588447 Woodward, John, of Aylysham, or of Wymondham, mercer 0
3968437 2013594 2013594 plaintiff Churche Robert yeoman 588447 588447 Churche, Robert, of Aylysham, yeoman 0
3985281 2019495 2019495 plaintiff Tyler Henry   588447 588447 Tyler, Henry, of Aylysham 0
4003398 2025978 2025978 plaintiff Horne Christopher yeoman 588447 588447 Horne, Christopher, of Aylysham, yeoman 0
4015030 2030074 2030074 defendant Moneyman William yeoman 588447 588447 Moneyman, William, of Aylysham, yeoman 6
4041912 2039594 2039594 plaintiff Oldeman Robert   588447 588447 Oldeman, Robert, of Aylysham 0
4041964 2039615 2039615 defendant Barker John husbandman 588447 588447 Barker, John, of Aylysham, husbandman 0
4041967 2039615 2039615 defendant Gylles John laborer 588447 588447 Gylles, John, of Aylysham, laborer 3
4049413 2042236 2042236 plaintiff Tyler George thatcher 588447 588447 Tyler, George, of Aylysham, thatcher 0
4086669 2055521 2055521 defendant Stowe John shoemaker 588447 588447 Stowe, John, of Aylysham, shoemaker 0
4088823 2056303 2056303 defendant Gyles John husbandman 588447 588447 Gyles, John, of Aylysham, husbandman 2
4088825 2056303 2056303 defendant Leman William skinner 588447 588447 Leman, William, of Aylysham, skinner 4
4115922 2065981 2065981 defendant Harte William baker 588447 588447 Harte, William, of Aylysham, baker 0
4139871 2074626 2074626 defendant Woodwarde John yeoman 588447 588447 Woodwarde, John, of Aylysham, yeoman 0
4184738 2090170 2090170 defendant Towtell alias Towtyng John yeoman 588447 588447 Towtell alias Towtyng, John, of Aylysham, yeoman 0
4256775 2115239 2115239 defendant Smyth Thomas scrivener 588447 588447 Smyth, Thomas, of Aylysham, yeoman, scrivener 0
4474470 2192675 2192675 defendant Edlyns Thomas   588447 588447 Edlyns, Thomas, of Aylysham 0
4775310 2288270 2288270 defendant Pekke Robert cooper 588447 588447 Pekke, Robert, of Aylysham, cooper 1
4775313 2288270 2288270 defendant Symkyns John yeoman 588447 588447 Symkyns, John, of Aylysham, yeoman 4
4888127 2323091 2323091 defendant Symkyns John yeoman 588447 588447 Symkyns, John, of Aylysham, yeoman 5
5024044 2363943 2363943 defendant Felys William yeoman 588447 588447 Felys, William, of Aylysham, yeoman 0
5274480 2437615 2437615 defendant Kyppyng John husbandman 588447 588447 Kyppyng, John, of Aylysham, husbandman 0
5279379 2439055 2439055 defendant Boon Thomas yeoman 588447 588447 Boon, Thomas, of Aylysham, yeoman 5
5288337 2441610 2441610 defendant Fewterer John hosier 588447 588447 Fewterer, John, of Aylysham, hosier 0
5295620 2443710 2443710 defendant Skyppyng Thomas yeoman 588447 588447 Skyppyng, Thomas, of Aylysham, yeoman 0
5295622 2443710 2443710 defendant Elyat William husbandman 588447 588447 Elyat, William, of Aylysham, husbandman 2
5325054 2452574 2452574 defendant Abbis or Abbot Thomas carpenter 588447 588447 Abbis or Abbot, Thomas, of Aylysham, carpenter 0
5325055 2452574 2452574 defendant Steyn or Steyner Peter husbandman 588447 588447 Steyn or Steyner, Peter, of Aylysham, husbandman 1
5325057 2452575 2452575 defendant Abbys or Abbot Thomas carpenter 588447 588447 Abbys or Abbot, Thomas, of Aylysham, carpenter 0
5325058 2452575 2452575 defendant Steyn Peter husbandman 588447 588447 Steyn, Peter, of Aylysham, husbandman 1
5355669 2461848 2461848 defendant Bettys Simon laborer 588447 588447 Bettys, Simon, of Aylysham, laborer 4
5374159 2467514 2467514 plaintiff Neuman Robert   588447 588447 Neuman, Robert, of Aylysham 0
5424733 2482355 2482355 defendant Emondys William laborer 588447 588447 Emondys, William, of Aylysham, laborer 4
5445218 2488463 2488463 plaintiff Egremond John   588447 588447 Egremond, John, of Aylysham 0
5450472 2490027 2490027 defendant Skyppyng Thomas yeoman 588447 588447 Skyppyng, Thomas, of Aylysham, yeoman 0
5450473 2490027 2490027 defendant Elreed John husbandman 588447 588447 Elreed, John, of Aylysham, husbandman 1
5450474 2490027 2490027 defendant Elyot William husbandman 588447 588447 Elyot, William, of Aylysham, husbandman 2
5450475 2490027 2490027 defendant Wattys Robert husbandman 588447 588447 Wattys, Robert, of Aylysham, husbandman 3
5454904 2491384 2491384 defendant Wattys Robert husbandman 588447 588447 Wattys, Robert, of Aylysham, husbandman 0
5466752 2495003 2495003 defendant Wattys Robert husbandman 588447 588447 Wattys, Robert, of Aylysham, husbandman 0
5474159 2497246 2497246 defendant Elyot William husbandman 588447 588447 Elyot, William, of Aylysham, husbandman 2
5474160 2497246 2497246 defendant Watttys Robert husbandman 588447 588447 Watttys, Robert, of Aylysham, husbandman 3
5474166 2497247 2497247 defendant Skyppyng Thomas yeoman 588447 588447 Skyppyng, Thomas, of Aylysham, yeoman 0
5474167 2497247 2497247 defendant Elreed John husbandman 588447 588447 Elreed, John, of Aylysham, husbandman 1
5474168 2497247 2497247 defendant Elyot William husbandman 588447 588447 Elyot, William, of Aylysham, husbandman 2
5474169 2497247 2497247 defendant Wattys Robert husbandman 588447 588447 Wattys, Robert, of Aylysham, husbandman 3
5479166 2498791 2498791 defendant Emondys William yeoman 588447 588447 Emondys, William, of Aylysham, yeoman 4
5498584 2504519 2504519 defendant Keade Thomas butcher 588447 588447 Keade, Thomas, of Aylysham, butcher 2
5513750 2509155 2509155 defendant Wattys alias Walters Robert husbandman 588447 588447 Wattys alias Walters, Robert, of Aylysham, husbandman 0
5529401 2513709 2513709 plaintiff Pekke Edward (legal representative) 588447 588447 Pekke, Edward, of Aylysham, clerk, executors of 0
5529404 2513709 2513709 defendant Medowe Edward husbandman 588447 588447 Medowe, Edward, of Aylysham, husbandman 0
5553838 2521161 2521161 plaintiff Gylys John   588447 588447 Gylys, John, of Aylysham, freemason 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);