names

121 rows where place_id = 591774

✎ 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
3605530 1869395 1869395 defendant Smyth Robert husbandman 591774 591774 Smyth, Robert, of Coton, husbandman 1
3620691 1874047 1874047 defendant Walys James yeoman 591774 591774 Walys, James, of Coton, yeoman 0
3620692 1874047 1874047 defendant Gelybronde Geoffrey yeoman 591774 591774 Gelybronde, Geoffrey, of Coton, yeoman 1
3620694 1874047 1874047 defendant Harryson John laborer 591774 591774 Harryson, John, of Coton, laborer 3
3661139 1913761 1913761 defendant Plont Ralph husbandman 591774 591774 Plont, Ralph, of Coton, husbandman 0
3662933 1914319 1914319 defendant Kyng John husbandman 591774 591774 Kyng, John, of Coton, husbandman 2
3673442 1917714 1917714 defendant Lucas John husbandman 591774 591774 Lucas, John, of Coton under Gyllesburgh, husbandman 0
3700687 1926463 1926463 defendant Reve Thomas husbandman 591774 591774 Reve, Thomas, of Coton, husbandman 0
3773119 1949295 1949295 defendant Tayller Nicholas carpenter 591774 591774 Tayller, Nicholas, of Coton, carpenter 0
3804938 1959488 1959488 defendant Sheperd Richard   591774 591774 Sheperd, Richard, of Coton, "suker" 1
3804939 1959488 1959488 defendant Underwode John yeoman 591774 591774 Underwode, John, of Coton, yeoman 2
3812051 1961679 1961679 defendant Doryngton Hamlet (legal representative) 591774 591774 Doryngton, Hamlet, of Coton, gent, executors of 0
3812052 1961679 1961679 defendant Doryngton John gent 591774 591774 (Doryngton, John, of Coton, gent 1
3812053 1961679 1961679 defendant Watson Roger husbandman 591774 591774 Watson, Roger, of Coton, husbandman 2
3823654 1965297 1965297 plaintiff Underwode John husbandman 591774 591774 Underwode, John, of Coton, husbandman 0
3906236 1992374 1992374 defendant Hyggynson John yeoman 591774 591774 Hyggynson, John, of Coton, yeoman 2
3906237 1992374 1992374 defendant Sherrard Hugh yeoman 591774 591774 Sherrard, Hugh, of Coton, yeoman 3
3915614 1995590 1995590 defendant Undwerwood John husbandman 591774 591774 Undwerwood, John, of Coton, husbandman 0
4017907 2031118 2031118 defendant Scutt Richard laborer 591774 591774 Scutt, Richard, of Coton, laborer 3
4039879 2038884 2038884 plaintiff Cole John yeoman 591774 591774 Cole, John, of Coton, yeoman 1
4039882 2038885 2038885 plaintiff Coole John yeoman 591774 591774 Coole, John, of Coton, yeoman 1
4039885 2038886 2038886 plaintiff Coole John yeoman 591774 591774 Coole, John, of Coton, yeoman 1
4053051 2043520 2043520 defendant Chrycheley John draper 591774 591774 Chrycheley, John, of Coton, yeoman, or of Lichfeld, draper 0
4053054 2043521 2043521 defendant Crycheley James yeoman 591774 591774 Crycheley, James, of Coton, or of Lichfeld, yeoman 0
4053061 2043523 2043523 defendant Hassell Henry gent 591774 591774 Hassell, Henry, of Coton, gent 1
4059383 2045747 2045747 defendant Gopsyll William yeoman 591774 591774 Gopsyll, William, of Coton, yeoman 1
4060208 2046052 2046052 defendant Gopsyll William yeoman 591774 591774 Gopsyll, William, of Coton, yeoman 1
4071336 2050048 2050048 defendant Parker Thomas husbandman 591774 591774 Parker, Thomas, of Coton, husbandman 3
4141194 2075078 2075078 defendant Steavem John, senior husbandman 591774 591774 Steavem, John, senior, of Coton, husbandman 2
4155965 2080161 2080161 defendant Sherrat Alan husbandman 591774 591774 Sherrat, Alan, of Coton, husbandman 0
4309028 2133313 2133313 defendant Coles Anne spinster 591774 591774 Coles, Anne, of Coton, spinster 0
4339536 2143597 2143597 defendant Steven John yeoman 591774 591774 Steven, John, of Coton, yeoman 0
4354351 2148753 2148753 defendant Hynkyn William husbandman 591774 591774 Hynkyn, William, of Coton, husbandman 0
4354352 2148753 2148753 defendant Gardyner Thomas husbandman 591774 591774 Gardyner, Thomas, of Coton, husbandman 1
4354353 2148753 2148753 defendant Evance John husbandman 591774 591774 Evance, John, of Coton, husbandman 2
4354354 2148753 2148753 defendant Dyke Nicholas husbandman 591774 591774 Dyke, Nicholas, of Coton, husbandman 3
4355248 2149057 2149057 defendant Hynkyn William husbandman 591774 591774 Hynkyn, William, of Coton, husbandman 0
4355249 2149057 2149057 defendant Evance John husbandman 591774 591774 Evance, John, of Coton, husbandman 1
4355250 2149057 2149057 defendant Dale Nicholas husbandman 591774 591774 Dale, Nicholas, of Coton, husbandman 2
4408244 2167327 2167327 defendant Hynkyn William husbandman 591774 591774 Hynkyn, William, of Coton, husbandman 0
4408245 2167327 2167327 defendant Gardyner Thomas husbandman 591774 591774 Gardyner, Thomas, of Coton, husbandman 1
4408246 2167327 2167327 defendant Evance John husbandman 591774 591774 Evance, John, of Coton, husbandman 2
4408247 2167327 2167327 defendant Dyke Nicholas husbandman 591774 591774 Dyke, Nicholas, of Coton, husbandman 3
4409323 2167714 2167714 defendant Hynkyn William husbandman 591774 591774 Hynkyn, William, of Coton, husbandman 0
4409324 2167714 2167714 defendant Evance John husbandman 591774 591774 Evance, John, of Coton, husbandman 1
4409325 2167714 2167714 defendant Dale Nicholas husbandman 591774 591774 Dale, Nicholas, of Coton, husbandman 2
4433608 2175277 2175277 defendant Baddesleye Peter de   591774 591774 Baddesleye, Peter de, of Coton 0
4443670 2182987 2182987 defendant Hamond Robert   591774 591774 Hamond, Robert, of Coton 0
4462382 2188932 2188932 defendant Blome Nicholas   591774 591774 Blome, Nicholas, of Coton 2
4472887 2192196 2192196 defendant Lee Roger   591774 591774 Lee, Roger, of Coton 0
4482529 2195237 2195237 defendant Stevenson Richard   591774 591774 Stevenson, Richard, of Coton 3
4484040 2195699 2195699 defendant Stevenson Richard   591774 591774 Stevenson, Richard, of Coton 3
4490603 2197756 2197756 defendant Odele John   591774 591774 Odele, John, of Coton 0
4502161 2201272 2201272 defendant Palmer Thomas   591774 591774 Palmer, Thomas, of Coton 0
4525758 2208359 2208359 defendant Marreys Henry   591774 591774 Marreys, Henry, of Coton 0
4527667 2208935 2208935 defendant Reede Henry   591774 591774 Reede, Henry, of Coton 0
4527668 2208935 2208935 defendant Alcok John   591774 591774 Alcok, John, of Coton 1
4542116 2213427 2213427 defendant Reede Henry   591774 591774 Reede, Henry, of Coton 0
4542117 2213427 2213427 defendant Alkot John   591774 591774 Alkot, John, of Coton 1
4567110 2221270 2221270 defendant del Halle Thomas   591774 591774 del Halle, Thomas, of Coton 0
4571159 2222551 2222551 defendant Coton Thomas   591774 591774 Coton, Thomas, of Coton 0
4574433 2223533 2223533 defendant Neel Ralph   591774 591774 Neel, Ralph, of Coton 0
4579579 2225099 2225099 defendant Harward John smith 591774 591774 Harward, John, of Coton, smith 0
4655013 2247449 2247449 defendant Coton Robert husbandman 591774 591774 Coton, Robert, of Coton, husbandman 0
4675977 2258096 2258096 defendant Sherwode John laborer 591774 591774 Sherwode, John, of Coton, laborer 3
4680997 2259681 2259681 defendant Claver or Clauer Thomas husbandman 591774 591774 Claver or Clauer, Thomas, of Coton, husbandman 2
4712573 2269251 2269251 plaintiff Smyth Robert   591774 591774 Smyth, Robert, of Coton 0
4730117 2274620 2274620 defendant Brid Nicholas yeoman 591774 591774 Brid, Nicholas, of Coton, yeoman 1
4740358 2277691 2277691 defendant Copes Nicholas husbandman 591774 591774 Copes, Nicholas, of Coton, husbandman 1
4747226 2279692 2279692 defendant Halle John husbandman 591774 591774 Halle, John, of Coton, husbandman 4
4747886 2279885 2279885 defendant Kyngeson John husbandman 591774 591774 Kyngeson, John, of Coton, husbandman 4
4754237 2281704 2281704 plaintiff Wryght John   591774 591774 Wryght, John, of Coton 0
4764565 2284904 2284904 defendant Sampson Adam yeoman 591774 591774 Sampson, Adam, of Coton, yeoman 0
4776687 2288698 2288698 defendant Floure John husbandman 591774 591774 Floure, John, of Coton, husbandman 0
4808119 2298715 2298715 defendant Payntour John husbandman 591774 591774 Payntour, John, of Coton, husbandman 0
4839623 2308308 2308308 defendant Halle John husbandman 591774 591774 Halle, John, of Coton, husbandman 5
4861445 2314951 2314951 defendant Lucas Thomas husbandman 591774 591774 Lucas, Thomas, of Coton, husbandman 0
4861446 2314951 2314951 defendant Lucas John husbandman 591774 591774 Lucas, John, of Coton, husbandman 1
4861447 2314951 2314951 defendant Kekeby John husbandman 591774 591774 Kekeby, John, of Coton, husbandman 2
4861448 2314951 2314951 defendant Carter John husbandman 591774 591774 Carter, John, of Coton, husbandman 3
4866833 2316590 2316590 defendant Halle John husbandman 591774 591774 Halle, John, of Coton, husbandman 3
4895198 2325158 2325158 defendant Couper Thomas husbandman 591774 591774 Couper, Thomas, of Coton, husbandman 0
4895199 2325158 2325158 defendant Lord John husbandman 591774 591774 Lord, John, of Coton, husbandman 1
4895201 2325158 2325158 defendant Proude William husbandman 591774 591774 Proude, William, of Coton, husbandman 3
4906174 2328522 2328522 defendant Cole William husbandman 591774 591774 Cole, William, of Coton, husbandman 2
4912341 2330362 2330362 defendant Lord Thomas, junior husbandman 591774 591774 Lord, Thomas, junior, of Coton, husbandman 0
4933588 2336887 2336887 defendant Syre Thomas husbandman 591774 591774 Syre, Thomas, of Coton, husbandman 0
4951087 2342302 2342302 defendant Arle Richard husbandman 591774 591774 Arle, Richard, of Coton, husbandman 4
4958426 2344488 2344488 defendant Cole John husbandman 591774 591774 Cole, John, of Coton, husbandman 0
4959630 2344842 2344842 defendant Rodon John husbandman 591774 591774 Rodon, John, of Coton, husbandman 1
4960558 2345126 2345126 defendant Lorde Maud widow 591774 591774 Lorde, Maud, of Coton, widow 0
4960561 2345126 2345126 defendant Couper John husbandman 591774 591774 Couper, John, of Coton, husbandman 3
4977089 2350102 2350102 defendant Erle Richard husbandman 591774 591774 Erle, Richard, of Coton, husbandman 0
5066333 2376459 2376459 defendant Congulton Robert husbandman 591774 591774 Congulton, Robert, of Coton, husbandman 0
5082197 2381170 2381170 defendant Mawer John yeoman 591774 591774 Mawer, John, of Coton, yeoman 0
5091514 2383908 2383908 defendant Cobb John husbandman 591774 591774 Cobb, John, of Coton, husbandman 6
5121868 2392830 2392830 defendant Mundys Simon carpenter 591774 591774 Mundys, Simon, of Coton, carpenter 0
5133409 2396261 2396261 defendant Swetenham Thomas gent 591774 591774 Swetenham, Thomas, of Coton, gent 0
5151688 2401652 2401652 defendant Dyxwell William yeoman 591774 591774 Dyxwell, William, of Coton by Chirchewover, yeoman 0
5217346 2420810 2420810 defendant Swetnam Thomas esq 591774 591774 Swetnam, Thomas, of Coton, esq 0

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