names

229 rows where place_id = 605106

✎ 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
3660407 1913512 1913512 defendant Raynold William smith 605106 605106 Raynold, William, of Faversham, smith 0
3662110 1914073 1914073 defendant Johnson Harmon   605106 605106 Johnson, Harmon, of Faversham, shoe maker 0
3662111 1914073 1914073 defendant -----serer Vycent shoemaker 605106 605106 -----serer, Vycent, of Faversham, shoemaker 1
3701296 1926651 1926651 defendant Barmyng John clothmaker 605106 605106 Barmyng, John, of Faversham, clothmaker 0
3701297 1926651 1926651 defendant Castlok William merchant 605106 605106 Castlok, William, of Faversham, merchant 1
3701298 1926651 1926651 defendant Awder George tailor 605106 605106 Awder, George, of Faversham, tailor 2
3729282 1935408 1935408 defendant Kere Robert brewer 605106 605106 Kere, Robert, of Faversham, brewer 0
3730327 1935716 1935716 defendant Barmyng John clothmaker 605106 605106 Barmyng, John, of Faversham, clothmaker 0
3740396 1938857 1938857 plaintiff Roper Robert   605106 605106 Roper, Robert, of Faversham 0
3740397 1938857 1938857 defendant Mantyll William merchant of the staple 605106 605106 Mantyll, William, of Faversham, merchant of the staple 0
3748790 1941556 1941556 plaintiff Hampton John merchant 605106 605106 Hampton, John, of Faversham, merchant 0
3810467 1961167 1961167 plaintiff Brooke William (legal representative) 605106 605106 Brooke, William, of Faversham, executors of 0
3827646 1966506 1966506 plaintiff Broke William (legal representative) 605106 605106 Broke, William, of Faversham, executors of 0
3840712 1970661 1970661 defendant Belke William barber 605106 605106 Belke, William, of Faversham, barber 0
3840714 1970662 1970662 plaintiff Atkyn Joan widow 605106 605106 Atkyn, Joan, of Faversham, widow 0
3840715 1970662 1970662 defendant Belke William barber 605106 605106 Belke, William, of Faversham, barber 0
3853066 1974578 1974578 defendant More Thomas butcher 605106 605106 More, Thomas, of Faversham, butcher 3
3853074 1974579 1974579 defendant More Thomas butcher 605106 605106 More, Thomas, of Faversham, butcher 4
3854300 1974981 1974981 defendant Sawyer John yeoman 605106 605106 Sawyer, John, of Faversham, yeoman 0
3865046 1978510 1978510 defendant Fenner Thomas innholder 605106 605106 Fenner, Thomas, of Faversham, innholder 3
3865047 1978510 1978510 defendant Sawyer John yeoman 605106 605106 Sawyer, John, of Faversham, yeoman 4
3879286 1983324 1983324 defendant Godfrey Thomas skinner 605106 605106 Godfrey, Thomas, of Faversham, skinner 0
3933765 2001588 2001588 defendant Marden Lewis (legal representative) 605106 605106 Marden, Lewis, of Faversham, chapman, executrix of 1
3937759 2002960 2002960 defendant Wade Andrew chapman 605106 605106 Wade, Andrew, of Faversham, chapman 1
3937762 2002961 2002961 defendant Wade Andrew chapman 605106 605106 Wade, Andrew, of Faversham, chapman 1
3969365 2013889 2013889 defendant Bonde Henry yeoman 605106 605106 Bonde, Henry, of Faversham, yeoman 3
4027243 2034392 2034392 plaintiff Chatborn William glover 605106 605106 Chatborn, William, of Faversham, glover 0
4236290 2108263 2108263 defendant Fynche Christopher gent 605106 605106 Fynche, Christopher, of Faversham, gent 0
4318298 2136507 2136507 defendant Lagoe John miller 605106 605106 Lagoe, John, of Faversham, miller 1
4318303 2136509 2136509 defendant Tomlyn William brewer 605106 605106 Tomlyn, William, of Faversham, yeoman, brewer 0
4394441 2162738 2162738 defendant Amys Bartholomew (legal representative) 605106 605106 Amys, Bartholomew, of Faversham, yeoman, executors of 0
4433276 2175162 2175162 plaintiff Forstalle William (legal representative) 605106 605106 Forstalle, William, of Faversham, executor of 0
4433278 2175162 2175162 defendant Shipman John   605106 605106 Shipman, John, of Faversham 0
4462905 2189093 2189093 defendant Wousbrygg Richard   605106 605106 Wousbrygg, Richard, of Faversham 0
4470563 2191440 2191440 defendant Swetyng John   605106 605106 Swetyng, John, of Faversham 0
4481914 2195052 2195052 plaintiff Marchall John   605106 605106 Marchall, John, of Faversham 0
4493181 2198570 2198570 defendant Ledes William   605106 605106 Ledes, William, of Faversham 0
4493186 2198571 2198571 defendant Childemell John   605106 605106 Childemell, John, of Faversham 0
4493477 2198665 2198665 plaintiff Wepere John   605106 605106 Wepere, John, of Faversham 1
4500599 2200811 2200811 defendant Wade William   605106 605106 Wade, William, of Faversham 1
4520154 2206638 2206638 defendant Darch John   605106 605106 Darch, John, of Faversham 0
4533235 2210655 2210655 plaintiff Reve John   605106 605106 Reve, John, of Faversham 0
4540448 2212912 2212912 plaintiff Wepere John   605106 605106 Wepere, John, of Faversham 0
4557817 2218375 2218375 plaintiff Pokeleswode John   605106 605106 Pokeleswode, John, of Faversham 1
4558155 2218491 2218491 plaintiff Pokeleswode John   605106 605106 Pokeleswode, John, of Faversham 1
4569242 2221967 2221967 defendant Russell John   605106 605106 Russell, John, of Faversham 0
4569243 2221967 2221967 defendant Plomer Simon   605106 605106 Plomer, Simon, of Faversham 1
4602136 2231890 2231890 defendant Hughelyn Richard   605106 605106 Hughelyn, Richard, of Faversham 0
4616470 2236146 2236146 defendant Cornhell John   605106 605106 Cornhell, John, of Faversham 1
4626161 2239141 2239141 plaintiff Pool Thomas   605106 605106 Pool, Thomas, of Faversham 0
4637357 2242481 2242481 defendant Bartelot William   605106 605106 Bartelot, William, of Faversham 0
4637375 2242487 2242487 defendant Bek Walter de   605106 605106 Bek, Walter de, of Faversham 0
4646883 2245150 2245150 plaintiff Rolf Thomas   605106 605106 Rolf, Thomas, of Faversham 0
4649026 2245763 2245763 plaintiff Tonge Seamus de   605106 605106 Tonge, Seamus de, of Faversham 0
4649028 2245764 2245764 plaintiff Tonge Seamus de   605106 605106 Tonge, Seamus de, of Faversham 0
4654711 2247350 2247350 defendant Bartelot William   605106 605106 Bartelot, William, of Faversham 0
4655290 2247541 2247541 plaintiff Broke Richard   605106 605106 Broke, Richard, of Faversham 0
4661844 2249552 2249552 defendant Penfeld Peter clerk 605106 605106 Penfeld, Peter, of Faversham, clerk 0
4664002 2250227 2250227 defendant Sperhauk Richard shipman 605106 605106 Sperhauk, Richard, of Faversham, shipman 0
4664278 2250310 2250310 defendant Hoghelyn John laborer 605106 605106 Hoghelyn, John, of Faversham, laborer 0
4669973 2256306 2256306 defendant Wade William husbandman 605106 605106 Wade, William, of Faversham, husbandman 0
4671734 2256804 2256804 plaintiff Chapman Vincent brewer 605106 605106 Chapman, Vincent, of Faversham, brewer 0
4676281 2258194 2258194 defendant Chapman Vincent yeoman 605106 605106 Chapman, Vincent, of Faversham, yeoman 2
4680173 2259408 2259408 plaintiff Ledes William   605106 605106 Ledes, William, of Faversham 0
4692470 2263162 2263162 defendant March Thomas fuller 605106 605106 March, Thomas, of Faversham, fuller 0
4693203 2263376 2263376 plaintiff Barbour William   605106 605106 Barbour, William, of Faversham 0
4701542 2265877 2265877 defendant Chapman Vincent yeoman 605106 605106 Chapman, Vincent, of Faversham, yeoman 2
4701547 2265877 2265877 defendant Love Walter thesher 605106 605106 Love, Walter, of Faversham, thesher 7
4703390 2266441 2266441 plaintiff Herfeld William   605106 605106 Herfeld, William, of Faversham 0
4705807 2267188 2267188 plaintiff Ledes William   605106 605106 Ledes, William, of Faversham 0
4709632 2268376 2268376 plaintiff Petyte William   605106 605106 Petyte, William, of Faversham, vicar 0
4709633 2268376 2268376 plaintiff Barbour William   605106 605106 Barbour, William, of Faversham 1
4709635 2268377 2268377 plaintiff Petyte William   605106 605106 Petyte, William, of Faversham, vicar 0
4709636 2268377 2268377 plaintiff Barbour William   605106 605106 Barbour, William, of Faversham 1
4712653 2269273 2269273 defendant Parys John husbandman 605106 605106 Parys, John, of Faversham, husbandman 3
4715052 2270035 2270035 plaintiff Umflays John   605106 605106 Umflays, John, of Faversham 0
4715053 2270035 2270035 defendant Broek Laurence fuller 605106 605106 Broek, Laurence, of Faversham, fuller 0
4715054 2270035 2270035 defendant Chestede John fuller 605106 605106 Chestede, John, of Faversham, fuller 1
4715055 2270035 2270035 defendant Wastell William fuller 605106 605106 Wastell, William, of Faversham, fuller 2
4723871 2272768 2272768 defendant Napilton Peter husbandman 605106 605106 Napilton, Peter, of Faversham, husbandman 0
4727351 2273804 2273804 plaintiff Henxhall John (legal representative) 605106 605106 Henxhall, John, of Faversham, executors of 0
4729458 2274427 2274427 plaintiff Ledys William   605106 605106 Ledys, William, of Faversham, administrators of 0
4729461 2274427 2274427 defendant Bryd John smith 605106 605106 Bryd, John, of Faversham, smith 0
4729462 2274427 2274427 defendant Ryche John husbandman 605106 605106 Ryche, John, of Faversham, husbandman 1
4729464 2274428 2274428 plaintiff Ledys William   605106 605106 Ledys, William, of Faversham, administrators of 0
4730494 2274736 2274736 defendant Brice William mercer 605106 605106 Brice, William, of Faversham, mercer 1
4730497 2274737 2274737 defendant Bryce William mercer 605106 605106 Bryce, William, of Faversham, mercer 1
4738922 2277264 2277264 defendant Betyll John, sen husbandman 605106 605106 Betyll, John, sen, of Faversham, husbandman 2
4741099 2277901 2277901 defendant Bryse William mercer 605106 605106 Bryse, William, of Faversham, mercer 4
4742372 2278262 2278262 defendant Clapman Vincent brewer 605106 605106 Clapman, Vincent, of Faversham, brewer 0
4743746 2278700 2278700 defendant Chapman Vincent brewer 605106 605106 Chapman, Vincent, of Faversham, brewer 0
4744751 2278980 2278980 plaintiff Fen Robert   605106 605106 Fen, Robert, of Faversham, on his own account 0
4745210 2279105 2279105 defendant Chapman Vincent brewer 605106 605106 Chapman, Vincent, of Faversham, brewer 0
4749559 2280353 2280353 defendant Colshille Thomas dyer 605106 605106 Colshille, Thomas, of Faversham, dyer 0
4767430 2285794 2285794 defendant Fenel Robert husbandman 605106 605106 Fenel, Robert, of Faversham, husbandman 2
4769248 2286361 2286361 defendant Fenel Robert husbandman 605106 605106 Fenel, Robert, of Faversham, husbandman 1
4778589 2289288 2289288 defendant Fenel or Fevel Robert husbandman 605106 605106 Fenel or Fevel, Robert, of Faversham, husbandman 0
4790824 2293221 2293221 plaintiff Ledes William (legal representative) 605106 605106 Ledes, William, of Faversham, administratrix of 0
4813659 2300379 2300379 defendant Clyfton Thomas yeoman 605106 605106 Clyfton, Thomas, of Faversham, yeoman 0
4831560 2305905 2305905 plaintiff Broun Richard merchant 605106 605106 Broun, Richard, of Faversham, merchant 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);