names

171 rows where place_id = 588590

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595006 1866069 1866069 defendant Cokayn John esq 588590 588590 Cokayn, John, of Assheburn, esq 0
3601670 1868178 1868178 defendant Cokayn John, senior   588590 588590 Cokayn, John, senior, of Assheburn, Derbsm esq 0
3601674 1868179 1868179 defendant Cokayn John, senior   588590 588590 Cokayn, John, senior, of Assheburn, Derbsm esq 0
3601677 1868180 1868180 defendant Cokayn John, senior esq 588590 588590 Cokayn, John, senior, of Assheburn, esq 0
3602810 1868548 1868548 defendant Carter John chapman 588590 588590 Carter, John, of Assheburn, chapman 1
3602832 1868555 1868555 defendant Carter John chapman 588590 588590 Carter, John, of Assheburn, chapman 2
3729821 1935582 1935582 defendant Derby Nicholas glover 588590 588590 Derby, Nicholas, of Assheburn, glover 4
3737492 1937968 1937968 defendant Wright William glover 588590 588590 Wright, William, of Assheburn, glover 0
3797512 1957114 1957114 defendant Hurtt Thomas   588590 588590 Hurtt, Thomas, of Assheburn 0
3797513 1957114 1957114 defendant Hurtt Christopher   588590 588590 Hurtt, Christopher, of Assheburn 1
3935434 2002163 2002163 defendant Holles Richard glover 588590 588590 Holles, Richard, of Assheburn, glover 1
3935435 2002163 2002163 defendant Holles Robert glover 588590 588590 Holles, Robert, of Assheburn, glover 2
3935436 2002163 2002163 defendant Smyth Humphrey tanner 588590 588590 Smyth, Humphrey, of Assheburn, tanner 3
4022683 2032836 2032836 defendant Lakyn William yeoman 588590 588590 Lakyn, William, of Assheburn, yeoman 1
4482316 2195172 2195172 plaintiff Melton William de   588590 588590 Melton, William de, of Assheburn, vicar 0
4484629 2195889 2195889 defendant atte Yate William   588590 588590 atte Yate, William, of Assheburn 0
4484630 2195889 2195889 defendant Lemystre Nicholas   588590 588590 Lemystre, Nicholas, of Assheburn 1
4484632 2195889 2195889 defendant Balydon John   588590 588590 Balydon, John, of Assheburn 3
4484633 2195889 2195889 defendant Holand John de   588590 588590 Holand, John de, of Assheburn 4
4484634 2195889 2195889 defendant Spicer Richard   588590 588590 Spicer, Richard, of Assheburn 5
4488340 2197072 2197072 plaintiff Stere Henry   588590 588590 Stere, Henry, of Assheburn 0
4495200 2199182 2199182 defendant Hewester John   588590 588590 Hewester, John, of Assheburn 1
4497516 2199866 2199866 defendant Spicer John   588590 588590 Spicer, John, of Assheburn 0
4512375 2204313 2204313 defendant Stones John de   588590 588590 Stones, John de, of Assheburn 0
4518259 2206085 2206085 defendant atte Zate William   588590 588590 atte Zate, William, of Assheburn 0
4518845 2206259 2206259 defendant Spicer Richard   588590 588590 Spicer, Richard, of Assheburn 0
4521835 2207165 2207165 defendant Clyfton Nicholas de   588590 588590 Clyfton, Nicholas de, of Assheburn 0
4555221 2217569 2217569 defendant Noteman John   588590 588590 Noteman, John, of Assheburn 1
4557789 2218365 2218365 defendant Ryddyng John   588590 588590 Ryddyng, John, of Assheburn, parchment maker 0
4558639 2218655 2218655 defendant Noteman John   588590 588590 Noteman, John, of Assheburn 0
4562670 2219883 2219883 defendant Lynster Nicholas   588590 588590 Lynster, Nicholas, of Assheburn 0
4579855 2225185 2225185 defendant Chaloner Robert   588590 588590 Chaloner, Robert, of Assheburn 0
4579857 2225186 2225186 defendant Chaloner Robert   588590 588590 Chaloner, Robert, of Assheburn 0
4604850 2232689 2232689 defendant Page William   588590 588590 Page, William, of Assheburn 0
4613669 2235287 2235287 defendant Glover Robert   588590 588590 Glover, Robert, of Assheburn 0
4640463 2243322 2243322 defendant Alsop Henry   588590 588590 Alsop, Henry, of Assheburn 7
4640556 2243345 2243345 defendant Oldhale John   588590 588590 Oldhale, John, of Assheburn 2
4640928 2243445 2243445 defendant Cowedraye John   588590 588590 Cowedraye, John, of Assheburn 0
4643603 2244231 2244231 defendant Stere Henry   588590 588590 Stere, Henry, of Assheburn 0
4645134 2244646 2244646 defendant Glover William   588590 588590 Glover, William, of Assheburn 3
4661837 2249549 2249549 plaintiff Maister Roger   588590 588590 (Maister, Roger, of Assheburn 1
4680778 2259607 2259607 defendant Chaloner John collier 588590 588590 Chaloner, John, of Assheburn, collier 0
4726840 2273663 2273663 defendant Ruddyng John   588590 588590 Ruddyng, John, of Assheburn, parchment maker 0
4726841 2273663 2273663 defendant Gyles Ralph weaver 588590 588590 Gyles, Ralph, of Assheburn, weaver 1
4732889 2275464 2275464 defendant Hygynson John cutler 588590 588590 Hygynson, John, of Assheburn, cutler 1
4755803 2282197 2282197 plaintiff Barker John   588590 588590 Barker, John, of Assheburn 0
4755805 2282198 2282198 plaintiff Barker John   588590 588590 Barker, John, of Assheburn 0
4768670 2286178 2286178 defendant Both John yeoman 588590 588590 (Both, John, of Assheburn, yeoman 1
4768672 2286178 2286178 defendant Morley John yeoman 588590 588590 Morley, John, of Assheburn, yeoman 3
4768675 2286179 2286179 defendant Bagger John butcher 588590 588590 Bagger, John, of Assheburn, butcher 0
4768676 2286179 2286179 defendant Bretoner Robert mercer 588590 588590 together with Bretoner, Robert, of Assheburn, mercer 1
4768678 2286180 2286180 defendant Bretoner Robert mercer 588590 588590 Bretoner, Robert, of Assheburn, mercer 0
4791549 2293450 2293450 defendant Loksmyth Robert husbandman 588590 588590 Loksmyth, Robert, of Assheburn, husbandman 1
4792854 2293855 2293855 defendant Bretoner Robert mercer 588590 588590 Bretoner, Robert, of Assheburn, mercer 0
4807466 2298528 2298528 defendant Malefeld Richard yeoman 588590 588590 Malefeld, Richard, of Assheburn, yeoman 1
4809170 2299046 2299046 defendant Malefeld Richard yeoman 588590 588590 Malefeld, Richard, of Assheburn, yeoman 0
4815527 2300962 2300962 defendant Welbek Richard merchant 588590 588590 Welbek, Richard, of Assheburn, merchant 1
4816424 2301230 2301230 defendant Heureson Henry husbandman 588590 588590 Heureson, Henry, of Assheburn, husbandman 0
4816443 2301233 2301233 defendant Parker John farrier 588590 588590 Parker, John, of Assheburn, farrier 3
4839038 2308138 2308138 defendant Parfey John yeoman 588590 588590 Parfey, John, of Assheburn, yeoman 1
4843043 2309359 2309359 defendant Troche John yeoman 588590 588590 Troche, John, of Assheburn, yeoman 0
4843230 2309402 2309402 defendant Malefeld Richard yeoman 588590 588590 Malefeld, Richard, of Assheburn, yeoman 6
4843231 2309402 2309402 defendant Bate William yeoman 588590 588590 Bate, William, of Assheburn, yeoman 7
4864045 2315730 2315730 defendant Payntour Thomas yeoman 588590 588590 Payntour, Thomas, of Assheburn, yeoman 0
4864048 2315731 2315731 defendant Payntour Thomas yeoman 588590 588590 Payntour, Thomas, of Assheburn, yeoman 0
4865370 2316137 2316137 defendant Peynter Thomas yeoman 588590 588590 Peynter, Thomas, of Assheburn, yeoman 0
4870507 2317749 2317749 defendant Trowelegh Robert laborer 588590 588590 Trowelegh, Robert, of Assheburn, laborer 0
4873250 2318585 2318585 defendant Cawedray William cutler 588590 588590 Cawedray, William, of Assheburn, cutler 2
4873251 2318585 2318585 defendant Aleyn John husbandman 588590 588590 Aleyn, John, of Assheburn, husbandman 3
4881357 2321074 2321074 defendant Bate John yeoman 588590 588590 Bate, John, of Assheburn, yeoman 0
4891257 2323996 2323996 defendant Conhoippe or Couhoppe Roger walker 588590 588590 Conhoippe or Couhoppe, Roger, of Assheburn, walker 6
4891258 2323996 2323996 defendant Punt William cordwainer 588590 588590 Punt, William, of Assheburn, cordwainer 7
4891259 2323996 2323996 defendant Elysson John miller 588590 588590 Elysson, John, of Assheburn, miller 8
4891260 2323996 2323996 defendant Clounham John butcher 588590 588590 Clounham, John, of Assheburn, butcher 9
4924605 2334131 2334131 defendant Bate John yeoman 588590 588590 Bate, John, of Assheburn, yeoman 3
4936285 2337749 2337749 defendant Cokayn Isabel widow 588590 588590 Cokayn, Isabel, of Assheburn, widow 2
4940222 2338973 2338973 defendant Forest John cordwainer 588590 588590 Forest, John, of Assheburn, cordwainer 0
4940223 2338973 2338973 defendant Clerk William cordwainer 588590 588590 Clerk, William, of Assheburn, cordwainer 1
4940451 2339038 2339038 defendant Barlowe John yeoman 588590 588590 Barlowe, John, of Assheburn, yeoman 0
4948238 2341424 2341424 defendant Bate John yeoman 588590 588590 Bate, John, of Assheburn, yeoman 1
4954273 2343250 2343250 defendant Elton John, junior yeoman 588590 588590 Elton, John, junior, of Assheburn, yeoman 1
4961683 2345459 2345459 defendant Cokayn John (legal representative) 588590 588590 Cokayn, John, of Assheburn, knight, administratrix of 1
4961684 2345459 2345459 defendant Cokayn Isabel widow 588590 588590 Cokayn, Isabel, of Assheburn, widow 2
4998769 2356520 2356520 defendant Heyward John baker 588590 588590 Heyward, John, of Assheburn, baker 0
4998770 2356520 2356520 defendant Coulroppe Roger walker 588590 588590 Coulroppe, Roger, of Assheburn, walker 1
5000537 2357028 2357028 defendant Payntour Thomas yeoman 588590 588590 Payntour, Thomas, of Assheburn, yeoman 0
5006648 2358845 2358845 defendant Bate John yeoman 588590 588590 Bate, John, of Assheburn, yeoman 0
5006649 2358845 2358845 defendant Coken John esq 588590 588590 Coken, John, of Assheburn, esq 1
5006650 2358845 2358845 defendant Verun Thurstan esq 588590 588590 Verun, Thurstan, of Assheburn, esq 2
5006651 2358845 2358845 defendant Godeale John yeoman 588590 588590 Godeale, John, of Assheburn, yeoman 3
5006653 2358845 2358845 defendant Derby Nichoals   588590 588590 Derby, Nichoals, of Assheburn, glove maker 5
5006654 2358845 2358845 defendant Fricer Thomas fricer 588590 588590 Fricer, Thomas, of Assheburn, fricer 6
5006655 2358845 2358845 defendant Dunton John weaver 588590 588590 Dunton, John, of Assheburn, weaver 7
5006656 2358845 2358845 defendant Bayle John yeoman 588590 588590 Bayle, John,of Assheburn, yeoman 8
5006657 2358845 2358845 defendant Brendwode Robert yeoman 588590 588590 Brendwode, Robert, of Assheburn, yeoman 9
5006658 2358845 2358845 defendant Damport Thomas mercer 588590 588590 Damport, Thomas, of Assheburn, mercer 10
5006659 2358845 2358845 defendant Coke John yeoman 588590 588590 Coke, John, of Assheburn, yeoman 11
5006661 2358845 2358845 defendant Derby William   588590 588590 Derby, William, of Assheburn, glove maker 13
5067276 2376723 2376723 defendant Crokker Nicholas yeoman 588590 588590 Crokker, Nicholas, of Assheburn, yeoman 4
5067302 2376728 2376728 defendant Elton William butcher 588590 588590 Elton, William, of Assheburn, butcher 3

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