names

135 rows where place_id = 604869

✎ 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
3659547 1913247 1913247 plaintiff Grene John   604869 604869 Grene, John, of Coventre 0
3684642 1921330 1921330 defendant Bowthe Thomas vintner 604869 604869 Bowthe, Thomas, of Coventre, vintner 0
3881307 1984013 1984013 defendant Shefford Thomas chapman 604869 604869 Shefford, Thomas, of Coventre, chapman 0
4450241 2185035 2185035 plaintiff Hampton Richard de   604869 604869 Hampton, Richard de, of Coventre, on his own account 0
4450248 2185036 2185036 plaintiff Hampton Richard de   604869 604869 Hampton, Richard de, of Coventre, on his own account 0
4455060 2186586 2186586 plaintiff Maxstoke John merchant 604869 604869 Maxstoke, John, of Coventre, merchant 0
4455433 2186700 2186700 defendant Ingham Robert   604869 604869 Ingham, Robert, of Coventre 0
4456218 2186963 2186963 defendant Papenham John   604869 604869 Papenham, John, of Coventre 0
4461103 2188550 2188550 defendant Wodenesbury John de   604869 604869 Wodenesbury, John de, of Coventre 2
4463797 2189354 2189354 defendant Deyer John   604869 604869 Deyer, John, of Coventre 6
4468376 2190775 2190775 defendant Byggyng Ralph   604869 604869 Byggyng, Ralph, of Coventre 1
4473455 2192362 2192362 plaintiff Cumpton John   604869 604869 Cumpton, John, of Coventre 1
4473839 2192467 2192467 defendant Wedon Roger   604869 604869 Wedon, Roger, of Coventre 0
4484052 2195704 2195704 defendant Tylsede Thomas   604869 604869 Tylsede, Thomas, of Coventre 1
4485084 2196034 2196034 plaintiff Preston John draper 604869 604869 Preston, John, of Coventre, draper 0
4486337 2196436 2196436 defendant Tylsede Thomas   604869 604869 Tylsede, Thomas, of Coventre 1
4492166 2198235 2198235 defendant Lytilman Richard   604869 604869 (Lytilman, Richard, of Coventre 1
4492337 2198280 2198280 defendant Bygeneld Richard shoemaker 604869 604869 Bygeneld, Richard, of Coventre, shoemaker 0
4493380 2198635 2198635 plaintiff Bandy John hosier 604869 604869 Bandy, John, of Coventre, hosier 0
4493500 2198671 2198671 plaintiff Barowegh John smith 604869 604869 Barowegh, John, of Coventre, smith, on his own account 0
4493789 2198750 2198750 defendant Baker John   604869 604869 Baker, John, of Coventre 0
4493792 2198752 2198752 plaintiff Bedford William de merchant 604869 604869 Bedford, William de, of Coventre, merchant 0
4494093 2198841 2198841 defendant Neuton Robert mercer 604869 604869 Neuton, Robert, of Coventre, mercer 0
4494866 2199082 2199082 defendant Taillour Thomas   604869 604869 Taillour, Thomas, of Coventre 4
4494867 2199082 2199082 defendant Carter Richard   604869 604869 Carter, Richard, of Coventre 5
4494868 2199082 2199082 defendant Mason Thomas   604869 604869 Mason, Thomas, of Coventre 6
4495838 2199380 2199380 plaintiff Chesterton Thomas draper 604869 604869 Chesterton, Thomas, of Coventre, draper 0
4495839 2199380 2199380 defendant Wryght John   604869 604869 Wryght, John, of Coventre, son of William 0
4499541 2200505 2200505 plaintiff Hawe Thomas   604869 604869 Hawe, Thomas, of Coventre, on his own account 0
4501710 2201137 2201137 plaintiff Lynton William butcher 604869 604869 Lynton, William, of Coventre, butcher 0
4501711 2201137 2201137 defendant Bernard John, junior   604869 604869 Bernard, John, junior, of Coventre, wright 0
4505079 2202121 2202121 plaintiff Skarburh John   604869 604869 Skarburh, John, of Coventre 0
4505081 2202121 2202121 defendant Walkeleyn Richard   604869 604869 Walkeleyn, Richard, of Coventre 0
4505770 2202314 2202314 plaintiff Stille Richard tanner 604869 604869 Stille, Richard, of Coventre, tanner 0
4508006 2202972 2202972 defendant Leyghton Simon   604869 604869 Leyghton, Simon, of Coventre 1
4530665 2209885 2209885 defendant Whelere John   604869 604869 Whelere, John, of Coventre 0
4566367 2221053 2221053 defendant Balle John draper 604869 604869 Balle, John, of Coventre, draper 0
4581604 2225694 2225694 defendant Milward John   604869 604869 Milward, John, of Coventre 1
4599331 2231009 2231009 defendant Feryby Thomas mercer 604869 604869 Feryby, Thomas, of Coventre, mercer 0
4669420 2256143 2256143 plaintiff Boot John   604869 604869 Boot, John, of Coventre 0
4669566 2256190 2256190 plaintiff Botiler John   604869 604869 Botiler, John, of Coventre 0
4670814 2256552 2256552 plaintiff Burton John   604869 604869 Burton, John, of Coventre 0
4670815 2256552 2256552 defendant Clyfton Thomas dyer 604869 604869 Clyfton, Thomas, of Coventre, dyer 0
4670816 2256552 2256552 defendant Sponer Richard mercer 604869 604869 Sponer, Richard, of Coventre, mercer 1
4670819 2256553 2256553 plaintiff Burton John   604869 604869 Burton, John, of Coventre, on his own account 0
4672706 2257105 2257105 defendant Benet John tipper 604869 604869 Benet, John, of Coventre, tipper 0
4672707 2257105 2257105 defendant Benet John weaver 604869 604869 Benet, John, of Coventre, weaver 1
4672709 2257106 2257106 defendant Denys Richard tipper 604869 604869 Denys, Richard, of Coventre, tipper 0
4672868 2257157 2257157 plaintiff Coppe William merchant 604869 604869 Coppe, William, of Coventre, merchant 0
4673261 2257279 2257279 plaintiff Croslond John draper 604869 604869 Croslond, John, of Coventre, servant of John Parkere, draper 0
4674905 2257761 2257761 plaintiff Eton William   604869 604869 Eton, William, of Coventre 0
4674907 2257762 2257762 plaintiff Eton William   604869 604869 Eton, William, of Coventre 0
4674909 2257763 2257763 plaintiff Eton William   604869 604869 Eton, William, of Coventre 0
4674911 2257764 2257764 plaintiff Eton William   604869 604869 Eton, William, of Coventre 0
4674951 2257774 2257774 defendant Tate John chapman 604869 604869 Tate, John, of Coventre, chapman 2
4674971 2257781 2257781 plaintiff Evesham Andrew   604869 604869 Evesham, Andrew, of Coventre 0
4674972 2257781 2257781 defendant Danyell William shoemaker 604869 604869 Danyell, William, of Coventre, shoemaker 0
4675467 2257936 2257936 defendant Sponer Richard mercer 604869 604869 Sponer, Richard, of Coventre, mercer 0
4675468 2257936 2257936 defendant Garton William draper 604869 604869 Garton, William, of Coventre, draper 1
4675959 2258093 2258093 plaintiff Fynche James   604869 604869 Fynche, James, of Coventre 0
4676665 2258319 2258319 plaintiff Gote John draper 604869 604869 Gote, John, of Coventre, draper 0
4677953 2258722 2258722 defendant Hasketh William merchant 604869 604869 Hasketh, William, of Coventre, merchant 0
4678555 2258899 2258899 plaintiff Horseley John (legal representative) 604869 604869 Horseley, John, of Coventre, executrix of 0
4678914 2259008 2259008 defendant Flaundres John draper 604869 604869 Flaundres, John, of Coventre, draper 0
4679449 2259187 2259187 defendant Wotton Thomas cardmaker 604869 604869 Wotton, Thomas, of Coventre, cardmaker 2
4680278 2259446 2259446 defendant Brewerne Thomas de   604869 604869 Brewerne, Thomas de, of Coventre, milward 0
4680822 2259622 2259622 defendant Pisford Richard, junior tanner 604869 604869 Pisford, Richard, junior, of Coventre, tanner 4
4682257 2260074 2260074 plaintiff Nayleston John   604869 604869 Nayleston, John, of Coventre 0
4682260 2260075 2260075 plaintiff Nayleston John   604869 604869 Nayleston, John, of Coventre, on his own account 0
4682494 2260152 2260152 plaintiff Normanton John draper 604869 604869 Normanton, John, of Coventre, draper 0
4682496 2260153 2260153 plaintiff Normanton John draper 604869 604869 Normanton, John, of Coventre, draper 0
4682834 2260246 2260246 defendant Baxter Richard baker 604869 604869 Baxter, Richard, of Coventre, baker 1
4682835 2260246 2260246 defendant Hornby William   604869 604869 Hornby, William, of Coventre, belt maker 2
4682836 2260247 2260247 plaintiff Olney William   604869 604869 Olney, William, of Coventre 0
4683176 2260355 2260355 plaintiff Parker John   604869 604869 Parker, John, of Coventre 0
4683177 2260355 2260355 defendant Sponer Richard chapman 604869 604869 Sponer, Richard, of Coventre, chapman 0
4683181 2260356 2260356 plaintiff Parker John draper 604869 604869 Parker, John, of Coventre, draper 0
4683806 2260544 2260544 defendant Sharp William roper 604869 604869 Sharp, William, of Coventre, roper 0
4684235 2260674 2260674 plaintiff Prentys John mercer 604869 604869 Prentys, John, of Coventre, mercer 0
4684606 2260783 2260783 defendant Curwayn Thomas shoemaker 604869 604869 Curwayn, Thomas, of Coventre, shoemaker 3
4685295 2260996 2260996 defendant Knotte John dyer 604869 604869 Knotte, John, of Coventre, dyer 0
4687536 2261691 2261691 defendant Shape John tailor 604869 604869 Shape, John, of coventre, tailor 5
4687543 2261692 2261692 defendant Snape John tailor 604869 604869 Snape, John, of Coventre, tailor 5
4690167 2262481 2262481 defendant Fynche James chandler 604869 604869 Fynche, James, of Coventre, chandler 0
4690221 2262497 2262497 defendant Fauconer Nicholas laborer 604869 604869 Fauconer, Nicholas, of Coventre, laborer 1
4691430 2262846 2262846 defendant Joynour John joiner 604869 604869 Joynour, John, of Coventre, joiner 0
4691433 2262847 2262847 defendant Knotte Henry dyer 604869 604869 Knotte, Henry, of Coventre, dyer 0
4691435 2262847 2262847 defendant Bromwiche William cardmaker 604869 604869 Bromwiche, William, of Coventre, cardmaker 2
4746788 2279560 2279560 defendant Horton John   604869 604869 Horton, John, of Coventre, wire drawer 1
4783665 2290909 2290909 defendant Yate John esq 604869 604869 Yate, John, of Coventre, esq 0
4819477 2302167 2302167 defendant Munk Richard skinner 604869 604869 Munk, Richard, of Coventre, skinner 0
4832741 2306263 2306263 defendant Talbot Henry dyer 604869 604869 Talbot, Henry, of Coventre, dyer 2
5131729 2395764 2395764 defendant Swayn John yeoman & son of Thomas 604869 604869 Swayn, John, of Coventre, yeoman & son of Thomas 1
5231182 2424719 2424719 defendant Norton Thomas smith 604869 604869 Norton, Thomas, of Coventre, smith 0
5233313 2425329 2425329 defendant Norffolke Richard fuller 604869 604869 Norffolke, Richard, of Coventre, fuller 3
5246720 2429203 2429203 defendant Farewell Richard   604869 604869 Farewell, Richard, of Coventre, "deyster" 0
5369940 2466190 2466190 defendant Coton Humphrey hosier 604869 604869 Coton, Humphrey, of Coventre, hosier 1
5369941 2466190 2466190 defendant Edmay John barber 604869 604869 Edmay, John, of Coventre, barber 2
5441432 2487359 2487359 defendant Hedley Richard gent 604869 604869 Hedley, Richard, of Coventre, gent 0
5491888 2502482 2502482 defendant Hypper William yeoman or "passynger" 604869 604869 Hypper, William, of Coventre, yeoman or "passynger" 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);