home / cp40x

names

116 rows where place_id = 592035

✎ 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
3606365 1869657 1869657 defendant Mury John yeoman 592035 592035 Mury, John, of Eynesham, yeoman 0
3630647 1904414 1904414 defendant Conyngham William yeoman 592035 592035 Conyngham, William, of Eynesham, yeoman 4
3634831 1905694 1905694 defendant Webbe alias Kyrby Thomas husbandman 592035 592035 Webbe alias Kyrby, Thomas, of Eynesham, husbandman 1
3650326 1910476 1910476 defendant Botrell John yeoman 592035 592035 Botrell, John, of Eynesham, yeoman 0
3664096 1914723 1914723 plaintiff Reading Henry   592035 592035 Reading, Henry, of Eynesham, abbot of the monastery of St Mary the virgin 0
3664097 1914723 1914723 defendant Davy John gent 592035 592035 Davy, John, of Eynesham, gent 0
3667876 1915894 1915894 defendant Hickis Roger butcher 592035 592035 Hickis, Roger, of Eynesham, butcher 0
3667881 1915895 1915895 defendant Hyckys Roger butcher 592035 592035 Hyckys, Roger, of Eynesham, butcher 0
3685611 1921652 1921652 defendant Bery Richard glover 592035 592035 Bery, Richard, of Eynesham, glover 0
3698859 1925859 1925859 defendant Brameley Humphrey tanner 592035 592035 Brameley, Humphrey, of Eynesham, tanner 2
3806359 1959902 1959902 defendant Wykes John husbandman 592035 592035 Wykes, John, of Eynesham, husbandman 1
3806360 1959902 1959902 defendant Goodwyn Richard husbandman 592035 592035 Goodwyn, Richard, of Eynesham, husbandman 2
3843277 1971430 1971430 defendant Wykkys John husbandman 592035 592035 Wykkys, John, of Eynesham, husbandman 0
3899095 1989905 1989905 defendant Blakeman Thomas yeoman 592035 592035 Blakeman, Thomas, of Eynesham, yeoman 0
3899096 1989905 1989905 defendant Blakeman William singleman 592035 592035 Blakeman, William, of Eynesham, singleman 1
3899097 1989905 1989905 defendant Shepard Hugh   592035 592035 Shepard, Hugh, of Eynesham, shepherd 2
3919544 1996869 1996869 defendant Bery Lawrence yeoman 592035 592035 (Bery, Lawrence, of Eynesham, yeoman 1
3927935 1999682 1999682 defendant Ruffyn Richard yeoman 592035 592035 Ruffyn, Richard, of Eynesham, yeoman 0
3927936 1999682 1999682 defendant Ruffyn John yeoman 592035 592035 Ruffyn, John, of Eynesham, yeoman 1
4221814 2103126 2103126 defendant Hampsheere John yeoman 592035 592035 Hampsheere, John, of Eynesham, yeoman 0
4413713 2169182 2169182 defendant Noble John le   592035 592035 Noble, John le, of Eynesham 0
4420046 2171170 2171170 defendant Shepeherde William le   592035 592035 Shepeherde, William le, of Eynesham 0
4424863 2172612 2172612 defendant Morel Robert   592035 592035 Morel, Robert, of Eynesham 0
4424864 2172612 2172612 defendant Sclattere William le   592035 592035 Sclattere, William le, of Eynesham 1
4424866 2172612 2172612 defendant Nobbe John le   592035 592035 Nobbe, John le, of Eynesham 3
4433097 2175104 2175104 defendant Stalynton Robert de chaplain 592035 592035 Stalynton, Robert de, of Eynesham, chaplain 0
4443031 2182782 2182782 defendant Blake John   592035 592035 Blake, John, of Eynesham, senior 0
4453989 2186263 2186263 defendant Smyth Peter   592035 592035 Smyth, Peter, of Eynesham 2
4463949 2189397 2189397 defendant Brunncombe William butcher 592035 592035 Brunncombe, William, of Eynesham, butcher 1
4481004 2194734 2194734 defendant Mercer Richard   592035 592035 Mercer, Richard, of Eynesham 1
4491645 2198072 2198072 defendant Taillour Adam   592035 592035 (Taillour, Adam, of Eynesham 1
4512748 2204422 2204422 plaintiff Bradyngstoke Thomas   592035 592035 Bradyngstoke, Thomas, of Eynesham, abbot 0
4554064 2217193 2217193 defendant Lounde William   592035 592035 Lounde, William, of Eynesham 0
4564204 2220378 2220378 defendant Lounde William   592035 592035 Lounde, William, of eynesham 0
4566339 2221043 2221043 defendant Bradinstok Thomas   592035 592035 Bradinstok, Thomas, of Eynesham, abbot of the monastery 0
4566341 2221044 2221044 defendant Bradinstok Thomas   592035 592035 Bradinstok, Thomas, of Eynesham, abbot of the monastery 0
4571323 2222614 2222614 defendant Faireford John   592035 592035 Faireford, John, of Eynesham 0
4582530 2225979 2225979 defendant Berwyke John   592035 592035 Berwyke, John, of Eynesham 0
4582531 2225979 2225979 defendant Hulle John   592035 592035 Hulle, John, of Eynesham 1
4614300 2235485 2235485 defendant Hampton Thomas   592035 592035 together with Hampton, Thomas, of Eynesham 3
4615321 2235800 2235800 defendant Tanner Robert   592035 592035 Tanner, Robert, of Eynesham 0
4623135 2238211 2238211 plaintiff Mason alias Vicori William (legal representative) 592035 592035 Mason alias Vicori, William, of Eynesham, executrix of 0
4648789 2245702 2245702 defendant Spencer Thomas   592035 592035 Spencer, Thomas, of Eynesham 0
4661811 2249539 2249539 defendant Blake John, senior butcher 592035 592035 Blake, John, senior, of Eynesham, butcher 0
4661812 2249539 2249539 defendant Blake William husbandman 592035 592035 Blake, William, of Eynesham, husbandman 1
4661813 2249539 2249539 defendant Blake John, senior   592035 592035 Blake, John, senior, of Eynesham, servant 2
4661814 2249539 2249539 defendant Blake John, junior   592035 592035 Blake, John, junior, of Eynesham, servant 3
4661815 2249539 2249539 defendant Blake Thomas ploughman 592035 592035 Blake, Thomas, of Eynesham, ploughman 4
4661817 2249540 2249540 defendant Gefferey Hugh smith 592035 592035 Gefferey, Hugh, of Eynesham, smith 0
4661819 2249541 2249541 defendant Hulle John husbandman 592035 592035 Hulle, John, of Eynesham, husbandman 0
4667283 2255497 2255497 defendant Lound William husbandman 592035 592035 Lound, William, of Eynesham, husbandman 0
4700433 2265551 2265551 defendant Blake John butcher 592035 592035 Blake, John, of Eynesham, butcher 0
4700434 2265551 2265551 defendant Raas Thomas skinner 592035 592035 Raas, Thomas, of Eynesham, skinner 1
4700435 2265551 2265551 defendant Chaundeler Thomas husbandman 592035 592035 Chaundeler, Thomas, of Eynesham, husbandman 2
4700436 2265551 2265551 defendant Colles Geoffrey husbandman 592035 592035 Colles, Geoffrey, of Eynesham, husbandman 3
4700437 2265551 2265551 defendant Norreys Simon husbandman 592035 592035 Norreys, Simon, of Eynesham, husbandman 4
4700438 2265551 2265551 defendant Hynebest John tanner 592035 592035 Hynebest, John, of Eynesham, tanner 5
4700439 2265551 2265551 defendant Glover Hugh   592035 592035 Glover, Hugh, of Eynesham, glove maker 6
4700440 2265551 2265551 defendant Taillour Robert tailor 592035 592035 Taillour, Robert, of Eynesham, tailor 7
4705076 2266960 2266960 defendant atte Selere Thomas husbandman 592035 592035 atte Selere, Thomas, of Eynesham, husbandman 0
4720425 2271723 2271723 defendant Hewet Herny chapman 592035 592035 Hewet, Herny, of Eynesham, chapman 0
4724500 2272960 2272960 defendant Blake John butcher 592035 592035 Blake, John, of Eynesham, butcher 0
4724504 2272962 2272962 defendant Huet Henry husbandman 592035 592035 Huet, Henry, of Eynesham, husbandman 0
4724505 2272962 2272962 defendant Hynebest Henry husbandman 592035 592035 Hynebest, Henry, of Eynesham, husbandman 1
4729993 2274585 2274585 defendant Salesbury Walter shoemaker 592035 592035 Salesbury, Walter, of Eynesham, shoemaker 0
4729994 2274585 2274585 defendant Carter Thomas husbandman 592035 592035 Carter. Thomas, of Eynesham, husbandman 1
4729995 2274585 2274585 defendant Sawyer Lawrence husbandman 592035 592035 Sawyer, Lawrence, of Eynesham, husbandman 2
4734815 2276045 2276045 defendant Blakeman John husbandman 592035 592035 Blakeman, John, of Eynesham, husbandman 0
4734816 2276045 2276045 defendant atte Seler Thomas husbandman 592035 592035 atte Seler, Thomas, of Eynesham, husbandman 1
4742423 2278280 2278280 plaintiff Carpenter Reginald   592035 592035 Carpenter, Reginald, of Eynesham 0
4761975 2284092 2284092 defendant Panter Richard husbandman 592035 592035 Panter, Richard, of Eynesham, husbandman 0
4793419 2294048 2294048 defendant Blakeman John husbandman 592035 592035 Blakeman, John, of Eynesham, husbandman 1
4810475 2299422 2299422 defendant Newynham John husbandman 592035 592035 Newynham, John, of Eynesham, husbandman 0
4826490 2304321 2304321 defendant Ramsden James   592035 592035 Ramsden, James, of Eynesham, abbot 0
4910644 2329839 2329839 defendant Oxenford Thomas   592035 592035 Oxenford, Thomas, of Eynesham, abbot of the church of the BVM 0
4918322 2332248 2332248 defendant Oxenford Thomas   592035 592035 Oxenford, Thomas, of Eynesham, abbot of the church of the BVM 0
4940097 2338930 2338930 defendant Kene John husbandman 592035 592035 Kene, John, of Eynesham, husbandman 0
4940098 2338930 2338930 defendant Aleyn William weaver 592035 592035 Aleyn, William, of Eynesham, weaver 1
4940100 2338931 2338931 defendant Underway John weaver 592035 592035 Underway, John, of Eynesham, weaver 0
4950355 2342076 2342076 defendant Webbe William husbandman 592035 592035 Webbe, William, of Eynesham, husbandman 1
4950356 2342076 2342076 defendant Stokemanne John husbandman 592035 592035 Stokemanne, John, of Eynesham, husbandman 2
4977838 2350330 2350330 defendant Morton Christine widow 592035 592035 Morton, Christine, of Eynesham, widow 0
5001277 2357253 2357253 plaintiff Meleward Robert   592035 592035 Meleward, Robert, of Eynesham 0
5001279 2357254 2357254 plaintiff Meleward Robert   592035 592035 Meleward, Robert, of Eynesham 0
5027563 2364939 2364939 defendant Webbe John husbandman 592035 592035 Webbe, John, of Eynesham, husbandman 2
5053929 2372770 2372770 defendant Shorte William tanner 592035 592035 Shorte, William, of Eynesham, tanner 2
5097115 2385589 2385589 defendant Whitacre Thomas husbandman 592035 592035 Whitacre, Thomas, of Eynesham, husbandman 1
5127237 2394443 2394443 defendant Reson William clerk 592035 592035 Reson, William, of eynesham, clerk 2
5134143 2396481 2396481 defendant Rayson William clerk 592035 592035 Rayson, William, of Eynesham, clerk 0
5138066 2397639 2397639 plaintiff Rayson William clerk 592035 592035 Rayson, William, of Eynesham, clerk 0
5138068 2397640 2397640 plaintiff Rayson William   592035 592035 Rayson, William, of Eynesham, parson 0
5149147 2400880 2400880 defendant Salisman William husbandman 592035 592035 Salisman, William, of Eynesham, husbandman 1
5152017 2401726 2401726 defendant Pulker Richard husbandman 592035 592035 Pulker, Richard, of Eynesham, husbandman 0
5168178 2406406 2406406 defendant Salisman William husbandman 592035 592035 Salisman, William, of Eynesham, husbandman 1
5169959 2406946 2406946 defendant Pulker Richard husbandman 592035 592035 Pulker, Richard, of Eynesham, husbandman 0
5187189 2411981 2411981 defendant Pulker Richard husbandman 592035 592035 Pulker, Richard, of Eynesham, husbandman 0
5204098 2416950 2416950 defendant Salysman William husbandman 592035 592035 Salysman, William, of Eynesham, husbandman 1
5237691 2426608 2426608 defendant Payn Richard husbandman 592035 592035 Payn, Richard, of Eynesham, husbandman 1
5256768 2432239 2432239 defendant Shepeherd Robert husbandman 592035 592035 Shepeherd, Robert, of Eynesham, husbandman 2
5270295 2436412 2436412 defendant Walwayn William   592035 592035 Walwayn, William, of Eynesham, abbot 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);
Powered by Datasette · Queries took 20.662ms