names

49 rows where place_id = 638396

✎ 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
3842224 1971112 1971112 defendant Gyles William husbandman 638396 638396 Gyles, William, of Est Coker, husbandman 1
3861704 1977377 1977377 plaintiff Ganet James   638396 638396 Ganet, James, of Est Coker, administrators of 0
3909980 1993645 1993645 defendant Cooke alias Crewdell William husbandman 638396 638396 Cooke alias Crewdell, William, of Est Coker, husbandman 1
3951737 2007665 2007665 defendant Whyppyng William butcher 638396 638396 Whyppyng, William, of Est Coker, butcher 0
3957365 2009641 2009641 defendant Myddelton John gent 638396 638396 Myddelton, John, of Est Coker, gent 0
3973887 2015435 2015435 plaintiff Hambridge Richard   638396 638396 Hambridge, Richard, of Est Coker 0
3991460 2021698 2021698 defendant Hambridge Richard gent 638396 638396 Hambridge, Richard, of Est Coker, gent 0
4058635 2045478 2045478 plaintiff Clarke Edward tailor 638396 638396 Clarke, Edward, of Est Coker, tailor 0
4136063 2073239 2073239 defendant Longe Anthony husbandman 638396 638396 Longe, Anthony, of East Cooker, husbandman 0
4136064 2073239 2073239 defendant Williams John husbandman 638396 638396 Williams, John, of East Cooker, husbandman 1
4173062 2086034 2086034 defendant Wyllyams John yeoman 638396 638396 Wyllyams, John, of East Coker, yeoman 0
4229210 2105700 2105700 defendant Williams Thomas   638396 638396 Williams, Thomas, of Est Coker yeoman 1
4229214 2105701 2105701 defendant Penney Giles gent 638396 638396 Penney, Giles, of Est Coker, gent 1
4229215 2105701 2105701 defendant Williams Thomas yeoman 638396 638396 Williams, Thomas, of Est Coker, yeoman 2
4264174 2117667 2117667 defendant Anketyll Christopher (legal representative) 638396 638396 Anketyll, Christopher, of East Almer, esq, administratrix of 1
4291720 2127115 2127115 defendant Penney Giles esq 638396 638396 Penney, Giles, of East Coker, or of Weston, Corscombe, Dorset, esq 0
4291963 2127202 2127202 defendant Danyell William husbandman 638396 638396 Danyell, William, of Est Coker, husbandman 0
4291964 2127202 2127202 defendant Gyles John husbandman 638396 638396 Gyles, John, of East Coker, husbandman 1
4317284 2136159 2136159 defendant Gyles Michael husbandman 638396 638396 Gyles, Michael, of East Coker, husbandman 0
4362636 2151695 2151695 defendant Williams Thomas yeoman 638396 638396 Williams, Thomas, of East Coker, yeoman 0
4374012 2155776 2155776 defendant Gyles Henry husbandman 638396 638396 Gyles, Henry, of East Coker, husbandman 0
4459918 2188158 2188158 plaintiff Scot John   638396 638396 Scot, John, of Est Coker 0
4506224 2202448 2202448 defendant Bardeman Peter   638396 638396 Bardeman, Peter, of Est 6
4622631 2238056 2238056 defendant Benet Richard   638396 638396 Benet, Richard, of East Coker 1
4656675 2247983 2247983 defendant Merssh John   638396 638396 Merssh, John, of Est Coker, mason 0
4701554 2265879 2265879 defendant Bernard Hugh butcher 638396 638396 Bernard, Hugh, of East Coker, butcher 2
4729898 2274558 2274558 defendant Care Richard husbandman 638396 638396 Care, Richard, of East Coker, husbandman 0
4733090 2275527 2275527 defendant Newe William husbandman 638396 638396 Newe, William, of East Coker, husbandman 0
4759955 2283451 2283451 defendant Adekyns Nicholas chapman 638396 638396 Adekyns, Nicholas, of East Coker, chapman 0
4759958 2283452 2283452 defendant Adekyns Nicholas chapman 638396 638396 Adekyns, Nicholas, of East Coker, chapman 0
4817433 2301541 2301541 defendant Uphill Thomas husbandman 638396 638396 Uphill, Thomas, of Est Coker, husbandman 1
4817434 2301541 2301541 defendant Clerk Richard husbandman 638396 638396 Clerk, Richard, of East Coker, husbandman 2
4843264 2309410 2309410 defendant Dene John husbandman 638396 638396 Dene, John, of East Coker, husbandman 1
4885284 2322286 2322286 defendant Ganat Nicholas husbandman 638396 638396 Ganat, Nicholas, of Est Coker, husbandman 4
4900364 2326751 2326751 defendant Cokkes John husbandman 638396 638396 Cokkes, John, of Est Coker, husbandman 0
4942330 2339588 2339588 defendant Sondon Robert chapman 638396 638396 Sondon, Robert, of Est Coker, chapman 0
4943227 2339851 2339851 defendant Warner John husbandman 638396 638396 Warner, John, of Est Coker, husbandman 2
4951186 2342335 2342335 defendant Sondon Robert chapman 638396 638396 Sondon, Robert, of Est Coker, chapman 0
4974780 2349427 2349427 defendant Aleyn John husbandman 638396 638396 Aleyn, John, of Est Coker, husbandman 1
5025013 2364215 2364215 defendant Cokkes John, junior husbandman 638396 638396 Cokkes, John, junior, of Est Coker, husbandman 4
5103018 2387305 2387305 defendant Payn Stephen husbandman 638396 638396 Payn, Stephen, of Est Coker, husbandman 0
5191737 2413318 2413318 defendant Hymerford Robert gent 638396 638396 Hymerford, Robert, of East Coker, gent 0
5191738 2413318 2413318 defendant Fawyn Nicholas yeoman 638396 638396 Fawyn, Nicholas, of East Coker, yeoman 1
5257028 2432325 2432325 defendant Persele Robert clerk 638396 638396 Persele, Robert, of Est Coker, clerk 0
5285916 2440896 2440896 defendant Hemerford John gent 638396 638396 Hemerford, John, of Est Coker, gent 0
5320161 2451120 2451120 plaintiff Hymerford John esq 638396 638396 Hymerford, John, of Est Coker, esq 0
5320178 2451124 2451124 plaintiff Hymerford John, senior esq 638396 638396 Hymerford, John, senior, of Est Coker, esq 0
5445525 2488559 2488559 defendant Richeman Edmund yeoman 638396 638396 Richeman, Edmund, of East Harman, yeoman 2
5546848 2519082 2519082 defendant Michell John gent 638396 638396 Michell, John, of Est Coker, gent 1

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