names

162 rows where place_id = 588674

✎ 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
3588745 1864123 1864123 defendant Wykers Thomas   588674 588674 Wykers, Thomas, of Sevenoke, horse collar maker 2
3595250 1866148 1866148 defendant Hegge Adam weaver 588674 588674 Hegge, Adam, of Sevenoke, weaver 2
3648168 1909822 1909822 defendant Romayne Robert laborer 588674 588674 Romayne, Robert, of Sevenoke, laborer 2
3670548 1916751 1916751 defendant Hunt Robert   588674 588674 Hunt, Robert, of Sevenoke, tallow chandler 0
3670550 1916752 1916752 defendant Peekyn John yeoman 588674 588674 Peekyn, John, of Sevenoke, yeoman 0
3684592 1921312 1921312 defendant Potkyn John yeoman 588674 588674 Potkyn, John, of Sevenoke, yeoman 0
3739636 1938613 1938613 defendant Downe William miller 588674 588674 Downe, William, of Sevenoke, miller 0
3739637 1938613 1938613 defendant Isop Robert laborer 588674 588674 Isop, Robert, of Sevenoke, laborer 1
3739638 1938613 1938613 defendant Baker Robert laborer 588674 588674 Baker, Robert, of Sevenoke, laborer 2
3782993 1952430 1952430 defendant Rychardson Thomas butcher 588674 588674 Rychardson, Thomas, of Sevenoke, butcher 0
3896705 1989107 1989107 defendant Hunte Robert yeoman 588674 588674 Hunte, Robert, of Sevenoke, yeoman 0
3896706 1989107 1989107 defendant Brympton Francis yeoman 588674 588674 Brympton, Francis, of Sevenoke, yeoman 1
3980688 2017855 2017855 defendant Lettyn Cedda painter 588674 588674 Lettyn, Cedda, of Sevenoke, painter 0
4069256 2049292 2049292 defendant Walker Paul laborer 588674 588674 Walker, Paul, of Sevenoke, laborer 1
4069257 2049292 2049292 defendant Medeherst Henry laborer 588674 588674 Medeherst, Henry, of Sevenoke, laborer 2
4069258 2049292 2049292 defendant Mylcam John laborer 588674 588674 Mylcam, John, of Sevenoke, laborer 3
4069259 2049292 2049292 defendant Botley John carpenter 588674 588674 Botley, John, of Sevenoke, carpenter 4
4069260 2049292 2049292 defendant Botley Mathew laborer 588674 588674 Botley, Mathew, of Sevenoke, laborer 5
4069261 2049292 2049292 defendant Whyte William laborer 588674 588674 Whyte, William, of Sevenoke, laborer 6
4069262 2049292 2049292 defendant Skele John laborer 588674 588674 Skele, John, of Sevenoke, laborer 7
4069263 2049292 2049292 defendant Grene Griffin laborer 588674 588674 Grene, Griffin, of Sevenoke, laborer 8
4237753 2108803 2108803 defendant Lamperd William husbandman 588674 588674 Lamperd, William, of Sevenoke, husbandman 0
4237754 2108803 2108803 defendant Lamperd Edward husbandman 588674 588674 Lamperd, Edward, of Sevenoke, husbandman 1
4444538 2183268 2183268 defendant Cranherst Andrew   588674 588674 Cranherst, Andrew, of Sevenoke 5
4582908 2226081 2226081 defendant Scotlond John   588674 588674 Scotlond, John, of Sevenoke 0
4617993 2236635 2236635 plaintiff Gyles William   588674 588674 Gyles, William, of Sevenoke 0
4630649 2240497 2240497 defendant Haukyn John   588674 588674 Haukyn, John, of Sevenoke 1
4630650 2240497 2240497 defendant Brace John   588674 588674 Brace, John, of Sevenoke 2
4630651 2240497 2240497 defendant Peyntour John   588674 588674 Peyntour, John, of Sevenoke 3
4651162 2246368 2246368 defendant Thechere Simon butcher 588674 588674 Thechere, Simon, of Sevenoke, butcher 0
4656856 2248040 2248040 defendant Edward Stephen fuller 588674 588674 Edward, Stephen, of Sevenoke, fuller 0
4664054 2250246 2250246 defendant Taillour Robert ploughman 588674 588674 Taillour, Robert, of Sevenoke, ploughman 0
4674625 2257672 2257672 plaintiff Edward Stephen   588674 588674 Edward, Stephen, of Sevenoke 0
4675036 2257803 2257803 defendant Thecchere Simon butcher 588674 588674 Thecchere, Simon, of Sevenoke, butcher 0
4675449 2257930 2257930 defendant atte Wolle John husbandman 588674 588674 atte Wolle, John, of Sevenoke, husbandman 2
4677058 2258440 2258440 defendant Tayllour Robert ploughman 588674 588674 Tayllour, Robert, of Sevenoke, ploughman 0
4677204 2258488 2258488 defendant Cheriatur John farmer 588674 588674 Cheriatur, John, of Sevenoke, farmer 0
4680701 2259579 2259579 plaintiff Loyd or Hoyd John   588674 588674 Loyd or Hoyd, John, of Sevenoke 0
4681250 2259761 2259761 defendant Haye William husbandman 588674 588674 Haye, William, of Sevenoke, husbandman 0
4686438 2261362 2261362 defendant Alcok Richard butcher 588674 588674 Alcok, Richard, of Sevenoke, butcher 0
4686479 2261376 2261376 defendant Gyles Richard husbandman 588674 588674 Gyles, Richard, of Sevenoke, husbandman 0
4750628 2280671 2280671 defendant Marchall William laborer 588674 588674 Marchall, William, of Sevenoke, laborer 0
4750652 2280681 2280681 defendant Hereward John smith 588674 588674 Hereward, John, of Sevenoke, smith 0
4752779 2281268 2281268 defendant Lyntot John yeoman 588674 588674 Lyntot, John, of Sevenoke, yeoman 3
4779383 2289535 2289535 defendant Dod Thomas husbandman 588674 588674 Dod, Thomas, of Sevenoke, husbandman 0
4779384 2289535 2289535 defendant atte Wode Roger weaver 588674 588674 atte Wode, Roger, of Sevenoke, weaver 1
4779385 2289535 2289535 defendant Merden Ralph husbandman 588674 588674 Merden, Ralph, of Sevenoke, husbandman 2
4779386 2289535 2289535 defendant Thaccher Simon husbandman 588674 588674 Thaccher, Simon, of Sevenoke, husbandman 3
4781347 2290176 2290176 defendant Wyldebor John baker 588674 588674 Wyldebor, John, of Sevenoke, baker 1
4789258 2292700 2292700 defendant Rode William dyer 588674 588674 Rode, William, of Sevenoke, dyer 0
4792215 2293655 2293655 plaintiff Melle John   588674 588674 Melle, John, of Sevenoke 0
4796687 2295115 2295115 defendant Rode William wooder 588674 588674 Rode, William, of Sevenoke, wooder 0
4799030 2295870 2295870 defendant Cristemasse Richard   588674 588674 Cristemasse, Richard, of Sevenoke husbandman 0
4799031 2295870 2295870 defendant Cristemasse William   588674 588674 Cristemasse, William, of Sevenoke husbandman 1
4799033 2295871 2295871 defendant Crouherst Robert husbandman 588674 588674 Crouherst, Robert, of Sevenoke, husbandman 0
4799034 2295871 2295871 defendant Wilkyn John smith 588674 588674 Wilkyn, John, of Sevenoke, smith 1
4814031 2300494 2300494 defendant Michell Robert husbandman 588674 588674 Michell, Robert, of Sevenoke, husbandman 0
4819162 2302072 2302072 defendant Cristemasse Richard   588674 588674 Cristemasse, Richard, of Sevenoke, mason 0
4819176 2302076 2302076 defendant Cristemasse Richard   588674 588674 Cristemasse, Richard, of Sevenoke, mason 0
4821326 2302750 2302750 defendant Grace John butcher 588674 588674 Grace, John, of Sevenoke, butcher 0
4863818 2315655 2315655 defendant Typpyng William husbandman 588674 588674 Typpyng, William, of Sevenoke, husbandman 5
4868414 2317092 2317092 plaintiff Melle John   588674 588674 Melle, John, of Sevenoke 2
4868419 2317093 2317093 plaintiff Melle John   588674 588674 Melle, John, of Sevenoke 2
4871503 2318054 2318054 defendant Wellere alias Barbour Robert yeoman 588674 588674 Wellere alias Barbour, Robert, of Sevenoke, yeoman 0
4871504 2318054 2318054 defendant Grove John husbandman 588674 588674 Grove, John, of Sevenoke, husbandman 1
4874293 2318904 2318904 defendant Michell Robert husbandman 588674 588674 Michell, Robert, of Sevenoke, husbandman 1
4884255 2321983 2321983 defendant Bele John skinner 588674 588674 Bele, John, of Sevenoke, skinner 0
4884256 2321983 2321983 defendant Pette Thomas chandler 588674 588674 Pette, Thomas, of Sevenoke, chandler 1
4885139 2322244 2322244 defendant Gylys Richard laborer 588674 588674 Gylys, Richard, of Sevenoke, laborer 0
4885140 2322244 2322244 defendant Tygherst William laborer 588674 588674 Tygherst, William, of Sevenoke, laborer 1
4885141 2322244 2322244 defendant Grove John wheeler 588674 588674 together with Grove, John, of Sevenoke, wheeler 2
4889510 2323516 2323516 defendant Bele John skinner 588674 588674 Bele, John, of Sevenoke, skinner 0
4889511 2323516 2323516 defendant Pette Thomas chandler 588674 588674 Pette, Thomas, of Sevenoke, chandler 1
4896931 2325691 2325691 defendant atte Pette Thomas chandler 588674 588674 atte Pette, Thomas, of Sevenoke, chandler 0
4896932 2325691 2325691 defendant Bole John skinner 588674 588674 Bole, John, of Sevenoke, skinner 1
4902237 2327309 2327309 defendant atte Pette Thomas chandler 588674 588674 atte Pette, Thomas, of Sevenoke, chandler 0
4902238 2327309 2327309 defendant Bole John skinner 588674 588674 Bole, John, of Sevenoke, skinner 1
4904551 2328033 2328033 defendant Rumshed Nicholas husbandman 588674 588674 Rumshed, Nicholas, of Sevenoke, husbandman 0
4907245 2328830 2328830 defendant Gylys Richard laborer 588674 588674 Gylys, Richard, of Sevenoke, laborer 0
4907246 2328830 2328830 defendant Tygherst William laborer 588674 588674 Tygherst, William, of Sevenoke, laborer 1
4907247 2328830 2328830 defendant Grove John wheeler 588674 588674 Grove, John, of Sevenoke, wheeler 2
4913168 2330615 2330615 defendant Aleyn Richard yeoman 588674 588674 Aleyn, Richard, of Sevenoke, yeoman 0
4917993 2332142 2332142 defendant Wellere Robert husbandman 588674 588674 Wellere, Robert, of Sevenoke, husbandman 1
4918647 2332348 2332348 defendant Bele John husbandman 588674 588674 Bele, John, of Sevenoke, husbandman 0
4921916 2333259 2333259 defendant Walder Richard tiler 588674 588674 Walder, Richard, of Sevenoke, tiler 0
4921917 2333259 2333259 defendant Pode John chandler 588674 588674 Pode, John, of Sevenoke, chandler 1
4921918 2333259 2333259 defendant Alcok John butcher 588674 588674 Alcok, John, of Sevenoke, butcher 2
4935274 2337434 2337434 defendant Northwode John husbandman 588674 588674 Northwode, John, of Sevenoke, husbandman 0
4935275 2337434 2337434 defendant Shepherd Thomas collier 588674 588674 Shepherd, Thomas, of Sevenoke, collier 1
4938477 2338412 2338412 defendant Bele John husbandman 588674 588674 Bele, John, of Sevenoke, husbandman 0
4944234 2340169 2340169 defendant Well Robert laborer 588674 588674 Well, Robert, of Sevenoke, laborer 0
4948996 2341673 2341673 defendant Cristemasse Richard tiler 588674 588674 Cristemasse, Richard, of Sevenoke, tiler 0
4948997 2341673 2341673 defendant Smyth John tailor 588674 588674 Smyth, John, of Sevenoke, tailor 1
4977655 2350283 2350283 defendant Mychell William husbandman 588674 588674 Mychell, William, of Sevenoke, husbandman 1
4977657 2350283 2350283 defendant Haukyn John butcher 588674 588674 Haukyn, John, of Sevenoke, butcher 3
4978444 2350500 2350500 defendant Bele John husbandman 588674 588674 Bele, John, of Sevenoke, husbandman 1
4983253 2351896 2351896 defendant Cristemasse William yeoman 588674 588674 Cristemasse, William, of Sevenoke, yeoman 0
4985299 2352524 2352524 defendant Aleyn Richard husbandman 588674 588674 Aleyn, Richard, of Sevenoke, husbandman 2
5020139 2362778 2362778 defendant Skele John butcher 588674 588674 Skele, John, of Sevenoke, butcher 1
5032017 2366237 2366237 defendant Bele John husbandman 588674 588674 Bele, John, of Sevenoke, 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);