names

88 rows where place_id = 592997

✎ 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
3609868 1870757 1870757 defendant Harryes John   592997 592997 Harryes, John, of Wedmore 1
3623335 1874829 1874829 defendant Harrys John yeoman or court holder 592997 592997 Harrys, John, of Wedmore, yeoman or court holder 0
3709983 1929431 1929431 defendant Reve John husbandman 592997 592997 Reve, John, of Wedmore, husbandman 4
3712433 1930205 1930205 defendant Montegewe Richard chapman 592997 592997 Montegewe, Richard, of Wedmore, chapman 1
3712769 1930311 1930311 defendant Popham John, junior husbandman 592997 592997 Popham, John, junior, of Wedmore, husbandman 1
3836696 1969376 1969376 defendant Brownyng John yeoman 592997 592997 Brownyng, John, of Wedmore, yeoman 1
3836697 1969376 1969376 defendant Felcher Robert husbandman 592997 592997 Felcher, Robert, of Wedmore, husbandman 2
3858477 1976312 1976312 defendant Lamberd John smith 592997 592997 Lamberd, John, of Wedmore, smith 0
3869252 1979959 1979959 defendant Popham John husbandman 592997 592997 Popham, John, of Wedmore, husbandman 0
3869253 1979959 1979959 defendant Voele John, senior husbandman 592997 592997 Voele, John, senior, of Wedmore, husbandman 1
3869255 1979960 1979960 defendant Vowlys John, senior husbandman 592997 592997 Vowlys, John, senior, of Wedmore, husbandman 0
3881092 1983946 1983946 defendant Lamberde John husbandman 592997 592997 Lamberde, John, of Wedmore, husbandman 2
3885754 1985488 1985488 defendant Pryddy Robert husbandman 592997 592997 Pryddy, Robert, of Wedmore, husbandman 0
3920821 1997309 1997309 defendant Algar Robert smith 592997 592997 Algar, Robert, of Wedmore, smith 3
3926083 1999044 1999044 defendant Lambard John yeoman 592997 592997 Lambard, John, of Wedmore, yeoman 0
3937876 2003000 2003000 defendant Parker John husbandman 592997 592997 Parker, John, of Wedmore, husbandman 0
3947368 2006152 2006152 defendant Fyssher John yeoman 592997 592997 Fyssher, John, of Wedmore, yeoman 0
3952585 2007975 2007975 plaintiff Holbroke Flora widow 592997 592997 Holbroke, Flora, of Wedmore, widow 0
3952586 2007975 2007975 defendant Lamberde or Lambert John yeoman 592997 592997 Lamberde or Lambert, John, of Wedmore, yeoman 0
3960390 2010731 2010731 defendant Broughton George gent 592997 592997 Broughton, George, of Wedmore, gent 0
3968350 2013562 2013562 defendant Cardemaker John glover 592997 592997 Cardemaker, John, of Wedmore, glover 1
4002904 2025807 2025807 defendant Thurston John husbandman 592997 592997 Thurston, John, of Wedmore, husbandman 1
4023708 2033185 2033185 defendant Voules Walter husbandman 592997 592997 Voules, Walter, of Wedmore, husbandman 1
4023715 2033186 2033186 defendant Voules Walter husbandman 592997 592997 Voules, Walter, of Wedmore, husbandman 1
4055984 2044520 2044520 defendant Ingram John butcher 592997 592997 Ingram, John, of Wedmore, butcher 1
4067966 2048850 2048850 defendant Bustell John husbandman 592997 592997 Bustell, John, of Wedmore, husbandman 0
4067967 2048850 2048850 defendant Councell Richard husbandman 592997 592997 Councell, Richard, of Wedmore, husbandman 1
4144948 2076393 2076393 defendant Fowen John husbandman 592997 592997 Fowen, John, of Wedmore, husbandman 1
4145729 2076659 2076659 defendant Pewe Edward yeoman 592997 592997 Pewe, Edward, of Wedmore, yeoman 1
4148690 2077665 2077665 defendant Fowles Walter husbandman 592997 592997 Fowles, Walter, of Wedmore, husbandman 0
4190120 2092049 2092049 defendant Ewyn Clement husbandman 592997 592997 Ewyn, Clement, of Wedmore, husbandman 1
4218792 2102071 2102071 defendant Kyne William gent 592997 592997 Kyne, William, of Wedmore, gent 0
4251152 2113362 2113362 defendant Lancaster Richard husbandman 592997 592997 Lancaster, Richard, of Wedmore, husbandman 1
4283811 2124247 2124247 defendant Browne James husbandman 592997 592997 Browne, James, of Wedmore, husbandman 0
4286943 2125383 2125383 defendant Thorne William carpenter 592997 592997 Thorne, William, of Wedmore, carpenter 3
4291951 2127198 2127198 defendant Hodges Thomas gent 592997 592997 Hodges, Thomas, of Wedmore, gent 0
4308523 2133135 2133135 defendant Graves Thomas yeoman 592997 592997 Graves, Thomas, of Wedmore, yeoman 1
4386007 2160008 2160008 defendant Counsell John husbandman 592997 592997 Counsell, John, of Wedmore, husbandman 2
4412710 2168843 2168843 defendant Stone Thomas gent 592997 592997 Stone, Thomas, of Wedmore, gent 1
4500271 2200712 2200712 defendant Veysy John   592997 592997 Veysy, John, of Wedmore 0
4574424 2223530 2223530 defendant Pronte William   592997 592997 Pronte, William, of Wedmore 0
4590240 2228317 2228317 defendant Consill John   592997 592997 Consill, John, of Wedmore 0
4592438 2228987 2228987 defendant Wylkyns Nicholas   592997 592997 Wylkyns, Nicholas, of Wedmore 0
4602298 2231935 2231935 defendant Gilbard John   592997 592997 Gilbard, John, of Wedmore 0
4633519 2241338 2241338 defendant Prat John   592997 592997 Prat, John, of Wedmore 0
4652611 2246774 2246774 defendant Baret John tailor 592997 592997 Baret, John, of Wedmore, tailor 0
4656316 2247867 2247867 defendant Thomas John husbandman 592997 592997 Thomas, John, of Wedmore, husbandman 0
4657588 2248262 2248262 defendant Barwe Nicholas   592997 592997 Barwe, Nicholas, of Wedmore, franklin 0
4705324 2267037 2267037 defendant Tomas John husbandman 592997 592997 Tomas, John, of Wedmore, husbandman 0
4728636 2274195 2274195 defendant Northlode Alice   592997 592997 (Northlode, Alice, of Wedmore, widow, formerly wife of William 1
4730852 2274848 2274848 defendant Reek William laborer 592997 592997 Reek, William, of Wedmore, laborer 0
4833104 2306373 2306373 defendant Thomas_ John gent 592997 592997 Thomas_, John, of Wedmore, gent 1
4833129 2306376 2306376 defendant Tomas John gent 592997 592997 Tomas, John, of Wedmore, gent 1
4882909 2321573 2321573 defendant Thomas John yeoman 592997 592997 Thomas, John, of Wedmore, yeoman 1
4897693 2325944 2325944 defendant Stremyng John butcher 592997 592997 Stremyng, John, of Wedmore, butcher 1
4932314 2336508 2336508 defendant Vowell William husbandman 592997 592997 Vowell, William, of Wedmore, husbandman 0
4951925 2342551 2342551 defendant Voule William husbandman 592997 592997 Voule, William, of Wedmore, husbandman 4
4959796 2344893 2344893 defendant Harewell Roger husbandman 592997 592997 Harewell, Roger, of Wedmore, husbandman 0
4959797 2344893 2344893 defendant Crosman John husbandman 592997 592997 Crosman, John, of Wedmore, husbandman 1
4959801 2344895 2344895 defendant Harewell Roger husbandman 592997 592997 Harewell, Roger, of Wedmore, husbandman 0
4959802 2344895 2344895 defendant Crosseman John husbandman 592997 592997 Crosseman, John, of Wedmore, husbandman 1
4974795 2349432 2349432 defendant Warman Walter husbandman 592997 592997 Warman, Walter, of Wedmore, husbandman 0
4986427 2352867 2352867 defendant Mylburne John   592997 592997 Mylburne, John, of Wedmore, franklin 0
4986428 2352867 2352867 defendant Harewell Roger   592997 592997 Harewell, Roger, of Wedmore, holy water clerk 1
4997415 2356075 2356075 defendant Stremyng John husbandman 592997 592997 Stremyng, John, of Wedmore, husbandman 1
5005746 2358577 2358577 defendant Harewell Roger husbandman 592997 592997 Harewell, Roger, of Wedmore, husbandman 0
5030625 2365828 2365828 defendant Stremyng John butcher 592997 592997 Stremyng, John, of Wedmore, butcher 0
5031620 2366112 2366112 defendant Hogges Walter husbandman 592997 592997 Hogges, Walter, of Wedmore, husbandman 0
5053859 2372748 2372748 defendant Thomas Thomas gent 592997 592997 together with Thomas, Thomas, of Wedmore, gent 1
5053860 2372748 2372748 defendant Milborn John   592997 592997 Milborn, John, of Wedmore, franklin 2
5053870 2372752 2372752 defendant Thomas Thomas gent 592997 592997 Thomas, Thomas, of Wedmore, gent 0
5114923 2390778 2390778 defendant Holbroke Thomas, senior husbandman 592997 592997 Holbroke, Thomas, senior, of Wedmore, husbandman 0
5217893 2420964 2420964 defendant Voule William husbandman 592997 592997 Voule, William, of Wedmore, husbandman 0
5237581 2426574 2426574 plaintiff Gaylard John mercer 592997 592997 Gaylard, John, of Wedmore, mercer 0
5243308 2428244 2428244 defendant Ryke William husbandman 592997 592997 Ryke, William, of Wedmore, husbandman 0
5280998 2439523 2439523 defendant Reke William husbandman 592997 592997 Reke, William, of Wedmore, husbandman 0
5376619 2468285 2468285 defendant Moreys William   592997 592997 Moreys, William, of Wedmore, shoe maker 0
5536739 2515976 2515976 defendant Colyns Nicholas husbandman 592997 592997 Colyns, Nicholas, of Wedmore, husbandman 0
5536740 2515976 2515976 defendant Colyns Andrew husbandman 592997 592997 Colyns, Andrew, of Wedmore, husbandman 1
5544233 2518301 2518301 defendant Kyrkeby John miller 592997 592997 Kyrkeby, John, of Wedmore, miller 0
5544234 2518301 2518301 defendant Martyn Thomas husbandman 592997 592997 Martyn, Thomas, of Wedmore, husbandman 1
5544235 2518301 2518301 defendant Dean John butcher 592997 592997 Dean, John, of Wedmore, butcher 2
5544236 2518301 2518301 defendant Bailly William husbandman 592997 592997 Bailly, William, of Wedmore, husbandman 3
5544238 2518302 2518302 defendant Milburn William gent 592997 592997 Milburn, William, of Wedmore, gent 0
5544239 2518302 2518302 defendant Kyng Roger smith 592997 592997 Kyng, Roger, of Wedmore, smith 1
5544240 2518302 2518302 defendant Counsell John husbandman 592997 592997 Counsell, John, of Wedmore, husbandman 2
5544241 2518302 2518302 defendant Dean John smith 592997 592997 Dean, John, of Wedmore, smith 3
5635366 2555026 2555026 defendant Part John   592997 592997 Part, John, of Wedmore, holy water clerk 0

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