names

1,342 rows where place_id = 587058

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590351 1864623 1864623 defendant Wagstaff Thomas miller 587058 587058 Wagstaff, Thomas, of Sutton, miller 1
3595153 1866115 1866115 plaintiff Male John   587058 587058 Male, John, of Sutton 0
3595155 1866116 1866116 plaintiff Male John   587058 587058 Male, John, of Sutton 0
3596424 1866510 1866510 defendant Hosbern Thomas husbandman 587058 587058 Hosbern, Thomas, of Sutton, husbandman 1
3596425 1866510 1866510 defendant Bydnaham Robert husbandman 587058 587058 Bydnaham, Robert, of Sutton, husbandman 2
3596427 1866510 1866510 defendant Payn John husbandman 587058 587058 Payn, John, of Sutton, husbandman 4
3597990 1866996 1866996 defendant Agge Thomas husbandman 587058 587058 Agge, Thomas, of Sutton, husbandman 1
3597991 1866996 1866996 defendant Broderton Richard husbandman 587058 587058 Broderton, Richard, of Sutton, husbandman 2
3607781 1870084 1870084 defendant Barker Thomas husbandman 587058 587058 Barker, Thomas, of Sutton, husbandman 1
3607783 1870084 1870084 defendant Langton Edward husbandman 587058 587058 Langton, Edward, of Sutton, husbandman 3
3608075 1870178 1870178 defendant Edmond Sayer yeoman 587058 587058 Edmond, Sayer, of Sutton, yeoman 0
3608076 1870178 1870178 defendant Edmond Robert yeoman 587058 587058 Edmond, Robert, of Sutton, yeoman 1
3608077 1870178 1870178 defendant Hip or Hiper John yeoman 587058 587058 Hip or Hiper, John, of Sutton, yeoman 2
3608078 1870178 1870178 defendant Joye John, junior yeoman 587058 587058 Joye, John, junior, of Sutton, yeoman 3
3609188 1870534 1870534 defendant Blakburn John husbandman 587058 587058 Blakburn, John, of Sutton, husbandman 1
3611274 1871203 1871203 defendant Brystyll Thomas husbandman 587058 587058 Brystyll, Thomas, of Sutton, husbandman 1
3611275 1871203 1871203 defendant Holand John husbandman 587058 587058 Holand, John, of Sutton, husbandman 2
3611276 1871203 1871203 defendant Broun Richard husbandman 587058 587058 Broun, Richard, of Sutton, husbandman 3
3611277 1871203 1871203 defendant Broun William husbandman 587058 587058 Broun, William, of Sutton, husbandman 4
3611278 1871203 1871203 defendant Clerk John husbandman 587058 587058 Clerk, John, of Sutton, husbandman 5
3611279 1871203 1871203 defendant Tuhagys John husbandman 587058 587058 Tuhagys, John, of Sutton, husbandman 6
3611280 1871203 1871203 defendant Stoukis or Stoubis John husbandman 587058 587058 Stoukis or Stoubis, John, of Sutton, husbandman 7
3611281 1871203 1871203 defendant Spencer Robert husbandman 587058 587058 Spencer, Robert, of Sutton, husbandman 8
3611282 1871203 1871203 defendant Spencer Simon husbandman 587058 587058 Spencer, Simon, of Sutton, husbandman 9
3611283 1871203 1871203 defendant Brontan Thomas husbandman 587058 587058 Brontan, Thomas, of Sutton, husbandman 10
3611497 1871269 1871269 defendant Broun Hugh laborer 587058 587058 Broun, Hugh, of Sutton, laborer 0
3611498 1871269 1871269 defendant Reynold John, junior laborer 587058 587058 Reynold, John, junior, of Sutton, laborer 1
3626308 1903085 1903085 defendant Chatour John carpenter 587058 587058 Chatour, John, of Sutton, carpenter 0
3626309 1903085 1903085 defendant Thomas Richard   587058 587058 Thomas, Richard, of Sutton, salt weller 1
3626310 1903085 1903085 defendant Worschip Simon husbandman 587058 587058 Worschip, Simon, of Sutton, husbandman 2
3628611 1903822 1903822 defendant Mark Robert yeoman 587058 587058 Mark, Robert, of Sutton, yeoman 0
3628613 1903823 1903823 defendant Thomas Richard yeoman 587058 587058 Thomas, Richard, of Sutton, yeoman 0
3630988 1904512 1904512 defendant Mere William yeoman 587058 587058 Mere, William, of Sutton, yeoman 0
3634185 1905494 1905494 defendant Clerk Thomas husbandman 587058 587058 Clerk, Thomas, of Sutton, husbandman 2
3638859 1906975 1906975 defendant Brondoun Robert husbandman 587058 587058 Brondoun, Robert, of Sutton, husbandman 4
3641055 1907643 1907643 defendant Jakson William husbandman 587058 587058 Jakson, William, of Sutton, husbandman 0
3648871 1910036 1910036 defendant Wright Robert yeoman 587058 587058 Wright, Robert, of Sutton, yeoman 0
3649527 1910242 1910242 defendant Bramley Richard glover 587058 587058 Bramley, Richard, of Sutton, glover 0
3649528 1910242 1910242 defendant Hunt Thomas husbandman 587058 587058 Hunt, Thomas, of Sutton, husbandman 1
3649531 1910243 1910243 defendant Bramley Richard glover 587058 587058 Bramley, Richard, of Sutton, glover 0
3649532 1910243 1910243 defendant Hunt Thomas husbandman 587058 587058 Hunt, Thomas, of Sutton, husbandman 1
3656634 1912329 1912329 plaintiff Clerk Richard (legal representative) 587058 587058 Clerk, Richard, of Sutton, executors of 0
3662397 1914152 1914152 defendant Here Thomas butcher 587058 587058 Here, Thomas, of Sutton, butcher 1
3665561 1915179 1915179 defendant Barteram James husbandman 587058 587058 Barteram, James, of Sutton, husbandman 0
3668233 1916011 1916011 defendant Smyth Thomas husbandman 587058 587058 Smyth, Thomas, of Sutton, husbandman 0
3668234 1916011 1916011 defendant Smyth John husbandman 587058 587058 Smyth, John, of Sutton, husbandman 1
3669233 1916314 1916314 defendant Bayly Thomas husbandman 587058 587058 Bayly, Thomas, of Sutton, husbandman 4
3673620 1917780 1917780 defendant Wright Robert yeoman 587058 587058 Wright, Robert, of Sutton, yeoman 0
3674037 1917920 1917920 defendant Holbeche Thomas husbandman 587058 587058 Holbeche, Thomas, of Sutton, husbandman 0
3676303 1918632 1918632 defendant Derluff William husbandman 587058 587058 Derluff, William, of Sutton, husbandman 0
3676304 1918632 1918632 defendant Osgate Thomas husbandman 587058 587058 Osgate, Thomas, of Sutton, husbandman 1
3676552 1918709 1918709 defendant Coney Roger yeoman 587058 587058 Coney, Roger, of Sutton, yeoman 0
3676563 1918710 1918710 defendant Wright Robert husbandman 587058 587058 Wright, Robert, of Sutton, husbandman 4
3676576 1918712 1918712 defendant Lamberd Henry yeoman 587058 587058 Lamberd, Henry, of Sutton, yeoman 2
3676577 1918712 1918712 defendant Derlof William husbandman 587058 587058 Derlof, William, of Sutton, husbandman 3
3677796 1919106 1919106 plaintiff Man John   587058 587058 Man, John, of Sutton 0
3678678 1919396 1919396 defendant Pytte Thomas husbandman 587058 587058 Pytte, Thomas, of Sutton, husbandman 0
3680786 1920071 1920071 plaintiff Rynge John   587058 587058 Rynge, John, of Sutton 0
3683103 1920832 1920832 defendant Lean John yeoman 587058 587058 Lean, John, of Sutton, yeoman 0
3685922 1921754 1921754 defendant Aleyn Richard husbandman 587058 587058 Aleyn, Richard, of Sutton juxta Dovor, husbandman 0
3686953 1922085 1922085 defendant Grene John husbandman 587058 587058 Grene, John, of Sutton, husbandman 0
3687653 1922307 1922307 defendant Lewyn Thomas, junior laborer 587058 587058 Lewyn, Thomas, junior, of Sutton, laborer 1
3689044 1922735 1922735 plaintiff Dyngell Richard, senior   587058 587058 Dyngell, Richard, senior, of Sutton 0
3690132 1923072 1923072 defendant Foster William chaplain 587058 587058 Foster, William, of Sutton, chaplain 1
3691073 1923370 1923370 defendant Huddelston Robert husbandman 587058 587058 Huddelston, Robert, of Sutton, husbandman 0
3692920 1923986 1923986 plaintiff Sutton John   587058 587058 Sutton, John, of Sutton 1
3693414 1924157 1924157 plaintiff Manne John husbandman 587058 587058 Manne, John, of Sutton, husbandman 0
3693415 1924157 1924157 defendant Holdon SImon yeoman 587058 587058 Holdon, SImon, of Sutton, yeoman 0
3693515 1924179 1924179 defendant Chylton John yeoman 587058 587058 Chylton, John, of Sutton, yeoman 1
3693516 1924179 1924179 defendant Tomson Robert husbandman 587058 587058 Tomson, Robert, of Sutton, husbandman 2
3695200 1924720 1924720 defendant Onneslowe Edward husbandman 587058 587058 Onneslowe, Edward, of Sutton, husbandman 1
3696819 1925229 1925229 defendant Sheffeld Thomas gent 587058 587058 Sheffeld, Thomas, of Sutton, gent 0
3697414 1925410 1925410 defendant Garnett Thomas   587058 587058 Garnett, Thomas, of Sutton, millwright 0
3698390 1925718 1925718 defendant Mather John, senior mariner 587058 587058 Mather, John, senior, of Sutton, mariner 0
3698391 1925718 1925718 defendant Mather John, junior mariner 587058 587058 Mather, John, junior, of Sutton, mariner 1
3698402 1925721 1925721 defendant Milleward Jenkyn husbandman 587058 587058 Milleward, Jenkyn, of Sutton, husbandman 1
3698403 1925721 1925721 defendant Baker Philip husbandman 587058 587058 Baker, Philip, of Sutton, husbandman 2
3700892 1926524 1926524 defendant Appulby John husbandman 587058 587058 Appulby, John, of Sutton, husbandman 2
3702859 1927167 1927167 defendant Peirson John yeoman 587058 587058 Peirson, John, of Sutton, yeoman 1
3703570 1927393 1927393 defendant Lambert Henry yeoman 587058 587058 Lambert, Henry, of Sutton, yeoman 0
3704201 1927612 1927612 defendant Wright Robert, junior yeoman 587058 587058 Wright, Robert, junior, of Sutton, yeoman 0
3705295 1927943 1927943 defendant Couper Thomas thatcher 587058 587058 Couper, Thomas, of Sutton, thatcher 1
3705301 1927946 1927946 defendant Shawe William husbandman 587058 587058 Shawe, William, of Sutton, husbandman 0
3705334 1927958 1927958 defendant Gaunt Thomas weaver 587058 587058 Gaunt, Thomas, of Sutton, weaver 3
3706522 1928325 1928325 defendant Hipp John husbandman 587058 587058 Hipp, John, of Sutton, husbandman 0
3707591 1928670 1928670 plaintiff Man John husbandman 587058 587058 Man, John, of Sutton, husbandman 0
3708090 1928831 1928831 defendant Prytte Thomas husbandman 587058 587058 Prytte, Thomas, of Sutton, husbandman 0
3708091 1928831 1928831 defendant Wyllyams Thomas husbandman 587058 587058 Wyllyams, Thomas, of Sutton, husbandman 1
3708092 1928831 1928831 defendant Underwode Thomas husbandman 587058 587058 Underwode, Thomas, of Sutton, husbandman 2
3708094 1928831 1928831 defendant Wenland Walter husbandman 587058 587058 Wenland, Walter, of Sutton, husbandman 4
3709130 1929153 1929153 defendant Hareson Robert husbandman 587058 587058 Hareson, Robert, of Sutton, husbandman 0
3710776 1929687 1929687 defendant Sandham William husbandman 587058 587058 Sandham, William, of Sutton, husbandman 5
3711442 1929885 1929885 defendant Pytte Thomas husbandman 587058 587058 Pytte, Thomas, of Sutton, husbandman 0
3712908 1930358 1930358 defendant Man John yeoman 587058 587058 Man, John, of Sutton, yeoman 0
3712909 1930358 1930358 defendant Wylson Thomas yeoman 587058 587058 Wylson, Thomas, of Sutton, yeoman 1
3713040 1930404 1930404 defendant Taillour William husbandman 587058 587058 Taillour, William, of Sutton, husbandman 0
3713041 1930404 1930404 defendant Chaters John husbandman 587058 587058 Chaters, John, of Sutton, husbandman 1
3716138 1931337 1931337 plaintiff Chylton John (legal representative) 587058 587058 Chylton, John, of Sutton, yeoman, executors of 0
3717103 1931633 1931633 defendant Rawlet John husbandman 587058 587058 Rawlet, John, of Sutton, husbandman 0
3717412 1931728 1931728 defendant Lambert Henry yeoman 587058 587058 Lambert, Henry, of Sutton, yeoman 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);