names

71 rows where place_id = 586367

✎ 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
3588533 1864057 1864057 defendant Milward John tucker 586367 586367 Milward, John, of Shepton Malet, tucker 1
3601244 1868051 1868051 defendant Syms John husbandman 586367 586367 Syms, John, of Shepton Malet, husbandman 0
3601245 1868051 1868051 defendant Walter Thomas weaver 586367 586367 Walter, Thomas, of Shepton Malet, weaver 1
3650199 1910433 1910433 plaintiff Ruynon Richard gent 586367 586367 Ruynon, Richard, of Shepton Malet, gent 0
3670463 1916720 1916720 plaintiff Buclond Agnes widow 586367 586367 Buclond, Agnes, of Shepton Malet, widow 0
3672181 1917298 1917298 defendant Hardyk John husbandman 586367 586367 Hardyk, John, of Shepton Malet, husbandman 0
3869736 1980117 1980117 defendant Eyrre William mercer 586367 586367 Eyrre, William, of Shepton Malet, mercer 0
3883663 1984805 1984805 defendant Hodges Richard weaver 586367 586367 Hodges, Richard, of Shepton Malet, weaver 1
3883664 1984805 1984805 defendant Stroode Edward clothmaker 586367 586367 Stroode, Edward, of Shepton Malet, clothmaker 2
3883665 1984805 1984805 defendant Wattys William husbandman 586367 586367 Wattys, William, of Shepton Malet, husbandman 3
3954704 2008709 2008709 defendant Strowde John husbandman or yeoman 586367 586367 Strowde, John, of Shepton Malet, husbandman or yeoman 0
4486851 2196602 2196602 defendant Martyn Richard   586367 586367 Martyn, Richard, of Shepton Malet 0
4510015 2203620 2203620 defendant Sutton Richard   586367 586367 Sutton, Richard, of Shepton Malet 2
4514571 2204976 2204976 defendant Gate John   586367 586367 Gate, John, of Shepton Malet 1
4542084 2213417 2213417 defendant Bole Thomas   586367 586367 Bole, Thomas, of Shepton Malet 0
4542089 2213418 2213418 defendant Lovelot John   586367 586367 together with Lovelot, John, of Shepton Malet 3
4542091 2213418 2213418 defendant Ferrour William   586367 586367 Ferrour, William, of Shepton Malet 5
4542093 2213419 2213419 defendant Lovelot John   586367 586367 Lovelot, John, of Shepton Malet 0
4542095 2213419 2213419 defendant Ferrour William   586367 586367 Ferrour, William, of Shepton Malet 2
4625070 2238808 2238808 defendant Neyewerewe John   586367 586367 Neyewerewe, John, of Shepton Malet 0
4680687 2259574 2259574 plaintiff Loveyn John   586367 586367 Loveyn, John, of Shepton Malet, on his own account 0
4703343 2266423 2266423 defendant Wolball William laborer 586367 586367 Wolball, William, of Shepton Malet, laborer 3
4706347 2267367 2267367 plaintiff Loveyn John   586367 586367 Loveyn, John, of Shepton Malet 0
4717389 2270777 2270777 defendant Squybbe Walter butcher 586367 586367 Squybbe, Walter, of Shepton Malet, butcher 2
4733829 2275759 2275759 defendant Dodmede John husbandman 586367 586367 Dodmede, John, of Shepton Malet, husbandman 0
4741680 2278059 2278059 defendant Dyer Thomas, junior dyer 586367 586367 Dyer, Thomas, junior, of Shepton Malet, dyer 2
4760023 2283472 2283472 defendant Smogger Thomas weaver 586367 586367 Smogger, Thomas, of Shepton Malet, weaver 2
4770218 2286659 2286659 defendant Touker Robert fuller 586367 586367 Touker, Robert, of Shepton Malet, fuller 0
4771919 2287190 2287190 defendant Bole Thomas ostler 586367 586367 Bole, Thomas, of Shepton Malet, ostler 0
4776085 2288517 2288517 defendant Serne Richard fuller 586367 586367 Serne, Richard, of Shepton Malet, fuller 1
4782259 2290452 2290452 defendant Smogger Thomas weaver 586367 586367 Smogger, Thomas, of Shepton Malet, weaver 0
4824038 2303594 2303594 defendant Coker Peter chapman 586367 586367 Coker, Peter, of Shepton Malet, chapman 0
4847707 2310776 2310776 defendant Deverall John fuller 586367 586367 Deverall, John, of Shepton Malet, fuller 2
4889265 2323429 2323429 defendant Cerne Richard husbandman 586367 586367 Cerne, Richard, of Shepton Malet, husbandman 0
4889266 2323429 2323429 defendant Cerne John husbandman 586367 586367 Cerne, John, of Shepton Malet, husbandman 1
4927622 2335075 2335075 defendant Heyman John husbandman 586367 586367 Heyman, John, of Shepton Malet, husbandman 2
4927623 2335075 2335075 defendant Mede Willam collier 586367 586367 Mede, Willam, of Shepton Malet, collier 3
4938284 2338353 2338353 defendant Rondon or Roudon Richard clothier 586367 586367 Rondon or Roudon, Richard, of Shepton Malet, clothier 3
4941954 2339467 2339467 defendant Dyer John dyer 586367 586367 Dyer, John, of Shepton Malet, dyer 0
4963983 2346137 2346137 defendant Brede Nicholas   586367 586367 Brede, Nicholas, of Shepton Malet, holy water clerk 0
5017012 2361869 2361869 plaintiff Carter Edmund   586367 586367 Carter, Edmund, of Shepton Malet 0
5018898 2362415 2362415 defendant Harper John clothier 586367 586367 Harper, John, of Shepton Malet, clothier 1
5020507 2362886 2362886 defendant Perys Robert husbandman 586367 586367 Perys, Robert, of Shepton Malet, husbandman 3
5020508 2362886 2362886 defendant Perys William husbandman 586367 586367 Perys, William, of Shepton Malet, husbandman 4
5028538 2365221 2365221 defendant Legge John clothmaker 586367 586367 Legge, John, of Shepton Malet, clothmaker 0
5029980 2365643 2365643 defendant Dyer Thomas dyer 586367 586367 Dyer, Thomas, of Shepton Malet, dyer 3
5032223 2366305 2366305 defendant Strode Walter tucker 586367 586367 Strode, Walter, of Shepton Malet, tucker 0
5032224 2366305 2366305 defendant Perys Robert husbandman 586367 586367 Perys, Robert, of Shepton Malet, husbandman 1
5032228 2366306 2366306 defendant Strode Walter tucker 586367 586367 Strode, Walter, of Shepton Malet, tucker 0
5215295 2420201 2420201 defendant Corveser or Cordwainer Denis shoemaker 586367 586367 Corveser or Cordwainer, Denis, of Shepton Malet, shoemaker 0
5229718 2424312 2424312 defendant Vorst Richard weaver 586367 586367 Vorst, Richard, of Shepton Malet, weaver 0
5246376 2429098 2429098 defendant Heyman John husbandman 586367 586367 Heyman, John, of Shepton Malet, husbandman 0
5246378 2429099 2429099 defendant Heyman John husbandman 586367 586367 Heyman, John, of Shepton Malet, husbandman 0
5274124 2437510 2437510 defendant Alygode William fuller 586367 586367 Alygode, William, of Shepton Malet, fuller 0
5307315 2447193 2447193 plaintiff Pavy Hugh   586367 586367 Pavy, Hugh, of Shepton Malet, parson of the parish church 0
5342419 2457824 2457824 defendant Dultyng John clithier 586367 586367 Dultyng, John, of Shepton Malet, clithier 0
5357942 2462549 2462549 defendant Plumley Richard clothmaker 586367 586367 Plumley, Richard, of Shepton Malet, clothmaker 0
5360275 2463250 2463250 defendant Inge John, senior clothier 586367 586367 Inge, John, senior, of Shepton Malet, clothier 1
5382213 2469970 2469970 defendant Bowley Robert   586367 586367 Bowley, Robert, of Shepton Malet 0
5391012 2472496 2472496 defendant Bowby Robert merchant 586367 586367 Bowby, Robert, of Shepton Malet, merchant 0
5391014 2472497 2472497 defendant Bowley Robert merchant 586367 586367 Bowley, Robert, of Shepton Malet, merchant 0
5439830 2486852 2486852 defendant Taillour Richard tailor 586367 586367 Taillour, Richard, of Shepton Malet, tailor 0
5453447 2490922 2490922 defendant Taillour Richard tailor 586367 586367 Taillour, Richard, of Shepton Malet, tailor 0
5465358 2494547 2494547 defendant Taillour Richard tailor 586367 586367 Taillour, Richard, of Shepton Malet, tailor 0
5484956 2500423 2500423 defendant Makerell John husbandman 586367 586367 Makerell, John, of Shepton Malet, husbandman 0
5493279 2502898 2502898 defendant Doultyng John (legal representative) 586367 586367 Doultyng, John, of Shepton Malet, clothmaker, executors of 0
5502186 2505610 2505610 defendant Clerke Robert weaver 586367 586367 Clerke, Robert, of Shepton Malet, weaver 0
5517931 2510453 2510453 defendant Whyng William chaplain 586367 586367 Whyng, William, of Shepton Malet, chaplain 0
5517932 2510453 2510453 defendant Catcote John clothier 586367 586367 Catcote, John, of Shepton Malet, clothier 1
5517933 2510453 2510453 defendant Clerke Robert husbandman 586367 586367 Clerke, Robert, of Shepton Malet, husbandman 2
5589264 2531649 2531649 plaintiff Rayvon or Raynon Richard gent 586367 586367 Rayvon or Raynon, Richard, of Shepton Malet, gent 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);