names

108 rows where place_id = 606920

✎ 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
3666962 1915611 1915611 plaintiff Wenman Richard gent 606920 606920 Wenman, Richard, of Wytney, gent 0
3683683 1921029 1921029 plaintiff Wenman Richard woolman 606920 606920 Wenman, Richard, of Wytney, woolman 0
3698856 1925859 1925859 plaintiff Wenman Richard   606920 606920 Wenman, Richard, of Wytney 0
3727560 1934899 1934899 defendant Coke John   606920 606920 Coke, John, of Wytney, wool packer 1
3773292 1949355 1949355 defendant Brakley John husbandman 606920 606920 Brakley, John, of Wytney, husbandman 3
3773293 1949355 1949355 defendant Wynslowe Richard pewterer 606920 606920 Wynslowe, Richard, of Wytney, pewterer 4
3790543 1954867 1954867 plaintiff Wenman Richard   606920 606920 Wenman, Richard, of Wytney 0
3791097 1955049 1955049 defendant Brakley John husbandman 606920 606920 Brakley, John, of Wytney, husbandman 2
3824528 1965542 1965542 defendant Bowell Thomas yeoman 606920 606920 Bowell, Thomas, of Wytney, yeoman 0
3855747 1975432 1975432 plaintiff Wenman Richard (legal representative) 606920 606920 Wenman, Richard, of Wytney, esq, executor of 0
3855750 1975433 1975433 plaintiff Wenman Richard (legal representative) 606920 606920 Wenman, Richard, of Wytney, esq, executor of 0
3855756 1975434 1975434 plaintiff Wenman Richard (legal representative) 606920 606920 Wenman, Richard, of Wytney, executor of 0
3855759 1975435 1975435 plaintiff Wenman Richard (legal representative) 606920 606920 Wenman, Richard, of Wytney, merchant of the staple, executor of 0
3855761 1975435 1975435 defendant Gerye John   606920 606920 Gerye, John, of Wytney, wax chandler 0
3855771 1975437 1975437 plaintiff Wenman Thomas   606920 606920 Wenman, Thomas, of Wytney 0
3858664 1976382 1976382 plaintiff Brice William yeoman 606920 606920 Brice, William, of Wytney, yeoman 0
3858665 1976382 1976382 plaintiff Yate Leonard yeoman 606920 606920 Yate, Leonard, of Wytney, yeoman 1
3858666 1976382 1976382 plaintiff Bysshope alias Marten William yeoman 606920 606920 Bysshope alias Marten, William, of Wytney, yeoman 2
3858669 1976382 1976382 defendant Hyggys John yeoman 606920 606920 Hyggys, John, of Wytney, yeoman 2
3869794 1980141 1980141 plaintiff Wenman Richard (legal representative) 606920 606920 Wenman, Richard, of Wytney, gent, executor of 0
3872832 1981125 1981125 defendant Hyggys John yeoman 606920 606920 Hyggys, John, of Wytney, yeoman 2
3875225 1981952 1981952 defendant Carles Thomas shoemaker 606920 606920 Carles, Thomas, of Wytney, shoemaker 0
3897161 1989268 1989268 plaintiff Wenman Thomas   606920 606920 Wenman, Thomas, of Wytney 0
3897163 1989269 1989269 plaintiff Wenman Thomas esq 606920 606920 Wenman, Thomas, of Wytney, esq 0
3897165 1989270 1989270 plaintiff Wenman Thomas esq 606920 606920 Wenman, Thomas, of Wytney, esq 0
3897167 1989271 1989271 plaintiff Wenman Thomas esq 606920 606920 Wenman, Thomas, of Wytney, esq 0
3907718 1992869 1992869 defendant Taylour William weaver 606920 606920 Taylour, William, of Wytney, weaver 0
3935989 2002354 2002354 defendant Bekynsall Edward yeoman 606920 606920 Bekynsall, Edward, of Wytney, yeoman 0
3981347 2018097 2018097 plaintiff Ranckell Peter   606920 606920 Ranckell, Peter, of Wytney 0
3986843 2020037 2020037 plaintiff Wilmott Edward (legal representative) 606920 606920 Wilmott, Edward, of Wytney, esq, executrix of 0
4037237 2037982 2037982 plaintiff Jones Henry clothier 606920 606920 Jones, Henry, of Wytney, clothier 0
4067889 2048825 2048825 plaintiff Jones Henry clothier 606920 606920 Jones, Henry, of Wytney, clothier 0
4077898 2052397 2052397 plaintiff Streate John   606920 606920 Streate, John, of Wytney, surgeon 0
4119848 2067388 2067388 defendant Collyer John clothier 606920 606920 Collyer, John, of Wytney, clothier 1
4283651 2124188 2124188 defendant Lacon Roland yeoman 606920 606920 Lacon, Roland, of Wytney, yeoman 1
4351236 2147682 2147682 defendant West Thomas clothier 606920 606920 West, Thomas, of Wytney, clothier 0
4351237 2147682 2147682 defendant Shewyll Richard mercer 606920 606920 Shewyll, Richard, of Wytney, mercer 1
4404152 2165958 2165958 defendant West Thomas clothier 606920 606920 West, Thomas, of Wytney, clothier 0
4404154 2165959 2165959 defendant Shewyll Richard mercer 606920 606920 Shewyll, Richard, of Wytney, mercer 0
4507825 2202906 2202906 defendant Webbe Nicholas   606920 606920 Webbe, Nicholas, of Wytney 1
4692357 2263127 2263127 defendant Radford John husbandman 606920 606920 Radford, John, of Wytney, husbandman 1
4822128 2302998 2302998 defendant Dyer Henry dyer 606920 606920 Dyer, Henry, of Wytney, dyer 0
4855806 2313189 2313189 defendant Russell Thomas tanner 606920 606920 Russell, Thomas, of Wytney, tanner 2
4858812 2314130 2314130 defendant Temple John husbandman 606920 606920 Temple, John, of Wytney, husbandman 0
4866429 2316468 2316468 defendant Rolkyn John husbandman 606920 606920 Rolkyn, John, of Wytney, husbandman 0
4899783 2326568 2326568 defendant Gyn John dyer 606920 606920 Gyn, John, of Wytney, dyer 1
4909308 2329453 2329453 defendant Gayte William chapman 606920 606920 Gayte, William, of Wytney, chapman 4
4920092 2332794 2332794 defendant Granger Robert weaver 606920 606920 Granger, Robert, of Wytney, weaver 2
4944217 2340162 2340162 defendant Martyn John husbandman 606920 606920 Martyn, John, of Wytney, husbandman 2
4957930 2344343 2344343 defendant Warner Edmund tailor 606920 606920 Warner, Edmund, of Wytney, tailor 1
4957931 2344343 2344343 defendant Staunton William weaver 606920 606920 Staunton, William, of Wytney, weaver 2
4958818 2344611 2344611 defendant Gate William chapman 606920 606920 Gate, William, of Wytney, chapman 2
4958823 2344612 2344612 defendant Gayte William chapman 606920 606920 Gayte, William, of Wytney, chapman 2
4963120 2345876 2345876 defendant Brayn John husbandman 606920 606920 Brayn, John, of Wytney, husbandman 0
4973639 2349069 2349069 defendant Ryder William yeoman 606920 606920 Ryder, William, of Wytney, yeoman 0
5004569 2358237 2358237 defendant Symond William husbandman 606920 606920 Symond, William, of Wytney, husbandman 0
5023479 2363776 2363776 defendant Edney John cordwainer 606920 606920 Edney, John, of Wytney, cordwainer 0
5096914 2385527 2385527 defendant Dustelyng Richard husbandman 606920 606920 Dustelyng, Richard, of Wytney, husbandman 0
5118815 2391934 2391934 defendant Dyer Richard dyer 606920 606920 Dyer, Richard, of Wytney, dyer 0
5126699 2394284 2394284 defendant Lovecok --ionus husbandman 606920 606920 Lovecok, --ionus, of Wytney, husbandman 0
5145384 2399796 2399796 defendant Lovecok Simon husbandman 606920 606920 Lovecok, Simon, of Wytney, husbandman 0
5262066 2433885 2433885 defendant Berston John miller 606920 606920 Berston, John, of Wytney, miller 0
5262067 2433885 2433885 defendant Fetheler John yeoman 606920 606920 Fetheler, John, of Wytney, yeoman 1
5288401 2441628 2441628 plaintiff Locok Simon   606920 606920 Locok, Simon, of Wytney 0
5319120 2450813 2450813 defendant Shepherd Thomas yeoman 606920 606920 Shepherd, Thomas, of Wytney, yeoman 0
5330575 2454234 2454234 defendant Holme Thomas dyer 606920 606920 Holme, Thomas, of Wytney, dyer 0
5345928 2458859 2458859 defendant Caswell Robert chaplain 606920 606920 Caswell, Robert, of Wytney, chaplain 0
5354226 2461386 2461386 plaintiff Harecourte John esq 606920 606920 Harecourte, John, of Wytney, esq 0
5369683 2466102 2466102 defendant Gillon Thomas husbandman 606920 606920 Gillon, Thomas, of Wytney, husbandman 0
5376433 2468226 2468226 defendant Rede Ralph butcher 606920 606920 Rede, Ralph, of Wytney, butcher 1
5376436 2468227 2468227 defendant Rede Ralph butcher 606920 606920 Rede, Ralph, of Wytney, butcher 1
5398561 2474649 2474649 plaintiff Harecourt John esq 606920 606920 Harecourt, John, of Wytney, esq 1
5404489 2476353 2476353 defendant Har--- John esq 606920 606920 Har---, John, of Wytney, esq 1
5407516 2477221 2477221 defendant Gyllon Thomas yeoman 606920 606920 Gyllon, Thomas, of Wytney, yeoman 0
5427860 2483286 2483286 defendant Hosyer Edward chapman 606920 606920 Hosyer, Edward, of Wytney, chapman 1
5427967 2483316 2483316 defendant Hosyer Edward chapman 606920 606920 Hosyer, Edward, of Wytney, chapman 1
5486121 2500734 2500734 defendant Holme Thomas dyer 606920 606920 Holme, Thomas, of Wytney, dyer 1
5517474 2510306 2510306 defendant Dustelyng William fuller 606920 606920 Dustelyng, William, of Wytney, fuller 0
5517475 2510306 2510306 defendant Box William fuller 606920 606920 Box, William, of Wytney, fuller 1
5547272 2519216 2519216 plaintiff Wenman Richard   606920 606920 Wenman, Richard, of Wytney 0
5547277 2519217 2519217 plaintiff Wenman Richard   606920 606920 Wenman, Richard, of Wytney 0
5547284 2519218 2519218 plaintiff Wenman Richard   606920 606920 Wenman, Richard, of Wytney 0
5547289 2519219 2519219 plaintiff Wenman Richard   606920 606920 Wenman, Richard, of Wytney 0
5552939 2520907 2520907 defendant Somerffeld William   606920 606920 Somerffeld, William, of Wytney, servant 0
5552940 2520907 2520907 defendant Maye Thomas salter 606920 606920 Maye, Thomas, of Wytney, salter 1
5552941 2520907 2520907 defendant Rose Thomas shoemaker 606920 606920 Rose, Thomas, of Wytney, shoemaker 2
5552942 2520907 2520907 defendant Evan John laborer 606920 606920 Evan, John, of Wytney, laborer 3
5552943 2520907 2520907 defendant Dyngell Roger glover 606920 606920 Dyngell, Roger, of Wytney, glover 4
5552944 2520907 2520907 defendant Box John fuller 606920 606920 Box, John, of Wytney, fuller 5
5552945 2520907 2520907 defendant Dannyng Richard fuller 606920 606920 Dannyng, Richard, of Wytney, fuller 6
5552946 2520907 2520907 defendant Goldron John glover 606920 606920 Goldron, John, of Wytney, glover 7
5552947 2520907 2520907 defendant Bysshopp John laborer 606920 606920 Bysshopp, John, of Wytney, laborer 8
5552948 2520907 2520907 defendant Lane ohn fuller 606920 606920 Lane, ohn, of Wytney, fuller 9
5552950 2520908 2520908 defendant Somerffeld William   606920 606920 Somerffeld, William, of Wytney, servant 0
5552952 2520908 2520908 defendant Rose Thomas shoemaker 606920 606920 Rose, Thomas, of Wytney, shoemaker 2
5552953 2520908 2520908 defendant Evan John laborer 606920 606920 Evan, John, of Wytney, laborer 3
5552954 2520908 2520908 defendant Dyngell Roger glover 606920 606920 Dyngell, Roger, of Wytney, glover 4
5552955 2520908 2520908 defendant Box John fuller 606920 606920 Box, John, of Wytney, fuller 5
5552956 2520908 2520908 defendant Dannyng Richard fuller 606920 606920 Dannyng, Richard, of Wytney, fuller 6
5552957 2520908 2520908 defendant Goldron John glover 606920 606920 Goldron, John, of Wytney, glover 7

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