names

101 rows where place_id = 587760

✎ 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
3592357 1865225 1865225 defendant Cok Richard yeoman 587760 587760 Cok, Richard, of Eston Bavent, yeoman 1
3592358 1865225 1865225 defendant Well William mariner 587760 587760 Well, William, of Eston Bavent, mariner 2
3596411 1866508 1866508 plaintiff Peirs John   587760 587760 Peirs, John, of Eston Bavent 0
3596561 1866560 1866560 plaintiff Pires John   587760 587760 Pires, John, of Eston Bavent 0
3606221 1869615 1869615 defendant Butte John (legal representative) 587760 587760 Butte, John, of Eston Bavent, mariner, executors of 0
3606222 1869615 1869615 defendant Butte Emma widow 587760 587760 (Butte, Emma, of Eston Bavent, widow 1
3606223 1869615 1869615 defendant Butte Henry mariner 587760 587760 Butte, Henry, of Eston Bavent, mariner 2
3606896 1869822 1869822 plaintiff Peyrs John   587760 587760 Peyrs, John, of Eston Bavent 0
3607763 1870078 1870078 defendant Clayson John mariner 587760 587760 Clayson, John, of Eston Bavent, mariner 0
3616980 1872931 1872931 defendant Mekylhawe Henry butcher 587760 587760 Mekylhawe, Henry, of Eston Bavent, butcher 2
3647868 1909729 1909729 defendant Spencer James yeoman 587760 587760 Spencer, James, of Eston Bavent, yeoman 2
3753682 1943092 1943092 defendant Wellys Nicholas mariner 587760 587760 Wellys, Nicholas, of Eston Bavent, mariner 0
3761743 1945683 1945683 defendant Gyllett William shoemaker 587760 587760 Gyllett, William, of Eston Bavent, shoemaker 2
3761744 1945683 1945683 defendant Edwardys William   587760 587760 Edwardys, William, of Eston Bavent 3
3804415 1959318 1959318 defendant Thomas alias Phelyp Robert mariner 587760 587760 Thomas alias Phelyp, Robert, of Eston Bavent, mariner 0
3832380 1968047 1968047 defendant Bacon Thomas husbandman 587760 587760 Bacon, Thomas, of Eston Bavent, husbandman 0
3837593 1969666 1969666 plaintiff Sponer James   587760 587760 Sponer, James, of Eston Bavent 0
3840856 1970709 1970709 defendant Ussher John mariner 587760 587760 Ussher, John, of Eston Bavent, mariner 1
3892794 1987839 1987839 defendant Nycollys Robert mariner 587760 587760 Nycollys, Robert, of Eston Bavent, mariner 3
3932659 2001219 2001219 defendant Gardener Robert gent 587760 587760 Gardener, Robert, of Eston Bavent, gent 0
3967049 2013101 2013101 plaintiff Browne Nicholas husbandman 587760 587760 Browne, Nicholas, of Eston Bavent, husbandman 0
4063577 2047262 2047262 defendant Calfe Robert husbandman 587760 587760 Calfe, Robert, of Eston Bavent, husbandman 1
4063580 2047263 2047263 defendant Calse or Calfe Robert husbandman 587760 587760 Calse or Calfe, Robert, of Eston Bavent, husbandman 1
4139909 2074640 2074640 defendant Doughtie John husbandman 587760 587760 Doughtie, John, of Eston Bavent, husbandman 3
4662991 2249889 2249889 plaintiff Gardener Thomas   587760 587760 Gardener, Thomas, of Eston Bavent 0
4722158 2272261 2272261 defendant Bocher Richard butcher 587760 587760 Bocher, Richard, of Eston Bavent, butcher 1
4754085 2281657 2281657 defendant Mower John shipman 587760 587760 Mower, John, of Eston Bavent, shipman 0
4804608 2297635 2297635 defendant Bocher Richard butcher 587760 587760 Bocher, Richard, of Eston Bavent, butcher 0
4844957 2309943 2309943 plaintiff Notyngham John   587760 587760 Notyngham, John, of Eston Bavent 0
4846259 2310333 2310333 plaintiff Pope John   587760 587760 Pope, John, of Eston Bavent 0
4861789 2315061 2315061 defendant Turry Ralph yeoman 587760 587760 Turry, Ralph, of Eston Bavent, yeoman 0
4865144 2316073 2316073 plaintiff Gardenere Geoffrey   587760 587760 Gardenere, Geoffrey, of Eston Bavent 0
4873866 2318765 2318765 plaintiff Pope John   587760 587760 Pope, John, of Eston Bavent 0
4878413 2320191 2320191 defendant Clubbard Richard yeoman 587760 587760 Clubbard, Richard, of Eston Bavent, yeoman 2
4884106 2321939 2321939 defendant Bocher Richard husbandman 587760 587760 Bocher, Richard, of Eston Bavent, husbandman 2
4891857 2324189 2324189 defendant Sparhauk John husbandman 587760 587760 Sparhauk, John, of Eston Bavent, husbandman 0
4949971 2341961 2341961 plaintiff Notyngham John   587760 587760 Notyngham, John, of Eston Bavent 0
4952052 2342584 2342584 defendant Sparhawk Robert   587760 587760 Sparhawk, Robert, of Eston Bavent, holy water clerk 0
4978229 2350439 2350439 defendant Sparhauk Ralph husbandman 587760 587760 Sparhauk, Ralph, of Eston Bavent, husbandman 1
4986648 2352938 2352938 defendant Erll John shipman 587760 587760 Erll, John, of Eston Bavent, shipman 3
5060739 2374792 2374792 defendant Prentys John shipman 587760 587760 Prentys, John, of Eston Bavent, shipman 0
5060741 2374792 2374792 defendant Gyle John yeoman 587760 587760 Gyle, John, of Eston Bavent, yeoman 2
5109335 2389159 2389159 defendant Lytyll Robert shipman 587760 587760 Lytyll, Robert, of Eston Bavent, shipman 0
5109367 2389168 2389168 defendant Tebald John shipman 587760 587760 Tebald, John, of Eston Bavent, shipman 2
5109368 2389169 2389169 plaintiff Gardener John   587760 587760 Gardener, John, of Eston Bavent 0
5120980 2392569 2392569 defendant Childerhous Thomas yeoman 587760 587760 Childerhous, Thomas, of Eston Bavent, yeoman 2
5163089 2404932 2404932 defendant Childerhous Richard shipman 587760 587760 Childerhous, Richard, of Eston Bavent, shipman 0
5184843 2411315 2411315 defendant Smyth William mariner 587760 587760 Smyth, William, of Eston Bavent, mariner 2
5184844 2411315 2411315 defendant Westwynd Peter yeoman 587760 587760 Westwynd, Peter, of Eston Bavent, yeoman 3
5199486 2415597 2415597 defendant Childerhous Richard shipman 587760 587760 Childerhous, Richard, of Eston Bavent, shipman 0
5204567 2417084 2417084 defendant Smyth William mariner 587760 587760 Smyth, William, of Eston Bavent, mariner 2
5205992 2417484 2417484 defendant Childerhous John yeoman 587760 587760 Childerhous, John, of Eston Bavent, yeoman 0
5220394 2421660 2421660 defendant Lynde William butcher 587760 587760 Lynde, William, of Eston Bavent, butcher 1
5220398 2421661 2421661 defendant Lynde William butcher 587760 587760 Lynde, William, of Eston Bavent, butcher 1
5237419 2426528 2426528 plaintiff Gamyll Henry   587760 587760 Gamyll, Henry, of Eston Bavent 0
5281819 2439755 2439755 defendant Smyth William shipman 587760 587760 Smyth, William, of Eston Bavent, shipman 0
5380625 2469507 2469507 defendant Frank John mariner 587760 587760 Frank, John, of Eston Bavent, mariner 1
5385451 2470910 2470910 defendant Phelip John mariner 587760 587760 Phelip, John, of Eston Bavent, mariner 0
5385452 2470910 2470910 defendant Franke John mariner 587760 587760 Franke, John, of Eston Bavent, mariner 1
5397606 2474383 2474383 defendant Phelip John mariner 587760 587760 Phelip, John, of Eston Bavent, mariner 0
5397607 2474383 2474383 defendant Frank John mariner 587760 587760 Frank, John, of Eston Bavent, mariner 1
5418095 2480338 2480338 defendant Leveriche William shipman 587760 587760 Leveriche, William, of Eston Bavent, shipman 0
5435427 2485537 2485537 plaintiff Pyers John   587760 587760 Pyers, John, of Eston Bavent 0
5435844 2485662 2485662 defendant Leveriche William shipman 587760 587760 Leveriche, William, of Eston Bavent, shipman 0
5450487 2490031 2490031 plaintiff Pyers John   587760 587760 Pyers, John, of Eston Bavent 0
5459563 2492772 2492772 defendant Gardener William mariner 587760 587760 Gardener, William, of Eston Bavent, mariner 1
5459564 2492772 2492772 defendant Joye Richard mariner 587760 587760 Joye, Richard, of Eston Bavent, mariner 2
5462627 2493734 2493734 plaintiff Pyers John   587760 587760 Pyers, John, of Eston Bavent 0
5463195 2493907 2493907 defendant Philip John mariner 587760 587760 Philip, John, of Eston Bavent, mariner 2
5463202 2493908 2493908 defendant Philip John mariner 587760 587760 Philip, John, of Eston Bavent, mariner 2
5471279 2496346 2496346 defendant Gardener William mariner 587760 587760 Gardener, William, of Eston Bavent, mariner 1
5471280 2496346 2496346 defendant Joye Richard mariner 587760 587760 Joye, Richard, of Eston Bavent, mariner 2
5474761 2497433 2497433 defendant Philip John mariner 587760 587760 Philip, John, of Eston Bavent, mariner 2
5486375 2500810 2500810 defendant Phelip John mariner 587760 587760 (Phelip, John, of Eston Bavent, mariner 4
5496485 2503857 2503857 defendant Childerhous John husbandman 587760 587760 Childerhous, John, of Eston Bavent, husbandman 3
5510730 2508195 2508195 defendant Childerrous John yeoman 587760 587760 Childerrous, John, of Eston Bavent, yeoman 0
5511445 2508424 2508424 defendant Childerhous John husbandman 587760 587760 Childerhous, John, of Eston Bavent, husbandman 3
5520362 2511190 2511190 defendant Chery William miller 587760 587760 Chery, William, of Eston Bavent, miller 0
5520363 2511190 2511190 defendant Osberne William husbandman 587760 587760 Osberne, William, of Eston Bavent, husbandman 1
5529391 2513706 2513706 plaintiff Peirs John   587760 587760 Peirs, John, of Eston Bavent 0
5529393 2513706 2513706 defendant Smyth Richard mariner 587760 587760 Smyth, Richard, of Eston Bavent, mariner 1
5535420 2515606 2515606 defendant Smyth Richard mariner 587760 587760 Smyth, Richard, of Eston Bavent, mariner 0
5542362 2517736 2517736 plaintiff Meke Nicholas (legal representative) 587760 587760 Meke, Nicholas, of Eston Bavent, executors of 0
5542366 2517736 2517736 defendant Gardyner William, senior mariner 587760 587760 Gardyner, William, senior, of Eston Bavent, mariner 0
5542367 2517736 2517736 defendant Serle Robert (legal representative) 587760 587760 Serle, Robert, of Eston Bavent, husbandman, executors of 1
5543476 2518077 2518077 plaintiff Peirs John merchant 587760 587760 Peirs, John, of Eston Bavent, merchant 0
5543641 2518118 2518118 defendant Smyth Richard mariner 587760 587760 Smyth, Richard, of Eston Bavent, mariner 0
5552237 2520697 2520697 defendant Butte Henry yeoman 587760 587760 Butte, Henry, of Eston Bavent, yeoman 1
5552240 2520698 2520698 defendant Butte Henry yeoman 587760 587760 Butte, Henry, of Eston Bavent, yeoman 1
5555514 2521614 2521614 defendant Bacon William shipman 587760 587760 Bacon, William, of Eston Bavent, shipman 0
5555515 2521614 2521614 defendant Rednale Robert yeoman 587760 587760 Rednale, Robert, of Eston Bavent, yeoman 1
5555516 2521614 2521614 defendant Hankyn or Haukyn Robert yeoman 587760 587760 Hankyn or Haukyn, Robert, of Eston Bavent, yeoman 2
5558491 2522431 2522431 defendant Roule Edward husbandman 587760 587760 Roule, Edward, of Eston Bavent, husbandman 0
5558492 2522431 2522431 defendant Chylderhouse John husbandman 587760 587760 Chylderhouse, John, of Eston Bavent, husbandman 1
5569339 2525590 2525590 defendant Spencer John mariner 587760 587760 Spencer, John, of Eston Bavent, mariner 1
5578981 2528496 2528496 defendant Hokelle William butcher 587760 587760 Hokelle, William, of Eston Bavent, butcher 1
5585678 2530591 2530591 defendant Chery John husbandman 587760 587760 Chery, John, of Eston Bavent, husbandman 1
5593071 2532816 2532816 defendant Tomson alias Phelyp Alice widow 587760 587760 Tomson alias Phelyp, Alice, of Eston Bavent, widow 0
5593074 2532816 2532816 defendant Boortor John husbandman 587760 587760 Boortor, John, of Eston Bavent, husbandman 3
5601727 2535441 2535441 defendant Pers henry mariner 587760 587760 Pers, henry, of Eston Bavent, mariner 6

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