names

115 rows where place_id = 588136

✎ 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
3593489 1865597 1865597 defendant Alysaunder Thomas husbandman 588136 588136 Alysaunder, Thomas, of New Bokenham, husbandman 1
3594421 1865892 1865892 defendant Verdon John (legal representative) 588136 588136 Verdon, John, of New Bokenham, yeoman, executrix of 0
3594422 1865892 1865892 defendant Verdon Agnes widow 588136 588136 Verdon, Agnes, of New Bokenham, widow 1
3595764 1866307 1866307 defendant Boys Andrew husbandman 588136 588136 Boys, Andrew, of New Bokenham, husbandman 4
3598206 1867070 1867070 defendant Walden John yeoman 588136 588136 Walden, John, of New Bokenham, yeoman 0
3598424 1867135 1867135 defendant Ray John   588136 588136 Ray, John, of New Bokenham, paten maker 1
3627884 1903578 1903578 defendant Adams Richard husbandman 588136 588136 Adams, Richard, of New Bokenham, husbandman 1
3630138 1904273 1904273 defendant Buntyng Joan widow 588136 588136 Buntyng, Joan, of New Bokenham, widow 4
3694614 1924519 1924519 defendant Downyng Christopher carpenter 588136 588136 Downyng, Christopher, of New Bokenham, carpenter 0
3696166 1925022 1925022 defendant Puddyng Agnes widow 588136 588136 Puddyng, Agnes, of New Bokenham, widow 1
3696290 1925060 1925060 defendant Maister Simon smith 588136 588136 Maister, Simon, of New Bokenham, smith 1
3709354 1929223 1929223 defendant Adams Richard tailor 588136 588136 Adams, Richard, of New Bokenham, tailor 0
3709355 1929223 1929223 defendant Sharpyng Nicholas smith 588136 588136 Sharpyng, Nicholas, of New Bokenham, smith 1
3731717 1936150 1936150 plaintiff Churche Thomas   588136 588136 Churche, Thomas, of New Bokenham 0
3734935 1937163 1937163 defendant Puddyng Thomas   588136 588136 Puddyng, Thomas, of New Bokenham, yeoman, ezxecutors of 9
3734936 1937163 1937163 defendant Canne Bartholomew husbandman 588136 588136 (Canne, Bartholomew, of New Bokenham, husbandman 10
3735424 1937317 1937317 defendant Buntyng John husbandman 588136 588136 Buntyng, John, of New Bokenham, husbandman 0
3821483 1964613 1964613 defendant Neve Walter tanner 588136 588136 Neve, Walter, of New Bokenham, tanner 0
3831191 1967644 1967644 defendant Deynys Agnes widow 588136 588136 Deynys, Agnes, of New Bokenham, widow 4
3831211 1967649 1967649 defendant Deynys Agnes   588136 588136 Deynys, Agnes, of New Bokenham 3
3840361 1970551 1970551 defendant Branche Edward turner 588136 588136 Branche, Edward, of New Bokenham, turner 0
3876291 1982311 1982311 defendant Bronde Richard sawyer 588136 588136 Bronde, Richard, of New Bokenham, sawyer 1
3879785 1983493 1983493 defendant Dalham William yeoman 588136 588136 Dalham, William, of New Bokenham, yeoman 3
3893970 1988205 1988205 defendant Holt Ellen widow 588136 588136 Holt, Ellen, of New Bokenham, widow 2
3893975 1988206 1988206 defendant Holt Ellen widow 588136 588136 Holt, Ellen, of New Bokenham, widow 1
3895275 1988628 1988628 defendant Wylkynson Hugh gent 588136 588136 Wylkynson, Hugh, of New Bokenham, gent 0
3898169 1989593 1989593 defendant Adcok William beer brewer 588136 588136 Adcok, William, of New Bokenham, beer brewer 0
3912521 1994518 1994518 defendant Rysyng William cordwainer 588136 588136 Rysyng, William, of New Bokenham, cordwainer 0
3912522 1994518 1994518 defendant Milys Robert sherman 588136 588136 Milys, Robert, of New Bokenham, sherman 1
3931857 2000953 2000953 plaintiff Eldred John yeoman 588136 588136 Eldred, John, of New Bokenham, yeoman 0
3931859 2000954 2000954 plaintiff Eldred John yeoman 588136 588136 Eldred, John, of New Bokenham, yeoman 0
3931860 2000954 2000954 defendant Verby Henry smith 588136 588136 Verby, Henry, of New Bokenham, smith 0
3967430 2013242 2013242 defendant Robardis William yeoman 588136 588136 Robardis, William, of New Bokenham, yeoman 0
3968322 2013551 2013551 defendant Knyvett Henry esq 588136 588136 Knyvett, Henry, of New Bokenham, esq 2
3980663 2017848 2017848 defendant Rysyng Thomas shoemaker 588136 588136 Rysyng, Thomas, of New Bokenham, shoemaker 2
4029311 2035126 2035126 defendant Fennyng William clerk 588136 588136 Fennyng, William, of New Bokenham, clerk 0
4044810 2040596 2040596 defendant Gyrlyng Mathew butcher 588136 588136 Gyrlyng, Mathew, of New Bokenham, butcher 0
4052864 2043460 2043460 defendant Rysyng Robert shoemaker 588136 588136 Rysyng, Robert, of New Bokenham, shoemaker 1
4052865 2043460 2043460 defendant Gylderd William butcher 588136 588136 Gylderd, William, of New Bokenham, butcher 2
4063355 2047183 2047183 defendant Wolward Thomas carpenter 588136 588136 Wolward, Thomas, of New Bokenham, carpenter 1
4081175 2053577 2053577 defendant Ellyngham William fishmonger 588136 588136 Ellyngham, William, of New Bokenham, fishmonger 2
4452897 2185913 2185913 defendant Aylles William   588136 588136 Aylles, William, of New Bokenham 3
4505385 2202216 2202216 defendant Smyth Richard   588136 588136 Smyth, Richard, of New Bokenham 1
4522490 2207374 2207374 defendant Westherby Paul   588136 588136 Westherby, Paul, of New Bokenham 0
4533430 2210725 2210725 defendant Grene Drew   588136 588136 Grene, Drew, of New Bokenham 0
4610607 2234385 2234385 defendant Steynolf Thomas   588136 588136 Steynolf, Thomas, of New Bokenham 2
4627555 2239550 2239550 defendant Colby Richard   588136 588136 Colby, Richard, of New Bokenham 0
4627556 2239550 2239550 defendant Jolif Thomas   588136 588136 Jolif, Thomas, of New Bokenham 1
4652343 2246685 2246685 defendant Gamyn Thomas chaplain 588136 588136 Gamyn, Thomas, of New Bokenham, chaplain 0
4692810 2263262 2263262 defendant Stradyshill John husbandman 588136 588136 Stradyshill, John, of New Bokenham, husbandman 3
4715268 2270107 2270107 defendant Fyssheman Thomas husbandman 588136 588136 Fyssheman, Thomas, of New Bokenham, husbandman 1
4793238 2293980 2293980 defendant Chirm John husbandman 588136 588136 Chirm, John, of New Bokenham, husbandman 2
4825455 2304006 2304006 defendant Colby Richard husbandman 588136 588136 Colby, Richard, of New Bokenham, husbandman 0
4879392 2320484 2320484 defendant Colby Richard husbandman 588136 588136 Colby, Richard, of New Bokenham, husbandman 2
4880821 2320908 2320908 defendant atte Grene David laborer 588136 588136 atte Grene, David, of New Bokenham, laborer 3
4882932 2321581 2321581 defendant atte Grene David ploughman 588136 588136 atte Grene, David, of New Bokenham, ploughman 2
4888473 2323191 2323191 defendant Herbard Richard husbandman 588136 588136 Herbard, Richard, of New Bokenham, husbandman 2
4897877 2325996 2325996 defendant Sturmyne John yeoman 588136 588136 Sturmyne, John, of New Bokenham, yeoman 0
4925898 2334531 2334531 defendant Pydkok Thomas yeoman 588136 588136 Pydkok, Thomas, of New Bokenham, yeoman 0
4964541 2346303 2346303 defendant Wellys Thomas yeoman 588136 588136 Wellys, Thomas, of New Bokenham, yeoman 0
4984755 2352369 2352369 defendant Wellys Thomas carpenter 588136 588136 Wellys, Thomas, of New Bokenham, carpenter 0
5051421 2372039 2372039 defendant Wetherby Richard husbandman 588136 588136 Wetherby, Richard, of New Bokenham, husbandman 0
5051422 2372039 2372039 defendant Wetherby Walter singleman 588136 588136 Wetherby, Walter, of New Bokenham, singleman 1
5069325 2377315 2377315 defendant Wykes Thomas yeoman 588136 588136 Wykes, Thomas, of New Bokenham, yeoman 0
5077236 2379694 2379694 defendant Larke Edmund husbandman 588136 588136 Larke, Edmund, of New Bokenham, husbandman 0
5105435 2388029 2388029 defendant Page John smith 588136 588136 Page, John, of New Bokenham, smith 3
5111472 2389749 2389749 defendant Trewelove John husbandman 588136 588136 Trewelove, John, of New Bokenham, husbandman 3
5119750 2392216 2392216 defendant Swetman Roger barker 588136 588136 Swetman, Roger, of New Bokenham, barker 1
5124563 2393647 2393647 defendant --nberston John yeoman 588136 588136 --nberston, John, of New Bokenham, yeoman 0
5155855 2402873 2402873 defendant Hardy Robert yeoman 588136 588136 Hardy, Robert, of New Bokenham, yeoman 0
5191084 2413131 2413131 defendant Verdon Robert baker 588136 588136 Verdon, Robert, of New Bokenham, baker 0
5218043 2421013 2421013 defendant Hardy Robert yeoman 588136 588136 Hardy, Robert, of New Bokenham, yeoman 0
5218046 2421014 2421014 defendant Hardy Robert yeoman 588136 588136 Hardy, Robert, of New Bokenham, yeoman 0
5223648 2422601 2422601 defendant Wode William carpenter 588136 588136 Wode, William, of New Bokenham, carpenter 4
5240818 2427525 2427525 defendant Fader John gent 588136 588136 Fader, John, of New Bokenham, gent 0
5240820 2427525 2427525 defendant Bettys Thomas yeoman 588136 588136 Bettys, Thomas, of New Bokenham, yeoman 2
5240823 2427526 2427526 defendant Fader John gent 588136 588136 Fader, John, of New Bokenham, gent 0
5240825 2427526 2427526 defendant Bettys Thomas yeoman 588136 588136 Bettys, Thomas, of New Bokenham, yeoman 2
5240829 2427527 2427527 defendant Fader John gent 588136 588136 Fader, John, of New Bokenham, gent 1
5240831 2427527 2427527 defendant Bettys Thomas yeoman 588136 588136 Bettys, Thomas, of New Bokenham, yeoman 3
5244076 2428455 2428455 defendant Wode William carpenter 588136 588136 Wode, William, of New Bokenham, carpenter 0
5280040 2439235 2439235 defendant Glove John yeoman 588136 588136 Glove, John, of New Bokenham, yeoman 1
5299592 2444852 2444852 defendant Glove John yeoman 588136 588136 Glove, John, of New Bokenham, yeoman 0
5299596 2444853 2444853 defendant Glove John yeoman 588136 588136 Glove, John, of New Bokenham, yeoman 1
5310342 2448125 2448125 plaintiff Verdon John   588136 588136 Verdon, John, of New Bokenham 0
5310345 2448126 2448126 plaintiff Verdon John   588136 588136 Verdon, John, of New Bokenham 0
5323683 2452169 2452169 defendant Morys William baker 588136 588136 Morys, William, of New Bokenham, baker 2
5327594 2453327 2453327 defendant Ray Thomas   588136 588136 Ray, Thomas, of New Bokenham, paten maker 0
5327596 2453328 2453328 defendant Ray Thomas   588136 588136 Ray, Thomas, of New Bokenham, paten maker 0
5333442 2455075 2455075 defendant Alisaunder John husbandman 588136 588136 Alisaunder, John, of New Bokenham, husbandman 2
5334876 2455500 2455500 defendant Russhebrok William butcher 588136 588136 Russhebrok, William, of New Bokenham, butcher 3
5335348 2455641 2455641 defendant Glove John yeoman 588136 588136 Glove, John, of New Bokenham, yeoman 0
5346112 2458921 2458921 defendant Verdon John yeoman 588136 588136 Verdon, John, of New Bokenham, yeoman 2
5440982 2487211 2487211 defendant Verdon John   588136 588136 Verdon, John, of New Bokenham 2
5478714 2498658 2498658 defendant Glove John yeoman 588136 588136 Glove, John, of New Bokenham, yeoman 0
5482022 2499552 2499552 defendant Verdon John yeoman 588136 588136 Verdon, John, of New Bokenham, yeoman 0
5482112 2499588 2499588 defendant Verdon John yeoman 588136 588136 Verdon, John, of New Bokenham, yeoman 0
5493777 2503045 2503045 plaintiff Fakon Robert   588136 588136 Fakon, Robert, of New Bokenham 0
5500621 2505121 2505121 defendant Mawle John husbandman 588136 588136 Mawle, John, of New Bokenham, husbandman 0
5501485 2505399 2505399 defendant Ray John   588136 588136 Ray, John, of New Bokenham, patin maker 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);