names

81 rows where place_id = 586865

✎ 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
3589831 1864460 1864460 defendant Randall John baker 586865 586865 (Randall, John, of Glastonbury, Soms, baker 2
3589835 1864461 1864461 defendant Rendall John baker 586865 586865 (Rendall, John, of Glastonbury, Soms, baker 2
3611966 1871403 1871403 defendant Gunwyn Thomas scrivener 586865 586865 Gunwyn, Thomas, of Glastonbury, Soms, scrivener 3
3621625 1874303 1874303 defendant Moor Hugh tailor 586865 586865 Moor, Hugh, of Glastonbury, Soms, tailor 0
3621630 1874304 1874304 defendant Moor Hugh tailor 586865 586865 Moor, Hugh, of Glastonbury, Soms, tailor 0
3744070 1940039 1940039 defendant Apowell William weaver 586865 586865 Apowell, William, of Glastonbury, Soms, weaver 1
3752392 1942670 1942670 defendant Colmer William gent 586865 586865 (Colmer, William, of Glastonbury, Soms, gent 4
3752404 1942673 1942673 defendant Colmer William yeoman 586865 586865 (Colmer, William, of Glastonbury, Soms, yeoman 2
3769110 1947993 1947993 defendant Colmer William gent 586865 586865 (Colmer, William, of Glastonbury, Soms, gent 1
3879499 1983397 1983397 plaintiff Mylborn William (legal representative) 586865 586865 Mylborn, William, of Glastonbury, Soms, gent, executrix of 0
3919204 1996750 1996750 defendant Levet Richard chapman 586865 586865 Levet, Richard, of Glastonbury, Soms, chapman 0
3928463 1999857 1999857 defendant Mannyng John yeoman 586865 586865 Mannyng, John, of Glastonbury, Soms, yeoman 0
3930079 2000405 2000405 defendant Ambrose Nicholas yeoman 586865 586865 Ambrose, Nicholas, of Glastonbury, Soms, yeoman 0
3952981 2008110 2008110 defendant Soute or Sonte Richard yeoman 586865 586865 Soute or Sonte, Richard, of Glastonbury, Soms, yeoman 1
3971647 2014646 2014646 defendant Payne John gent 586865 586865 Payne, John, of Glastonbury, Soms, gent 0
3971650 2014647 2014647 defendant Holmes Osmund yeoman 586865 586865 Holmes, Osmund, of Glastonbury, Soms, yeoman 0
3975398 2015961 2015961 defendant Helleker William chapman 586865 586865 Helleker, William, of Glastonbury, Soms, chapman 1
3983415 2018844 2018844 defendant Holmes Osmond yeoman 586865 586865 Holmes, Osmond, of Glastonbury, Soms, yeoman 0
3983417 2018845 2018845 defendant Vale Lawrence smith 586865 586865 Vale, Lawrence, of Glastonbury, Soms, smith 0
3984915 2019362 2019362 defendant Holmes Osmund yeoman 586865 586865 Holmes, Osmund, of Glastonbury, Soms, yeoman 0
3984981 2019387 2019387 defendant Holmes Osmund yeoman 586865 586865 Holmes, Osmund, of Glastonbury, Soms, yeoman 0
4009605 2028206 2028206 defendant Mannynge John gent 586865 586865 Mannynge, John, of Glastonbury, Soms, gent 2
4019125 2031580 2031580 defendant Mannynge John gent 586865 586865 Mannynge, John, of Glastonbury, Soms, gent 0
4035668 2037435 2037435 defendant Mannyng John gent 586865 586865 Mannyng, John, of Glastonbury, Soms, gent 0
4044057 2040325 2040325 defendant Mannyng John gent 586865 586865 Mannyng, John, of Glastonbury, Soms, gent 0
4044059 2040326 2040326 defendant Mannynge John gent 586865 586865 Mannynge, John, of Glastonbury, Soms, gent 0
4049720 2042339 2042339 defendant Mannynge John gent 586865 586865 Mannynge, John, of Glastonbury, Soms, gent 0
4052821 2043445 2043445 defendant Eyat or Gyat John yeoman 586865 586865 Eyat or Gyat, John, of Glastonbury, Soms, yeoman 0
4080798 2053446 2053446 defendant Allyn Thomas gent 586865 586865 Allyn, Thomas, of Glastonbury, Soms, gent 0
4083194 2054277 2054277 defendant Dyer Edmund chapman 586865 586865 Dyer, Edmund, of Glastonbury, Soms, chapman 0
4085449 2055072 2055072 defendant Dyer Edmund merchant 586865 586865 Dyer, Edmund, of Glastonbury, Soms, merchant 0
4095159 2058595 2058595 defendant Goulle Thomas carpenter 586865 586865 Goulle, Thomas, of Glastonbury, Soms, carpenter 0
4095653 2058775 2058775 defendant Gyat John yeoman 586865 586865 Gyat, John, of Glastonbury, Soms, yeoman 1
4109351 2063607 2063607 defendant Allyn Thomas gent 586865 586865 Allyn, Thomas, of Glastonbury, Soms, gent 0
4138572 2074163 2074163 defendant Goule Richard vintner 586865 586865 Goule, Richard, of Glastonbury, Soms, vintner 0
4147306 2077196 2077196 defendant Hatche William mercer 586865 586865 Hatche, William, of Glastonbury, Soms, mercer 1
4164111 2082972 2082972 defendant Westley William yeoman 586865 586865 Westley, William, of Glastonbury, Soms, yeoman 3
4164115 2082974 2082974 defendant Preston Edward gent 586865 586865 Preston, Edward, of Glastonbury, Soms, gent 0
4168425 2084442 2084442 defendant Morgan Gregory gent 586865 586865 Morgan, Gregory, of Glastonbury, Soms, gent 0
4168427 2084443 2084443 defendant Morgan Gregory gent 586865 586865 Morgan, Gregory, of Glastonbury, Soms, gent 0
4181773 2089105 2089105 defendant Dawes John yeoman 586865 586865 Dawes, John, of Glastonbury, Soms, yeoman 0
4185982 2090587 2090587 defendant Allen Thomas gent 586865 586865 Allen, Thomas, of Glastonbury, Soms, gent 0
4190260 2092100 2092100 defendant Dawes John yeoman 586865 586865 Dawes, John, of Glastonbury, Soms, yeoman 0
4203077 2096624 2096624 defendant Dawes John yeoman 586865 586865 Dawes, John, of Glastonbury, Soms, yeoman 0
4203093 2096631 2096631 defendant Raynesburye Fabian yeoman 586865 586865 Raynesburye, Fabian, of Glastonbury, Soms, yeoman 0
4211504 2099581 2099581 defendant Dawes or Dees John yeoman 586865 586865 Dawes or Dees, John, of Glastonbury, Soms, yeoman 0
4212301 2099848 2099848 defendant Allyn Thomas gent 586865 586865 Allyn, Thomas, of Glastonbury, Soms, gent 0
4236421 2108311 2108311 defendant Notley John yeoman 586865 586865 Notley, John, of Glastonbury, Soms, yeoman 0
4239526 2109450 2109450 defendant Cooke Thomas yeoman 586865 586865 Cooke, Thomas, of Glastonbury, Soms, yeoman 0
4250380 2113109 2113109 defendant Lewes William, junior weaver 586865 586865 Lewes, William, junior, of Glastonbury, Soms, weaver 0
4285289 2124788 2124788 defendant Preston Amos gent 586865 586865 Preston, Amos, of Glastonbury, Soms, gent 0
4328064 2139704 2139704 defendant Rawles Thomas husbandman 586865 586865 Rawles, Thomas, of Glastonbury, Soms, or of Sturmynster Marshall, Dorset, husbandman 0
4339234 2143486 2143486 defendant Kynge John husbandman 586865 586865 Kynge, John, of Glastonbury, Soms, husbandman 0
4349332 2147028 2147028 defendant Overton Thomas grocer 586865 586865 Overton, Thomas, of Glastonbury, Soms, or of London, grocer 0
4352045 2147950 2147950 defendant Hatche William chapman 586865 586865 Hatche, William, of Glastonbury, Soms, chapman 0
4363999 2152182 2152182 defendant Hatche William   586865 586865 Hatche, William, of Glastonbury, Soms, linen draper 0
4378612 2157423 2157423 defendant Edgill William glover 586865 586865 Edgill, William, of Glastonbury, Soms, glover 1
4385596 2159866 2159866 defendant Hatche William mercer 586865 586865 Hatche, William, of Glastonbury, Soms, mercer 0
4389216 2161022 2161022 defendant Border Philip haberdasher 586865 586865 Border, Philip, of Glastonbury, Soms, haberdasher 2
4411728 2168517 2168517 defendant Hatche William mercer 586865 586865 Hatche, William, of Glastonbury, Soms, mercer 0
4738042 2276999 2276999 defendant Body Thomas baker 586865 586865 Body, Thomas, of Glastonbury, Soms, baker 3
4843981 2309631 2309631 defendant Bate Thomas chapman 586865 586865 Bate, Thomas, of Glastonbury, Soms, chapman 4
4980733 2351173 2351173 defendant Burnell Adam yeoman 586865 586865 Burnell, Adam, of Glastonbury, Soms, yeoman 1
5022865 2363598 2363598 defendant Mynehede John (legal representative) 586865 586865 Mynehede, John, of Glastonbury, Soms, fisher, administratrix of 1
5025164 2364256 2364256 defendant Persevale Thomas gent 586865 586865 Persevale, Thomas, of Glastonbury, Soms, gent 1
5180356 2409996 2409996 defendant Bytham Thomas gent 586865 586865 (Bytham, Thomas, of Glastonbury, Soms, gent 3
5185803 2411593 2411593 defendant Persyvale Thomas gent 586865 586865 Persyvale, Thomas, of Glastonbury, Soms, gent 4
5202368 2416455 2416455 defendant Bytham Thomas gent 586865 586865 (Bytham, Thomas, of Glastonbury, Soms, gent 2
5202374 2416456 2416456 defendant Bycham Thomas gent 586865 586865 (Bycham, Thomas, of Glastonbury, Soms, gent 3
5204939 2417190 2417190 defendant Percyvale Thomas gent 586865 586865 Percyvale, Thomas, of Glastonbury, Soms, gent 4
5267026 2435444 2435444 defendant Holman Hugh yeoman 586865 586865 (Holman, Hugh, of Glastonbury, Soms, yeoman 5
5296931 2444095 2444095 defendant Touker Richard gent 586865 586865 Touker, Richard, of Glastonbury, Soms, gent 1
5296933 2444096 2444096 defendant Okeley John gent 586865 586865 Okeley, John, of Glastonbury, Soms, gent 0
5312971 2448910 2448910 defendant Conell or Couell Thomas sherman 586865 586865 Conell or Couell, Thomas, of Glastonbury, Soms, sherman 0
5343926 2458287 2458287 defendant Yonge William clothier 586865 586865 Yonge, William, of Glastonbury, Soms, clothier 4
5489524 2501748 2501748 plaintiff at Welle Joan (legal representative) 586865 586865 at Welle, Joan, of Glastonbury, Soms, widow, executor of 0
5504416 2506298 2506298 plaintiff at Welle Joan widow 586865 586865 at Welle, Joan, of Glastonbury, Soms, widow 0
5509955 2507953 2507953 defendant Holman John carrier 586865 586865 Holman, John, of Glastonbury, Soms, carrier 0
5552287 2520715 2520715 defendant Johnson James shoemaker 586865 586865 (Johnson, James, of Glastonbury, Soms, shoemaker 3
5564041 2524097 2524097 defendant Boys John gent 586865 586865 Boys, John, of Glastonbury, Soms, gent 1
5566765 2524874 2524874 defendant Boys John gent 586865 586865 Boys, John, of Glastonbury, Soms, 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);