names

35 rows where case_id = 2422731

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5224111 2422731 2422731 plaintiff Pierpoynt Henry esq   Pierpoynt, Henry, esq 0
5224112 2422731 2422731 defendant Courtnay John   642255 642255 Courtnay, John, of Tyverton, Devon, knight 0
5224113 2422731 2422731 defendant Fulford Thomas   709911 709911 Fulford, Thomas, of Fulford, Devon, knight 1
5224114 2422731 2422731 defendant Webber John parson of Godelegh, Devon   Webber, John, parson of Godelegh, Devon 2
5224115 2422731 2422731 defendant Wixe Richard parson of Courtnay Sampford, Devon   Wixe, Richard, parson of Courtnay Sampford, Devon 3
5224116 2422731 2422731 defendant Westcot Peter yeoman 846576 846576 Westcot, Peter, of Chepyng Tauton, Devon, yeoman 4
5224117 2422731 2422731 defendant Tyrnour John armorer 588557 588557 Tyrnour, John, of Tyverton, armorer 5
5224118 2422731 2422731 defendant Calwodelegh John yeoman 588557 588557 Calwodelegh, John, of Tyverton, yeoman 6
5224119 2422731 2422731 defendant Calwodelegh Robert   588557 588557 Calwodelegh, Robert, of Tyverton, groom 7
5224120 2422731 2422731 defendant Noel Richard yeoman 588557 588557 Noel, Richard, of Tyverton, yeoman 8
5224121 2422731 2422731 defendant Stile John fuller 588557 588557 Stile, John, of Tyverton, fuller 9
5224122 2422731 2422731 defendant Hewe John fuller 588557 588557 Hewe, John, of Tyverton, fuller 10
5224123 2422731 2422731 defendant Holewyll John yeoman 588557 588557 Holewyll, John, of Tyverton, yeoman 11
5224124 2422731 2422731 defendant Cayleway John esq 861206 861206 Cayleway, John, of Chayneston, Devon, esq 12
5224125 2422731 2422731 defendant Cayleway William gent 861207 861207 Cayleway, William, of Chayneston, gent 13
5224126 2422731 2422731 defendant Dobbe John gent 669641 669641 Dobbe, John, of Chulmelegh, Devon, gent 14
5224127 2422731 2422731 defendant Crowde John yeoman 588557 588557 Crowde, John, of Tyverton, yeoman 15
5224128 2422731 2422731 defendant Swannesby John gent 588557 588557 Swannesby, John, of Tyverton, gent 16
5224129 2422731 2422731 defendant Lichefeld William   588557 588557 Lichefeld, William, of Tyverton, freemason 17
5224130 2422731 2422731 defendant Baly John bookbinder 588557 588557 Baly, John, of Tyverton, bookbinder 18
5224131 2422731 2422731 defendant Vawetard Thomas husbandman 588557 588557 Vawetard, Thomas, of Tyverton, husbandman 19
5224132 2422731 2422731 defendant Prous John cooper 588557 588557 Prous, John, of Tyverton, cooper 20
5224133 2422731 2422731 defendant Rokley John yeoman 588557 588557 Rokley, John, of Tyverton, yeoman 21
5224134 2422731 2422731 defendant Hawardeyn Thomas yeoman 861209 861209 Hawardeyn, Thomas, of Lowestok, Wilts, yeoman 22
5224135 2422731 2422731 defendant Lange William yeoman 588557 588557 Lange, William, of Tyverton, yeoman 23
5224136 2422731 2422731 defendant Vawetard John yeoman 588557 588557 Vawetard, John, of Tyverton, yeoman 24
5224137 2422731 2422731 defendant Atkyn Henry yeoman 588557 588557 Atkyn, Henry, of Tyverton, yeoman 25
5224138 2422731 2422731 defendant Joce John shoemaker 861210 861210 Joce, John, of Samford Peverell, Devon, shoemaker 26
5224139 2422731 2422731 defendant Holmes Thomas tailor 588557 588557 Holmes, Thomas, of Tyverton, tailor 27
5224140 2422731 2422731 defendant Broghton William gent 861211 861211 Broghton, William, of Malverton, Soms, gent 28
5224141 2422731 2422731 defendant Torner Robert   588557 588557 Torner, Robert, of Tyverton, "furbour" 29
5224142 2422731 2422731 defendant Hodde John   588557 588557 Hodde, John, of Tyverton, groom 30
5224143 2422731 2422731 defendant Whubet John   588557 588557 Whubet, John, of Tyverton, groom 31
5224144 2422731 2422731 defendant Layne William yeoman 588557 588557 Layne, William, of Tyverton, yeoman 32
5224145 2422731 2422731 defendant Warwyk William   588557 588557 Warwyk, William, of Tyverton, groom 33

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