names

46 rows where place_id = 594995

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3618415 1873393 1873393 defendant Glyn John gent 594995 594995 Glyn, John, of Morvall, gent 0
3661247 1913794 1913794 defendant Olyver George laborer 594995 594995 Olyver, George, of Morvall, laborer 2
3886935 1985894 1985894 defendant Nycoll Richard husbandman 594995 594995 Nycoll, Richard, of Morvall, husbandman 0
3887280 1986011 1986011 defendant Praundergest John gent 594995 594995 Praundergest, John, of Morvall, gent 0
3901041 1990577 1990577 defendant Short John husbandman 594995 594995 Short, John, of Morvall, husbandman 0
3903352 1991343 1991343 defendant Gaych William husbandman 594995 594995 Gaych, William, of Morvall, husbandman 0
3919155 1996731 1996731 defendant Nycoll Richard miller 594995 594995 Nycoll, Richard, of Morvall, miller 1
3922264 1997758 1997758 defendant Nycoll Richard miller 594995 594995 Nycoll, Richard, of Morvall, miller 1
4058996 2045613 2045613 defendant Chubb Richard husbandman 594995 594995 Chubb, Richard, of Morvall, husbandman 0
4058997 2045613 2045613 defendant Ew Leonard laborer 594995 594995 Ew, Leonard, of Morvall, laborer 1
4058998 2045613 2045613 defendant Ew Thomas husbandman 594995 594995 Ew, Thomas, of Morvall, husbandman 2
4068218 2048934 2048934 defendant Clemens John husbandman 594995 594995 Clemens, John, of Morvall, husbandman 0
4068219 2048934 2048934 defendant Clemens Henry laborer 594995 594995 Clemens, Henry, of Morvall, laborer 1
4073540 2050823 2050823 defendant Clemens John husbandman 594995 594995 Clemens, John, of Morvall, husbandman 0
4073542 2050824 2050824 defendant Clemens John husbandman 594995 594995 Clemens, John, of Morvall, husbandman 0
4114596 2065509 2065509 defendant Waye William (legal representative) 594995 594995 Waye, William, of Morvall, yeoman, executrix of 0
4114597 2065509 2065509 defendant Waye Joan widow 594995 594995 Waye, Joan, of Morvall, widow 1
4145907 2076724 2076724 defendant Clemence John husbandman 594995 594995 Clemence, John, of Morvall, husbandman 5
4145914 2076725 2076725 defendant Clemence John husbandman 594995 594995 Clemence, John, of Morvall, husbandman 5
4155856 2080126 2080126 defendant Ewstas Richard husbandman 594995 594995 Ewstas, Richard, of Morvall, husbandman 2
4174385 2086506 2086506 defendant Hoskynge Richard husbandman 594995 594995 Hoskynge, Richard, of Morvall, husbandman 0
4384742 2159583 2159583 defendant Towsey Peter husbandman 594995 594995 Towsey, Peter, of Morvall, husbandman 0
4578015 2224629 2224629 defendant Michell John   594995 594995 Michell, John, of Morvall 2
4797620 2295432 2295432 defendant Colyn Walter drover 594995 594995 Colyn, Walter, of Morvall, drover 2
4882016 2321274 2321274 defendant Tallan Hugh gent 594995 594995 Tallan, Hugh, of Morvall, gent 0
5066570 2376526 2376526 defendant Pennarth Thomas gent 594995 594995 together with Pennarth, Thomas, of Morvall, gent 1
5066574 2376527 2376527 defendant Pennarth Thomas gent 594995 594995 Pennarth, Thomas, of Morvall, gent 0
5116965 2391388 2391388 defendant Hugh Roger husbandman 594995 594995 Hugh, Roger, of Morvall, husbandman 3
5131568 2395715 2395715 defendant Code Walter gent 594995 594995 Code, Walter, of Morvall, gent 0
5131585 2395719 2395719 defendant Pollard Walter chaplain 594995 594995 Pollard, Walter, of Morvall, chaplain 1
5131586 2395719 2395719 defendant Knoly Thomas husbandman 594995 594995 Knoly, Thomas, of Morvall, husbandman 2
5151049 2401447 2401447 defendant Code Walter gent 594995 594995 Code, Walter, of Morvall, gent 0
5151062 2401451 2401451 defendant Pollard Walter chaplain 594995 594995 Pollard, Walter, of Morvall, chaplain 1
5151063 2401451 2401451 defendant Knoky Thomas husbandman 594995 594995 Knoky, Thomas, of Morvall, husbandman 2
5169346 2406768 2406768 defendant Palard Walter chaplain 594995 594995 Palard, Walter, of Morvall, chaplain 1
5169350 2406770 2406770 defendant Code Walter gent 594995 594995 Code, Walter, of Morvall, gent 0
5186035 2411662 2411662 defendant Pollard Walter chaplain 594995 594995 Pollard, Walter, of Morvall, chaplain 1
5186046 2411665 2411665 defendant Pollard Walter chaplain 594995 594995 Pollard, Walter, of Morvall, chaplain 1
5186047 2411665 2411665 defendant Knoky Thomas husbandman 594995 594995 Knoky, Thomas, of Morvall, husbandman 2
5205051 2417232 2417232 defendant Code Walter gent 594995 594995 Code, Walter, of Morvall, gent 0
5262813 2434113 2434113 defendant Bunte John husbandman 594995 594995 Bunte, John, of Morvall, husbandman 0
5262814 2434113 2434113 defendant Bunte William husbandman 594995 594995 Bunte, William, of Morvall, husbandman 1
5262818 2434114 2434114 defendant Bunte John husbandman 594995 594995 Bunte, John, of Morvall, husbandman 0
5262819 2434114 2434114 defendant Bunte William husbandman 594995 594995 Bunte, William, of Morvall, husbandman 1
5335242 2455607 2455607 defendant Glyn John gent 594995 594995 Glyn, John, of Morvall, gent 0
5336588 2456008 2456008 defendant Glyn John gent 594995 594995 Glyn, John, of Morvall, gent 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);