names

62 rows where place_id = 603117

✎ 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
3653149 1911318 1911318 defendant Billyngham Nicholas yeoman 603117 603117 Billyngham, Nicholas, of Kendall, Westmor, yeoman 0
3653151 1911319 1911319 defendant Byllyngham Nicholas yeoman 603117 603117 Byllyngham, Nicholas, of Kendall, Westmor, yeoman 0
3722826 1933407 1933407 defendant Beke Walter   603117 603117 Beke, Walter, of Kendall, Westmor, "merchard" or "passynger" 0
3761124 1945483 1945483 defendant Colens William clothman 603117 603117 Colens, William, of Kendall, Westmor, clothman 0
3761126 1945484 1945484 defendant Colens William clothman 603117 603117 Colens, William, of Kendall, Westmor, clothman 0
3761939 1945739 1945739 defendant Becke Miles merchant 603117 603117 Becke, Miles, of Kendall, Westmor, merchant 0
3763266 1946145 1946145 defendant Fostrest William draper 603117 603117 Fostrest, William, of Kendall, Westmor, draper 1
3784354 1952888 1952888 defendant Cokeson William draper 603117 603117 Cokeson, William, of Kendall, Westmor, draper 0
3790651 1954898 1954898 defendant Docwra Thomas gent 603117 603117 Docwra, Thomas, of Kendall, Westmor, gent 0
3836115 1969210 1969210 defendant Collyns William gent 603117 603117 Collyns, William, of Kendall, Westmor, gent 0
3842264 1971125 1971125 plaintiff Brigges Robert clothier 603117 603117 Brigges, Robert, of Kendall, Westmor, clothier 0
3842268 1971126 1971126 plaintiff Brigges Robert clothier 603117 603117 Brigges, Robert, of Kendall, Westmor, clothier 0
3842270 1971127 1971127 plaintiff Brigges Robert clothier 603117 603117 Brigges, Robert, of Kendall, Westmor, clothier 0
3842272 1971128 1971128 plaintiff Brigges Robert clothier 603117 603117 Brigges, Robert, of Kendall, Westmor, clothier 0
3875934 1982205 1982205 defendant Laileborne Nicholas gent 603117 603117 Laileborne, Nicholas, of Kendall, Westmor, gent 1
3886139 1985616 1985616 plaintiff Brigges Robert clothier 603117 603117 Brigges, Robert, of Kendall, Westmor, clothier 0
3895309 1988638 1988638 defendant Nycholson Thomas clothier 603117 603117 Nycholson, Thomas, of Kendall, Westmor, clothier 2
3903176 1991290 1991290 defendant Byrse Robert chapman 603117 603117 Byrse, Robert, of Kendall, Westmor, chapman 1
3918653 1996565 1996565 defendant Smyth John clothman 603117 603117 Smyth, John, of Kendall, Westmor, clothman 0
3923482 1998162 1998162 defendant Danson or Dauson Henry clothier 603117 603117 Danson or Dauson, Henry, of Kendall, Westmor, clothier 0
3938891 2003343 2003343 defendant Tydenman William clothier 603117 603117 Tydenman, William, of Kendall, Westm, clothier 0
3965555 2012564 2012564 defendant Crosseby Peter yeoman 603117 603117 Crosseby, Peter, of Kendall, Westmor, yeoman 0
3967997 2013435 2013435 defendant Williamson Anthony mercer 603117 603117 Williamson, Anthony, of Kendall, Westmor, mercer 2
3989781 2021091 2021091 plaintiff Bateman Nicholas clothier 603117 603117 Bateman, Nicholas, of Kendall, Westmor, clothier 0
3989783 2021092 2021092 plaintiff Bateman Nicholas clothier 603117 603117 Bateman, Nicholas, of Kendall, Westmor, clothier 0
4023618 2033156 2033156 plaintiff Bateman Nicholas clothier 603117 603117 Bateman, Nicholas, of Kendall, Westmor, clothier 0
4023620 2033157 2033157 plaintiff Bateman Nicholas clothier 603117 603117 Bateman, Nicholas, of Kendall, Westmor, clothier 0
4054891 2044140 2044140 defendant Bateman Robert yeoman 603117 603117 Bateman, Robert, of Kendall, Westmor, yeoman 0
4056795 2044813 2044813 defendant Helme Henry chapman 603117 603117 Helme, Henry, of Kendall, Westmor, chapman 1
4066525 2048320 2048320 defendant Bateman Henry yeoman 603117 603117 Bateman, Henry, of kendall, Westmor, yeoman 0
4069506 2049374 2049374 defendant Lockey James yeoman 603117 603117 Lockey, James, of Kendall, Westmor, yeoman 0
4069781 2049480 2049480 defendant Judson Stephen chapman 603117 603117 Judson, Stephen, of Kendall, Westmor, chapman 1
4070051 2049577 2049577 defendant Bateman Randolph or Randall clothier 603117 603117 Bateman, Randolph or Randall, of Kendall, Westmor, clothier 1
4081268 2053608 2053608 defendant Lockey Robert carrier 603117 603117 Lockey, Robert, of Kendall, Westmor, carrier 1
4081536 2053706 2053706 defendant Dickson Henry chapman 603117 603117 Dickson, Henry, of Kendall, Westmor, chapman 1
4081574 2053715 2053715 defendant Judson John   603117 603117 Judson, John, of Kendall, Westmor, chapman, alias Stephen Jodsonn 0
4081580 2053716 2053716 defendant Huberstye or Holberstie James chapman 603117 603117 Huberstye or Holberstie, James, of Kendall, Westmor, chapman 2
4087861 2055951 2055951 defendant Carrington Christopher chapman 603117 603117 Carrington, Christopher, of Kendall, Westmor, chapman 1
4088679 2056252 2056252 defendant Lockey Robert carrier 603117 603117 Lockey, Robert, of Kendall, Westmor, carrier 3
4088684 2056253 2056253 defendant Lockey Robert carrier 603117 603117 Lockey, Robert, of Kendall, Westmor, carrier 3
4090676 2056954 2056954 defendant Moser Merton innkeeper having the sign of the Black Bull 603117 603117 Moser, Merton, of Kendall, Westmor, innkeeper having the sign of the Black Bull 0
4130590 2071251 2071251 defendant Fothergill Reginald yeoman 603117 603117 Fothergill, Reginald, of Kendall, Westmor, yeoman 0
4137065 2073607 2073607 defendant Fyssher Arthur chapman 603117 603117 Fyssher, Arthur, of Kendall, Westmor, chapman 0
4165182 2083332 2083332 defendant Pott William yeoman 603117 603117 Pott, William, of Kendall, Westmor, yeoman 0
4193251 2093209 2093209 defendant Bindlos Peter chapman 603117 603117 Bindlos, Peter, of Kendall, Westmor, chapman 1
4200603 2095771 2095771 defendant Crosyer Roger yeoman 603117 603117 Crosyer, Roger, of Kendall, Westmor, yeoman 3
4252020 2113665 2113665 defendant Browne Roland husbandman 603117 603117 Browne, Roland, of Kendall, Westmor, husbandman 0
4261327 2116754 2116754 defendant Wilson Edward carrier 603117 603117 Wilson, Edward, of Kendall, Westmor, carrier 2
4265775 2118192 2118192 defendant Browne Roland chapman 603117 603117 Browne, Roland, of Kendall, Westmor, chapman 0
4267365 2118722 2118722 defendant Bedam or Bethome Thomas gent 603117 603117 Bedam or Bethome, Thomas, of Kendall, Westmor, gent 0
4272403 2120345 2120345 defendant Wilson Edward carrier 603117 603117 Wilson, Edward, of Kendall, Westmor, carrier 2
4290670 2126721 2126721 defendant Ayrey John gent 603117 603117 Ayrey, John, of Kendall, Westmor, gent 0
4306328 2132355 2132355 defendant Layfield John chapman 603117 603117 Layfield, John, of Kendall, Westmor, chapman 0
4310541 2133839 2133839 defendant Wilson Rowland chapman 603117 603117 Wilson, Rowland, of Kendall, Westmor, chapman 1
4310971 2133982 2133982 defendant Smyth John chapman 603117 603117 Smyth, John, of Kendall, Westmor, chapman 2
4319371 2136882 2136882 defendant Midgley James vintner 603117 603117 Midgley, James, of Kendall, Westmor, vintner 2
4330924 2140642 2140642 defendant Kayfeild John chapman 603117 603117 Kayfeild, John, of Kendall, Westmor, chapman 0
4360520 2150929 2150929 defendant Cooke Richard chapman 603117 603117 Cooke, Richard, of Kendall, Westmor, chapman 1
5564563 2524237 2524237 defendant Philipson Roland draper 603117 603117 Philipson, Roland, of Kendall, Westmor, draper 1
5564613 2524242 2524242 defendant Philipson Roland draper 603117 603117 Philipson, Roland, of Kendall, Westmor, draper 1
5577624 2528068 2528068 defendant Bellyngham Nicholas yeoman 603117 603117 Bellyngham, Nicholas, of Kendall, Westmor, yeoman 0
5577638 2528073 2528073 defendant bellyngham Nicholas yeoman 603117 603117 bellyngham, Nicholas, of Kendall, Westmor, yeoman 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);