names

107 rows where place_id = 653254

✎ 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
3927836 1999649 1999649 defendant Tye Christopher gent & Doctor of Music 653254 653254 Tye, Christopher, of Ely, Cambs, gent & Doctor of Music 0
3928701 1999936 1999936 defendant Preston Robert upholster 653254 653254 Preston, Robert, of Ely, Cambs, upholster 0
3934740 2001916 2001916 defendant Benett John   653254 653254 Benett, John, of Ely, Cambs, shoe maker 2
4673230 2257265 2257265 defendant Cuttermong Edmund chapman 653254 653254 Cuttermong, Edmund, of Ely, Cambs, chapman 0
4682352 2260103 2260103 defendant Smale John husbandman 653254 653254 Smale, John, of Ely, Cambs, husbandman 0
4682358 2260104 2260104 defendant Smale John husbandman 653254 653254 Smale, John, of Ely, Cambs, husbandman 0
4693420 2263443 2263443 defendant Fordham John esq 653254 653254 Fordham, John, of Ely, Cambs, esq 0
4693424 2263444 2263444 defendant Fordam John esq 653254 653254 Fordam, John, of Ely, Cambs, esq 0
4710482 2268637 2268637 defendant Cotermonger Edmund husbandman 653254 653254 Cotermonger, Edmund, of Ely, Cambs, husbandman 1
4721707 2272126 2272126 defendant Fordeham John esq 653254 653254 Fordeham, John, of Ely, Cambs, esq 0
4729679 2274494 2274494 defendant Reynold Thomas   653254 653254 Reynold, Thomas, of Ely, Cambs, parson & clerk 2
4731526 2275057 2275057 defendant Palmere William husbandman 653254 653254 Palmere, William, of Ely, Cambs, husbandman 0
4736166 2276446 2276446 defendant Fordham John esq 653254 653254 Fordham, John, of Ely, Cambs, esq 0
4738437 2277112 2277112 defendant Fordham John gent 653254 653254 Fordham, John, of Ely, Cambs, gent 1
4740875 2277846 2277846 defendant Messager Richard husbandman 653254 653254 Messager, Richard, of Ely, Cambs, husbandman 1
4740881 2277847 2277847 defendant Messager Richard husbandman 653254 653254 Messager, Richard, of Ely, Cambs, husbandman 1
4752717 2281253 2281253 defendant Totermong or Cotermong Edmund yeoman 653254 653254 Totermong or Cotermong, Edmund, of Ely, Cambs, yeoman 0
4754856 2281897 2281897 defendant Draweswerd Robert chapman 653254 653254 Draweswerd, Robert, of Ely, Cambs, chapman 2
4759173 2283213 2283213 defendant Fordham John esq 653254 653254 Fordham, John, of Ely, Cambs, esq 1
4759174 2283213 2283213 defendant Wiseman John yeoman 653254 653254 Wiseman, John, of Ely, Cambs, yeoman 2
4765592 2285229 2285229 defendant Bugge John dyer 653254 653254 Bugge, John, of Ely, Cambs, dyer 1
4768490 2286119 2286119 defendant Smale John husbandman 653254 653254 Smale, John, of Ely, Cambs, husbandman 2
4827549 2304664 2304664 defendant Rede Richard gent 653254 653254 Rede, Richard, of Ely, Cambs, gent 2
4833170 2306386 2306386 defendant Fordham John gent 653254 653254 Fordham, John, of Ely, Cambs, gent 2
4833175 2306387 2306387 defendant Fordham John gent 653254 653254 Fordham, John, of Ely, Cambs, gent 2
4917377 2331949 2331949 defendant Bene John baker 653254 653254 Bene, John, of Ely, Cambs, baker 1
4924751 2334175 2334175 defendant Whityng John chapman 653254 653254 Whityng, John, of Ely, Cambs, chapman 4
4929845 2335750 2335750 defendant Chatryche Martin yeoman 653254 653254 Chatryche, Martin, of Ely, Cambs, yeoman 0
4930434 2335919 2335919 plaintiff Tolbethe Thomas   653254 653254 Tolbethe, Thomas, of Ely, Cambs 0
4930436 2335920 2335920 plaintiff Tolbothe Thomas   653254 653254 Tolbothe, Thomas, of Ely, Cambs 0
4931624 2336279 2336279 defendant Wylton Thomas yeoman 653254 653254 Wylton, Thomas, of Ely, Cambs,yeoman 0
4985524 2352588 2352588 defendant Armysley Henry spicer 653254 653254 Armysley, Henry, of Ely, Cambs, spicer 1
4985530 2352589 2352589 defendant Armysley Henry spicer 653254 653254 Armysley, Henry, of Ely, Cambs, spicer 1
4991379 2354304 2354304 defendant Brewode William gent 653254 653254 Brewode, William, of Ely, Cambs, gent 1
4991482 2354336 2354336 defendant Hardewyk John goldsmith 653254 653254 Hardewyk, John, of ely, Cambs, goldsmith 0
4991484 2354337 2354337 defendant Hardewyk John goldsmith 653254 653254 Hardewyk, John, of Ely, Cambs, goldsmith 0
4995500 2355493 2355493 defendant Fordham John gent 653254 653254 Fordham, John, of Ely, Cambs, gent 0
4996058 2355675 2355675 defendant Kyng John goldsmith 653254 653254 Kyng, John, of Ely, Cambs, goldsmith 1
5000415 2356989 2356989 defendant Tolbothe Thomas esq 653254 653254 Tolbothe, Thomas, of Ely, Cambs, esq 0
5001001 2357171 2357171 defendant Raynold Thomas   653254 653254 (Raynold, Thomas, of Ely, Cambs, parson 1
5038394 2368118 2368118 defendant Armeslee Henry chapman 653254 653254 Armeslee, Henry, of Ely, Cambs, chapman 2
5038437 2368131 2368131 defendant Herman John merchant 653254 653254 Herman, John, of Ely, Cambs, merchant 1
5038829 2368256 2368256 defendant Mobbys John husbandman 653254 653254 Mobbys, John, of Ely, Cambs, husbandman 3
5048117 2371059 2371059 defendant Turnour John turner 653254 653254 Turnour, John, of Ely, Cambs, turner 3
5050089 2371648 2371648 defendant Armysley alias Spycer Henry spicer 653254 653254 Armysley alias Spycer, Henry, of Ely, Cambs, spicer 0
5125877 2394055 2394055 defendant Coot John pedder 653254 653254 Coot, John, of Ely, Cambs, pedder 2
5129495 2395114 2395114 defendant Stanley Wiliam former parson 653254 653254 Stanley, Wiliam, of Ely, Cambs, successor to Thomas Reynold, former parson 0
5141503 2398633 2398633 defendant Lincoln William husbandman 653254 653254 Lincoln, William, of Ely, Cambs, husbandman 1
5141509 2398634 2398634 defendant Lyncoln William husbandman 653254 653254 Lyncoln, William, of Ely, Cambs, husbandman 1
5144481 2399546 2399546 defendant Cort John   653254 653254 Cort, John, of Ely, Cambs, pedlar 2
5144483 2399547 2399547 defendant Cort John   653254 653254 Cort, John, of Ely, Cambs, pedlar 0
5144485 2399548 2399548 defendant Cort John   653254 653254 Cort, John, of Ely, Cambs, pedlar 0
5152713 2401934 2401934 defendant Herman William gent 653254 653254 Herman, William, of Ely, Cambs, gent 3
5152860 2401977 2401977 defendant Herman William gent 653254 653254 Herman, William, of Ely, Cambs, gent 3
5153615 2402209 2402209 defendant (not given) William prior of Wellys 653254 653254 Wellys, William, of Ely, Cambs, prior of the cathedral church 0
5165212 2405568 2405568 defendant Herman William gent 653254 653254 Herman, William, of Ely, Cambs, gent 0
5168712 2406574 2406574 defendant Herman William gent 653254 653254 Herman, William, of Ely, Cambs, gent 0
5170469 2407091 2407091 defendant Herman William gent 653254 653254 Herman, William, of Ely, Cambs, gent 3
5170956 2407228 2407228 defendant (not given) William prior of Wellys 653254 653254 Wellys, William, of Ely, Cambs, prior of the cathedral church 0
5170958 2407229 2407229 defendant (not given) William prior of Wellys 653254 653254 Wellys, William, of Ely, Cambs, prior of the cathedral church 0
5175737 2408587 2408587 defendant (not given) William prior of Welles 653254 653254 Welles, William, of Ely, Cambs, prior of the cathedral church 0
5179044 2409597 2409597 defendant Herman William gent 653254 653254 Herman, William, of Ely, Cambs, gent 0
5184727 2411283 2411283 defendant Herman William gent 653254 653254 Herman, William, of Ely, Cambs, gent 0
5184730 2411284 2411284 defendant Herman William gent 653254 653254 Herman, William, of Ely, Cambs, gent 0
5184733 2411285 2411285 defendant Herman William gent 653254 653254 Herman, William, of Ely, Cambs, gent 0
5185088 2411378 2411378 defendant Nevyle Thomas yeoman 653254 653254 Nevyle, Thomas, of Ely, Cambs, yeoman 0
5186194 2411711 2411711 defendant Grandon Nicholas chandler 653254 653254 Grandon, Nicholas, of Ely, Cambs, chandler 3
5186198 2411712 2411712 defendant Grandon Nicholas chandler 653254 653254 Grandon, Nicholas, of Ely, Cambs, chandler 2
5188223 2412268 2412268 defendant Herman William gent 653254 653254 Herman, William, of Ely, Cambs, gent 2
5189055 2412532 2412532 defendant (not given) William prior of Wellys 653254 653254 Wellys, William, of Ely, Cambs, prior of the cathedral church 0
5189445 2412652 2412652 defendant Bradewey Richard smith 653254 653254 Bradewey, Richard, of Ely, Cambs, smith 0
5189448 2412653 2412653 defendant Bradewey Richard smith 653254 653254 Bradewey, Richard, of Ely, Cambs, smith 0
5197217 2414924 2414924 defendant (not given) William prior of Welles 653254 653254 Welles, William, of Ely, Cambs, prior of the cathedral church 0
5197223 2414925 2414925 defendant (not given) William prior of Welles 653254 653254 Welles, William, of Ely, Cambs, prior of the cathedral church 0
5205113 2417253 2417253 defendant Grandon Nicholas chandler 653254 653254 Grandon, Nicholas, of Ely, Cambs, chandler 3
5205118 2417254 2417254 defendant Grandon Nicholas   653254 653254 Grandon, Nicholas, of Ely, Cambs 3
5206353 2417594 2417594 defendant (not given) William prior of Wellys 653254 653254 Wellys, William, of Ely, Cambs, prior of the cathedral church 0
5209989 2418652 2418652 defendant (not given) William prior of Welles 653254 653254 Welles, William, of Ely, Cambs, prior of the cathedral church 0
5269995 2436330 2436330 defendant Everard Robert husbandman 653254 653254 Everard, Robert, of Ely, Cambs, husbandman 0
5274242 2437545 2437545 defendant Chaundeler alias Grandon Nicholas yeoman 653254 653254 Chaundeler alias Grandon, Nicholas, of Ely, Cambs, yeoman 0
5274244 2437546 2437546 defendant Chaundeler Nicholas yeoman 653254 653254 Chaundeler, Nicholas, of Ely, Cambs, yeoman 0
5300504 2445112 2445112 defendant Hastyngys Robert esq 653254 653254 Hastyngys, Robert, of Ely, Cambs, esq 4
5305915 2446754 2446754 defendant Barnard John esq 653254 653254 Barnard, John, of Ely, Cambs, esq 2
5311572 2448485 2448485 defendant Brewode John gent 653254 653254 Brewode, John, of Ely, Cambs, gent 0
5374992 2467771 2467771 defendant Persons Thomas (legal representative) 653254 653254 Persons, Thomas, of Ely, Cambs, gent, executor of 0
5375360 2467882 2467882 defendant Gray Thomas mercer 653254 653254 Gray, Thomas, of Ely, Cambs, mercer 0
5375362 2467883 2467883 defendant Grey Thomas mercer 653254 653254 Grey, Thomas, of Ely, Cambs, mercer 0
5376652 2468291 2468291 defendant Clederhowe Clement gent 653254 653254 Clederhowe, Clement, of Ely, Cambs, gent 3
5382429 2470033 2470033 defendant Gray Thomas mercer 653254 653254 Gray, Thomas, of Ely, Cambs, mercer 0
5391747 2472713 2472713 defendant Gray Thomas mercer 653254 653254 Gray, Thomas, of Ely, Cambs, mercer 0
5392804 2473010 2473010 defendant Clederhowe Clement gent 653254 653254 Clederhowe, Clement, of Ely, Cambs, gent 4
5403309 2476023 2476023 defendant Gray Thomas yeoman 653254 653254 Gray, Thomas, of Ely, Cambs, yeoman 0
5404434 2476337 2476337 defendant Sproo Thomas husbandman 653254 653254 Sproo, Thomas, of Ely, Cambs, husbandman 2
5412669 2478736 2478736 defendant Roray Edmund clerk 653254 653254 Roray, Edmund, of Ely, Cambs, clerk 0
5413836 2479062 2479062 defendant Wryght John yeoman 653254 653254 Wryght, John, of Ely, Cambs, yeoman 3
5416358 2479810 2479810 defendant Gray Thomas yeoman 653254 653254 Gray, Thomas, of Ely, Cambs, yeoman 0
5417551 2480169 2480169 defendant Sproo Thomas husbandman 653254 653254 Sproo, Thomas, of Ely, Cambs, husbandman 2
5429226 2483668 2483668 defendant Wryght John yeoman 653254 653254 Wryght, John, of Ely, Cambs, yeoman 3
5429227 2483668 2483668 defendant Marteyn William chapman 653254 653254 Marteyn, William, of Ely, Cambs, chapman 4
5429232 2483669 2483669 defendant Wryght John yeoman 653254 653254 Wryght, John, of Ely, Cambs, yeoman 3

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