names

143 rows where place_id = 594048

✎ 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
3614364 1872144 1872144 defendant Byngham John yeoman 594048 594048 Byngham, John, of Dover, Kent, yeoman 5
3618667 1873465 1873465 defendant Hexstall Edward gent 594048 594048 Hexstall, Edward, of Dover, Kent, gent 0
3640880 1907592 1907592 defendant Weldon Robert yeoman 594048 594048 Weldon, Robert, of Dover, Kent, yeoman 0
3641520 1907804 1907804 defendant Waren John gent 594048 594048 Waren, John, of Dover, Kent, gent 1
3655771 1912065 1912065 defendant Copulyche William chaplain 594048 594048 Copulyche, William, of Dover, Kent, chaplain 1
3683925 1921106 1921106 defendant Welden Robert mercer 594048 594048 Welden, Robert, of Dover, Kent, mercer 0
3690582 1923220 1923220 defendant Goodlade Thomas yeoman 594048 594048 Goodlade, Thomas, of Dover, Kent, yeoman 2
3690588 1923221 1923221 defendant Goodlade Thomas yeoman 594048 594048 Goodlade, Thomas, of Dover, Kent, yeoman 2
3690591 1923222 1923222 plaintiff Gregory John   594048 594048 Gregory, John, of Dover, Kent 0
3690592 1923222 1923222 defendant Lewys William yeoman 594048 594048 Lewys, William, of Dover, Kent, yeoman 0
3690604 1923226 1923226 plaintiff Gregorye John   594048 594048 Gregorye, John, of Dover, Kent 0
3705922 1928137 1928137 defendant Weltden or Welterden Robert gent 594048 594048 Weltden or Welterden, Robert, of Dover, Kent, gent 0
3705926 1928138 1928138 defendant Weltden Robert gent 594048 594048 Weltden, Robert, of Dover, Kent, gent 0
3722802 1933399 1933399 defendant Bendbow William yeoman 594048 594048 Bendbow, William, of Dover, Kent, yeoman 0
3722805 1933400 1933400 defendant Weldon Robert   594048 594048 Weldon, Robert, of Dover, Kent 0
3753894 1943165 1943165 defendant Cooper Robert clerk 594048 594048 Cooper, Robert, of Dover, Kent, clerk 1
3765275 1946805 1946805 defendant Vaughan Thomas yeoman 594048 594048 Vaughan, Thomas, of Dover, Kent, yeoman 0
3796251 1956692 1956692 defendant Marshall Thomas yeoman 594048 594048 Marshall, Thomas, of Dover, Kent, yeoman 2
3797014 1956944 1956944 defendant Thomson John clerk 594048 594048 Thomson, John, of Dover, Kent, clerk 1
3808550 1960551 1960551 defendant Benger Richard clerk 594048 594048 Benger, Richard, of Dover, Kent, clerk 0
3818767 1963775 1963775 defendant Benger Richard clerk 594048 594048 Benger, Richard, of Dover, Kent, clerk 0
3819259 1963913 1963913 defendant Weltden Robert gent 594048 594048 Weltden, Robert, of Dover, Kent, gent 0
3827602 1966495 1966495 plaintiff Broke John (legal representative) 594048 594048 Broke, John, of Dover, Kent, gent, executors of 0
3827607 1966496 1966496 plaintiff Broke John (legal representative) 594048 594048 Broke, John, of Dover, Kent, gent, executors of 0
3898672 1989763 1989763 defendant Granger William gent 594048 594048 Granger, William, of Dover, Kent, gent 2
3932359 2001121 2001121 defendant Waryn John, senior alderman 594048 594048 Waryn, John, senior, of Dover, Kent, alderman 1
3937722 2002949 2002949 defendant Tomson Philip baker 594048 594048 Tomson, Philip, of Dover, Kent, baker 2
3945771 2005594 2005594 defendant Mylward John yeoman 594048 594048 Mylward, John, of Dover, Kent, yeoman 0
3950897 2007380 2007380 defendant Hannyngton William gent 594048 594048 Hannyngton, William, of Dover, Kent, gent 0
3951842 2007705 2007705 defendant Warren Thomas gent 594048 594048 (Warren, Thomas, of Dover, Kent, gent 2
3953046 2008130 2008130 defendant Mynge Alexander   594048 594048 Mynge, Alexander, of Dover, Kent, gent, jurat 0
3953724 2008377 2008377 defendant Hanyngton William gent 594048 594048 Hanyngton, William, of Dover, Kent, gent 0
3954800 2008747 2008747 defendant Barlye Arthur gent 594048 594048 Barlye, Arthur, of Dover, Kent, gent 2
3955092 2008844 2008844 defendant Mylward John beer brewer 594048 594048 Mylward, John, of Dover, Kent, beer brewer 0
3962348 2011415 2011415 defendant Hudson John tailor 594048 594048 Hudson, John, of Dover, Kent, tailor 0
3962351 2011416 2011416 defendant Hudson John tailor 594048 594048 Hudson, John, of Dover, Kent, tailor 0
3965193 2012438 2012438 plaintiff Barley John gent 594048 594048 Barley, John, of Dover, Kent, gent 0
3977824 2016816 2016816 defendant Mylward John searcher 594048 594048 Mylward, John, of Dover, Kent, searcher 0
3981132 2018009 2018009 defendant Pendryd John yeoman 594048 594048 Pendryd, John, of Dover, Kent, yeoman 1
3981806 2018251 2018251 plaintiff Robyns John gent 594048 594048 Robyns, John, of Dover, Kent, gent 0
3985723 2019654 2019654 defendant Blackwowte William tailor 594048 594048 Blackwowte, William, of Dover, Kent, tailor 0
3986790 2020017 2020017 defendant Stone alias Hewson John yeoman 594048 594048 Stone alias Hewson, John, of Dover, Kent, yeoman 0
3995243 2023038 2023038 defendant Robyns John gent 594048 594048 Robyns, John, of Dover, Kent, gent 0
4007144 2027330 2027330 defendant Mylward John searcher 594048 594048 Mylward, John, of Dover, Kent, searcher 0
4007545 2027482 2027482 defendant Cokerell Thomas yeoman 594048 594048 Cokerell, Thomas, of Dover, Kent, yeoman 2
4010447 2028508 2028508 plaintiff Parker Giles merchant 594048 594048 Parker, Giles, of Dover, Kent, merchant 0
4030922 2035724 2035724 defendant Hannyngton William   594048 594048 Hannyngton, William, of Dover, Kent, gebnt 0
4035405 2037336 2037336 defendant Hanyngton William yeoman 594048 594048 Hanyngton, William, of Dover, Kent, yeoman 2
4035412 2037337 2037337 defendant Hannyngton William yeoman 594048 594048 Hannyngton, William, of Dover, Kent, yeoman 2
4055790 2044453 2044453 defendant Lovell William butcher 594048 594048 Lovell, William, of Dover, Kent, butcher 1
4066653 2048368 2048368 defendant Haynes John vintner 594048 594048 Haynes, John, of Dover, Kent, vintner 0
4066655 2048369 2048369 defendant Haynes John vintner 594048 594048 Haynes, John, of Dover, Kent, vintner 0
4078906 2052752 2052752 defendant Haynes John vintner 594048 594048 Haynes, John, of Dover, Kent, vintner 0
4088007 2056006 2056006 defendant Harflett William gent 594048 594048 Harflett, William, of Dover, Kent, gent 0
4101680 2060907 2060907 defendant Lucas John beer brewer 594048 594048 Lucas, John, of Dover, Kent, beer brewer 2
4108486 2063290 2063290 defendant Heynes John vintner 594048 594048 Heynes, John, of Dover, Kent, gent, vintner 2
4108490 2063291 2063291 defendant Heynes John vintner 594048 594048 Heynes, John, of Dover, Kent, gent, vintner 2
4191387 2092555 2092555 defendant Hannyngton William gent 594048 594048 Hannyngton, William, of Dover, Kent, gent 0
4232691 2106939 2106939 defendant Harwood Henry fishmonger 594048 594048 Harwood, Henry, of Dover, Kent, fishmonger 0
4237430 2108683 2108683 defendant Allen Thomas gent 594048 594048 Allen, Thomas, of Dover, Kent, gent 0
4241584 2110171 2110171 defendant Marshe Robert yeoman 594048 594048 Marshe, Robert, of Dover, Kent, yeoman 0
4260905 2116612 2116612 defendant Pulman Richard   594048 594048 Pulman, Richard, of Dover, Kent, shipwright 0
4260915 2116614 2116614 defendant Pulman Richard   594048 594048 Pulman, Richard, of Dover, Kent, shipwright 0
4271800 2120144 2120144 defendant Knap or Knappe John merchant 594048 594048 Knap or Knappe, John, of Dover, Kent, merchant 0
4276313 2121658 2121658 defendant Swan Francis gent 594048 594048 Swan, Francis, of Dover, Kent, gent 0
4295972 2128658 2128658 defendant Wood Roland yeoman 594048 594048 Wood, Roland, of Dover, Kent, yeoman 1
4334115 2141688 2141688 defendant Packnam Mathew gent 594048 594048 Packnam, Mathew, of Dover, kent, gent 0
4338229 2143112 2143112 defendant Binge George merchant 594048 594048 Binge, George, of Dover, Kent, merchant 0
4342897 2144789 2144789 defendant Berger John tanner 594048 594048 Berger, John, of Dover, Kent, tanner 0
4347245 2146295 2146295 defendant Haynes John vintner 594048 594048 Haynes, John, of Dover, Kent, vintner 0
4352176 2147997 2147997 defendant Parker Robert merchant 594048 594048 Parker, Robert, of Dover, Kent, merchant 1
4353652 2148497 2148497 defendant Bargar alias Bargrove John tanner 594048 594048 Bargar alias Bargrove, John, of Dover, Kent, tanner 0
4393037 2162283 2162283 defendant Bonnett Robert mariner 594048 594048 Bonnett, Robert, of Dover, Kent, mariner 0
4673695 2257402 2257402 defendant Louther Geoffrey esq 594048 594048 Louther, Geoffrey, of Dover, Kent, esq 0
4721797 2272150 2272150 defendant Quyntyne William gent 594048 594048 Quyntyne, William, of Dover, Kent, gent 1
4734311 2275904 2275904 defendant Quyntyn William gent 594048 594048 Quyntyn, William, of Dover, Kent, gent 0
4754231 2281701 2281701 defendant Oxenden Thomas husbandman 594048 594048 Oxenden, Thomas, of Dover, Kent, husbandman 2
4775896 2288461 2288461 defendant Byngle John yeoman 594048 594048 Byngle, John, of Dover, Kent, yeoman 1
4806999 2298386 2298386 defendant Sindyr Peter clerk 594048 594048 Sindyr, Peter, of Dover, Kent, clerk 3
4823586 2303467 2303467 defendant Hert Robert yeoman 594048 594048 Hert, Robert, of Dover, Kent, yeoman 2
4848728 2311069 2311069 defendant Bathe John mercer 594048 594048 Bathe, John, of Dover, Kent, mercer 0
4856997 2313570 2313570 defendant Nesam Walter gent 594048 594048 Nesam, Walter, of Dover, Kent, gent 0
4858134 2313914 2313914 defendant Pesam Walter gent 594048 594048 Pesam, Walter, of Dover, Kent, gent 0
4873293 2318600 2318600 defendant Altham Peter merchant 594048 594048 Altham, Peter, of Dover, Kent, merchant 0
4873296 2318601 2318601 defendant Altham Peter merchant 594048 594048 Altham, Peter, of Dover, Kent, merchant 0
4901793 2327166 2327166 defendant Louther Geoffrey esq 594048 594048 Louther, Geoffrey, of Dover, Kent, esq 0
4928146 2335233 2335233 defendant Neseham Walter gent 594048 594048 Neseham, Walter, of Dover, Kent, gent 0
4950504 2342116 2342116 defendant Brewys William merchant 594048 594048 Brewys, William, of Dover, Kent, merchant 1
5006160 2358690 2358690 defendant Newynton Thomas   594048 594048 Newynton, Thomas, of Dover, Kent, glove maker 4
5017690 2362049 2362049 defendant Petyt Thomas husbandman 594048 594048 (Petyt, Thomas, of Dover, Kent, husbandman 5
5020779 2362973 2362973 defendant Audlaby or Andlaby Nicholas merchant 594048 594048 Audlaby or Andlaby, Nicholas, of Dover, Kent, merchant 0
5062211 2375256 2375256 defendant Andelaby or Audelaby Nicholas merchant 594048 594048 Andelaby or Audelaby, Nicholas, of Dover, Kent, merchant 0
5062216 2375258 2375258 defendant Andelaby or Audelaby Nicholas merchant 594048 594048 Andelaby or Audelaby, Nicholas, of Dover, Kent, merchant 0
5109189 2389111 2389111 defendant Tomson John butcher 594048 594048 Tomson, John, of Dover, Kent, butcher 3
5111381 2389721 2389721 defendant Petle John yeoman 594048 594048 Petle, John, of Dover, Kent, yeoman 0
5117308 2391495 2391495 defendant Mytron William gent 594048 594048 Mytron, William, of Dover, Kent, gent 3
5179796 2409829 2409829 defendant Briggis John merchant 594048 594048 Briggis, John, of Dover, Kent, merchant 2
5189124 2412552 2412552 defendant Hexstall Thomas gent 594048 594048 Hexstall, Thomas, of Dover, Kent, gent 1
5189126 2412552 2412552 defendant (not given) Richard rector of Blake 594048 594048 Blake, Richard, of Dover, Kent, clerk & rector of the church within 3
5189129 2412553 2412553 defendant Hexstall Thomas gent 594048 594048 Hexstall, Thomas, of Dover, Kent, gent 1

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);