names

104 rows where place_id = 586229

✎ 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
3588217 1863969 1863969 defendant Beeston Robert yeoman 586229 586229 Beeston, Robert, of South Lenn, yeoman 0
3602498 1868440 1868440 defendant Powedyssh Richard yeoman 586229 586229 Powedyssh, Richard, of South Lenn, yeoman 3
3606984 1869847 1869847 defendant Wenyngton Isabel widow 586229 586229 Wenyngton, Isabel, of South Lenn, widow 0
3606988 1869848 1869848 defendant Norys John clerk 586229 586229 Norys, John, of South Lenn, clerk 1
3607602 1870035 1870035 defendant Magnus John tailor 586229 586229 Magnus, John, of South Lenn, tailor 0
3614660 1872238 1872238 defendant Elwyn Thomas gent 586229 586229 Elwyn, Thomas, of South Lenn, gent 0
3620063 1873851 1873851 defendant Male Thomas raffman 586229 586229 Male, Thomas, of South Lenn, raffman 0
3621546 1874279 1874279 defendant Wyldegryce William gent 586229 586229 Wyldegryce, William, of South Lenn, gent 0
3621576 1874289 1874289 defendant Elwyn Thomas gent 586229 586229 Elwyn, Thomas, of South Lenn, gent 0
3621581 1874290 1874290 defendant Wyldegryce William gent 586229 586229 Wyldegryce, William, of South Lenn, gent 0
3621586 1874291 1874291 defendant Elwyn Thomas gent 586229 586229 Elwyn, Thomas, of South Lenn, gent 0
3622341 1874523 1874523 defendant Elwyn Thomas gent 586229 586229 Elwyn, Thomas, of South Lenn, gent 0
3622345 1874525 1874525 plaintiff Powedyche Richard   586229 586229 Powedyche, Richard, of South Lenn, or of Emnyth 0
3705980 1928160 1928160 defendant Antony Robert laborer 586229 586229 Antony, Robert, of South Lenn, laborer 0
3705981 1928160 1928160 defendant Webster John laborer 586229 586229 Webster, John, of South Lenn, laborer 1
3712609 1930259 1930259 defendant Dawny Thomas merchant 586229 586229 Dawny, Thomas, of South Lenn, merchant 0
3773140 1949304 1949304 defendant Dawney Thomas merchant 586229 586229 Dawney, Thomas, of South Lenn, merchant 0
3839338 1970231 1970231 defendant Glover Thomas husbandman 586229 586229 Glover, Thomas, of South Lenn, husbandman 0
3840550 1970604 1970604 defendant Branstell William glover 586229 586229 Branstell, William, of South Lenn, glover 0
3841474 1970912 1970912 defendant Ryall Robert smith 586229 586229 Ryall, Robert, of South Lenn, smith 0
3845636 1972178 1972178 defendant Knape John butcher 586229 586229 Knape, John, of South Lenn, butcher 0
3856844 1975767 1975767 defendant Branstell William glover 586229 586229 Branstell, William, of South Lenn, glover 0
3861383 1977275 1977275 defendant Knape John butcher 586229 586229 Knape, John, of South Lenn, butcher 0
3865683 1978742 1978742 defendant Bramstell William glover 586229 586229 Bramstell, William, of South Lenn, glover 1
3905397 1992074 1992074 plaintiff Knape John yeoman 586229 586229 Knape, John, of South Lenn, yeoman 0
3912948 1994661 1994661 defendant Vaughan John yeoman 586229 586229 Vaughan, John, of South Lenn, yeoman 1
4032662 2036332 2036332 defendant Clarke William husbandman or yeoman 586229 586229 Clarke, William, of South Lenn, husbandman or yeoman 1
4569355 2222005 2222005 defendant Bristowe John   586229 586229 Bristowe, John, of South Lenn 1
4581956 2225803 2225803 plaintiff Ely John   586229 586229 Ely, John, of South Lenn 0
4678992 2259037 2259037 defendant Rose William yeoman 586229 586229 Rose, William, of South Lenn, yeoman 2
4678996 2259038 2259038 defendant Rose Willis yeoman 586229 586229 Rose, Willis, of South Lenn, yeoman 2
4694157 2263673 2263673 defendant Wynche John yeoman 586229 586229 Wynche, John, of South Lenn, yeoman 1
4695582 2264104 2264104 defendant Colles Henry chandler 586229 586229 Colles, Henry, of South Lenn, chandler 0
4729366 2274402 2274402 defendant Baxster Walter baker 586229 586229 Baxster, Walter, of South Lenn, baker 2
4729444 2274421 2274421 plaintiff Bulwere Andrew water carrier 586229 586229 Bulwere, Andrew, of South Lenn, water carrier 2
4736370 2276504 2276504 defendant Collys John laborer 586229 586229 Collys, John, of South Lenn, laborer 1
4754861 2281899 2281899 defendant Mower Godewin husbandman 586229 586229 Mower, Godewin, of South Lenn, husbandman 1
4757970 2282870 2282870 defendant Shepherd Richard yeoman 586229 586229 Shepherd, Richard, of South Lenn, yeoman 0
4761243 2283864 2283864 defendant Pye Thomas (legal representative) 586229 586229 Pye, Thomas, of South Lenn, executor of 1
4761244 2283864 2283864 defendant Pye Thomas   586229 586229 Pye, Thomas, of South Lenn, glove maker 2
4763972 2284724 2284724 defendant Broun Thomas baker 586229 586229 Broun, Thomas, of South Lenn, baker 0
4768789 2286216 2286216 defendant Takkere William husbandman 586229 586229 Takkere, William, of South Lenn, husbandman 0
4770706 2286818 2286818 defendant Rose William weaver 586229 586229 Rose, William, of South Lenn, weaver 3
4773147 2287571 2287571 defendant Broun Thomas tinker 586229 586229 Broun, Thomas, of South Lenn, tinker 0
4789686 2292842 2292842 defendant Collys Henry raffman 586229 586229 Collys, Henry, of South Lenn, raffman 0
4798266 2295649 2295649 defendant Collys Henry   586229 586229 Collys, Henry, of South Lenn, candle maker 0
4798281 2295652 2295652 defendant Collys Henry   586229 586229 Collys, Henry, of South Lenn, cande maker 0
4799298 2295956 2295956 defendant Danyell William yeoman 586229 586229 Danyell, William, of South Lenn, yeoman 1
4800043 2296197 2296197 defendant Takkere William husbandman 586229 586229 Takkere, William, of South Lenn, husbandman 0
4860907 2314770 2314770 plaintiff Collys Henry chandler 586229 586229 Collys, Henry, of South Lenn, chandler 0
4860909 2314770 2314770 defendant Sutton John cordwainer 586229 586229 Sutton, John, of South Lenn, cordwainer 1
4860910 2314771 2314771 plaintiff Collys Henry chandler 586229 586229 Collys, Henry, of South Lenn, chandler 0
4860912 2314771 2314771 defendant Sutton John cordwainer 586229 586229 Sutton, John, of South Lenn, cordwainer 1
4905024 2328179 2328179 defendant Prentys Alice widow 586229 586229 Prentys, Alice, of South Lenn, widow 0
4955085 2343473 2343473 defendant Carpenter Robert barker 586229 586229 Carpenter, Robert, of South Lenn, barker 1
4987037 2353065 2353065 plaintiff Baxter Simon brewer 586229 586229 Baxter, Simon, of South Lenn, brewer 0
4990374 2354031 2354031 defendant Godewyn Robert husbandman 586229 586229 Godewyn, Robert, of South Lenn, husbandman 0
4996384 2355777 2355777 plaintiff (not given) John vicar of Halle 586229 586229 Halle, John, of South Lenn, vicar of All Saints church, executors of 0
5012274 2360442 2360442 plaintiff Pokedych Thomas   586229 586229 Pokedych, Thomas, of South Lenn 2
5042877 2369479 2369479 defendant Ede John husbandman 586229 586229 Ede, John, of South Lenn, husbandman 0
5042879 2369479 2369479 defendant Catte William baker 586229 586229 Catte, William, of South Lenn, baker 2
5059482 2374404 2374404 defendant Baker Godfrey   586229 586229 Baker, Godfrey, of South Lenn, administrators of 0
5059483 2374404 2374404 defendant Syche Etheldred widow 586229 586229 (Syche, Etheldred, of South Lenn, widow 1
5059484 2374404 2374404 defendant Baker Agnes widow 586229 586229 Baker, Agnes, of South Lenn, widow 2
5071107 2377851 2377851 defendant Powedyche John brewer 586229 586229 Powedyche, John, of South Lenn, brewer 0
5095086 2384977 2384977 defendant Hardy Nicholas yeoman 586229 586229 Hardy, Nicholas, of South Lenn, yeoman 1
5095088 2384977 2384977 defendant Gunne John   586229 586229 Gunne, John, of South Lenn, tile maker 3
5100682 2386624 2386624 plaintiff Adam Robert (legal representative) 586229 586229 Adam, Robert, of South Lenn, executor of 0
5121797 2392807 2392807 plaintiff Tonn or Toun John baker 586229 586229 Tonn or Toun, John, of South Lenn, baker 0
5156736 2403131 2403131 defendant Boure Thomas husbandman 586229 586229 Boure, Thomas, of South Lenn, husbandman 2
5192910 2413650 2413650 defendant Branch Thomas yeoman 586229 586229 Branch, Thomas, of South Lenn, yeoman 1
5192911 2413650 2413650 defendant Hardy Nicholas yeoman 586229 586229 Hardy, Nicholas, of South Lenn, yeoman 2
5247419 2429401 2429401 plaintiff Witherige William   586229 586229 Witherige, William, of South Lenn 1
5247422 2429401 2429401 defendant Aleyn Richard yeoman 586229 586229 Aleyn, Richard, of South Lenn, yeoman 2
5314240 2449275 2449275 plaintiff Bryston Richard tanner 586229 586229 Bryston, Richard, of South Lenn, tanner 0
5342388 2457816 2457816 plaintiff Sampson Thomas   586229 586229 Sampson, Thomas, of South Lenn 0
5348300 2459610 2459610 plaintiff Braunch Thomas (legal representative) 586229 586229 Braunch, Thomas, of South Lenn, executors of 0
5348305 2459611 2459611 plaintiff Braunch Thomas (legal representative) 586229 586229 Braunch, Thomas, of South Lenn, executors of 0
5384210 2470570 2470570 defendant Parker Robert yeoman 586229 586229 Parker, Robert, of South Lenn, yeoman 2
5396021 2473947 2473947 defendant Samson Nicholas   586229 586229 Samson, Nicholas, of South Lenn, wax chandler 0
5396023 2473947 2473947 defendant Parker Robert yeoman 586229 586229 Parker, Robert, of South Lenn, yeoman 2
5409302 2477751 2477751 defendant Parker Robert yeoman 586229 586229 Parker, Robert, of South Lenn, yeoman 0
5416084 2479742 2479742 defendant Mathewe Thomas husbandman 586229 586229 Mathewe, Thomas, of South Lenn, husbandman 0
5432785 2484773 2484773 defendant Mathewe Thomas husbandman 586229 586229 Mathewe, Thomas, of South Lenn, husbandman 0
5432787 2484774 2484774 defendant Mathewe Thomas husbandman 586229 586229 Mathewe, Thomas, of South Lenn, husbandman 0
5448784 2489530 2489530 defendant Mathewe Thomas husbandman 586229 586229 Mathewe, Thomas, of South Lenn, husbandman 0
5448786 2489531 2489531 defendant Mathewe Thomas husbandman 586229 586229 Mathewe, Thomas, of South Lenn, husbandman 0
5515806 2509789 2509789 defendant Fraunsham Robert brewer 586229 586229 Fraunsham, Robert, of South Lenn, brewer 0
5519273 2510873 2510873 defendant Newehole John husbandman 586229 586229 Newehole, John, of South Lenn, husbandman 2
5520488 2511228 2511228 plaintiff Bryston Katherine (legal representative) 586229 586229 Bryston, Katherine, of South Lenn, widow, executrix of Bryston, Thomas, of South Lenn, executors of 0
5520492 2511228 2511228 defendant Bryston Richard barker 586229 586229 Bryston, Richard, of South Lenn, barker 1
5531416 2514348 2514348 defendant Wilgrys William gent 586229 586229 Wilgrys, William, of South Lenn, gent 0
5531536 2514395 2514395 defendant Norys John chaplain 586229 586229 Norys, John, of South Lenn, chaplain 0
5532240 2514627 2514627 defendant Kenston John yeoman 586229 586229 Kenston, John, of South Lenn, yeoman 1
5532586 2514734 2514734 defendant Fraunceys Robert shoemaker 586229 586229 (Fraunceys, Robert, of South Lenn, shoemaker 2
5532587 2514734 2514734 defendant Jakys John weaver 586229 586229 Jakys, John, of South Lenn, weaver 3
5534029 2515180 2515180 defendant Sherp Hugh shoemaker 586229 586229 Sherp, Hugh, of South Lenn, shoemaker 2
5534842 2515437 2515437 defendant Flegge Thomas laborer 586229 586229 Flegge, Thomas, of South Lenn, laborer 2
5543027 2517936 2517936 defendant Wildegrice William gent 586229 586229 Wildegrice, William, of South Lenn, gent 0
5543784 2518162 2518162 plaintiff Powedych Richard   586229 586229 Powedych, Richard, of South Lenn 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);