names

282 rows where place_id = 599457

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3636853 1906319 1906319 defendant Reed Joan widow 599457 599457 Reed, Joan, of Dartmouth, widow 2
3656307 1912218 1912218 defendant Huper Thomas baker 599457 599457 Huper, Thomas, of Dartmouth, baker 0
3695211 1924722 1924722 defendant Robynson William (legal representative) 599457 599457 Robynson, William, of Dartmouth, merchant, executrix of 2
3720344 1932641 1932641 defendant Smythe John   599457 599457 Smythe, John, of Dartmouth, gent, sergeant at arms 1
3758939 1944787 1944787 defendant Wykes William tailor 599457 599457 Wykes, William, of Dartmouth, tailor 0
3758941 1944788 1944788 defendant Wykys William tailor 599457 599457 Wykys, William, of Dartmouth, tailor 0
3826628 1966175 1966175 defendant Longmede Nicholas merchant 599457 599457 Longmede, Nicholas, of Dartmouth, merchant 0
3838352 1969915 1969915 defendant Berde William merchant 599457 599457 Berde, William, of Dartmouth, merchant 0
3867435 1979344 1979344 plaintiff Sayer John   599457 599457 Sayer, John, of Dartmouth 0
3868537 1979719 1979719 defendant Methe David mariner 599457 599457 Methe, David, of Dartmouth, mariner 0
3890674 1987146 1987146 defendant Hooke Richard merchant 599457 599457 Hooke, Richard, of Dartmouth, merchant 0
3965791 2012648 2012648 defendant Gurneys Thomas merchant 599457 599457 Gurneys, Thomas, of Dartmouth, merchant 1
3965792 2012648 2012648 defendant Smythe Robert merchant 599457 599457 Smythe, Robert, of Dartmouth, merchant 2
3966693 2012986 2012986 defendant Powell William merchant 599457 599457 Powell, William, of Dartmouth, merchant 0
3969896 2014071 2014071 defendant Wyne Humphrey beer brewer 599457 599457 Wyne, Humphrey, of Dartmouth, beer brewer 0
3969899 2014072 2014072 defendant Wyne Humphrey beer brewer 599457 599457 Wyne, Humphrey, of Dartmouth, beer brewer 0
3969900 2014072 2014072 defendant Pawell Walter mariner 599457 599457 Pawell, Walter, of Dartmouth, mariner 1
3974988 2015813 2015813 defendant Lyston Edward merchant 599457 599457 Lyston, Edward, of Dartmouth, merchant 0
3980134 2017659 2017659 defendant Lydston Edward merchant 599457 599457 Lydston, Edward, of Dartmouth, merchant 0
3980136 2017660 2017660 defendant Lydston Edward merchant 599457 599457 Lydston, Edward, of Dartmouth, merchant 0
3981222 2018045 2018045 plaintiff Pyllyngton James merchant 599457 599457 Pyllyngton, James, of Dartmouth, merchant 0
3983201 2018763 2018763 defendant Jeffrey Walter shoemaker 599457 599457 Jeffrey, Walter, of Dartmouth, shoemaker 0
3983202 2018764 2018764 plaintiff Smyth Nicholas merchant 599457 599457 Smyth, Nicholas, of Dartmouth, merchant 0
3983318 2018805 2018805 plaintiff Smythe Richard merchant 599457 599457 Smythe, Richard, of Dartmouth, merchant 0
4011485 2028867 2028867 plaintiff Plumleigh John   599457 599457 Plumleigh, John, of Dartmouth 0
4011487 2028868 2028868 plaintiff Plumleigh Thomas   599457 599457 Plumleigh, Thomas, of Dartmouth 0
4011489 2028869 2028869 plaintiff Plumleighe John   599457 599457 Plumleighe, John, of Dartmouth 0
4016822 2030714 2030714 defendant Lydston Edward merchant 599457 599457 Lydston, Edward, of Dartmouth, merchant 0
4016823 2030714 2030714 defendant Holland Robert merchant 599457 599457 Holland, Robert, of Dartmouth, merchant 1
4029205 2035090 2035090 plaintiff Cunstable Martine gent 599457 599457 Cunstable, Martine, of Dartmouth, gent 0
4054366 2043952 2043952 defendant Browne Edward smith 599457 599457 Browne, Edward, of Dartmouth, smith 0
4066626 2048358 2048358 defendant Gurney John vintner 599457 599457 Gurney, John, of Dartmouth, vintner 1
4108173 2063191 2063191 defendant Constable Martin gent 599457 599457 Constable, Martin, of Dartmouth, gent 0
4120100 2067477 2067477 defendant Poole John   599457 599457 Poole, John, of Dartmouth, mariner, administrators of 0
4125620 2069448 2069448 defendant Plumleigh Robert merchant 599457 599457 Plumleigh, Robert, of Dartmouth, merchant 0
4143185 2075787 2075787 defendant Poole or Paule John   599457 599457 Poole or Paule, John, of Dartmouth, mariner, administrators of 0
4176709 2087324 2087324 defendant Agmer Nicholas mariner 599457 599457 Agmer, Nicholas, of Dartmouth, mariner 2
4178953 2088117 2088117 defendant Wotton Arthur yeoman 599457 599457 Wotton, Arthur, of Dartmouth, yeoman 0
4178954 2088117 2088117 defendant Barty Peter yeoman 599457 599457 Barty, Peter, of Dartmouth, yeoman 1
4244023 2110983 2110983 defendant Dyer George mariner 599457 599457 Dyer, George, of Dartmouth, mariner 0
4252601 2113862 2113862 defendant Puckell Edmund innkeeper 599457 599457 Puckell, Edmund, of Dartmouth, innkeeper 0
4285755 2124958 2124958 defendant Pears Robert   599457 599457 Pears, Robert, of Dartmouth, shipwright 0
4287844 2125699 2125699 defendant Plumleigh Lewis yeoman 599457 599457 Plumleigh, Lewis, of Dartmouth, yeoman 0
4287846 2125700 2125700 defendant Blackaller Richard gent 599457 599457 Blackaller, Richard, of Dartmouth, gent 0
4287848 2125701 2125701 defendant Plumleigh John yeoman 599457 599457 Plumleigh, John, of Dartmouth, yeoman 0
4289483 2126299 2126299 defendant Roche Walter clerk 599457 599457 Roche, Walter, of Dartmouth, or of Stratford on Avon, Warks, clerk 0
4290452 2126645 2126645 defendant Spurwaye Thomas yeoman 599457 599457 Spurwaye, Thomas, of Dartmouth, yeoman 0
4291848 2127159 2127159 defendant Hoggard Thomas cooper 599457 599457 Hoggard, Thomas, of Dartmouth, cooper 0
4296394 2128809 2128809 defendant Plumleigh John, junior merchant 599457 599457 Plumleigh, John, junior, of Dartmouth, merchant 0
4296721 2128923 2128923 defendant Roche Walter clerk 599457 599457 Roche, Walter, of Dartmouth, clerk 0
4303819 2131466 2131466 defendant Heyman Nicholas merchant 599457 599457 Heyman, Nicholas, of Dartmouth, merchant 0
4315850 2135651 2135651 defendant Ley John yeman 599457 599457 Ley, John, of Dartmouth, yeman 0
4315852 2135652 2135652 defendant Ley William gent 599457 599457 Ley, William, of Dartmouth, gent 0
4315854 2135653 2135653 defendant Plumleighe John, junior merchant 599457 599457 Plumleighe, John, junior, of Dartmouth, merchant 0
4320968 2137430 2137430 defendant Smythe Robert (legal representative) 599457 599457 Smythe, Robert, of Dartmouth, merchant, administrator of 0
4362952 2151810 2151810 defendant Searell James baker 599457 599457 Searell, James, of Dartmouth, baker 1
4372078 2155078 2155078 defendant Roche Walter clerk 599457 599457 Roche, Walter, of Dartmouth, clerk 0
4387780 2160551 2160551 defendant Crosman William yeoman 599457 599457 Crosman, William, of Dartmouth, yeoman 0
4387781 2160551 2160551 defendant Towill John yeoman 599457 599457 Towill, John, of Dartmouth, yeoman 1
4387782 2160551 2160551 defendant Clifforde Nicholas painter 599457 599457 Clifforde, Nicholas, of Dartmouth, painter 2
4391469 2161763 2161763 defendant Wotton Arthur gent 599457 599457 Wotton, Arthur, of Dartmouth, gent 4
4391479 2161765 2161765 defendant Newby John yeoman 599457 599457 Newby, John, of Dartmouth, yeoman 2
4391480 2161765 2161765 defendant Philpott Robert   599457 599457 Philpott, Robert, of Dartmouth, shipwright 3
4391481 2161765 2161765 defendant Gurny Thomas merchant 599457 599457 Gurny, Thomas, of Dartmouth, merchant 4
4393194 2162331 2162331 defendant Luke Thomas mariner 599457 599457 Luke, Thomas, of Dartmouth, mariner 0
4393196 2162332 2162332 defendant Barter Alexander mariner 599457 599457 Barter, Alexander, of Dartmouth, mariner 0
4394131 2162638 2162638 defendant Heyman Nicholas merchant 599457 599457 (Heyman, Nicholas, of Dartmouth, merchant 1
4406629 2166781 2166781 defendant Wakeham William (legal representative) 599457 599457 Wakeham, William, of Dartmouth, yeoman, executors of 0
4408781 2167534 2167534 defendant Ingram Anthony merchant 599457 599457 Ingram, Anthony, of Dartmouth, merchant 0
4449610 2184825 2184825 defendant Hopere William   599457 599457 Hopere, William, of Dartmouth 4
4449611 2184825 2184825 defendant Pybaker Thomas   599457 599457 Pybaker, Thomas, of Dartmouth 5
4457784 2187448 2187448 defendant Fero or Ferour William   599457 599457 Fero or Ferour, William, of Dartmouth 0
4458461 2187692 2187692 defendant Cornyssh John baker 599457 599457 Cornyssh, John, of Dartmouth, baker 0
4464486 2189560 2189560 defendant Boron Matilda   599457 599457 Boron, Matilda, of Dartmouth, formerly wife of John 0
4466927 2190329 2190329 plaintiff Asshenden Thomas (legal representative) 599457 599457 Asshenden, Thomas, of Dartmouth, executors of 0
4478102 2193826 2193826 plaintiff Hauley or Hanley John   599457 599457 Hauley or Hanley, John, of Dartmouth 0
4480190 2194464 2194464 defendant Willis John   599457 599457 Willis, John, of Dartmouth 1
4480191 2194464 2194464 defendant Polard Walter   599457 599457 Polard, Walter, of Dartmouth 2
4480193 2194464 2194464 defendant Bonde John   599457 599457 Bonde, John, of Dartmouth 4
4480196 2194465 2194465 defendant Edward John   599457 599457 Edward, John, of Dartmouth 1
4480200 2194465 2194465 defendant Barbour William   599457 599457 Barbour, William, of Dartmouth 5
4499359 2200450 2200450 plaintiff Hanley John   599457 599457 Hanley, John, of Dartmouth, on his own account 0
4499362 2200451 2200451 plaintiff Hanley John   599457 599457 Hanley, John, of Dartmouth, on his own account 0
4512049 2204210 2204210 defendant Parye John   599457 599457 Parye, John, of Dartmouth 0
4514738 2205025 2205025 defendant Bast Joan   599457 599457 Bast, Joan, of Dartmouth, formerly wife of William Bast 1
4515777 2205361 2205361 plaintiff Clerk William   599457 599457 Clerk, William, of Dartmouth 0
4516652 2205621 2205621 defendant Gibbe Nicholas   599457 599457 Gibbe, Nicholas, of Dartmouth 1
4523049 2207541 2207541 plaintiff Hanfford Richard   599457 599457 Hanfford, Richard, of Dartmouth 0
4523051 2207542 2207542 plaintiff Hanleigh John   599457 599457 Hanleigh, John, of Dartmouth 0
4523081 2207546 2207546 plaintiff Hanley John   599457 599457 Hanley, John, of Dartmouth 0
4523083 2207546 2207546 defendant Marton John   599457 599457 Marton, John, of Dartmouth 1
4523084 2207547 2207547 plaintiff Hanley John   599457 599457 Hanley, John, of Dartmouth 0
4523085 2207547 2207547 defendant Baret John   599457 599457 Baret, John, of Dartmouth 0
4523086 2207547 2207547 defendant Martyn John   599457 599457 Martyn, John, of Dartmouth 1
4523087 2207548 2207548 plaintiff Hanley John   599457 599457 Hanley, John, of Dartmouth 0
4523091 2207549 2207549 plaintiff Hanley John   599457 599457 Hanley, John, of Dartmouth 0
4523093 2207550 2207550 plaintiff Hanley John   599457 599457 Hanley, John, of Dartmouth 0
4523095 2207551 2207551 plaintiff Hanley John, sen   599457 599457 Hanley, John, sen, of Dartmouth 0
4523096 2207551 2207551 defendant Welles William   599457 599457 Welles, William, of Dartmouth 0
4523498 2207672 2207672 plaintiff Hauleigh or Hanley John   599457 599457 Hauleigh or Hanley, John, of Dartmouth 0

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