names

182 rows where place_id = 591423

✎ 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
3604366 1869033 1869033 defendant Derkyn Thomas husbandman 591423 591423 Derkyn, Thomas, of Fynchyngfeld, husbandman 0
3619881 1873792 1873792 defendant Darkyll Thomas husbandman 591423 591423 Darkyll, Thomas, of Fynchyngfeld, husbandman 0
3620895 1874098 1874098 defendant Rand William husbandman 591423 591423 Rand, William, of Fynchyngfeld, husbandman 1
3620896 1874098 1874098 defendant Polto or Pulte Robert husbandman 591423 591423 Polto or Pulte, Robert, of Fynchyngfeld, husbandman 2
3705811 1928098 1928098 plaintiff Herde Thomas (legal representative) 591423 591423 Herde, Thomas, of Fynchyngfeld, yeoman, executors of 0
3709656 1929330 1929330 defendant Barners John esq 591423 591423 Barners, John, of Fynchyngfeld, esq 0
3734209 1936940 1936940 defendant Tybbold William mercer 591423 591423 Tybbold, William, of Fynchyngfeld, mercer 2
3755005 1943512 1943512 defendant Walford John husbandman 591423 591423 Walford, John, of Fynchyngfeld, husbandman 1
3756985 1944164 1944164 plaintiff Barnes John esq 591423 591423 Barnes, John, of Fynchyngfeld, esq 0
3771447 1948762 1948762 defendant Pottefeld Philip carpenter 591423 591423 Pottefeld, Philip, of Fynchyngfeld, carpenter 1
3771448 1948762 1948762 defendant Coo John husbandman 591423 591423 Coo, John, of Fynchyngfeld, husbandman 2
3771449 1948762 1948762 defendant Richold Thomas butcher 591423 591423 Richold, Thomas, of Fynchyngfeld, butcher 3
3779613 1951353 1951353 defendant Rychold Thomas butcher 591423 591423 Rychold, Thomas, of Fynchyngfeld, butcher 1
3785930 1953395 1953395 plaintiff Parker William yeoman 591423 591423 Parker, William, of Fynchyngfeld, yeoman 0
3792078 1955376 1955376 defendant Rychold Thomas butcher 591423 591423 Rychold, Thomas, of Fynchyngfeld, butcher 1
3796607 1956813 1956813 defendant Barnes John esq 591423 591423 Barnes, John, of Fynchyngfeld, esq 0
3810319 1961119 1961119 defendant Harvy Thomas husbandman 591423 591423 Harvy, Thomas, of Fynchyngfeld, husbandman 1
3830196 1967339 1967339 defendant Mascall William yeoman 591423 591423 Mascall, William, of Fynchyngfeld, yeoman 0
3830197 1967339 1967339 defendant Rycholde Thomas husbandman 591423 591423 Rycholde, Thomas, of Fynchyngfeld, husbandman 1
3848292 1973036 1973036 defendant Rychold Thomas buthcer 591423 591423 Rychold, Thomas, of Fynchyngfeld, buthcer 1
3851886 1974181 1974181 defendant Hayward John husbandman 591423 591423 Hayward, John, of Fynchyngfeld, husbandman 1
3867540 1979380 1979380 defendant Sylesden Thomas gent 591423 591423 Sylesden, Thomas, of Fynchyngfeld, gent 0
3870050 1980224 1980224 defendant Mayedy John clerk 591423 591423 Mayedy, John, of Fynchyngfeld, clerk 0
3870803 1980483 1980483 defendant Palmer John laborer 591423 591423 Palmer, John, of Fynchyngfeld, laborer 0
3891163 1987311 1987311 defendant Warner alias Brewer Thomas husbandman 591423 591423 Warner alias Brewer, Thomas,of Fynchyngfeld, husbandman 2
3896832 1989151 1989151 defendant Caunte John husbandman 591423 591423 Caunte, John, of Fynchyngfeld, husbandman 0
3903983 1991571 1991571 defendant Warner alias Brewer Thomas husbandman 591423 591423 Warner alias Brewer, Thomas, of Fynchyngfeld, husbandman 0
3911546 1994180 1994180 defendant Barnars Francis esq 591423 591423 Barnars, Francis, of Fynchyngfeld, esq 0
3911547 1994180 1994180 defendant Darkyn Anthony laborer 591423 591423 Darkyn, Anthony, of Fynchyngfeld, laborer 1
3911548 1994180 1994180 defendant Harbye John laborer 591423 591423 Harbye, John, of Fynchyngfeld, laborer 2
3911549 1994180 1994180 defendant Brond John laborer 591423 591423 Brond, John, of Fynchyngfeld, laborer 3
3911550 1994180 1994180 defendant Bekwyth Thomas laborer 591423 591423 Bekwyth, Thomas, of Fynchyngfeld, laborer 4
3911552 1994181 1994181 defendant Darkyn Anthony laborer 591423 591423 Darkyn, Anthony, of Fynchyngfeld, laborer 0
3911553 1994181 1994181 defendant Harvy John laborer 591423 591423 Harvy, John, of Fynchyngfeld, laborer 1
3911554 1994181 1994181 defendant Brond alias Bolt John laborer 591423 591423 Brond alias Bolt, John, of Fynchyngfeld, laborer 2
3911555 1994181 1994181 defendant Bekwith Thomas laborer 591423 591423 Bekwith, Thomas, of Fynchyngfeld, laborer 3
3911556 1994181 1994181 defendant Barners Francis esq 591423 591423 Barners, Francis, of Fynchyngfeld, esq 4
3914798 1995296 1995296 defendant Groundesborow alias Totyryche Thomas husbandman 591423 591423 Groundesborow alias Totyryche, Thomas, of Fynchyngfeld, husbandman 1
3914799 1995296 1995296 defendant Bretten John butcher 591423 591423 Bretten, John, of Fynchyngfeld, butcher 2
3917618 1996251 1996251 defendant Warner alias Bruer Thomas   591423 591423 Warner alias Bruer, Thomas, of Fynchyngfeld, husbandman, administrators of 0
3921108 1997411 1997411 defendant Gelham alias Yeldham Thomas husbandman 591423 591423 Gelham alias Yeldham, Thomas, of Fynchyngfeld, husbandman 0
3921109 1997411 1997411 defendant Gelham alias Yeldham John husbandman 591423 591423 Gelham alias Yeldham, John, of Fynchyngfeld, husbandman 1
3921110 1997411 1997411 defendant Gelham alias Yeldham Elizabeth spinster 591423 591423 Gelham alias Yeldham, Elizabeth, of Fynchyngfeld, spinster 2
4085512 2055095 2055095 defendant Harryngton Henry yeoman 591423 591423 Harryngton, Henry, of Fynchyngfeld, yeoman 0
4100825 2060611 2060611 defendant Yeldham John (legal representative) 591423 591423 Yeldham, John, of Fynchyngfeld, yeoman, executrix of 0
4177003 2087429 2087429 defendant Browne John yeoman 591423 591423 Browne, John, of Fynchyngfeld, yeoman 0
4415935 2169868 2169868 defendant Walram John   591423 591423 Walram, John, of Fynchyngfeld, knight 0
4425989 2172931 2172931 defendant Kempe Nicholas   591423 591423 Kempe, Nicholas, of Fynchyngfeld 0
4457135 2187241 2187241 defendant Kyng John   591423 591423 Kyng, John, of Fynchyngfeld 0
4457137 2187242 2187242 defendant Kyng John   591423 591423 Kyng, John, of Fynchyngfeld 0
4474492 2192682 2192682 defendant Long John miller 591423 591423 Long, John, of Fynchyngfeld, miller 3
4474497 2192683 2192683 defendant Taillour John   591423 591423 Taillour, John, of fynchyngfeld 1
4478817 2194044 2194044 defendant Spryngold Geoffrey   591423 591423 Spryngold, Geoffrey, of Fynchyngfeld 0
4495724 2199345 2199345 defendant Cardere Robert   591423 591423 Cardere, Robert, of Fynchyngfeld 2
4500138 2200682 2200682 defendant Cumpton Thomas   591423 591423 Cumpton, Thomas, of Fynchyngfeld 0
4500755 2200850 2200850 defendant Rys Robert   591423 591423 Rys, Robert, of Fynchyngfeld 2
4500757 2200850 2200850 defendant Neel Alexander   591423 591423 Neel, Alexander, of Fynchyngfeld 4
4525245 2208234 2208234 defendant Olksmyth John   591423 591423 Olksmyth, John, of Fynchyngfeld 0
4571428 2222649 2222649 defendant Sumpnour Henry   591423 591423 Sumpnour, Henry, of Fynchyngfeld 5
4587636 2227538 2227538 defendant Kemp Richard   591423 591423 Kemp, Richard, of Fynchyngfeld 0
4587637 2227538 2227538 defendant Colman William   591423 591423 Colman, William, of Fynchyngfeld 1
4588331 2227742 2227742 defendant Bakere John   591423 591423 Bakere, John, of Fynchyngfeld 3
4594659 2229584 2229584 defendant Pullleceoo Peter   591423 591423 Pullleceoo, Peter, of Fynchyngfeld 0
4601248 2231624 2231624 defendant Ovywene Henry   591423 591423 Ovywene, Henry, of Fynchyngfeld 0
4601819 2231790 2231790 defendant Onwyne Henry   591423 591423 Onwyne, Henry, of Fynchyngfeld 0
4607320 2233399 2233399 defendant Thetford Richard   591423 591423 Thetford, Richard, of Fynchyngfeld 1
4631260 2240672 2240672 defendant Gonerych Richard   591423 591423 Gonerych, Richard, of Fynchyngfeld 1
4651055 2246331 2246331 defendant Shelford John   591423 591423 Shelford, John, of Fynchyngfeld, bailiff 1
4654156 2247182 2247182 defendant Onewyn Richard husbandman 591423 591423 Onewyn, Richard, of Fynchyngfeld, husbandman 1
4654159 2247183 2247183 defendant Onewyn Richard husbandman 591423 591423 Onewyn, Richard, of Fynchyngfeld, husbandman 1
4663441 2250040 2250040 defendant Clovyere Robert tailor 591423 591423 Clovyere, Robert, of Fynchyngfeld, tailor 1
4665238 2250617 2250617 defendant Helion John esq 591423 591423 Helion, John, of Fynchyngfeld, esq 1
4679485 2259198 2259198 defendant Wouborne William gent 591423 591423 Wouborne, William, of fynchyngfeld, gent 0
4679486 2259198 2259198 defendant Cokkayn Thomas gent 591423 591423 Cokkayn, Thomas, of Fynchyngfeld, gent 1
4680552 2259529 2259529 defendant Helyon John esq 591423 591423 Helyon, John, of Fynchyngfeld, esq 0
4691780 2262961 2262961 defendant Shelford John yeoman 591423 591423 Shelford, John, of Fynchyngfeld, yeoman 0
4692818 2263264 2263264 defendant Olmested John butcher 591423 591423 Olmested, John, of Fynchyngfeld, butcher 0
4692819 2263264 2263264 defendant Hardy John butcher 591423 591423 Hardy, John, of Fynchyngfeld, butcher 1
4704979 2266932 2266932 defendant Wouborne William gent 591423 591423 Wouborne, William, of Fynchyngfeld, gent 0
4704994 2266936 2266936 defendant Caketon John husbandman 591423 591423 Caketon, John, of Fynchyngfeld, husbandman 2
4706200 2267316 2267316 defendant Hely John esq 591423 591423 Hely, John, of Fynchyngfeld, esq 0
4715518 2270185 2270185 defendant Kempe Richard gent 591423 591423 Kempe, Richard, of Fynchyngfeld, gent 0
4715519 2270185 2270185 defendant Brokholl Thomas husbandman 591423 591423 Brokholl, Thomas, of Fynchyngfeld, husbandman 1
4715521 2270185 2270185 defendant Bakere John husbandman 591423 591423 Bakere, John, of Fynchyngfeld, husbandman 3
4722679 2272409 2272409 defendant Helion John gent 591423 591423 Helion, John, of Fynchyngfeld, gent 0
4725887 2273385 2273385 defendant Hardy John butcher 591423 591423 Hardy, John, of Fynchyngfeld, butcher 1
4727768 2273928 2273928 defendant Hierde John husbandman 591423 591423 Hierde, John, of Fynchyngfeld, husbandman 0
4727770 2273929 2273929 defendant Godrych Richard shoemaker 591423 591423 Godrych, Richard, of Fynchyngfeld, shoemaker 0
4728315 2274100 2274100 defendant Brokhole Thomas, sen   591423 591423 Brokhole, Thomas, sen, of Fynchyngfeld 5
4728331 2274101 2274101 defendant Brokhole Thomas, sen   591423 591423 Brokhole, Thomas, sen, of Fynchyngfeld 5
4728666 2274204 2274204 defendant Kempe Richard gent 591423 591423 Kempe, Richard, of Fynchyngfeld, gent 0
4728706 2274215 2274215 defendant Helioune John esq 591423 591423 Helioune, John, of Fynchyngfeld, esq 0
4729837 2274537 2274537 defendant Helion John esq 591423 591423 Helion, John, of Fynchyngfeld, esq 0
4740657 2277784 2277784 defendant Waltham John fuller 591423 591423 Waltham, John, of Fynchyngfeld, fuller 0
4744834 2279009 2279009 defendant Goderich Richard shoemaker 591423 591423 Goderich, Richard, of Fynchyngfeld, shoemaker 2
4747173 2279676 2279676 defendant Spylman John husbandman 591423 591423 Spylman, John, of Fynchyngfeld, husbandman 0
4747174 2279676 2279676 defendant Buk- Stephen husbandman 591423 591423 Buk-, Stephen, of Fynchyngfeld, husbandman 1
4747176 2279676 2279676 defendant Goderiche Richard shoemaker 591423 591423 Goderiche, Richard, of Fynchyngfeld, shoemaker 3
4747316 2279717 2279717 defendant Kempe Richard gent 591423 591423 Kempe, Richard, of Fynchyngfeld, gent 0
4755967 2282249 2282249 defendant Brokhole Thomas husbandman 591423 591423 Brokhole, Thomas, of Fynchyngfeld, husbandman 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);