names

14 rows where case_id = 1917790

✎ 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
3673648 1917790 1917790 plaintiff FitzJames John     FitzJames, John 0
3673649 1917790 1917790 defendant Bevyle Peter gent 600983 600983 Bevyle, Peter, of Truru, Cornw, gent 0
3673650 1917790 1917790 defendant Godolphan John esq 605546 605546 Godolphan, John, of Cornw, esq 1
3673651 1917790 1917790 defendant Tregoos Thomas gent 608418 608418 Tregoos, Thomas, of Trewnleke, Cornw, gent 2
3673652 1917790 1917790 defendant Treunwith Thomas gent 608419 608419 Treunwith, Thomas, of St Jes, Cornw, gent 3
3673653 1917790 1917790 defendant Chenowith Michael merchant 608420 608420 Chenowith, Michael, of St Yes, merchant 4
3673654 1917790 1917790 defendant Code Richard gent 608421 608421 Code, Richard, of Morvall, Cornw, gent 5
3673655 1917790 1917790 defendant Trecarell Henry gent 608422 608422 Trecarell, Henry, of Trecarell, Cornw, gent 6
3673656 1917790 1917790 defendant Tregafowe John gent 601946 601946 Tregafowe, John, of Leskerd, Cornw, gent 7
3673657 1917790 1917790 defendant Loure William gent 608423 608423 Loure, William, of Wynowe, Cornw, gent 8
3673658 1917790 1917790 defendant Newcourt Theobald gent 608424 608424 Newcourt, Theobald, of Carguyn, Cornw, gent 9
3673659 1917790 1917790 defendant Enys Nicholas gent 608425 608425 Enys, Nicholas, of Luxurian, Cornw, gent 10
3673660 1917790 1917790 defendant Goleyn John gent 608426 608426 Goleyn, John, of Golyn, Cornw, gent 11
3673661 1917790 1917790 defendant Rosagan John gent 608427 608427 Rosagan, John, of Rosagan, Cornw, gent 12

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