names

107 rows where place_id = 604694

✎ 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
3658926 1913053 1913053 defendant Longmed Nicholas merchant 604694 604694 Longmed, Nicholas, of Dartmouth, Devon, merchant 0
3663751 1914598 1914598 defendant Longmede Nicholas merchant & haberdasher 604694 604694 Longmede, Nicholas, of Dartmouth, Devon, merchant & haberdasher 0
3667311 1915714 1915714 defendant Trevanyon John esq 604694 604694 Trevanyon, John, of Dartmouth, Devon, esq 1
3695212 1924722 1924722 defendant Robynson Joan widow 604694 604694 Robynson, Joan, of Dartmouth, Devon, widow 3
3763452 1946201 1946201 defendant Smyth John gent 604694 604694 Smyth, John, of Dartmouth, Devon, gent 0
3770710 1948522 1948522 defendant Longmede Nicholas merchant 604694 604694 Longmede, Nicholas, of Dartmouth, Devon, merchant 0
3826626 1966174 1966174 defendant Longmede Nicholas merchant 604694 604694 Longmede, Nicholas, of Dartmouth, Devon, merchant 0
3965790 2012648 2012648 defendant Smythe John merchant 604694 604694 Smythe, John, of Dartmouth, Devon, merchant 0
3969354 2013886 2013886 defendant Holland Robert merchant 604694 604694 Holland, Robert, of Dartmouth, Devon, merchant 2
3985544 2019593 2019593 defendant Newland William merchant 604694 604694 Newland, William, of Dartmouth, Devon, merchant 3
3994381 2022744 2022744 defendant Wykes Walter merchant 604694 604694 Wykes, Walter, of Dartmouth, Devon, merchant 0
3999635 2024634 2024634 defendant Carwytham Richard gent 604694 604694 Carwytham, Richard, of Dartmouth, Devon, gent 2
4011426 2028863 2028863 plaintiff Plomleigh Thomas   604694 604694 Plomleigh, Thomas, of Dartmouth, Devon 0
4011490 2028869 2028869 defendant Frye Alexander tailor 604694 604694 Frye, Alexander, of Dartmouth, Devon, tailor 0
4011641 2028904 2028904 defendant Walter Adam merchant 604694 604694 Walter, Adam, of Dartmouth, Devon, merchant 3
4018144 2031211 2031211 plaintiff Turner Geoffrey mariner 604694 604694 Turner, Geoffrey, of Dartmouth, Devon, esq, mariner 0
4018146 2031212 2031212 plaintiff Turner Geoffrey mariner 604694 604694 Turner, Geoffrey, of Dartmouth, Devon, gent, mariner 0
4030197 2035450 2035450 defendant Newland Edward merchant 604694 604694 Newland, Edward, of Dartmouth, Devon, merchant 0
4066625 2048358 2048358 defendant Leyson Edward vintner 604694 604694 Leyson, Edward, of Dartmouth, Devon, vintner 0
4073513 2050812 2050812 plaintiff Plumlyghe Thomas   604694 604694 Plumlyghe, Thomas, of Dartmouth, Devon 0
4075323 2051476 2051476 plaintiff Rowpe Gulbert (legal representative) 604694 604694 Rowpe, Gulbert, of Dartmouth, Devon, merchant, executors of 0
4082478 2054040 2054040 defendant Gourney John yeoman 604694 604694 Gourney, John, of Dartmouth, Devon, yeoman 0
4120101 2067477 2067477 defendant Norbur Richard mariner 604694 604694 (Norbur, Richard, of Dartmouth, Devon, mariner 1
4126051 2069603 2069603 defendant Blackaller Richard gent 604694 604694 Blackaller, Richard, of Dartmouth, Devon, gent 0
4128492 2070481 2070481 defendant Shapley Richard merchant 604694 604694 Shapley, Richard, of Dartmouth, Devon, merchant 0
4139914 2074642 2074642 defendant Parkhurst Anthony gent 604694 604694 Parkhurst, Anthony, of Dartmouth, Devon, gent 0
4143186 2075787 2075787 defendant Norbur Richard mariner 604694 604694 (Norbur, Richard, of Dartmouth, Devon, mariner 1
4149190 2077845 2077845 defendant Blackaller Richard gent 604694 604694 Blackaller, Richard, of Dartmouth, Devon, gent 0
4171357 2085445 2085445 defendant Gyles Robert merchant 604694 604694 Gyles, Robert, of Dartmouth, Devon, merchant 0
4176708 2087324 2087324 defendant Archer Philip mariner 604694 604694 Archer, Philip, of Dartmouth, Devon, mariner 1
4198531 2095039 2095039 defendant Plumleighe William merchant 604694 604694 Plumleighe, William, of Dartmouth, Devon, merchant 0
4202644 2096468 2096468 defendant Norrys William merchant 604694 604694 Norrys, William, of Dartmouth, Devon, merchant 1
4202760 2096510 2096510 defendant Southcott George gent 604694 604694 Southcott, George, of Dartmouth, Devon, gent 0
4205051 2097312 2097312 defendant Stephens William merchant 604694 604694 Stephens, William, of Dartmouth, Devon, merchant 0
4206342 2097763 2097763 defendant Stapley Robert merchant 604694 604694 Stapley, Robert, of Dartmouth, Devon, merchant 1
4207681 2098245 2098245 defendant Shapley Richard merchant 604694 604694 Shapley, Richard, of Dartmouth, Devon, merchant 2
4223685 2103770 2103770 defendant Walker Adam merchant 604694 604694 Walker, Adam, of Dartmouth, Devon, merchant 1
4231695 2106584 2106584 defendant Walker Adam merchant 604694 604694 Walker, Adam, of Dartmouth, Devon, merchant 1
4237650 2108761 2108761 defendant Knill Thomas merchant 604694 604694 Knill, Thomas, of Dartmouth, Devon, yeoman, merchant 1
4244797 2111248 2111248 defendant Newman John beer brewer 604694 604694 Newman, John, of Dartmouth, Devon, beer brewer 0
4246230 2111717 2111717 defendant Knoll Thomas merchant 604694 604694 Knoll, Thomas, of Dartmouth, Devon, yeoman, merchant 1
4256527 2115152 2115152 defendant Newman John beer brewer 604694 604694 Newman, John, of Dartmouth, Devon, beer brewer 0
4282219 2123680 2123680 defendant Smyth Robert, senior (legal representative) 604694 604694 Smyth, Robert, senior, of Dartmouth, Devon, merchant, administrator of 0
4288825 2126057 2126057 defendant Wooton Arthur gent 604694 604694 Wooton, Arthur, of Dartmouth, Devon, gent 3
4331009 2140669 2140669 defendant Gillard John cordwainer 604694 604694 Gillard, John, of Dartmouth, Devon, cordwainer 2
4333898 2141622 2141622 defendant Southcott George gent 604694 604694 Southcott, George, of Dartmouth, Devon, gent 0
4345739 2145778 2145778 defendant Addams Nicholas gent 604694 604694 Addams, Nicholas, of Dartmouth, Devon, gent 0
4362951 2151810 2151810 defendant Putt William yeoman 604694 604694 Putt, William, of Dartmouth, Devon, yeoman 0
4388614 2160830 2160830 defendant Collyns Henry chapman 604694 604694 Collyns, Henry, of Dartmouth, Devon, chapman 0
4391467 2161763 2161763 defendant Smyth John merchant 604694 604694 Smyth, John, of Dartmouth, Devon, merchant 2
4391473 2161764 2161764 defendant Keymar John tailor 604694 604694 Keymar, John, of Dartmouth, Devon, tailor 2
4391477 2161765 2161765 defendant Roche Walter clerk 604694 604694 Roche, Walter, of Dartmouth, Devon, clerk 0
4391485 2161766 2161766 defendant Greble Margery widow 604694 604694 Greble, Margery, of Dartmouth, Devon, widow 2
4391490 2161767 2161767 defendant Wakeham Thomas yeoman 604694 604694 Wakeham, Thomas, of Dartmouth, Devon, yeoman 3
4391493 2161768 2161768 defendant Lodwell John weaver 604694 604694 Lodwell, John, of Dartmouth, Devon, weaver 0
4391738 2161858 2161858 defendant Avery Edmund mariner 604694 604694 Avery, Edmund, of Dartmouth, Devon, mariner 1
4394130 2162638 2162638 defendant Blackaller Christopher   604694 604694 Blackaller, Christopher, of Dartmouth, Devon, gent, administrators of 0
4406630 2166781 2166781 defendant Cocke Lawrence mariner 604694 604694 (Cocke, Lawrence, of Dartmouth, Devon, mariner 1
4409893 2167912 2167912 defendant Heyward James yeoman 604694 604694 Heyward, James, of Dartmouth, Devon, yeoman 0
4409895 2167913 2167913 defendant Heyward James yeoman 604694 604694 Heyward, James, of Dartmouth, Devon, yeoman 0
4645731 2244816 2244816 defendant Broun Thomas   604694 604694 Broun, Thomas, of Dartmouth, Devon 0
4689403 2262243 2262243 defendant Hawley John, junior esq 604694 604694 Hawley, John, junior, of Dartmouth, Devon, esq 3
4697144 2264584 2264584 defendant Rede John mariner 604694 604694 Rede, John, of Dartmouth, Devon, mariner 2
4702827 2266281 2266281 defendant Forde John husbandman 604694 604694 (Forde, John, of Dartmouth, Devon, husbandman 5
4702834 2266282 2266282 defendant Forde John husbandman 604694 604694 (Forde, John, of Dartmouth, Devon, husbandman 4
4717823 2270916 2270916 defendant Hanley John esq 604694 604694 Hanley, John, of Dartmouth, Devon, esq 0
4737614 2276874 2276874 defendant Hillery Robert husbandman 604694 604694 Hillery, Robert, of Dartmouth, Devon, husbandman 1
4737618 2276875 2276875 defendant Hillery Robert husbandman 604694 604694 Hillery, Robert, of Dartmouth, Devon, husbandman 1
4758730 2283086 2283086 defendant Forster John mercer 604694 604694 Forster, John, of Dartmouth, Devon, mercer 4
4819833 2302276 2302276 defendant William John shipman 604694 604694 William, John, of Dartmouth, Devon, shipman 1
4822420 2303090 2303090 defendant Symond John husbandman 604694 604694 Symond, John, of Dartmouth, Devon, husbandman 3
4828117 2304838 2304838 defendant Aleyn John yeoman 604694 604694 Aleyn, John, of Dartmouth, Devon, yeoman 0
4833914 2306615 2306615 defendant Rede John mariner 604694 604694 Rede, John, of Dartmouth, Devon, mariner 0
4910204 2329711 2329711 defendant Rolf John skinner 604694 604694 Rolf, John, of Dartmouth, Devon, skinner 1
4993973 2355071 2355071 defendant Yon Hugh gent 604694 604694 Yon, Hugh, of Dartmouth, Devon, gent 0
4995695 2355555 2355555 defendant Knyght John shipman 604694 604694 Knyght, John, of Dartmouth, Devon, shipman 0
5011955 2360347 2360347 defendant Derlyng William merchant 604694 604694 Derlyng, William, of Dartmouth, Devon, merchant 0
5140292 2398264 2398264 defendant Gylle Thomas, senior gent 604694 604694 Gylle, Thomas, senior, of Dartmouth, Devon, gent 0
5149236 2400908 2400908 defendant Wychehall John merchant 604694 604694 Wychehall, John, of Dartmouth, Devon, merchant 1
5151678 2401648 2401648 defendant Weston John mariner 604694 604694 Weston, John, of Dartmouth, Devon, mariner 1
5152347 2401818 2401818 defendant Weston John mariner 604694 604694 Weston, John, of Dartmouth, Devon, mariner 1
5159388 2403861 2403861 defendant Bussheford William gent 604694 604694 Bussheford, William, of Dartmouth, Devon, gent 0
5170169 2407005 2407005 defendant Weston John mariner 604694 604694 Weston, John, of Dartmouth, Devon, mariner 1
5174546 2408256 2408256 defendant Bussheford William gent 604694 604694 Bussheford, William, of Dartmouth, Devon, gent 0
5174549 2408257 2408257 defendant Bussheford William gent 604694 604694 Bussheford, William, of Dartmouth, Devon, gent 0
5182471 2410629 2410629 defendant Phelipp John merchant 604694 604694 Phelipp, John, of Dartmouth, Devon, merchant 0
5182477 2410630 2410630 defendant Phelipp John merchant 604694 604694 Phelipp, John, of Dartmouth, Devon, merchant 0
5183101 2410799 2410799 defendant Stebbyng Nicholas chapman 604694 604694 Stebbyng, Nicholas, of Dartmouth, Devon, chapman 3
5184693 2411273 2411273 defendant Wytle William gent 604694 604694 Wytle, William, of Dartmouth, Devon, gent 0
5194164 2414027 2414027 defendant Wrangebroke Thomas yeoman 604694 604694 Wrangebroke, Thomas, of Dartmouth, Devon, yeoman 0
5194197 2414033 2414033 defendant Wrangebroke Thomas yeoman 604694 604694 Wrangebroke, Thomas, of Dartmouth, Devon, yeoman 0
5203394 2416755 2416755 defendant Phelipp John merchant 604694 604694 Phelipp, John, of Dartmouth, Devon, merchant 0
5203730 2416840 2416840 defendant Stebbyng Nicholas chapman 604694 604694 Stebbyng, Nicholas, of Dartmouth, Devon, chapman 3
5208583 2418239 2418239 defendant Wrangebroke Thomas yeoman 604694 604694 Wrangebroke, Thomas, of Dartmouth, Devon, yeoman 0
5208585 2418240 2418240 defendant Wrangebroke Thomas yeoman 604694 604694 Wrangebroke, Thomas, of Dartmouth, Devon, yeoman 0
5210058 2418675 2418675 defendant Gille Thomas, sen gent 604694 604694 Gille, Thomas, sen, of Dartmouth, Devon, gent 0
5210061 2418676 2418676 defendant Gille Thomas, sen gent 604694 604694 Gille, Thomas, sen, of Dartmouth, Devon, gent 0
5269865 2436292 2436292 defendant Gale Thomas gent 604694 604694 Gale, Thomas, of Dartmouth, Devon, gent 0
5298903 2444661 2444661 defendant Heyrs Nicholas mariner 604694 604694 Heyrs, Nicholas, of Dartmouth, Devon, mariner 1
5303349 2445999 2445999 defendant Gale Thomas merchant 604694 604694 Gale, Thomas, of Dartmouth, Devon, merchant 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);