names

33 rows where case_id = 2392844

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5121941 2392844 2392844 plaintiff Tregarthen Thomas     Tregarthen, Thomas 0
5121942 2392844 2392844 defendant Dorneford James esq 848891 848891 Dorneford, James, of Estonehouse, Devon, esq 0
5121943 2392844 2392844 defendant Nicoll William merchant 592959 592959 together with Nicoll, William, of Plymmouth, Devon, merchant 1
5121944 2392844 2392844 defendant Tavystoke Roger merchant 586834 586834 Tavystoke, Roger, of Plymmouth, merchant 2
5121945 2392844 2392844 defendant Debernon Richard merchant 586834 586834 Debernon, Richard, of Plymmouth, merchant 3
5121946 2392844 2392844 defendant Tregell Thomas merchant 586834 586834 Tregell, Thomas, of Plymmouth, merchant 4
5121947 2392844 2392844 defendant Hill Thomas merchant 586834 586834 Hill, Thomas, of Plymmouth, merchant 5
5121948 2392844 2392844 defendant Colman William weaver 586834 586834 Colman, William, of Plymmouth, weaver 6
5121949 2392844 2392844 defendant Warwyk Thomas   586834 586834 Warwyk, Thomas, of Plymmouth, millward 7
5121950 2392844 2392844 defendant Bole Thomas merchant 586834 586834 Bole, Thomas, of Plymmouth, merchant 8
5121951 2392844 2392844 defendant Skynner Robert skinner 586834 586834 Skynner, Robert, of Plymmouth, skinner 9
5121952 2392844 2392844 defendant Smyth John yeoman 586834 586834 Smyth, John, of Plymmouth, yeoman 10
5121953 2392844 2392844 defendant Page John merchant 586834 586834 Page, John, of Plymmouth, merchant 11
5121954 2392844 2392844 defendant Colman Richard mariner 586834 586834 Colman, Richard, of Plymmouth, mariner 12
5121955 2392844 2392844 defendant Forster Walter mercer 586834 586834 Forster, Walter, of Plymmouth, mercer 13
5121956 2392844 2392844 defendant Grygge Thomas smith 586834 586834 Grygge, Thomas, of Plymmouth, smith 14
5121957 2392844 2392844 defendant Fourbour John   586834 586834 Fourbour, John, of Plymmouth, "furbour" or furbisher 15
5121958 2392844 2392844 defendant Geffrey Richard shoemaker 586834 586834 Geffrey, Richard, of Plymmouth, shoemaker 16
5121959 2392844 2392844 defendant Spyne or Spyve John merchant 586834 586834 Spyne or Spyve, John, of Plymmouth, merchant 17
5121960 2392844 2392844 defendant Morys John merchant 586834 586834 Morys, John, of Plymmouth, merchant 18
5121961 2392844 2392844 defendant Wymond John baker 586834 586834 Wymond, John, of Plymmouth, baker 19
5121962 2392844 2392844 defendant Gewe Robert butcher 586834 586834 Gewe, Robert, of Plymmouth, butcher 20
5121963 2392844 2392844 defendant Glogge Thomas mariner 586834 586834 Glogge, Thomas, of Plymmouth, mariner 21
5121964 2392844 2392844 defendant Buk John merchant 586834 586834 Buk, John, of Plymmouth, merchant 22
5121965 2392844 2392844 defendant Buk Elias merchant 586834 586834 Buk, Elias, of Plymmouth, merchant 23
5121966 2392844 2392844 defendant Noyter Richard merchant 586834 586834 Noyter, Richard, of Plymmouth, merchant 24
5121967 2392844 2392844 defendant Cheverney Thomas butcher 586834 586834 Cheverney, Thomas, of Plymmouth, butcher 25
5121968 2392844 2392844 defendant Waren John yeoman 586834 586834 Waren, John, of Plymmouth, yeoman 26
5121969 2392844 2392844 defendant Peutrer Nicholas pewterer 586834 586834 Peutrer, Nicholas, of Plymmouth, pewterer 27
5121970 2392844 2392844 defendant Jacob John mariner 586834 586834 Jacob, John, of Plymmouth, mariner 28
5121971 2392844 2392844 defendant Cristofer John fisher 586834 586834 Cristofer, John, of Plymmouth, fisher 29
5121972 2392844 2392844 defendant Sayer John mariner 586834 586834 Sayer, John, of Plymmouth, mariner 30
5121973 2392844 2392844 defendant Charleton Nicholas merchant 586834 586834 Charleton, Nicholas, of Plymmouth, merchant 31

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