names

31 rows where case_id = 2392843

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5121910 2392843 2392843 plaintiff Tregarthen Thomas     Tregarthen, Thomas 0
5121911 2392843 2392843 defendant Derneford James esq 848891 848891 Derneford, James, of Estonehouse, Devon, esq 0
5121912 2392843 2392843 defendant Nicoll William merchant 592959 592959 Nicoll, William, of Plymmouth, Devon, merchant 1
5121913 2392843 2392843 defendant Tavystoke Roger merchant 586834 586834 Tavystoke, Roger, of Plymmouth, merchant 2
5121914 2392843 2392843 defendant Debernon Richard merchant 586834 586834 Debernon, Richard, of Plymmouth, merchant 3
5121915 2392843 2392843 defendant Tregell Thomas merchant 586834 586834 Tregell, Thomas, of Plymmouth, merchant 4
5121916 2392843 2392843 defendant Hill Thomas merchant 586834 586834 Hill, Thomas, of Plymmouth, merchant 5
5121917 2392843 2392843 defendant Colman William   848892 848892 Colman, William, of Plymmouth, weave 6
5121918 2392843 2392843 defendant Warwyk Thomas   586834 586834 Warwyk, Thomas, of Plymmouth, millward 7
5121919 2392843 2392843 defendant Bole Thomas merchant 586834 586834 Bole, Thomas, of Plymmouth, merchant 8
5121920 2392843 2392843 defendant Skynner Robert skinner 586834 586834 Skynner, Robert, of Plymmouth, skinner 9
5121921 2392843 2392843 defendant Smyth John yeoman 586834 586834 Smyth, John, of Plymmouth, yeoman 10
5121922 2392843 2392843 defendant Page John merchant 586834 586834 Page, John, of Plymmouth, merchant 11
5121923 2392843 2392843 defendant Colman Richard mariner 586834 586834 Colman, Richard, of Plymmouth, mariner 12
5121924 2392843 2392843 defendant Forster Walter mercer 586834 586834 Forster, Walter, of Plymmouth, mercer 13
5121925 2392843 2392843 defendant Grygge Thomas smith 586834 586834 Grygge, Thomas, of Plymmouth, smith 14
5121926 2392843 2392843 defendant Fourbour John furbisher 586834 586834 Fourbour, John, of Plymmouth, furbisher 15
5121927 2392843 2392843 defendant Geffrey Richard shoemaker 586834 586834 Geffrey, Richard, of Plymmouth, shoemaker 16
5121928 2392843 2392843 defendant Spyne or Spyve John merchant 586834 586834 Spyne or Spyve, John, of Plymmouth, merchant 17
5121929 2392843 2392843 defendant Morys John merchant 586834 586834 Morys, John, of Plymmouth, merchant 18
5121930 2392843 2392843 defendant Wymond John baker 586834 586834 Wymond, John, of Plymmouth, baker 19
5121931 2392843 2392843 defendant Gowe Robert butcher 586834 586834 Gowe, Robert, of Plymmouth, butcher 20
5121932 2392843 2392843 defendant Glogge Thomas mariner 586834 586834 Glogge, Thomas, of Plymmouth, mariner 21
5121933 2392843 2392843 defendant Buk John merchant 586834 586834 Buk, John, of Plymmouth, merchant 22
5121934 2392843 2392843 defendant Cheverney Thomas butcher 586834 586834 Cheverney, Thomas, of Plymmouth, butcher 23
5121935 2392843 2392843 defendant Waran John yeoman 586834 586834 Waran, John, of Plymmouth, yeoman 24
5121936 2392843 2392843 defendant Peutrer Nicholas pewterer 586834 586834 Peutrer, Nicholas, of Plymmouth, pewterer 25
5121937 2392843 2392843 defendant Jacob John mariner 586834 586834 Jacob, John, of Plymmouth, mariner 26
5121938 2392843 2392843 defendant Crystofer John fisher 586834 586834 Crystofer, John, of Plymmouth, fisher 27
5121939 2392843 2392843 defendant Sayer John mariner 586834 586834 Sayer, John, of Plymmouth, mariner 28
5121940 2392843 2392843 defendant Charleton Nicholas merchant 586834 586834 Charleton, Nicholas, of Plymmouth, merchant 29

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