names

42 rows where place_id = 612045

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3691295 1923436 1923436 defendant Denyer Thomas husbandman 612045 612045 Denyer, Thomas, of Godalmynge, husbandman 1
4116596 2066226 2066226 defendant Wells Thomas yeoman 612045 612045 Wells, Thomas, of Godalmynge, yeoman 0
4149063 2077794 2077794 defendant Brayden Stephen husbandman 612045 612045 Brayden, Stephen, of Godalmynge, husbandman 0
4158617 2081087 2081087 defendant Warnar John weaver 612045 612045 Warnar, John, of Godalmynge, weaver 0
4167911 2084263 2084263 defendant Plonker or Plouker Robert clothier 612045 612045 Plonker or Plouker, Robert, of Godalmynge, clothier 0
4180748 2088747 2088747 defendant Chyttye alias Butcher John clothier 612045 612045 Chyttye alias Butcher, John, of Godalmynge, clothier 0
4182763 2089450 2089450 defendant Dennyer John weaver 612045 612045 Dennyer, John, of Godalmynge, weaver 0
4182764 2089450 2089450 defendant Mackerell Robert clothier 612045 612045 Mackerell, Robert, of Godalmynge, clothier 1
4184844 2090208 2090208 defendant Wylson William tailor 612045 612045 Wylson, William, of Godalmynge, tailor 2
4185320 2090376 2090376 defendant Bridger Robert yeoman 612045 612045 Bridger, Robert, of Godalmynge, yeoman 0
4226856 2104866 2104866 defendant Carpynter Richard weaver 612045 612045 Carpynter, Richard, of Godalmynge, weaver 0
4226858 2104867 2104867 defendant Carpynter Richard weaver 612045 612045 Carpynter, Richard, of Godalmynge, weaver 0
4233063 2107072 2107072 defendant Inwood Arnold sherman 612045 612045 Inwood, Arnold, of Godalmynge, sherman 0
4233221 2107129 2107129 defendant Inwood Arnold sherman 612045 612045 Inwood, Arnold, of Godalmynge, sherman 0
4233578 2107264 2107264 defendant Smyther John husbandman 612045 612045 Smyther, John, of Godalmynge, husbandman 0
4233580 2107265 2107265 defendant Smyther John husbandman 612045 612045 Smyther, John, of Godalmynge, husbandman 0
4234221 2107505 2107505 defendant Bysbridge John yeoman 612045 612045 Bysbridge, John, of Godalmynge, yeoman 1
4236746 2108427 2108427 defendant Haman Henry sherman 612045 612045 Haman, Henry, of Godalmynge, sherman 1
4237321 2108642 2108642 defendant Charman Francis smith 612045 612045 Charman, Francis, of Godalmynge, smith 1
4241700 2110210 2110210 defendant Inwood Arnold sherman 612045 612045 Inwood, Arnold, of Godalmynge, sherman 0
4281220 2123340 2123340 defendant Bradfelde John Surrey, clothier 612045 612045 Bradfelde John, of Godalmynge, Surrey, clothier 0
4283678 2124200 2124200 defendant Bridger John innholder 612045 612045 Bridger, John, of Godalmynge, innholder 0
4283679 2124200 2124200 defendant Chitty John sherman 612045 612045 Chitty, John, of Godalmynge, sherman 1
4285164 2124744 2124744 defendant Inwood John clothier 612045 612045 Inwood, John, of Godalmynge, clothier 0
4285165 2124744 2124744 defendant Miles Nicholas tailor 612045 612045 Miles, Nicholas, of Godalmynge, tailor 1
4288471 2125925 2125925 defendant Mackrith or Mackryll Richard clothier 612045 612045 Mackrith or Mackryll, Richard, of Godalmynge, clothier 0
4288473 2125925 2125925 defendant Chaundler Richard clothier 612045 612045 Chaundler, Richard, of Godalmynge, clothier 2
4310989 2133990 2133990 defendant Bradfolde John clothier 612045 612045 Bradfolde, John, of Godalmynge, clothier 0
4323175 2138165 2138165 defendant Howke William clothier 612045 612045 Howke, William, of Godalmynge, clothier 0
4366325 2152996 2152996 defendant Cowper Thomas   612045 612045 Cowper, Thomas, of Godalmynge, gent, administrstor of 0
4369963 2154312 2154312 defendant Carpenter Richard clothier 612045 612045 Carpenter, Richard, of Godalmynge, clothier 0
4372533 2155246 2155246 defendant Cowdrey John clothier 612045 612045 Cowdrey, John, of Godalmynge, clothier 0
4373322 2155524 2155524 defendant Dymes William yeoman 612045 612045 Dymes, William, of Godalmynge, yeoman 1
4373323 2155524 2155524 defendant Nutley John laborer 612045 612045 Nutley, John, of Godalmynge, laborer 2
4373324 2155524 2155524 defendant Warner alias Marlin David laborer 612045 612045 Warner, alias Marlin David, of Godalmynge, laborer 3
4401416 2165068 2165068 defendant Dymes William yeoman 612045 612045 Dymes, William, of Godalmynge, yeoman 1
4401417 2165068 2165068 defendant Nutley John laborer 612045 612045 Nutley, John, of Godalmynge, laborer 2
4401418 2165068 2165068 defendant Warner alias Marlyn David laborer 612045 612045 Warner alias Marlyn, David, of Godalmynge, laborer 3
4444498 2183260 2183260 defendant Fourner Thomas   612045 612045 Fourner, Thomas, of Godalmynge 0
4444502 2183262 2183262 defendant Westwode John   612045 612045 Westwode, John, of Godalmynge 0
4450099 2184988 2184988 defendant Monstede Richard   612045 612045 Monstede, Richard, of Godalmynge 1
4732709 2275410 2275410 defendant Compton John butcher 612045 612045 Compton, John, of Godalmynge, butcher 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);