names

145 rows where place_id = 586932

✎ 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
3590022 1864518 1864518 defendant Besyn Richard fisher 586932 586932 Besyn, Richard, of Royston, Herts, fisher 1
3648216 1909840 1909840 defendant Willoys Thomas husbandman 586932 586932 Willoys, Thomas, of Royston, Herts, husbandman 2
3675287 1918310 1918310 defendant Willons Thomas yeoman 586932 586932 Willons, Thomas, of Royston, Herts, yeoman 0
3687821 1922355 1922355 defendant Anabull John sherman 586932 586932 Anabull, John, of Royston, Herts, sherman 1
3725398 1934237 1934237 defendant Wyllons Thomas husbandman 586932 586932 Wyllons, Thomas, of Royston, Herts, husbandman 0
3799282 1957690 1957690 defendant Cole John innholder 586932 586932 Cole, John, of Royston, Herts, innholder 1
3811558 1961510 1961510 defendant Bell Robert yeoman 586932 586932 Bell, Robert, of Royston, Herts, yeoman 0
3839046 1970138 1970138 defendant Hogeson Robert innholder 586932 586932 Hogeson, Robert, of Royston, Herts, innholder 3
3856062 1975521 1975521 defendant Clerke Henry chapman 586932 586932 Clerke, Henry, of Royston, Herts, chapman 0
3856067 1975522 1975522 defendant Clerke Henry chapman 586932 586932 Clerke, Henry, of Royston, Herts, chapman 0
3898646 1989755 1989755 defendant Taylor Thomas tailor 586932 586932 Taylor, Thomas, of Royston, Herts, tailor 0
3910076 1993675 1993675 defendant Marten John yeoman 586932 586932 Marten, John, of Royston, Herts, yeoman 0
3918844 1996624 1996624 defendant Showell John yeoman 586932 586932 Showell, John, of Royston, Herts, yeoman 0
3923659 1998225 1998225 defendant Holt Thomas yeoman 586932 586932 Holt, Thomas, of Royston, Herts, yeoman 0
3925361 1998796 1998796 plaintiff Whytakers John (legal representative) 586932 586932 Whytakers, John, of Royston, Herts, yeoman, executor of 0
3948872 2006671 2006671 plaintiff Dixe John   586932 586932 Dixe, John, of Royston, Herts 0
4001223 2025216 2025216 defendant Chester Edward esq 586932 586932 Chester, Edward, of Royston, Herts, esq 0
4007887 2027593 2027593 defendant Whittacres John gent 586932 586932 Whittacres, John, of Royston, Herts, gent 2
4007895 2027594 2027594 defendant Whittacres William gent 586932 586932 Whittacres, William, of Royston, Herts, gent 3
4039278 2038677 2038677 defendant Burde Henry tailor 586932 586932 Burde, Henry, of Royston, Herts, tailor 0
4068213 2048933 2048933 defendant Edlyn Edward esq 586932 586932 Edlyn, Edward, of Royston, Herts, husbandman, servant to Edward Chester, esq 0
4077176 2052122 2052122 plaintiff Snell or Suell John maltster 586932 586932 Snell or Suell, John, of Royston, Herts, maltster 0
4118481 2066902 2066902 defendant Byrd Henry tailor 586932 586932 Byrd, Henry, of Royston, Herts, tailor 1
4122230 2068255 2068255 defendant Chambers Peter gent 586932 586932 Chambers, Peter, of Royston, Herts, gent 0
4122511 2068359 2068359 defendant Burdell William chapman 586932 586932 Burdell, William, of Royston, Herts, chapman 0
4122515 2068360 2068360 defendant Burdell William chapman 586932 586932 Burdell, William, of Royston, Herts, chapman 0
4123217 2068605 2068605 defendant Burdall William chapman 586932 586932 Burdall, William, of Royston, Herts, chapman 0
4127496 2070129 2070129 defendant Welson Lawrence chapman 586932 586932 Welson, Lawrence, of Royston, Herts, chapman 0
4143771 2075981 2075981 defendant Burham Samuel yeoman 586932 586932 (Burham, Samuel, of Royston, Herts, yeoman 3
4145436 2076562 2076562 defendant Chambers Peter gent 586932 586932 Chambers, Peter, of Royston, Herts, gent 0
4179269 2088226 2088226 defendant Lyng John yeoman 586932 586932 Lyng, John, of Royston, Herts, yeoman 3
4195320 2093911 2093911 defendant Filodde Barnaby yeoman 586932 586932 Filodde, Barnaby, of Royston, Herts, yeoman 0
4208723 2098601 2098601 defendant Amye Roger yeoman 586932 586932 Amye, Roger, of Royston, Herts, yeoman 0
4227227 2105002 2105002 defendant Morley Mark gent 586932 586932 Morley, Mark, of Royston, Herts, gent 0
4228431 2105425 2105425 defendant Pette John chapman 586932 586932 Pette, John, of Royston, Herts, chapman 0
4243553 2110832 2110832 defendant Crowche John saddler 586932 586932 Crowche, John, of Royston, Herts, saddler 0
4245538 2111483 2111483 defendant Pette John chapman 586932 586932 Pette, John, of Royston, Herts, chapman 0
4248276 2112413 2112413 defendant Westley Robert haberdasher 586932 586932 Westley, Robert, of Royston, Herts, haberdasher 1
4249329 2112760 2112760 defendant Wright Thomas vintner 586932 586932 Wright, Thomas, of Royston, Herts, vintner 1
4249656 2112869 2112869 defendant Seigmore James maltster 586932 586932 Seigmore, James, of Royston, Herts, maltster 3
4253904 2114304 2114304 defendant Crowche John saddler 586932 586932 Crowche, John, of Royston, Herts, saddler 0
4262668 2117184 2117184 defendant Westley Robert haberdasher 586932 586932 Westley, Robert, of Royston, Herts, haberdasher 1
4264064 2117633 2117633 defendant Wygmore James maltster 586932 586932 Wygmore, James, of Royston, Herts, maltster 3
4288815 2126054 2126054 defendant Crowche John saddler 586932 586932 Crowche, John, of Royston, Herts, yeoman, saddler 0
4305885 2132196 2132196 defendant Crowche John saddler 586932 586932 Crowche, John, of Royston, Herts, yeoman, saddler 0
4311836 2134276 2134276 defendant Twynne William shoemaker 586932 586932 Twynne, William, of Royston, Herts, shoemaker 1
4328020 2139691 2139691 defendant Crowche John saddler 586932 586932 Crowche, John, of Royston, Herts, yeoman, saddler 1
4329128 2140055 2140055 defendant Hall Francis   586932 586932 Hall, Francis, of Royston, Herts, gent, son of John Hall 0
4335989 2142321 2142321 defendant Bland Richard yeoman 586932 586932 Bland, Richard, of Royston, Herts, yeoman 0
4346595 2146062 2146062 defendant Blande Richard yeoman 586932 586932 Blande, Richard, of Royston, Herts, yeoman 0
4350291 2147364 2147364 defendant Earle William   586932 586932 Earle, William, of Royston, Herts, apothecary 1
4367252 2153345 2153345 defendant Crowche John saddler 586932 586932 Crowche, John, of Royston, Herts, yeoman, saddler 0
4374245 2155859 2155859 defendant Earle William   586932 586932 Earle, William, of Royston, Herts, apothecary 1
4385558 2159855 2159855 defendant Bland Richard yeoman 586932 586932 Bland, Richard, of Royston, Herts, yeoman 0
4389813 2161217 2161217 defendant Swan Richard yeoman 586932 586932 Swan, Richard, of Royston, Herts, yeoman 1
4396412 2163374 2163374 defendant Mott Edward chapman 586932 586932 Mott, Edward, of Royston, Herts, chapman 0
4620702 2237460 2237460 defendant West Richard   586932 586932 West, Richard, of Royston, Herts 0
4664973 2250525 2250525 defendant Grene John husbandman 586932 586932 Grene, John, of Royston, Herts, husbandman 0
4664975 2250526 2250526 defendant Grene John husbandman 586932 586932 Grene, John, of Royston, Herts, husbandman 0
4666918 2255384 2255384 defendant Lote John sadler 586932 586932 Lote, John, of Royston, Herts, sadler 0
4678724 2258952 2258952 defendant Tunworth John baker 586932 586932 Tunworth, John, of Royston, Herts, baker 0
4685487 2261055 2261055 defendant Grey Thomas butcher 586932 586932 Grey, Thomas, of Royston, Herts, butcher 0
4690517 2262591 2262591 defendant Grey Thomas burcher 586932 586932 Grey, Thomas, of Royston, Herts, burcher 0
4710404 2268608 2268608 defendant Grey Thomas butcher 586932 586932 Grey, Thomas, of Royston, Herts, butcher 0
4711786 2269013 2269013 defendant Porter William ostler 586932 586932 Porter, William, of Royston, Herts, ostler 0
4711792 2269014 2269014 defendant Porter William ostler 586932 586932 Porter, William, of Royston, Herts, ostler 0
4718979 2271282 2271282 defendant Grey Thomas butcher 586932 586932 Grey, Thomas, of Royston, Herts, butcher 1
4718982 2271283 2271283 defendant Gray Thomas butcher 586932 586932 Gray, Thomas, of Royston, Herts, butcher 0
4720820 2271843 2271843 defendant Grey Thomas butcher 586932 586932 Grey, Thomas, of Royston, Herts, butcher 2
4731240 2274970 2274970 defendant Valentyne Alice   586932 586932 Valentyne, Alice, of Royston, Herts, servant 0
4741335 2277961 2277961 defendant Grey Thomas butcher 586932 586932 Grey, Thomas, of Royston, Herts, butcher 1
4760709 2283692 2283692 defendant Brereton John tailor 586932 586932 (Brereton, John, of Royston, Herts, tailor 1
4793831 2294191 2294191 defendant Mason Robert husbandman 586932 586932 Mason, Robert, of Royston, Herts, husbandman 1
4813408 2300307 2300307 defendant Herewyche John glover 586932 586932 Herewyche, John, of Royston, Herts, glover 1
4836284 2307325 2307325 defendant Goodman John sadler 586932 586932 Goodman, John, of Royston, Herts, sadler 3
4865564 2316194 2316194 defendant Fullere William husbandman 586932 586932 Fullere, William, of Royston, Herts, husbandman 1
4868637 2317164 2317164 defendant Byrches John draper 586932 586932 Byrches, John, of Royston, Herts, draper 1
4868642 2317165 2317165 defendant Byrches John draper 586932 586932 Byrches, John, of Royston, Herts, draper 1
4876183 2319510 2319510 defendant Skynner William chapman 586932 586932 Skynner, William, of Royston, Herts, chapman 1
4879693 2320568 2320568 defendant Miles Isabel   586932 586932 Miles, Isabel, of Royston, Herts, widow or Miles, Richard 2
4886322 2322581 2322581 defendant Okys John husbandman 586932 586932 Okys, John, of Royston, Herts, husbandman 0
4894674 2325004 2325004 defendant Baker Peter yeoman 586932 586932 Baker, Peter, of Royston, Herts, yeoman 0
4901836 2327181 2327181 defendant Jankyn Alexander butcher 586932 586932 Jankyn, Alexander, of Royston, Herts, butcher 0
4910020 2329659 2329659 defendant Grenele John ostler 586932 586932 Grenele, John, of Royston, Herts, ostler 0
4915058 2331213 2331213 defendant Bonde Robert husbandman 586932 586932 Bonde, Robert, of Royston, Herts, husbandman 1
4918801 2332393 2332393 defendant Baker Peter husbandman 586932 586932 Baker, Peter, of Royston, Herts, husbandman 2
4929631 2335682 2335682 defendant Skynner William chapman 586932 586932 Skynner, William, of Royston, Herts, chapman 0
4940022 2338905 2338905 defendant Bonde Robert mercer 586932 586932 Bonde, Robert, of Royston, Herts, mercer 0
4942218 2339555 2339555 defendant Berkebowe John husbandman 586932 586932 Berkebowe, John, of Royston, Herts, husbandman 1
4950906 2342250 2342250 defendant Adam John yeoman 586932 586932 Adam, John, of Royston, Herts, yeoman 2
4955204 2343515 2343515 defendant Okes John yeoman 586932 586932 Okes, John, of Royston, Herts, yeoman 0
4978929 2350656 2350656 defendant Bonde Robert mercer 586932 586932 Bonde, Robert, of Royston, Herts, mercer 0
4980529 2351116 2351116 defendant Baker Peter husbandman 586932 586932 Baker, Peter, of Royston, Herts, husbandman 1
4981597 2351410 2351410 defendant Okes John yeoman 586932 586932 Okes, John, of Royston, Herts, yeoman 0
4992463 2354632 2354632 defendant Bonde Robert mercer 586932 586932 Bonde, Robert, of Royston, Herts, mercer 0
4996856 2355917 2355917 defendant Wodeward Thomas miller 586932 586932 Wodeward, Thomas, of Royston, Herts, miller 0
5000379 2356979 2356979 defendant Bonde Robert baker 586932 586932 Bonde, Robert, of Royston, Herts, baker 0
5002552 2357658 2357658 defendant Bonde Robert baker 586932 586932 Bonde, Robert, of Royston, Herts, baker 5
5004034 2358068 2358068 defendant Edward John husbandman 586932 586932 Edward, John, of Royston, Herts, husbandman 0
5004042 2358069 2358069 defendant Edward John husbandman 586932 586932 Edward, John, of Royston, Herts, 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);