names

158 rows where place_id = 588021

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593120 1865474 1865474 defendant Quynte John butcher 588021 588021 Quynte, John, of Becclys, Suff, butcher 1
3609252 1870557 1870557 defendant Sheryng Thomas spurrier 588021 588021 Sheryng, Thomas, of Becclys, Suff, spurrier 3
3609259 1870558 1870558 defendant Sheryng Thomas spurrier 588021 588021 Sheryng, Thomas, of Becclys, Suff, spurrier 3
3613784 1871965 1871965 defendant Benet Robert fuller 588021 588021 Benet, Robert, of Becclys, Suff, fuller 0
3621956 1874410 1874410 defendant Hille William yeoman 588021 588021 Hille, William, of Becclys, Suff, yeoman 0
3621960 1874411 1874411 defendant Hille William yeoman 588021 588021 Hille, William, of Becclys, Suff, yeoman 0
3621964 1874412 1874412 defendant Hylle William yeoman 588021 588021 Hylle, William, of Becclys, Suff, yeoman 0
3621968 1874413 1874413 defendant Hyll William yeoman 588021 588021 Hyll, William, of Becclys, Suff, yeoman 0
3622448 1874557 1874557 defendant Moyse John butcher 588021 588021 Moyse, John, of Becclys, Suff, butcher 0
3623799 1874976 1874976 defendant Eye John butcher 588021 588021 Eye, John, of Becclys, Suff, butcher 0
3623835 1874984 1874984 defendant Gronde John shoemaker 588021 588021 Gronde, John, of Becclys, Suff, shoemaker 0
3628445 1903763 1903763 defendant Nene or Neve Thomas yeoman 588021 588021 Nene or Neve, Thomas, of Becclys, Suff, yeoman 4
3644100 1908585 1908585 defendant Bumpsted Agnes widow 588021 588021 Bumpsted, Agnes, of Becclys, Suff, widow 0
3644104 1908586 1908586 defendant Bumpsted Agnes widow 588021 588021 Bumpsted, Agnes, of Becclys, Suff, widow 0
3673230 1917642 1917642 defendant Calthorp Robert butcher 588021 588021 Calthorp, Robert, of Becclys, Suff, butcher 0
3679035 1919516 1919516 defendant Goddys Richard yeoman 588021 588021 Goddys, Richard, of Becclys, Suff, yeoman 0
3687491 1922267 1922267 defendant Marley William keelman 588021 588021 Marley, William, of Becclys, Suff, keelman 1
3692356 1923782 1923782 defendant Colydour William husbandman 588021 588021 Colydour, William, of Becclys, Suff, husbandman 0
3698324 1925695 1925695 defendant Burnam Thomas embroiderer 588021 588021 Burnam, Thomas, of Becclys, Suff, embroiderer 1
3700204 1926296 1926296 defendant Arnyap William butcher 588021 588021 Arnyap, William, of Becclys, Suff, butcher 0
3701837 1926824 1926824 defendant Cadow James tanner 588021 588021 Cadow, James, of Becclys, Suff, tanner 1
3707126 1928515 1928515 defendant Beynham Robert shoemaker 588021 588021 Beynham, Robert, of Becclys, Suff, shoemaker 3
3710004 1929437 1929437 defendant Burnham Thomas   588021 588021 Burnham, Thomas, of Becclys, Suff, vestment maker 0
3711490 1929901 1929901 defendant Grene Robert dyer 588021 588021 Grene, Robert, of Becclys, Suff, dyer 0
3722287 1933230 1933230 defendant Bowes Anne widow 588021 588021 Bowes, Anne, of Becclys, Suff, widow 0
3744249 1940098 1940098 defendant Arnyapp William butcher 588021 588021 Arnyapp, William, of Becclys, Suff, butcher 0
3751835 1942491 1942491 defendant Chappeleyn William mercer 588021 588021 Chappeleyn, William, of Becclys, Suff, mercer 0
3752900 1942832 1942832 defendant Burnam John clerk 588021 588021 Burnam, John, of Becclys, Suff, clerk 0
3757163 1944222 1944222 defendant Leys Nicholas   588021 588021 Leys, Nicholas, of Becclys, Suff, worsted weaver 0
3757822 1944423 1944423 defendant Bumpsted William gent 588021 588021 Bumpsted, William, of Becclys, Suff, gent 0
3758902 1944775 1944775 defendant Burneham Thomas   588021 588021 Burneham, Thomas, of Becclys, Suff, vestment maker 0
3760900 1945414 1945414 defendant Rede Thomas clerk 588021 588021 (Rede, Thomas, of Becclys, Suff, clerk 1
3763461 1946204 1946204 defendant Harold Richard pedder 588021 588021 Harold, Richard, of Becclys, Suff, pedder 1
3769793 1948207 1948207 defendant Burnam John clerk 588021 588021 Burnam, John, of Becclys, Suff, clerk 0
3779030 1951165 1951165 defendant Rede Thomas clerk 588021 588021 (Rede, Thomas, of Becclys, Suff, clerk 1
3791308 1955116 1955116 defendant Bumpsted William gent 588021 588021 Bumpsted, William, of Becclys, Suff, gent 0
3794606 1956191 1956191 defendant Leycett John shoemaker 588021 588021 Leycett, John, of Becclys, Suff, shoemaker 2
3795605 1956509 1956509 defendant Garneys Anne widow 588021 588021 Garneys, Anne, of Becclys, Suff, widow 1
3800093 1957954 1957954 defendant Stanfeld Richard yeoman 588021 588021 Stanfeld, Richard, of Becclys, Suff, yeoman 1
3803985 1959162 1959162 defendant Rushmer John smith 588021 588021 Rushmer, John, of Becclys, Suff, smith 0
3805540 1959674 1959674 defendant Rayner John husbandman 588021 588021 Rayner, John, of Becclys, Suff, husbandman 0
3819590 1964003 1964003 defendant Note William   588021 588021 Note, William, of Becclys, Suff, worsted weaver 0
3831343 1967691 1967691 defendant Gunvyle Richard gent 588021 588021 Gunvyle, Richard, of Becclys, Suff, gent 2
3833283 1968336 1968336 defendant Axham Robert beer brewer 588021 588021 Axham, Robert, of Becclys, Suff, beer brewer 3
3839652 1970326 1970326 defendant Chapleyn Thomas husbandman 588021 588021 Chapleyn, Thomas, of Becclys, Suff, husbandman 0
3857871 1976101 1976101 defendant Wryght Martin yeoman 588021 588021 Wryght, Martin, of Becclys, Suff, yeoman 0
3864066 1978166 1978166 defendant Wolsy Robert sherman 588021 588021 Wolsy, Robert, of Becclys, Suff, sherman 0
3866315 1978966 1978966 defendant Grene Robert   588021 588021 Grene, Robert, of Becclys, Suff, tallow chandler 0
3866317 1978967 1978967 defendant Grene Robert   588021 588021 Grene, Robert, of Becclys, Suff, tallow chandler 0
3866321 1978968 1978968 defendant Losse Richard tanner 588021 588021 Losse, Richard, of Becclys, Suff, tanner 0
3872094 1980897 1980897 defendant Turly John pedder 588021 588021 Turly, John, of Becclys, Suff, pedder 1
3874886 1981822 1981822 defendant Wolcy Robert yeoman 588021 588021 Wolcy, Robert, of Becclys, Suff, yeoman 0
3881951 1984221 1984221 defendant Losse Richard tanner 588021 588021 Losse, Richard, of Becclys, Suff, tanner 0
3882541 1984426 1984426 defendant Loft Richard tanner 588021 588021 Loft, Richard, of Becclys, Suff, tanner 2
3888471 1986405 1986405 defendant Gatys John yeoman 588021 588021 Gatys, John, of Becclys, Suff, yeoman 2
3890464 1987067 1987067 defendant Broun Thomas merchant 588021 588021 Broun, Thomas, of Becclys, Suff, merchant 3
3893028 1987914 1987914 defendant Waters John cordwainer 588021 588021 Waters, John, of Becclys, Suff, cordwainer 0
3893979 1988207 1988207 defendant Bradley John tanner 588021 588021 Bradley, John, of Becclys, Suff, tanner 0
3893984 1988208 1988208 defendant Bradley John tanner 588021 588021 Bradley, John, of Becclys, Suff, tanner 0
3895414 1988676 1988676 defendant Royse William cordwainer 588021 588021 Royse, William, of Becclys, Suff, cordwainer 0
3895419 1988678 1988678 defendant Royse William cordwainer 588021 588021 Royse, William, of Becclys, Suff, cordwainer 1
3897427 1989352 1989352 defendant Grene Agnes widow 588021 588021 Grene, Agnes, of Becclys, suff, widow 2
3902220 1990979 1990979 defendant Bacon Robert gent 588021 588021 Bacon, Robert, of Becclys, Suff, gent 0
3908391 1993102 1993102 defendant Eglyn John husbandman 588021 588021 Eglyn, John, of Becclys, Suff, husbandman 3
3973617 2015343 2015343 defendant Mannyng Robert   588021 588021 Mannyng, Robert, of Becclys, Suff, yeoman, administrators of 1
4653888 2247125 2247125 defendant Thurlberne Henry baker 588021 588021 Thurlberne, Henry, of Becclys, Suff, baker 0
4780054 2289765 2289765 defendant Wyske Simon husbandman 588021 588021 Wyske, Simon, of Becclys, Suff, husbandman 2
4780812 2289997 2289997 defendant Maundevyle Robert tailor 588021 588021 Maundevyle, Robert, of Becclys, Suff, tailor 1
4783189 2290757 2290757 defendant Wynferthyng William husbandman 588021 588021 Wynferthyng, William, of Becclys, Suff, husbandman 0
4786603 2291860 2291860 plaintiff Garveys Peter esq 588021 588021 Garveys, Peter, of Becclys, Suff, esq 0
4786605 2291861 2291861 plaintiff Garveys Peter esq 588021 588021 Garveys, Peter, of Becclys, Suff, esq 0
4801555 2296668 2296668 defendant Wynneferthyng William yeoman 588021 588021 Wynneferthyng, William, of Becclys, Suff, yeoman 0
4801558 2296669 2296669 defendant Wynneferthyng William husbandman 588021 588021 Wynneferthyng, William, of Becclys, Suff, husbandman 0
4839303 2308219 2308219 defendant Grove William yeoman 588021 588021 Grove, William, of Becclys, Suff, yeoman 1
4863803 2315652 2315652 defendant Wynferthyng William gent 588021 588021 Wynferthyng, William, of Becclys, Suff, gent 2
4880001 2320658 2320658 defendant Wynferthyng William gent 588021 588021 Wynferthyng, William, of Becclys, Suff, gent 2
4906654 2328668 2328668 defendant Bennys Thomas mercer 588021 588021 Bennys, Thomas, of Becclys, Suff, mercer 3
4950176 2342019 2342019 defendant Massy Mathew boatman 588021 588021 Massy, Mathew, of Becclys, Suff, boatman 5
4959971 2344944 2344944 defendant Skut Richard husbandman 588021 588021 Skut, Richard, of Becclys, Suff, husbandman 0
4959975 2344945 2344945 defendant Skut Richard husbandman 588021 588021 Skut, Richard, of Becclys, Suff, husbandman 0
4975922 2349761 2349761 defendant Story William painter 588021 588021 Story, William, of Becclys, Suff, painter 0
5016664 2361764 2361764 defendant Chese John husbandman 588021 588021 Chese, John, of Becclys, Suff, husbandman 0
5030897 2365907 2365907 defendant Ingram Walter hosier 588021 588021 Ingram, Walter, of Becclys, Suff, hosier 3
5053333 2372600 2372600 defendant Goderyche William yeoman 588021 588021 Goderyche, William, of Becclys, Suff, yeoman 0
5055925 2373339 2373339 defendant Pareys Adam butcher 588021 588021 Pareys, Adam, of Becclys, Suff, butcher 2
5055930 2373340 2373340 defendant Pareys Adam butcher 588021 588021 Pareys, Adam, of Becclys, Suff, butcher 2
5063326 2375565 2375565 defendant Mutford William chandler 588021 588021 Mutford, William, of Becclys, Suff, chandler 0
5063330 2375566 2375566 defendant Mutford William chandler 588021 588021 Mutford, William, of Becclys, Suff, chandler 0
5066858 2376615 2376615 defendant Garveys Edmund esq 588021 588021 Garveys, Edmund, of Becclys, Suff, esq 0
5091595 2383931 2383931 defendant Garnysch or Garneys Edmund esq 588021 588021 Garnysch or Garneys, Edmund, of Becclys, Suff, esq 3
5104184 2387648 2387648 defendant Danyell Henry husbandman 588021 588021 Danyell, Henry, of Becclys, Suff, husbandman 3
5116079 2391132 2391132 defendant Rede John   588021 588021 Rede, John, of Becclys, Suff, mercant 0
5116442 2391242 2391242 defendant Jurdon Robert smith 588021 588021 Jurdon, Robert, of Becclys, Suff, smith 2
5148533 2400696 2400696 defendant Neve Thomas mercer 588021 588021 (Neve, Thomas, of Becclys, Suff, mercer 3
5164343 2405306 2405306 defendant Sewale Thomas yeoman 588021 588021 Sewale, Thomas, of Becclys, Suff, yeoman 3
5167789 2406291 2406291 defendant Nene Thomas mercer 588021 588021 (Nene, Thomas, of Becclys, Suff, mercer 3
5177607 2409144 2409144 defendant Sewale Thomas yeoman 588021 588021 Sewale, Thomas, of Becclys, Suff, yeoman 3
5213385 2419644 2419644 defendant Sewall Thomas yeoman 588021 588021 Sewall, Thomas, of Becclys, Suff, yeoman 1
5220704 2421748 2421748 defendant Fen- John gent 588021 588021 Fen-, John, of Becclys, Suff, gent 2
5254659 2431578 2431578 defendant Manwode Robert baker 588021 588021 Manwode, Robert, of Becclys, Suff, baker 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);