names

223 rows where place_id = 601922

✎ 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
3647687 1909667 1909667 defendant Lane John yeoman 601922 601922 Lane, John, of Burford, yeoman 0
3651260 1910761 1910761 plaintiff Staunton Thomas   601922 601922 Staunton, Thomas, of Burford 0
3651263 1910762 1910762 plaintiff Harrys John   601922 601922 Harrys, John, of Burford 1
3666963 1915611 1915611 defendant Cokkys Thomas butcher 601922 601922 Cokkys, Thomas, of Burford, butcher 0
3689307 1922820 1922820 defendant Bysshop John yeoman 601922 601922 Bysshop, John, of Burford, yeoman 1
3689310 1922821 1922821 defendant Pynnoke Thomas (legal representative) 601922 601922 Pynnoke, Thomas, of Burford, gent, executors of 0
3698823 1925849 1925849 defendant Tesdale Thomas mercer 601922 601922 Tesdale, Thomas, of Burford, mercer 0
3699780 1926153 1926153 defendant Marky John yeoman 601922 601922 Marky, John, of Burford, yeoman 3
3699781 1926153 1926153 defendant Clerke Thomas yeoman 601922 601922 Clerke, Thomas, of Burford, yeoman 4
3713292 1930466 1930466 defendant Marky John yeoman 601922 601922 Marky, John, of Burford, yeoman 3
3713293 1930466 1930466 defendant Clerke Thomas yeoman 601922 601922 Clerke, Thomas, of Burford, yeoman 4
3732340 1936352 1936352 plaintiff Cornewale Thomas   601922 601922 Cornewale, Thomas, of Burford, knight 0
3734703 1937102 1937102 defendant Thesedale Thomas yeoman 601922 601922 Thesedale, Thomas, of Burford, yeoman 0
3734704 1937102 1937102 defendant Yong John tailor 601922 601922 Yong, John, of Burford, tailor 1
3742907 1939636 1939636 defendant Cornewell Richard esq 601922 601922 Cornewell, Richard, of Burford, esq 1
3742908 1939636 1939636 defendant Fermour Edmund husbandman 601922 601922 Fermour, Edmund, of Burford, husbandman 2
3748819 1941566 1941566 defendant Johnson Robert shoemaker 601922 601922 Johnson, Robert, of Burford, shoemaker 1
3757634 1944367 1944367 defendant Marten Thomas tailor 601922 601922 Marten, Thomas, of Burford, tailor 0
3759998 1945122 1945122 plaintiff Cornewall Thomas   601922 601922 Cornewall, Thomas, of Burford, knight 0
3797357 1957060 1957060 defendant Helcombe John yeoman 601922 601922 Helcombe, John, of Burford, yeoman 10
3798163 1957321 1957321 plaintiff Hoggys William yeoman 601922 601922 Hoggys, William, of Burford, yeoman 1
3815540 1962775 1962775 plaintiff Hoggys William yeoman 601922 601922 Hoggys, William, of Burford, yeoman 1
3821720 1964681 1964681 plaintiff Sharpe John   601922 601922 Sharpe, John, of Burford 0
3827962 1966613 1966613 plaintiff Busby John (legal representative) 601922 601922 Busby, John, of Burford, executors of 0
3831687 1967810 1967810 plaintiff Hammys alias Handys Richard clothier 601922 601922 Hammys alias Handys, Richard, of Burford, clothier 0
3835087 1968914 1968914 defendant Ryle Thomas slater 601922 601922 Ryle, Thomas, of Burford, slater 0
3835088 1968914 1968914 defendant Reynyng John weaver 601922 601922 Reynyng, John, of Burford, weaver 1
3836892 1969438 1969438 defendant Hannys Richard clothier 601922 601922 Hannys, Richard, of Burford, clothier 0
3850170 1973642 1973642 defendant Lyons John husbandman 601922 601922 Lyons, John, of Burford, husbandman 0
3850172 1973643 1973643 defendant Lyons John husbandman 601922 601922 Lyons, John, of Burford, husbandman 0
3868569 1979725 1979725 defendant Cornewall Richard esq 601922 601922 Cornewall, Richard, of Burford, esq 1
3898777 1989792 1989792 defendant Wynchester Simon yeoman 601922 601922 Wynchester, Simon, of Burford, yeoman 0
3915972 1995723 1995723 defendant Jones alias Tucker John weaver 601922 601922 Jones alias Tucker, John, of Burford, weaver 0
3937411 2002847 2002847 plaintiff Nycolles Walter   601922 601922 Nycolles, Walter, of Burford 0
3981706 2018214 2018214 plaintiff Reynold Richard   601922 601922 Reynold, Richard, of Burford, Woollen draper 0
4056580 2044741 2044741 defendant West Robert innholder 601922 601922 West, Robert, of Burford, innholder 0
4093916 2058148 2058148 defendant Serell William haberdasher 601922 601922 Serell, William, of Burford, haberdasher 1
4113728 2065193 2065193 defendant Calcott alias Crowe Thomas yeoman 601922 601922 Calcott alias Crowe, Thomas, of Burford, yeoman 0
4113753 2065203 2065203 defendant Calcott alias Crowe Thomas yeoman 601922 601922 Calcott alias Crowe, Thomas, of Burford, yeoman 0
4175103 2086756 2086756 defendant West alias Hollydaye Robert yeoman 601922 601922 West alias Hollydaye, Robert, of Burford, yeoman 3
4223394 2103675 2103675 defendant Haynes Thomas butcher 601922 601922 Haynes, Thomas, of Burford, butcher 0
4303578 2131377 2131377 defendant Rosse or Roffe John shoemaker 601922 601922 Rosse or Roffe, John, of Burford, shoemaker 1
4339131 2143443 2143443 defendant Hardinge Thomas clothier 601922 601922 Hardinge, Thomas, of Burford, clothier 0
4358255 2150122 2150122 defendant Tayler John   601922 601922 Tayler, John, of Burford, woollen draper 1
4364937 2152513 2152513 defendant Coxe Nicholas husbandman 601922 601922 Coxe, Nicholas, of Burford, husbandman 0
4366093 2152916 2152916 defendant Jurden Richard, junior saddler 601922 601922 Jurden, Richard, junior, of Burford, yeoman, his son, saddler 1
4385482 2159833 2159833 defendant Dalby Simon butcher 601922 601922 Dalby, Simon, of Burford, butcher 1
4480848 2194680 2194680 defendant Bythewynde John   601922 601922 Bythewynde, John, of burford 0
4492238 2198255 2198255 plaintiff Wynrysshe John (legal representative) 601922 601922 Wynrysshe, John, of Burford, executors of 0
4492243 2198255 2198255 defendant Stowe Robert   601922 601922 Stowe, Robert, of Burford 0
4496494 2199579 2199579 plaintiff Couper Roger   601922 601922 Couper, Roger, of Burford, on his own account 0
4496495 2199579 2199579 defendant Stowe John   601922 601922 Stowe, John, of Burford 0
4496496 2199579 2199579 defendant Stowe Robert   601922 601922 Stowe, Robert, of Burford 1
4496497 2199579 2199579 defendant Southwyk John   601922 601922 Southwyk, John, of Burford 2
4497285 2199797 2199797 defendant Cornewayle John   601922 601922 Cornewayle, John, of Burford 0
4497286 2199797 2199797 defendant Dyere Edmund   601922 601922 Dyere, Edmund, of Burford 1
4497288 2199797 2199797 defendant Chaloner Nicholas chaplain 601922 601922 Chaloner, Nicholas, of Burford, chaplain 3
4497291 2199797 2199797 defendant Stowe John   601922 601922 with Stowe, John, of Burford 6
4502588 2201390 2201390 defendant Dyer Edmund   601922 601922 Dyer, Edmund, of Burford 0
4502590 2201391 2201391 defendant Dyer Edmund   601922 601922 Dyer, Edmund, of Burford 0
4516894 2205687 2205687 defendant Hatter John   601922 601922 Hatter, John, of Burford 1
4532389 2210397 2210397 defendant Coterler Henry   601922 601922 Coterler, Henry, of Burford 3
4535409 2211345 2211345 defendant Wardon Richard   601922 601922 Wardon, Richard, of Burford 0
4537189 2211904 2211904 plaintiff Suthwyk John spicer 601922 601922 Suthwyk, John, of Burford, spicer 0
4541954 2213375 2213375 plaintiff Wynrysshe Joan   601922 601922 Wynrysshe, Joan, of Burford 0
4558538 2218621 2218621 defendant Pouter John   601922 601922 Pouter, John, of Burford 0
4562820 2219930 2219930 plaintiff Punter John   601922 601922 Punter, John, of Burford 0
4562821 2219930 2219930 defendant Sclatter Robert   601922 601922 Sclatter, Robert, of Burford 0
4570918 2222471 2222471 defendant Coke William   601922 601922 Coke, William, of Burford, son of John 0
4570927 2222475 2222475 defendant Taillour David draper 601922 601922 Taillour, David, of Burford, draper 0
4570928 2222475 2222475 defendant Grene John   601922 601922 Grene, John, of Burford 1
4581584 2225687 2225687 plaintiff Dyer Edmund   601922 601922 Dyer, Edmund, of Burford 0
4589013 2227940 2227940 defendant Eyre Thomas   601922 601922 Eyre, Thomas, of Burford 0
4589650 2228131 2228131 plaintiff Longe Thomas   601922 601922 Longe, Thomas, of Burford 0
4589979 2228224 2228224 defendant Draper David   601922 601922 Draper, David, of Burford 0
4604219 2232489 2232489 defendant Skynner Nicholas   601922 601922 Skynner, Nicholas, of Burford 5
4610536 2234363 2234363 defendant Baker John   601922 601922 Baker, John, of Burford 0
4610537 2234363 2234363 defendant Baker John   601922 601922 Baker, John, of Burford, son of John 1
4610784 2234444 2234444 defendant James Philip   601922 601922 James, Philip, of Burford 1
4615121 2235739 2235739 defendant Mason John   601922 601922 Mason, John, of Burford 0
4619995 2237235 2237235 defendant Carpenter Reginald   601922 601922 Carpenter, Reginald, of Burford 0
4624660 2238693 2238693 defendant Dyere Edmund   601922 601922 Dyere, Edmund, of Burford 2
4625901 2239055 2239055 plaintiff Dier Edmund   601922 601922 Dier, Edmund, of Burford 2
4625905 2239055 2239055 defendant Hosyer Simon   601922 601922 Hosyer, Simon, of Burford 3
4628007 2239681 2239681 defendant Wynryssh Joan   601922 601922 Wynryssh, Joan, of Burford, formerly wife of John 0
4630502 2240453 2240453 plaintiff Stowe Alice   601922 601922 (Stowe, Alice, of Burford, formerly wife of John Stowe, sen 1
4630511 2240455 2240455 plaintiff Stowe John, sen (legal representative) 601922 601922 Stowe, John, sen, of Burford, executors of 0
4632954 2241177 2241177 defendant Draper David   601922 601922 Draper, David, of Burford 0
4634994 2241791 2241791 defendant Milton John   601922 601922 Milton, John, of Burford 4
4634995 2241791 2241791 defendant Spicer John   601922 601922 Spicer, John, of Burford 5
4634998 2241792 2241792 defendant Graunger Edward   601922 601922 Graunger, Edward, of Burford 1
4634999 2241792 2241792 defendant Note Robert   601922 601922 Note, Robert, of Burford 2
4635340 2241888 2241888 defendant Wynrisshe Thomas   601922 601922 Wynrisshe, Thomas, of Burford 0
4637939 2242632 2242632 defendant Hay Richard   601922 601922 Hay, Richard, of Burford 5
4644624 2244517 2244517 defendant Wurnyssh Thomas   601922 601922 Wurnyssh, Thomas, of Burford 4
4650795 2246252 2246252 defendant James Philip   601922 601922 James, Philip, of Burford 0
4652716 2246785 2246785 defendant Wynryssh Richard chapman 601922 601922 Wynryssh, Richard, of Burford, chapman 0
4652717 2246785 2246785 defendant Gornay Henry   601922 601922 Gornay, Henry, of Burford, "honymonger" 1
4658187 2248438 2248438 defendant Walyssheman John tailor 601922 601922 Walyssheman, John, of Burford, tailor 0
4659174 2248742 2248742 defendant Dekyn Walter hosteler 601922 601922 Dekyn, Walter, of Burford, hosteler 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);