names

138 rows where place_id = 589159

✎ 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
3596718 1866608 1866608 defendant Talmage John husbandman 589159 589159 Talmage, John, of Codenham, husbandman 0
3617297 1873035 1873035 defendant Bothe Humphrey gent 589159 589159 Bothe, Humphrey, of Codenham, gent 0
3618533 1873420 1873420 defendant Reynold Robert (legal representative) 589159 589159 Reynold, Robert, of Codenham, yeoman, executors of 1
3618534 1873420 1873420 defendant Reynold William yeoman 589159 589159 (Reynold, William, of Codenham, yeoman 2
3645314 1908944 1908944 plaintiff Gosnold Edmund yeoman 589159 589159 Gosnold, Edmund, of Codenham, yeoman 0
3646883 1909423 1909423 defendant Skopys Roger husbandman 589159 589159 Skopys, Roger, of Codenham, husbandman 0
3665948 1915284 1915284 defendant Baldwyn Thomas, senior   589159 589159 Baldwyn, Thomas, senior, of Codenham, husbandman, son & heir of John Baldwyn 0
3670905 1916866 1916866 defendant Reynold John yeoman 589159 589159 Reynold, John, of Codenham, yeoman 1
3671563 1917091 1917091 plaintiff Coke William (legal representative) 589159 589159 Coke, William, of Codenham, executors of 0
3674485 1918070 1918070 plaintiff Gosnold Edmund   589159 589159 Gosnold, Edmund, of Codenham 0
3674488 1918071 1918071 plaintiff Gosnold Edmund yeoman 589159 589159 Gosnold, Edmund, of Codenham, yeoman 0
3683179 1920858 1920858 defendant Coke Robert butcher 589159 589159 Coke, Robert, of Codenham, butcher 0
3707284 1928568 1928568 defendant Reynold John husbandman 589159 589159 Reynold, John, of Codenham, husbandman 0
3734669 1937090 1937090 defendant Webber Robert husbandman 589159 589159 Webber, Robert, of Codenham, husbandman 0
3753486 1943027 1943027 defendant Downyng Thomas smith 589159 589159 Downyng, Thomas, of Codenham, smith 3
3762659 1945958 1945958 defendant Hasyll John yeoman 589159 589159 Hasyll, John, of Codenham, yeoman 0
3762660 1945959 1945959 plaintiff Gossenold Edmund yeoman 589159 589159 Gossenold, Edmund, of Codenham, yeoman 0
3762662 1945960 1945960 plaintiff Gossenold Edmund   589159 589159 Gossenold, Edmund, of Codenham 0
3762663 1945960 1945960 plaintiff Reynold John   589159 589159 Reynold, John, of Codenham 1
3762664 1945960 1945960 plaintiff Frenche Robert   589159 589159 Frenche, Robert, of Codenham 2
3763552 1946235 1946235 defendant Cooke Robert husbandman 589159 589159 Cooke, Robert, of Codenham, husbandman 0
3763693 1946288 1946288 defendant Hasell John yeoman 589159 589159 Hasell, John, of Codenham, yeoman 0
3772249 1949006 1949006 defendant Reynold George yeoman 589159 589159 Reynold, George, of Codenham, yeoman 0
3780785 1951725 1951725 defendant Hasyll John tailor 589159 589159 Hasyll, John, of Codenham, tailor 0
3788108 1954073 1954073 defendant Coke Robert husbandman 589159 589159 Coke, Robert, of Codenham, husbandman 1
3798662 1957492 1957492 defendant Colman John husbandman 589159 589159 Colman, John, of Codenham, husbandman 2
3798748 1957523 1957523 defendant Dey Richard husbandman 589159 589159 Dey, Richard, of Codenham, husbandman 0
3798753 1957524 1957524 defendant Dey Richard husbandman 589159 589159 Dey, Richard, of Codenham, husbandman 0
3822187 1964838 1964838 defendant Hasyll John draper 589159 589159 Hasyll, John, of Codenham, draper 0
3822899 1965067 1965067 defendant Frenche Robert yeoman 589159 589159 Frenche, Robert, of Codenham, yeoman 0
3862714 1977723 1977723 plaintiff Hassyll John   589159 589159 Hassyll, John, of Codenham 0
3862715 1977723 1977723 defendant Cooke Robert husbandman 589159 589159 Cooke, Robert, of Codenham, husbandman 0
3862716 1977723 1977723 defendant Dewe Thomas husbandman 589159 589159 Dewe, Thomas, of Codenham, husbandman 1
3873775 1981450 1981450 defendant Gosnold Edmund yeoman 589159 589159 Gosnold, Edmund, of Codenham, yeoman 0
3876342 1982333 1982333 plaintiff Gosnold Edmund   589159 589159 Gosnold, Edmund, of Codenham 0
3880844 1983862 1983862 defendant Hassyll John yeoman 589159 589159 Hassyll, John, of Codenham, yeoman 0
3924274 1998426 1998426 defendant Cooke John husbandman 589159 589159 Cooke, John, of Codenham, husbandman 0
3933193 2001397 2001397 plaintiff Gosnold Edmund gent 589159 589159 Gosnold, Edmund, of Codenham, gent 0
3933195 2001398 2001398 plaintiff Gosnold Edmund gent 589159 589159 Gosnold, Edmund, of Codenham, gent 0
4097400 2059393 2059393 defendant Skopes John yeoman 589159 589159 Skopes, John, of Codenham, or of Cretyng St Mary, yeoman 0
4418786 2170742 2170742 defendant atte Bregge Robert   589159 589159 atte Bregge, Robert, of Codenham, son of John 0
4443126 2182811 2182811 defendant Jaune Nicholas   589159 589159 Jaune, Nicholas, of Codenham 0
4508633 2203179 2203179 plaintiff Alvene William   589159 589159 Alvene, William, of Codenham 0
4515106 2205137 2205137 plaintiff Chapman John   589159 589159 Chapman, John, of Codenham 0
4515108 2205137 2205137 defendant Muspet Joan   589159 589159 Muspet, Joan, of Codenham 1
4515111 2205138 2205138 defendant Muspet Joan   589159 589159 Muspet, Joan, of Codenham 1
4544935 2214335 2214335 defendant Bakere John   589159 589159 Bakere, John, of Codenham 0
4548085 2215343 2215343 plaintiff Chapman John   589159 589159 Chapman, John, of Codenham 0
4548091 2215344 2215344 plaintiff Chapman John   589159 589159 Chapman, John, of Codenham 0
4554890 2217457 2217457 defendant Scut Simon (legal representative) 589159 589159 Scut, Simon, of Codenham, executor of 1
4554891 2217457 2217457 defendant Scut John   589159 589159 Scut, John, of Codenham 2
4589384 2228057 2228057 plaintiff Bakere John   589159 589159 Bakere, John, of Codenham 1
4611013 2234514 2234514 defendant Reynburgh Walter   589159 589159 Reynburgh, Walter, of Codenham 0
4611015 2234515 2234515 defendant Reynburgh Walter   589159 589159 Reynburgh, Walter, of Codenham 0
4634875 2241759 2241759 defendant Bakere John   589159 589159 Bakere, John, of Codenham 3
4635726 2242017 2242017 defendant Wygenhale Thomas   589159 589159 Wygenhale, Thomas, of Codenham 2
4646192 2244959 2244959 defendant Leveson William   589159 589159 Leveson, William, of Codenham 3
4648702 2245677 2245677 defendant Payn John butcher 589159 589159 Payn, John, of Codenham, butcher 0
4650482 2246160 2246160 plaintiff Wodeward Robert   589159 589159 Wodeward, Robert, of Codenham 0
4671663 2256784 2256784 plaintiff Chapman John   589159 589159 Chapman, John, of Codenham 0
4679833 2259301 2259301 plaintiff Chapman John   589159 589159 Chapman, John, of Codenham 1
4681320 2259784 2259784 defendant Dowe Martin husbandman 589159 589159 Dowe, Martin, of Codenham, husbandman 1
4681323 2259784 2259784 defendant Cook Walter husbandman 589159 589159 Cook, Walter, of Codenham, husbandman 4
4681324 2259784 2259784 defendant Cakker John husbandman 589159 589159 Cakker, John, of Codenham, husbandman 5
4681325 2259784 2259784 defendant atte Chirche Martin husbandman 589159 589159 atte Chirche, Martin, of Codenham, husbandman 6
4681380 2259799 2259799 defendant Roo John husbandman 589159 589159 Roo, John, of codenham, husbandman 0
4681381 2259799 2259799 defendant Cook Walter husbandman 589159 589159 Cook, Walter, of Codenham, husbandman 1
4681382 2259799 2259799 defendant Cakestrete John, senior husbandman 589159 589159 Cakestrete, John, senior, of Codenham, husbandman 2
4681383 2259799 2259799 defendant atte Chirche Martin husbandman 589159 589159 atte Chirche, Martin, of Codenham, husbandman 3
4723483 2272652 2272652 defendant Cranele Joan widow & formerly wife of Richard 589159 589159 Cranele, Joan, of Codenham, widow & formerly wife of Richard 8
4729730 2274506 2274506 defendant Reynburgh Walter husbandman 589159 589159 Reynburgh, Walter, of Codenham, husbandman 0
4729732 2274506 2274506 defendant Boye John husbandman 589159 589159 Boye, John, of Codenham, husbandman 2
4743197 2278536 2278536 defendant Fathare John yeoman 589159 589159 Fathare, John, of Codenham, yeoman 2
4749455 2280320 2280320 defendant Grene John chaplain 589159 589159 Grene, John, of Codenham, chaplain 3
4753410 2281441 2281441 defendant Bakere John husbandman 589159 589159 Bakere, John, of Codenham, husbandman 0
4763659 2284621 2284621 defendant Glemesford John gent 589159 589159 (Glemesford, John, of Codenham, gent 1
4787346 2292113 2292113 defendant Chapman John (legal representative) 589159 589159 Chapman, John, of Codenham, executors of 0
4787347 2292113 2292113 defendant Glemesford John gent 589159 589159 (Glemesford, John, of Codenham, gent 1
4789847 2292893 2292893 defendant Moyse John laborer 589159 589159 Moyse, John, of Codenham, laborer 0
4791428 2293414 2293414 defendant Bakere John yeoman 589159 589159 Bakere, John, of Codenham, yeoman 0
4791429 2293414 2293414 defendant Harveys William husbandman 589159 589159 Harveys, William, of Codenham, husbandman 1
4791430 2293414 2293414 defendant Pole Alan fuller 589159 589159 Pole, Alan, of Codenham, fuller 2
4791432 2293414 2293414 defendant Muspet Richard yeoman 589159 589159 Muspet, Richard, of Codenham, yeoman 4
4809108 2299025 2299025 defendant Dowerys John   589159 589159 Dowerys, John, of Codenham, vicar 1
4838389 2307921 2307921 defendant Fathare Robert husbandman 589159 589159 Fathare, Robert, of Codenham, husbandman 0
4838390 2307921 2307921 defendant Colchestre Robert husbandman 589159 589159 Colchestre, Robert, of Codenham, husbandman 1
4844507 2309798 2309798 defendant Doures John clerk 589159 589159 Doures, John, of Codenham, clerk 0
4884096 2321938 2321938 plaintiff Fathare Roger (legal representative) 589159 589159 Fathare, Roger, of Codenham, executors of 0
4896881 2325679 2325679 defendant Hyght Thomas husbandman 589159 589159 Hyght, Thomas, of Codenham, husbandman 2
4919727 2332672 2332672 defendant Wyndesore John carter 589159 589159 Wyndesore, John, of Codenham, carter 2
4943900 2340056 2340056 defendant Chapman John (legal representative) 589159 589159 Chapman, John, of Codenham, executors of 0
4946609 2340935 2340935 defendant Pippe William ploughman 589159 589159 Pippe, William, of Codenham, ploughman 0
4969567 2347847 2347847 defendant Chapman John (legal representative) 589159 589159 Chapman, John, of Codenham, executors of 0
4969570 2347848 2347848 defendant Chapman John (legal representative) 589159 589159 Chapman, John, of Codenham, executors of 0
5003097 2357809 2357809 defendant Knotyng John husbandman 589159 589159 Knotyng, John, of Codenham, husbandman 3
5016910 2361837 2361837 defendant Walton John carpenter 589159 589159 Walton, John, of Codenham, carpenter 0
5063655 2375662 2375662 defendant Groundeshawe Richard yeoman 589159 589159 Groundeshawe, Richard, of Codenham, yeoman 2
5100779 2386652 2386652 defendant Grundeshawe Richard husbandman 589159 589159 Grundeshawe, Richard, of Codenham, husbandman 0
5109127 2389092 2389092 defendant Walton John carpenter 589159 589159 Walton, John, of Codenham, carpenter 2
5119055 2392012 2392012 defendant Doye Thomas yeoman 589159 589159 Doye, Thomas, of Codenham, yeoman 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);