names

167 rows where place_id = 591323

✎ 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
3604067 1868941 1868941 defendant Wastlyn John smith 591323 591323 Wastlyn, John, of Earls Colne, smith 0
3604068 1868941 1868941 defendant Mogge Richard yeoman 591323 591323 Mogge, Richard, of Earls Colne, yeoman 1
3632871 1905098 1905098 defendant Jesse or Jeffe Nicholas yeoman 591323 591323 Jesse or Jeffe, Nicholas, of Earls Colne, yeoman 0
3679135 1919541 1919541 defendant Mete aloas Motte John smith 591323 591323 Mete aloas Motte, John, of Earls Colne, smith 4
3688552 1922578 1922578 defendant Sparowe John yeoman 591323 591323 Sparowe, John, of Earls Colne, yeoman 0
3703475 1927358 1927358 defendant Sparowe John tanner 591323 591323 Sparowe, John, of Earls Colne, tanner 0
3709923 1929418 1929418 defendant Sevyer Agnes spinster 591323 591323 Sevyer, Agnes, of Earls Colne, spinster 0
3743966 1940002 1940002 defendant Sparowe John yeoman 591323 591323 Sparowe, John, of Earls Colne, yeoman 0
3792079 1955376 1955376 defendant Lyngwood William   591323 591323 Lyngwood, William, of Earls Colne. Husbandman 2
3849736 1973505 1973505 defendant Farthyng John yeoman 591323 591323 Farthyng, John, of Earls Colne, yeoman 0
3858020 1976157 1976157 plaintiff Beeston George yeoman 591323 591323 Beeston, George, of Earls Colne, yeoman 0
3899287 1989972 1989972 plaintiff Beesten George   591323 591323 Beesten, George, of Earls Colne 0
3919215 1996755 1996755 defendant Rote Thomas, senior yeoman 591323 591323 Rote, Thomas, senior, of Earls Colne, yeoman 0
3921541 1997543 1997543 defendant Coppyn John baker 591323 591323 Coppyn, John, of Earls Colne, baker 0
3930980 2000695 2000695 defendant Chisell William yeoman 591323 591323 (Chisell, William, of Earls Colne, yeoman 1
3971956 2014749 2014749 plaintiff Folkes John yeoman 591323 591323 Folkes, John, of Earls Colne, yeoman 0
3971958 2014749 2014749 defendant Brand Richard clothier 591323 591323 Brand, Richard, of Earls Colne, clothier 1
3971959 2014750 2014750 plaintiff Folkes John yeoman 591323 591323 Folkes, John, of Earls Colne, yeoman 0
3971961 2014750 2014750 defendant Brand Richard clothier 591323 591323 Brand, Richard, of Earls Colne, clothier 1
3982546 2018533 2018533 defendant Polley Adam yeoman 591323 591323 Polley, Adam, of Earls Colne, yeoman 0
3982547 2018533 2018533 defendant Polley John, junior laborer 591323 591323 Polley, John, junior, of Earls Colne, laborer 1
3982548 2018533 2018533 defendant Reade Robert yeoman 591323 591323 Reade, Robert, of Earls Colne, yeoman 2
3982972 2018689 2018689 defendant Polley John, junior laborer 591323 591323 Polley, John, junior, of Earls Colne, laborer 0
3982973 2018689 2018689 defendant Walshe Robert laborer 591323 591323 Walshe, Robert, of Earls Colne, laborer 1
3982974 2018689 2018689 defendant Barrett John yeoman 591323 591323 Barrett, John, of Earls Colne, yeoman 2
3982979 2018690 2018690 defendant Tracer John laborer 591323 591323 Tracer, John, of Earls Colne, laborer 0
3982980 2018690 2018690 defendant Allen Anthony laborer 591323 591323 Allen, Anthony, of Earls Colne, laborer 1
3982981 2018690 2018690 defendant Brond alias Bowles Christopher clothier 591323 591323 Brond alias Bowles, Christopher, of Earls Colne, clothier 2
3982982 2018690 2018690 defendant Brond alias Bowles Richard clothier 591323 591323 Brond alias Bowles, Richard, of Earls Colne, clothier 3
3982983 2018690 2018690 defendant Poynter Thomas laborer 591323 591323 Poynter, Thomas, of Earls Colne, laborer 4
3982984 2018690 2018690 defendant Richold Edward butcher 591323 591323 Richold, Edward, of Earls Colne, butcher 5
3982986 2018691 2018691 defendant Warde Robert laborer 591323 591323 Warde, Robert, of Earls Colne, laborer 0
3982987 2018691 2018691 defendant Strette Robert laborer 591323 591323 Strette, Robert, of Earls Colne, laborer 1
4005814 2026853 2026853 defendant Sygg Richard butcher 591323 591323 Sygg, Richard, of Earls Colne, butcher 1
4005815 2026853 2026853 defendant Catt William husbandman 591323 591323 Catt, William, of Earls Colne, husbandman 2
4005816 2026853 2026853 defendant Polly Adam yeoman 591323 591323 Polly, Adam, of Earls Colne, yeoman 3
4013498 2029562 2029562 plaintiff Routhe Richard   591323 591323 Routhe, Richard, of Earls Colne, pail or pale maker 0
4013500 2029563 2029563 plaintiff Routhe Richard   591323 591323 Routhe, Richard, of Earls Colne, pale maker 0
4038541 2038424 2038424 defendant Myddleton John yeoman 591323 591323 Myddleton, John, of Earls Colne, yeoman 0
4038543 2038425 2038425 defendant Myddleton John yeoman 591323 591323 Myddleton, John, of Earls Colne, yeoman 0
4113207 2064992 2064992 defendant Jolley Robert Essex, yeoman 591323 591323 Jolley Robert, of Earls Colne, Essex, yeoman 0
4113208 2064992 2064992 defendant Turnor William yeoman 591323 591323 Turnor, William, of Earls Colne, yeoman 1
4168377 2084426 2084426 defendant Hewes Jonah   591323 591323 Hewes, Jonah, of Earls Colne 0
4367996 2153604 2153604 defendant Whyffyn Thomas yeoman 591323 591323 Whyffyn, Thomas, of Earls Colne, yeoman 1
4386487 2160154 2160154 defendant Sawen John husbandman 591323 591323 Sawen, John, of Earls Colne, husbandman 0
4386488 2160154 2160154 defendant Bredge Henry tailor 591323 591323 Bredge, Henry, of Earls Colne, tailor 1
4389912 2161251 2161251 defendant Fyshe Richard husbandman 591323 591323 Fyshe, Richard, of Earls Colne, husbandman 2
4406668 2166796 2166796 defendant Stillitoe John butcher 591323 591323 Stillitoe, John, of Earls Colne, butcher 0
4446283 2183753 2183753 defendant Wynter John   591323 591323 Wynter, John, of Earls Colne 2
4448480 2184458 2184458 defendant Currour Robert   591323 591323 Currour, Robert, of Earls Colne 0
4460164 2188236 2188236 defendant Diere Nicholas   591323 591323 Diere, Nicholas, of Earls Colne 2
4460165 2188236 2188236 defendant Michel John   591323 591323 Michel, John, of Earls Colne 3
4461753 2188737 2188737 defendant Bonyle Roger   591323 591323 Bonyle, Roger, of Earls Colne 0
4461755 2188737 2188737 defendant Taillour John   591323 591323 Taillour, John, of Earls Colne 2
4461757 2188738 2188738 defendant Norman Vincent   591323 591323 Norman, Vincent, of Earls Colne 0
4461760 2188739 2188739 defendant Bovyle Roger   591323 591323 Bovyle, Roger, of Earls Colne 0
4461762 2188739 2188739 defendant Taillour John   591323 591323 Taillour, John, of Earls Colne 2
4487553 2196825 2196825 plaintiff Smyth Thomas   591323 591323 Smyth, Thomas, of Earls Colne 0
4487556 2196826 2196826 plaintiff Smyth Thomas   591323 591323 Smyth, Thomas, of Earls Colne 0
4487557 2196826 2196826 defendant Taververn Richard   591323 591323 Taververn, Richard, of Earls Colne 0
4492705 2198419 2198419 defendant Webbe Thomas dyer 591323 591323 Webbe, Thomas, of Earls Colne, dyer 1
4515088 2205131 2205131 plaintiff Chapman Geoffrey   591323 591323 Chapman, Geoffrey, of Earls Colne 0
4515090 2205132 2205132 plaintiff Chapman Geoffrey   591323 591323 Chapman, Geoffrey, of Earls Colne 0
4565512 2220784 2220784 defendant Normelle John   591323 591323 Normelle, John, of Earls Colne 0
4565513 2220784 2220784 defendant Debenham Roger   591323 591323 Debenham, Roger, of Earls Colne 1
4587445 2227477 2227477 plaintiff Hunte Thomas   591323 591323 Hunte, Thomas, of Earls Colne 0
4587446 2227477 2227477 defendant Langton John   591323 591323 Langton, John, of Earls Colne 0
4652185 2246623 2246623 defendant Onger William yeoman 591323 591323 Onger, William, of Earls Colne, yeoman 0
4689855 2262383 2262383 defendant Bradford Ralph gent 591323 591323 Bradford, Ralph, of Earls Colne, gent 4
4713327 2269492 2269492 defendant atte Wode William   591323 591323 (atte Wode, William, of Earls Colne, mason 5
4713328 2269492 2269492 defendant Wryght John   591323 591323 Wryght, John, of Earls Colne, wright 6
4718087 2270998 2270998 defendant atte Wode William   591323 591323 (atte Wode, William, of Earls Colne, mason 1
4718088 2270998 2270998 defendant Kelet Thomas shoemaker 591323 591323 Kelet, Thomas, of Earls Colne, shoemaker 2
4735650 2276299 2276299 defendant Snowe John fuller 591323 591323 Snowe, John, of Earls Colne, fuller 1
4751079 2280798 2280798 defendant Chaloner John butcher 591323 591323 Chaloner, John, of Earls Colne, butcher 0
4771075 2286933 2286933 defendant Beveroche Henry   591323 591323 Beveroche, Henry, of Earls Colne, pedlar 1
4772865 2287485 2287485 defendant Taillour Robert (legal representative) 591323 591323 Taillour, Robert, of Earls Colne, executors of: (atte Wode, William, of Earls Colne, mason 4
4772866 2287485 2287485 defendant Wright John carpenter 591323 591323 Wright, John, of Earls Colne, carpenter 5
4772867 2287485 2287485 defendant Acon Robert weaver 591323 591323 Acon, Robert, of Earls Colne, weaver 6
4792756 2293822 2293822 defendant Peldon John barber 591323 591323 Peldon, John, of Earls Colne, barber 0
4829455 2305254 2305254 defendant Turnour John yeoman 591323 591323 Turnour, John, of Earls Colne, yeoman 0
4856311 2313348 2313348 defendant Turnour John yeoman 591323 591323 Turnour, John, of Earls Colne, yeoman 0
4856312 2313348 2313348 defendant Sonyld or Sovyld John husbandman 591323 591323 Sonyld or Sovyld, John, of Earls Colne, husbandman 1
4859773 2314424 2314424 defendant Wilde Robert fuller 591323 591323 Wilde, Robert, of Earls Colne, fuller 0
4859775 2314425 2314425 defendant Wylde Robert fuller 591323 591323 Wylde, Robert, of Earls Colne, fuller 0
4881234 2321036 2321036 defendant Hamonde Simon husbandman 591323 591323 Hamonde, Simon, of Earls Colne, husbandman 1
4884393 2322021 2322021 plaintiff Mille John   591323 591323 Mille, John, of Earls Colne 1
4910667 2329846 2329846 defendant Goldyng Edmund husbandman 591323 591323 Goldyng, Edmund, of Earls Colne, husbandman 0
4915053 2331211 2331211 defendant Morse Thomas husbandman 591323 591323 Morse, Thomas, of Earls Colne, husbandman 3
4923113 2333646 2333646 defendant S--- Richard farmer 591323 591323 S---, Richard, of Earls Colne, farmer 0
4942791 2339716 2339716 defendant Mey John weaver 591323 591323 Mey, John, of Earls Colne, weaver 1
4950216 2342032 2342032 defendant Skynner Richard pedder 591323 591323 Skynner, Richard, of Earls Colne, pedder 0
4954763 2343379 2343379 defendant Morton or Mordon Thomas spicer 591323 591323 Morton or Mordon, Thomas, of Earls Colne, or of Wykeham Market, Suff, spicer 0
4968207 2347442 2347442 defendant Drewe John glover 591323 591323 Drewe, John, of Earls Colne, glover 0
4976424 2349912 2349912 defendant Audele Ralph barber 591323 591323 Audele, Ralph, of Earls Colne, barber 1
4976427 2349913 2349913 defendant Audele Ralph barber 591323 591323 Audele, Ralph, of Earls Colne, barber 1
5005237 2358429 2358429 defendant Goldyng Edmund chapman 591323 591323 Goldyng, Edmund, of Earls Colne, chapman 0
5009759 2359734 2359734 defendant Mordon Thomas husbandman 591323 591323 Mordon, Thomas, of Earls Colne, husbandman 2
5013004 2360636 2360636 defendant Goldyng Edmund husbandman 591323 591323 Goldyng, Edmund, of Earls Colne, husbandman 1
5017254 2361930 2361930 defendant Olmestede Thomas, senior butcher 591323 591323 Olmestede, Thomas, senior, of Earls Colne, butcher 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);