names

402 rows where place_id = 586130

✎ 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
3587999 1863899 1863899 defendant Hoke William tailor 586130 586130 Hoke, William, of Hoo, tailor 0
3592932 1865409 1865409 defendant Ecoll Thomas yeoman 586130 586130 Ecoll, Thomas, of Hoo, yeoman 0
3597146 1866731 1866731 defendant Sherwyn Richard husbandman 586130 586130 Sherwyn, Richard, of Hoo, husbandman 1
3597267 1866764 1866764 defendant Parker John husbandman 586130 586130 Parker, John, of Hoo, husbandman 2
3597462 1866825 1866825 defendant Lambard John husbandman 586130 586130 Lambard, John, of Hoo, husbandman 0
3597466 1866827 1866827 defendant Scarlet William gent 586130 586130 Scarlet, William, of Hoo, gent 0
3598364 1867119 1867119 defendant Lamberd John husbandman 586130 586130 Lamberd, John, of Hoo, husbandman 3
3598384 1867125 1867125 defendant Scarlet William gent 586130 586130 Scarlet, William, of Hoo, gent 0
3598385 1867125 1867125 defendant Mason Thomas yeoman 586130 586130 Mason, Thomas, of Hoo, yeoman 1
3598386 1867125 1867125 defendant Denby John yeoman 586130 586130 Denby, John, of Hoo, yeoman 2
3604916 1869203 1869203 defendant Wodman Richard husbandman 586130 586130 Wodman, Richard, of Hoo, husbandman 1
3605442 1869367 1869367 defendant Jonson John carver 586130 586130 Jonson, John, of Hoo, carver 1
3608431 1870296 1870296 defendant Kent Robert clerk 586130 586130 Kent, Robert, of Hoo, clerk 0
3616504 1872798 1872798 defendant Pryke John husbandman 586130 586130 Pryke, John, of Hoo, husbandman 2
3620571 1874010 1874010 defendant Eycoll Thomas husbandman 586130 586130 Eycoll, Thomas, of Hoo, husbandman 0
3622984 1874715 1874715 defendant Lamberd John husbandman 586130 586130 Lamberd, John, of Hoo, husbandman 0
3625434 1875492 1875492 defendant Fraunsham Richard yeoman 586130 586130 Fraunsham, Richard, of Hoo, yeoman 0
3628313 1903717 1903717 defendant Kyng Ralph chaplain 586130 586130 Kyng, Ralph, of Hoo, chaplain 1
3633718 1905355 1905355 defendant Pakeman Thomas   586130 586130 Pakeman, Thomas, of Hoo, notary 0
3641587 1907829 1907829 defendant Rolfe Stephen husbandman 586130 586130 Rolfe, Stephen, of Hoo, husbandman 0
3644892 1908813 1908813 defendant Charles William husbandman 586130 586130 Charles, William, of Hoo, husbandman 1
3657430 1912584 1912584 defendant Alton William husbandman 586130 586130 Alton, William, of Hoo, husbandman 0
3659256 1913151 1913151 defendant Clerk William husbandman 586130 586130 Clerk, William, of Hoo, husbandman 0
3660332 1913492 1913492 defendant Parker Thomas yeoman 586130 586130 Parker, Thomas, of Hoo, yeoman 1
3660333 1913492 1913492 defendant Alton William yeoman 586130 586130 Alton, William, of Hoo, yeoman 2
3660334 1913492 1913492 defendant Jerman Thomas husbandman 586130 586130 Jerman, Thomas, of Hoo, husbandman 3
3660335 1913492 1913492 defendant Braybroke John husbandman 586130 586130 Braybroke, John, of Hoo, husbandman 4
3662724 1914259 1914259 defendant Warner John miller 586130 586130 Warner, John, of Hoo, miller 0
3665067 1915022 1915022 defendant Palmer Richard husbandman 586130 586130 Palmer, Richard, of Hoo, husbandman 0
3673362 1917686 1917686 plaintiff Eston Robert   586130 586130 Eston, Robert, of Hoo 0
3673543 1917750 1917750 defendant Markaunt Thomas yeoman 586130 586130 Markaunt, Thomas, of Hoo, yeoman 0
3676310 1918635 1918635 plaintiff Iden Robert gent 586130 586130 Iden, Robert, of Hoo, gent 0
3687370 1922225 1922225 defendant Barbour John diker 586130 586130 Barbour, John, of Hoo, diker 0
3689945 1923014 1923014 defendant Pakeman Thomas   586130 586130 Pakeman, Thomas, of Hoo, notary 0
3691873 1923618 1923618 defendant Warner John husbandman 586130 586130 Warner, John, of Hoo, husbandman 0
3694198 1924390 1924390 defendant Archer John husbandman 586130 586130 Archer, John, of Hoo, husbandman 0
3695917 1924960 1924960 defendant Warner John yeoman 586130 586130 Warner, John, of Hoo, yeoman 0
3698741 1925822 1925822 defendant Cobham Edward gent 586130 586130 Cobham, Edward, of Hoo, gent 0
3704418 1927679 1927679 defendant Pakeman Thomas   586130 586130 Pakeman, Thomas, of Hoo, notary 0
3712334 1930175 1930175 defendant Cobham Edward gent 586130 586130 Cobham, Edward, of Hoo, gent 0
3723199 1933526 1933526 defendant A Neston Robert yeoman 586130 586130 A Neston, Robert, of Hoo, yeoman 0
3725981 1934398 1934398 defendant Hakon John husbandman 586130 586130 Hakon, John, of Hoo, husbandman 0
3731915 1936214 1936214 defendant Pratt John husbandman 586130 586130 Pratt, John, of Hoo, husbandman 0
3740388 1938855 1938855 defendant Woodward Robert carver 586130 586130 Woodward, Robert, of Hoo, carver 0
3741790 1939295 1939295 defendant Barkar Richard gent 586130 586130 Barkar, Richard, of Hoo, gent 0
3748582 1941487 1941487 defendant Frankwell Richard yeoman 586130 586130 Frankwell, Richard, of Hoo, yeoman 0
3754105 1943230 1943230 defendant Barker Richard gent 586130 586130 Barker, Richard, of Hoo, gent 0
3756911 1944138 1944138 defendant Dorant Walter husbandman 586130 586130 Dorant, Walter, of Hoo, husbandman 0
3762956 1946046 1946046 defendant Barker Richard gent 586130 586130 Barker, Richard, of Hoo, gent 0
3762963 1946047 1946047 defendant Barker Richard gent 586130 586130 Barker, Richard, of Hoo, gent 0
3763944 1946365 1946365 defendant Shettell Richard husbandman 586130 586130 Shettell, Richard, of Hoo, husbandman 1
3769153 1948007 1948007 defendant Cobham Edward gent 586130 586130 Cobham, Edward, of Hoo, gent 0
3776193 1950300 1950300 defendant Malines John husbandman 586130 586130 Malines, John, of Hoo, husbandman 0
3794696 1956218 1956218 plaintiff Clerk William   586130 586130 Clerk, William, of Hoo 0
3798835 1957549 1957549 defendant Berker Richard gent 586130 586130 Berker, Richard, of Hoo, gent 2
3802143 1958566 1958566 defendant Frankwell Richard yeoman 586130 586130 Frankwell, Richard, of Hoo, yeoman 0
3812640 1961842 1961842 defendant Frankewell Richard yeoman 586130 586130 Frankewell, Richard, of Hoo, yeoman 0
3814333 1962395 1962395 defendant Johnson John   586130 586130 Johnson, John, of Hoo, shepherd 1
3814334 1962395 1962395 defendant Radclyff Margaret spinster 586130 586130 Radclyff, Margaret, of Hoo, spinster 2
3815117 1962648 1962648 defendant Barker Richard gent 586130 586130 Barker, Richard, of Hoo, gent 0
3824276 1965467 1965467 plaintiff Warner William (legal representative) 586130 586130 Warner, William, of Hoo, executors of 0
3824283 1965468 1965468 plaintiff Warner William (legal representative) 586130 586130 Warner, William, of Hoo, executors of 0
3824670 1965590 1965590 defendant Plotton John butcher 586130 586130 Plotton, John, of Hoo, butcher 1
3833821 1968510 1968510 plaintiff Malby Robert   586130 586130 Malby, Robert, of Hoo 0
3835286 1968977 1968977 defendant Schetyll Richard husbandman 586130 586130 Schetyll, Richard, of Hoo, husbandman 0
3845421 1972129 1972129 defendant Dorant Walter husbandman 586130 586130 Dorant, Walter, of Hoo, husbandman 2
3845432 1972131 1972131 defendant Doraunt Walter husbandman 586130 586130 Doraunt, Walter, of Hoo, husbandman 2
3855468 1975354 1975354 defendant Malby Robert husbandman 586130 586130 Malby, Robert, of Hoo, husbandman 0
3855469 1975354 1975354 defendant Bache Thomas husbandman 586130 586130 Bache, Thomas, of Hoo, husbandman 1
3855470 1975354 1975354 defendant Dey Richard husbandman 586130 586130 Dey, Richard, of Hoo, husbandman 2
3857538 1975992 1975992 defendant Marshall William mariner 586130 586130 Marshall, William, of Hoo, mariner 1
3857539 1975992 1975992 defendant Farrar John mariner 586130 586130 Farrar, John, of Hoo, mariner 2
3860130 1976886 1976886 defendant Algar John husbandman 586130 586130 Algar, John, of Hoo, husbandman 0
3861963 1977460 1977460 defendant Woodward Ellen widow 586130 586130 Woodward, Ellen, of Hoo, widow 1
3874968 1981851 1981851 plaintiff Dorant Walter husbandman 586130 586130 Dorant, Walter, of Hoo, husbandman 0
3879442 1983376 1983376 defendant Bache Thomas husbandman 586130 586130 Bache, Thomas, of Hoo, husbandman 2
3896840 1989154 1989154 defendant Cryall Christopher husbandman 586130 586130 Cryall, Christopher, of Hoo, husbandman 0
3903463 1991383 1991383 defendant Ellys John husbandman 586130 586130 Ellys, John, of Hoo, husbandman 2
3903521 1991405 1991405 defendant Asshewell Henry husbandman 586130 586130 Asshewell, Henry, of Hoo, husbandman 0
3903524 1991406 1991406 defendant Asshewell Henry husbandman 586130 586130 Asshewell, Henry, of Hoo, husbandman 1
3913931 1995005 1995005 defendant Pykes Richard husbandman 586130 586130 Pykes, Richard, of Hoo, husbandman 1
3913932 1995005 1995005 defendant Smyth John husbandman 586130 586130 Smyth, John, of Hoo, husbandman 2
3913933 1995005 1995005 defendant Dockyng Richard laborer 586130 586130 Dockyng, Richard, of Hoo, laborer 3
3913934 1995005 1995005 defendant Farwell Robert laborer 586130 586130 Farwell, Robert, of Hoo, laborer 4
3917118 1996085 1996085 defendant Asshewell Henry husbandman 586130 586130 Asshewell, Henry, of Hoo, husbandman 0
3917120 1996086 1996086 defendant Asshewell Henry husbandman 586130 586130 Asshewell, Henry, of Hoo, husbandman 0
3923260 1998090 1998090 defendant Crowche George smith 586130 586130 Crowche, George, of Hoo, smith 0
3944197 2005076 2005076 plaintiff Bardon Richard (legal representative) 586130 586130 Bardon, Richard, of Hoo, miller, executors of 0
3944200 2005077 2005077 plaintiff Bardon Richard (legal representative) 586130 586130 Bardon, Richard, of Hoo, miller, executors of 0
3980671 2017850 2017850 defendant Becheley Henry husbandman 586130 586130 Becheley, Henry, of Hoo, husbandman 2
3982153 2018378 2018378 defendant Dossell William weaver 586130 586130 Dossell, William, of Hoo, weaver 0
3985848 2019703 2019703 plaintiff Warner Thomas   586130 586130 Warner, Thomas, of Hoo 0
3989356 2020935 2020935 defendant Butler Richard butcher 586130 586130 Butler, Richard, of Hoo, butcher 0
4019148 2031587 2031587 plaintiff Warne Thomas (legal representative) 586130 586130 Warne, Thomas, of Hoo, yeoman, executor of 0
4053351 2043575 2043575 defendant Kynswall Richard husbandman 586130 586130 Kynswall, Richard, of Hoo, husbandman 0
4053352 2043575 2043575 defendant Walter Robert husbandman 586130 586130 Walter, Robert, of Hoo, husbandman 1
4053353 2043575 2043575 defendant Walcock John husbandman 586130 586130 Walcock, John, of Hoo, husbandman 2
4079511 2052971 2052971 defendant Weekes George yeoman 586130 586130 Weekes, George, of Hoo, yeoman 0
4115828 2065945 2065945 defendant Aberge John husbandman 586130 586130 Aberge, John, of Hoo, husbandman 0
4117285 2066485 2066485 defendant Aberge John yeoman 586130 586130 Aberge, John, of Hoo, 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);