names

113 rows where place_id = 591692

✎ 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
3605255 1869311 1869311 defendant Hale William husbandman 591692 591692 Hale, William, of Over, husbandman 0
3628587 1903814 1903814 defendant Cobbold John husbandman 591692 591692 Cobbold, John, of Over, husbandman 0
3630404 1904345 1904345 defendant Stevyn John butcher 591692 591692 Stevyn, John, of Over, butcher 0
3630409 1904346 1904346 defendant Stevyn John butcher 591692 591692 Stevyn, John, of Over, butcher 0
3630416 1904348 1904348 defendant Stevyn John butcher 591692 591692 Stevyn, John, of Over, butcher 0
3672731 1917477 1917477 defendant Sadeler John husbandman 591692 591692 Sadeler, John, of Over, husbandman 0
3693757 1924242 1924242 defendant Syne William smith 591692 591692 Syne, William, of Over, smith 1
3693780 1924252 1924252 defendant Smyth William smith 591692 591692 Smyth, William, of Over, smith 1
3706366 1928280 1928280 defendant Gosbyn Thomas husbandman 591692 591692 Gosbyn, Thomas, of Over, husbandman 2
3716626 1931496 1931496 defendant Castell Thomas yeoman 591692 591692 Castell, Thomas, of Over, yeoman 2
3717282 1931689 1931689 defendant Bowdyng William husbandman 591692 591692 Bowdyng, William, of Over, husbandman 4
3724885 1934069 1934069 defendant Saddelar William husbabndman 591692 591692 Saddelar, William, of Over, husbabndman 0
3734502 1937036 1937036 defendant Wright Thomas chaplain 591692 591692 Wright, Thomas, of Over, chaplain 0
3750031 1941926 1941926 defendant Makerell William husbandman 591692 591692 Makerell, William, of Over, husbandman 0
3752363 1942662 1942662 defendant Bleke John laborer 591692 591692 Bleke, John, of Over, laborer 0
3756768 1944089 1944089 defendant Dorsetur William yeoman 591692 591692 Dorsetur, William, of Over, yeoman 0
3757835 1944428 1944428 defendant Mitton Richard butcher 591692 591692 Mitton, Richard, of Over, butcher 1
3770017 1948283 1948283 defendant Hare Thomas shoemaker 591692 591692 Hare, Thomas, of Over, shoemaker 0
3792267 1955434 1955434 defendant Newton Thomas yeoman 591692 591692 Newton, Thomas, of Over, yeoman 0
3796507 1956780 1956780 defendant Dorcettour William husbandman 591692 591692 Dorcettour, William, of Over, husbandman 0
3812859 1961919 1961919 defendant Dyson Henry pulter 591692 591692 Dyson, Henry, of Over, pulter 3
3828016 1966628 1966628 defendant Starky Thomas yeoman 591692 591692 Starky, Thomas, of Over Whyttaker, yeoman 0
3851412 1974041 1974041 defendant Wyett Thomas miller 591692 591692 Wyett, Thomas, of Over, miller 0
3853517 1974724 1974724 defendant Cooke Richard husbandman 591692 591692 Cooke, Richard, of Over Whytaker, husbandman 0
3865635 1978726 1978726 defendant Mytton Henry butcher 591692 591692 Mytton, Henry, of Over, butcher 0
3867985 1979526 1979526 defendant Coke Richard husbandman 591692 591692 (Coke, Richard, of Over Whitaker, husbandman 1
3892174 1987637 1987637 defendant Mytton Matilda widow 591692 591692 Mytton, Matilda, of Over, widow 0
3898494 1989709 1989709 defendant Carpenter alias Alone James laborer 591692 591692 Carpenter alias Alone, James, of Over, laborer 0
3898496 1989710 1989710 defendant Carpenter alias Loo James husbandman 591692 591692 Carpenter alias Loo, James, of Over, husbandman 0
3903854 1991524 1991524 defendant ap Rotherawgh David ap Howell gent 591692 591692 ap Rotherawgh, David ap Howell, of Over Elvell, Radnor, gent 2
3904332 1991696 1991696 defendant Hernyngold Robert yeoman 591692 591692 Hernyngold, Robert, of Over, yeoman 2
3905162 1991990 1991990 defendant Hornyngold Ronert yeoman 591692 591692 Hornyngold, Ronert, of Over, yeoman 0
3907070 1992652 1992652 defendant Hornyngold Robert yeoman 591692 591692 Hornyngold, Robert, of Over, yeoman 0
3907071 1992652 1992652 defendant Boydon Richard yeoman 591692 591692 Boydon, Richard, of Over, yeoman 1
3907072 1992652 1992652 defendant Burman Nicholas weaver 591692 591692 Burman, Nicholas, of Over, weaver 2
3911127 1994048 1994048 defendant Castell Richard yeoman 591692 591692 Castell, Richard, of Over, yeoman 3
3914781 1995290 1995290 defendant Fox John husbandman 591692 591692 Fox, John, of Over, husbandman 0
3916167 1995792 1995792 defendant Boydun Richard yeoman 591692 591692 Boydun, Richard, of Over, yeoman 1
3928585 1999901 1999901 defendant Boydon Richard yeoman 591692 591692 Boydon, Richard, of Over, yeoman 1
3928586 1999901 1999901 defendant Loder Robert yeoman 591692 591692 Loder, Robert, of Over, yeoman 2
3928587 1999901 1999901 defendant Spryng John butcher 591692 591692 Spryng, John, of Over, butcher 3
3928588 1999901 1999901 defendant Byrchener John   591692 591692 Byrchener, John, of Over 4
3928589 1999901 1999901 defendant Tock or Cock William husbandman 591692 591692 Tock or Cock, William, of Over, husbandman 5
3928590 1999901 1999901 defendant Ile William husbandman 591692 591692 Ile, William, of Over, husbandman 6
3928591 1999901 1999901 defendant Coper Robert husbandman 591692 591692 Coper, Robert, of Over, husbandman 7
3928592 1999901 1999901 defendant Leke Thomas husbandman 591692 591692 Leke, Thomas, of Over, husbandman 8
3928593 1999901 1999901 defendant Cotton Thomas husbandman 591692 591692 Cotton, Thomas, of Over, husbandman 9
3928594 1999901 1999901 defendant Cotton Richard husbandman 591692 591692 Cotton, Richard, of Over, husbandman 10
3928595 1999901 1999901 defendant Symes William smith 591692 591692 Symes, William, of Over, smith 11
3970731 2014354 2014354 plaintiff Dodmer Brian   591692 591692 Dodmer, Brian, of Over 0
3997554 2023874 2023874 defendant Mylford Lawrence merchant 591692 591692 Mylford, Lawrence, of Over, merchant 2
4012474 2029183 2029183 defendant Skynner Edward husbandman 591692 591692 Skynner, Edward, of Over, husbandman 2
4012479 2029184 2029184 defendant Milford Lawrence merchant 591692 591692 Milford, Lawrence, of Over, merchant 2
4019363 2031658 2031658 defendant Gamme Richard husbandman 591692 591692 Gamme, Richard, of Over, husbandman 0
4121871 2068120 2068120 defendant Bynge John yeoman 591692 591692 Bynge, John, of Over, yeoman 0
4127516 2070134 2070134 defendant Bowles Francis gent 591692 591692 Bowles, Francis, of Over, gent 3
4132690 2072013 2072013 defendant Smyth John yeoman 591692 591692 Smyth, John, of Over, yeoman 2
4133309 2072236 2072236 defendant Woodhowse Luke tailor 591692 591692 Woodhowse, Luke, of Over, tailor 3
4133546 2072329 2072329 defendant Chaunge John husbandman 591692 591692 Chaunge, John, of Over Whittaker, husbandman 0
4144640 2076284 2076284 defendant Smythe John husbandman 591692 591692 Smythe, John, of Over, husbandman 0
4192040 2092774 2092774 defendant Gylbye William husbandman 591692 591692 Gylbye, William, of Over, husbandman 0
4193309 2093226 2093226 defendant Byng John yeoman 591692 591692 Byng, John, of Over, yeoman 0
4224535 2104061 2104061 defendant Waker Cuthbert husbandman 591692 591692 Waker, Cuthbert, of Over, husbandman 1
4253909 2114305 2114305 defendant Burham Edward maltster 591692 591692 Burham, Edward, of Over, or of Royston, Herts, Cams, maltster 2
4266696 2118504 2118504 defendant Pyeke William husbandman 591692 591692 Pyeke, William, of Over, husbandman 0
4294892 2128259 2128259 defendant Lawe Nicholas husbandman 591692 591692 Lawe, Nicholas, of Over, husbandman 0
4294893 2128259 2128259 defendant Merett Roger husbandman 591692 591692 Merett, Roger, of Over, husbandman 1
4296692 2128916 2128916 defendant Lawe Nicholas husbandman 591692 591692 Lawe, Nicholas, of Over, husbandman 1
4307858 2132889 2132889 defendant Jackson Thomas chapman 591692 591692 Jackson, Thomas, of Over, Cumber, chapman 0
4336743 2142580 2142580 defendant Pyke Robert, junior   591692 591692 Pyke, Robert, junior, of Over, yeoman, son of Robert Pike, senior, of Over husbandman 0
4336744 2142580 2142580 defendant Daunger Andrew husbandman 591692 591692 Daunger, Andrew, of Over, husbandman 1
4353152 2148330 2148330 defendant Pyke William husbandman 591692 591692 Pyke, William, of Over, husbandman 3
4605013 2232726 2232726 defendant Mayner Richard   591692 591692 Mayner, Richard, of Over 4
4628446 2239818 2239818 plaintiff Saxe John   591692 591692 Saxe, John, of Over 0
4650046 2246026 2246026 defendant Smyth John   591692 591692 Smyth, John, of Over, son of William 3
4665932 2250821 2250821 defendant Grene John butcher 591692 591692 Grene, John, of Over, butcher 0
4665933 2250821 2250821 defendant Cheyne Thomas husbandman 591692 591692 Cheyne, Thomas, of Over, husbandman 1
4669817 2256263 2256263 defendant Horsle John husbandman 591692 591692 Horsle, John, of Over Sloughter, husbandman 0
4685638 2261099 2261099 defendant Perys William husbandman 591692 591692 Perys, William, of Over, husbandman 2
4707448 2267706 2267706 defendant Pyrle John husbandman 591692 591692 Pyrle, John, of Over Sapy or Upper Sapey, husbandman 1
4734899 2276073 2276073 defendant Hervy Thomas husbandman 591692 591692 Hervy, Thomas, of Over, husbandman 0
4763159 2284462 2284462 defendant Sysmore Thomas carpenter 591692 591692 Sysmore, Thomas, of Over by Gloucester, carpenter 0
4787676 2292215 2292215 defendant Vyntener John husbandman 591692 591692 Vyntener, John, of Over Sloghter, husbandman 2
4844561 2309820 2309820 defendant Dawene William esq 591692 591692 Dawene, William, of Over, Chester, esq 0
4847668 2310763 2310763 defendant Box Edward husbandman 591692 591692 Box, Edward, of Over Segre or Upper Seagry, husbandman 0
4970117 2348014 2348014 defendant Fennemyll John husbandman 591692 591692 Fennemyll, John, of Over Sloghter, husbandman 0
4985926 2352707 2352707 defendant Sampson John, sen husbandman 591692 591692 Sampson, John, sen, of Over, husbandman 0
5082518 2381275 2381275 defendant Assheby Thomas clerk 591692 591692 Assheby, Thomas, of Over, clerk 0
5082519 2381275 2381275 defendant Mayner William husbandman 591692 591692 Mayner, William, of Over, husbandman 1
5082520 2381275 2381275 defendant Robert John husbandman 591692 591692 Robert, John, of Over, husbandman 2
5105507 2388057 2388057 defendant Grey Richard   591692 591692 Grey, Richard, of Over, servant 1
5143249 2399164 2399164 defendant Makerell Henry fishmonger 591692 591692 Makerell, Henry, of Over, fishmonger 1
5164570 2405370 2405370 defendant Makerell Henry fishmonger 591692 591692 Makerell, Henry, of Over, fishmonger 1
5301447 2445384 2445384 defendant Danyell John husbandman 591692 591692 Danyell, John, of Over Whitaker, husbandman 2
5342858 2457961 2457961 defendant Bartelot Maurice husbandman 591692 591692 Bartelot, Maurice, of Over, husbandman 0
5342859 2457961 2457961 defendant Kene Simon husbandman 591692 591692 Kene, Simon, of Over, husbandman 1
5432294 2484628 2484628 defendant Cryde Thomas husbandman 591692 591692 Cryde, Thomas, of Over Adber, husbandman 0
5440310 2487004 2487004 defendant Barker Robert yeoman 591692 591692 Barker, Robert, of Over Geyst or Upper Guist, yeoman 0
5448455 2489434 2489434 defendant Cryde Thomas husbandman 591692 591692 Cryde, Thomas, of Over Adber, husbandman 0
5460783 2493173 2493173 defendant Crede Thomas husbandman 591692 591692 Crede, Thomas, of Over Adber, 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);