names

33 rows where place_id = 612630

✎ 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
3694264 1924408 1924408 defendant Burton Thomas miller or brewer 612630 612630 Burton, Thomas, of Trowse, miller or brewer 0
3963876 2011969 2011969 defendant Reynolde Thomas tailor 612630 612630 Reynolde, Thomas, of Trowse, tailor 0
3984634 2019263 2019263 plaintiff Tesmond Thomas glover 612630 612630 Tesmond, Thomas, of Trowse, glover 0
4007966 2027610 2027610 defendant Howlyng William yeoman 612630 612630 Howlyng, William, of Trowse, yeoman 0
4007967 2027610 2027610 defendant Spynsby Henry   612630 612630 Spynsby, Henry, of Trowse, ploughwright 1
4013408 2029529 2029529 defendant Reade Leonard   612630 612630 Reade, Leonard, of Trowse, "kalendrer" 0
4013652 2029619 2029619 defendant Raynold Thomas husbandman 612630 612630 Raynold, Thomas, of Trowse, husbandman 3
4068983 2049195 2049195 plaintiff Lathe John beer brewer 612630 612630 Lathe John, of Trowse, beer brewer 0
4070637 2049794 2049794 defendant Howlyng William yeoman 612630 612630 Howlyng, William, of Trowse, yeoman 0
4075960 2051698 2051698 defendant Raynold Robert, senior husbandman 612630 612630 Raynold, Robert, senior, of Trowse, husbandman 7
4098377 2059746 2059746 defendant Lathe John glasier 612630 612630 Lathe, John, of Trowse, glasier 0
4113580 2065135 2065135 defendant Fayerclyff Robert beer brewer 612630 612630 Fayerclyff, Robert, of Trowse, beer brewer 0
4113587 2065138 2065138 defendant Lathe John glasier 612630 612630 Lathe, John, of Trowse, glasier 0
4124769 2069153 2069153 defendant Reynold John tailor 612630 612630 Reynold, John, of Trowse, tailor 1
4139635 2074539 2074539 defendant Howlyng Robert   612630 612630 Howlyng, Robert, of Trowse, lime burner 0
4148380 2077564 2077564 defendant Howlynge William yeoman 612630 612630 Howlynge, William, of Trowse, yeoman 0
4172959 2085995 2085995 defendant Faierclyff Robert beer brewer 612630 612630 Faierclyff, Robert, of Trowse, beer brewer 0
4209942 2099040 2099040 defendant Dey Richard butcher 612630 612630 Dey, Richard, of Trowse, butcher 0
4227362 2105051 2105051 defendant Raynold John tailor 612630 612630 Raynold, John, of Trowse, tailor 3
4227367 2105052 2105052 defendant Raynold John tailor 612630 612630 Raynold, John, of Trowse, tailor 3
4230872 2106295 2106295 defendant Howling William, senior hasbandman 612630 612630 Howling, William, senior, of Trowse, hasbandman 1
4243438 2110797 2110797 defendant Jenkenson John yeoman 612630 612630 Jenkenson, John, of Trowse, yeoman 2
4243442 2110798 2110798 defendant Jenkenson John yeoman 612630 612630 Jenkenson, John, of Trowse, yeoman 2
4253787 2114259 2114259 defendant Jenkenson John yeoman 612630 612630 Jenkenson, John, of Trowse, yeoman 4
4256600 2115178 2115178 defendant Howlyng William yeoman 612630 612630 Howlyng, William, of Trowse, yeoman 0
4256601 2115178 2115178 defendant Howlyng Robert husbandman 612630 612630 Howlyng, Robert, of Trowse, husbandman 1
4261933 2116941 2116941 defendant Tesmond Thomas glover 612630 612630 Tesmond, Thomas, of Trowse, glover 3
4316508 2135891 2135891 defendant Sporle Nicholas laborer 612630 612630 Sporle, Nicholas, of Trowse, laborer 3
4330034 2140348 2140348 defendant Dixon Henry blacksmith 612630 612630 Dixon, Henry, of Trowse, blacksmith 0
4345238 2145612 2145612 defendant Read William blacksmith 612630 612630 Read, William, of Trowse, blacksmith 0
4389292 2161046 2161046 defendant Reynold John tailor 612630 612630 Reynold, John, of Trowse, tailor 0
4389293 2161046 2161046 defendant Howling Robert limeburner 612630 612630 Howling, Robert, of Trowse, limeburner 1
4389294 2161046 2161046 defendant Kyberd or Kybern Agnes spinster 612630 612630 Kyberd or Kybern, Agnes, of Trowse, spinster 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);