names

87 rows where place_id = 588253

✎ 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
3593851 1865717 1865717 defendant at Wode John husbandman 588253 588253 at Wode, John, of Clayton, husbandman 0
3624919 1875325 1875325 defendant Poynton Richard husbandman 588253 588253 Poynton, Richard, of Clayton, husbandman 10
3664282 1914781 1914781 defendant Sale Thomas yeoman 588253 588253 Sale, Thomas, of Clayton, yeoman 1
3693942 1924309 1924309 defendant Midgeley John yeoman 588253 588253 Midgeley, John, of Clayton, yeoman 0
3703913 1927505 1927505 defendant Lovatt Richard husbandman 588253 588253 Lovatt, Richard, of Clayton, husbandman 0
3753515 1943036 1943036 defendant Deane Thomas yeoman 588253 588253 Deane, Thomas, of Clayton, yeoman 0
3759463 1944953 1944953 defendant Lovat John husbandman 588253 588253 Lovat, John, of Clayton, husbandman 0
3827574 1966484 1966484 plaintiff Brewer Richard husbandman 588253 588253 Brewer, Richard, of Clayton, husbandman 1
3827575 1966484 1966484 defendant Wode Thomas yeoman 588253 588253 Wode, Thomas, of Clayton, yeoman 0
3836368 1969283 1969283 defendant Stowars John husbandman 588253 588253 Stowars, John, of Clayton, husbandman 0
3854661 1975102 1975102 defendant Rowland John husbandman 588253 588253 Rowland, John, of Clayton, husbandman 2
3937031 2002718 2002718 defendant Kyng John husbandman 588253 588253 Kyng, John, of Clayton, husbandman 0
3937032 2002718 2002718 defendant Kyng Richard husbandman 588253 588253 Kyng, Richard, of Clayton, husbandman 1
3937033 2002718 2002718 defendant Leperd John husbandman 588253 588253 Leperd, John, of Clayton, husbandman 2
3937034 2002718 2002718 defendant Whitpayn Robert husbandman 588253 588253 Whitpayn, Robert, of Clayton, husbandman 3
3937035 2002718 2002718 defendant Whytpayn Thomas husbandman 588253 588253 Whytpayn, Thomas, of Clayton, husbandman 4
3952660 2008000 2008000 defendant Hollyns Thomas yeoman 588253 588253 Hollyns, Thomas, of Clayton, yeoman 0
4059839 2045912 2045912 defendant Culpeper Richard gent 588253 588253 Culpeper, Richard, of Clayton, gent 0
4066358 2048261 2048261 defendant Newall John clothier 588253 588253 Newall, John, of Clayton, clothier 0
4071046 2049944 2049944 defendant Culpeper Richard gent 588253 588253 Culpeper, Richard, of Clayton, gent 0
4129287 2070774 2070774 defendant Dawson William   588253 588253 Dawson, William, of Clayton 0
4132964 2072117 2072117 defendant Hopkynson Henry husbandman 588253 588253 Hopkynson, Henry, of Clayton, husbandman 0
4132965 2072117 2072117 defendant Newall Richard yeoman 588253 588253 Newall, Richard, of Clayton, yeoman 1
4132966 2072117 2072117 defendant Drake thomas husbandman 588253 588253 Drake, thomas, of Clayton, husbandman 2
4134363 2072619 2072619 defendant Culpeper Rochard gent 588253 588253 Culpeper, Rochard, of Clayton, gent 0
4136228 2073303 2073303 defendant Luxford Thomas, junior gent 588253 588253 Luxford, Thomas, junior, of Clayton, gent 0
4148907 2077736 2077736 defendant Rakes Robert carpenter 588253 588253 Rakes, Robert, of Clayton, carpenter 3
4159952 2081549 2081549 defendant Oxley Thomas yeoman 588253 588253 Oxley, Thomas, of Clayton, yeoman 1
4172935 2085987 2085987 defendant Hollyns Thomas yeoman 588253 588253 Hollyns, Thomas, of Clayton, yeoman 0
4176589 2087288 2087288 defendant Luxforde Thomas yeoman 588253 588253 Luxforde, Thomas, of Clayton, yeoman 3
4178274 2087872 2087872 defendant Popleton Isabel widow 588253 588253 Popleton, Isabel, of Clayton, widow 2
4187334 2091070 2091070 defendant Luxford Thomas   588253 588253 Luxford, Thomas, of Clayton yeoman 0
4190089 2092037 2092037 defendant Pencost Richard yeoman 588253 588253 Pencost, Richard, of Clayton, yeoman 0
4214269 2100508 2100508 defendant Tricket Owen husbandman 588253 588253 Tricket, Owen, of Clayton, husbandman 2
4228577 2105478 2105478 defendant Smyth Francis yeoman 588253 588253 Smyth, Francis, of Clayton, yeoman 1
4262125 2117007 2117007 defendant Clayton John yeoman 588253 588253 Clayton, John, of Clayton, yeoman 0
4325188 2138804 2138804 defendant Beny Henry clerk 588253 588253 Beny, Henry, of Clayton, clerk 0
4396220 2163310 2163310 defendant Stookes John yeoman 588253 588253 Stookes, John, of Clayton, yeoman 2
4434484 2175543 2175543 plaintiff Lathes John de   588253 588253 Lathes, John de, of Clayton, son of Paul 0
4436151 2176047 2176047 defendant Noble Beatrice   588253 588253 Noble, Beatrice, of Clayton 2
4464476 2189556 2189556 defendant Okelore John   588253 588253 Okelore, John, of Clayton 1
4496954 2199715 2199715 defendant Porter John   588253 588253 Porter, John, of Clayton 0
4515083 2205130 2205130 plaintiff Chapell William   588253 588253 Chapell, William, of Clayton 0
4515085 2205130 2205130 defendant Coly Roger   588253 588253 Coly, Roger, of Clayton 1
4518959 2206290 2206290 defendant Warde Adam   588253 588253 Warde, Adam, of Clayton 1
4518960 2206290 2206290 defendant Warde John   588253 588253 Warde, John, of Clayton 2
4518963 2206290 2206290 defendant Kese John   588253 588253 Kese, John, of Clayton 5
4518965 2206290 2206290 defendant Williamson John   588253 588253 Williamson, John, of Clayton 7
4518966 2206290 2206290 defendant Walker William   588253 588253 Walker, William, of Clayton 8
4518967 2206290 2206290 defendant Holme William de   588253 588253 Holme, William de, of Clayton 9
4539337 2212563 2212563 defendant Warde Adam   588253 588253 Warde, Adam, of Clayton 1
4539338 2212563 2212563 defendant Warde John   588253 588253 Warde, John, of Clayton 2
4539341 2212563 2212563 defendant Kese John   588253 588253 Kese, John, of Clayton 5
4539343 2212563 2212563 defendant Williamson John   588253 588253 Williamson, John, of Clayton 7
4539344 2212563 2212563 defendant Walker William   588253 588253 Walker, William, of Clayton 8
4539345 2212563 2212563 defendant Holme William de   588253 588253 Holme, William de, of Clayton 9
4693092 2263345 2263345 defendant Saywell Thomas (legal representative) 588253 588253 Saywell, Thomas, of Clayton, executors of 0
4708820 2268128 2268128 defendant Brakepooll John husbandman 588253 588253 Brakepooll, John, of Clayton, husbandman 0
4708825 2268129 2268129 defendant Bracpol John husbandman 588253 588253 Bracpol, John, of Clayton, husbandman 0
4783045 2290715 2290715 defendant Pycombe William   588253 588253 Pycombe, William, of Clayton, shepherd 0
4783102 2290732 2290732 defendant Frye John laborer 588253 588253 Frye, John, of Clayton, laborer 3
4792196 2293648 2293648 defendant Clayton Henry husbandman 588253 588253 Clayton, Henry, of Clayton, husbandman 3
4823439 2303419 2303419 defendant Appulyerd John (legal representative) 588253 588253 Appulyerd, John, of Clayton, executrix of 0
4854313 2312756 2312756 defendant Roper John husbandman 588253 588253 Roper, John, of Clayton, husbandman 0
4854314 2312756 2312756 defendant Holyns Richard de husbandman 588253 588253 Holyns, Richard de, of Clayton, husbandman 1
4854315 2312756 2312756 defendant del Okes William husbandman 588253 588253 del Okes, William, of Clayton, husbandman 2
4854316 2312756 2312756 defendant Mortymer John husbandman 588253 588253 Mortymer, John, of Clayton, husbandman 3
4854317 2312756 2312756 defendant del Wod John husbandman 588253 588253 del Wod, John, of Clayton, husbandman 4
4873736 2318727 2318727 defendant Thornton Robert husbandman 588253 588253 Thornton, Robert, of Clayton, husbandman 2
4943557 2339956 2339956 defendant Frye John husbandman 588253 588253 Frye, John, of Clayton, husbandman 0
4980632 2351145 2351145 defendant Appilyerd Henry yeoman 588253 588253 Appilyerd, Henry, of Clayton, yeoman 1
4980634 2351145 2351145 defendant Porter John husbandman 588253 588253 Porter, John, of Clayton, husbandman 3
5013462 2360774 2360774 defendant Brakpole John husbandman 588253 588253 Brakpole, John, of Clayton, husbandman 0
5037694 2367896 2367896 defendant Porter John husbandman 588253 588253 Porter, John, of Clayton, husbandman 5
5037776 2367925 2367925 defendant Porter William laborer 588253 588253 Porter, William, of Clayton, laborer 0
5052109 2372245 2372245 defendant Apylyerde Henry husbandman 588253 588253 Apylyerde, Henry, of Clayton, husbandman 0
5058225 2374017 2374017 defendant Cartwryght John husbandman 588253 588253 Cartwryght, John, of Clayton, husbandman 0
5085376 2382118 2382118 defendant Lovot William husbandman 588253 588253 Lovot, William, of Clayton, husbandman 5
5085378 2382118 2382118 defendant Lovot Richard husbandman 588253 588253 Lovot, Richard, of Clayton, husbandman 7
5127398 2394495 2394495 defendant Porter John yeoman 588253 588253 Porter, John, of Clayton, yeoman 2
5225445 2423120 2423120 defendant Radclyff Henry gent 588253 588253 Radclyff, Henry, of Clayton, gent 0
5280937 2439500 2439500 defendant Hyncheclyfe Emma widow 588253 588253 Hyncheclyfe, Emma, of Clayton juxta Doncaster, widow 0
5280939 2439501 2439501 defendant Wharom John husbandman 588253 588253 Wharom, John, of Clayton juxta Doncaster, husbandman 0
5282314 2439887 2439887 defendant Adam Richard husbandman 588253 588253 Adam, Richard, of Clayton, husbandman 1
5403920 2476194 2476194 defendant atte Wode Thomas husbandman 588253 588253 atte Wode, Thomas, of Clayton, husbandman 0
5511925 2508585 2508585 defendant Passelewe John yeoman 588253 588253 Passelewe, John, of Clayton, yeoman 6
5551111 2520350 2520350 defendant Wode Thomas yeoman 588253 588253 Wode, Thomas, of Clayton, yeoman 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);