names

109 rows where place_id = 589856

✎ 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
3599007 1867323 1867323 defendant Calaber Roger husbandman 589856 589856 Calaber, Roger, of Pakenham, husbandman 2
3604171 1868971 1868971 defendant Clerk Robert husbandman 589856 589856 Clerk, Robert, of Pakenham, husbandman 0
3644230 1908627 1908627 defendant Smyth John husbandman 589856 589856 Smyth, John, of Pakenham, husbandman 0
3710240 1929519 1929519 plaintiff Schandell William   589856 589856 Schandell, William, of Pakenham 0
3747051 1940993 1940993 defendant Broke Thomas yeoman 589856 589856 Broke, Thomas, of Pakenham, yeoman 3
3761063 1945462 1945462 defendant Payn John laborer 589856 589856 Payn, John, of Pakenham, laborer 2
3767694 1947531 1947531 defendant Cage Thomas yeoman 589856 589856 Cage, Thomas, of Pakenham, yeoman 4
3794177 1956050 1956050 plaintiff Cage Thomas yeoman 589856 589856 Cage, Thomas, of Pakenham, yeoman 0
3794356 1956113 1956113 plaintiff Case Thomas yeoman 589856 589856 Case, Thomas, of Pakenham, yeoman 0
3794359 1956113 1956113 defendant Box John husbandman 589856 589856 Box, John, of Pakenham, husbandman 2
3807946 1960375 1960375 plaintiff Wyngfeld Edmund (legal representative) 589856 589856 Wyngfeld, Edmund, of Pakenham, executrix of 0
3811130 1961378 1961378 plaintiff Cage Thomas yeoman 589856 589856 Cage, Thomas, of Pakenham, yeoman 0
3819168 1963882 1963882 defendant Fuller John husbandman 589856 589856 Fuller, John, of Pakenham, husbandman 0
3857612 1976014 1976014 defendant Cage Walter husbandman 589856 589856 Cage, Walter, of Pakenham, husbandman 0
3867860 1979483 1979483 plaintiff Smyth Edmund yeoman 589856 589856 Smyth, Edmund, of Pakenham, yeoman 0
3867867 1979486 1979486 plaintiff Smyth Edward yeoman 589856 589856 Smyth, Edward, of Pakenham, yeoman 0
3881846 1984182 1984182 plaintiff Smythe Edmund yeoman 589856 589856 Smythe, Edmund, of Pakenham, yeoman 0
3948819 2006653 2006653 defendant Cowper William beer brewer 589856 589856 Cowper, William, of Pakenham, beer brewer 0
3965090 2012396 2012396 plaintiff Bardwell Edward gent 589856 589856 Bardwell, Edward, of Pakenham, gent 0
3971835 2014710 2014710 plaintiff Fiske Robert yeoman 589856 589856 Fiske, Robert, of Pakenham, yeoman 0
3979817 2017536 2017536 defendant Bett William tanner 589856 589856 Bett, William, of Pakenham, tanner 0
4010317 2028455 2028455 defendant Wylkyn Thomas yeoman 589856 589856 Wylkyn, Thomas, of Pakenham, yeoman 0
4010318 2028455 2028455 defendant Sterne David yeoman 589856 589856 Sterne, David, of Pakenham, yeoman 1
4085510 2055094 2055094 defendant Bett William tanner 589856 589856 Bett, William, of Pakenham, tanner 0
4142926 2075698 2075698 defendant Tye Robert husbandman 589856 589856 Tye, Robert, of Pakenham, husbandman 0
4142927 2075698 2075698 defendant Adkyns Robert husbandman 589856 589856 Adkyns, Robert, of Pakenham, husbandman 1
4142928 2075698 2075698 defendant Lawes Thomas husbandman 589856 589856 Lawes, Thomas, of Pakenham, husbandman 2
4142929 2075698 2075698 defendant Laste Nicholas husbandman 589856 589856 Laste, Nicholas, of Pakenham, husbandman 3
4142930 2075698 2075698 defendant Cage John husbandman 589856 589856 Cage, John, of Pakenham, husbandman 4
4225684 2104448 2104448 defendant Springe John esq 589856 589856 Springe, John, of Pakenham, esq 0
4236837 2108461 2108461 defendant Bannocke Andrew   589856 589856 Bannocke, Andrew, of Pakenham, mason 1
4344160 2145237 2145237 defendant Pettitt Bartholomew yeoman 589856 589856 Pettitt, Bartholomew, of Pakenham, yeoman 1
4411100 2168299 2168299 defendant Halsted John yeoman 589856 589856 Halsted, John, of Pakenham, yeoman 2
4412669 2168827 2168827 defendant Palfrey John   589856 589856 Palfrey, John, of Pakenham, wheelwright 0
4449048 2184646 2184646 defendant folkes Alexander   589856 589856 folkes, Alexander, of Pakenham 2
4449049 2184646 2184646 defendant Claketon John   589856 589856 Claketon, John, of Pakenham 3
4451868 2185562 2185562 defendant Fysshere William   589856 589856 Fysshere, William, of Pakenham 7
4451869 2185562 2185562 defendant Fysshere Richard   589856 589856 Fysshere, Richard, of Pakenham, son of William 8
4451871 2185562 2185562 defendant Ballard William   589856 589856 Ballard, William, of Pakenham 10
4467332 2190462 2190462 plaintiff atte Stretisende John clerk 589856 589856 atte Stretisende, John, of Pakenham, clerk 0
4533177 2210643 2210643 defendant Marleton Simon   589856 589856 Marleton, Simon, of Pakenham 2
4544934 2214335 2214335 plaintiff Beman Abel   589856 589856 Beman, Abel, of Pakenham 0
4544936 2214336 2214336 plaintiff Beman Abel   589856 589856 Beman, Abel, of Pakenham 0
4603022 2232157 2232157 defendant Contence John   589856 589856 Contence, John, of Pakenham, glass wright 0
4603023 2232157 2232157 defendant Contence William   589856 589856 Contence, William, of Pakenham, son of John 1
4668829 2255957 2255957 defendant Drake Edmund dyer 589856 589856 Drake, Edmund, of Pakenham, dyer 3
4687777 2261749 2261749 defendant Drake Edmund husbandman 589856 589856 Drake, Edmund, of Pakenham, husbandman 1
4692453 2263158 2263158 plaintiff atte Felde John   589856 589856 atte Felde, John, of Pakenham 0
4719172 2271344 2271344 defendant Fyssher John husbandman 589856 589856 Fyssher, John, of Pakenham, husbandman 0
4734800 2276040 2276040 plaintiff Sherwynd Robert   589856 589856 Sherwynd, Robert, of Pakenham 0
4734801 2276040 2276040 defendant Abell Robert chaplain 589856 589856 Abell, Robert, of Pakenham, chaplain 0
4734802 2276040 2276040 defendant Abell William husbandman 589856 589856 Abell, William, of Pakenham, husbandman 1
4740115 2277626 2277626 plaintiff atte Felde John (legal representative) 589856 589856 atte Felde, John, of Pakenham, executors of 0
4754588 2281817 2281817 defendant Pakenham John   589856 589856 Pakenham, John, of Pakenham, glass wright 0
4764044 2284743 2284743 defendant Pakenham John   589856 589856 Pakenham, John, of Pakenham, glass wright 1
4796874 2295179 2295179 defendant Abell Robert chaplain 589856 589856 Abell, Robert, of Pakenham, chaplain 1
4796875 2295179 2295179 defendant Abell William ploughman 589856 589856 Abell, William, of Pakenham, ploughman 2
4822095 2302988 2302988 defendant Prudde Henry husbandman 589856 589856 Prudde, Henry, of Pakenham, husbandman 0
4832337 2306146 2306146 defendant Burdon William miller 589856 589856 Burdon, William, of Pakenham, miller 0
4903127 2327591 2327591 defendant Spede John yeoman 589856 589856 Spede, John, of Pakenham, yeoman 6
4903129 2327591 2327591 defendant Fyston Thomas yeoman 589856 589856 Fyston, Thomas, of Pakenham, yeoman 8
4963925 2346121 2346121 defendant Taillour Robert tailor 589856 589856 Taillour, Robert, of Pakenham, tailor 1
4977019 2350081 2350081 defendant Martyn Alexander husbandman 589856 589856 Martyn, Alexander, of Pakenham, husbandman 0
4977020 2350081 2350081 defendant Creme John yeoman 589856 589856 Creme, John, of Pakenham, yeoman 1
4997922 2356237 2356237 defendant Cristeyn Thomas mlller 589856 589856 Cristeyn, Thomas, of Pakenham, mlller 0
5005708 2358565 2358565 defendant Doket John husbandman 589856 589856 Doket, John, of Pakenham, husbandman 1
5005709 2358565 2358565 defendant Seymor John husbandman 589856 589856 Seymor, John, of Pakenham, husbandman 2
5007152 2358980 2358980 defendant Lamberd John clerk 589856 589856 Lamberd, John, of Pakenham, clerk 0
5009116 2359548 2359548 defendant Rous John husbandman 589856 589856 Rous, John, of Pakenham, husbandman 0
5009117 2359548 2359548 defendant Taverham Robert husbandman 589856 589856 Taverham, Robert, of Pakenham, husbandman 1
5009118 2359548 2359548 defendant Shirwynd Robert husbandman 589856 589856 Shirwynd, Robert, of Pakenham, husbandman 2
5010639 2359982 2359982 defendant Hert William   589856 589856 Hert, William, of Pakenham, wright 2
5013551 2360804 2360804 defendant Creme John yeoman 589856 589856 Creme, John, of Pakenham, yeoman 2
5013574 2360813 2360813 defendant Taverham Robert husbandman 589856 589856 Taverham, Robert, of Pakenham, husbandman 1
5013575 2360813 2360813 defendant Holder John husbandman 589856 589856 Holder, John, of Pakenham, husbandman 2
5053110 2372525 2372525 defendant Fyston Thomas husbandman 589856 589856 Fyston, Thomas, of Pakenham, husbandman 0
5053111 2372525 2372525 defendant Sneth John husbandman 589856 589856 Sneth, John, of Pakenham, husbandman 1
5073061 2378427 2378427 defendant Russell John   589856 589856 Russell, John, of Pakenham, shepherd 4
5076349 2379428 2379428 defendant Shirwyn John laborer 589856 589856 Shirwyn, John, of Pakenham, laborer 4
5077547 2379783 2379783 defendant Wynde John   589856 589856 Wynde, John, of Pakenham, yeoman, son of Henry 1
5096703 2385472 2385472 defendant Horn John husbandman 589856 589856 Horn, John, of Pakenham, husbandman 3
5116216 2391171 2391171 defendant Wynde John husbandman 589856 589856 Wynde, John, of Pakenham, husbandman 0
5118225 2391770 2391770 defendant Wynde John yeoman 589856 589856 Wynde, John, of Pakenham, yeoman 4
5118646 2391885 2391885 plaintiff Rous John gent 589856 589856 Rous, John, of Pakenham, gent 0
5118651 2391886 2391886 plaintiff Rous John   589856 589856 Rous, John, of Pakenham 0
5249961 2430098 2430098 defendant Lore John laborer 589856 589856 Lore, John, of Pakenham, laborer 0
5266587 2435300 2435300 defendant Fysshe John carpenter 589856 589856 Fysshe, John, of Pakenham, carpenter 2
5266588 2435300 2435300 defendant Fyssher Thomas carpenter 589856 589856 Fyssher, Thomas, of Pakenham, carpenter 3
5266590 2435301 2435301 defendant Pecok John husbandman 589856 589856 Pecok, John, of Pakenham, husbandman 0
5266591 2435301 2435301 defendant Peg John husbandman 589856 589856 Peg, John, of Pakenham, husbandman 1
5281172 2439568 2439568 defendant Rous John (legal representative) 589856 589856 Rous, John, of Pakenham, gent, executor of 2
5289401 2441902 2441902 defendant Pryour John yeoman 589856 589856 Pryour, John, of Pakenham, yeoman 0
5297689 2444330 2444330 defendant Pegge Robert husbandman 589856 589856 Pegge, Robert, of Pakenham, husbandman 0
5297690 2444330 2444330 defendant Pegge John husbandman 589856 589856 Pegge, John, of Pakenham, husbandman 1
5300718 2445178 2445178 defendant Rous John (legal representative) 589856 589856 Rous, John, of Pakenham, gent, executor of 0
5318390 2450595 2450595 defendant Pakenham Richard husbandman 589856 589856 Pakenham, Richard, of Pakenham, husbandman 0
5340405 2457200 2457200 defendant Goodson John clerk 589856 589856 Goodson, John, of Pakenham, clerk 4
5348372 2459634 2459634 defendant Roose Thomas husbandman 589856 589856 Roose, Thomas, of Pakenham, husbandman 0
5356990 2462248 2462248 defendant Master Thomas husbandman 589856 589856 Master, Thomas, of Pakenham, husbandman 0
5450249 2489958 2489958 defendant Rose Thomas husbandman 589856 589856 Rose, Thomas, of Pakenham, husbandman 4

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