names

53 rows where place_id = 598344

✎ 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
3632063 1904844 1904844 defendant Rolff John yeoman 598344 598344 Rolff, John, of Roche, yeoman 3
3653870 1911475 1911475 plaintiff (illegible) John   598344 598344 --, John, of Roche, abbot of the monastery of St Mary 0
3740366 1938851 1938851 plaintiff Rolff Thomas yeoman 598344 598344 Rolff, Thomas, of Roche, yeoman 0
3801080 1958254 1958254 defendant Trebilcok Odo husbandman 598344 598344 Trebilcok, Odo, of Roche, husbandman 0
3801081 1958254 1958254 defendant Trebilcok Simon husbandman 598344 598344 Trebilcok, Simon, of Roche, husbandman 1
3806910 1960070 1960070 defendant Jakson Thomas yeoman 598344 598344 Jakson, Thomas, of Roche, yeoman 0
3838474 1969958 1969958 defendant Niclys Luke husbandman 598344 598344 Niclys, Luke, of Roche, husbandman 0
3838475 1969958 1969958 defendant Crabbe Thomas laborer 598344 598344 Crabbe, Thomas, of Roche, laborer 1
3838477 1969958 1969958 defendant Osteller Philip laborer 598344 598344 Osteller, Philip, of Roche, laborer 3
3891860 1987529 1987529 defendant Gardener Edward brewer 598344 598344 Gardener, Edward, of Roche, brewer 0
4157417 2080666 2080666 defendant Lavedden George husbandman 598344 598344 Lavedden, George, of Roche, husbandman 0
4202791 2096521 2096521 defendant Luky John husbandman 598344 598344 Luky, John, of Roche, husbandman 0
4202792 2096521 2096521 defendant Luke Richard husbandman 598344 598344 Luke, Richard, of Roche, husbandman 1
4202793 2096521 2096521 defendant Tonkyn alias Tregonhey Stephen husbandman 598344 598344 together with Tonkyn alias Tregonhey, Stephen, of Roche, husbandman 2
4202795 2096522 2096522 defendant Lukye John husbandman 598344 598344 Lukye, John, of Roche, husbandman 0
4204921 2097262 2097262 defendant Laviden George husbandman 598344 598344 Laviden, George, of Roche, husbandman 0
4310747 2133903 2133903 defendant Coysgarne Robert gent 598344 598344 Coysgarne, Robert, of Roche, gent 0
4363307 2151948 2151948 defendant Key Richard tailor 598344 598344 Key, Richard, of Roche, tailor 0
4399608 2164457 2164457 defendant Carhart Robert husbandman 598344 598344 Carhart, Robert, of Roche, husbandman 1
4399609 2164457 2164457 defendant Menhere Robert husbandman 598344 598344 Menhere, Robert, of Roche, husbandman 2
4405933 2166548 2166548 defendant Woone alias Pentevall Stephen husbandman 598344 598344 Woone alias Pentevall, Stephen, of Roche, husbandman 0
4405934 2166548 2166548 defendant Woone alias Pentevall Thomas husbandman 598344 598344 Woone alias Pentevall, Thomas, of Roche, husbandman 1
4405935 2166548 2166548 defendant Woone alias Pentevall John husbandman 598344 598344 Woone alias Pentevall, John, of Roche, husbandman 2
4452399 2185744 2185744 defendant Cody John   598344 598344 Cody, John, of Roche 1
4479283 2194171 2194171 defendant Phelip Odo   598344 598344 Phelip, Odo, of Roche 7
4513902 2204768 2204768 defendant atte Wyn Philip   598344 598344 atte Wyn, Philip, of Roche 0
4559078 2218798 2218798 defendant Hopkyn John   598344 598344 Hopkyn, John, of Roche 1
4563982 2220309 2220309 defendant Sparewe John   598344 598344 Sparewe, John, of Roche 0
4675561 2257965 2257965 defendant Hikke John husbandman 598344 598344 Hikke, John, of Roche, husbandman 0
4805363 2297882 2297882 defendant Polstak William husbandman 598344 598344 Polstak, William, of Roche, husbandman 3
4898231 2326109 2326109 defendant John Philip clerk 598344 598344 John, Philip, of Roche, clerk 0
4901766 2327159 2327159 defendant James John husbandman 598344 598344 James, John, of Roche, husbandman 0
5012394 2360476 2360476 plaintiff Yonge John   598344 598344 Yonge, John, of Roche 0
5267164 2435489 2435489 defendant Jowey Philip clerk 598344 598344 Jowey, Philip, of Roche, clerk 0
5330628 2454247 2454247 defendant Tregean John   598344 598344 together with Tregean, John, of Roche, franklin 13
5330639 2454249 2454249 defendant Tregean John   598344 598344 Tregean, John, of Roche, franklin 0
5356501 2462102 2462102 defendant Tomkyn John husbandman 598344 598344 Tomkyn, John, of Roche, husbandman 1
5424985 2482440 2482440 defendant Dagon John husbandman 598344 598344 Dagon, John, of Roche, husbandman 1
5424986 2482440 2482440 defendant Nycoll Lawrence husbandman 598344 598344 Nycoll, Lawrence, of Roche, husbandman 2
5456331 2491814 2491814 defendant Dagon John husbandman 598344 598344 Dagon, John, of Roche, husbandman 1
5456332 2491814 2491814 defendant Nycoll Lawrence husbandman 598344 598344 Nycoll, Lawrence, of Roche, husbandman 2
5468143 2495417 2495417 defendant Dagon John husbandman 598344 598344 Dagon, John, of Roche, husbandman 1
5468144 2495417 2495417 defendant Nicoll Lawrence husbandman 598344 598344 Nicoll, Lawrence, of Roche, husbandman 2
5480699 2499189 2499189 defendant Tregayn William husbandman 598344 598344 Tregayn, William, of Roche, husbandman 4
5532529 2514718 2514718 defendant Trebylcok Odo husbandman 598344 598344 Trebylcok, Odo, of Roche, husbandman 0
5583420 2529885 2529885 defendant Stephyn Thomas yeoman 598344 598344 Stephyn, Thomas, of Roche, yeoman 2
5591009 2532167 2532167 defendant Tresebell Philip husbandman 598344 598344 Tresebell, Philip, of Roche, husbandman 1
5591010 2532167 2532167 defendant Tresebell John husbandman 598344 598344 Tresebell, John, of Roche, husbandman 2
5606493 2536920 2536920 defendant Crabbe Richard laborer 598344 598344 Crabbe, Richard, of Roche, laborer 3
5606498 2536921 2536921 defendant Crabbe Richard laborer 598344 598344 Crabbe, Richard, of Roche, laborer 3
5606503 2536922 2536922 defendant Crabbe Richard laborer 598344 598344 Crabbe, Richard, of Roche, laborer 3
5606558 2536936 2536936 defendant Trebylcok Odo yeoman 598344 598344 Trebylcok, Odo, of Roche, yeoman 6
5626463 2552247 2552247 defendant Philpot Odo gent 598344 598344 Philpot, Odo, of Roche, 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);