names

251 rows where place_id = 588442

✎ 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
3594527 1865918 1865918 defendant Beche John yeoman 588442 588442 Beche, John, of Rochester, Kent, yeoman 2
3594532 1865919 1865919 defendant Bethe or Beche John yeoman 588442 588442 Bethe or Beche, John, of Rochester, Kent, yeoman 2
3601325 1868081 1868081 defendant Bruyn William gent 588442 588442 Bruyn, William, of Rochester, Kent, gent 0
3606574 1869728 1869728 defendant Borden Thomas innholder 588442 588442 Borden, Thomas, of Rochester, Kent, innholder 1
3608899 1870440 1870440 defendant Borden Thomas innholder 588442 588442 Borden, Thomas, of Rochester, Kent, innholder 0
3608901 1870441 1870441 defendant Borden Thomas innholder 588442 588442 Borden, Thomas, of Rochester, Kent, innholder 0
3623026 1874729 1874729 defendant Barker Thomas fishmonger 588442 588442 Barker, Thomas, of Rochester, Kent, fishmonger 0
3623044 1874732 1874732 defendant Barker Thomas fishmonger 588442 588442 Barker, Thomas, of Rochester, Kent, fishmonger 0
3623049 1874733 1874733 defendant Kotyng William   588442 588442 Kotyng, William, of Rochester, Kent, tallow chandler 0
3625343 1875465 1875465 defendant Bruyn William gent 588442 588442 Bruyn, William, of Rochester, Kent, gent 0
3658203 1912819 1912819 defendant Thurston John   588442 588442 Thurston, John, of Rochester, Kent, inn holder 2
3665812 1915247 1915247 defendant Wyggyns Richard yeoman 588442 588442 Wyggyns, Richard, of Rochester, Kent, yeoman 0
3665841 1915251 1915251 defendant Wygyns Richard yeoman 588442 588442 Wygyns, Richard, of Rochester, Kent, yeoman 4
3671203 1916964 1916964 defendant Ade William merchant of the staple 588442 588442 Ade, William, of Rochester, Kent, innholder, merchant of the staple 4
3674457 1918059 1918059 defendant Warner William mercer 588442 588442 Warner, William, of Rochester, Kent, mercer 0
3674459 1918060 1918060 defendant Warner William mercer 588442 588442 Warner, William, of Rochester, Kent, mercer 0
3682206 1920539 1920539 defendant Crosby Thomas smith 588442 588442 Crosby, Thomas, of Rochester, Kent, smith 0
3690462 1923184 1923184 defendant Wygyn Richard innholder 588442 588442 Wygyn, Richard, of Rochester, Kent, innholder 1
3697384 1925400 1925400 defendant Adams Thomas innholder 588442 588442 Adams, Thomas, of Rochester, Kent, innholder 4
3697390 1925401 1925401 defendant Adams Thomas innholder 588442 588442 Adams, Thomas, of Rochester, Kent, innholder 4
3734370 1936988 1936988 defendant Goddard William yeoman 588442 588442 Goddard, William, of Rochester, Kent, yeoman 0
3769527 1948131 1948131 defendant Wygen Richard gent 588442 588442 Wygen, Richard, of Rochester, Kent, gent 1
3800943 1958204 1958204 defendant Maye James haberdasher 588442 588442 Maye, James, of Rochester, Kent, haberdasher 1
3801940 1958506 1958506 defendant Lee John yeoman 588442 588442 Lee, John, of Rochester, Kent, yeoman 1
3813823 1962236 1962236 defendant Lee John mercer 588442 588442 Lee, John, of Rochester, Kent, mercer: Dynsay, John, of Bedford, mercer 2
3814157 1962331 1962331 defendant Pylbeme Thomas innholder 588442 588442 Pylbeme, Thomas, of Rochester, Kent, innholder 4
3816642 1963106 1963106 defendant Turnar Thomas chapman 588442 588442 Turnar, Thomas, of Rochester, Kent, chapman 0
3816644 1963107 1963107 defendant Turnar Thomas chapman 588442 588442 Turnar, Thomas, of Rochester, Kent, chapman 0
3842300 1971136 1971136 defendant May Richard innholder 588442 588442 May, Richard, of Rochester, Kent, innholder 0
3874242 1981605 1981605 defendant Maye James yeoman 588442 588442 Maye, James, of Rochester, Kent, yeoman 2
3887363 1986037 1986037 defendant Perpoynt Robert tailor 588442 588442 Perpoynt, Robert, of Rochester, Kent, tailor 1
3925150 1998721 1998721 defendant Watson Robert innholder 588442 588442 Watson, Robert, of Rochester, Kent, innholder 4
3934673 2001891 2001891 defendant Comyars Robert yeoman 588442 588442 Comyars, Robert, of Rochester, Kent, yeoman 1
3943418 2004813 2004813 defendant Some Thomas yeoman 588442 588442 Some, Thomas, of Rochester, Kent, yeoman 0
3954793 2008745 2008745 defendant Sone Thomas innholder 588442 588442 Sone, Thomas, of Rochester, Kent, innholder 0
3955414 2008960 2008960 defendant Sone or Soane Thomas innholder 588442 588442 Sone or Soane, Thomas, of Rochester, Kent, innholder 0
3963968 2012005 2012005 defendant Some Thomas yeoman 588442 588442 Some, Thomas, of Rochester, Kent, yeoman 0
3967457 2013253 2013253 defendant Butler John chapman 588442 588442 Butler, John, of Rochester, Kent, chapman 2
3974800 2015750 2015750 defendant Gonson Michael purser of one of Queen's ships 588442 588442 Gonson, Michael, of Rochester, Kent, mariner, purser of one of Queen's ships 0
3975523 2016004 2016004 defendant Robynson William mariner 588442 588442 Robynson, William, of Rochester, Kent, mariner 1
3994596 2022814 2022814 plaintiff Collyn Francis alderman 588442 588442 Collyn, Francis, of Rochester, Kent, mercer, alderman 0
4035358 2037319 2037319 defendant Gaynesford Arthur gent 588442 588442 Gaynesford, Arthur, of Rochester, Kent, gent 2
4035403 2037336 2037336 defendant Gonston or Gouston Michael yeoman 588442 588442 Gonston or Gouston, Michael, of Rochester, Kent, yeoman 0
4035410 2037337 2037337 defendant Gonston Michael yeoman 588442 588442 Gonston, Michael, of Rochester, Kent, yeoman 0
4091412 2057217 2057217 defendant Butler John innholder 588442 588442 Butler, John, of Rochester, Kent, innholder 0
4091784 2057354 2057354 defendant Claye Richard vintner 588442 588442 Claye, Richard, of Rochester, Kent, vintner 0
4096822 2059195 2059195 defendant Jones John yeoman 588442 588442 Jones, John, of Rochester, Kent, yeoman 2
4101591 2060876 2060876 defendant Butler John innholder 588442 588442 Butler, John, of Rochester, Kent, mercer, innholder 1
4101685 2060908 2060908 defendant Butler John yeoman 588442 588442 Butler, John, of Rochester, Kent, yeoman 3
4105561 2062271 2062271 defendant Cooke John yeoman 588442 588442 Cooke, John, of Rochester, Kent, yeoman 1
4106998 2062798 2062798 defendant Bowe John innkeeper 588442 588442 Bowe, John, of Rochester, Kent, innkeeper 1
4112625 2064772 2064772 defendant Waters Thomas mercer 588442 588442 Waters, Thomas, of Rochester, Kent, mercer 2
4125461 2069387 2069387 defendant Besbitche george chapman 588442 588442 Besbitche, george, of Rochester, Kent, chapman 2
4134609 2072708 2072708 defendant Bespyche George innholder 588442 588442 Bespyche, George, of Rochester, Kent, innholder 0
4134612 2072709 2072709 defendant Bowle John yeoman 588442 588442 Bowle, John, of Rochester, Kent, yeoman 0
4164016 2082942 2082942 defendant Borne Thomas miller 588442 588442 Borne, Thomas, of Rochester, Kent, miller 0
4164700 2083162 2083162 defendant Wentworth William hackneyman 588442 588442 Wentworth, William, of Rochester, Kent, hackneyman 2
4180400 2088621 2088621 defendant White Francis clerk 588442 588442 White, Francis, of Rochester, Kent, clerk 0
4230606 2106200 2106200 defendant Hocker John merchant tailor 588442 588442 Hocker, John, of Rochester, Kent, gent, or of London, merchant tailor 0
4235481 2107977 2107977 defendant Beacher Edward esq 588442 588442 Beacher, Edward, of Rochester, Kent, esq 0
4272575 2120404 2120404 defendant Hooker John merchant tailor 588442 588442 Hooker, John, of Rochester, Kent, gent, or of London, merchant tailor 1
4278447 2122398 2122398 defendant Thomson Thomas yeoman 588442 588442 Thomson, Thomas, of Rochester, Kent, yeoman, kinsman of Walter Wood, of St Mary, Hundred of Howe, Kent, yeoman 0
4284275 2124427 2124427 defendant Lebson Humphrey innholder 588442 588442 Lebson, Humphrey, of Rochester, Kent, innholder 0
4287402 2125546 2125546 defendant Bespityne George gent 588442 588442 Bespityne, George, of Rochester, Kent, gent 0
4304500 2131711 2131711 defendant Bespiche George gent 588442 588442 Bespiche, George, of Rochester, Kent, gent 0
4307140 2132632 2132632 defendant Waters Thomas yeoman 588442 588442 Waters, Thomas, of Rochester, Kent, yeoman 0
4326969 2139351 2139351 defendant Bestpiche George gent 588442 588442 Bestpiche, George, of Rochester, kent, gent 1
4330729 2140578 2140578 defendant Bespiche George gent 588442 588442 Bespiche, George, of Rochester, Kent, gent 0
4333649 2141535 2141535 defendant Waters Thomas chapman 588442 588442 Waters, Thomas, of Rochester, Kent, chapman 1
4335467 2142135 2142135 defendant Waters Thomas chapman 588442 588442 Waters, Thomas, of Rochester, Kent, chapman 0
4363192 2151898 2151898 defendant London William tailor 588442 588442 London, William, of Rochester, Kent, tailor 0
4401732 2165175 2165175 defendant Waters Thomas mercer 588442 588442 Waters, Thomas, of Rochester, Kent, mercer 0
4408559 2167448 2167448 defendant Revington Edward ironmonger 588442 588442 Revington, Edward, of Rochester, Kent, ironmonger 3
4582544 2225984 2225984 defendant Stynt Robert   588442 588442 Stynt, Robert, of Rochester, Kent 3
4615895 2235966 2235966 defendant Rerysby John   588442 588442 Rerysby, John, of Rochester, Kent 0
4622563 2238035 2238035 defendant Frere Alice   588442 588442 Frere, Alice, of Rochester, Kent, formerly wife of Thomas 1
4622616 2238052 2238052 defendant Frere Thomas   588442 588442 Frere, Thomas, of Rochester, Kent, cook, adminstratrix of 0
4635114 2241827 2241827 defendant Marchant John   588442 588442 Marchant, John, of Rochester, Kent 2
4656616 2247962 2247962 defendant Wevere John hosteler 588442 588442 Wevere, John, of Rochester, Kent, hosteler 1
4661736 2249513 2249513 defendant Clerk Thomas   588442 588442 Clerk, Thomas, of Rochester, Kent, bailiff 0
4661740 2249514 2249514 defendant Clerk Thomas   588442 588442 Clerk, Thomas, of Rochester, kent, bailiff 0
4683633 2260482 2260482 defendant Esby John taverner 588442 588442 Esby, John, of Rochester, Kent, taverner 4
4699764 2265369 2265369 defendant Bocher Henry shipman 588442 588442 Bocher, Henry, of Rochester, Kent, shipman 4
4700864 2265670 2265670 defendant Rerysby John yeoman 588442 588442 Rerysby, John, of Rochester, kent, yeoman 0
4701441 2265854 2265854 defendant Bolour Thomas chapman 588442 588442 Bolour, Thomas, of Rochester, Kent, chapman 4
4701447 2265855 2265855 defendant Bolour Thomas chapman 588442 588442 Bolour, Thomas, of Rochester, Kent, chapman 4
4703633 2266516 2266516 defendant Mone or Move Agnes widow 588442 588442 Mone or Move, Agnes, of Rochester, Kent, widow 0
4703665 2266525 2266525 defendant Mone or Move Agnes widow 588442 588442 Mone or Move, Agnes, of Rochester, Kent, widow 0
4708658 2268084 2268084 defendant Wychyngham John brewer 588442 588442 Wychyngham, John, of Rochester, Kent, brewer 0
4708677 2268088 2268088 defendant Wychyngham John husbandman 588442 588442 Wychyngham, John, of Rochester, Kent, husbandman 0
4708688 2268091 2268091 defendant Wychyngham John draper 588442 588442 Wychyngham, John, of Rochester, Kent, draper 0
4711068 2268814 2268814 defendant Mone Thomas baker 588442 588442 Mone, Thomas, of Rochester, Kent, baker 1
4712665 2269277 2269277 defendant Wychyngham John brewer 588442 588442 Wychyngham, John, of Rochester, Kent, brewer 0
4712669 2269278 2269278 defendant Wychyngham John brewer 588442 588442 Wychyngham, John, of Rochester, Kent, brewer 0
4720173 2271653 2271653 defendant Mason William miller 588442 588442 Mason, William, of Rochester, Kent, miller 2
4734098 2275847 2275847 defendant Savage Peter gent 588442 588442 Savage, Peter, of Rochester, Kent, gent 3
4736742 2276619 2276619 defendant Byle Walter yeoman 588442 588442 Byle, Walter, of Rochester, Kent, yeoman 2
4737540 2276853 2276853 defendant Ram William gent 588442 588442 Ram, William, of Rochester, Kent, gent 4
4737579 2276861 2276861 defendant Ram William gent 588442 588442 Ram, William, of Rochester, Kent, gent 4
4762952 2284396 2284396 defendant Bolour Thomas chapman 588442 588442 Bolour, Thomas, of Rochester, Kent, chapman 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);