names

115 rows where place_id = 739739

✎ 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
4337071 2142688 2142688 defendant Cotwyn Daniel yeoman 739739 739739 Cotwyn, Daniel, of Kirketon, yeoman 3
4416678 2170082 2170082 plaintiff Nyvery John   739739 739739 Nyvery, John, of Kirketon 0
4424713 2172565 2172565 defendant Stalweworth Robert   739739 739739 Stalweworth, Robert, of Kirketon, son of Geoffrey 0
4431178 2174511 2174511 plaintiff Benett John clerk 739739 739739 Benett, John, of Kirketon, clerk 0
4438168 2181237 2181237 plaintiff Andreweson Thomas merchant 739739 739739 Andreweson, Thomas, of Kirketon, merchant 0
4438169 2181237 2181237 defendant Whelewryght Thomas   739739 739739 Whelewryght, Thomas, of Kirketon 0
4438170 2181237 2181237 defendant Whelewryght John   739739 739739 Whelewryght, John, of Kirketon 1
4440328 2181888 2181888 plaintiff Belers Roger   739739 739739 Belers, Roger, of Kirketon, vicar 0
4440511 2181944 2181944 plaintiff Benyngton Thomas   739739 739739 Benyngton, Thomas, of Kirketon, son of John 0
4448959 2184614 2184614 defendant Umfrey Aldous   739739 739739 Umfrey, Aldous, of Kirketon 1
4448960 2184614 2184614 defendant Hardpeny Thomas   739739 739739 Hardpeny, Thomas, of Kirketon 2
4450910 2185254 2185254 defendant Hervy John   739739 739739 Hervy, John, of Kirketon 0
4450912 2185254 2185254 defendant Hervy Hugh   739739 739739 Hervy, Hugh, of Kirketon 2
4453164 2185994 2185994 defendant Whelewryght Thomas   739739 739739 Whelewryght, Thomas, of Kirketon 4
4457425 2187333 2187333 plaintiff Perkyn John   739739 739739 Perkyn, John, of Kirketon, merchant, staying in Boston 0
4461354 2188633 2188633 plaintiff Stalworth William draper 739739 739739 Stalworth, William, of Kirketon, draper 0
4461355 2188633 2188633 defendant Whelewright Thomas   739739 739739 Whelewright, Thomas, of Kirketon 0
4461548 2188691 2188691 defendant Badreweson Thomas   739739 739739 Badreweson, Thomas, of Kirketon 0
4461549 2188691 2188691 defendant Bateson John   739739 739739 Bateson, John, of Kirketon, son of Hugh 1
4461558 2188692 2188692 defendant Katteson Roger   739739 739739 Katteson, Roger, of Kirketon, son of Hugh 1
4461562 2188694 2188694 plaintiff Stevenson William   739739 739739 Stevenson, William, of Kirketon 0
4462221 2188880 2188880 defendant Beel John   739739 739739 Beel, John, of Kirketon 0
4465524 2189885 2189885 defendant del Feld John   739739 739739 del Feld, John, of Kirketon 0
4468352 2190767 2190767 defendant Foule Edmund   739739 739739 Foule, Edmund, of Kirketon, son of John 1
4471728 2191825 2191825 defendant Wryghte Edmund   739739 739739 Wryghte, Edmund, of Kirketon 0
4471729 2191825 2191825 defendant atte Halle Thomas   739739 739739 atte Halle, Thomas, of Kirketon 1
4482983 2195374 2195374 defendant Andreweson Thomas   739739 739739 Andreweson, Thomas, of Kirketon 0
4488167 2197015 2197015 plaintiff Stalworth William   739739 739739 Stalworth, William, of Kirketon 0
4488168 2197015 2197015 defendant Hervy Simon   739739 739739 Hervy, Simon, of Kirketon 0
4501754 2201145 2201145 defendant Ragson Thomas   739739 739739 Ragson, Thomas, of Kirketon 2
4502304 2201311 2201311 defendant Skelton William de   739739 739739 Skelton, William de, of Kirketon 0
4505874 2202344 2202344 defendant Gery Robert   739739 739739 Gery, Robert, of Kirketon 0
4506673 2202565 2202565 defendant Bole Thomas   739739 739739 Bole, Thomas, of Kirketon 2
4510753 2203820 2203820 defendant Couper John   739739 739739 Couper, John, of Kirketon 0
4511154 2203939 2203939 plaintiff Bele John   739739 739739 Bele, John, of Kirketon 0
4514253 2204874 2204874 defendant Holte Thomas   739739 739739 Holte, Thomas, of Kirketon 0
4518407 2206133 2206133 plaintiff Meres John de   739739 739739 Meres, John de, of Kirketon 2
4524259 2207923 2207923 plaintiff Hobard Robert   739739 739739 Hobard, Robert, of Kirketon 0
4525154 2208208 2208208 defendant Idon Thomas   739739 739739 Idon, Thomas, of Kirketon 0
4528557 2209208 2209208 plaintiff Mason Gilbert   739739 739739 Mason, Gilbert, of Kirketon 0
4536153 2211583 2211583 plaintiff Duncot Henry   739739 739739 Duncot, Henry, of Kirketon, parson 1
4536489 2211688 2211688 plaintiff Stalworth William   739739 739739 Stalworth, William, of Kirketon 0
4536490 2211688 2211688 plaintiff Mabilson Robert   739739 739739 Mabilson, Robert, of Kirketon 1
4536948 2211825 2211825 defendant Gery Robert   739739 739739 Gery, Robert, of Kirketon 0
4538263 2212255 2212255 defendant Pykeworth John   739739 739739 together with Pykeworth, John, of Kirketon 3
4540326 2212872 2212872 plaintiff Welby Thomas   739739 739739 Welby, Thomas, of Kirketon 0
4540327 2212872 2212872 defendant Warde John   739739 739739 Warde, John, of Kirketon 0
4544491 2214191 2214191 plaintiff Batisson Edmund   739739 739739 Batisson, Edmund, of Kirketon 0
4544493 2214192 2214192 plaintiff Batisson Edmund   739739 739739 Batisson, Edmund, of Kirketon 0
4544851 2214310 2214310 plaintiff Beleres Roger   739739 739739 Beleres, Roger, of Kirketon, vicar 0
4559459 2218907 2218907 plaintiff Welby Thomas de   739739 739739 Welby, Thomas de, of Kirketon 2
4559461 2218908 2218908 plaintiff Meres Thomas (legal representative) 739739 739739 Meres, Thomas, of Kirketon, executors of 0
4562338 2219782 2219782 defendant Hervy Joceus   739739 739739 Hervy, Joceus, of Kirketon 0
4565555 2220797 2220797 defendant Stalworth William   739739 739739 Stalworth, William, of Kirketon 3
4567000 2221237 2221237 defendant Joneson John   739739 739739 Joneson, John, of Kirketon 2
4577047 2224329 2224329 plaintiff Bykerswayn Robert   739739 739739 Bykerswayn, Robert, of Kirketon 0
4577048 2224329 2224329 defendant Blunte Alan   739739 739739 Blunte, Alan, of Kirketon 0
4583094 2226135 2226135 plaintiff Flete John   739739 739739 Flete, John, of Kirketon 0
4586170 2227098 2227098 defendant Poles John   739739 739739 Poles, John, of Kirketon 0
4598259 2230693 2230693 defendant Preston Robert   739739 739739 Preston, Robert, of Kirketon 1
4599126 2230941 2230941 plaintiff Meers John de   739739 739739 (Meers, John de, of Kirketon 1
4632865 2241155 2241155 defendant Cleyen William   739739 739739 Cleyen, William, of Kirketon 9
4632880 2241157 2241157 defendant Welleford John   739739 739739 Welleford, John, of Kirketon 0
4634513 2241642 2241642 defendant Warner John, sen   739739 739739 Warner, John, sen, of Kirketon 0
4648819 2245713 2245713 defendant Nicoll John   739739 739739 Nicoll, John, of Kirketon 4
4651912 2246537 2246537 defendant Burdon Richard husbandman 739739 739739 Burdon, Richard, of Kirketon, husbandman 0
4651913 2246537 2246537 defendant Burdon John husbandman 739739 739739 Burdon, John, of Kirketon, husbandman 1
4651914 2246537 2246537 defendant Taillour Richard tailor 739739 739739 Taillour, Richard, of Kirketon, tailor 2
4651915 2246537 2246537 defendant Weston Thomas husbandman 739739 739739 Weston, Thomas, of Kirketon, husbandman 3
4651916 2246537 2246537 defendant Yong William husbandman 739739 739739 Yong, William, of Kirketon, husbandman 4
4660229 2249033 2249033 defendant Burdon Richard husbandman 739739 739739 Burdon, Richard, of Kirketon, husbandman 0
4662183 2249646 2249646 defendant Foule Edmund yeoman 739739 739739 together with Foule, Edmund, of Kirketon, yeoman 2
4666848 2255357 2255357 defendant Burdon Richard husbandman 739739 739739 Burdon, Richard, of Kirketon, husbandman 0
4675646 2257993 2257993 plaintiff Foule Edmund   739739 739739 Foule, Edmund, of Kirketon 0
4675647 2257993 2257993 defendant Forbyshoure Reginald   739739 739739 Forbyshoure, Reginald, of Kirketon, sow gelder 0
4724960 2273100 2273100 plaintiff Olton David   739739 739739 Olton, David, of Kirketon, vicar 2
4744937 2279034 2279034 plaintiff Ulton David   739739 739739 Ulton, David, of Kirketon, vicar 2
4744943 2279035 2279035 plaintiff Holton David   739739 739739 Holton, David, of Kirketon, vicar 1
4776039 2288505 2288505 plaintiff Olton David   739739 739739 Olton, David, of Kirketon, vicar 3
4816379 2301214 2301214 defendant Carter Thomas husbandman 739739 739739 Carter, Thomas, of Kirketon, husbandman 1
4823652 2303489 2303489 defendant Iveson John yeoman 739739 739739 Iveson, John, of Kirketon, yeoman 1
4823653 2303489 2303489 defendant Tomson John yeoman 739739 739739 Tomson, John, of Kirketon, yeoman 2
4823654 2303489 2303489 defendant Warner John yeoman 739739 739739 Warner, John, of Kirketon, yeoman 3
4825560 2304033 2304033 defendant Hervy Michael chaplain 739739 739739 Hervy, Michael, of Kirketon, chaplain 10
4827431 2304627 2304627 defendant Frenche John laborer 739739 739739 Frenche, John, of Kirketon, laborer 4
4879064 2320383 2320383 plaintiff Trane John husbandman 739739 739739 Trane, John, of Kirketon, husbandman 0
4911506 2330100 2330100 defendant Williamson Richard husbandman 739739 739739 Williamson, Richard, of Kirketon, husbandman 1
4911507 2330100 2330100 defendant Puttok Thomas husbandman 739739 739739 Puttok, Thomas, of Kirketon, husbandman 2
4911508 2330100 2330100 defendant Bailly Thomas husbandman 739739 739739 Bailly, Thomas, of Kirketon, husbandman 3
4914775 2331138 2331138 defendant Stalworth William yeoman 739739 739739 Stalworth, William, of Kirketon, yeoman 0
4930945 2336074 2336074 defendant Iveson John yeoman 739739 739739 Iveson, John, of Kirketon, yeoman 0
4931735 2336311 2336311 defendant Bailly Margaret widow 739739 739739 Bailly, Margaret, of Kirketon, widow 0
4968284 2347474 2347474 defendant Norton Robert yeoman 739739 739739 Norton, Robert, of Kirketon, yeoman 0
4995024 2355369 2355369 plaintiff Echard Richard   739739 739739 (Echard, Richard, of Kirketon 1
5075477 2379160 2379160 plaintiff Aleyn John   739739 739739 Aleyn, John, of Kirketon 0
5093615 2384530 2384530 defendant Bramby Peter laborer 739739 739739 together with Bramby, Peter, of Kirketon, laborer 1
5101663 2386909 2386909 defendant Hopkynson Alan husbandman 739739 739739 Hopkynson, Alan, of Kirketon, husbandman 1
5101664 2386909 2386909 defendant Hopkynson Richard husbandman 739739 739739 Hopkynson, Richard, of Kirketon, husbandman 2
5104493 2387742 2387742 plaintiff Candeler William   739739 739739 Candeler, William, of Kirketon 0
5104494 2387742 2387742 plaintiff Candeler Robert   739739 739739 Candeler, Robert, of Kirketon 1

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