names

89 rows where place_id = 593335

✎ 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
3611379 1871232 1871232 defendant Carnaby John yeoman 593335 593335 Carnaby, John, of Toft, yeoman 0
3611381 1871233 1871233 defendant Carnaby John yeoman 593335 593335 Carnaby, John, of Toft, yeoman 0
3646658 1909359 1909359 defendant Westmylls William fisher 593335 593335 Westmylls, William, of Toft, fisher 0
3661147 1913765 1913765 plaintiff Johnson William yeoman 593335 593335 Johnson, William, of Toft, yeoman 0
3706179 1928222 1928222 defendant Baesley George husbandman 593335 593335 Baesley, George, of Toft, husbandman 2
3712107 1930104 1930104 defendant Jelle John (legal representative) 593335 593335 Jelle, John, of Toft, husbandman, executors of 0
3712109 1930104 1930104 defendant Broun Robert husbandman 593335 593335 Broun, Robert, of Toft, husbandman 2
3727524 1934887 1934887 defendant Baxster Roland clerk 593335 593335 Baxster, Roland, of Toft, clerk 0
3745686 1940558 1940558 defendant Johnson Richard yeoman 593335 593335 Johnson, Richard, of Toft, yeoman 1
3767576 1947496 1947496 plaintiff Nevet David gent 593335 593335 Nevet, David, of Toft, gent 0
3777342 1950658 1950658 defendant Kene Thomas yeoman 593335 593335 Kene, Thomas, of Toft, yeoman 0
3809770 1960943 1960943 defendant Tomson John husbandman 593335 593335 Tomson, John, of Toft, husbandman 2
3836120 1969212 1969212 plaintiff Pynchebek John (legal representative) 593335 593335 Pynchebek, John, of Toft, chaplain, executors of 0
3896462 1989022 1989022 defendant Paynell Thomas gent 593335 593335 Paynell, Thomas, of Toft, gent 0
3917424 1996186 1996186 defendant Dalymont John husbandman 593335 593335 Dalymont, John, of Toft, husbandman 0
4021056 2032253 2032253 defendant Cooke Anthony carpenter 593335 593335 Cooke, Anthony, of Toft, carpenter 1
4069191 2049274 2049274 plaintiff Leicester Ralph (legal representative) 593335 593335 Leicester, Ralph, of Toft, knight, executors of 0
4200282 2095651 2095651 defendant Baspoole William yeoman 593335 593335 Baspoole, William, of Toft, yeoman 0
4214756 2100667 2100667 defendant Beamont Thomas yeoman 593335 593335 Beamont, Thomas, of Toft, yeoman 3
4222737 2103442 2103442 defendant Whitehurste John yeoman 593335 593335 Whitehurste, John, of Toft, yeoman 3
4386224 2160071 2160071 defendant Bradshawe James gent 593335 593335 Bradshawe, James, of Toft, gent 1
4418627 2170697 2170697 defendant Clyve Nicholas   593335 593335 Clyve, Nicholas, of Toft 0
4426732 2173175 2173175 plaintiff Petite Robert   593335 593335 Petite, Robert, of Toft, son of Robert 0
4426733 2173175 2173175 defendant Horn Simon   593335 593335 Horn, Simon, of Toft 0
4426735 2173175 2173175 defendant Gardyner John   593335 593335 Gardyner, John, of Toft 2
4426736 2173175 2173175 defendant Erlyn Roger   593335 593335 Erlyn, Roger, of Toft 3
4429396 2174000 2174000 plaintiff Wace Gilbert   593335 593335 Wace, Gilbert, of Toft 0
4458155 2187586 2187586 plaintiff Purchas Geoffrey   593335 593335 Purchas, Geoffrey, of Toft, parson 0
4489511 2197441 2197441 plaintiff Toft Thomas de   593335 593335 Toft, Thomas de, of Toft 0
4501146 2200961 2200961 defendant Williamson Thomas   593335 593335 Williamson, Thomas, of Toft 1
4512082 2204220 2204220 defendant Clerk Hugh   593335 593335 Clerk, Hugh, of Toft 2
4519155 2206343 2206343 defendant Raulyn John   593335 593335 Raulyn, John, of Toft 0
4538939 2212451 2212451 defendant Holand John   593335 593335 Holand, John, of Toft 0
4541660 2213287 2213287 defendant Horne Simon   593335 593335 Horne, Simon, of Toft 0
4544123 2214076 2214076 plaintiff Barby Henry chaplain 593335 593335 Barby, Henry, of Toft, chaplain 0
4544810 2214295 2214295 plaintiff Bekton (illegible)   593335 593335 Bekton, _, of Toft 0
4610908 2234485 2234485 plaintiff Wassyngton John   593335 593335 Wassyngton, John, of Toft, parson 3
4623682 2238383 2238383 plaintiff Midelton Joan   593335 593335 Midelton, Joan, of Toft, formerly wife of John 0
4658088 2248410 2248410 defendant Aleynem William maltman 593335 593335 Aleynem William, of Toft, maltman 1
4658090 2248411 2248411 defendant Aleyne Geoffrey maltman 593335 593335 Aleyne, Geoffrey, of Toft, maltman 0
4658091 2248411 2248411 defendant Alayne William maltman 593335 593335 Alayne, William, of Toft, maltman 1
4677276 2258510 2258510 plaintiff Carter Thomas   593335 593335 Carter, Thomas, of Toft 1
4687815 2261759 2261759 defendant Auncell John clerk 593335 593335 Auncell, John, of Toft, clerk 2
4697976 2264860 2264860 defendant Kymbell Nicholas esq 593335 593335 Kymbell, Nicholas, of Toft, esq 0
4697977 2264860 2264860 defendant Aleyn Robert husbandman 593335 593335 Aleyn, Robert, of Toft, husbandman 1
4710405 2268608 2268608 defendant Aleyn John maltman 593335 593335 Aleyn, John, of Toft, maltman 1
4713582 2269569 2269569 defendant ruston Robert yeoman 593335 593335 ruston, Robert, of Toft, yeoman 1
4735292 2276186 2276186 defendant Partenay John chaplain 593335 593335 Partenay, John, of Toft, chaplain 0
4764017 2284732 2284732 defendant Lumbard Thomas husbandman 593335 593335 Lumbard, Thomas, of Toft, husbandman 0
4764018 2284732 2284732 defendant Clevye John husbandman 593335 593335 Clevye, John, of Toft, husbandman 1
4777285 2288885 2288885 defendant Hygdon Roger chaplain 593335 593335 Hygdon, Roger, of Toft, chaplain 0
4782722 2290611 2290611 defendant Aleyn John, junior husbandman 593335 593335 Aleyn, John, junior, of Toft, husbandman 1
4782723 2290611 2290611 defendant Aleyn John, senior husbandman 593335 593335 Aleyn, John, senior, of Toft, husbandman 2
4796387 2295020 2295020 defendant Carterson Thomas husbandman 593335 593335 Carterson, Thomas, of Toft, husbandman 0
4806987 2298383 2298383 defendant Faukes John yeoman 593335 593335 Faukes, John, of toft, yeoman 1
4825553 2304033 2304033 defendant Curson John husbandman 593335 593335 Curson, John, of Toft, husbandman 3
4826439 2304306 2304306 defendant Aleyn Geoffrey yeoman 593335 593335 Aleyn, Geoffrey, of Toft, yeoman 0
4826441 2304306 2304306 defendant Lumbarde Margaret widow 593335 593335 Lumbarde, Margaret, of Toft, widow 2
4826442 2304306 2304306 defendant Aleyn John husbandman 593335 593335 Aleyn, John, of toft, husbandman 3
4897222 2325787 2325787 defendant Taillour John husbandman 593335 593335 Taillour, John, of Toft, husbandman 1
4913301 2330660 2330660 defendant Baret Robert husbandman 593335 593335 Baret, Robert, of Toft, husbandman 1
4914633 2331094 2331094 defendant Jonson Henry husbandman 593335 593335 Jonson, Henry, of Toft, husbandman 1
4918183 2332208 2332208 defendant Maye Alexander husbandman 593335 593335 Maye, Alexander, of Toft, husbandman 0
4920517 2332931 2332931 defendant Walnote John husbandman 593335 593335 Walnote, John, of Toft, husbandman 0
4930734 2336021 2336021 defendant Johnson Henry husbandman 593335 593335 Johnson, Henry, of Toft, husbandman 0
4964146 2346186 2346186 defendant Asteyn John husbandman 593335 593335 Asteyn, John, of Toft, husbandman 4
4976668 2349978 2349978 defendant Alhall Robert husbandman 593335 593335 Alhall, Robert, of Toft, husbandman 1
4983792 2352079 2352079 defendant Toft Richard husbandman 593335 593335 Toft, Richard, of Toft, husbandman 1
4991490 2354339 2354339 defendant Baseley Thomas   593335 593335 Baseley, Thomas, of Toft 2
4992903 2354757 2354757 defendant Peresson Peter husbandman 593335 593335 Peresson, Peter, of Toft, husbandman 0
5003117 2357816 2357816 defendant Salter Roger laborer 593335 593335 Salter, Roger, of Toft, laborer 3
5006351 2358756 2358756 defendant Wenham Robert husbandman 593335 593335 Wenham, Robert, of Toft, husbandman 0
5009133 2359553 2359553 defendant Glenton Abraham husbandman 593335 593335 Glenton, Abraham, of Toft, husbandman 0
5010409 2359913 2359913 defendant May Alexander husbandman 593335 593335 May, Alexander, of Toft, husbandman 0
5015997 2361564 2361564 defendant Deynes Richard gent 593335 593335 Deynes, Richard, of Toft, gent 0
5015999 2361565 2361565 defendant Moldeson Stephen yeoman 593335 593335 Moldeson, Stephen, of Toft, yeoman 0
5017060 2361885 2361885 plaintiff Moldson Stephen   593335 593335 Moldson, Stephen, of Toft 1
5017061 2361885 2361885 plaintiff Pykeryng John   593335 593335 Pykeryng, John, of Toft 2
5044821 2370087 2370087 defendant Reydon William husbandman 593335 593335 Reydon, William, of Toft, husbandman 0
5096043 2385272 2385272 defendant Grobham John clerk 593335 593335 Grobham, John, of Toft, clerk 0
5105397 2388022 2388022 defendant Claymond John (legal representative) 593335 593335 Claymond, John, of Toft, executors of 2
5115251 2390887 2390887 plaintiff Moldson Stephen yeoman 593335 593335 Moldson, Stephen, of Toft, yeoman 0
5125463 2393932 2393932 plaintiff Baret Robert, junior yeoman 593335 593335 Baret, Robert, junior, of Toft, yeoman 1
5191074 2413128 2413128 defendant Pynder John husbandman 593335 593335 Pynder, John, of Toft, husbandman 4
5315616 2449734 2449734 defendant Holand John husbandman 593335 593335 Holand, John, of Toft, husbandman 7
5518238 2510532 2510532 defendant Jakson Thomas fisher 593335 593335 Jakson, Thomas, of Toft, fisher 1
5586600 2530844 2530844 defendant Mors Robert husbandman 593335 593335 Mors, Robert, of Toft, husbandman 2
5626605 2552294 2552294 defendant Kirketon Ralph   593335 593335 Kirketon, Ralph, of Toft, cook 0
5636719 2555430 2555430 defendant Aleyn John maltman 593335 593335 Aleyn, John, of Toft, maltman 0

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