names

109 rows where place_id = 601002

✎ 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
3643501 1908397 1908397 defendant Wakefeld Nicholas husbandman 601002 601002 Wakefeld, Nicholas, of Ikelyngton, husbandman 0
3644864 1908804 1908804 defendant Reymond Thomas laborer 601002 601002 Reymond, Thomas, of Ikelyngton, laborer 0
3644865 1908804 1908804 defendant Atkynson Thomas husbandman 601002 601002 Atkynson, Thomas, of Ikelyngton, husbandman 1
3752823 1942808 1942808 defendant Keye William butcher 601002 601002 Keye, William, of Ikelyngton, butcher 0
3901733 1990803 1990803 defendant Batysford William laborer 601002 601002 Batysford, William, of Ikelyngton, laborer 0
3901735 1990803 1990803 defendant Whytyng William husbandman 601002 601002 Whytyng, William, of Ikelyngton, husbandman 2
4448645 2184508 2184508 defendant Houresere of Hourefere Richard   601002 601002 Houresere of Hourefere, Richard, of Ikelyngton 0
4671762 2256815 2256815 defendant Kyng William shoemaker 601002 601002 Kyng, William, of Ikelyngton, shoemaker 0
4671764 2256815 2256815 defendant Andrewe Thomas husbandman 601002 601002 Andrewe, Thomas, of Ikelyngton, husbandman 2
4671765 2256815 2256815 defendant Skrevener John husbandman 601002 601002 Skrevener, John, of Ikelyngton,husbandman 3
4671766 2256815 2256815 defendant Whytytng John husbandman 601002 601002 Whytytng, John, of Ikelyngton, husbandman 4
4673467 2257339 2257339 defendant Paynot Thomas husbandman 601002 601002 Paynot, Thomas, of Ikelyngton, husbandman 1
4731290 2274986 2274986 defendant Pye John miller 601002 601002 Pye, John, of Ikelyngton, miller 1
4731294 2274987 2274987 defendant Pye John miller 601002 601002 Pye, John, of Ikelyngton, miller 1
4731295 2274987 2274987 defendant Smyth John smith 601002 601002 Smyth, John, of Ikelyngton, smith 2
4759123 2283201 2283201 plaintiff Sawyere Thomas   601002 601002 Sawyere, Thomas, of Ikelyngton 1
4759124 2283201 2283201 defendant Fullere John fuller 601002 601002 Fullere, John, of Ikelyngton, fuller 0
4759126 2283202 2283202 plaintiff Sawyere Thomas   601002 601002 Sawyere, Thomas, of Ikelyngton 1
4762588 2284278 2284278 defendant Russell James husbandman 601002 601002 Russell, James, of Ikelyngton, husbandman 0
4762589 2284278 2284278 defendant Style William chaplain 601002 601002 Style, William, of Ikelyngton, chaplain 1
4780448 2289883 2289883 defendant Russell James   601002 601002 Russell, James, of Ikelyngton, franklin 0
4792221 2293657 2293657 defendant Baker Thomas baker 601002 601002 Baker, Thomas, of Ikelyngton, baker 0
4797029 2295233 2295233 defendant Dalygod John husbandman 601002 601002 Dalygod, John, of Ikelyngton, husbandman 0
4805721 2297999 2297999 defendant Russell James   601002 601002 Russell, James, of Ikelyngton, franklin 0
4825481 2304015 2304015 defendant Russell James yeoman 601002 601002 Russell, James, of Ikelyngton, yeoman 0
4833305 2306426 2306426 defendant Dabygood Edmund laborer 601002 601002 Dabygood, Edmund, of Ikelyngton, laborer 0
4837475 2307656 2307656 defendant Pye John miller 601002 601002 Pye, John, of Ikelyngton, miller 0
4867004 2316644 2316644 defendant Casbolt John   601002 601002 Casbolt, John, of Ikelyngton, tallow chandler 0
4867005 2316644 2316644 defendant Hayward Joan widow 601002 601002 Hayward, Joan, of Ikelyngton, widow 1
4867007 2316645 2316645 defendant Casbolt John   601002 601002 Casbolt, John, of Ikelyngton, tallow chandler 0
4867008 2316645 2316645 defendant Hayward Joan widow 601002 601002 Hayward, Joan, of Ikelyngton, widow 1
4867334 2316748 2316748 defendant Heyward Richard husbandman 601002 601002 Heyward, Richard, of Ikelyngton, husbandman 0
4867335 2316748 2316748 defendant Roge Edmund husbandman 601002 601002 Roge, Edmund, of Ikelyngton, husbandman 1
4870019 2317588 2317588 defendant Frensh John husbandman 601002 601002 Frensh, John, of Ikelyngton, husbandman 1
4890744 2323855 2323855 defendant Upforth alias Swan Thomas butcher 601002 601002 Upforth alias Swan, Thomas, of Ikelyngton, butcher 0
4897137 2325761 2325761 defendant Sawyer Thomas cordwainer 601002 601002 Sawyer, Thomas, of Ikelyngton, cordwainer 0
4901807 2327171 2327171 defendant Sawyere Thomas cordwainer 601002 601002 Sawyere, Thomas, of Ikelyngton, cordwainer 0
4903366 2327661 2327661 defendant Sawyer Thomas cordwainer 601002 601002 Sawyer, Thomas, of Ikelyngton, cordwainer 0
4906110 2328504 2328504 defendant Heyward Joan widow 601002 601002 Heyward, Joan, of Ikelyngton, widow 0
4906122 2328507 2328507 defendant Russell James gent 601002 601002 Russell, James, of Ikelyngton, gent 0
4906123 2328507 2328507 defendant Frensshe John chapman 601002 601002 Frensshe, John, of Ikelyngton, chapman 1
4916448 2331645 2331645 defendant Mutforth Thomas chapman 601002 601002 Mutforth, Thomas, of Ikelyngton, chapman 0
4932499 2336558 2336558 defendant Fuller Thomas husbandman 601002 601002 Fuller, Thomas, of Ikelyngton, husbandman 2
4934790 2337279 2337279 defendant Casebolt John chandler 601002 601002 Casebolt, John, of Ikelyngton, chandler 1
4934791 2337279 2337279 defendant Candelestyk Henry   601002 601002 Candelestyk, Henry, of Ikelyngton, servant 2
4937068 2337965 2337965 defendant Englissh John yeoman 601002 601002 Englissh, John, of Ikelyngton, yeoman 1
4938612 2338461 2338461 defendant Frenssh John fishmonger 601002 601002 Frenssh, John, of Ikelyngton, fishmonger 1
4949391 2341796 2341796 defendant Knolles Alice   601002 601002 Knolles, Alice, of Ikelyngton, widow of Knolles, Robert 0
4950254 2342045 2342045 defendant Chapman John husbandman 601002 601002 Chapman, John, of Ikelyngton, husbandman 0
4950263 2342048 2342048 defendant Chapman John shoemaker 601002 601002 Chapman, John, of Ikelyngton, shoemaker 0
4951771 2342506 2342506 defendant Greneway John weaver 601002 601002 Greneway, John, of Ikelyngton, weaver 1
4962921 2345826 2345826 defendant Gale Thomas carpenter 601002 601002 Gale, Thomas, of Ikelyngton, carpenter 0
4983094 2351847 2351847 defendant Daligood Edmund   601002 601002 Daligood, Edmund, of Ikelyngton, shepherd 0
4983096 2351848 2351848 defendant Miller John husbandman 601002 601002 Miller, John, of Ikelyngton, husbandman 0
4983723 2352059 2352059 defendant Bramson John husbandman 601002 601002 Bramson, John, of Ikelyngton, husbandman 0
4983724 2352059 2352059 defendant Heyward Richard husbandman 601002 601002 Heyward, Richard, of Ikelyngton, husbandman 1
4983725 2352059 2352059 defendant Chapman William husbandman 601002 601002 Chapman, William, of Ikelyngton, husbandman 2
4983726 2352059 2352059 defendant Chapman John husbandman 601002 601002 Chapman, John, of Ikelyngton, husbandman 3
4983727 2352059 2352059 defendant Casbolt John husbandman 601002 601002 Casbolt, John, of Ikelyngton, husbandman 4
4989006 2353648 2353648 defendant Brabson Thomas butcher 601002 601002 Brabson, Thomas, of Ikelyngton, butcher 0
4989458 2353782 2353782 defendant Loughton John   601002 601002 Loughton, John, of Ikelyngton, servant 0
4989459 2353783 2353783 plaintiff Burnham John   601002 601002 Burnham, John, of Ikelyngton 0
4989462 2353783 2353783 defendant Mutford Geoffrey syneker or die-sinker 601002 601002 Mutford, Geoffrey, of Ikelyngton, syneker or die-sinker 2
4991414 2354318 2354318 defendant Lyon Alexander husbandman 601002 601002 Lyon, Alexander, of Ikelyngton, husbandman 1
4991415 2354318 2354318 defendant Mutteford Geoffrey husbandman 601002 601002 Mutteford, Geoffrey, of Ikelyngton, husbandman 2
4991420 2354318 2354318 defendant Edon John husbandman 601002 601002 Edon, John, of Ikelyngton, husbandman 7
4993571 2354950 2354950 defendant Munde John husbandman 601002 601002 Munde, John, of Ikelyngton, husbandman 0
4993573 2354951 2354951 defendant Grene Paul (legal representative) 601002 601002 Grene, Paul, of Ikelyngton, formerly vicar, administratrix of 0
4993576 2354952 2354952 defendant Munde John (legal representative) 601002 601002 Munde, John, of Ikelyngton, butcher, executors of 0
4993577 2354952 2354952 defendant Munde John husbandman 601002 601002 (Munde, John, of Ikelyngton, husbandman 1
4993578 2354952 2354952 defendant Munde Joan widow 601002 601002 Munde, Joan, of Ikelyngton, widow 2
4994881 2355321 2355321 defendant Dasshe Thomas husbandman 601002 601002 Dasshe, Thomas, of Ikelyngton, husbandman 1
4994882 2355321 2355321 defendant Undirwode John husbandman 601002 601002 Undirwode, John, of Ikelyngton, husbandman 2
4997005 2355957 2355957 defendant Faukes John husbandman 601002 601002 Faukes, John, of Ikelyngton, husbandman 0
4997006 2355957 2355957 defendant Canstyk John   601002 601002 Canstyk, John, of Ikelyngton, servant 1
4997007 2355957 2355957 defendant Perkyn John   601002 601002 Perkyn, John, of Ikelyngton, servant 2
4997008 2355957 2355957 defendant Loughton Thomas husbandman 601002 601002 Loughton, Thomas, of Ikelyngton, husbandman 3
5011913 2360336 2360336 defendant Brabbeson Thomas   601002 601002 Brabbeson, Thomas, of Ikelyngton 0
5037427 2367817 2367817 defendant Mutford Thomas husbandman 601002 601002 Mutford, Thomas, of Ikelyngton, husbandman 1
5082904 2381390 2381390 defendant Burnham John yeoman 601002 601002 Burnham, John, of Ikelyngton, yeoman 0
5100091 2386464 2386464 defendant Dalygood John   601002 601002 Dalygood, John, of Ikelyngton, brewer, his son 1
5100094 2386465 2386465 defendant Dalygood John   601002 601002 Dalygood, John, of Ikelyngton, brewer, his son 1
5109643 2389249 2389249 defendant Branson Thomas husbandman 601002 601002 Branson, Thomas, of Ikelyngton, husbandman 3
5143596 2399264 2399264 defendant Munde John yeoman 601002 601002 Munde, John, of Ikelyngton, yeoman 0
5143597 2399264 2399264 defendant Fuller John husbandman 601002 601002 Fuller, John, of Ikelyngton, husbandman 1
5143617 2399268 2399268 defendant Munde John yeoman 601002 601002 Munde, John, of Ikelyngton, yeoman 0
5143618 2399268 2399268 defendant Fuller John husbandman 601002 601002 Fuller, John, of Ikelyngton, husbandman 1
5186842 2411896 2411896 defendant Brabson Thomas husbandman 601002 601002 Brabson, Thomas, of Ikelyngton, husbandman 4
5205377 2417326 2417326 defendant Brabson Thomas husbandman 601002 601002 Brabson, Thomas, of Ikelyngton, husbandman 4
5229913 2424366 2424366 defendant Morehous John yeoman 601002 601002 Morehous, John, of Ikelyngton, yeoman 0
5240163 2427326 2427326 defendant Gerveys John   601002 601002 Gerveys, John, of Ikelyngton, shepherd 2
5240165 2427327 2427327 defendant Whityng John husbandman 601002 601002 Whityng, John, of Ikelyngton, husbandman 0
5247373 2429389 2429389 defendant Spycer John husbandman 601002 601002 Spycer, John, of Ikelyngton, husbandman 1
5247374 2429389 2429389 defendant Soper John cordwainer 601002 601002 Soper, John, of Ikelyngton, cordwainer 2
5247375 2429389 2429389 defendant Garder Thomas husbandman 601002 601002 Garder, Thomas, of Ikelyngton, husbandman 3
5247378 2429390 2429390 defendant Spycer John husbandman 601002 601002 Spycer, John, of Ikelyngton, husbandman 1
5247379 2429390 2429390 defendant Soper John cordwainer 601002 601002 Soper, John, of Ikelyngton, cordwainer 2
5248415 2429665 2429665 defendant Soper John yeoman 601002 601002 Soper, John, of Ikelyngton, yeoman 3
5248420 2429666 2429666 defendant Soper John yeoman 601002 601002 Soper, John, of Ikelyngton, yeoman 2
5261295 2433642 2433642 defendant Soper John yeoman 601002 601002 Soper, John, of Ikelyngton, yeoman 2

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