names

40 rows where place_id = 603058

✎ 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
3652919 1911239 1911239 defendant Spret John mercer 603058 603058 Spret, John, of Plympton, Devon, mercer 0
3671186 1916959 1916959 defendant Trevath John mercer 603058 603058 Trevath, John, of Plympton, Devon, mercer 0
3743651 1939891 1939891 defendant Chalans William yeoman 603058 603058 Chalans, William, of Plympton, Devon, yeoman 0
3920137 1997070 1997070 defendant Gregory John mercer 603058 603058 Gregory, John, of Plympton, Devon, mercer 0
3922979 1997994 1997994 defendant Sparke John merchant 603058 603058 Sparke, John, of Plympton, Devon, merchant 1
3930690 2000614 2000614 defendant Skynner Walter gent 603058 603058 Skynner, Walter, of Plympton, Devon, gent 0
3942284 2004433 2004433 defendant Gregory John chapman 603058 603058 Gregory, John, of Plympton, Devon, chapman 0
3989782 2021091 2021091 defendant Battishill Thomas merchant 603058 603058 Battishill, Thomas, of Plympton, Devon, merchant 0
4027303 2034412 2034412 defendant Sperke Richard merchant 603058 603058 Sperke, Richard, of Plympton, Devon, merchant 0
4028964 2035004 2035004 defendant Saunders alias Pethebrudge John   603058 603058 Saunders alias Pethebrudge, John, of Plympton, Devon, hat maker 0
4028967 2035005 2035005 defendant Saunders alias Pewthebrudge John hatmaker 603058 603058 Saunders alias Pewthebrudge, John, of Plympton, Devon, hatmaker 0
4030154 2035430 2035430 plaintiff Drue Margaret widow 603058 603058 Drue, Margaret, of Plympton, Devon, widow 0
4066869 2048447 2048447 defendant Saunders alias Pethebridge John   603058 603058 Saunders alias Pethebridge, John, of Plympton, Devon, hat maker 1
4182070 2089207 2089207 defendant Colls John shoemaker 603058 603058 Colls, John, of Plympton, Devon, shoemaker 3
4216791 2101368 2101368 defendant Platt Anthony gent 603058 603058 Platt, Anthony, of Plympton, Devon, gent 0
4297856 2129339 2129339 defendant Cryspen Achilles gent 603058 603058 Cryspen, Achilles, of Plympton, Devon, gent 0
4696604 2264415 2264415 defendant Jacob Edward yeoman 603058 603058 Jacob, Edward, of Plympton, Devon, yeoman 4
4709738 2268405 2268405 defendant Silverlok William chapman 603058 603058 Silverlok, William, of Plympton, Devon, chapman 1
4709740 2268405 2268405 defendant Silverlok John gent 603058 603058 together with Silverlok, John, of Plympton, Devon, gent 3
4709746 2268406 2268406 defendant Silverlok William chapman 603058 603058 Silverlok, William, of Plympton, Devon, chapman 3
4709747 2268406 2268406 defendant Martyn Peter shipman 603058 603058 Martyn, Peter, of Plympton, Devon, shipman 4
4709749 2268407 2268407 defendant Sylverlok John gent 603058 603058 Sylverlok, John, of Plympton, Devon, gent 0
4709752 2268407 2268407 defendant Silverlok William chapman 603058 603058 Silverlok, William, of Plympton, Devon, chapman 3
4709753 2268407 2268407 defendant Martyn Peter shipman 603058 603058 Martyn, Peter, of Plympton, Devon, shipman 4
4717225 2270716 2270716 defendant Rose Peter tailor 603058 603058 Rose, Peter, of Plympton, Devon, tailor 0
4808374 2298797 2298797 defendant Goys or Eays John gent 603058 603058 Goys or Eays, John, of Plympton, Devon, gent 2
4808447 2298815 2298815 defendant Boys John gent 603058 603058 Boys, John, of Plympton, Devon, gent 2
4845186 2310006 2310006 defendant Selman John, sen gent 603058 603058 Selman, John, sen, of Plympton, Devon, gent 1
4890718 2323850 2323850 defendant Bronde John, senior shoemaker 603058 603058 Bronde, John, senior, of Plympton, Devon, shoemaker 1
4959565 2344819 2344819 defendant Stone John gent 603058 603058 Stone, John, of Plympton, Devon, gent 2
4978649 2350562 2350562 defendant Chalons John esq 603058 603058 Chalons, John, of Plympton, Devon, esq 0
4978651 2350563 2350563 defendant Chalons John esq 603058 603058 Chalons, John, of Plympton, Devon, esq 0
4998145 2356312 2356312 defendant Serle John gent 603058 603058 Serle, John, of Plympton, Devon, gent 0
5069519 2377381 2377381 defendant Brakkelegh John chapman 603058 603058 Brakkelegh, John, of Plympton, Devon, chapman 0
5069976 2377515 2377515 defendant Bakkeleth John chapman 603058 603058 Bakkeleth, John, of Plympton, Devon, chapman 0
5115924 2391086 2391086 defendant Dawebyn alias Chapman John chapman 603058 603058 Dawebyn alias Chapman, John, of Plympton, Devon, chapman 0
5131576 2395716 2395716 defendant Pyke William gent 603058 603058 Pyke, William, of Plympton, Devon, gent 6
5190498 2412965 2412965 defendant Brakeley John yeoman 603058 603058 Brakeley, John, of Plympton, Devon, yeoman 0
5223139 2422478 2422478 defendant Tabyn John mercer 603058 603058 Tabyn, John, of Plympton, Devon, mercer 2
5292569 2442823 2442823 defendant Ryke John gent 603058 603058 Ryke, John, of Plympton, Devon, gent, son of Ryke, Richard, of Plympton, gent 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);