names

40 rows where place_id = 596015

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3622777 1874655 1874655 defendant Escote Robert yeoman 596015 596015 Escote, Robert, of Okehampton, Devon, yeoman 0
3787447 1953866 1953866 defendant Cary John gent 596015 596015 Cary, John, of Okehampton, Devon, gent 2
3840650 1970640 1970640 defendant Escotte Robert yeoman 596015 596015 Escotte, Robert, of Okehampton, Devon, yeoman 0
3874417 1981672 1981672 defendant Cary John esq 596015 596015 Cary, John, of Okehampton, Devon, esq 0
3874445 1981681 1981681 defendant Furse Edmund chapman 596015 596015 Furse, Edmund, of Okehampton, Devon, chapman 4
3925009 1998680 1998680 defendant Cary John esq 596015 596015 Cary, John, of Okehampton, Devon, esq 0
3941290 2004092 2004092 defendant Pawe John yeoman 596015 596015 Pawe, John, of Okehampton, Devon, yeoman 2
3949301 2006825 2006825 defendant Cottell Robert chapman 596015 596015 Cottell, Robert, of Okehampton, Devon, chapman 1
3985251 2019482 2019482 defendant Tottell Robert chapman 596015 596015 Tottell, Robert, of Okehampton, Devon, chapman 0
4014440 2029887 2029887 defendant Cornewe William gent 596015 596015 Cornewe, William, of Okehampton, Devon, gent 1
4055468 2044351 2044351 plaintiff Bickell John   596015 596015 Bickell, John, of Okehampton, Devon 0
4057574 2045089 2045089 plaintiff Byckell John   596015 596015 Byckell, John, of Okehampton, Devon 0
4121437 2067959 2067959 defendant Cornewe William gent 596015 596015 Cornewe, William, of Okehampton, Devon, gent 0
4127301 2070059 2070059 defendant Barnes Stephen yeoman 596015 596015 Barnes, Stephen, of Okehampton, Devon, yeoman 0
4144495 2076237 2076237 defendant Cornewe William gent 596015 596015 Cornewe, William, of Okehampton, Devon, gent 0
4155778 2080101 2080101 defendant Cornewe William gent 596015 596015 Cornewe, William, of Okehampton, Devon, gent 2
4231602 2106554 2106554 defendant Newcombe Thomas yeoman 596015 596015 Newcombe, Thomas, of Okehampton, Devon, yeoman 0
4237173 2108587 2108587 defendant Kennecott or Kynnacott Thomas   596015 596015 Kennecott or Kynnacott, Thomas, of Okehampton, Devon, yeoman, son of Richard 2
4239331 2109375 2109375 defendant Kennecott Thomas husbandman 596015 596015 Kennecott, Thomas, of Okehampton, Devon, husbandman 1
4240564 2109826 2109826 defendant Newcombe Thomas yeoman 596015 596015 Newcombe, Thomas, of Okehampton, Devon, yeoman 0
4247744 2112228 2112228 defendant Kennacott Thomas husbandman 596015 596015 Kennacott, Thomas, of Okehampton, Devon, husbandman 1
4331485 2140827 2140827 defendant Westlack John yeoman 596015 596015 Westlack, John, of Okehampton, Devon, yeoman 3
4331491 2140828 2140828 defendant Darbye alias Borough John yeoman 596015 596015 Darbye alias Borough, John, of Okehampton, Devon, yeoman 4
4353075 2148303 2148303 defendant Drewe Henry yeoman 596015 596015 Drewe, Henry, of Okehampton, Devon, yeoman 0
4383343 2159140 2159140 defendant Bowdon William yeoman 596015 596015 Bowdon, William, of Okehampton, Devon, yeoman 1
4391813 2161886 2161886 defendant Deyman Roger innholder 596015 596015 Deyman, Roger, of Okehampton, Devon, innholder 0
4391847 2161898 2161898 defendant Deyman Roger innholder 596015 596015 Deyman, Roger, of Okehampton, Devon, innholder 0
4403393 2165701 2165701 defendant Kynsman Leonard yeoman 596015 596015 Kynsman, Leonard, of Okehampton, Devon, yeoman 0
4985295 2352523 2352523 defendant Berne John chapman 596015 596015 Berne, John, of Okehampton, Devon, chapman 0
5164098 2405232 2405232 defendant Lytelwyke William   596015 596015 Lytelwyke, William, of Okehampton, Devon, "marchdon" 0
5177475 2409104 2409104 defendant Lytelwyke William merchant 596015 596015 Lytelwyke, William, of Okehampton, Devon, merchant 0
5225830 2423227 2423227 defendant Wylle John chaplain 596015 596015 Wylle, John, of Okehampton, Devon, chaplain 0
5246950 2429273 2429273 defendant Wylle John chaplain 596015 596015 Wylle, John, of Okehampton, Devon, chaplain 0
5300538 2445126 2445126 defendant Rattonbury Richard husbandman 596015 596015 Rattonbury, Richard, of Okehampton, Devon, husbandman 0
5300579 2445135 2445135 defendant Rattenbury Richard husbandman 596015 596015 Rattenbury, Richard, of Okehampton, Devon, husbandman 0
5456169 2491763 2491763 defendant Kyghley John gent 596015 596015 (Kyghley, John, of Okehampton, Devon, gent 2
5479177 2498793 2498793 defendant Kyghley John gent 596015 596015 (Kyghley, John, of Okehampton, Devon, gent 2
5479183 2498794 2498794 defendant Hyghly John gent 596015 596015 (Hyghly, John, of Okehampton, Devon, gent 4
5490446 2502037 2502037 defendant Toker Nicholas yeoman 596015 596015 Toker, Nicholas, of Okehampton, Devon, yeoman 3
5530416 2514029 2514029 defendant Escote Robert yeoman 596015 596015 Escote, Robert, of Okehampton, Devon, yeoman 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);