names

143 rows where place_id = 606555

✎ 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
3665658 1915208 1915208 defendant Stoughton John gent 606555 606555 Stoughton, John, of Guildford, gent 0
3667417 1915748 1915748 defendant Ripley Henry husbandman 606555 606555 Ripley, Henry, of Guildford, husbandman 0
3667419 1915749 1915749 defendant Stoughton John gent 606555 606555 Stoughton, John, of Guildford, gent 0
3667476 1915769 1915769 defendant Bowles Thomas   606555 606555 Bowles, Thomas, of Guildford 0
3667478 1915770 1915770 defendant Bowles Thomas   606555 606555 Bowles, Thomas, of Guildford 0
4408015 2167249 2167249 defendant Streete Henry tailor 606555 606555 Streete, Henry, of Guildford, tailor 0
4426747 2173179 2173179 defendant Mareschal John le clerk 606555 606555 Mareschal, John le, of Guildford, clerk 0
4427454 2173422 2173422 defendant Baillif Thomas   606555 606555 Baillif, Thomas, of Guildford 3
4443926 2183070 2183070 plaintiff Chesenhale Robert   606555 606555 Chesenhale, Robert, of Guildford 0
4467748 2190591 2190591 defendant Crosse John   606555 606555 Crosse, John, of Guildford 0
4472224 2191980 2191980 defendant Colas Henry   606555 606555 Colas, Henry, of Guildford 0
4517321 2205817 2205817 defendant Sengelton Joan   606555 606555 Sengelton, Joan, of Guildford, formerly wife of John 1
4533491 2210743 2210743 defendant Vynt Robert   606555 606555 Vynt, Robert, of Guildford 0
4554097 2217206 2217206 defendant Farnham John   606555 606555 Farnham, John, of Guildford 0
4558801 2218711 2218711 defendant Brain Richard chandler 606555 606555 Brain, Richard, of Guildford, chandler 0
4561091 2219422 2219422 defendant Vynt Robert   606555 606555 Vynt, Robert, of Guildford 0
4572628 2222976 2222976 defendant Stoghton John   606555 606555 Stoghton, John, of Guildford 0
4577776 2224557 2224557 plaintiff Chamberlayn Thomas   606555 606555 Chamberlayn, Thomas, of Guildford 0
4577777 2224557 2224557 defendant Dubeneye John   606555 606555 Dubeneye, John, of Guildford 0
4596366 2230116 2230116 plaintiff Russell John sawyer 606555 606555 Russell, John, of Guildford, sawyer 0
4612916 2235100 2235100 defendant Waterman Robert   606555 606555 Waterman, Robert, of Guildford 1
4631549 2240760 2240760 defendant (not given) Richard prior of Graveney 606555 606555 Graveney, Richard, of Guildford, prior of the fraternity 0
4642697 2243979 2243979 plaintiff Russell John sawyer 606555 606555 Russell, John, of Guildford, sawyer 3
4650649 2246208 2246208 defendant Nanvan William tailor 606555 606555 Nanvan, William, of Guildford, tailor 0
4673340 2257300 2257300 defendant Gilberd Henry husbandman 606555 606555 Gilberd, Henry, of Guildford, husbandman 0
4673341 2257300 2257300 defendant Neweton Stephen chaplain 606555 606555 Neweton, Stephen, of Guildford, chaplain 1
4676946 2258408 2258408 plaintiff Growe Richard   606555 606555 Growe, Richard, of Guildford 0
4676947 2258408 2258408 defendant Cradeler Richard husbandman 606555 606555 Cradeler, Richard, of Guildford, husbandman 0
4683070 2260321 2260321 defendant Grovere John, junior husbandman 606555 606555 Grovere, John, junior, of Guildford, husbandman 0
4692549 2263185 2263185 plaintiff atte Lee John   606555 606555 atte Lee, John, of Guildford 0
4695272 2264002 2264002 defendant Butt Henry painter 606555 606555 Butt, Henry, of Guildford, painter 0
4707982 2267867 2267867 defendant Broke Walter gent 606555 606555 Broke, Walter, of Guildford, gent 0
4710089 2268511 2268511 defendant Kyngeston John (legal representative) 606555 606555 Kyngeston, John, of Guildford, baker, executors of 0
4710090 2268511 2268511 defendant Dogell Thomas baker 606555 606555 (Dogell, Thomas, of Guildford, baker 1
4710091 2268511 2268511 defendant Wylde Thomas baker 606555 606555 Wylde, Thomas, of Guildford, baker 2
4713310 2269489 2269489 defendant But Henry dyer 606555 606555 But, Henry, of Guildford, dyer 0
4713311 2269489 2269489 defendant Syre John dyer 606555 606555 Syre, John, of Guildford, dyer 1
4715612 2270208 2270208 defendant Barbour Robert husbandman 606555 606555 Barbour, Robert, of Guildford, husbandman 3
4718035 2270981 2270981 plaintiff atte Hoo William   606555 606555 atte Hoo, William, of Guildford 0
4731149 2274942 2274942 defendant Clerk Richard tailor 606555 606555 Clerk, Richard, of Guildford, tailor 0
4731492 2275050 2275050 defendant Tyngewyk William husbandman 606555 606555 Tyngewyk, William, of Guildford, husbandman 0
4731493 2275050 2275050 defendant Huntesford Richard shoemaker 606555 606555 together with Huntesford, Richard, of Guildford, shoemaker 1
4738396 2277105 2277105 defendant Barbour Robert   606555 606555 Barbour, Robert, of Guildford, bailiff 1
4811277 2299636 2299636 defendant Mugge Geoffrey gent 606555 606555 Mugge, Geoffrey, of Guildford, gent 0
4812548 2300041 2300041 defendant Eton Richard gent 606555 606555 Eton, Richard, of Guildford, gent 1
4812549 2300041 2300041 defendant Hippepron John gent 606555 606555 Hippepron, John, of Guildford, gent 2
4825473 2304012 2304012 defendant Fraunceys Thomas yeoman 606555 606555 Fraunceys, Thomas, of Guildford, yeoman 0
4825474 2304012 2304012 defendant Hosyer Robert hosier 606555 606555 Hosyer, Robert, of Guildford, hosier 1
4825475 2304012 2304012 defendant Stracy William yeoman 606555 606555 Stracy, William, of Guildford, yeoman 2
4825575 2304038 2304038 defendant Taillour William   606555 606555 Taillour, William, of Guildford, bailiff 2
4826651 2304370 2304370 defendant Hayward Henry dyer 606555 606555 Hayward, Henry, of Guildford, dyer 2
4826678 2304376 2304376 defendant Hayward Henry dyer 606555 606555 Hayward, Henry, of Guildford, dyer 2
4827990 2304802 2304802 defendant Dogell Thomas baker 606555 606555 Dogell, Thomas, of Guildford, baker 3
4828533 2304964 2304964 defendant Danhurst Robert gent 606555 606555 Danhurst, Robert, of Guildford, gent 2
4828539 2304965 2304965 defendant Manery Walter weaver 606555 606555 Manery, Walter, of Guildford, weaver 3
4833628 2306523 2306523 defendant Cosyngton Stephen gent 606555 606555 Cosyngton, Stephen, of Guildford, esq OR Mathewe, William, of London, gent 0
4841487 2308868 2308868 defendant Skelton John baker 606555 606555 Skelton, John, of Guildford, baker 0
4841488 2308868 2308868 defendant Skelton Thomas baker 606555 606555 Skelton, Thomas, of Guildford, baker 1
4844400 2309760 2309760 defendant Turnour Thomas ostler 606555 606555 Turnour, Thomas, of Guildford, ostler 0
4845448 2310089 2310089 defendant Kember Thomas baker 606555 606555 Kember, Thomas, of Guildford, baker 0
4845449 2310089 2310089 defendant Wardale John hosteler 606555 606555 Wardale, John, of Guildford, hosteler 1
4845450 2310089 2310089 defendant Burry John tanner 606555 606555 Burry, John, of Guildford, tanner 2
4845792 2310195 2310195 defendant Kyngeston John chapman 606555 606555 Kyngeston, John, of Guildford, chapman 0
4846514 2310418 2310418 defendant Shawe Richard   606555 606555 Shawe, Richard, of Guildford, inland fish seller 0
4846515 2310418 2310418 defendant Godard John   606555 606555 Godard, John, of Guildford, inland fish seller 1
4847280 2310651 2310651 defendant Janyn Thomas dyer 606555 606555 Janyn, Thomas, of Guildford, dyer 0
4847620 2310746 2310746 defendant Manary Walter weaver 606555 606555 Manary, Walter, of Guildford, weaver 2
4849545 2311332 2311332 defendant Mawer Gregory   606555 606555 Mawer, Gregory, of Guildford, coverlet maker 0
4852018 2312063 2312063 defendant Skelton Thomas laborer 606555 606555 Skelton, Thomas, of Guildford, laborer 0
4852019 2312063 2312063 defendant Danherst Geoffrey   606555 606555 Danherst, Geoffrey, of Guildford, single man 1
4852927 2312338 2312338 defendant Hayward Henry dyer 606555 606555 Hayward, Henry, of Guildford, dyer 0
4918257 2332231 2332231 defendant Mugge Geoffrey (legal representative) 606555 606555 Mugge, Geoffrey, of Guildford, executor of 0
4918258 2332231 2332231 defendant Jenyn John yeoman 606555 606555 Jenyn, John, of Guildford, yeoman 1
4918260 2332232 2332232 defendant Mugge Geoffrey (legal representative) 606555 606555 Mugge, Geoffrey, of Guildford, executor of 0
4918261 2332232 2332232 defendant Jenyn John yeoman 606555 606555 Jenyn, John, of Guildford, yeoman 1
4930959 2336079 2336079 defendant Buntyng John husbandman 606555 606555 Buntyng, John, of Guildford, husbandman 0
4930961 2336079 2336079 defendant Goryng John, junior   606555 606555 Goryng, John, junior, of Guildford, groom 2
4930962 2336079 2336079 defendant Spygot John husbandman 606555 606555 Spygot, John, of Guildford, husbandman 3
4932045 2336413 2336413 defendant Mugge Geoffrey (legal representative) 606555 606555 Mugge, Geoffrey, of Guildford, gent, administrator of 0
4998593 2356467 2356467 defendant Thrisk William husbandman 606555 606555 Thrisk, William, of Guildford, husbandman 0
5001971 2357477 2357477 defendant Saundre Robert fuller 606555 606555 Saundre, Robert, of Guildford, fuller 0
5001972 2357477 2357477 defendant Pernesche Henry yeoman 606555 606555 Pernesche, Henry, of Guildford, yeoman 1
5007574 2359112 2359112 defendant Sturmyn John draper 606555 606555 Sturmyn, John, of Guildford, draper 0
5009083 2359537 2359537 defendant Buntyng John yeoman 606555 606555 Buntyng, John, of Guildford, yeoman 2
5009088 2359538 2359538 defendant Buntyng John yeoman 606555 606555 Buntyng, John, of Guildford, yeoman 2
5048465 2371180 2371180 plaintiff Rodes William dyer 606555 606555 Rodes, William, of Guildford, dyer 0
5051548 2372082 2372082 plaintiff Whyler Richard   606555 606555 Whyler, Richard, of Guildford 0
5129941 2395247 2395247 plaintiff Didlesden Thomas fisher 606555 606555 Didlesden, Thomas, of Guildford, fisher 0
5129942 2395247 2395247 plaintiff Fraunceys Geoffrey shoemaker 606555 606555 Fraunceys, Geoffrey, of Guildford, shoemaker 1
5130801 2395492 2395492 defendant Dydlesdon Richard husbandman 606555 606555 Dydlesdon, Richard, of Guildford, husbandman 0
5136498 2397191 2397191 defendant Edyngton Thomas barber 606555 606555 Edyngton, Thomas, of Guildford, barber 3
5138049 2397632 2397632 defendant Rodes William dyer 606555 606555 Rodes, William, of Guildford, dyer 4
5144501 2399551 2399551 defendant Wokkyng John yeoman 606555 606555 Wokkyng, John, of Guildford, yeoman 4
5151312 2401533 2401533 defendant Grover James chapman 606555 606555 Grover, James, of Guildford, chapman 2
5157674 2403375 2403375 defendant Russell Joan widow 606555 606555 Russell, Joan, of Guildford, widow 0
5158719 2403670 2403670 defendant Peverey John (legal representative) 606555 606555 Peverey, John, of Guildford, dyer, administrator of 3
5158720 2403670 2403670 defendant Rodes William dyer 606555 606555 Rodes, William, of Guildford, dyer 4
5159159 2403796 2403796 plaintiff Rodes William   606555 606555 Rodes, William, of Guildford 0
5163539 2405067 2405067 defendant Shawe Richard yeoman 606555 606555 Shawe, Richard, of Guildford, yeoman 1
5168778 2406599 2406599 defendant (not given) William prior of Whalle 606555 606555 Whalle, William, of Guildford, prior of New Place or Newark 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);