names

133 rows where place_id = 593750

✎ 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
3613177 1871776 1871776 defendant Kempe Robert (legal representative) 593750 593750 Kempe, Robert, of Baunton, husbandman, executors of 0
3613178 1871776 1871776 defendant Canne John husbandman 593750 593750 (Canne, John, of Baunton, husbandman 1
3624898 1875322 1875322 defendant Vereman Thomas husbandman 593750 593750 Vereman, Thomas, of Baunton, husbandman 3
3633158 1905183 1905183 defendant Flode John husbandman 593750 593750 Flode, John, of Baunton, husbandman 0
3633159 1905183 1905183 defendant Doget Robert husbandman 593750 593750 Doget, Robert, of Baunton, husbandman 1
3754677 1943422 1943422 defendant Whyte John clerk 593750 593750 Whyte, John, of Baunton, clerk 0
3758121 1944526 1944526 defendant Tristram John husbandman 593750 593750 Tristram, John, of Baunton, husbandman 0
3758122 1944526 1944526 defendant Pester James smith 593750 593750 Pester, James, of Baunton, smith 1
3776919 1950522 1950522 defendant Helyer John husbandman 593750 593750 Helyer, John, of Baunton, husbandman 0
3789680 1954602 1954602 defendant Aherney Donett chaplain 593750 593750 Aherney, Donett, of Baunton, chaplain 0
3793658 1955879 1955879 defendant Tristram John husbandman 593750 593750 Tristram, John, of Baunton, husbandman 0
3793659 1955879 1955879 defendant Pester James smith 593750 593750 Pester, James, of Baunton, smith 1
3869068 1979899 1979899 defendant Roper Richard chapman 593750 593750 Roper, Richard, of Baunton, chapman 0
3869076 1979902 1979902 defendant Perott John tanner 593750 593750 Perott, John, of Baunton, tanner 0
3904803 1991869 1991869 defendant Cownam James husbandman 593750 593750 Cownam, James, of Baunton, husbandman 0
3921785 1997632 1997632 defendant Rowe Joan widow 593750 593750 Rowe, Joan, of Baunton, widow 0
3921786 1997632 1997632 defendant Roo Michael weaver 593750 593750 Roo, Michael, of Baunton, weaver 1
3928582 1999900 1999900 defendant Mone Robert yeoman 593750 593750 Mone, Robert, of Baunton, yeoman 1
3941150 2004043 2004043 defendant Osmond John clothier 593750 593750 Osmond, John, of Baunton, clothier 0
4049775 2042362 2042362 defendant Bowbeare Thomas husbandman 593750 593750 Bowbeare, Thomas, of Baunton, husbandman 0
4108169 2063190 2063190 defendant Bawen Michael weaver 593750 593750 Bawen, Michael, of Baunton, weaver 0
4108171 2063190 2063190 defendant Goodman Richard   593750 593750 Goodman, Richard, of Baunton, linen draper 2
4171243 2085404 2085404 defendant Cawoodley John gent 593750 593750 Cawoodley, John, of Baunton, gent 1
4171244 2085404 2085404 defendant Hobbes John yeoman 593750 593750 Hobbes, John, of Baunton, yeoman 2
4171245 2085404 2085404 defendant Adycott Amisius yeoman 593750 593750 Adycott, Amisius, of Baunton, yeoman 3
4171246 2085404 2085404 defendant Bowbere Thomas husbandman 593750 593750 Bowbere, Thomas, of Baunton, husbandman 4
4171247 2085404 2085404 defendant Brambridge or Brainbridge alias Yendall James weaver 593750 593750 Brambridge or Brainbridge alias Yendall, James, of Baunton, weaver 5
4194432 2093603 2093603 defendant Cawoodley John gent 593750 593750 Cawoodley, John, of Baunton, gent 1
4194433 2093603 2093603 defendant Hobbes John yeoman 593750 593750 Hobbes, John, of Baunton, yeoman 2
4194434 2093603 2093603 defendant Adycott Amyas yeoman 593750 593750 Adycott, Amyas, of Baunton, yeoman 3
4194435 2093603 2093603 defendant Bowbere Thomas husbandman 593750 593750 Bowbere, Thomas, of Baunton, husbandman 4
4194436 2093603 2093603 defendant Brambridge or Brainbridge alias Youdall James weaver 593750 593750 Brambridge or Brainbridge alias Youdall, James, of Baunton, weaver 5
4194483 2093621 2093621 defendant Calwoodley John gent 593750 593750 Calwoodley, John, of Baunton, gent 1
4194484 2093621 2093621 defendant Hobbes John yeoman 593750 593750 Hobbes, John, of Baunton, yeoman 2
4194485 2093621 2093621 defendant Adicott Anne yeoman 593750 593750 Adicott, Anne, of Baunton, yeoman 3
4194486 2093621 2093621 defendant Bowbere Thomas husbandman 593750 593750 Bowbere, Thomas, of Baunton, husbandman 4
4194487 2093621 2093621 defendant Brainbridge alias Yendall James weaver 593750 593750 Brainbridge alias Yendall, James, of Baunton, weaver 5
4196309 2094252 2094252 defendant Cawodley John gent 593750 593750 Cawodley, John, of Baunton, gent 1
4196310 2094252 2094252 defendant Hobbes John yeoman 593750 593750 Hobbes, John, of Baunton, yeoman 2
4196311 2094252 2094252 defendant Adycott Amyas yeoman 593750 593750 Adycott, Amyas, of Baunton, yeoman 3
4196312 2094252 2094252 defendant Bowbere Thomas husbandman 593750 593750 Bowbere, Thomas, of Baunton, husbandman 4
4196313 2094252 2094252 defendant Brambridge or Brainbridge alias Yendall James weaver 593750 593750 Brambridge or Brainbridge alias Yendall, James, of Baunton, weaver 5
4248919 2112624 2112624 defendant Cheeke Henry fletcher 593750 593750 Cheeke, Henry, of Baunton, fletcher 0
4305759 2132151 2132151 defendant Whekyn Stephen husbandman 593750 593750 Whekyn, Stephen, of Baunton, husbandman 1
4308340 2133068 2133068 defendant Badcocke John husbandman 593750 593750 Badcocke, John, of Baunton, husbandman 0
4329146 2140060 2140060 defendant Wade Thomas husbandman 593750 593750 Wade, Thomas, of Baunton, husbandman 0
4452931 2185924 2185924 plaintiff Kyngman William   593750 593750 Kyngman, William, of Baunton, son of John 0
4482409 2195203 2195203 plaintiff Michel John   593750 593750 Michel, John, of Baunton, parson 0
4520558 2206780 2206780 defendant Wodeward John   593750 593750 Wodeward, John, of Baunton 1
4595018 2229700 2229700 defendant Holecombe Thomas   593750 593750 Holecombe, Thomas, of Baunton 0
4602082 2231873 2231873 defendant Clerk William   593750 593750 Clerk, William, of Baunton 2
4602087 2231874 2231874 defendant Rose John   593750 593750 Rose, John, of Baunton 0
4647699 2245384 2245384 plaintiff Smert Richard   593750 593750 Smert, Richard, of Baunton 0
4660877 2249227 2249227 defendant Stoke John husbandman 593750 593750 Stoke, John, of Baunton, husbandman 1
4660878 2249227 2249227 defendant Port John dyer 593750 593750 Port, John, of Baunton, dyer 2
4660881 2249228 2249228 defendant Waryn John clerk 593750 593750 Waryn, John, of Baunton, clerk 1
4662140 2249633 2249633 defendant Lange William yeoman 593750 593750 Lange, William, of Baunton, yeoman 0
4662141 2249633 2249633 defendant Nywe John, senior yeoman 593750 593750 Nywe, John, senior, of Baunton, yeoman 1
4699048 2265171 2265171 defendant Helyer Walter   593750 593750 Helyer, Walter, of Baunton, bailiff 4
4726452 2273554 2273554 defendant Goderygge John husbandman 593750 593750 Goderygge, John, of Baunton, husbandman 3
4726458 2273555 2273555 defendant Goderygge John capman 593750 593750 Goderygge, John, of Baunton, capman 3
4727191 2273766 2273766 defendant Dirlyng Robert chapman 593750 593750 Dirlyng, Robert, of Baunton, chapman 0
4727194 2273766 2273766 defendant Goderigge John husbandman 593750 593750 Goderigge, John, of Baunton, husbandman 3
4756223 2282320 2282320 defendant Hughe Walter husbandman 593750 593750 Hughe, Walter, of Baunton, husbandman 1
4759033 2283177 2283177 defendant Helyer Walter   593750 593750 Helyer, Walter, of Baunton 3
4760318 2283579 2283579 defendant Holcombe Thomas husbandman 593750 593750 Holcombe, Thomas, of Baunton, husbandman 1
4779132 2289448 2289448 defendant Helyer Walter   593750 593750 Helyer, Walter, of Baunton, bailiff 0
4779937 2289725 2289725 defendant atte Hylle Henry butcher 593750 593750 atte Hylle, Henry, of Baunton, butcher 0
4779938 2289725 2289725 defendant Morys Roger butcher 593750 593750 Morys, Roger, of Baunton, butcher 1
4779942 2289726 2289726 defendant Moryce Roger butcher 593750 593750 Moryce, Roger, of Baunton, butcher 1
4780009 2289749 2289749 defendant Ryng John husbandman 593750 593750 Ryng, John, of Baunton, husbandman 0
4782699 2290603 2290603 defendant Holcombe Thomas husbandman 593750 593750 Holcombe, Thomas, of Baunton, husbandman 1
4784533 2291168 2291168 defendant Passemere Ralph husbandman 593750 593750 Passemere, Ralph, of Baunton, husbandman 0
4784534 2291168 2291168 defendant atte Watere Robert laborer 593750 593750 atte Watere, Robert, of Baunton, laborer 1
4791058 2293299 2293299 defendant Dryngue or Dryngne John yeoman 593750 593750 Dryngue or Dryngne, John, of Baunton, yeoman 0
4862980 2315400 2315400 defendant Cheumpell John yeoman 593750 593750 Cheumpell, John, of Baunton, yeoman 2
4862982 2315400 2315400 defendant Graunte John husbandman 593750 593750 Graunte, John, of Baunton, husbandman 4
4919873 2332724 2332724 defendant Kemer John laborer 593750 593750 Kemer, John, of Baunton, laborer 0
4946716 2340975 2340975 defendant atte Wyke Richard husbandman 593750 593750 atte Wyke, Richard, of Baunton, husbandman 0
4963003 2345846 2345846 defendant Braddon John   593750 593750 Braddon, John, of Baunton, bailiff 2
4965304 2346544 2346544 defendant atte Hille John husbandman 593750 593750 atte Hille, John, of Baunton, husbandman 2
4965305 2346544 2346544 defendant Rowe William, junior husbandman 593750 593750 Rowe, William, junior, of Baunton, husbandman 3
4965306 2346544 2346544 defendant Hobbehous Thomas husbandman 593750 593750 Hobbehous, Thomas, of Baunton, husbandman 4
4973456 2349004 2349004 defendant Slade William husbandman 593750 593750 Slade, William, of Baunton, husbandman 1
4985219 2352509 2352509 defendant Braddon john   593750 593750 Braddon, john, of Baunton, bailiff 3
5005684 2358558 2358558 defendant Lovell John laborer 593750 593750 Lovell, John, of Baunton, laborer 1
5016040 2361575 2361575 defendant Braddon John   593750 593750 Braddon, John, of Baunton, bailiff 4
5024560 2364097 2364097 defendant Uppecote Robert laborer 593750 593750 Uppecote, Robert, of Baunton, laborer 1
5028025 2365076 2365076 defendant Cole Richard husbandman 593750 593750 Cole, Richard, of Baunton, husbandman 0
5032139 2366273 2366273 defendant Spore Philip gent 593750 593750 Spore, Philip, of Baunton, gent 0
5048741 2371260 2371260 defendant Helyer John skinner 593750 593750 Helyer, John, of Baunton, skinner 0
5078108 2379938 2379938 plaintiff Braddon John, junior   593750 593750 Braddon, John, junior, of Baunton 0
5098010 2385848 2385848 defendant Tristram William dyer 593750 593750 Tristram, William, of Baunton, dyer 0
5101408 2386826 2386826 plaintiff Avery John, junior   593750 593750 Avery, John, junior, of Baunton 0
5101409 2386826 2386826 defendant Frenssh John (legal representative) 593750 593750 Frenssh, John, of Baunton, mercer, executors of 0
5101411 2386827 2386827 plaintiff Avery John, junior   593750 593750 Avery, John, junior, of Baunton 0
5101412 2386827 2386827 defendant Frenssh John (legal representative) 593750 593750 Frenssh, John, of Baunton, mercer, executors of 0
5110583 2389496 2389496 defendant Atkyn Thomas husbandman 593750 593750 Atkyn, Thomas, of Baunton, husbandman 0
5123151 2393206 2393206 defendant atte Wer Richard butcher 593750 593750 atte Wer, Richard, of Baunton, butcher 0
5126653 2394270 2394270 defendant Mylton Thomas husbandman 593750 593750 Mylton, Thomas, of Baunton, husbandman 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);