names

72 rows where place_id = 590244

✎ 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
3600354 1867755 1867755 defendant Grene Simon clerk 590244 590244 Grene, Simon, of Donwich, clerk 1
3600358 1867755 1867755 defendant Freman Robert smith 590244 590244 Freman, Robert, of Donwich, smith 5
3603849 1868876 1868876 defendant Shipman Robert shipman 590244 590244 Shipman, Robert, of Donwich, shipman 3
3631068 1904541 1904541 defendant Over Ralph butcher 590244 590244 Over, Ralph, of Donwich, butcher 0
3631069 1904541 1904541 defendant Tryppe Thomas mariner 590244 590244 Tryppe, Thomas, of Donwich, mariner 1
3631070 1904541 1904541 defendant Coddon Nicholas mariner 590244 590244 Coddon, Nicholas, of Donwich, mariner 2
3636806 1906302 1906302 defendant Melton Peter mariner 590244 590244 Melton, Peter, of Donwich, mariner 0
3664538 1914860 1914860 defendant Garlond Richard skinner 590244 590244 Garlond, Richard, of Donwich, skinner 4
3669656 1916448 1916448 defendant Vurshe Thomas yeoman 590244 590244 Vurshe, Thomas, of Donwich, yeoman 0
3676921 1918820 1918820 defendant Elsey Stephen mariner 590244 590244 Elsey, Stephen, of Donwich, mariner 1
3676922 1918820 1918820 defendant Lokewode Robert laborer 590244 590244 Lokewode, Robert, of Donwich, laborer 2
3709639 1929323 1929323 defendant Bery William mariner 590244 590244 Bery, William, of Donwich, mariner 1
3714014 1930682 1930682 plaintiff Baldewyn Nicholas merchant 590244 590244 Baldewyn, Nicholas, of Donwich, merchant 0
3735306 1937275 1937275 defendant Elsy Stephen mariner 590244 590244 Elsy, Stephen, of Donwich, mariner 0
3735307 1937275 1937275 defendant Grosse Thomas mariner 590244 590244 Grosse, Thomas, of Donwich, mariner 1
3752419 1942678 1942678 defendant Rowse Edward gent 590244 590244 Rowse, Edward, of Donwich, gent 0
3752421 1942679 1942679 defendant Rowse Edward gent 590244 590244 Rowse, Edward, of Donwich, gent 0
3758541 1944669 1944669 defendant Lowder Richard husbandman 590244 590244 Lowder, Richard, of Donwich, husbandman 2
3769114 1947995 1947995 defendant Rowse Edmund gent 590244 590244 Rowse, Edmund, of Donwich, gent 0
3769116 1947996 1947996 defendant Rowse Edmund gent 590244 590244 Rowse, Edmund, of Donwich, gent 0
3790251 1954765 1954765 defendant Dowe John husbandman 590244 590244 Dowe, John, of Donwich, husbandman 4
3793763 1955913 1955913 defendant Grene William butcher 590244 590244 Grene, William, of Donwich, butcher 0
3794924 1956280 1956280 defendant Bery William mariner 590244 590244 Bery, William, of Donwich, mariner 0
3841070 1970781 1970781 defendant Hoddis Margaret widow 590244 590244 Hoddis, Margaret, of Donwich, widow 2
3889561 1986741 1986741 defendant Garlond Richard skinner 590244 590244 Garlond, Richard, of Donwich, skinner 1
3899824 1990153 1990153 defendant Thurston William baker 590244 590244 (Thurston, William, of Donwich, baker 1
3946337 2005793 2005793 plaintiff Butler Robert (legal representative) 590244 590244 Butler, Robert, of Donwich, mercer, executors of 0
3946560 2005862 2005862 defendant Bassett John merchant 590244 590244 Bassett, John, of Donwich, merchant 0
3948917 2006687 2006687 defendant Rowse Edmund   590244 590244 Rowse, Edmund, of Donwich, knight 0
3953079 2008142 2008142 plaintiff Hugman Robert yeoman 590244 590244 Hugman, Robert, of Donwich, yeoman 0
3963911 2011983 2011983 plaintiff Anderson Anthony mariner 590244 590244 Anderson, Anthony, of Donwich, mariner 0
3963913 2011984 2011984 plaintiff Anderson Anthony mariner 590244 590244 Anderson, Anthony, of Donwich, mariner 0
3974807 2015752 2015752 defendant Cryspe Nicholas husbandman 590244 590244 Cryspe, Nicholas, of Donwich, husbandman 2
3974839 2015764 2015764 defendant Jenney Christopher gent 590244 590244 Jenney, Christopher, of Donwich, gent 3
3987157 2020153 2020153 plaintiff Wychyngham Robert   590244 590244 Wychyngham, Robert, of Donwich, administrators of 0
3989773 2021087 2021087 plaintiff Girdler William merchant 590244 590244 Girdler, William, of Donwich, merchant 1
3991709 2021792 2021792 defendant Murdock Robert tailor 590244 590244 Murdock, Robert, of Donwich, yeoman, or of Beccles, tailor 0
3991711 2021793 2021793 defendant Murdock Robert tailor 590244 590244 Murdock, Robert, of Donwich, yeoman, or of Beccles, tailor 0
4006689 2027171 2027171 defendant Robson John mariner 590244 590244 Robson, John, of Donwich, mariner 0
4006690 2027171 2027171 defendant Wichyngham William mariner 590244 590244 Wichyngham, William, of Donwich, mariner 1
4006692 2027172 2027172 defendant Vyncent John mariner 590244 590244 Vyncent, John, of Donwich, mariner 0
4006693 2027172 2027172 defendant Bocher William yeoman 590244 590244 Bocher, William, of Donwich, yeoman 1
4025993 2033945 2033945 defendant Mowse Edward husbandman 590244 590244 Mowse, Edward, of Donwich, husbandman 2
4027153 2034358 2034358 defendant Hutchynson John mariner 590244 590244 Hutchynson, John, of Donwich, mariner 1
4027159 2034360 2034360 defendant Anderson Anthony merchant 590244 590244 Anderson, Anthony, of Donwich, merchant 1
4034935 2037171 2037171 defendant Alleyn John gent 590244 590244 Alleyn, John, of Donwich, gent 0
4041102 2039309 2039309 defendant Boutell or Bontell James yeoman 590244 590244 Boutell or Bontell, James, of Donwich, yeoman 0
4046653 2041254 2041254 defendant Hasborowe Nicholas merchant 590244 590244 Hasborowe, Nicholas, of Donwich, merchant 1
4106016 2062442 2062442 defendant Crispe Robert turner 590244 590244 Crispe, Robert, of Donwich, turner 2
4106017 2062442 2062442 defendant Ketell William mariner 590244 590244 Ketell, William, of Donwich, mariner 3
4195052 2093834 2093834 defendant Thackwerye Thomas clerk 590244 590244 Thackwerye, Thomas, of Donwich, clerk 0
4195061 2093836 2093836 defendant Thackwary Thomas clerk 590244 590244 Thackwary, Thomas, of Donwich, clerk 0
4208716 2098598 2098598 defendant Hasboroughe John mariner 590244 590244 Hasboroughe, John, of Donwich, mariner 3
4782778 2290629 2290629 defendant Brampton Thomas taverner 590244 590244 Brampton, Thomas, of Donwich, taverner 1
4946091 2340765 2340765 defendant Ducheman Richard beer brewer 590244 590244 Ducheman, Richard, of Donwich, beer brewer 1
4966369 2346873 2346873 defendant Gentilman Margaret widow 590244 590244 Gentilman, Margaret, of Donwich, widow 7
5019060 2362466 2362466 defendant Throp or Thorp Robert   590244 590244 Throp or Thorp, Robert, of Donwich merchant 1
5246944 2429270 2429270 defendant Lacy William shipman 590244 590244 (Lacy, William, of Donwich, shipman 2
5247478 2429418 2429418 plaintiff Skuttyng Clement   590244 590244 Skuttyng, Clement, of Donwich 1
5474836 2497457 2497457 defendant Chamberleyn John mariner 590244 590244 Chamberleyn, John, of Donwich, mariner 0
5474839 2497458 2497458 defendant Chamberleyn John mariner 590244 590244 Chamberleyn, John, of Donwich, mariner 0
5479231 2498806 2498806 defendant Peers Thomas yeoman 590244 590244 Peers, Thomas, of Donwich, yeoman 1
5485323 2500527 2500527 defendant Hawekwode John glasier 590244 590244 Hawekwode, John, of Donwich, glasier 4
5490337 2502001 2502001 defendant Croxton William yeoman 590244 590244 Croxton, William, of Donwich, yeoman 0
5490338 2502001 2502001 defendant Gentilman Thomas yeoman 590244 590244 Gentilman, Thomas, of Donwich, yeoman 1
5499047 2504652 2504652 defendant Warde Robert cooper 590244 590244 Warde, Robert, of Donwich, cooper 0
5499049 2504653 2504653 defendant Warde Robert cooper 590244 590244 Warde, Robert, of Donwich, cooper 0
5499051 2504654 2504654 defendant Warde Robert cooper 590244 590244 Warde, Robert, of Donwich, cooper 0
5518379 2510576 2510576 defendant Freman Robert smith 590244 590244 Freman, Robert, of Donwich, smith 0
5529162 2513634 2513634 defendant Fyket John mariner 590244 590244 Fyket, John, of Donwich, mariner 1
5554443 2521334 2521334 defendant Feket John yeoman 590244 590244 Feket, John, of Donwich, yeoman 0
5554444 2521334 2521334 defendant Chele William draper 590244 590244 Chele, William, of Donwich, draper 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);