names

19 rows where place_id = 638279

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3841614 1970961 1970961 defendant Nicoll John, senior gent 638279 638279 Nicoll, John, senior, of St Teth, gent 0
3865735 1978765 1978765 defendant Kyllyowe William   638279 638279 Kyllyowe, William, of St Teth, franklin 0
3865736 1978765 1978765 defendant Dagge John, junior husbandman 638279 638279 Dagge, John, junior, of St Teth, husbandman 1
3869026 1979886 1979886 defendant Trefrye John yeoman 638279 638279 Trefrye, John, of St teth, yeoman 0
3869027 1979886 1979886 defendant Symon Nicholas husbandman 638279 638279 Symon, Nicholas, of St Teth, husbandman 1
3869028 1979886 1979886 defendant Bagge John yeoman 638279 638279 Bagge, John, of St Teth, yeoman 2
3869250 1979958 1979958 defendant Ranke Thomas husbandman 638279 638279 Ranke, Thomas, of St Teth, husbandman 2
3874803 1981790 1981790 defendant Ranke Thomas husbandman 638279 638279 Ranke, Thomas, of St Teth, husbandman 2
3919243 1996766 1996766 defendant Trehanek Thomas yeoman 638279 638279 Trehanek, Thomas, of St Teth, yeoman 0
3930834 2000651 2000651 defendant Hyll John husbandman 638279 638279 Hyll, John, of St Teth, husbandman 0
3945696 2005570 2005570 defendant Randall alias Trevighan John yeoman 638279 638279 Randall alias Trevighan, John, of St Teth, yeoman 0
3945698 2005570 2005570 defendant Hodge Thomas husbandman 638279 638279 Hodge, Thomas, of St Teth, husbandman 2
3945699 2005570 2005570 defendant Lobbe Benedict husbandman 638279 638279 Lobbe, Benedict, of St Teth, husbandman 3
3945700 2005570 2005570 defendant Twyston Thomas husbandman 638279 638279 Twyston, Thomas, of St Teth, husbandman 4
3958556 2010063 2010063 defendant Lobbe Benedict husbandman 638279 638279 Lobbe, Benedict, of St Teth, husbandman 0
4048919 2042058 2042058 defendant Kelyowe William gent 638279 638279 Kelyowe, William, of St Teth, gent 0
4156599 2080385 2080385 defendant Penkevell John clerk 638279 638279 Penkevell, John, of St Teth, clerk 1
4298322 2129501 2129501 defendant Dagg Peter, senior yeoman 638279 638279 Dagg, Peter, senior, of St Teth, yeoman 0
4298323 2129501 2129501 defendant Dagg Peter, junior yeoman 638279 638279 Dagg, Peter, junior, of St Teth, yeoman 1

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