names

24 rows where place_id = 668400

✎ 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
3921185 1997438 1997438 defendant Mayne William   668400 668400 Mayne, William, of Credyton, Devon, gent, attorney 0
3988961 2020792 2020792 defendant Delve Peter husbandman 668400 668400 Delve, Peter, of Credyton, Devon, husbandman 0
3988967 2020793 2020793 defendant Delve Peter husbandman 668400 668400 Delve, Peter, of Credyton, Devon, husbandman 0
4011622 2028900 2028900 defendant Weyvell William gent 668400 668400 Weyvell, William, of Credyton, Devon, gent 3
4015902 2030377 2030377 plaintiff Spencer Thomas yeoman 668400 668400 Spencer, Thomas, of Credyton, Devon, yeoman 0
4024346 2033391 2033391 defendant Froste Mathew husbandman 668400 668400 Froste, Mathew, of Credyton, Devon, husbandman 7
4033723 2036710 2036710 defendant Saunder Richard husbandman 668400 668400 Saunder, Richard, of Credyton, Devon, husbandman 0
4050803 2042724 2042724 defendant Kyngwell William gent 668400 668400 Kyngwell, William, of Credyton, Devon, gent 0
4121614 2068024 2068024 defendant Spencer Thomas yeoman 668400 668400 Spencer, Thomas, of Credyton, Devon, yeoman 0
4144169 2076124 2076124 defendant Charde John yeoman 668400 668400 Charde, John, of Credyton, Devon, yeoman 1
4148747 2077686 2077686 defendant Dowrishe Thomas esq 668400 668400 Dowrishe, Thomas, of Credyton, Devon, esq 0
4170422 2085148 2085148 defendant Heard William husbandman 668400 668400 Heard, William, of Credyton, Devon, husbandman 0
4172074 2085697 2085697 defendant Wade Philip baker 668400 668400 Wade, Philip, of Credyton, Devon, victualer, baker 0
4194010 2093463 2093463 defendant Wyvell William gent 668400 668400 Wyvell, William, of Credyton, Devon, gent 1
4205229 2097379 2097379 defendant Wevell Nicholas gent 668400 668400 Wevell, Nicholas, of Credyton, Devon, gent 0
4212084 2099775 2099775 defendant Brodmeade Benedict husbandman 668400 668400 Brodmeade, Benedict, of Credyton, Devon, husbandman 3
4253569 2114183 2114183 defendant Furse John, junior gent 668400 668400 Furse, John, junior, of Credyton, Devon, gent, son of John Furse, of Crediton, gent 0
4287069 2125430 2125430 defendant Atwill Richard yeoman 668400 668400 Atwill, Richard, of Credyton, Devon, yeoman 0
4330171 2140392 2140392 defendant Newman Richard merchant 668400 668400 Newman, Richard, of Credyton, Devon, merchant 0
4359165 2150437 2150437 defendant Shorte William yeoman 668400 668400 Shorte, William, of Credyton, Devon, yeoman 2
4384262 2159429 2159429 defendant Stevens Philip baker 668400 668400 Stevens, Philip, of Credyton, Devon, baker 1
4395890 2163203 2163203 defendant Newman Richard merchant 668400 668400 Newman, Richard, of Credyton, Devon, merchant 0
4398707 2164147 2164147 defendant Babcombe Richard miller 668400 668400 Babcombe, Richard, of Credyton, Devon, miller 2
4399046 2164264 2164264 defendant Shilston Walter gent 668400 668400 Shilston, Walter, of Credyton, Devon, 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);