names

93 rows where place_id = 709207

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4177289 2087528 2087528 defendant Dyer John, senior husbandman 709207 709207 Dyer, John, senior, of Ilfardecombe, husbandman 0
4177290 2087528 2087528 defendant Slynner Anthony mariner 709207 709207 Slynner, Anthony, of Ilfardecombe, mariner 1
4193067 2093142 2093142 defendant Hexte Thomas yeoman 709207 709207 Hexte, Thomas, of Ilfardecombe, or of Pembrokeshire, Wales, yeoman 0
4193068 2093142 2093142 defendant Collamore John yeoman 709207 709207 Collamore, John, of Ilfardecombe, yeoman 1
4200902 2095872 2095872 defendant Collamore John, junior yeoman 709207 709207 Collamore, John, junior, of Ilfardecombe, yeoman 1
4200903 2095872 2095872 defendant Collamore John, senior yeoman 709207 709207 Collamore, John, senior, of Ilfardecombe, yeoman 2
4468963 2190969 2190969 defendant Haukyn Richard   709207 709207 Haukyn, Richard, of Ilfardecombe 3
4667947 2255678 2255678 defendant Genet John fisher 709207 709207 Genet, John, of Ilfardecombe, fisher 0
4668279 2255793 2255793 defendant Sotter Peter butcher 709207 709207 Sotter, Peter, of Ilfardecombe, butcher 0
4668282 2255793 2255793 defendant Mepper John husbandman 709207 709207 Mepper, John, of Ilfardecombe, husbandman 3
4668283 2255793 2255793 defendant Hille David shipman 709207 709207 Hille, David, of Ilfardecombe, shipman 4
4668284 2255793 2255793 defendant Sampson John shipman 709207 709207 Sampson, John, of Ilfardecombe, shipman 5
4790815 2293216 2293216 defendant James John merchant 709207 709207 James, John, of Ilfardecombe, merchant 0
4800351 2296290 2296290 defendant Samon John husbandman 709207 709207 Samon, John, of Ilfardecombe, husbandman 0
4807257 2298470 2298470 defendant Elys Robert husbandman 709207 709207 Elys, Robert, of Ilfardecombe, husbandman 1
4817018 2301422 2301422 defendant Wille William fuller 709207 709207 Wille, William, of Ilfardecombe, fuller 0
4877629 2319963 2319963 defendant Davy Richard baker 709207 709207 Davy, Richard, of Ilfardecombe, baker 0
4877630 2319963 2319963 defendant Riche David shipman 709207 709207 Riche, David, of Ilfardecombe, shipman 1
4877632 2319964 2319964 defendant Davy Richard baker 709207 709207 Davy, Richard, of Ilfardecombe, baker 0
4877633 2319964 2319964 defendant Roche David shipman 709207 709207 Roche, David, of Ilfardecombe, shipman 1
4881990 2321266 2321266 defendant Quyk Philip tailor 709207 709207 Quyk, Philip, of Ilfardecombe, tailor 0
4913719 2330790 2330790 defendant Buttyngcombe John tanner 709207 709207 Buttyngcombe, John, of Ilfardecombe, tanner 1
4950805 2342225 2342225 defendant Brounyng Thomas merchant 709207 709207 Brounyng, Thomas, of Ilfardecombe, merchant 0
4964579 2346311 2346311 defendant Blake Thomas shipman 709207 709207 together with Blake, Thomas, of Ilfardecombe, shipman 7
4978157 2350432 2350432 defendant Langelegh Walter gent 709207 709207 Langelegh, Walter, of Ilfardecombe, gent 0
4978158 2350432 2350432 defendant Gadlyng John butcher 709207 709207 Gadlyng, John, of Ilfardecombe, butcher 1
4978159 2350432 2350432 defendant Blake Thomas merchant 709207 709207 Blake, Thomas, of Ilfardecombe, merchant 2
4978160 2350432 2350432 defendant Wyke Ancelm seaman 709207 709207 Wyke, Ancelm, of Ilfardecombe, seaman 3
4978161 2350432 2350432 defendant Penryse Richard gent 709207 709207 Penryse, Richard, of Ilfardecombe, gent 4
4978162 2350432 2350432 defendant Dyer Thomas yeoman 709207 709207 Dyer, Thomas, of Ilfardecombe, yeoman 5
4978163 2350432 2350432 defendant Bealle Robert laborer 709207 709207 Bealle, Robert, of Ilfardecombe, laborer 6
4978164 2350432 2350432 defendant Brydde Walter seaman 709207 709207 Brydde, Walter, of Ilfardecombe, seaman 7
4978165 2350432 2350432 defendant Gubbe John, junior seaman 709207 709207 Gubbe, John, junior, of Ilfardecombe, seaman 8
4978166 2350432 2350432 defendant Dyryke John shipman 709207 709207 Dyryke, John, of Ilfardecombe, shipman 9
4978167 2350432 2350432 defendant Godelyng John butcher 709207 709207 Godelyng, John, of Ilfardecombe, butcher 10
4978168 2350432 2350432 defendant Fosse Richard husbandman 709207 709207 Fosse, Richard, of Ilfardecombe, husbandman 11
4978169 2350432 2350432 defendant Bounte Richard seaman 709207 709207 Bounte, Richard, of Ilfardecombe, seaman 12
4978170 2350432 2350432 defendant Hoper John seaman 709207 709207 Hoper, John, of Ilfardecombe, seaman 13
4978171 2350432 2350432 defendant Frensheman Adam   709207 709207 Frensheman, Adam, of Ilfardecombe, groom 14
4978172 2350432 2350432 defendant Auncell Thomas seaman 709207 709207 Auncell, Thomas, of Ilfardecombe, seaman 15
4978174 2350432 2350432 defendant Bawle Thomas husbandman 709207 709207 Bawle, Thomas, of Ilfardecombe, husbandman 17
4978175 2350432 2350432 defendant Bayne John weaver 709207 709207 Bayne, John, of Ilfardecombe, weaver 18
4978176 2350432 2350432 defendant Rowe Thomas shipman 709207 709207 Rowe, Thomas, of Ilfardecombe, shipman 19
4978177 2350432 2350432 defendant Rokebeare John butcher 709207 709207 Rokebeare, John, of Ilfardecombe, butcher 20
4978178 2350432 2350432 defendant Pytman Henry weaver 709207 709207 Pytman, Henry, of Ilfardecombe, weaver 21
4978179 2350432 2350432 defendant Dyer John husbandman 709207 709207 Dyer, John, of Ilfardecombe, husbandman 22
4978180 2350432 2350432 defendant Colyford John, senior husbandman 709207 709207 Colyford, John, senior, of Ilfardecombe, husbandman 23
4978181 2350432 2350432 defendant Duke Thomas weaver 709207 709207 Duke, Thomas, of Ilfardecombe, weaver 24
4978182 2350432 2350432 defendant Robert Richard, junior laborer 709207 709207 Robert, Richard, junior, of Ilfardecombe, laborer 25
4978183 2350432 2350432 defendant Edward John hooper 709207 709207 Edward John, of Ilfardecombe, hooper 26
4978184 2350432 2350432 defendant Wythere William laborer 709207 709207 Wythere, William, of Ilfardecombe, laborer 27
4978186 2350433 2350433 defendant Langelegh Walter gent 709207 709207 Langelegh, Walter, of Ilfardecombe, gent 0
4978187 2350433 2350433 defendant Cadlyng John butcher 709207 709207 Cadlyng, John, of Ilfardecombe, butcher 1
4978188 2350433 2350433 defendant Blake Thomas merchant 709207 709207 Blake, Thomas, of Ilfardecombe, merchant 2
4978189 2350433 2350433 defendant Wyke Ancel seaman 709207 709207 Wyke, Ancel, of Ilfardecombe, seaman 3
4978190 2350433 2350433 defendant Penryse Richard gent 709207 709207 Penryse, Richard, of Ilfardecombe, gent 4
4978191 2350433 2350433 defendant Dyer Thomas yeoman 709207 709207 Dyer, Thomas, of Ilfardecombe, yeoman 5
4978192 2350433 2350433 defendant Bealle Robert laborer 709207 709207 Bealle, Robert, of Ilfardecombe, laborer 6
4978193 2350433 2350433 defendant Bydde Walter seaman 709207 709207 Bydde, Walter, of Ilfardecombe, seaman 7
4978194 2350433 2350433 defendant Gubbe John, junior seaman 709207 709207 Gubbe, John, junior, of Ilfardecombe, seaman 8
4978195 2350433 2350433 defendant Dyryke John shipman 709207 709207 Dyryke, John, of Ilfardecombe, shipman 9
4978196 2350433 2350433 defendant Gedelyng John butcher 709207 709207 Gedelyng, John, of Ilfardecombe, butcher 10
4978197 2350433 2350433 defendant Fosse Richard husbandman 709207 709207 Fosse, Richard, of Ilfardecombe, husbandman 11
4978198 2350433 2350433 defendant Bounte Richard seaman 709207 709207 Bounte, Richard, of Ilfardecombe, seaman 12
4978199 2350433 2350433 defendant Hoper John seaman 709207 709207 Hoper, John, of Ilfardecombe, seaman 13
4978200 2350433 2350433 defendant Frensheman Adam   709207 709207 Frensheman, Adam, of Ilfardecombe, groom 14
4978201 2350433 2350433 defendant Auncell Thomas seaman 709207 709207 Auncell, Thomas, of Ilfardecombe, seaman 15
4978202 2350433 2350433 defendant Bawle John husbandman 709207 709207 Bawle, John, of Ilfardecombe, husbandman 16
4978203 2350433 2350433 defendant Bawle Thomas husbandman 709207 709207 Bawle, Thomas, of Ilfardecombe, husbandman 17
4978204 2350433 2350433 defendant Bayne John weaver 709207 709207 Bayne, John, of Ilfardecombe, weaver 18
4978205 2350433 2350433 defendant Rowe Thomas shipman 709207 709207 Rowe, Thomas, of Ilfardecombe, shipman 19
4978206 2350433 2350433 defendant Rokeleare John butcher 709207 709207 Rokeleare, John, of Ilfardecombe, butcher 20
4978207 2350433 2350433 defendant Pytman Henry weaver 709207 709207 Pytman, Henry, of Ilfardecombe, weaver 21
4978208 2350433 2350433 defendant Dyer John husbandman 709207 709207 Dyer, John, of Ilfardecombe, husbandman 22
4978209 2350433 2350433 defendant Colyford John, senior husbandman 709207 709207 Colyford, John, senior, of Ilfardecombe, husbandman 23
4978210 2350433 2350433 defendant Duke Thomas weaver 709207 709207 Duke, Thomas, of Ilfardecombe, weaver 24
4978211 2350433 2350433 defendant Robert Richard, junior laborer 709207 709207 Robert, Richard, junior, of Ilfardecombe, laborer 25
4978212 2350433 2350433 defendant Edward John hooper 709207 709207 Edward, John, of Ilfardecombe, hooper 26
4978213 2350433 2350433 defendant Wyther William laborer 709207 709207 Wyther, William, of Ilfardecombe, laborer 27
5062602 2375373 2375373 defendant Hille William weaver 709207 709207 Hille, William, of Ilfardecombe, weaver 0
5086742 2382517 2382517 defendant Hille William weaver 709207 709207 Hille, William, of Ilfardecombe, weaver 0
5086856 2382552 2382552 defendant Brownyng Thomas husbandman 709207 709207 Brownyng, Thomas, of Ilfardecombe, husbandman 1
5110500 2389473 2389473 defendant Gubbe John merchant 709207 709207 Gubbe, John, of Ilfardecombe, merchant 0
5110501 2389473 2389473 defendant Gubbe Thomas roper 709207 709207 Gubbe, Thomas, of Ilfardecombe, roper 1
5232751 2425163 2425163 defendant Olyver Thomas yeoman 709207 709207 Olyver, Thomas, of Ilfardecombe, yeoman 0
5348313 2459613 2459613 defendant Makerell Nicholas shipman 709207 709207 Makerell, Nicholas, of Ilfardecombe, shipman 1
5354351 2461427 2461427 defendant Garlond John gent 709207 709207 Garlond, John, of Ilfardecombe, gent 0
5368463 2465746 2465746 defendant Gobbe Thomas (legal representative) 709207 709207 Gobbe, Thomas, of Ilfardecombe, roper, executor of 0
5370664 2466414 2466414 plaintiff Gyen John (legal representative) 709207 709207 Gyen, John, of Ilfardecombe, merchant, executors of 0
5370696 2466425 2466425 plaintiff Gyon John (legal representative) 709207 709207 Gyon, John, of Ilfardecombe, merchant, executors of 0
5484078 2500172 2500172 plaintiff Hill William merchant 709207 709207 Hill, William, of Ilfardecombe, merchant 2
5484079 2500172 2500172 defendant Atteke Richard merchant 709207 709207 Atteke, Richard, of Ilfardecombe, merchant 0
5486399 2500819 2500819 defendant Eyen or Gyen William merchant 709207 709207 Eyen or Gyen, William, of Ilfardecombe, merchant 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);