names

140 rows where place_id = 588243

✎ 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
3593823 1865708 1865708 defendant Richeman alias Cammell John butcher 588243 588243 Richeman alias Cammell, John, of Chepyng Toryton, butcher 0
3654479 1911660 1911660 defendant Bowdon William   588243 588243 Bowdon, William, of Chepyng Toryton, shoe maker 0
3828702 1966853 1966853 defendant More alias Ellys John butcher 588243 588243 More alias Ellys, John, of Chepyng Toryton, butcher 1
4545431 2214494 2214494 defendant Webber David   588243 588243 Webber, David, of Chepyng Toryton 2
4545432 2214494 2214494 defendant Smyth William   588243 588243 Smyth, William, of Chepyng Toryton 3
4649751 2245950 2245950 defendant Salman John   588243 588243 Salman, John, of Chepyng Toryton 2
4649752 2245950 2245950 defendant Sadeler John   588243 588243 Sadeler, John, of Chepyng Toryton 3
4652037 2246571 2246571 defendant Gene William husbandman 588243 588243 Gene, William, of Chepyng Toryton, husbandman 1
4654563 2247306 2247306 defendant Gylys Joan   588243 588243 Gylys, Joan, of Chepyng Toryton, servant 0
4654570 2247309 2247309 defendant Westlegh Walter tanner 588243 588243 Westlegh, Walter, of Chepyng Toryton, tanner 0
4657891 2248354 2248354 plaintiff Colyn Alice   588243 588243 Colyn, Alice, of Chepyng Toryton 0
4660793 2249198 2249198 defendant Elys John smith 588243 588243 Elys, John, of Chepyng Toryton, smith 2
4663508 2250061 2250061 defendant Brode Henry loader 588243 588243 Brode, Henry, of Chepyng Toryton, loader 1
4663511 2250062 2250062 defendant Brode Henry loader 588243 588243 Brode, Henry, of Chepyng Toryton, loader 1
4689756 2262358 2262358 defendant Northwyk Thomas yeoman 588243 588243 Northwyk, Thomas, of Chepyng Toryton, yeoman 0
4689758 2262358 2262358 defendant Bilhole John shoemaker 588243 588243 Bilhole, John, of Chepyng Toryton, shoemaker 2
4739981 2277584 2277584 defendant Maryn Roger merchant 588243 588243 Maryn, Roger, of Chepyng Toryton, merchant 0
4779396 2289539 2289539 defendant Blynche William gent 588243 588243 Blynche, William, of Chepyng Toryton, gent 0
4779397 2289539 2289539 defendant Blynche John gent 588243 588243 Blynche, John, of Chepyng Toryton, gent 1
4784794 2291251 2291251 defendant Passer Walter husbandman 588243 588243 Passer, Walter, of Chepyng Toryton, husbandman 1
4784801 2291253 2291253 defendant Bilhole John, senior cordwainer 588243 588243 Bilhole, John, senior, of Chepyng Toryton, cordwainer 0
4786654 2291879 2291879 defendant Blynche William gent 588243 588243 Blynche, William, of Chepyng Toryton, gent 0
4786655 2291879 2291879 defendant Blynche John gent 588243 588243 Blynche, John, of Chepyng Toryton, gent 1
4786657 2291880 2291880 defendant Blynche William gent 588243 588243 Blynche, William, of Chepyng Toryton, gent 0
4786658 2291880 2291880 defendant Blynche John gent 588243 588243 Blynche, John, of Chepyng Toryton, gent 1
4790328 2293059 2293059 defendant Westelegh Richard, senior tanner 588243 588243 Westelegh, Richard, senior, of Chepyng Toryton, tanner 0
4798961 2295847 2295847 defendant Neel Walter husbandman 588243 588243 Neel, Walter, of Chepyng Toryton, husbandman 0
4801986 2296806 2296806 defendant Morley John brasier 588243 588243 Morley, John, of Chepyng Toryton, brasier 0
4904054 2327883 2327883 defendant Neweton Henry mercer 588243 588243 Neweton, Henry, of Chepyng Toryton, mercer 0
4904055 2327883 2327883 defendant Graddon Walter shoemaker 588243 588243 Graddon, Walter, of Chepyng Toryton, shoemaker 1
4913960 2330876 2330876 defendant Colyn alias Stappe Nicholas husbandman 588243 588243 Colyn alias Stappe, Nicholas, of Chepyng Toryton, husbandman 0
4917359 2331942 2331942 defendant Bylholle John gent 588243 588243 Bylholle, John, of Chepyng Toryton, gent 0
4917362 2331943 2331943 defendant Bilholle John gent 588243 588243 Bilholle, John, of Chepyng Toryton, gent 1
4930995 2336092 2336092 defendant Morles John   588243 588243 Morles, John, of Chepyng Toryton, brass worker 0
4930996 2336092 2336092 defendant Edward Richard husbandman 588243 588243 Edward, Richard, of Chepyng Toryton, husbandman 1
4936366 2337767 2337767 defendant Crewys Ranulph gent 588243 588243 Crewys, Ranulph, of Chepyng Toryton, gent 0
4936370 2337768 2337768 defendant Crewys Ranulph gent 588243 588243 Crewys, Ranulph, of Chepyng Toryton, gent 0
4957760 2344292 2344292 defendant Morleys John brasier 588243 588243 Morleys, John, of Chepyng Toryton, brasier 0
4957761 2344292 2344292 defendant Russell John schoolmaster 588243 588243 Russell, John, of Chepyng Toryton, schoolmaster 1
4957762 2344292 2344292 defendant Blake John   588243 588243 Blake, John, of Chepyng Toryton 2
4957763 2344292 2344292 defendant Meter Robert chapman 588243 588243 Meter, Robert, of Chepyng Toryton, chapman 3
4961216 2345322 2345322 defendant Whyte Richard gent 588243 588243 Whyte, Richard, of Chepyng Toryton, gent 0
4961217 2345322 2345322 defendant Smyth John smith 588243 588243 Smyth, John, of Chepyng Toryton, smith 1
4961218 2345322 2345322 defendant Somer John smith 588243 588243 Somer, John, of Chepyng Toryton, smith 2
4961219 2345322 2345322 defendant Trewyk Nicholas cutler 588243 588243 Trewyk, Nicholas, of Chepyng Toryton, cutler 3
4961220 2345322 2345322 defendant Pedeler Robert tanner 588243 588243 Pedeler, Robert, of Chepyng Toryton, tanner 4
4977257 2350151 2350151 defendant Hayward John tanner 588243 588243 Hayward, John, of Chepyng Toryton, tanner 0
5020002 2362731 2362731 defendant Fyrlerd John chaplain 588243 588243 Fyrlerd, John, of Chepyng Toryton, chaplain 0
5023738 2363846 2363846 defendant Fyrlard or Furlard John chaplain 588243 588243 Fyrlard or Furlard, John, of Chepyng Toryton, chaplain 0
5024201 2363992 2363992 defendant Pope John cordwainer 588243 588243 Pope, John, of Chepyng Toryton, cordwainer 0
5024203 2363993 2363993 defendant Rolle John cordwainer 588243 588243 Rolle, John, of Chepyng Toryton, cordwainer 0
5024205 2363994 2363994 defendant Rolle John cordwainer 588243 588243 Rolle, John, of Chepyng Toryton, cordwainer 0
5027754 2364995 2364995 defendant Maunsell Roger yeoman 588243 588243 Maunsell, Roger, of Chepyng Toryton, yeoman 0
5028467 2365198 2365198 defendant Martyn John yeoman 588243 588243 Martyn, John, of Chepyng Toryton, yeoman 0
5028468 2365198 2365198 defendant William Richard skinner 588243 588243 William, Richard, of Chepyng Toryton, skinner 1
5028470 2365199 2365199 defendant Martyn John yeoman 588243 588243 Martyn, John, of Chepyng Toryton, yeoman 0
5028471 2365199 2365199 defendant William Richard skinner 588243 588243 William, Richard, of Chepyng Toryton, skinner 1
5028841 2365311 2365311 defendant Fyrlerd John chaplain 588243 588243 Fyrlerd, John, of Chepyng Toryton, chaplain 0
5028843 2365312 2365312 defendant Waleys Roger scrivener 588243 588243 Waleys, Roger, of Chepyng Toryton, scrivener 0
5028844 2365312 2365312 defendant Somer John smith 588243 588243 Somer, John, of Chepyng Toryton, smith 1
5029813 2365594 2365594 defendant Adam Richard laborer 588243 588243 Adam, Richard, of Chepyng Toryton, laborer 0
5029814 2365594 2365594 defendant Colle John tanner 588243 588243 Colle, John, of Chepyng Toryton, tanner 1
5029816 2365594 2365594 defendant William Richard skinner 588243 588243 William, Richard, of Chepyng Toryton, skinner 3
5031883 2366197 2366197 defendant Fyrlerd John chaplain 588243 588243 Fyrlerd, John, of Chepyng Toryton, chaplain 0
5037216 2367753 2367753 defendant Hoo Richard chapman 588243 588243 Hoo, Richard, of Chepyng Toryton, chapman 1
5037403 2367809 2367809 defendant Gate William laborer 588243 588243 Gate, William, of Chepyng Toryton, laborer 0
5037405 2367809 2367809 defendant Drewe Richard smith 588243 588243 Drewe, Richard, of Chepyng Toryton, smith 2
5039532 2368472 2368472 defendant Tayller Thomas glover 588243 588243 Tayller, Thomas, of Chepyng Toryton, glover 0
5050219 2371686 2371686 defendant Neweton Henry mercer 588243 588243 Neweton, Henry, of Chepyng Toryton, mercer 0
5056663 2373564 2373564 defendant Stapylton Robert butcher 588243 588243 Stapylton, Robert, of Chepyng Toryton, butcher 0
5056664 2373564 2373564 defendant Rolle John tanner 588243 588243 together with Rolle, John, of Chepyng Toryton, tanner 1
5063247 2375539 2375539 defendant Redewyn David tanner 588243 588243 Redewyn, David, of Chepyng Toryton, tanner 0
5077701 2379825 2379825 defendant Downe William mercer 588243 588243 Downe, William, of Chepyng Toryton, mercer 0
5080090 2380529 2380529 defendant Chambroun William schoolmaster 588243 588243 Chambroun, William, of Chepyng Toryton, schoolmaster 1
5089475 2383292 2383292 defendant Hayward John tanner 588243 588243 Hayward, John, of Chepyng Toryton, tanner 1
5095306 2385046 2385046 defendant Dodewyll John husbandman 588243 588243 Dodewyll, John, of Chepyng Toryton, husbandman 0
5095349 2385061 2385061 defendant Cok John chaplain 588243 588243 Cok, John, of Chepyng Toryton, chaplain 0
5095350 2385061 2385061 defendant William John chaplain 588243 588243 William, John, of Chepyng Toryton, chaplain 1
5114946 2390787 2390787 defendant Deccombe John mercer 588243 588243 Deccombe, John, of Chepyng Toryton, mercer 1
5114948 2390787 2390787 defendant Neuton Henry mercer 588243 588243 Neuton, Henry, of Chepyng Toryton, mercer 3
5135410 2396865 2396865 defendant Howe John fuller of cloth 588243 588243 Howe, John, of Chepyng Toryton, fuller of cloth 1
5223169 2422486 2422486 defendant Rolle John tanner 588243 588243 Rolle, John, of Chepyng Toryton, tanner 0
5223170 2422486 2422486 defendant Arche William yeoman 588243 588243 Arche, William, of Chepyng Toryton, yeoman 1
5223171 2422486 2422486 defendant White Richard gent 588243 588243 White, Richard, of Chepyng Toryton, gent 2
5223172 2422486 2422486 defendant Alforde John yeoman 588243 588243 Alforde, John, of Chepyng Toryton, yeoman 3
5223173 2422486 2422486 defendant Kempe William husbandman 588243 588243 Kempe, William, of Chepyng Toryton, husbandman 4
5223174 2422486 2422486 defendant Chamber William schoolmaster 588243 588243 Chamber, William, of Chepyng Toryton, schoolmaster 5
5223175 2422486 2422486 defendant Jesse Ralph yeoman 588243 588243 Jesse, Ralph, of Chepyng Toryton, yeoman 6
5223176 2422486 2422486 defendant Sherme Thomas yeoman 588243 588243 Sherme, Thomas, of Chepyng Toryton, yeoman 7
5223177 2422486 2422486 defendant Crewys Thomas yeoman 588243 588243 Crewys, Thomas, of Chepyng Toryton, yeoman 8
5223178 2422486 2422486 defendant Antony John yeoman 588243 588243 Antony, John, of Chepyng Toryton, yeoman 9
5224413 2422816 2422816 defendant Trote Thomas   588243 588243 Trote, Thomas, of Chepyng Toryton, soap maker 1
5238389 2426816 2426816 defendant Alforthe William husbandman 588243 588243 Alforthe, William, of Chepyng Toryton, husbandman 3
5244670 2428621 2428621 defendant Bele John tailor 588243 588243 Bele, John, of Chepyng Toryton, tailor 0
5244672 2428622 2428622 defendant Foxcombe John yeoman 588243 588243 Foxcombe, John, of Chepyng Toryton, yeoman 0
5244673 2428622 2428622 defendant Beare John husbandman 588243 588243 Beare, John, of Chepyng Toryton, husbandman 1
5244994 2428711 2428711 defendant Penpoll Sybil widow 588243 588243 Penpoll, Sybil, of Chepyng Toryton, widow 0
5244995 2428711 2428711 defendant Penpoll William   588243 588243 Penpoll, William, of Chepyng Toryton, franklin 1
5244996 2428711 2428711 defendant Alford William husbandman 588243 588243 Alford, William, of Chepyng Toryton, husbandman 2
5260698 2433470 2433470 defendant Lorymer John shoemaker 588243 588243 Lorymer, John, of Chepyng Toryton, shoemaker 2

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);