names

22 rows where place_id = 588341

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594160 1865815 1865815 defendant Bonython Richard gent 588341 588341 Bonython, Richard, of Penryn, Cornw, gent 0
3594163 1865816 1865816 defendant Bonython Richard gent 588341 588341 Bonython, Richard, of Penryn, Cornw, gent 0
3874476 1981692 1981692 defendant Shutfford William gent 588341 588341 Shutfford, William, of Penryn, Cornw, gent 0
3874511 1981697 1981697 defendant Shutfford William gent 588341 588341 Shutfford, William, of Penryn, Cornw, gent 0
3950516 2007259 2007259 defendant Amadas Robert gent 588341 588341 Amadas, Robert, of Penryn, Cornw, gent 1
3967781 2013363 2013363 defendant Kerne alias Tresylyan Pascase gent 588341 588341 Kerne alias Tresylyan, Pascase, of Penryn, Cornw, gent 0
4045133 2040711 2040711 defendant Bowyer William yeoman 588341 588341 Bowyer, William, of Penryn, Cornw, yeoman 0
4045135 2040712 2040712 defendant Bowyer John gent 588341 588341 Bowyer, John, of Penryn, Cornw, gent 0
4136732 2073485 2073485 defendant Wood William vintner 588341 588341 Wood, William, of Penryn, Cornw, vintner 0
4148384 2077565 2077565 defendant Kyllegrewe Peter brother of John 588341 588341 Kyllegrewe, Peter, of Penryn, Cornw, esq, brother of John 1
4148934 2077747 2077747 defendant Mondaye Peter yeoman 588341 588341 Mondaye, Peter, of Penryn, Cornw, yeoman 0
4148936 2077748 2077748 defendant Mondaye Peter yeoman 588341 588341 Mondaye, Peter, of Penryn, Cornw, yeoman 0
4359140 2150432 2150432 defendant Payne Thomas gent 588341 588341 Payne, Thomas, of Penryn, Cornw, gent 2
4752903 2281302 2281302 defendant Cornyssh John merchant 588341 588341 Cornyssh, John, of Penryn, Cornw, merchant 1
4752907 2281303 2281303 defendant Geffrey John gent 588341 588341 Geffrey, John, of Penryn, cornw, gent 0
4752909 2281303 2281303 defendant Tremayn Henry mariner 588341 588341 Tremayn, Henry, of Penryn, Cornw, mariner 2
4907792 2328998 2328998 defendant Waryn Joan widow 588341 588341 Waryn, Joan, of Penryn, Cornw, widow 0
5134093 2396469 2396469 defendant Barell (illegible) yeoman 588341 588341 Barell, -----, of Penryn, Cornw, yeoman 0
5332520 2454790 2454790 plaintiff Cobbe William merchant 588341 588341 Cobbe, William, of Penryn, Cornw, merchant 0
5378278 2468783 2468783 defendant Beneython Richard gent 588341 588341 Beneython, Richard, of Penryn, Cornw, gent 0
5402455 2475772 2475772 defendant Purser alias Rawe Thomas merchant 588341 588341 Purser alias Rawe, Thomas, of Penryn, Cornw, merchant 0
5570168 2525847 2525847 defendant Genyn Simon   588341 588341 Genyn, Simon, of Penryn, Cornw, merchant, shipowner, the George of Falmouth 2

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