names

34 rows where place_id = 770457

✎ 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
4568047 2221572 2221572 defendant Bouclerk John   770457 770457 Bouclerk, John, of Oakhampton 0
4707217 2267637 2267637 defendant Grymell William chapman 770457 770457 Grymell, William, of Oakhampton, chapman 0
4736913 2276673 2276673 defendant Gascoigne Christine widow 770457 770457 Gascoigne, Christine, of Oakhampton, widow 0
4738469 2277123 2277123 defendant Breghe John tanner 770457 770457 Breghe, John, of Oakhampton, tanner 1
4738473 2277124 2277124 defendant Breghe John tanner 770457 770457 Breghe, John, of Oakhampton, tanner 1
4771230 2286985 2286985 defendant Rowedon Richard husbandman 770457 770457 Rowedon, Richard, of Oakhampton, husbandman 0
4771814 2287161 2287161 defendant Hauk John   770457 770457 Hauk, John, of Oakhampton, tin miner 2
4775177 2288231 2288231 defendant Bregh John tanner 770457 770457 Bregh, John, of Oakhampton, tanner 2
4834746 2306867 2306867 defendant Drohghe John tanner 770457 770457 Drohghe, John, of Oakhampton, tanner 0
4835296 2307037 2307037 defendant Canne Richard weaver 770457 770457 Canne, Richard, of Oakhampton, weaver 2
4840793 2308658 2308658 defendant Northcote John butcher 770457 770457 Northcote, John, of Oakhampton, butcher 0
4840794 2308658 2308658 defendant Estecote William tanner 770457 770457 Estecote, William, of Oakhampton, tanner 1
4840795 2308658 2308658 defendant Lemman Walter   770457 770457 Lemman, Walter, of Oakhampton, shoe maker 2
4840796 2308658 2308658 defendant Smyth John smith 770457 770457 Smyth, John, of Oakhampton, smith 3
4840798 2308659 2308659 defendant Northcote John butcher 770457 770457 Northcote, John, of Oakhampton, butcher 0
4841209 2308789 2308789 defendant Estecote William tanner 770457 770457 Estecote, William, of Oakhampton, tanner 0
4841235 2308796 2308796 defendant Estecote William tanner 770457 770457 Estecote, William, of Oakhampton, tanner 0
4851024 2311770 2311770 plaintiff Touker Henry   770457 770457 Touker, Henry, of Oakhampton 0
4851026 2311771 2311771 plaintiff Touker Henry   770457 770457 Touker, Henry, of Oakhampton 0
4997825 2356206 2356206 defendant Valance Robert tinker 770457 770457 Valance, Robert, of Oakhampton, tinker 0
4999036 2356591 2356591 defendant Canne Nicholas ostler 770457 770457 Canne, Nicholas, of Oakhampton, ostler 0
4999037 2356591 2356591 defendant Canne Richard weaver 770457 770457 together with Canne, Richard, of Oakhampton, weaver 1
5004082 2358081 2358081 defendant Reynell John skinner 770457 770457 Reynell, John, of Oakhampton, skinner 0
5005024 2358368 2358368 defendant Juyll or Inyll Richard carpenter 770457 770457 Juyll or Inyll, Richard, of Oakhampton, carpenter 0
5009230 2359584 2359584 defendant Hakeworthy Walter husbandman 770457 770457 Hakeworthy, Walter, of Oakhampton, husbandman 0
5155213 2402673 2402673 defendant Estcote William tanner 770457 770457 Estcote, William, of Oakhampton, tanner 0
5177016 2408971 2408971 defendant Horewyll Nicholas husbandman 770457 770457 Horewyll, Nicholas, of Oakhampton, husbandman 0
5185478 2411501 2411501 defendant Lytelwyke William   770457 770457 Lytelwyke, William, of Oakhampton 0
5207060 2417801 2417801 defendant Estcote William tanner 770457 770457 Estcote, William, of Oakhampton, tanner 0
5207501 2417936 2417936 plaintiff More Joan a   770457 770457 More, Joan a, of Oakhampton 1
5207504 2417937 2417937 plaintiff More Joan a   770457 770457 More, Joan a, of Oakhampton 1
5207507 2417938 2417938 plaintiff More John a (legal representative) 770457 770457 More, John a, of Oakhampton, park man, administratrix of 0
5301861 2445512 2445512 defendant Rysedon Richard ostler 770457 770457 Rysedon, Richard, of Oakhampton, ostler 0
5301862 2445512 2445512 defendant Shire John shoemaker 770457 770457 Shire, John, of Oakhampton, shoemaker 1

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