names

121 rows where place_id = 604865

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3659537 1913242 1913242 defendant Fysshe John grocer 604865 604865 (Fysshe, John, of Canterbury, Kent, grocer 3
3659640 1913270 1913270 defendant Fysshe John grocer 604865 604865 Fysshe, John, of Canterbury, Kent, grocer 3
3939069 2003394 2003394 defendant Skott Stephen clothier 604865 604865 Skott, Stephen, of Canterbury, Kent, clothier 2
4081312 2053627 2053627 plaintiff Whittfeild Edward   604865 604865 Whittfeild, Edward, of Canterbury, Kent 0
4668874 2255967 2255967 defendant burton Thomas   604865 604865 burton, Thomas, of Canterbury, Kent, clerk, formerly of York 1
4668880 2255968 2255968 defendant Burton Thomas clerk 604865 604865 Burton, Thomas, of Canterbury, Kent, clerk 1
4675320 2257891 2257891 defendant Newell Roger dyer 604865 604865 Newell, Roger, of Canterbury, Kent, dyer 0
4675992 2258102 2258102 defendant Newell Robert dyer 604865 604865 Newell, Robert, of Canterbury, Kent, dyer 0
4682168 2260045 2260045 defendant Court John yeoman 604865 604865 Court, John, of Canterbury, Kent, yeoman 0
4683606 2260475 2260475 defendant Byllyngton Wiliam mercer 604865 604865 (Byllyngton, Wiliam, of Canterbury, Kent, mercer 1
4686090 2261240 2261240 defendant Urry James vintner 604865 604865 Urry, James, of Canterbury, Kent, vintner 0
4689195 2262179 2262179 defendant Bakare Richard husbandman 604865 604865 Bakare, Richard, of Canterbury, Kent, husbandman 1
4691606 2262902 2262902 defendant Walsale Robert tailor 604865 604865 Walsale, Robert, of Canterbury, Kent, tailor 2
4693421 2263443 2263443 defendant Burton John   604865 604865 Burton, John, of Canterbury, Kent, clerk, formerly of Yorkshire 1
4693425 2263444 2263444 defendant Burton John   604865 604865 Burton, John, of Canterbury, Kent, clerk, formerly of Yorkshire 1
4700215 2265485 2265485 defendant Culmere John brewer 604865 604865 Culmere, John, of Canterbury, Kent, brewer 0
4706887 2267534 2267534 defendant Noone John dyer 604865 604865 Noone, John, of Canterbury, Kent, dyer 0
4709779 2268415 2268415 defendant Billyngton William mercer 604865 604865 (Billyngton, William, of Canterbury, Kent, mercer 1
4709988 2268481 2268481 defendant Waynflete William heweler 604865 604865 Waynflete, William, of Canterbury, Kent, heweler 0
4712226 2269139 2269139 defendant Baker William gent 604865 604865 Baker, William, of Canterbury, Kent, gent 1
4722689 2272414 2272414 defendant Culmere John brewer 604865 604865 Culmere, John, of Canterbury, Kent, brewer 0
4730485 2274732 2274732 defendant Noone John dyer 604865 604865 Noone, John, of Canterbury, Kent, dyer 0
4732497 2275336 2275336 defendant Valet Simon hosier 604865 604865 Valet, Simon, of Canterbury, Kent, hosier 0
4732549 2275354 2275354 defendant Appylby William draper 604865 604865 Appylby, William, of Canterbury, Kent, draper 0
4738182 2277041 2277041 defendant Hereford Robert summoner 604865 604865 Hereford, Robert, of Canterbury, Kent, summoner 1
4746068 2279349 2279349 defendant Chirche John   604865 604865 Chirche, John, of Canterbury, Kent, town clerk 1
4746074 2279350 2279350 defendant Chirche John   604865 604865 Chirche, John, of Canterbury, Kent, town clerk 1
4746899 2279592 2279592 defendant Colbrond Richard grocer 604865 604865 Colbrond, Richard, of Canterbury, Kent, grocer 0
4746902 2279593 2279593 defendant Colbrond Richard grocer 604865 604865 Colbrond, Richard, of Canterbury, Kent, grocer 0
4748356 2280026 2280026 defendant Pecok John   604865 604865 Pecok, John, of Canterbury, Kent, bow maker 2
4749357 2280292 2280292 defendant Colbrond Richard yeoman 604865 604865 Colbrond, Richard, of Canterbury, Kent, yeoman 0
4753744 2281545 2281545 defendant Grene Alice gentlewoman 604865 604865 Grene, Alice, of Canterbury, Kent, gentlewoman 1
4763950 2284718 2284718 defendant Cherche Thomas gent 604865 604865 Cherche, Thomas, of Canterbury, Kent, gent 1
4767475 2285806 2285806 defendant Lyvermere John gent 604865 604865 Lyvermere, John, of Canterbury, Kent, gent 0
4769728 2286504 2286504 defendant Maldon John chapman 604865 604865 Maldon, John, of Canterbury, Kent, chapman 1
4771590 2287092 2287092 defendant Wryghte Gregory yeoman 604865 604865 Wryghte, Gregory, of Canterbury, Kent, yeoman 0
4775198 2288237 2288237 defendant Merssh Estmerus yeoman 604865 604865 Merssh, Estmerus, of Canterbury, Kent, yeoman 0
4807529 2298549 2298549 defendant Banham Roger smith 604865 604865 Banham, Roger, of Canterbury, Kent, smith 0
4807532 2298549 2298549 defendant dufhous John smith 604865 604865 dufhous, John, of Canterbury, Kent, smith 3
4807589 2298565 2298565 defendant Wyberd John chapman 604865 604865 Wyberd, John, of Canterbury, kent, chapman 0
4810533 2299439 2299439 defendant Foxhonte John husbandman 604865 604865 Foxhonte, John, of Canterbury, Kent, husbandman 2
4813472 2300325 2300325 defendant Wotton Thomas clerk 604865 604865 Wotton, Thomas, of Canterbury, Kent, clerk 3
4813477 2300326 2300326 defendant Wotton Thomas clerk 604865 604865 Wotton, Thomas, of Canterbury, Kent, clerk 3
4814342 2300594 2300594 defendant Scot Richard mercer 604865 604865 Scot, Richard, of Canterbury, Kent, mercer 0
4818992 2302019 2302019 defendant Edmundes John chapman 604865 604865 Edmundes, John, of Canterbury, Kent, chapman 2
4818998 2302020 2302020 defendant Edmund John chapman 604865 604865 Edmund, John, of Canterbury, Kent, chapman 2
4820630 2302525 2302525 defendant Wotton Thomas   604865 604865 Wotton, Thomas, of Canterbury, Kent, parson of St Martin's Eastgate 0
4833830 2306587 2306587 defendant Danham Roger chapman 604865 604865 Danham, Roger, of Canterbury, Kent, chapman 0
4833833 2306588 2306588 defendant Banham Roger chapman 604865 604865 Banham, Roger, of Canterbury, Kent, chapman 0
4834197 2306706 2306706 defendant Thurstede William husbandman 604865 604865 Thurstede, William, of Canterbury, Kent, husbandman 0
4834198 2306706 2306706 defendant Rabage John sheerman 604865 604865 Rabage, John, of Canterbury, Kent, sheerman 1
4836080 2307264 2307264 defendant Horn William gent 604865 604865 Horn, William, of Canterbury, Kent, gent 0
4853916 2312635 2312635 defendant Crosse William tailor 604865 604865 Crosse, William, of Canterbury, Kent, tailor 0
4853918 2312636 2312636 defendant Crosse William tailor 604865 604865 Crosse, William, of Canterbury, Kent, tailor 0
4863475 2315548 2315548 defendant Emery William widow 604865 604865 Emery, William, of Canterbury, Kent, widow 0
4903914 2327838 2327838 defendant Gerard Robert barber 604865 604865 Gerard, Robert, of Canterbury, Kent, barber 0
4907396 2328873 2328873 defendant Gerard Robert barber 604865 604865 Gerard, Robert, of Canterbury, Kent, barber 0
4912695 2330475 2330475 defendant Virly John farmer 604865 604865 Virly, John, of Canterbury, Kent, farmer 0
4912877 2330523 2330523 defendant Alburgh John merchant 604865 604865 Alburgh, John, of Canterbury, Kent, merchant 0
4915015 2331201 2331201 defendant Ppetham Thomas taverner 604865 604865 Ppetham, Thomas, of Canterbury, Kent, taverner 1
4919371 2332570 2332570 defendant Bartelot John sadler 604865 604865 Bartelot, John, of Canterbury, Kent, sadler 1
4919377 2332571 2332571 defendant Bartelot John sadler 604865 604865 Bartelot, John, of Canterbury, Kent, sadler 2
4920287 2332858 2332858 defendant Bartelot John sadler 604865 604865 Bartelot, John, of Canterbury, Kent, sadler 3
4922493 2333450 2333450 defendant Colbronde Thomas (legal representative) 604865 604865 Colbronde, Thomas, of Canterbury, Kent, gent, executor of 0
4926168 2334612 2334612 defendant Person John carver 604865 604865 Person, John, of Canterbury, Kent, carver 1
4926174 2334613 2334613 defendant Person John carver 604865 604865 Person, John, of Canterbury, Kent, carver 1
4927447 2335017 2335017 defendant Hustwhayt Peter tanner 604865 604865 Hustwhayt, Peter, of Canterbury, Kent, tanner 0
4930332 2335886 2335886 defendant Harnhill John tailor 604865 604865 Harnhill, John, of Canterbury, Kent, tailor 2
4961444 2345388 2345388 defendant Norman Thomas brasier 604865 604865 Norman, Thomas, of Canterbury, Kent, brasier 0
4993339 2354878 2354878 defendant Randolf Thomas chapman 604865 604865 Randolf, Thomas, of Canterbury, Kent, chapman 2
4999930 2356855 2356855 defendant Merydyk Morgan esq 604865 604865 Merydyk, Morgan, of Canterbury, Kent, esq 1
5006826 2358897 2358897 defendant Qwyverton John gent 604865 604865 Qwyverton, John, of Canterbury, Kent, gent 0
5010703 2359994 2359994 defendant Kemond John tailor 604865 604865 Kemond, John, of Canterbury, Kent, tailor 0
5010754 2360001 2360001 defendant Kemond John tailor 604865 604865 Kemond, John, of Canterbury, Kent, tailor 0
5026117 2364535 2364535 defendant Gerard John skinner 604865 604865 Gerard, John, of Canterbury, Kent, skinner 1
5049975 2371614 2371614 defendant Randolf William yeoman 604865 604865 Randolf, William, of Canterbury, Kent, yeoman 0
5067499 2376777 2376777 defendant Sutton Ralph yeoman 604865 604865 Sutton, Ralph, of Canterbury, Kent, yeoman 0
5103392 2387420 2387420 defendant Walton Nicholas chapman 604865 604865 Walton, Nicholas, of Canterbury, Kent, chapman 2
5125078 2393806 2393806 defendant Morley Robert yeoman 604865 604865 Morley, Robert, of Canterbury, Kent, yeoman 2
5125082 2393807 2393807 defendant Morley Robert yeoman 604865 604865 Morley, Robert, of Canterbury, Kent, yeoman 2
5126841 2394327 2394327 defendant Whyte Richard draper 604865 604865 Whyte, Richard, of Canterbury, Kent, draper 0
5129235 2395038 2395038 defendant Reynold John pewterer 604865 604865 Reynold, John, of Canterbury, Kent, pewterer 3
5130060 2395279 2395279 defendant Rose William gent 604865 604865 Rose, William, of Canterbury, Kent, gent 0
5136233 2397114 2397114 defendant Walton Nicholas chapman 604865 604865 Walton, Nicholas, of Canterbury, Kent, chapman 0
5138292 2397707 2397707 defendant Delafeld Richard gent 604865 604865 (Delafeld, Richard, of Canterbury, Kent, gent 1
5138962 2397890 2397890 defendant Bysshop John (legal representative) 604865 604865 Bysshop, John, of Canterbury, Kent, ostler or hakeney man, executrix of 0
5139331 2397992 2397992 defendant Reyner Thomas   604865 604865 Reyner, Thomas, of Canterbury, Kent 0
5140511 2398330 2398330 defendant Reyner Thomas smith 604865 604865 Reyner, Thomas, of Canterbury, Kent, smith 0
5144631 2399587 2399587 defendant Lambert James merchant 604865 604865 Lambert, James, of Canterbury, Kent, merchant 0
5144635 2399588 2399588 defendant Laonbert James merchant 604865 604865 Laonbert, James, of Canterbury, Kent, merchant 0
5145424 2399806 2399806 defendant Russell John chandler 604865 604865 Russell, John, of Canterbury, Kent, chandler 0
5145538 2399840 2399840 defendant Whyte Richard draper 604865 604865 Whyte, Richard, of Canterbury, Kent, draper 0
5149351 2400944 2400944 defendant Rose William gent 604865 604865 Rose, William, of Canterbury, Kent, gent 0
5149354 2400945 2400945 defendant Rose William gent 604865 604865 Rose, William, of Canterbury, Kent, gent 0
5160299 2404105 2404105 defendant Reyner Thomas smith 604865 604865 Reyner, Thomas, of Canterbury, Kent, smith 0
5160304 2404106 2404106 defendant Reyner Thomas smith 604865 604865 Reyner, Thomas, of Canterbury, Kent, smith 0
5161563 2404480 2404480 defendant Cok Thomas yeoman 604865 604865 Cok, Thomas, of Canterbury, Kent, yeoman 0
5165392 2405626 2405626 defendant Lambert James merchant 604865 604865 Lambert, James, of Canterbury, Kent, merchant 0
5165933 2405782 2405782 defendant White Richard draper 604865 604865 White, Richard, of Canterbury, Kent, draper 0
5166180 2405836 2405836 defendant Russell John chandler 604865 604865 Russell, John, of Canterbury, Kent, chandler 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);