names

101 rows where place_id = 596344

✎ 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
3624320 1875140 1875140 defendant Trendyll Edmund barber 596344 596344 Trendyll, Edmund, of Stoke juxta Neylond, barber 1
3627599 1903491 1903491 defendant Markys John yeoman 596344 596344 Markys, John, of Stoke juxta Neylond, yeoman 0
3631307 1904602 1904602 defendant Smyth Joan widow 596344 596344 (Smyth, Joan, of Stoke juxta Neylond, widow 15
3652536 1911125 1911125 defendant Gaunte John husbandman 596344 596344 Gaunte, John, of Stoke juxta Neylond, husbandman 0
3669085 1916264 1916264 defendant Hacche John husbandman 596344 596344 Hacche, John, of Stoke juxta Neylond, husbandman 1
3674464 1918061 1918061 defendant Hewet John merchant 596344 596344 Hewet, John, of Stoke juxta Neylond, merchant 3
3675012 1918214 1918214 defendant Leche Robert yeoman 596344 596344 Leche, Robert, of Stoke juxta Neylond, yeoman 0
3676065 1918549 1918549 defendant Wellys John husbandman 596344 596344 Wellys, John, of Stoke juxta Neylond, husbandman 2
3707605 1928676 1928676 defendant Armond Edmund tailor 596344 596344 Armond, Edmund, of Stoke juxta Neylond, tailor 1
3718731 1932136 1932136 defendant Armond Robert tailor 596344 596344 Armond, Robert, of Stoke juxta Neylond, tailor 1
3746733 1940894 1940894 defendant Brett Thomas butcher 596344 596344 Brett, Thomas, of Stoke juxta Neylond, butcher 1
3755449 1943658 1943658 defendant Crane John clothmaker 596344 596344 Crane, John, of Stoke juxta Neylond, clothmaker 0
3755450 1943658 1943658 defendant Armond Edward tailor 596344 596344 Armond, Edward, of Stoke juxta Neylond, tailor 1
3755987 1943826 1943826 defendant Barnard John husbandman 596344 596344 Barnard, John, of Stoke juxta Neylond, husbandman 4
3759744 1945040 1945040 defendant Leme William husbandman 596344 596344 Leme, William, of Stoke juxta Neylond, husbandman 0
3769656 1948167 1948167 defendant Porter Robert husbandman 596344 596344 Porter, Robert, of Stoke juxta Neylond, husbandman 0
3778702 1951055 1951055 defendant Reynold John yeoman 596344 596344 Reynold, John, of Stoke juxta Neylond, yeoman 0
3788583 1954228 1954228 defendant Brett Thomas butcher 596344 596344 Brett, Thomas, of Stoke juxta Neylond, butcher 0
3788584 1954228 1954228 defendant Brette Robert butcher 596344 596344 Brette, Robert, of Stoke juxta Neylond, butcher 1
3800857 1958177 1958177 defendant Pyknott Thomas weaver 596344 596344 Pyknott, Thomas, of Stoke juxta Neylond, weaver 0
3809105 1960731 1960731 defendant Benett Thomas smith 596344 596344 Benett, Thomas, of Stoke juxta Neylond, smith 0
3809106 1960731 1960731 defendant Bannam Edmund laborer 596344 596344 Bannam, Edmund, of Stoke juxta Neylond, laborer 1
3813741 1962210 1962210 defendant Stranton Robert carpenter 596344 596344 Stranton, Robert, of Stoke juxta Neylond, carpenter 0
3813816 1962234 1962234 defendant Crane John weaver 596344 596344 Crane, John, of Stoke juxta Neylond, weaver 1
3826175 1966028 1966028 defendant Scranton Robert carpenter 596344 596344 Scranton, Robert, of Stoke juxta Neylond, carpenter 0
3830768 1967506 1967506 defendant Stranton Robert carpenter 596344 596344 Stranton, Robert, of Stoke juxta Neylond, carpenter 0
3859954 1976832 1976832 defendant Webbe Henry clothmaker 596344 596344 Webbe, Henry, of Stoke juxta Neylond, clothmaker 2
3859955 1976832 1976832 defendant Erilion Edmund tailor 596344 596344 Erilion, Edmund, of Stoke juxta Neylond, tailor 3
3867527 1979377 1979377 defendant Parson John husbandman 596344 596344 Parson, John, of Stoke juxta Neylond, husbandman 0
3898107 1989574 1989574 defendant Mylles John husbandman 596344 596344 Mylles, John, of Stoke juxta Neylond, husbandman 2
3898108 1989574 1989574 defendant Mylles Richard husbandman 596344 596344 Mylles, Richard, of Stoke juxta Neylond, husbandman 3
3905227 1992011 1992011 defendant Sutton Alice widow 596344 596344 Sutton, Alice, of Stoke juxta Neylond, widow 0
3905723 1992192 1992192 defendant Cuttyng John carpenter 596344 596344 Cuttyng, John, of Stoke juxta Neylond, carpenter 1
3909704 1993554 1993554 defendant Leme William butcher 596344 596344 Leme, William, of Stoke juxta Neylond, butcher 2
3994659 2022842 2022842 defendant Parker Thomas clothier 596344 596344 Parker, Thomas, of Stoke juxta Neylond, clothier 1
4021785 2032521 2032521 defendant Garrard John yeoman 596344 596344 Garrard, John, of Stoke juxta Neylond, yeoman 0
4247474 2112139 2112139 defendant Goodale Richard husbandman 596344 596344 Goodale, Richard, of Stoke juxta Neylond, husbandman 0
4857519 2313739 2313739 defendant Mannok Thomas ploughman 596344 596344 Mannok, Thomas, of Stoke juxta Neylond, ploughman 0
4870451 2317729 2317729 defendant Bolthood John dyer 596344 596344 Bolthood, John, of Stoke juxta Neylond, dyer 3
4871385 2318019 2318019 defendant Berner John yeoman 596344 596344 Berner, John, of Stoke juxta Neylond, yeoman 3
4871403 2318022 2318022 defendant Coker Thomas yeoman 596344 596344 Coker, Thomas, of Stoke juxta Neylond, yeoman 3
4894813 2325045 2325045 defendant Howard John   596344 596344 (Howard, John, of Stoke juxta Neylond, knight 1
5027346 2364873 2364873 defendant Wyllys John laborer 596344 596344 Wyllys, John, of Stoke juxta Neylond, laborer 0
5032793 2366478 2366478 defendant Leyll Thomas dyer 596344 596344 Leyll, Thomas, of Stoke juxta Neylond, dyer 0
5032794 2366478 2366478 defendant Tebold John dyer 596344 596344 Tebold, John, of Stoke juxta Neylond, dyer 1
5032795 2366478 2366478 defendant Tebaud John dyer 596344 596344 Tebaud, John, of Stoke juxta Neylond, dyer 2
5033426 2366657 2366657 defendant Halstede Robert smith 596344 596344 Halstede, Robert, of Stoke juxta Neylond, smith 2
5058736 2374178 2374178 plaintiff Debenham Richard   596344 596344 Debenham, Richard, of Stoke juxta Neylond 0
5058738 2374179 2374179 plaintiff Debynham Richard   596344 596344 Debynham, Richard, of Stoke juxta Neylond 0
5074074 2378738 2378738 defendant Mannok John esq 596344 596344 Mannok, John, of Stoke juxta Neylond, esq 0
5077655 2379813 2379813 plaintiff Bolthood John (legal representative) 596344 596344 Bolthood, John, of Stoke juxta Neylond, woodier, executors of 0
5082147 2381153 2381153 defendant Baker Thomas husbandman 596344 596344 Baker, Thomas, of Stoke juxta Neylond, husbandman 0
5089724 2383369 2383369 defendant Rollesmyth Thomas husbandman 596344 596344 Rollesmyth, Thomas, of Stoke juxta Neylond, husbandman 2
5101349 2386806 2386806 defendant Halsted Robert smith 596344 596344 Halsted, Robert, of Stoke juxta Neylond, smith 0
5107544 2388637 2388637 defendant Halstede Robert smith 596344 596344 Halstede, Robert, of Stoke juxta Neylond, smith 1
5111337 2389707 2389707 defendant Halsted Robert smith 596344 596344 Halsted, Robert, of Stoke juxta Neylond, smith 2
5114628 2390692 2390692 defendant Fynche William yeoman 596344 596344 Fynche, William, of Stoke juxta Neylond, yeoman 0
5115677 2391013 2391013 defendant Hatche William husbandman 596344 596344 Hatche, William, of Stoke juxta Neylond, husbandman 0
5115865 2391068 2391068 defendant Hamond William fuller 596344 596344 Hamond, William, of Stoke juxta Neylond, fuller 1
5119413 2392104 2392104 defendant Moleyns Thomas gent 596344 596344 Moleyns, Thomas, of Stoke juxta Neylond, gent 1
5223380 2422531 2422531 defendant Mannok John esq 596344 596344 Mannok, John, of Stoke juxta Neylond, esq 0
5231552 2424811 2424811 defendant Smyth Hugh yeoman 596344 596344 Smyth, Hugh, of Stoke juxta Neylond, yeoman 1
5267069 2435459 2435459 defendant Cranewys John clerk 596344 596344 (Cranewys, John, of Stoke juxta Neylond, clerk 1
5279318 2439044 2439044 defendant Smyth Robert weaver 596344 596344 Smyth, Robert, of Stoke juxta Neylond, weaver 0
5282457 2439930 2439930 defendant Man Thomas baker 596344 596344 Man, Thomas, of Stoke juxta Neylond, baker 1
5282984 2440084 2440084 defendant Man Thomas baker 596344 596344 Man, Thomas, of Stoke juxta Neylond, baker 1
5284054 2440357 2440357 defendant Halke Robert weaver 596344 596344 Halke, Robert, of Stoke juxta Neylond, weaver 2
5293785 2443146 2443146 defendant Mannok Robert yeoman 596344 596344 Mannok, Robert, of Stoke juxta Neylond, yeoman 2
5294151 2443261 2443261 plaintiff Sergeaunt Robert   596344 596344 Sergeaunt, Robert, of Stoke juxta Neylond 1
5296747 2444038 2444038 defendant Smyth Robert, junior weaver 596344 596344 Smyth, Robert, junior, of Stoke juxta Neylond, weaver 0
5316198 2449927 2449927 defendant Neuman Robert weaver 596344 596344 Neuman, Robert, of Stoke juxta Neylond, weaver 0
5320783 2451306 2451306 defendant Shene William smith 596344 596344 Shene, William, of Stoke juxta Neylond, smith 1
5320785 2451306 2451306 defendant Baker Robert baker 596344 596344 Baker, Robert, of Stoke juxta Neylond, baker 3
5354136 2461358 2461358 defendant Hawe Richard clothmaker 596344 596344 Hawe, Richard, of Stoke juxta Neylond, clothmaker 3
5364045 2464412 2464412 defendant Sergeaunt Robert, junior clothman 596344 596344 Sergeaunt, Robert, junior, of Stoke juxta Neylond, clothman 2
5483557 2500031 2500031 defendant Humfrey Richard barker 596344 596344 Humfrey, Richard, of Stoke juxta Neylond, barker 0
5489060 2501606 2501606 defendant Reve John laborer 596344 596344 Reve, John, of Stoke juxta Neylond, laborer 0
5489061 2501606 2501606 defendant Shytte Thomas laborer 596344 596344 Shytte, Thomas, of Stoke juxta Neylond, laborer 1
5491428 2502321 2502321 defendant Sergeaunt Robert yeoman 596344 596344 Sergeaunt, Robert, of Stoke juxta Neylond, yeoman 1
5498791 2504577 2504577 defendant Porter Robert husbandman 596344 596344 Porter, Robert, of Stoke juxta Neylond, husbandman 0
5504307 2506261 2506261 defendant Broun Thomas painter 596344 596344 Broun, Thomas, of Stoke juxta Neylond, painter 4
5504753 2506405 2506405 defendant Debenham John clothmaker 596344 596344 Debenham, John, of Stoke juxta Neylond, clothmaker 1
5504755 2506406 2506406 defendant Reve John laborer 596344 596344 Reve, John, of Stoke juxta Neylond, laborer 0
5504756 2506406 2506406 defendant Shytte Thomas laborer 596344 596344 Shytte, Thomas, of Stoke juxta Neylond, laborer 1
5509735 2507875 2507875 defendant Dowe George dyer 596344 596344 Dowe, George, of Stoke juxta Neylond, dyer 0
5519175 2510841 2510841 defendant Wyllys John baker 596344 596344 Wyllys, John, of Stoke juxta Neylond, baker 2
5531051 2514227 2514227 plaintiff Sergeant Robert (legal representative) 596344 596344 Sergeant, Robert, of Stoke juxta Neylond, weaver, executors of 0
5539869 2516949 2516949 defendant Dwyte John husbandman 596344 596344 Dwyte, John, of Stoke juxta Neylond, husbandman 0
5541915 2517589 2517589 defendant Nicoll Thomas clothmaker 596344 596344 Nicoll, Thomas, of Stoke juxta Neylond, clothmaker 0
5542967 2517920 2517920 plaintiff Nicoll John yeoman 596344 596344 Nicoll, John, of Stoke juxta Neylond, yeoman 0
5542969 2517921 2517921 plaintiff Nicoll John yeoman 596344 596344 Nicoll, John, of Stoke juxta Neylond, yeoman 0
5568708 2525398 2525398 defendant Waryn William thatcher 596344 596344 Waryn, William, of Stoke juxta Neylond, thatcher 0
5569132 2525522 2525522 defendant Nuthall Thomas husbandman 596344 596344 Nuthall, Thomas, of Stoke juxta Neylond, husbandman 2
5569139 2525524 2525524 defendant Nuoll Thomas husbandman 596344 596344 Nuoll, Thomas, of Stoke juxta Neylond, husbandman 3
5574461 2527096 2527096 defendant Smyth Robert husbandman 596344 596344 Smyth, Robert, of Stoke juxta Neylond, husbandman 0
5574496 2527106 2527106 defendant Smyth Robert husbandman 596344 596344 Smyth, Robert, of Stoke juxta Neylond, husbandman 0
5582965 2529746 2529746 defendant Hewett John merchant 596344 596344 Hewett, John, of Stoke juxta Neylond, merchant 0
5586377 2530782 2530782 defendant Huett John merchant 596344 596344 Huett, John, of Stoke juxta Neylond, merchant 0
5589743 2531787 2531787 defendant Hewet John merchant 596344 596344 Hewet, John, of Stoke juxta Neylond, merchant 0
5591953 2532471 2532471 defendant Gosse William husbandman 596344 596344 Gosse, William, of Stoke juxta Neylond, husbandman 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);