names

137 rows where place_id = 586778

✎ 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
3589597 1864385 1864385 defendant Porter John husbandman 586778 586778 Porter, John, of Byngham, husbandman 0
3589599 1864386 1864386 defendant Porter John husbandman 586778 586778 Porter, John, of Byngham, husbandman 0
3593934 1865741 1865741 defendant Cokker John yeoman 586778 586778 Cokker, John, of Byngham, yeoman 0
3602879 1868567 1868567 defendant Bygod Philip esq 586778 586778 Bygod, Philip, of Byngham, esq 0
3610574 1870972 1870972 defendant Cokker John yeoman 586778 586778 Cokker, John, of Byngham, yeoman 0
3610575 1870972 1870972 defendant Hill Otwell yeoman 586778 586778 Hill, Otwell, of Byngham, yeoman 1
3610576 1870972 1870972 defendant Colynson Henry husbandman 586778 586778 Colynson, Henry, of Byngham, husbandman 2
3610577 1870972 1870972 defendant Respyn Stephen cooper 586778 586778 Respyn, Stephen, of Byngham, cooper 3
3624093 1875063 1875063 defendant Brigge John husbandman 586778 586778 Brigge, John, of Byngham, husbandman 7
3624102 1875064 1875064 defendant Brigge John husbandman 586778 586778 Brigge, John, of Byngham, husbandman 7
3653041 1911281 1911281 defendant Smythe John cutler 586778 586778 Smythe, John, of Byngham, cutler 0
3654157 1911563 1911563 defendant Porter Thomas husbandman 586778 586778 Porter, Thomas, of Byngham, husbandman 0
3654158 1911563 1911563 defendant Blagge Richard laborer 586778 586778 Blagge, Richard, of Byngham, laborer 1
3654160 1911564 1911564 defendant Porter Thomas husbandman 586778 586778 Porter, Thomas, of Byngham, husbandman 0
3654161 1911564 1911564 defendant Blagge Richard laborer 586778 586778 Blagge, Richard, of Byngham, laborer 1
3659180 1913128 1913128 defendant Porter Thomas husbandman 586778 586778 Porter, Thomas, of Byngham, husbandman 0
3659181 1913128 1913128 defendant Blagge Richard laborer 586778 586778 Blagge, Richard, of Byngham, laborer 1
3659183 1913129 1913129 defendant Porter Thomas husbandman 586778 586778 Porter, Thomas, of Byngham, husbandman 0
3659184 1913129 1913129 defendant Blagge Richard laborer 586778 586778 Blagge, Richard, of Byngham, laborer 1
3688687 1922623 1922623 defendant Gybbon John smith 586778 586778 Gybbon, John, of Byngham, smith 3
3699519 1926080 1926080 defendant Garstang Thomas gent 586778 586778 Garstang, Thomas, of Byngham, gent 0
3699521 1926081 1926081 defendant Garstang Thomas gent 586778 586778 Garstang, Thomas, of Byngham, gent 0
3713019 1930396 1930396 defendant Garstang Thomas gent 586778 586778 Garstang, Thomas, of Byngham, gent 0
3728452 1935146 1935146 defendant Garstang Thomas gent 586778 586778 Garstang, Thomas, of Byngham, gent 0
3728454 1935147 1935147 defendant Garstang Thomas gent 586778 586778 Garstang, Thomas, of Byngham, gent 0
3827139 1966350 1966350 defendant Tutbure Thomas laborer 586778 586778 Tutbure, Thomas, of Byngham, laborer 0
3931568 2000855 2000855 defendant Woodcok Agnes widow 586778 586778 Woodcok, Agnes, of Byngham, widow 1
4011708 2028923 2028923 plaintiff Porter Robert yeoman 586778 586778 Porter, Robert, of Byngham, yeoman 0
4412907 2168911 2168911 defendant Bartram John tailor 586778 586778 Bartram, John, of Byngham, tailor 0
4436316 2176100 2176100 defendant Burre Thomas   586778 586778 Burre, Thomas, of Byngham 7
4503631 2201711 2201711 defendant Neweton William   586778 586778 Neweton, William, of Byngham 1
4534595 2211090 2211090 defendant Spicer Thomas   586778 586778 Spicer, Thomas, of Byngham 1
4534596 2211090 2211090 defendant Cok John   586778 586778 Cok, John, of Byngham 2
4534598 2211090 2211090 defendant Cloute John   586778 586778 Cloute, John, of Byngham 4
4548503 2215474 2215474 plaintiff Cicestria William de   586778 586778 Cicestria, William de, of Byngham, parson 0
4548505 2215475 2215475 plaintiff Cicestria William de   586778 586778 Cicestria, William de, of Byngham, parson 0
4548846 2215574 2215574 defendant Laxton Thomas   586778 586778 Laxton, Thomas, of Byngham 5
4563224 2220066 2220066 defendant Dapriell John   586778 586778 Dapriell, John, of Byngham 0
4583344 2226210 2226210 defendant Thorpe John de butcher 586778 586778 Thorpe, John de, of Byngham, butcher 3
4599998 2231222 2231222 defendant L_ Ralph   586778 586778 L_, Ralph, of Byngham 1
4610891 2234478 2234478 defendant Cony Thomas   586778 586778 Cony, Thomas, of Byngham 0
4610893 2234479 2234479 defendant Cony Thomas   586778 586778 Cony, Thomas, of Byngham 0
4613960 2235379 2235379 defendant Conyng Thomas   586778 586778 Conyng, Thomas, of Byngham 1
4613965 2235381 2235381 defendant Neteherd Richard   586778 586778 Neteherd, Richard, of Byngham 0
4621863 2237819 2237819 defendant Swan Henry   586778 586778 Swan, Henry, of Byngham 0
4630124 2240335 2240335 defendant Belle Robert   586778 586778 Belle, Robert, of Byngham 1
4630125 2240335 2240335 defendant Kynalton Richard   586778 586778 Kynalton, Richard, of Byngham 2
4630126 2240335 2240335 defendant Neuton Hugh   586778 586778 Neuton, Hugh, of Byngham 3
4631273 2240677 2240677 defendant Bell Robert   586778 586778 Bell, Robert, of Byngham 0
4633914 2241457 2241457 defendant Thorp John, sen   586778 586778 Thorp, John, sen, of Byngham 0
4646067 2244923 2244923 defendant Thorp John   586778 586778 Thorp, John, of Byngham 2
4654232 2247203 2247203 defendant Cony Thomas butcher 586778 586778 Cony, Thomas, of Byngham, butcher 5
4660478 2249103 2249103 defendant atte Brigge Hugh yeoman 586778 586778 atte Brigge, Hugh, of Byngham, yeoman 1
4660479 2249103 2249103 defendant Furnyvale Robert   586778 586778 Furnyvale, Robert, of Byngham, bailiff 2
4660480 2249103 2249103 defendant Clowte Hugh yeoman 586778 586778 Clowte, Hugh, of Byngham, yeoman 3
4660481 2249103 2249103 defendant Chaumberleyn Richard yeoman 586778 586778 Chaumberleyn, Richard, of Byngham, yeoman 4
4660482 2249103 2249103 defendant Kyng John miller 586778 586778 Kyng, John, of Byngham, miller 5
4660483 2249103 2249103 defendant Litelton John husbandman 586778 586778 Litelton, John, of Byngham, husbandman 6
4661483 2249419 2249419 defendant Kyng John skinner 586778 586778 Kyng, John, of Byngham, skinner 2
4662432 2249725 2249725 defendant Clowte Hugh husbandman 586778 586778 Clowte, Hugh, of Byngham, husbandman 0
4662433 2249725 2249725 defendant atte Brygge Hugh husbandman 586778 586778 atte Brygge, Hugh, of Byngham, husbandman 1
4662434 2249725 2249725 defendant Furnyvale Robert husbandman 586778 586778 Furnyvale, Robert, of Byngham, husbandman 2
4662435 2249725 2249725 defendant Chaumberleyn Richard tailor 586778 586778 Chaumberleyn, Richard, of Byngham, tailor 3
4662436 2249725 2249725 defendant Kyng John miller 586778 586778 Kyng, John, of Byngham, miller 4
4662437 2249725 2249725 defendant Lytilton John cordwainer 586778 586778 Lytilton, John, of Byngham, cordwainer 5
4668775 2255943 2255943 defendant Doket John weaver 586778 586778 Doket, John, of Byngham, weaver 2
4677144 2258468 2258468 defendant Bailly Walter husbandman 586778 586778 Bailly, Walter, of Byngham, husbandman 0
4677147 2258468 2258468 defendant Conynge Thomas skinner 586778 586778 Conynge, Thomas, of Byngham, skinner 3
4684991 2260905 2260905 defendant Furnevale Robert   586778 586778 Furnevale, Robert, of Byngham, bailiff 0
4685500 2261061 2261061 defendant Bertram Thomas husbandman 586778 586778 Bertram, Thomas, of Byngham, husbandman 0
4685501 2261061 2261061 defendant Belle William husbandman 586778 586778 Belle, William, of Byngham, husbandman 1
4716497 2270479 2270479 defendant Broune William husbandman 586778 586778 Broune, William, of Byngham, husbandman 0
4716498 2270479 2270479 defendant Cant Hugh husbandman 586778 586778 Cant, Hugh, of Byngham, husbandman 1
4719161 2271340 2271340 defendant Deget Richard weaver 586778 586778 Deget, Richard, of Byngham, weaver 4
4729915 2274564 2274564 plaintiff Louth John   586778 586778 Louth, John, of Byngham 0
4730266 2274671 2274671 defendant Furnyvall Robert yeoman 586778 586778 Furnyvall, Robert, of Byngham, yeoman 0
4739208 2277356 2277356 defendant Brone John husbandman 586778 586778 Brone, John, of Byngham, husbandman 0
4740971 2277869 2277869 defendant Doket Robert weaver 586778 586778 Doket, Robert, of Byngham, weaver 4
4751375 2280880 2280880 defendant Furnyvall Robert   586778 586778 Furnyvall, Robert, of Byngham 1
4766200 2285420 2285420 defendant Bery Richard husbandman 586778 586778 Bery, Richard, of Byngham, husbandman 0
4766201 2285420 2285420 defendant Selby Robert   586778 586778 Selby, Robert, of Byngham, wright 1
4770124 2286624 2286624 defendant Wastenes Nicholas husbandman 586778 586778 Wastenes, Nicholas, of Byngham, husbandman 0
4773153 2287573 2287573 plaintiff Sutton John   586778 586778 Sutton, John, of Byngham 0
4777825 2289056 2289056 plaintiff Barnesdale Thomas   586778 586778 Barnesdale, Thomas, of Byngham 0
4808532 2298836 2298836 defendant Skyrlyngton John   586778 586778 Skyrlyngton, John, of Byngham, franklin 0
4808533 2298836 2298836 defendant Clerk Thomas yeoman 586778 586778 Clerk, Thomas, of Byngham, yeoman 1
4842260 2309113 2309113 defendant Cook William shoemaker 586778 586778 Cook, William, of Byngham, shoemaker 1
4843237 2309403 2309403 defendant Furnyvall Robert yeoman 586778 586778 Furnyvall, Robert, of Byngham, yeoman 4
4871816 2318156 2318156 defendant Furnyvale Alice singlewoman 586778 586778 Furnyvale, Alice, of Byngham, singlewoman 5
4873725 2318725 2318725 defendant Duffeld John husbandman 586778 586778 Duffeld, John, of Byngham, husbandman 2
4876485 2319611 2319611 plaintiff Smyth Henry   586778 586778 Smyth, Henry, of Byngham 0
4881396 2321080 2321080 defendant Webster Robert weaver 586778 586778 Webster, Robert, of Byngham, weaver 0
4888518 2323206 2323206 defendant Furnyvall Robert (legal representative) 586778 586778 Furnyvall, Robert, of Byngham, executrix of 4
4888519 2323206 2323206 defendant Furnyvall Alice single woman 586778 586778 Furnyvall, Alice, of Byngham, single woman 5
4898700 2326245 2326245 plaintiff Smyth Henry   586778 586778 Smyth, Henry, of Byngham 0
4926709 2334774 2334774 plaintiff Rempston William clerk 586778 586778 Rempston, William, of Byngham, clerk 0
4951053 2342293 2342293 defendant Irysh John husbandman 586778 586778 Irysh, John, of Byngham, husbandman 1
4951135 2342319 2342319 defendant Rempton William clerk 586778 586778 Rempton, William, of Byngham, clerk 1
4966550 2346928 2346928 defendant Shale Ralph husbandman 586778 586778 Shale, Ralph, of Byngham, husbandman 0
4990609 2354104 2354104 defendant Barnsdale John husbandman 586778 586778 Barnsdale, John, of Byngham, 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);