names

66 rows where place_id = 602353

✎ 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
3649763 1910289 1910289 defendant Lanehyne William gent 602353 602353 Lanehyne, William, of Truru, gent 0
3677024 1918853 1918853 defendant Sybylly Robert yeoman 602353 602353 Sybylly, Robert, of Truru, yeoman 0
3677025 1918853 1918853 defendant Norton Otto yeoman 602353 602353 Norton, Otto, of Truru, yeoman 1
3680153 1919863 1919863 defendant Lanehyne William gent 602353 602353 Lanehyne, William, of Truru, gent 0
3680489 1919980 1919980 defendant Sadeler William merchant 602353 602353 Sadeler, William, of Truru, merchant 0
3682774 1920713 1920713 defendant Beake Peter gent 602353 602353 Beake, Peter, of Truru, gent 1
3687903 1922378 1922378 defendant Parkyn Richard yeoman 602353 602353 Parkyn, Richard, of Truru, yeoman 4
3687904 1922378 1922378 defendant Aleyn John yeoman 602353 602353 Aleyn, John, of Truru, yeoman 5
3687905 1922378 1922378 defendant Barbour Elizabeth widow 602353 602353 Barbour, Elizabeth, of Truru, widow 6
3697599 1925471 1925471 defendant Pastowetyar Richard yeoman 602353 602353 Pastowetyar, Richard, of Truru, yeoman 1
3702470 1927035 1927035 defendant Garman William tailor 602353 602353 Garman, William, of Truru, tailor 0
3707014 1928478 1928478 plaintiff Lagharn Stephen gent 602353 602353 Lagharn, Stephen, of Truru, gent 0
3711704 1929972 1929972 defendant Jac William John yeoman 602353 602353 Jac William, John, of Truru, yeoman 3
3739384 1938525 1938525 defendant Newman John merchant 602353 602353 Newman, John, of Truru, merchant 1
3759506 1944965 1944965 defendant John Richard laborer 602353 602353 John, Richard, of Truru, laborer 1
3774312 1949687 1949687 plaintiff Michell John   602353 602353 Michell, John, of Truru 2
3783590 1952626 1952626 plaintiff Lanyen William   602353 602353 Lanyen, William, of Truru 0
3789670 1954597 1954597 defendant Trewennowe John Michell baker 602353 602353 Trewennowe, John Michell, of Truru, baker 0
3829270 1967037 1967037 defendant Michell Drugo merchant 602353 602353 Michell, Drugo, of Truru, merchant 0
3834406 1968706 1968706 plaintiff Mychell John merchant 602353 602353 Mychell, John, of Truru, merchant 0
3834408 1968707 1968707 plaintiff Mychell John merchant 602353 602353 Mychell, John, of Truru, merchant 0
3874505 1981696 1981696 defendant Gavergan John gent 602353 602353 Gavergan, John, of Truru, gent 1
3874537 1981701 1981701 defendant Gavergan John gent 602353 602353 Gavergan, John, of Truru, gent 1
3890509 1987084 1987084 defendant Condorow Thomas merchant 602353 602353 Condorow, Thomas, of Truru, merchant 0
3890511 1987085 1987085 defendant Condorowe Thomas merchant 602353 602353 Condorowe, Thomas, of Truru, merchant 0
3892315 1987680 1987680 plaintiff Michell John   602353 602353 Michell, John, of Truru 0
3892507 1987741 1987741 plaintiff Mychell John   602353 602353 Mychell, John, of Truru 0
3899243 1989956 1989956 defendant Buys Nicholas merchant 602353 602353 Buys, Nicholas, of Truru, merchant 0
3904771 1991855 1991855 defendant Condorowe Thomas merchant 602353 602353 Condorowe, Thomas, of Truru, merchant 0
3913336 1994794 1994794 defendant Buys Nicholas merchant 602353 602353 Buys, Nicholas, of Truru, merchant 0
3913675 1994913 1994913 defendant Bretton John cobbler 602353 602353 Bretton, John, of Truru, cobbler 1
3921488 1997528 1997528 defendant Watt Thomas baker 602353 602353 Watt, Thomas, of Truru, baker 0
3970360 2014231 2014231 defendant Thomas John gent 602353 602353 Thomas, John, of Truru, gent 0
4593745 2229316 2229316 defendant Archer John   602353 602353 Archer, John, of Truru 0
4654249 2247210 2247210 defendant Seys James yeoman 602353 602353 Seys, James, of Truru, yeoman 0
4654253 2247211 2247211 defendant Belyetter John bellfounder 602353 602353 Belyetter, John, of Truru, bellfounder 1
4654254 2247211 2247211 defendant Dru John yeoman 602353 602353 Dru, John, of Truru, yeoman 2
4657232 2248148 2248148 plaintiff Clerk John   602353 602353 Clerk, John, of Truru 0
4666001 2250841 2250841 defendant Sandowe Nicholas cordwainer 602353 602353 Sandowe, Nicholas, of Truru, cordwainer 1
4666002 2250841 2250841 defendant Clerk John tanner 602353 602353 Clerk, John, of Truru, tanner 2
4776710 2288707 2288707 plaintiff Archdekene John   602353 602353 Archdekene, John, of Truru 0
4786690 2291891 2291891 defendant Ressant Henry laborer 602353 602353 Ressant, Henry, of Truru, laborer 3
4786691 2291891 2291891 defendant Due John saddler 602353 602353 Due, John, of Truru, saddler 4
4786692 2291891 2291891 defendant Herbart Mark laborer 602353 602353 Herbart, Mark, of Truru, laborer 5
4799439 2296006 2296006 defendant Trenelwyth Ricarda   602353 602353 Trenelwyth, Ricarda, of Truru, widow of Trenelwyth, John 1
4799445 2296007 2296007 defendant Trenellewyth Ricarda   602353 602353 Trenellewyth, Ricarda, of Truru, widow of Trenellewyth, Nicholas 1
4946067 2340757 2340757 defendant Lybowe Thomas glover 602353 602353 Lybowe, Thomas, of Truru, glover 0
4946068 2340757 2340757 defendant Bostolowe or Boscolowe Benedict glover 602353 602353 Bostolowe or Boscolowe, Benedict, of Truru, glover 1
4948952 2341654 2341654 defendant Selander John merchant 602353 602353 Selander, John, of Truru, merchant 0
4955628 2343651 2343651 defendant Sely David yeoman 602353 602353 Sely, David, of Truru, yeoman 0
4955629 2343651 2343651 defendant Talnargh Richard hooper 602353 602353 Talnargh, Richard, of Truru, hooper 1
4955630 2343651 2343651 defendant Talnargh Thomas hooper 602353 602353 Talnargh, Thomas, of Truru, hooper 2
4955631 2343651 2343651 defendant Michell James   602353 602353 Michell, James, of Truru, shipwright 3
4956128 2343795 2343795 plaintiff Trevesythyk Reginald   602353 602353 Trevesythyk, Reginald, of Truru 0
4959398 2344777 2344777 defendant Moton John husbandman 602353 602353 Moton, John, of Truru, husbandman 2
4982078 2351557 2351557 defendant Sely David yeoman 602353 602353 Sely, David, of Truru, yeoman 0
4982079 2351557 2351557 defendant Talnargh or Talvargh Richard hooper 602353 602353 Talnargh or Talvargh, Richard, of Truru, hooper 1
4982080 2351557 2351557 defendant Talnargh or Talvargh Thomas husbandman 602353 602353 Talnargh or Talvargh, Thomas, of Truru, husbandman 2
4982081 2351557 2351557 defendant Michell James   602353 602353 Michell, James, of Truru, shipwright 3
5072904 2378382 2378382 plaintiff Tregher Martin   602353 602353 Tregher, Martin, of Truru 0
5526094 2512738 2512738 defendant Colyng Henry gent 602353 602353 Colyng, Henry, of Truru, gent 3
5586581 2530839 2530839 defendant Cowelynge Henry gent 602353 602353 Cowelynge, Henry, of Truru, gent 0
5591825 2532428 2532428 plaintiff Trewyke Richard   602353 602353 Trewyke, Richard, of Truru 0
5601042 2535212 2535212 defendant Gourbewe Henry husbandman 602353 602353 Gourbewe, Henry, of Truru, husbandman 0
5601825 2535472 2535472 defendant Cowlyng Henry gent 602353 602353 Cowlyng, Henry, of Truru, gent 0
5603599 2535999 2535999 defendant Brusy Henry yeoman 602353 602353 Brusy, Henry, of Truru, yeoman 0

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