names

99 rows where place_id = 594605

✎ 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
3616802 1872883 1872883 defendant Smarte John innholder 594605 594605 Smarte, John, of Blanford Forum, innholder 0
3636222 1906120 1906120 defendant Grey Roger mercer 594605 594605 Grey, Roger, of Blanford Forum, mercer 0
3644180 1908612 1908612 defendant Yong John mercer 594605 594605 Yong, John, of Blanford Forum, mercer 0
3658284 1912846 1912846 defendant Yong John mercer 594605 594605 Yong, John, of Blanford Forum, mercer 0
3684376 1921244 1921244 defendant Godard William butcher 594605 594605 Godard, William, of Blanford Forum, butcher 1
3687675 1922314 1922314 defendant Michell Isaac baker 594605 594605 Michell, Isaac, of Blanford Forum, baker 0
3687676 1922314 1922314 defendant Dyvet Richard baker 594605 594605 Dyvet, Richard, of Blanford Forum, baker 1
3695537 1924829 1924829 defendant Vyncent alias Hynd William fisher 594605 594605 Vyncent alias Hynd, William, of Blanford Forum, fisher 0
3708018 1928805 1928805 defendant Daccombe John   594605 594605 Daccombe, John, of Blanford Forum 0
3709459 1929262 1929262 defendant Vyncent alias Hynde William fisher 594605 594605 Vyncent alias Hynde, William, of Blanford Forum, fisher 0
3722575 1933321 1933321 defendant Dacomb John gent 594605 594605 Dacomb, John, of Blanford Forum, gent 0
3738955 1938389 1938389 defendant Mathewe Anker baker 594605 594605 Mathewe, Anker, of Blanford Forum, baker 0
3781676 1952010 1952010 defendant Cowper Robert mercer 594605 594605 Cowper, Robert, of Blanford Forum, mercer 0
3828829 1966895 1966895 defendant Goddard William butcher 594605 594605 Goddard, William, of Blanford Forum, butcher 0
3832215 1967987 1967987 defendant Chapell John innholder 594605 594605 Chapell, John, of Blanford Forum, innholder 0
3847333 1972726 1972726 plaintiff Harveste Edith widow 594605 594605 Harveste, Edith, of Blanford Forum, widow 0
3862383 1977611 1977611 defendant Goddard William husbandman 594605 594605 Goddard, William, of Blanford Forum, husbandman 0
3872956 1981168 1981168 defendant Pytte Richard draper 594605 594605 Pytte, Richard, of Blanford Forum, draper 1
3891129 1987300 1987300 defendant Johns John miller 594605 594605 Johns, John, of Blanford Forum, miller 0
3894250 1988295 1988295 defendant Gardyner Robert tanner 594605 594605 Gardyner, Robert, of Blanford Forum, tanner 0
3957974 2009852 2009852 defendant Ryves John gent 594605 594605 Ryves, John, of Blanford Forum, gent 1
3961744 2011207 2011207 defendant Grene William yeoman 594605 594605 Grene, William, of Blanford Forum, or of Bloxworth, Dorset, yeoman 0
3974321 2015588 2015588 plaintiff Hatchet John   594605 594605 Hatchet, John, of Blanford Forum 0
3996609 2023547 2023547 defendant Keynell John mercer 594605 594605 Keynell, John, of Blanford Forum, mercer 0
4023571 2033139 2033139 plaintiff Bastard Joan widow of Thomas Basterd 594605 594605 Bastard, Joan, of Blanford Forum, widow of Thomas Basterd 0
4026467 2034111 2034111 defendant Hatchett John mercer 594605 594605 Hatchett, John, of Blanford Forum, mercer 0
4026472 2034113 2034113 defendant Hatchett John mercer 594605 594605 Hatchett, John, of Blanford Forum, mercer 0
4032950 2036429 2036429 defendant Dasshewood William tailor 594605 594605 Dasshewood, William, of Blanford Forum, tailor 0
4063988 2047401 2047401 defendant Rawlyngson George chapman 594605 594605 Rawlyngson, George, of Blanford Forum, chapman 0
4080064 2053175 2053175 defendant Lillington Thomas glover 594605 594605 Lillington, Thomas, of Blanford Forum, glover 0
4111120 2064232 2064232 defendant Locke John draper 594605 594605 Locke, John, of Blanford Forum, draper 1
4112987 2064914 2064914 defendant Reape John yeoman 594605 594605 Reape, John, of Blanford Forum, yeoman 0
4123196 2068595 2068595 defendant Corbyn Ralph baker 594605 594605 Corbyn, Ralph, of Blanford Forum, baker 1
4184130 2089947 2089947 defendant Erberye Henry cordwainer 594605 594605 Erberye, Henry, of Blanford Forum, cordwainer 0
4191238 2092500 2092500 defendant Rowdon Richard innholder 594605 594605 Rowdon, Richard, of Blanford Forum, innholder 0
4204721 2097196 2097196 defendant Meade Thomas butcher 594605 594605 Meade, Thomas, of Blanford Forum, butcher 3
4206077 2097674 2097674 defendant Leighe or Lye John esq 594605 594605 Leighe or Lye, John, of Blanford Forum, or of Shorewell, Isle of Wight, Hants, esq 0
4206217 2097721 2097721 defendant Lighe or Lye John esq 594605 594605 Lighe or Lye, John, of Blanford Forum, or of Shorewell, Isle of Wight, Hants, esq 0
4206219 2097722 2097722 defendant Lighe John esq 594605 594605 Lighe, John, of Blanford Forum, or of Shorewell, Isle of Wight, Hants, esq 0
4212524 2099923 2099923 defendant Ralingson George yeoman 594605 594605 Ralingson, George, of Blanford Forum, yeoman 0
4233017 2107055 2107055 defendant Pytt John   594605 594605 Pytt, John, of Blanford Forum, woollen draper 0
4243513 2110821 2110821 defendant Johnsons Thomas   594605 594605 Johnsons, Thomas, of Blanford Forum, surgeon 0
4243535 2110826 2110826 defendant Spearinge Robert yeoman 594605 594605 Spearinge, Robert, of Blanford Forum, yeoman 2
4246671 2111864 2111864 defendant Rosewell Thomas gent 594605 594605 Rosewell, Thomas, of Blanford Forum, or of Dowkerton, Soms, gent 0
4290617 2126702 2126702 defendant Husey Henry gent 594605 594605 Husey, Henry, of Blanford Forum, or of Alnedeston, Wilts, gent 0
4293927 2127900 2127900 defendant Meade Thomas butcher 594605 594605 Meade, Thomas, of Blanford Forum, butcher 0
4308005 2132945 2132945 defendant Whyttell Henry merchant 594605 594605 Whyttell, Henry, of Blanford Forum, merchant 0
4362328 2151579 2151579 defendant Harvye John tucker 594605 594605 Harvye, John, of Blanford Forum, tucker 0
4362329 2151579 2151579 defendant Lodge William husbandman 594605 594605 together with Lodge, William, of Blanford Forum, husbandman 1
4362331 2151580 2151580 defendant Harvye John tucker 594605 594605 Harvye, John, of Blanford Forum, tucker 0
4362332 2151580 2151580 defendant Lodge William husbandman 594605 594605 Lodge, William, of Blanford Forum, husbandman 1
4362334 2151581 2151581 defendant Bysshopp Richard   594605 594605 Bysshopp, Richard, of Blanford Forum, gun maker 0
4366061 2152904 2152904 defendant Mighell William, junior yeoman 594605 594605 Mighell, William, junior, of Blanford Forum, yeoman 0
4366887 2153208 2153208 defendant Pellye William chandler 594605 594605 Pellye, William, of Blanford Forum, chandler 0
4366888 2153208 2153208 defendant Pennye William cordwainer 594605 594605 Pennye, William, of Blanford Forum, cordwainer 1
4369099 2154015 2154015 defendant Burde Barneus or Barney chandler 594605 594605 Burde, Barneus or Barney, of Blanford Forum, chandler 0
4369100 2154015 2154015 defendant Carter Robert shoemaker 594605 594605 Carter, Robert, of Blanford Forum, shoemaker 1
4374351 2155894 2155894 defendant Olyver William yeoman 594605 594605 Olyver, William, of Blanford Forum, yeoman 0
4374409 2155914 2155914 defendant Kennell Richard   594605 594605 Kennell, Richard, of Blanford Forum, woollen draper 0
4375020 2156126 2156126 defendant Harrys Henry   594605 594605 Harrys, Henry, of Blanford Forum, parchment maker 0
4377308 2156959 2156959 defendant Basill Robert tailor 594605 594605 Basill, Robert, of Blanford Forum, tailor 3
4707525 2267726 2267726 defendant Yonge Robert butcher 594605 594605 Yonge, Robert, of Blanford Forum, butcher 0
4894416 2324928 2324928 defendant Helyer Thomas yeoman 594605 594605 Helyer, Thomas, of Blanford Forum, yeoman 0
4894869 2325058 2325058 defendant Maundeware Walter yeoman 594605 594605 Maundeware, Walter, of Blanford Forum, yeoman 6
4900234 2326702 2326702 plaintiff Pewterer John   594605 594605 Pewterer, John, of Blanford Forum 0
4952344 2342660 2342660 defendant Strete John tanner 594605 594605 Strete, John, of Blanford Forum, tanner 0
4974924 2349474 2349474 defendant Bole William dyer 594605 594605 Bole, William, of Blanford Forum, dyer 0
5038523 2368163 2368163 defendant Clare Robert butcher 594605 594605 Clare, Robert, of Blanford Forum, butcher 1
5042836 2369467 2369467 plaintiff Ekford John   594605 594605 Ekford, John, of Blanford Forum 0
5042838 2369467 2369467 defendant Skynner or Okynner alias Leche John husbandman 594605 594605 Skynner or Okynner alias Leche, John, of Blanford Forum, husbandman 1
5051383 2372029 2372029 defendant Suthwyk Robert husbandman 594605 594605 Suthwyk, Robert, of Blanford Forum, husbandman 1
5060581 2374744 2374744 defendant Couper Walter husbandman 594605 594605 Couper, Walter, of Blanford Forum, husbandman 0
5060983 2374855 2374855 defendant Adam Thomas tailor 594605 594605 Adam, Thomas, of Blanford Forum, tailor 3
5064607 2375955 2375955 defendant Deyman Richard husbandman 594605 594605 Deyman, Richard, of Blanford Forum, husbandman 0
5213366 2419639 2419639 defendant Deyman John ostler 594605 594605 Deyman, John, of Blanford Forum, ostler 2
5264204 2434563 2434563 defendant Ralegh Simon courtholder 594605 594605 Ralegh, Simon, of Blanford Forum, courtholder 4
5271319 2436705 2436705 defendant Blanford Nicholas butcher 594605 594605 Blanford, Nicholas, of Blanford Forum, butcher 1
5290186 2442132 2442132 defendant Howeles John husbandman 594605 594605 Howeles, John, of Blanford Forum, husbandman 0
5344712 2458520 2458520 defendant Miller William baker 594605 594605 Miller, William, of Blanford Forum, baker 0
5365696 2464932 2464932 defendant Gardener William fisher 594605 594605 Gardener, William, of Blanford Forum, fisher 4
5372620 2467036 2467036 defendant Kewe John husbandman 594605 594605 Kewe, John, of Blanford Forum, husbandman 1
5373860 2467420 2467420 defendant Coker Ralph gent 594605 594605 Coker, Ralph, of Blanford Forum, gent 0
5397746 2474427 2474427 defendant Smythe John cutler 594605 594605 Smythe, John, of Blanford Forum, cutler 0
5397747 2474427 2474427 defendant Cue John husbandman 594605 594605 Cue, John, of Blanford Forum, husbandman 1
5397748 2474427 2474427 defendant Sinert John miller 594605 594605 Sinert, John, of Blanford Forum, miller 2
5397761 2474429 2474429 defendant Smyth John cutler 594605 594605 Smyth, John, of Blanford Forum, cutler 0
5397762 2474429 2474429 defendant Ove John husbandman 594605 594605 Ove, John, of Blanford Forum, husbandman 1
5425064 2482459 2482459 defendant Smert John miller 594605 594605 Smert, John, of Blanford Forum, miller 2
5460281 2493011 2493011 defendant Kewe John hosteller 594605 594605 Kewe, John, of Blanford Forum, hosteller 0
5471912 2496554 2496554 defendant Kewe John hosteler 594605 594605 Kewe, John, of Blanford Forum, hosteler 0
5502154 2505598 2505598 defendant Arrower Owen smith 594605 594605 Arrower, Owen, of Blanford Forum, smith 0
5509274 2507754 2507754 defendant Gonys or Govys John husbandman 594605 594605 Gonys or Govys, John, of Blanford Forum, husbandman 0
5538231 2516443 2516443 defendant Wykeman Thomas husbandman 594605 594605 Wykeman, Thomas, of Blanford Forum, husbandman 0
5538232 2516443 2516443 defendant Pytte William draper 594605 594605 Pytte, William, of Blanford Forum, draper 1
5552105 2520659 2520659 defendant Pytte William merchant 594605 594605 Pytte, William, of Blanford Forum, merchant 0
5552106 2520659 2520659 defendant Pytte John laborer 594605 594605 Pytte, John, of Blanford Forum, laborer 1
5552107 2520659 2520659 defendant Strete John brewer 594605 594605 Strete, John, of Blanford Forum, brewer 2
5555740 2521672 2521672 defendant Skohan Thomas yeoman 594605 594605 Skohan, Thomas, of Blanford Forum, yeoman 2
5565871 2524617 2524617 plaintiff Cerbok Robert   594605 594605 Cerbok, Robert, of Blanford Forum 0

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