names

138 rows where place_id = 586782

✎ 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
3587530 1863748 1863748 defendant Hoker Robert   586782 586782 Hoker, Robert, of Leystoft, "swyllemaker" 1
3589610 1864391 1864391 defendant Dewyll Richard beer brewer 586782 586782 Dewyll, Richard, of Leystoft, beer brewer 1
3600322 1867747 1867747 defendant Davys Thomas butcher 586782 586782 Davys, Thomas, of Leystoft, butcher 1
3609046 1870486 1870486 plaintiff Tabarrer William   586782 586782 Tabarrer, William, of Leystoft 1
3646748 1909387 1909387 plaintiff Johnson Cornelius   586782 586782 Johnson, Cornelius, of Leystoft, mariner, administrators of 0
3652556 1911131 1911131 defendant Jettur Nicholas (legal representative) 586782 586782 Jettur, Nicholas, of Leystoft, yeoman, administratrix of 4
3652557 1911131 1911131 defendant Jettor Margaret widow 586782 586782 Jettor, Margaret, of Leystoft, widow 5
3723407 1933587 1933587 defendant Lobbys Geoffrey yeoman 586782 586782 Lobbys, Geoffrey, of Leystoft, yeoman 6
3738625 1938290 1938290 defendant Botyswyn John baker 586782 586782 Botyswyn, John, of Leystoft, baker 0
3740169 1938784 1938784 defendant Sellyng Richard yeoman 586782 586782 Sellyng, Richard, of Leystoft, yeoman 0
3741018 1939051 1939051 defendant Everard John mariner 586782 586782 Everard, John, of Leystoft, mariner 0
3761417 1945584 1945584 defendant Gare Robert shipman 586782 586782 Gare, Robert, of Leystoft, shipman 0
3782040 1952134 1952134 plaintiff Hoddys Robert, senior   586782 586782 Hoddys, Robert, senior, of Leystoft 0
3786009 1953417 1953417 defendant Palmer John gent 586782 586782 Palmer, John, of Leystoft, gent 1
3786010 1953417 1953417 defendant Gere Robert yeoman 586782 586782 Gere, Robert, of Leystoft, yeoman 2
3792273 1955436 1955436 defendant Shotysham Thomas nutcher 586782 586782 Shotysham, Thomas, of Leystoft, nutcher 0
3802048 1958538 1958538 defendant Cove John butcher 586782 586782 Cove, John, of Leystoft, butcher 0
3808029 1960402 1960402 defendant Lobbys Geoffrey yeoman 586782 586782 Lobbys, Geoffrey, of Leystoft, yeoman 0
3808030 1960402 1960402 defendant Cove John butcher 586782 586782 Cove, John, of Leystoft, butcher 1
3808032 1960402 1960402 defendant Greme Robert mariner 586782 586782 Greme, Robert, of Leystoft, mariner 3
3812814 1961905 1961905 defendant Jamys Richard shoemaker 586782 586782 Jamys, Richard, of Leystoft, shoemaker 0
3820840 1964409 1964409 defendant Parnell Thomas husbandman 586782 586782 Parnell, Thomas, of Leystoft, husbandman 2
3826791 1966232 1966232 defendant Lobbys Geoffrey (legal representative) 586782 586782 Lobbys, Geoffrey, of Leystoft, yeoman, executors of 1
3826800 1966234 1966234 defendant Lobbys Geoffrey (legal representative) 586782 586782 Lobbys, Geoffrey, of Leystoft, yeoman, executors of 1
3832216 1967988 1967988 plaintiff Hoddys Robert, senior   586782 586782 Hoddys, Robert, senior, of Leystoft 0
3832996 1968238 1968238 defendant Bull Simon husbandman 586782 586782 Bull, Simon, of Leystoft, husbandman 1
3846270 1972391 1972391 defendant Wyllett Robert weaver 586782 586782 Wyllett, Robert, of Leystoft, weaver 1
3848559 1973133 1973133 plaintiff Jettor John merchant 586782 586782 Jettor, John, of Leystoft, merchant 0
3857817 1976084 1976084 defendant Bulle Simon yeoman 586782 586782 Bulle, Simon, of Leystoft, yeoman 0
3863852 1978087 1978087 plaintiff Jettur John merchant 586782 586782 Jettur, John, of Leystoft, merchant 0
3870980 1980546 1980546 defendant Burgatt James tailor 586782 586782 Burgatt, James, of Leystoft, tailor 1
3872575 1981049 1981049 defendant Ussher Christopher mariner 586782 586782 Ussher, Christopher, of Leystoft, mariner 0
3872576 1981049 1981049 defendant Davy Richard butcher 586782 586782 Davy, Richard, of Leystoft, butcher 1
3872577 1981049 1981049 defendant Melton Robert mariner 586782 586782 Melton, Robert, of Leystoft, mariner 2
3875050 1981884 1981884 defendant Bottyswayn John baker or beer brewer 586782 586782 Bottyswayn, John, of Leystoft, baker or beer brewer 0
3876883 1982510 1982510 defendant Aleyn Thomas draper 586782 586782 Aleyn, Thomas, of Leystoft, draper 1
3879983 1983563 1983563 defendant Den Joan widow 586782 586782 Den, Joan, of Leystoft, widow 1
3888085 1986270 1986270 defendant Shanke Etheldreda widow 586782 586782 Shanke, Etheldreda, of Leystoft, widow 0
3890233 1986978 1986978 plaintiff Heron Arthur mariner 586782 586782 Heron, Arthur, of Leystoft, mariner 0
3892455 1987721 1987721 defendant Cotman Stephen mariner 586782 586782 Cotman, Stephen, of Leystoft, mariner 0
3896127 1988908 1988908 defendant Rypyng John husbandman 586782 586782 Rypyng, John, of Leystoft, husbandman 1
3897727 1989447 1989447 defendant Gryffyn John sherman 586782 586782 Gryffyn, John, of Leystoft, sherman 4
3899442 1990027 1990027 plaintiff Besfeld Thomas mariner 586782 586782 Besfeld, Thomas, of Leystoft, mariner 0
3900045 1990236 1990236 defendant Baker alias Culleys William baker 586782 586782 Baker alias Culleys, William, of Leystoft, baker 0
3900046 1990236 1990236 defendant Holmes John merchant 586782 586782 Holmes, John, of Leystoft, merchant 1
3903343 1991341 1991341 defendant Bonyvaunt John   586782 586782 Bonyvaunt, John, of Leystoft, "keleman" 1
3905181 1991997 1991997 plaintiff Jetter James   586782 586782 Jetter, James, of Leystoft 0
3913480 1994846 1994846 plaintiff Besfeld Thomas mariner 586782 586782 Besfeld, Thomas, of Leystoft, mariner 0
3947852 2006312 2006312 plaintiff Cooke Robert merchant 586782 586782 Cooke, Robert, of Leystoft, merchant 0
3970015 2014108 2014108 plaintiff Cullyer John yeoman 586782 586782 Cullyer, John, of Leystoft, yeoman 0
4022141 2032648 2032648 plaintiff Annott Thomas merchant 586782 586782 Annott, Thomas, of Leystoft, merchant 0
4022143 2032648 2032648 defendant Legett Richard glover 586782 586782 Legett, Richard, of Leystoft, glover 1
4042651 2039846 2039846 plaintiff Payne Gregory (legal representative) 586782 586782 Payne, Gregory, of Leystoft, gent, administrator of 0
4516571 2205593 2205593 defendant Spenser William   586782 586782 together with Spenser, William, of Leystoft 1
4594745 2229614 2229614 defendant Garveys William   586782 586782 Garveys, William, of Leystoft 0
4600968 2231530 2231530 plaintiff Turnour Geoffrey   586782 586782 Turnour, Geoffrey, of Leystoft 0
4611982 2234808 2234808 defendant Sudbury John   586782 586782 Sudbury, John, of Leystoft 0
4637240 2242443 2242443 defendant Halman John   586782 586782 Halman, John, of Leystoft 0
4658493 2248534 2248534 defendant Glover John yeoman 586782 586782 Glover, John, of Leystoft, yeoman 5
4664179 2250284 2250284 defendant Dane William butcher 586782 586782 Dane, William, of Leystoft, butcher 0
4683080 2260324 2260324 defendant Edward Henry butcher 586782 586782 Edward, Henry, of Leystoft, butcher 3
4683083 2260325 2260325 plaintiff Edward Henry   586782 586782 Edward, Henry, of Leystoft 2
4683088 2260326 2260326 plaintiff Edward Henry   586782 586782 Edward, Henry, of Leystoft 2
4722292 2272296 2272296 defendant Edward Henry butcher 586782 586782 Edward, Henry, of Leystoft, butcher 0
4727911 2273971 2273971 defendant Pykeryng John bucher 586782 586782 Pykeryng, John, of Leystoft, bucher 0
4742788 2278399 2278399 defendant Stengate Henry roper 586782 586782 Stengate, Henry, of Leystoft, roper 0
4742789 2278399 2278399 defendant Stengate John laborer 586782 586782 Stengate, John, of Leystoft, laborer 1
4745410 2279165 2279165 defendant Milys Thomas yeoman 586782 586782 Milys, Thomas, of Leystoft, yeoman 0
4752013 2281084 2281084 defendant Fen John yeoman 586782 586782 Fen, John, of Leystoft, yeoman 1
4776541 2288656 2288656 defendant Reynald John yeoman 586782 586782 Reynald, John, of Leystoft, yeoman 0
4779791 2289674 2289674 defendant Broun John laborer 586782 586782 Broun, John, of Leystoft, laborer 0
4787514 2292166 2292166 defendant Bocher alias Forthe John yeoman 586782 586782 Bocher alias Forthe, John, of Leystoft, yeoman 1
4792804 2293840 2293840 plaintiff Moryng Robert   586782 586782 Moryng, Robert, of Leystoft 0
4804446 2297576 2297576 plaintiff bocher William   586782 586782 bocher, William, of Leystoft 0
4811858 2299822 2299822 defendant Clays alias Spryys Nicholas tailor 586782 586782 Clays alias Spryys, Nicholas, of Leystoft, tailor 0
4813842 2300440 2300440 defendant Bocher Simon butcher 586782 586782 Bocher, Simon, of Leystoft, butcher 0
4845282 2310035 2310035 defendant Kowe John butcher 586782 586782 Kowe, John, of Leystoft, butcher 0
4878414 2320191 2320191 defendant Glover John yeoman 586782 586782 Glover, John, of Leystoft, yeoman 3
4883297 2321700 2321700 defendant Watyrford Thomas gent 586782 586782 Watyrford, Thomas, of Leystoft, gent 0
4884078 2321932 2321932 defendant Smyth William butcher 586782 586782 Smyth, William, of Leystoft, butcher 0
4891846 2324185 2324185 defendant Dollard William barber 586782 586782 Dollard, William, of Leystoft, barber 0
4905722 2328390 2328390 defendant Smyth William butcher 586782 586782 Smyth, William, of Leystoft, butcher 0
4931975 2336388 2336388 defendant Elwyn John butcher 586782 586782 Elwyn, John, of Leystoft, butcher 0
4931976 2336388 2336388 defendant Broun John butcher 586782 586782 Broun, John, of Leystoft, butcher 1
4938864 2338546 2338546 defendant Yedan alias Langele William merchant 586782 586782 Yedan alias Langele, William, of Leystoft, merchant 0
4949798 2341926 2341926 defendant Gase Alan sherman 586782 586782 Gase, Alan, of Leystoft, sherman 4
4965752 2346684 2346684 defendant Carbroke John laborer 586782 586782 Carbroke, John, of Leystoft, laborer 0
4982286 2351618 2351618 defendant Steyngate Henry roper 586782 586782 Steyngate, Henry, of Leystoft, roper 0
5017786 2362081 2362081 defendant Bernard John carver 586782 586782 Bernard, John, of Leystoft, carver 0
5056832 2373616 2373616 defendant Cove or Cone John butcher 586782 586782 Cove or Cone, John, of Leystoft, butcher 0
5056940 2373651 2373651 defendant Wellys John yeoman 586782 586782 Wellys, John, of Leystoft, yeoman 2
5056943 2373652 2373652 defendant Wellys John yeoman 586782 586782 Wellys, John, of Leystoft, yeoman 1
5071944 2378098 2378098 defendant Alman John yeoman 586782 586782 Alman, John, of Leystoft, yeoman 3
5079815 2380442 2380442 defendant Sterky John yeoman 586782 586782 Sterky, John, of Leystoft, yeoman 1
5079818 2380443 2380443 defendant Sterky John yeoman 586782 586782 Sterky, John, of Leystoft, yeoman 1
5100803 2386653 2386653 defendant Heygham John (legal representative) 586782 586782 Heygham, John, of Leystoft, husbandman, administratrix of 3
5100804 2386653 2386653 defendant Heygham Maud widow 586782 586782 Heygham, Maud, of Leystoft, widow 4
5104801 2387842 2387842 defendant Weston Thomas shoemaker 586782 586782 Weston,Thomas, of Leystoft, shoemaker 0
5104802 2387842 2387842 defendant Palmer Richard   586782 586782 Palmer, Richard, of Leystoft, shipwright 1
5104803 2387842 2387842 defendant Edward William butcher 586782 586782 Edward, William, of Leystoft, butcher 2

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