names

92 rows where place_id = 587915

✎ 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
3592818 1865367 1865367 defendant Levald or Lenald Robert husbandman 587915 587915 Levald or Lenald, Robert, of Gyssyng, husbandman 0
3625279 1875442 1875442 defendant Norman Robert husbandman 587915 587915 Norman, Robert, of Gyssyng, husbandman 0
3649522 1910240 1910240 defendant Gatby alias Monnford John husbandman 587915 587915 Gatby alias Monnford, John, of Gyssyng, husbandman 0
3696165 1925022 1925022 defendant Puddyng Thomas (legal representative) 587915 587915 Puddyng, Thomas, of Gyssyng, yeoman, administratrix of 0
3736749 1937744 1937744 plaintiff Kempe Bartholomew gent 587915 587915 Kempe, Bartholomew, of Gyssyng, gent 0
3742016 1939371 1939371 defendant Snees John husbandman 587915 587915 Snees, John, of Gyssyng, husbandman 1
3772658 1949140 1949140 defendant Kempe Robert (legal representative) 587915 587915 Kempe, Robert, of Gyssyng, gent, executors of 0
3772659 1949140 1949140 defendant Kempe Bartholomew esq 587915 587915 (Kempe, Bartholomew, of Gyssyng, esq 1
3774077 1949607 1949607 defendant Chatesham John tailor 587915 587915 Chatesham, John, of Gyssyng, tailor 1
3789278 1954464 1954464 defendant Foster John husbandman 587915 587915 Foster, John, of Gyssyng, husbandman 1
3830487 1967414 1967414 defendant Chapelyn Alan chaplain 587915 587915 Chapelyn, Alan, of Gyssyng, chaplain 0
3848656 1973164 1973164 defendant Royse Edmund husbandman 587915 587915 Royse, Edmund, of Gyssyng, husbandman 0
3864266 1978241 1978241 defendant Cordwayner James cooper 587915 587915 Cordwayner, James, of Gyssyng, cooper 2
3904459 1991738 1991738 defendant Avelyn John, senior husbandman 587915 587915 Avelyn, John, senior, of Gyssyng, husbandman 0
3904460 1991738 1991738 defendant Fulcher Robert husbandman 587915 587915 Fulcher, Robert, of Gyssyng, husbandman 1
3963725 2011918 2011918 defendant Cobbe John carpenter 587915 587915 Cobbe, John, of Gyssyng, carpenter 1
3969717 2014015 2014015 defendant Marten John husbandman 587915 587915 Marten, John, of Gyssyng, husbandman 0
4026994 2034305 2034305 defendant Row William draper 587915 587915 Row, William, of Gyssyng, draper 0
4026999 2034306 2034306 defendant Rowe William draper 587915 587915 Rowe, William, of Gyssyng, draper 0
4035353 2037318 2037318 plaintiff Hillton Hugh drover 587915 587915 Hillton, Hugh, of Gyssyng, drover 0
4061502 2046513 2046513 defendant Thurborn Robert glover 587915 587915 Thurborn, Robert, of Gyssyng, glover 3
4067204 2048570 2048570 defendant Fulcher Leonard weaver 587915 587915 Fulcher, Leonard, of Gyssyng, weaver 0
4291506 2127035 2127035 defendant Hasting James butcher 587915 587915 Hasting, James, of Gyssyng, butcher 0
4443536 2182945 2182945 defendant Gardeneyr Thomas   587915 587915 Gardeneyr, Thomas, of Gyssyng 0
4546245 2214769 2214769 defendant Avelyn Henry   587915 587915 Avelyn, Henry, of Gyssyng 0
4674306 2257572 2257572 defendant Rumburgh John yeoman 587915 587915 Rumburgh, John, of Gyssyng, yeoman 1
4699442 2265283 2265283 defendant Speed William cooper 587915 587915 Speed, William, of Gyssyng, cooper 1
4770002 2286589 2286589 defendant Cartere Thomas yeoman 587915 587915 Cartere, Thomas, of Gyssyng, yeoman 0
4893534 2324678 2324678 defendant Balle Robert clerk 587915 587915 Balle, Robert, of Gyssyng, clerk 0
4909079 2329380 2329380 plaintiff Balle Robert   587915 587915 Balle, Robert, of Gyssyng, vicar 0
4913916 2330859 2330859 defendant Olyver William yeoman 587915 587915 Olyver, William, of Gyssyng, yeoman 3
4925902 2334531 2334531 defendant Carman John husbandman 587915 587915 Carman, John, of Gyssyng, husbandman 4
4943151 2339830 2339830 defendant Breton William yeoman 587915 587915 Breton, William, of Gyssyng, yeoman 2
4944181 2340152 2340152 defendant Hoo Thomas smith 587915 587915 Hoo, Thomas, of Gyssyng, smith 0
4947908 2341330 2341330 defendant Breton William husbandman 587915 587915 Breton, William, of Gyssyng, husbandman 1
4963074 2345863 2345863 defendant Smyth John laborer 587915 587915 Smyth, John, of Gyssyng, laborer 0
4977144 2350118 2350118 defendant Bacon Nicholas chandler 587915 587915 Bacon, Nicholas, of Gyssyng, chandler 3
4981026 2351258 2351258 defendant Hoo Thomas yeoman 587915 587915 Hoo, Thomas, of Gyssyng, yeoman 1
4995103 2355392 2355392 defendant Olyver William husbandman 587915 587915 Olyver, William, of Gyssyng, husbandman 2
5030101 2365675 2365675 defendant Olyver William yeoman 587915 587915 Olyver, William, of Gyssyng, yeoman 1
5059101 2374287 2374287 defendant Hoo Thomas smith 587915 587915 Hoo, Thomas, of Gyssyng, smith 0
5061655 2375077 2375077 defendant Bacon Henry butcher 587915 587915 Bacon, Henry, of Gyssyng, butcher 0
5061657 2375077 2375077 defendant Gore John peddler 587915 587915 Gore, John, of Gyssyng, peddler 2
5092647 2384228 2384228 defendant Bacon Henry husbandman 587915 587915 Bacon, Henry, of Gyssyng, husbandman 1
5097370 2385660 2385660 defendant Smyth Robert butcher 587915 587915 Smyth, Robert, of Gyssyng, butcher 2
5115730 2391029 2391029 defendant Hoo Thomas smith 587915 587915 Hoo, Thomas, of Gyssyng, smith 1
5130339 2395361 2395361 defendant Hoo Thomas yeoman 587915 587915 Hoo, Thomas, of Gyssyng, yeoman 0
5130340 2395361 2395361 defendant Hoo John yeoman 587915 587915 Hoo, John, of Gyssyng, yeoman 1
5149683 2401036 2401036 defendant Hoo Thomas yeoman 587915 587915 Hoo, Thomas, of Gyssyng, yeoman 0
5149684 2401036 2401036 defendant Hoo John yeoman 587915 587915 Hoo, John, of Gyssyng, yeoman 1
5219242 2421352 2421352 defendant Bokon Henry husbandman 587915 587915 Bokon, Henry, of Gyssyng, husbandman 0
5219243 2421352 2421352 defendant Kempe alias Tayllour Robert tailor 587915 587915 Kempe alias Tayllour, Robert, of Gyssyng, tailor 1
5243989 2428431 2428431 defendant Bakon Henry butcher 587915 587915 Bakon, Henry, of Gyssyng, butcher 1
5243995 2428432 2428432 defendant Bakon Henry butcher 587915 587915 Bakon, Henry, of Gyssyng, butcher 1
5253048 2431059 2431059 defendant Bacon Henry yeoman 587915 587915 Bacon, Henry, of Gyssyng, yeoman 1
5254356 2431490 2431490 defendant Clerkson William yeoman 587915 587915 Clerkson, William, of Gyssyng, yeoman 5
5262585 2434041 2434041 defendant Bakton John butcher 587915 587915 Bakton, John, of Gyssyng, butcher 0
5266426 2435246 2435246 defendant Clerkson John husbandman 587915 587915 Clerkson, John, of Gyssyng, husbandman 0
5273095 2437204 2437204 defendant Kempe Robert tailor 587915 587915 Kempe, Robert, of Gyssyng, tailor 3
5273119 2437208 2437208 defendant (illegible) Robert   587915 587915 ---, Robert, of Gyssyng, vicar 4
5279387 2439056 2439056 defendant Bakon Henry butcher 587915 587915 Bakon, Henry, of Gyssyng, butcher 4
5283123 2440124 2440124 defendant Lane Robert husbandman 587915 587915 Lane, Robert, of Gyssyng, husbandman 2
5287507 2441369 2441369 defendant Bacon John butcher 587915 587915 Bacon, John, of Gyssyng, butcher 1
5288839 2441745 2441745 defendant Bacon Henry husbandman 587915 587915 Bacon, Henry, of Gyssyng, husbandman 3
5290963 2442359 2442359 defendant Avelyn Henry husbandman 587915 587915 Avelyn, Henry, of Gyssyng, husbandman 1
5302129 2445593 2445593 defendant Lane Robert husbandman 587915 587915 Lane, Robert, of Gyssyng, husbandman 0
5305794 2446738 2446738 defendant Hertyshorn Thomas esq 587915 587915 Hertyshorn, Thomas, of Gyssyng, esq 3
5331029 2454345 2454345 defendant Hordon alias Koort John husbandman or pedder 587915 587915 Hordon alias Koort, John, of Gyssyng, husbandman or pedder 0
5346851 2459172 2459172 defendant Clerkeson William   587915 587915 Clerkeson, William, of Gyssyng, husbandman, administrators of 0
5355591 2461823 2461823 plaintiff Kempp Robert gent 587915 587915 Kempp, Robert, of Gyssyng, gent 0
5367515 2465486 2465486 defendant Yong Henry husbandman 587915 587915 Yong, Henry, of Gyssyng, husbandman 0
5380907 2469595 2469595 defendant Cort John husbandman 587915 587915 Cort, John, of Gyssyng, husbandman 0
5381740 2469836 2469836 defendant Martyn John husbandman 587915 587915 Martyn, John, of Gyssyng, husbandman 0
5384200 2470568 2470568 defendant Cort John husbandman 587915 587915 Cort, John, of Gyssyng, husbandman 2
5384204 2470569 2470569 defendant Cort John husbandman 587915 587915 Cort, John, of Gyssyng, husbandman 0
5391633 2472677 2472677 defendant Hoxdorn John   587915 587915 Hoxdorn, John, of Gyssyng, pedlar 0
5398893 2474749 2474749 defendant Norman John   587915 587915 Norman, John, of Gyssyng 0
5398894 2474749 2474749 defendant Norman Robert husbandman 587915 587915 Norman, Robert, of Gyssyng, husbandman 1
5399224 2474848 2474848 defendant Cort John   587915 587915 Cort, John, of Gyssyng 0
5409735 2477888 2477888 defendant Cort John husbandman 587915 587915 Cort, John, of Gyssyng, husbandman 1
5448554 2489465 2489465 defendant Vynt John clerk 587915 587915 Vynt, John, of Gyssyng, clerk 1
5450450 2490021 2490021 defendant Broun Robert husbandman 587915 587915 Broun, Robert, of Gyssyng, husbandman 0
5481621 2499433 2499433 defendant Lyng John yeoman 587915 587915 Lyng, John, of Gyssyng, yeoman 4
5481629 2499435 2499435 defendant Bate Robert clerk 587915 587915 Bate, Robert, of Gyssyng, clerk 0
5481630 2499435 2499435 defendant Lynge John yeoman 587915 587915 together with Lynge, John, of Gyssyng, yeoman 1
5481635 2499437 2499437 defendant Bate Robert clerk 587915 587915 Bate, Robert, of Gyssyng, clerk 1
5481637 2499438 2499438 defendant Lynge John yeoman 587915 587915 Lynge, John, of Gyssyng, yeoman 0
5481638 2499438 2499438 defendant Bate Robert clerk 587915 587915 together with Bate, Robert, of Gyssyng, clerk 1
5492718 2502738 2502738 defendant Norman John husbandman 587915 587915 Norman, John, of Gyssyng, husbandman 0
5492719 2502738 2502738 defendant Norman Robert husbandman 587915 587915 Norman, Robert, of Gyssyng, husbandman 1
5578362 2528303 2528303 defendant Judson Richard yeoman 587915 587915 Judson, Richard, of Gyssyng, yeoman 0
5604094 2536142 2536142 defendant Kempe Thomas laborer 587915 587915 Kempe, Thomas, of Gyssyng, laborer 1

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