names

116 rows where place_id = 598601

✎ 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
3633262 1905220 1905220 plaintiff Kaylway John esq 598601 598601 Kaylway, John, of Columpton, esq 1
3633373 1905249 1905249 defendant Kent William   598601 598601 Kent, William, of Columpton, tailor, son of Kent, John, son of Kent, John, senior 0
3635795 1905996 1905996 defendant Davy John innholder 598601 598601 Davy, John, of Columpton, innholder 0
3639000 1907020 1907020 defendant Glover Walter husbandman 598601 598601 Glover, Walter, of Columpton, husbandman 1
3646564 1909326 1909326 defendant Broke John, senior husbandman 598601 598601 Broke, John, senior, of Columpton, husbandman 1
3687823 1922356 1922356 defendant Franke John butcher 598601 598601 Franke, John, of Columpton, butcher 0
3696248 1925048 1925048 defendant Kayleway John esq 598601 598601 Kayleway, John, of Columpton, esq 0
3710037 1929450 1929450 defendant Kalewey John gent 598601 598601 Kalewey, John, of Columpton, gent 0
3828458 1966774 1966774 defendant Amore John gent 598601 598601 Amore, John, of Columpton, gent 1
3851398 1974036 1974036 defendant Salter Henry yeoman 598601 598601 Salter, Henry, of Columpton, yeoman 0
3862172 1977534 1977534 defendant Fulforde James gent 598601 598601 Fulforde, James, of Columpton, gent 0
3874960 1981848 1981848 defendant Aubre William merchant 598601 598601 Aubre, William, of Columpton, merchant 0
3880528 1983745 1983745 defendant Facy Robert (legal representative) 598601 598601 Facy, Robert, of Columpton, merchant, executrix of 0
3880529 1983745 1983745 defendant Facy Joan widow 598601 598601 Facy, Joan, of Columpton, widow 1
3880534 1983746 1983746 defendant Facy Joan widow 598601 598601 Facy, Joan, of Columpton, widow 3
3893840 1988162 1988162 defendant More John gent 598601 598601 More, John, of Columpton, gent 0
3906357 1992411 1992411 defendant Kyth Benedict mercer 598601 598601 Kyth, Benedict, of Columpton, mercer 1
3932717 2001241 2001241 defendant Parrett John gent 598601 598601 Parrett, John, of Columpton, gent 0
3958614 2010085 2010085 plaintiff Rowlande Mary daughter of John More, gent 598601 598601 Mary his wife, daughter of John More, of Columpton, gent 1
3964988 2012361 2012361 plaintiff Ball William yeoman 598601 598601 Ball, William, of Columpton, yeoman 0
4026371 2034074 2034074 defendant Byckner Joan widow 598601 598601 Byckner, Joan, of Columpton, widow 1
4027933 2034641 2034641 plaintiff Cole Benedict or Bennet innholder 598601 598601 Cole, Benedict or Bennet, of Columpton, innholder 0
4027935 2034642 2034642 plaintiff Cole Benedict yeoman 598601 598601 Cole, Benedict, of Columpton, yeoman 0
4027937 2034643 2034643 plaintiff Cole Benedict yeoman 598601 598601 Cole, Benedict, of Columpton, yeoman 0
4042163 2039682 2039682 plaintiff Page William (legal representative) 598601 598601 Page, William, of Columpton, merchant, executors of 0
4130132 2071084 2071084 defendant Mawricke alias Bull Alexander merchant 598601 598601 Mawricke alias Bull, Alexander, of Columpton, merchant 2
4219104 2102178 2102178 defendant Norman John tailor 598601 598601 Norman, John, of Columpton, tailor 0
4262754 2117211 2117211 defendant Bale Walter fuller 598601 598601 Bale, Walter, of Columpton, fuller 0
4363657 2152072 2152072 defendant More Katherine widow 598601 598601 More, Katherine, of Columpton, or of Morehayse, Devon, widow 2
4393248 2162347 2162347 defendant Inglande William tailor 598601 598601 Inglande, William, of Columpton, tailor 0
4469418 2191097 2191097 defendant Spenser Richard   598601 598601 Spenser, Richard, of Columpton 0
4531280 2210060 2210060 defendant Shether John   598601 598601 Shether, John, of Columpton, son of John 0
4531285 2210061 2210061 defendant Shether John   598601 598601 Shether, John, of Columpton, son of John 0
4551551 2216422 2216422 defendant Payn William   598601 598601 Payn, William, of Columpton 0
4553252 2216948 2216948 defendant Payn William baker 598601 598601 Payn, William, of Columpton, baker 1
4575060 2223722 2223722 defendant Caproun Thomas   598601 598601 Caproun, Thomas, of Columpton 0
4590622 2228427 2228427 defendant Brys John   598601 598601 Brys, John, of Columpton 0
4650338 2246118 2246118 defendant Lymyngton John   598601 598601 Lymyngton, John, of Columpton 0
4685428 2261038 2261038 defendant Holbem Reginald shoemaker 598601 598601 Holbem, Reginald, of Columpton, shoemaker 1
4691120 2262742 2262742 defendant Ppurs John yeoman 598601 598601 Ppurs, John, of Columpton, yeoman 0
4692733 2263238 2263238 defendant atte Wyke William husbandman 598601 598601 atte Wyke, William, of Columpton, husbandman 0
4717544 2270822 2270822 defendant Paveley Simon gent 598601 598601 Paveley, Simon, of Columpton, gent 1
4727567 2273861 2273861 defendant Fyssacre John husbandman 598601 598601 Fyssacre, John, of Columpton, husbandman 1
4808369 2298796 2298796 defendant Lord Walter husbandman 598601 598601 Lord, Walter, of Columpton, husbandman 0
4841730 2308952 2308952 plaintiff Koc John   598601 598601 Koc, John, of Columpton 0
4893602 2324700 2324700 defendant Prideaux William shoemaker 598601 598601 Prideaux, William, of Columpton, shoemaker 0
4909331 2329460 2329460 defendant Lord Walter fuller 598601 598601 Lord, Walter, of Columpton, fuller 0
4926897 2334843 2334843 defendant Lord Walter fuller 598601 598601 Lord, Walter, of Columpton, fuller 0
5007789 2359173 2359173 defendant Undesdon Thomas brother of John Colyford 598601 598601 Undesdon, Thomas, of Columpton, gent, brother of John Colyford 1
5014499 2361102 2361102 defendant Counte Robert, junior husbandman 598601 598601 Counte, Robert, junior, of Columpton, husbandman 0
5040964 2368919 2368919 defendant More John gent 598601 598601 More, John, of Columpton, gent 4
5077554 2379785 2379785 defendant Sutter Gregory husbandman 598601 598601 Sutter, Gregory, of Columpton, husbandman 1
5079971 2380487 2380487 defendant Ibdon John husbandman 598601 598601 Ibdon, John, of Columpton, husbandman 1
5087414 2382696 2382696 defendant Garlond John husbandman 598601 598601 Garlond, John, of Columpton, husbandman 14
5098587 2386019 2386019 defendant Chave John tailor 598601 598601 Chave, John, of Columpton, tailor 2
5101534 2386863 2386863 defendant Neubury John mercer 598601 598601 Neubury, John, of Columpton, mercer 0
5115224 2390876 2390876 defendant Chave John tailor 598601 598601 Chave, John, of Columpton, tailor 0
5140616 2398364 2398364 defendant Underdoun John gent 598601 598601 Underdoun, John, of columpton, gent 1
5150392 2401248 2401248 defendant Colbroke Walter gent 598601 598601 Colbroke, Walter, of Columpton, gent 0
5155734 2402838 2402838 defendant Hert John smith 598601 598601 Hert, John, of Columpton, smith 0
5161542 2404474 2404474 defendant Newebery John mercer 598601 598601 Newebery, John, of Columpton, mercer 0
5172222 2407601 2407601 defendant Hert John smith 598601 598601 Hert, John, of Columpton, smith 0
5175918 2408638 2408638 defendant Newebery John mercer 598601 598601 Newebery, John, of Columpton, mercer 0
5210216 2418714 2418714 defendant Newebery John mercer 598601 598601 Newebery, John, of Columpton, mercer 0
5218950 2421268 2421268 defendant Collyng Robert husbndman 598601 598601 Collyng, Robert, of Columpton, husbndman 0
5222240 2422211 2422211 defendant Alysaunder Thomas dyer 598601 598601 Alysaunder, Thomas, of Columpton, dyer 0
5228030 2423808 2423808 plaintiff Vacy John butcher 598601 598601 Vacy, John, of Columpton, butcher 0
5229711 2424309 2424309 defendant Serell John smith 598601 598601 Serell, John, of Columpton, smith 0
5238483 2426845 2426845 defendant Neubury John chapman 598601 598601 Neubury, John, of Columpton, chapman 0
5246266 2429070 2429070 defendant Wythyn John husbandman 598601 598601 Wythyn, John, of Columpton, husbandman 1
5246639 2429177 2429177 defendant Hert John smith 598601 598601 Hert, John, of Columpton, smith 0
5250636 2430309 2430309 defendant Baker John baker 598601 598601 Baker, John, of Columpton, baker 0
5250637 2430309 2430309 defendant Baker William husbandman 598601 598601 Baker, William, of Columpton, husbandman 1
5258531 2432783 2432783 defendant Hert John smith 598601 598601 Hert, John, of Columpton, smith 0
5258532 2432783 2432783 defendant Stephyn John husbandman 598601 598601 Stephyn, John, of Columpton, husbandman 1
5261718 2433775 2433775 plaintiff More John (legal representative) 598601 598601 More, John, of Columpton, executor of atte Fenne, John, executors of 0
5264060 2434519 2434519 defendant Mate Robert yeoman 598601 598601 Mate, Robert, of Columpton, yeoman 0
5264129 2434540 2434540 defendant Oterham Stephen ostler 598601 598601 Oterham, Stephen, of Columpton, ostler 0
5280072 2439246 2439246 defendant Underdon John gent 598601 598601 Underdon, John, of Columpton, gent 0
5280336 2439329 2439329 defendant Walsshe John yeoman 598601 598601 Walsshe, John, of Columpton, yeoman 1
5297079 2444142 2444142 defendant Mate Robert yeoman 598601 598601 Mate, Robert, of Columpton, yeoman 2
5307276 2447179 2447179 defendant Hoiglond John yeoman 598601 598601 Hoiglond, John, of Columpton, yeoman 0
5312455 2448758 2448758 defendant Lake William hooper 598601 598601 Lake, William, of Columpton, hooper 0
5315570 2449723 2449723 defendant Clarys John dyer 598601 598601 Clarys, John, of Columpton, dyer 0
5328042 2453453 2453453 defendant Oteram Stephen yeoman 598601 598601 Oteram, Stephen, of Columpton, yeoman 0
5328047 2453455 2453455 defendant Baker William yeoman 598601 598601 Baker, William, of Columpton, yeoman 0
5339079 2456797 2456797 defendant William John   598601 598601 William, John, of Columpton, or of Exiland, Devon, yeoman, or dyer 1
5371930 2466809 2466809 defendant Robyns John   598601 598601 Robyns, John, of Columpton 0
5375563 2467946 2467946 defendant West John dyer 598601 598601 West, John, of Columpton, dyer 0
5378513 2468865 2468865 defendant Kynge Ralph mercer 598601 598601 (Kynge, Ralph, of Columpton, mercer 2
5378516 2468865 2468865 defendant Mogrigge Thomas fulller of cloth 598601 598601 Mogrigge, Thomas, of Columpton, fulller of cloth 5
5412554 2478699 2478699 plaintiff More John   598601 598601 More, John, of Columpton 2
5418989 2480606 2480606 defendant Roper Robert mercer 598601 598601 Roper, Robert, of Columpton, mercer 0
5419903 2480868 2480868 defendant Kynge John mercer 598601 598601 Kynge, John, of columpton, mercer 0
5423729 2482062 2482062 defendant Hoggelond John yeoman 598601 598601 Hoggelond, John, of Columpton, yeoman 0
5427387 2483135 2483135 plaintiff More John   598601 598601 More, John, of Columpton 2
5436144 2485748 2485748 plaintiff Roper Robert   598601 598601 Roper, Robert, of Columpton 0
5437182 2486058 2486058 defendant Roper Robert mercer 598601 598601 Roper, Robert, of Columpton, mercer 0
5453240 2490848 2490848 defendant Chanon William husbandman 598601 598601 Chanon, William, of Columpton, husbandman 0
5467463 2495207 2495207 defendant Hoggelond John yeoman 598601 598601 Hoggelond, John, of Columpton, 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);