names

18 rows where place_id = 600983

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643421 1908368 1908368 defendant Jenyns John yeoman of the king 600983 600983 Jenyns, John, of Truru, Cornw, yeoman of the king 0
3673649 1917790 1917790 defendant Bevyle Peter gent 600983 600983 Bevyle, Peter, of Truru, Cornw, gent 0
3733811 1936828 1936828 defendant Michell Drew merchant 600983 600983 Michell, Drew, of Truru, Cornw, merchant 0
3812023 1961669 1961669 defendant Bottler John merchant 600983 600983 Bottler, John, of Truru, Cornw, merchant 0
3812073 1961686 1961686 defendant Bottler John merchant 600983 600983 Bottler, John, of Truru, Cornw, merchant 0
3851170 1973957 1973957 defendant Lagharn Stephen gent 600983 600983 Lagharn, Stephen, of Truru, Cornw, gent 0
3851172 1973958 1973958 defendant Lagharn Stephen gent 600983 600983 Lagharn, Stephen, of Truru, Cornw, gent 0
3874504 1981696 1981696 defendant Trewike John merchant 600983 600983 Trewike, John, of Truru, Cornw, merchant 0
3874536 1981701 1981701 defendant Trewike John merchant 600983 600983 Trewike, John, of Truru, Cornw, merchant 0
3879905 1983537 1983537 defendant Lagharn Stephen gent 600983 600983 Lagharn, Stephen, of Truru, Cornw, gent 0
3963587 2011874 2011874 defendant Mychell John merchant 600983 600983 Mychell, John, of Truru, Cornw, merchant 0
3982289 2018436 2018436 defendant Mychell John merchant 600983 600983 Mychell, John, of Truru, Cornw, merchant 0
4008169 2027689 2027689 plaintiff Melhuyshe John (legal representative) 600983 600983 Melhuyshe, John, of Truru, Cornw, merchant, administrator of 0
4665026 2250540 2250540 defendant Stikworth John esq 600983 600983 Stikworth, John, of Truru, Cornw, esq 1
4799438 2296006 2296006 defendant Urban Nicholas tailor 600983 600983 Urban, Nicholas, of Truru, Cornw, tailor 0
4799444 2296007 2296007 defendant Urban Nicholas tailor 600983 600983 Urban, Nicholas, of Truru, Cornw, tailor 0
4900810 2326883 2326883 defendant Tregasowe John chaplain 600983 600983 Tregasowe, John, of Truru, Cornw, chaplain 1
5115652 2391006 2391006 defendant Crehar Martin merchant 600983 600983 Crehar, Martin, of Truru, Cornw, merchant 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);