names

125 rows where place_id = 596533

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625150 1875400 1875400 defendant Arnold Henry gent 596533 596533 Arnold, Henry, of Gyllyngham, gent 0
3637185 1906430 1906430 defendant Kyng Richard waterman 596533 596533 Kyng, Richard, of Gyllyngham, waterman 0
3638551 1906874 1906874 defendant Mikelbergh John husbandman 596533 596533 Mikelbergh, John, of Gyllyngham, husbandman 3
3640687 1907529 1907529 defendant Brown Roger husbandman 596533 596533 Brown, Roger, of Gyllyngham, husbandman 1
3657519 1912611 1912611 defendant Godfrey William yeoman 596533 596533 Godfrey, William, of Gyllyngham, yeoman 0
3662671 1914243 1914243 defendant Hemgstrige Robert gent 596533 596533 Hemgstrige, Robert, of Gyllyngham, gent 0
3664300 1914786 1914786 defendant Fynche Thomas husbandman 596533 596533 Fynche, Thomas, of Gyllyngham, husbandman 0
3666605 1915496 1915496 defendant Colte Henry tanner 596533 596533 Colte, Henry, of Gyllyngham, tanner 0
3666606 1915496 1915496 defendant Mykylborough John husbandman 596533 596533 Mykylborough, John, of Gyllyngham, husbandman 1
3680782 1920070 1920070 defendant Browne Roger husbandman 596533 596533 Browne, Roger, of Gyllyngham, husbandman 1
3693976 1924318 1924318 defendant Browne Roger husbandman 596533 596533 Browne, Roger, of Gyllyngham, husbandman 2
3712491 1930223 1930223 defendant Wortley Edmund gent 596533 596533 Wortley, Edmund, of Gyllyngham, gent 0
3712492 1930223 1930223 defendant Shorte William yeoman 596533 596533 Shorte, William, of Gyllyngham, yeoman 1
3748002 1941294 1941294 defendant Mansere William yeoman 596533 596533 Mansere, William, of Gyllyngham, yeoman 0
3752802 1942800 1942800 defendant Dyrdowe Robert gent 596533 596533 Dyrdowe, Robert, of Gyllyngham, gent 0
3752803 1942800 1942800 defendant Dyrdowe William gent 596533 596533 Dyrdowe, William, of Gyllyngham, gent 1
3755951 1943813 1943813 defendant Browne Roger husbandman 596533 596533 Browne, Roger, of Gyllyngham, husbandman 0
3769641 1948162 1948162 defendant Dirdowe Robert gent 596533 596533 Dirdowe, Robert, of Gyllyngham, gent 0
3769642 1948162 1948162 defendant Dirdowe William gent 596533 596533 Dirdowe, William, of Gyllyngham, gent 1
3770910 1948588 1948588 defendant Shorte William husbandman 596533 596533 Shorte, William, of Gyllyngham, husbandman 0
3839239 1970201 1970201 defendant Sharlys William yeoman 596533 596533 Sharlys, William, of Gyllyngham, yeoman 1
3848383 1973072 1973072 defendant Cols John butcher 596533 596533 Cols, John, of Gyllyngham, butcher 0
3853244 1974632 1974632 defendant Car George smith 596533 596533 Car, George, of Gyllyngham, smith 0
3857864 1976098 1976098 defendant Porte John yeoman 596533 596533 Porte, John, of Gyllyngham, yeoman 0
3859803 1976779 1976779 defendant Bonor John mariner 596533 596533 Bonor, John, of Gyllyngham, mariner 2
3863026 1977833 1977833 defendant Charvys William yeoman 596533 596533 Charvys, William, of Gyllyngham, yeoman 0
3864046 1978158 1978158 defendant Bollys William butcher 596533 596533 Bollys, William, of Gyllyngham, butcher 0
3867747 1979444 1979444 defendant Carr George smith 596533 596533 Carr, George, of Gyllyngham, smith 0
3879397 1983362 1983362 defendant Chethull John gent 596533 596533 Chethull, John, of Gyllyngham, gent 0
3879398 1983362 1983362 defendant Stone John yeoman 596533 596533 Stone, John, of Gyllyngham, yeoman 1
3890357 1987025 1987025 defendant Wykes William husbandman 596533 596533 Wykes, William, of Gyllyngham, husbandman 0
3893386 1988020 1988020 defendant Browne John laborer 596533 596533 Browne, John, of Gyllyngham, laborer 0
3978384 2017025 2017025 defendant Newman John blacksmith 596533 596533 Newman, John, of Gyllyngham, blacksmith 0
3996719 2023590 2023590 defendant Garrett John husbandman 596533 596533 Garrett, John, of Gyllyngham, husbandman 0
4017820 2031086 2031086 defendant Smale Robert husbandman 596533 596533 Smale, Robert, of Gyllyngham, husbandman 0
4042837 2039914 2039914 plaintiff Peers or Perys John (legal representative) 596533 596533 Peers or Perys, John, of Gyllyngham, executors of 0
4050974 2042792 2042792 defendant Abb Robert yeoman 596533 596533 Abb, Robert, of Gyllyngham, yeoman 0
4060995 2046341 2046341 defendant Newman Peter turner 596533 596533 Newman, Peter, of Gyllyngham, turner 0
4143488 2075881 2075881 defendant Serchefeilde Robert gent 596533 596533 Serchefeilde, Robert, of Gyllyngham, gent 0
4169448 2084817 2084817 defendant Booles William husbandman 596533 596533 Booles, William, of Gyllyngham, husbandman 0
4169449 2084817 2084817 defendant Thorne Nicholas tucker 596533 596533 Thorne, Nicholas, of Gyllyngham, tucker 1
4169450 2084817 2084817 defendant Shephard William tucker 596533 596533 Shephard, William, of Gyllyngham, tucker 2
4171532 2085508 2085508 defendant Moggredge Thomas yeoman 596533 596533 Moggredge, Thomas, of Gyllyngham, yeoman 0
4192306 2092869 2092869 plaintiff Belman John husbandman 596533 596533 Belman, John, of Gyllyngham, husbandman 0
4278949 2122571 2122571 defendant Bysse John gent 596533 596533 Bysse, John, of Gyllyngham, gent 1
4304052 2131551 2131551 defendant Pyckman or Pytman Nicholas husbandman 596533 596533 (Pyckman or Pytman, Nicholas, of Gyllyngham, husbandman 1
4318456 2136566 2136566 defendant Tumber Thomas butcher 596533 596533 Tumber, Thomas, of Gyllyngham, butcher 0
4460212 2188251 2188251 defendant Wyke John   596533 596533 Wyke, John, of Gyllyngham 2
4496083 2199451 2199451 defendant Stephen Robert   596533 596533 Stephen, Robert, of Gyllyngham 1
4534944 2211208 2211208 defendant Kent John   596533 596533 Kent, John, of Gyllyngham 2
4553032 2216888 2216888 defendant Derland John   596533 596533 Derland, John, of Gyllyngham 1
4588531 2227781 2227781 defendant Bocher Henry   596533 596533 Bocher, Henry, of Gyllyngham 0
4593426 2229230 2229230 defendant Sayere John   596533 596533 Sayere, John, of Gyllyngham 0
4596567 2230162 2230162 defendant Hayron William   596533 596533 Hayron, William, of Gyllyngham 1
4636086 2242115 2242115 defendant Wyke John   596533 596533 Wyke, John, of Gyllyngham 0
4685528 2261068 2261068 defendant Martyn Simon spitelman or hospital attendant 596533 596533 Martyn, Simon, of Gyllyngham, spitelman or hospital attendant 0
4781507 2290225 2290225 defendant Dygon Geoffrey husbandman 596533 596533 Dygon, Geoffrey, of Gyllyngham, husbandman 2
4811773 2299794 2299794 defendant Taillour Mathew tailor 596533 596533 Taillour, Mathew, of Gyllyngham, tailor 0
4823186 2303341 2303341 defendant Edward John husbandman 596533 596533 Edward, John, of Gyllyngham, husbandman 0
4830150 2305472 2305472 defendant Hengstrigge Walter husbandman 596533 596533 Hengstrigge, Walter, of Gyllyngham, husbandman 0
4850954 2311748 2311748 defendant Edward Mathew husbandman 596533 596533 Edward, Mathew, of Gyllyngham, husbandman 0
4853673 2312565 2312565 defendant Edward Mathew husbandman 596533 596533 Edward, Mathew, of Gyllyngham, husbandman 0
4895281 2325182 2325182 defendant Mason Henry   596533 596533 Mason, Henry, of Gyllyngham, mason 0
4902076 2327256 2327256 defendant Bydyk John gent 596533 596533 Bydyk, John, of Gyllyngham, gent 0
4906831 2328721 2328721 defendant Mancer Richard husbandman 596533 596533 Mancer, Richard, of Gyllyngham, husbandman 0
4906832 2328721 2328721 defendant Joce John husbandman 596533 596533 Joce, John, of Gyllyngham, husbandman 1
4906833 2328721 2328721 defendant Culton Alice   596533 596533 Culton, Alice, of Gyllyngham, widow of Culton, William 2
4913247 2330643 2330643 defendant Hobbes Richard yeoman 596533 596533 Hobbes, Richard, of Gyllyngham, yeoman 0
4935293 2337441 2337441 defendant Mylward Thomas laborer 596533 596533 Mylward, Thomas, of Gyllyngham, laborer 0
4935295 2337441 2337441 defendant Bogeley John butcher 596533 596533 together with Bogeley, John, of Gyllyngham, butcher 2
4981292 2351326 2351326 defendant Sandhirst William yeoman 596533 596533 Sandhirst, William, of Gyllyngham, yeoman 0
5025513 2364365 2364365 defendant Wryche John carpenter 596533 596533 Wryche, John, of Gyllyngham, carpenter 0
5025514 2364365 2364365 defendant Sprake Richard husbandman 596533 596533 Sprake, Richard, of Gyllyngham, husbandman 1
5026543 2364644 2364644 defendant Brook Henry husbandman 596533 596533 Brook, Henry, of Gyllyngham, husbandman 0
5026545 2364644 2364644 defendant Yonge William husbandman 596533 596533 Yonge, William, of Gyllyngham, husbandman 2
5044623 2370023 2370023 defendant Bamme Richard   596533 596533 Bamme, Richard, of Gyllyngham 0
5050841 2371870 2371870 defendant Harry John husbandman 596533 596533 Harry, John, of Gyllyngham, husbandman 0
5058123 2373995 2373995 defendant Plumstede John husbandman 596533 596533 Plumstede, John, of Gyllyngham, husbandman 5
5058124 2373995 2373995 defendant Gybbys Michael husbandman 596533 596533 Gybbys, Michael, of Gyllyngham, husbandman 6
5065017 2376068 2376068 defendant Smyth Henry smith 596533 596533 Smyth, Henry, of Gyllyngham, smith 0
5088437 2382994 2382994 defendant Vernon Stephen yeoman 596533 596533 Vernon, Stephen, of Gyllyngham, yeoman 0
5088438 2382994 2382994 defendant Fleccher Thomas husbandman 596533 596533 Fleccher, Thomas, of Gyllyngham, husbandman 1
5088440 2382994 2382994 defendant Fleccher Philip husbandman 596533 596533 Fleccher, Philip, of Gyllyngham, husbandman 3
5092127 2384074 2384074 defendant Gybbes Michael husbandman 596533 596533 Gybbes, Michael, of Gyllyngham, husbandman 3
5136578 2397216 2397216 defendant Pery William husbandman 596533 596533 Pery, William, of Gyllyngham, husbandman 0
5181396 2410302 2410302 defendant Grove Nicholas tanner 596533 596533 Grove, Nicholas, of Gyllyngham, tanner 1
5181397 2410302 2410302 defendant Coweherd Robert butcher 596533 596533 Coweherd, Robert, of Gyllyngham, butcher 2
5202912 2416615 2416615 defendant Grove Nicholas tanner 596533 596533 Grove, Nicholas, of Gyllyngham, tanner 0
5202913 2416615 2416615 defendant Coweherd Robert butcher 596533 596533 Coweherd, Robert, of Gyllyngham, butcher 1
5215669 2420307 2420307 defendant Gybbys Michael laborer 596533 596533 Gybbys, Michael, of Gyllyngham, laborer 2
5225753 2423202 2423202 defendant Vynyng William   596533 596533 Vynyng, William, of Gyllyngham 0
5236356 2426224 2426224 defendant Thorp Nicholas yeoman 596533 596533 Thorp, Nicholas, of Gyllyngham, yeoman 0
5236358 2426224 2426224 defendant Thorp John gent 596533 596533 Thorp, John, of Gyllyngham, gent 2
5246785 2429223 2429223 defendant Trymmell Henry clerk 596533 596533 Trymmell, Henry, of Gyllyngham, clerk 0
5251037 2430430 2430430 defendant Larke William husbandman 596533 596533 Larke, William, of Gyllyngham, husbandman 3
5275236 2437831 2437831 defendant Grove Nicholas tanner 596533 596533 Grove, Nicholas, of Gyllyngham, tanner 1
5327399 2453266 2453266 defendant Powse Thomas husbandman 596533 596533 Powse, Thomas, of Gyllyngham, husbandman 0
5336708 2456047 2456047 defendant Crystyan William husbandman 596533 596533 Crystyan, William, of Gyllyngham, husbandman 2
5336714 2456049 2456049 defendant Crystyan William husbandman 596533 596533 Crystyan, William, of Gyllyngham, husbandman 1
5386108 2471095 2471095 defendant Chaldecote William (legal representative) 596533 596533 Chaldecote, William, of Gyllyngham, executrix of 4

Next page

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