names

987 rows where place_id = 590357

✎ 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
3592822 1865369 1865369 plaintiff Grey Reginald   590357 590357 Grey, Reginald, of Wilton, knight 0
3600772 1867902 1867902 defendant Huntley William yeoman 590357 590357 Huntley, William, of Wilton, yeoman 0
3608610 1870354 1870354 defendant Walles Robert   590357 590357 Walles, Robert, of Wilton, tallow chandler 0
3620200 1873895 1873895 defendant Hall Thomas esq 590357 590357 Hall, Thomas, of Wilton, esq 0
3642168 1907998 1907998 defendant Wylloughby Anthony esq 590357 590357 Wylloughby, Anthony, of Wilton, esq 0
3648443 1909914 1909914 defendant Vaughan James clerk 590357 590357 Vaughan, James, of Wilton, clerk 0
3666022 1915310 1915310 defendant Gardener William   590357 590357 Gardener, William, of Wilton, shepherd 0
3676135 1918576 1918576 defendant Willoughby Christopher gent 590357 590357 Willoughby, Christopher, of Wilton, gent 0
3692722 1923911 1923911 defendant Rolles William husbandman 590357 590357 Rolles, William, of Wilton, husbandman 3
3751675 1942441 1942441 defendant Poole John yeoman 590357 590357 Poole, John, of Wilton, yeoman 0
3773003 1949260 1949260 defendant Clement William clothier 590357 590357 Clement, William, of Wilton, clothier 0
3773004 1949260 1949260 defendant Helston Richard yeoman 590357 590357 Helston, Richard, of Wilton, yeoman 1
3773009 1949261 1949261 defendant Clement William clothier 590357 590357 Clement, William, of Wilton, clothier 0
3773010 1949261 1949261 defendant Helston Richard yeoman 590357 590357 Helston, Richard, of Wilton, yeoman 1
3782622 1952305 1952305 defendant Fyssher Alexander weaver 590357 590357 Fyssher, Alexander, of Wilton, weaver 0
3818216 1963612 1963612 defendant Swett Roger yeoman 590357 590357 Swett, Roger, of Wilton, yeoman 0
3818217 1963612 1963612 defendant Besford Walter tucker 590357 590357 Besford, Walter, of Wilton, tucker 1
3851838 1974167 1974167 defendant Stephynson John carpenter 590357 590357 Stephynson, John, of Wilton, carpenter 0
3866466 1979014 1979014 defendant Dere John carpenter 590357 590357 Dere, John, of Wilton, carpenter 0
3866506 1979027 1979027 defendant Hoke Hugh husbandman 590357 590357 Hoke, Hugh, of Wilton, husbandman 1
3871354 1980669 1980669 defendant Hucke Hugh yeoman 590357 590357 Hucke, Hugh, of Wilton, yeoman 1
3871355 1980669 1980669 defendant Cuckoo Thomas yeoman 590357 590357 Cuckoo, Thomas, of Wilton, yeoman 2
3871454 1980697 1980697 defendant Hugke Hugh yeoman 590357 590357 Hugke, Hugh, of Wilton, yeoman 1
3871455 1980697 1980697 defendant Cuckoo Thomas yeoman 590357 590357 Cuckoo, Thomas, of Wilton, yeoman 2
3872418 1980998 1980998 defendant Clement alias Browne Margaret widow 590357 590357 (Clement alias Browne, Margaret, of Wilton, widow 1
3872419 1980998 1980998 defendant Clement alias Browne Edward yeoman 590357 590357 Clement alias Browne, Edward, of Wilton, yeoman 2
3872423 1981000 1981000 defendant Frowde Thomas (legal representative) 590357 590357 Frowde, Thomas, of Wilton, executrix of 0
3872424 1981000 1981000 defendant Frowde Edith widow 590357 590357 Frowde, Edith, of Wilton, widow 1
3884200 1984982 1984982 defendant Bodnam Henry gent 590357 590357 Bodnam, Henry, of Wilton, gent 0
3887083 1985943 1985943 defendant Saunderson Roger husbandman 590357 590357 Saunderson, Roger, of Wilton, husbandman 3
3890355 1987024 1987024 defendant Sharp Philip merchant 590357 590357 Sharp, Philip, of Wilton, merchant 0
3899763 1990136 1990136 defendant Grene Ralph laborer 590357 590357 Grene, Ralph, of Wilton, laborer 1
3901603 1990762 1990762 defendant Gregory Roger clothmaker 590357 590357 Gregory, Roger, of Wilton, clothmaker 0
3901604 1990762 1990762 defendant Nie alias Mody Richard tailor 590357 590357 Nie alias Mody, Richard, of Wilton, tailor 1
3906494 1992463 1992463 defendant Rowdon Hugh butcher 590357 590357 Rowdon, Hugh, of Wilton, butcher 3
3906496 1992464 1992464 defendant Hachell alias Lamber Richard tucker 590357 590357 Hachell alias Lamber, Richard, of Wilton, tucker 0
3906498 1992464 1992464 defendant Sheperd John miller 590357 590357 Sheperd, John, of Wilton, miller 2
3906840 1992577 1992577 defendant Sharpe Stephen clothier 590357 590357 Sharpe, Stephen, of Wilton, clothier 1
3908678 1993198 1993198 defendant Fynde Edmund yeoman 590357 590357 Fynde, Edmund, of Wilton, yeoman 0
3914811 1995299 1995299 defendant Raynold Walter yeoman 590357 590357 Raynold, Walter, of Wilton, yeoman 0
3915436 1995529 1995529 defendant Wylloughby Christopher esq 590357 590357 Wylloughby, Christopher, of Wilton, esq 1
3966308 2012842 2012842 plaintiff Boston Alexander   590357 590357 Boston, Alexander, of Wilton, Wilts hat maker 0
3967309 2013198 2013198 plaintiff Bulmer Ralph (legal representative) 590357 590357 Bulmer, Ralph, of Wilton, knight, executors of 0
3974689 2015716 2015716 defendant Myller Thomas smith 590357 590357 Myller, Thomas, of Wilton, smith 0
3988711 2020706 2020706 defendant Heyes Thomas clothier 590357 590357 Heyes, Thomas, of Wilton, clothier 0
4000652 2025006 2025006 defendant Sparke Henry   590357 590357 Sparke, Henry, of Wilton 3
4023263 2033027 2033027 defendant Zouche Francis gent 590357 590357 Zouche, Francis, of Wilton, gent 0
4043700 2040203 2040203 defendant Gaye Geoffrey yeoman 590357 590357 Gaye, Geoffrey, of Wilton, yeoman 0
4057920 2045216 2045216 defendant Bull John (legal representative) 590357 590357 Bull, John, of Wilton, husbandman, executrix of 2
4057921 2045216 2045216 defendant Bull Joan widow 590357 590357 Bull, Joan, of Wilton, widow 3
4086046 2055282 2055282 defendant Fermor Robert clerk 590357 590357 Fermor, Robert, of Wilton, clerk 3
4096284 2059001 2059001 defendant Flower John   590357 590357 Flower, John, of Wilton, yeoman, farmer of Comehaye, Soms 0
4097147 2059302 2059302 defendant Herbert George   590357 590357 Herbert, George, of Wilton, gent, servant with Earl of Pembroke 1
4097148 2059302 2059302 defendant Powell William   590357 590357 Powell, William, of Wilton, gent, servant with Earl of Pembroke 2
4108994 2063473 2063473 defendant Sturges John gent 590357 590357 Sturges, John, of Wilton, or of Wolavington, Soms, gent 0
4112181 2064613 2064613 defendant Cole John gent 590357 590357 Cole, John, of Wilton, or of Bristol, gent 0
4114156 2065344 2065344 defendant Knyghte Edward gent 590357 590357 Knyghte, Edward, of Wilton, or of Somerset, gent 0
4119353 2067214 2067214 defendant Drewett Robert husbandman 590357 590357 Drewett, Robert, of Wilton, or of Tinhed, husbandman 0
4119510 2067267 2067267 defendant Howchens David weaver 590357 590357 Howchens, David, of Wilton, weaver 3
4121680 2068051 2068051 defendant Budden Edward yeoman 590357 590357 Budden, Edward, of Wilton, or of Handley, Dorset, yeoman 0
4123790 2068806 2068806 defendant Gwyn Owen gent 590357 590357 Gwyn, Owen, of Wilton, gent 0
4124929 2069206 2069206 defendant Hayes Thomas brewer 590357 590357 Hayes, Thomas, of Wilton, brewer 0
4125277 2069326 2069326 defendant (not given) Nicholas rector of Pullen 590357 590357 Pullen, Nicholas, of Wilton, clerk, rector of Burscott, Berks 0
4129747 2070950 2070950 defendant Longe Richard clothier 590357 590357 Longe, Richard, of Wilton, or of Malmesbury, clothier 0
4129843 2070983 2070983 defendant Rosewell Thomas gent 590357 590357 Rosewell, Thomas, of Wilton, or of Dunkerton, Soms, gent 0
4129844 2070983 2070983 defendant Northover John yeoman 590357 590357 Northover, John, of Wilton, or of Aller, Soms, yeoman 1
4130416 2071192 2071192 defendant West Stephen gent 590357 590357 West, Stephen, of Wilton, or of Evercreche, Soms, gent 0
4131484 2071579 2071579 defendant George Richard beer brewer 590357 590357 George, Richard, of Wilton, beer brewer 0
4132931 2072104 2072104 defendant Purdew William bellfounder 590357 590357 Purdew, William, of Wilton, or of Clossewoode, Soms, bellfounder 0
4133838 2072439 2072439 defendant Rondell John husbandman 590357 590357 Rondell, John, of Wilton, or of Edyngton, husbandman 0
4137090 2073615 2073615 defendant Williams Thomas yeoman 590357 590357 Williams, Thomas, of Wilton, or of Broghton, Bedwyn Magna, yeoman 0
4137091 2073615 2073615 defendant Burley Robert, senior gent 590357 590357 Burley, Robert, senior, of Wilton, or of Fernamsden, Uphusbourne, Hants, gent 1
4137092 2073615 2073615 defendant Keele John yeoman 590357 590357 Keele, John, of Wilton, or of Bedwyn Magna, yeoman 2
4137094 2073616 2073616 defendant Williams Thomas yeoman 590357 590357 Williams, Thomas, of Wilton, or of Crofton, yeoman 0
4138660 2074192 2074192 defendant Hooper Henry yeoman 590357 590357 Hooper, Henry, of Wilton, or of Brodwey, yeoman 0
4140786 2074941 2074941 defendant Moulton Henry mercer 590357 590357 Moulton, Henry, of Wilton, or of Haitbery, mercer 0
4140787 2074941 2074941 defendant Hayword Thomas yeoman 590357 590357 Hayword, Thomas, of Wilton, or of Lovells Upton, yeoman 1
4143521 2075893 2075893 defendant Pyrrymon William yeoman 590357 590357 Pyrrymon, William, of Wilton, yeoman 0
4144247 2076146 2076146 defendant Hunter John ironmonger 590357 590357 Hunter, John, of Wilton, or of London, ironmonger 0
4145301 2076516 2076516 defendant Brocas Barnard esq 590357 590357 Brocas, Barnard, of Wilton, or of Swacliff, Middx, esq 0
4150095 2078170 2078170 defendant Deacon William yeoman 590357 590357 Deacon, William, of Wilton, or of St Elles , Isle of Wight, Hants, yeoman 2
4153242 2079230 2079230 defendant Knapton Richard gent 590357 590357 Knapton, Richard, of Wilton, or of Tisseburye, gent 0
4153244 2079231 2079231 defendant Semor Morgan merchant 590357 590357 Semor, Morgan, of Wilton, or of Shaftsbury, Dorset, merchant 0
4153246 2079232 2079232 defendant Codryngton Simon esq 590357 590357 Codryngton, Simon, of Wilton, or of Didmarton, Glos, esq 0
4153248 2079233 2079233 defendant Eyre Robert gent 590357 590357 Eyre, Robert, of Wilton, or of London, gent 0
4154343 2079613 2079613 defendant Purdewe William bellfounder 590357 590357 Purdewe, William, of Wilton, or of Closeworthe, Soms, bellfounder 0
4154776 2079765 2079765 defendant Brocas Barnard esq 590357 590357 Brocas, Barnard, of Wilton, or of Snakliffe or Suakliffe, Middx, esq 0
4155704 2080077 2080077 defendant Weare alias Browne Clement gent 590357 590357 Weare alias Browne, Clement, of Wilton, or of Denforde, Berks, gent 0
4155705 2080077 2080077 defendant Weare alias Browne Robert gent 590357 590357 Weare alias Browne, Robert, of Wilton, or of Polton Magna, Myldenhall, Wilts, gent 1
4161123 2081965 2081965 defendant Welles Francis yeoman 590357 590357 Welles, Francis, of Wilton, yeoman 0
4162885 2082547 2082547 defendant Hayes Thomas haberdasher 590357 590357 Hayes, Thomas, of Wilton, haberdasher 1
4169290 2084762 2084762 defendant Brooke Thomas husbandman 590357 590357 Brooke, Thomas, of Wilton, or of Crochorne, Soms, husbandman 0
4169299 2084766 2084766 defendant Arkyll John husbandman 590357 590357 Arkyll, John, of Wilton, or of Keynsam, Soms, husbandman 0
4171273 2085415 2085415 defendant Riche William cutler 590357 590357 Riche, William, of Wilton, or of Shaftesbury, Dorset, cutler 0
4171274 2085415 2085415 defendant Chaulcott or Chalkote John merchant or merchant draper 590357 590357 Chaulcott or Chalkote, John, of Wilton, or of Shaftesbury, merchant or merchant draper 1
4171287 2085418 2085418 defendant Buck Ralph yeoman 590357 590357 Buck, Ralph, of Wilton, or of East Pennarde, Soms, yeoman 0
4171288 2085418 2085418 defendant Stibbes Hercules yeoman 590357 590357 Stibbes, Hercules, of Wilton, or of Bowden, Soms, yeoman 1
4171290 2085419 2085419 defendant Smythe George gent 590357 590357 Smythe, George, of Wilton, or of Dorchester, Dorset, gent 0
4171291 2085419 2085419 defendant Strongman John gent 590357 590357 Strongman, John, of Wilton, or of Tarrante Abbye, Dorset, gent 1
4171363 2085447 2085447 defendant Symondes Richard ostler 590357 590357 Symondes, Richard, of Wilton, or of Blanford Forum, Dorset, ostler 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);