names

303 rows where place_id = 604469

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3656948 1912431 1912431 plaintiff (not given) Alexander prior of Colyns 604469 604469 Colyns, Alexander, of Daventry, prior of the monastery of St Augustine 0
3658098 1912788 1912788 defendant Graunt Thomas gent 604469 604469 Graunt, Thomas, of Daventry, gent 0
3661342 1913821 1913821 defendant (not given) Alexander prior of Colyns 604469 604469 Colyns, Alexander, of Daventry, prior of the monastery of St Augustine 0
3661347 1913822 1913822 defendant (not given) Alexander prior of Colyns 604469 604469 Colyns, Alexander, of Daventry, prior of the Monastery of St Augustine 0
3677629 1919045 1919045 defendant Cowper alias Harres John cooper 604469 604469 Cowper alias Harres, John, of Daventry, cooper 0
3687827 1922358 1922358 defendant Stafforde Philip gent 604469 604469 Stafforde, Philip, of Daventry, gent 0
3783406 1952559 1952559 defendant Mapull Maurice chapman 604469 604469 Mapull, Maurice, of Daventry, chapman 2
3948350 2006485 2006485 defendant Brothers Henry glover 604469 604469 Brothers, Henry, of Daventry, glover 0
3952938 2008097 2008097 defendant Batman Elizabeth widow 604469 604469 Elizabeth his wife, formerly Elizabeth Capes, of Daventry, widow 1
3959303 2010333 2010333 defendant Brothers Henry fellmonger 604469 604469 Brothers, Henry, of Daventry, fellmonger 0
3959304 2010333 2010333 defendant Brothers Richard fellmonger 604469 604469 Brothers, Richard, of Daventry, fellmonger 1
4010187 2028410 2028410 defendant Farmer William chapman 604469 604469 Farmer, William, of Daventry, chapman 1
4010188 2028410 2028410 defendant Blysse Henry chapman 604469 604469 Blysse, Henry, of Daventry, chapman 2
4012499 2029191 2029191 defendant Simons William yeoman 604469 604469 Simons, William, of Daventry, yeoman 2
4012500 2029191 2029191 defendant Banester Richard yeoman 604469 604469 Banester, Richard, of Daventry, yeoman 3
4026563 2034150 2034150 defendant Rogers John smith 604469 604469 Rogers, John, of Daventry, or of Carrington, Beds, smith 1
4026613 2034165 2034165 defendant Rogers John smith 604469 604469 Rogers, John, of Daventry, or of Carrington, Beds, smith 0
4034930 2037169 2037169 defendant Tuffnayle Edmund cooper 604469 604469 Tuffnayle, Edmund, of Daventry, or of Brandfeld, liberty of St Albans, Herts, cooper 0
4035248 2037285 2037285 defendant Tuffnayle Edmund cooper 604469 604469 Tuffnayle, Edmund, of Daventry, or of Brandfeld, liberty of St Albans, Herts, cooper 0
4045073 2040692 2040692 defendant Bagshawe John yeoman 604469 604469 Bagshawe, John, of Daventry, yeoman 1
4045079 2040693 2040693 defendant Bagshawe John yeoman 604469 604469 Bagshawe, John, of Daventry, yeoman 1
4048173 2041785 2041785 plaintiff Symmes John innholder 604469 604469 Symmes, John, of Daventry, innholder 0
4048175 2041786 2041786 plaintiff Symmes John innholder 604469 604469 Symmes, John, of Daventry, innholder 0
4119609 2067300 2067300 defendant Byddell Mathew   604469 604469 Byddell, Mathew, of Daventry, woollen draper 1
4119610 2067300 2067300 defendant Smyth Henry   604469 604469 Smyth, Henry, of Daventry, linen draper 2
4184377 2090037 2090037 defendant Roper Henry gent 604469 604469 Roper, Henry, of Daventry, gent 0
4208158 2098408 2098408 defendant Roper Henry gent 604469 604469 Roper, Henry, of Daventry, gent 0
4251639 2113530 2113530 defendant Walker George saddler 604469 604469 Walker, George, of Daventry, saddler 3
4257709 2115552 2115552 defendant Farmer William mercer 604469 604469 Farmer, William, of Daventry, mercer 0
4265483 2118092 2118092 defendant Walker George saddler 604469 604469 Walker, George, of Daventry, saddler 3
4317896 2136371 2136371 defendant Watt Edward butcher 604469 604469 Watt, Edward, of Daventry, butcher 0
4317897 2136371 2136371 defendant Brothers John   604469 604469 Brothers, John, of Daventry, woollen draper 1
4322874 2138066 2138066 defendant Abbye Mathew husbandman 604469 604469 (Abbye, Mathew, of Daventry, husbandman 1
4326964 2139349 2139349 defendant Moore Thomas pulter 604469 604469 Moore, Thomas, of Daventry, pulter 0
4337310 2142782 2142782 defendant Cliffe Thomas yeoman 604469 604469 Cliffe, Thomas, of Daventry, yeoman 0
4342122 2144526 2144526 defendant Mounford John husbandman 604469 604469 Mounford, John, of Daventry, husbandman 0
4342124 2144527 2144527 defendant Gennynges Thomas ironmonger 604469 604469 Gennynges, Thomas, of Daventry, ironmonger 0
4342125 2144527 2144527 defendant Smyth Henry mercer 604469 604469 Smyth, Henry, of Daventry, mercer 1
4344832 2145471 2145471 defendant Brothers John   604469 604469 Brothers, John, of Daventry, woolen draper 0
4344833 2145471 2145471 defendant Makepeace John   604469 604469 Makepeace, John, of Daventry, woollen draper 1
4348885 2146873 2146873 defendant Newport John gent 604469 604469 Newport, John, of Daventry, gent 0
4348886 2146873 2146873 defendant Musgrave John maltster 604469 604469 Musgrave, John, of Daventry, maltster 1
4348887 2146873 2146873 defendant Farmer William yeoman 604469 604469 Farmer, William, of Daventry, yeoman 2
4392770 2162200 2162200 defendant Mounford John husbandman 604469 604469 Mounford, John, of Daventry, husbandman 0
4416652 2170072 2170072 defendant Kat Walter butcher 604469 604469 Kat, Walter, of Daventry, butcher 0
4419854 2171107 2171107 defendant Horn John   604469 604469 Horn, John, of Daventry 0
4419856 2171108 2171108 defendant Horn John   604469 604469 Horn, John, of Daventry, parson of Bradden church 0
4433388 2175199 2175199 defendant Spicer Joan le   604469 604469 Spicer, Joan le, of Daventry, formerly wife of Thomas 1
4435355 2175812 2175812 plaintiff Neubold Richard clerk 604469 604469 Neubold, Richard, of Daventry, clerk 0
4435358 2175813 2175813 plaintiff Neubold Richard clerk 604469 604469 Neubold, Richard, of Daventry, clerk 0
4437921 2181179 2181179 defendant Wilby John   604469 604469 Wilby, John, of Daventry 0
4437923 2181180 2181180 defendant Wylby John   604469 604469 Wylby, John, of Daventry 0
4447775 2184232 2184232 defendant Bere Robert   604469 604469 Bere, Robert, of Daventry 2
4459332 2187969 2187969 plaintiff Rumylowe Peter de   604469 604469 Rumylowe, Peter de, of Daventry 0
4506009 2202392 2202392 defendant Hosyere John   604469 604469 Hosyere, John, of Daventry 1
4506722 2202577 2202577 defendant Waundell John   604469 604469 Waundell, John, of Daventry 1
4517982 2206005 2206005 defendant Clerk Maud   604469 604469 Clerk, Maud, of Daventry, formerly wife of Thomas 0
4517984 2206006 2206006 defendant Edward Robert weaver 604469 604469 Edward, Robert, of Daventry, weaver 0
4517992 2206007 2206007 defendant Curteys John   604469 604469 Curteys, John, of Daventry 6
4517993 2206007 2206007 defendant Curteys Henry   604469 604469 Curteys, Henry, of Daventry 7
4517996 2206007 2206007 defendant Webbe Robert   604469 604469 Webbe, Robert, of Daventry 10
4517997 2206007 2206007 defendant Fyssher Thomas   604469 604469 Fyssher, Thomas, of Daventry 11
4517998 2206007 2206007 defendant Wodeward Henry   604469 604469 Wodeward, Henry, of Daventry 12
4517999 2206007 2206007 defendant Boteler Henry   604469 604469 Boteler, Henry, of Daventry 13
4535417 2211349 2211349 plaintiff Skynner William   604469 604469 Skynner, William, of Daventry 0
4551462 2216396 2216396 defendant Smyth John chaplain 604469 604469 Smyth, John, of Daventry, chaplain 0
4556265 2217901 2217901 defendant Waltham John merchant 604469 604469 Waltham, John, of Daventry, merchant 1
4558293 2218536 2218536 defendant Huntyngdon Thomas   604469 604469 Huntyngdon, Thomas, of Daventry 0
4558294 2218536 2218536 defendant Cleydon Hugh   604469 604469 Cleydon, Hugh, of Daventry 1
4565208 2220692 2220692 plaintiff Skynner William   604469 604469 Skynner, William, of Daventry 0
4566041 2220936 2220936 defendant Deyster Thomas   604469 604469 Deyster, Thomas, of Daventry 0
4580200 2225296 2225296 defendant Pyn Roger   604469 604469 Pyn, Roger, of Daventry 2
4581855 2225770 2225770 defendant Pyryd William   604469 604469 Pyryd, William, of Daventry 1
4589967 2228219 2228219 defendant Hall Richard   604469 604469 Hall, Richard, of Daventry 0
4590173 2228293 2228293 defendant Scoture William   604469 604469 Scoture, William, of Daventry 0
4590174 2228293 2228293 defendant Dallyng John   604469 604469 Dallyng, John, of Daventry 1
4603166 2232197 2232197 defendant Neubold John   604469 604469 Neubold, John, of Daventry 0
4603169 2232198 2232198 defendant Neubold John   604469 604469 Neubold, John, of Daventry 0
4603705 2232347 2232347 plaintiff Wryght William   604469 604469 Wryght, William, of Daventry 0
4605381 2232834 2232834 defendant Horn Simon   604469 604469 Horn, Simon, of Daventry 0
4605383 2232834 2232834 defendant Bakere John   604469 604469 Bakere, John, of Daventry 2
4605390 2232835 2232835 defendant Horn Simon   604469 604469 Horn, Simon, of Daventry 0
4605392 2232835 2232835 defendant Bakere John   604469 604469 Bakere, John, of Daventry 2
4605525 2232850 2232850 defendant Wyllewgby John   604469 604469 Wyllewgby, John, of Daventry 0
4605527 2232850 2232850 defendant Barker John   604469 604469 Barker, John, of Daventry 2
4608335 2233719 2233719 defendant Dyllyng John   604469 604469 Dyllyng, John, of Daventry 0
4610483 2234351 2234351 defendant Cleyton Hugh   604469 604469 Cleyton, Hugh, of Daventry 0
4615489 2235848 2235848 defendant Warde John   604469 604469 Warde, John, of Daventry 0
4619266 2237020 2237020 plaintiff Heywode John   604469 604469 Heywode, John, of Daventry 0
4620234 2237310 2237310 defendant Pope Richard   604469 604469 Pope, Richard, of Daventry 1
4630829 2240532 2240532 plaintiff Sutton Henry   604469 604469 Sutton, Henry, of Daventry 0
4634585 2241669 2241669 defendant Kent William   604469 604469 Kent, William, of Daventry 0
4642583 2243950 2243950 defendant Waundell John   604469 604469 Waundell, John, of Daventry 0
4643223 2244128 2244128 plaintiff Huntyngdon Thomas   604469 604469 Huntyngdon, Thomas, of Daventry 0
4643224 2244128 2244128 plaintiff Willughby John   604469 604469 Willughby, John, of Daventry 1
4643225 2244128 2244128 defendant Edward Robert weaver 604469 604469 Edward, Robert, of Daventry, weaver 0
4646839 2245139 2245139 defendant Claydon Hugh   604469 604469 Claydon, Hugh, of Daventry 0
4652926 2246846 2246846 defendant Dyllyng John butcher 604469 604469 Dyllyng, John, of Daventry, butcher 2
4661259 2249343 2249343 defendant Pope Richard husbandman 604469 604469 Pope, Richard, of Daventry, husbandman 0
4664162 2250277 2250277 defendant Haddon Thomas butcher 604469 604469 Haddon, Thomas, of Daventry, 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);