names

41 rows where place_id = 587163

✎ 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
3590637 1864714 1864714 defendant Robyn James yeoman 587163 587163 Robyn, James, of Dodbroke, yeoman 1
3598337 1867108 1867108 defendant Hengeston Thomas husbandman 587163 587163 Hengeston, Thomas, of Dodbroke Maner, husbandman 0
3646561 1909325 1909325 defendant Kent Henry carpenter 587163 587163 Kent, Henry, of Dodbroke, carpenter 1
3646861 1909416 1909416 defendant Tewsyn Robert smith 587163 587163 Tewsyn, Robert, of Dodbroke, smith 7
3675098 1918243 1918243 defendant Crympe Richard tanner 587163 587163 Crympe, Richard, of Dodbroke, tanner 1
3675099 1918243 1918243 defendant Brice Richard weaver 587163 587163 Brice, Richard, of Dodbroke, weaver 2
3675100 1918243 1918243 defendant Weve or Wene Robert   587163 587163 Weve or Wene, Robert, of Dodbroke, groom 3
3675101 1918243 1918243 defendant Smyth Robert laborer 587163 587163 Smyth, Robert, of Dodbroke, laborer 4
3692157 1923715 1923715 defendant Krympe Richard tanner 587163 587163 Krympe, Richard, of Dodbroke, tanner 7
3733389 1936678 1936678 defendant Abbott John glover 587163 587163 Abbott, John, of Dodbroke, glover 1
3733390 1936678 1936678 defendant Salter John laborer 587163 587163 Salter, John, of Dodbroke, laborer 2
3802835 1958781 1958781 defendant Valys John smith 587163 587163 Valys, John, of Dodbroke, smith 0
3822656 1964990 1964990 defendant Upton Nicholas gent 587163 587163 Upton, Nicholas, of Dodbroke, gent 0
3960436 2010748 2010748 defendant Dunnyng John tinker 587163 587163 Dunnyng, John, of Dodbroke, tinker 0
3960437 2010748 2010748 defendant Stabbe James smith 587163 587163 Stabbe, James, of Dodbroke, smith 1
3974472 2015647 2015647 defendant Byckeforde John smith 587163 587163 Byckeforde, John, of Dodbroke, smith 0
4004111 2026242 2026242 defendant Byckeforde John smith 587163 587163 Byckeforde, John, of Dodbroke, smith 0
4013569 2029588 2029588 defendant Chubbe John yeoman 587163 587163 Chubbe, John, of Dodbroke, yeoman 0
4246138 2111687 2111687 plaintiff Payne John   587163 587163 Payne, John, of Dodbroke Devon, whittawer, administrators of 0
4596721 2230214 2230214 defendant Bradlegh John   587163 587163 Bradlegh, John, of Dodbroke 0
4669062 2256029 2256029 defendant Combe Robert husbandman 587163 587163 Combe, Robert, of Dodbroke, husbandman 1
4669068 2256031 2256031 defendant Combe Robert husbandman 587163 587163 with Combe, Robert, of Dodbroke, husbandman 1
4720660 2271795 2271795 defendant Johan John   587163 587163 Johan, John, of Dodbroke, millward 0
4768152 2286011 2286011 defendant Gylle John gent 587163 587163 Gylle, John, of Dodbroke, gent 2
4946844 2341019 2341019 defendant Coyte William husbandman 587163 587163 Coyte, William, of Dodbroke, husbandman 0
4946846 2341020 2341020 defendant Davy Thomas, senior husbandman 587163 587163 Davy, Thomas, senior, of Dodbroke, husbandman 0
4946847 2341020 2341020 defendant Davy Thomas, junior laborer 587163 587163 Davy, Thomas, junior, of Dodbroke, laborer 1
4946848 2341020 2341020 defendant Coyte William husbandman 587163 587163 together with Coyte, William, of Dodbroke, husbandman 2
4968833 2347646 2347646 defendant Bradelegh John merchant 587163 587163 Bradelegh, John, of Dodbroke, merchant 2
5144395 2399517 2399517 defendant Champernon William esq 587163 587163 together with Champernon, William, of Dodbroke, esq 1
5179126 2409627 2409627 defendant Champernon William esq 587163 587163 together with Champernon, William, of Dodbroke, esq 1
5180173 2409943 2409943 defendant Champernoun William esq 587163 587163 Champernoun, William, of Dodbroke, esq 0
5180176 2409944 2409944 defendant Champernoun William esq 587163 587163 Champernoun, William, of Dodbroke, esq 0
5201767 2416282 2416282 defendant Champernon William esq 587163 587163 together with Champernon, William, of Dodbroke, esq 1
5202281 2416431 2416431 defendant Champernoun William esq 587163 587163 Champernoun, William, of Dodbroke, esq 0
5202284 2416432 2416432 defendant Champernoun William esq 587163 587163 Champernoun, William, of Dodbroke, esq 0
5232619 2425121 2425121 defendant Lovenay Thomas   587163 587163 Lovenay, Thomas, of Dodbroke, franklin 0
5233399 2425358 2425358 defendant Carsewill John mercer 587163 587163 Carsewill, John, of Dodbroke, mercer 5
5585477 2530525 2530525 defendant Broun Pascas husbandman 587163 587163 Broun, Pascas, of Dodbroke, husbandman 2
5585481 2530526 2530526 defendant Broun Pascas husbandman 587163 587163 Broun, Pascas, of Dodbroke, husbandman 2
5585486 2530527 2530527 defendant Broun Pascas husbandman 587163 587163 Broun, Pascas, of Dodbroke, husbandman 3

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