names

30 rows where place_id = 595360

✎ 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
3620164 1873884 1873884 defendant Throwyston Richard husbandman 595360 595360 Throwyston, Richard, of Chageford, husbandman 0
3947604 2006225 2006225 defendant Cornew William gent 595360 595360 Cornew, William, of Chageford, gent 0
4416774 2170114 2170114 defendant Taverner Reginald   595360 595360 Taverner, Reginald, of Chageford 3
4435548 2175878 2175878 plaintiff Monck Richard   595360 595360 Monck, Richard, of Chageford 1
4491116 2197911 2197911 defendant Ware William clerk 595360 595360 Ware, William, of Chageford, clerk 0
4659468 2248820 2248820 defendant Wybbury John esq 595360 595360 Wybbury, John, of Chageford, esq 0
4699610 2265329 2265329 defendant Synge Thomas jouter or hawker 595360 595360 Synge, Thomas, of Chageford, jouter or hawker 0
4786540 2291840 2291840 defendant Jurdeston John husbandman 595360 595360 Jurdeston, John, of Chageford, husbandman 2
4795600 2294774 2294774 defendant Newecomb Thomas laborer 595360 595360 Newecomb, Thomas, of Chageford, laborer 0
4926075 2334585 2334585 plaintiff Prous John   595360 595360 Prous, John, of Chageford 0
4927984 2335184 2335184 defendant Rogge John weaver 595360 595360 Rogge, John, of Chageford, weaver 0
4927986 2335184 2335184 defendant Westcote John weaver 595360 595360 Westcote, John, of Chageford, weaver 2
4962990 2345845 2345845 defendant Caselegh Simon   595360 595360 Caselegh, Simon, of Chageford, bailiff 2
4982904 2351797 2351797 defendant Caselegh Simon husbandman 595360 595360 Caselegh, Simon, of Chageford, husbandman 0
4982906 2351798 2351798 defendant Caselegh Simon husbandman 595360 595360 Caselegh, Simon, of Chageford, husbandman 0
5016048 2361577 2361577 defendant Caselegh Simon   595360 595360 Caselegh, Simon, of Chageford, bailiff 0
5021517 2363195 2363195 defendant Caselegh Simon   595360 595360 Caselegh, Simon, of Chageford, bailiff 0
5103089 2387326 2387326 defendant Bevyll William husbandman 595360 595360 Bevyll, William, of Chageford, husbandman 11
5139638 2398069 2398069 defendant Aysshe John, junior gent 595360 595360 Aysshe, John, junior, of Chageford, gent 0
5139639 2398069 2398069 defendant Aysshe William husbandman 595360 595360 Aysshe, William, of Chageford, husbandman 1
5139640 2398069 2398069 defendant Hilman John husbandman 595360 595360 Hilman, John, of chageford, husbandman 2
5139641 2398069 2398069 defendant Wille William laborer 595360 595360 Wille, William, of Chageford, laborer 3
5139642 2398069 2398069 defendant Comyng William laborer 595360 595360 Comyng, William, of Chageford, laborer 4
5139654 2398073 2398073 defendant Ebbesworthy John   595360 595360 Ebbesworthy, John, of Chageford 0
5238443 2426833 2426833 defendant Seward John husbandman 595360 595360 Seward, John, of Chageford, husbandman 0
5378399 2468824 2468824 defendant Hylman Henry yeoman 595360 595360 Hylman, Henry, of Chageford, yeoman 0
5507446 2507224 2507224 defendant Fanell or Favell Stephen, junior husbandman 595360 595360 Fanell or Favell, Stephen, junior, of Chageford, husbandman 1
5507448 2507224 2507224 defendant Rede William smith 595360 595360 Rede, William, of Chageford, smith 3
5632476 2554194 2554194 defendant Dyer Richard smith 595360 595360 Dyer, Richard, of Chageford, smith 1
5632477 2554194 2554194 defendant Hurtyston William smith 595360 595360 Hurtyston, William, of Chageford, smith 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);