names

17 rows where case_id = 1926562

✎ 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
3700996 1926562 1926562 plaintiff Bewyke alias Swyllyngton of London draper   Bewyke alias Swyllyngton, of London, draper, executors of 0
3700997 1926562 1926562 plaintiff Owen William gent   (Owen, William, gent 1
3700998 1926562 1926562 defendant Whytfyld John esq 613923 613923 Whytfyld, John, of Whytfyld, Northumb, esq 0
3700999 1926562 1926562 defendant Bechamp Agnes (legal representative)   Bechamp, Agnes, executrix of Bechamp, Thomas, of Croglyn, Cumber, gent, executors of 1
3701000 1926562 1926562 defendant Blenkynsop John esq 613924 613924 (Blenkynsop, John, of Blenkynsop, Northumb, esq 2
3701001 1926562 1926562 defendant Hoston Anthony gent 613925 613925 Hoston, Anthony, of Hoston, Nurthumb, gent 3
3701002 1926562 1926562 defendant Wodell Gilbert gent 613926 613926 Wodell, Gilbert, of Naferton, Yorks, gent 4
3701003 1926562 1926562 defendant Horpoll Robert gent 613927 613927 Horpoll, Robert, of Clerkyngwell, Middx, or of Lincolns Inn, gent 5
3701004 1926562 1926562 defendant Bollyng Alice yeoman of the crown 600209 600209 Bollyng, Alice, of Bradford, Yorks, widow of Bollyng, Raynbrowne, of Bradford, yeoman of the crown 6
3701005 1926562 1926562 defendant Hall Ralph yeoman 613929 613929 Hall, Ralph, of Byrtelee, Durham, yeoman 7
3701006 1926562 1926562 defendant Lucton Thomas gent 613930 613930 Lucton, Thomas, of Clements Inn, Middx, gent 8
3701007 1926562 1926562 defendant Grenewyll Edward gent 586035 586035 Grenewyll, Edward, of Buckingham, or of Middle Temple, gent 9
3701008 1926562 1926562 defendant Marshall Thomas tailor 585929 585929 Marshall, Thomas, of St Clement Danes, tailor 10
3701009 1926562 1926562 defendant Ratclyff William gent 602238 602238 Ratclyff, William, of Tadcaster, Yorks, or of Clements Inn, gent 11
3701010 1926562 1926562 defendant Studley John vicar of Good Ester   Studley, John, vicar of Good Ester 12
3701011 1926562 1926562 defendant Madewe William yeoman 613933 613933 Madewe, William, of St Dunstan in the WEest, London, yeoman 13
3701012 1926562 1926562 defendant Constable Robert esq 613934 613934 Constable, Robert, of Twyng, Yorks, or of Clements Inn, esq 14

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