names

90 rows where place_id = 601885

✎ 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
3647445 1909590 1909590 defendant Leygh William gent 601885 601885 Leygh, William, of Holdesworthy, gent 0
3652247 1911042 1911042 defendant Flayer Richard gent 601885 601885 Flayer, Richard, of Holdesworthy, gent 0
3674317 1918012 1918012 defendant Yeo Richard husbandman 601885 601885 Yeo, Richard, of Holdesworthy, husbandman 0
3766538 1947192 1947192 plaintiff Martyn Thomas tanner 601885 601885 Martyn, Thomas, of Holdesworthy, tanner 0
3850162 1973640 1973640 defendant Brom Richard husbandman 601885 601885 Brom, Richard, of Holdesworthy, husbandman 1
3943584 2004874 2004874 plaintiff Arscott Thomas (legal representative) 601885 601885 Arscott, Thomas, of Holdesworthy, executors of 0
3943589 2004875 2004875 plaintiff Arscott Thomas (legal representative) 601885 601885 Arscott, Thomas, of Holdesworthy, executors of 0
3964414 2012158 2012158 defendant Robyn John husbandman 601885 601885 Robyn, John, of Holdesworthy, husbandman 0
4047479 2041550 2041550 defendant Bowerman William husbandman 601885 601885 Bowerman, William, of Holdesworthy, husbandman 0
4587137 2227381 2227381 defendant Asshecote Richard   601885 601885 Asshecote, Richard, of Holdesworthy 0
4623026 2238178 2238178 defendant Rydon Alan   601885 601885 Rydon, Alan, of Holdesworthy 0
4657429 2248215 2248215 defendant Goddnowe William fisher 601885 601885 Goddnowe, William, of Holdesworthy, fisher 0
4666098 2250864 2250864 defendant Hege John butcher 601885 601885 Hege, John, of Holdesworthy, butcher 1
4666099 2250864 2250864 defendant Godynowe Thomas husbandman 601885 601885 Godynowe, Thomas, of Holdesworthy, husbandman 2
4689507 2262274 2262274 defendant Lake Richard husbandman 601885 601885 Lake, Richard, of Holdesworthy, husbandman 0
4771566 2287083 2287083 defendant Aryscot Richard chaplain 601885 601885 Aryscot, Richard, of Holdesworthy, chaplain 0
4796639 2295099 2295099 defendant Aryscot Richard chaplain 601885 601885 Aryscot, Richard, of Holdesworthy, chaplain 0
4866999 2316642 2316642 defendant Edward John chaplain 601885 601885 Edward, John, of Holdesworthy, chaplain 0
4871182 2317963 2317963 defendant Hamond Richard carpenter 601885 601885 Hamond, Richard, of Holdesworthy, carpenter 3
4889350 2323461 2323461 defendant Hayward Roger fisher 601885 601885 Hayward, Roger, of Holdesworthy, fisher 0
4920102 2332797 2332797 defendant Starie Richard husbandman 601885 601885 Starie, Richard, of Holdesworthy, husbandman 0
4920104 2332798 2332798 defendant Starye Richard husbandman 601885 601885 Starye, Richard, of Holdesworthy, husbandman 0
4942262 2339571 2339571 defendant Uggeworthy John gent 601885 601885 Uggeworthy, John, of Holdesworthy, gent 0
4945801 2340675 2340675 defendant Colyn John weaver 601885 601885 Colyn, John, of Holdesworthy, weaver 0
4948563 2341531 2341531 defendant Whyttyn Peter shoemaker 601885 601885 Whyttyn, Peter, of Holdesworthy, shoemaker 0
4948564 2341531 2341531 defendant Coby Denis shoemaker 601885 601885 Coby, Denis, of Holdesworthy, shoemaker 1
4954078 2343186 2343186 defendant Adam John shoemaker 601885 601885 Adam, John, of Holdesworthy, shoemaker 1
4954079 2343186 2343186 defendant Brayburd William singleman 601885 601885 Brayburd, William, of Holdesworthy, singleman 2
4954080 2343186 2343186 defendant Stone John laborer 601885 601885 Stone, John, of Holdesworthy, laborer 3
4954081 2343186 2343186 defendant Page John shoemaker 601885 601885 Page, John, of Holdesworthy, shoemaker 4
4977691 2350288 2350288 defendant Pylaton Walter husbandman 601885 601885 Pylaton, Walter, of Holdesworthy, husbandman 0
4992233 2354569 2354569 defendant Clerk William gent 601885 601885 (Clerk, William, of Holdesworthy, gent 1
4992234 2354569 2354569 defendant Welywrought Richard husbandman 601885 601885 Welywrought, Richard, of Holdesworthy, husbandman 2
4997195 2356014 2356014 defendant Averey Walter husbandman 601885 601885 Averey, Walter, of Holdesworthy, husbandman 0
5001984 2357480 2357480 defendant Clerk (illegible) husbandman 601885 601885 Clerk, _, of Holdesworthy, husbandman 0
5001988 2357481 2357481 defendant Clerk William husbandman 601885 601885 Clerk, William, of Holdesworthy, husbandman 0
5029815 2365594 2365594 defendant Pylaton John husbandman 601885 601885 Pylaton, John, of Holdesworthy, husbandman 2
5045760 2370367 2370367 defendant Bale Robert yeoman 601885 601885 Bale, Robert, of Holdesworthy, yeoman 2
5057904 2373935 2373935 defendant Blakemore John husbandman 601885 601885 Blakemore, John, of Holdesworthy, husbandman 1
5062723 2375407 2375407 defendant Welywrouth Richard yeoman 601885 601885 Welywrouth, Richard, of Holdesworthy, yeoman 1
5062724 2375407 2375407 defendant Hayward Roger fisher 601885 601885 Hayward, Roger, of Holdesworthy, fisher 2
5062725 2375407 2375407 defendant Wallyng William tanner 601885 601885 Wallyng, William, of Holdesworthy, tanner 3
5069405 2377344 2377344 defendant Walter Roger husbandman 601885 601885 Walter, Roger, of Holdesworthy, husbandman 0
5080089 2380529 2380529 defendant Clerk William gent 601885 601885 Clerk, William, of Holdesworthy, gent 0
5080481 2380652 2380652 defendant Scoche Richard chaplain 601885 601885 Scoche, Richard, of Holdesworthy, chaplain 2
5087077 2382600 2382600 defendant Welywrought Richard yeoman 601885 601885 Welywrought, Richard, of Holdesworthy, yeoman 1
5087078 2382600 2382600 defendant Hayward Roger fisher 601885 601885 Hayward, Roger, of Holdesworthy, fisher 2
5087079 2382600 2382600 defendant Wallyng William tanner 601885 601885 Wallyng, William, of Holdesworthy, tanner 3
5117954 2391678 2391678 defendant Coton John yeoman 601885 601885 Coton, John, of Holdesworthy, yeoman 0
5117955 2391678 2391678 defendant Adam John yeoman 601885 601885 Adam, John, of Holdesworthy, yeoman 1
5152830 2401967 2401967 defendant Clerk William gent 601885 601885 Clerk, William, of Holdesworthy, gent 0
5167141 2406124 2406124 plaintiff Clerk William   601885 601885 Clerk, William, of Holdesworthy 0
5170455 2407088 2407088 defendant Clerk William gent 601885 601885 Clerk, William, of Holdesworthy, gent 0
5182390 2410606 2410606 plaintiff Clerk William   601885 601885 Clerk, William, of Holdesworthy 0
5188190 2412260 2412260 defendant Clerk William gent 601885 601885 Clerk, William, of Holdesworthy, gent 0
5189861 2412780 2412780 defendant Skykerd Richard chaplain 601885 601885 Skykerd, Richard, of Holdesworthy, chaplain 0
5206688 2417693 2417693 defendant Skykerd Richard chaplain 601885 601885 Skykerd, Richard, of Holdesworthy, chaplain 0
5224541 2422846 2422846 defendant Coton John yeoman 601885 601885 Coton, John, of Holdesworthy, yeoman 0
5224542 2422846 2422846 defendant Adam John yeoman 601885 601885 Adam, John, of Holdesworthy, yeoman 1
5233705 2425446 2425446 defendant Cranbury Richard tanner 601885 601885 Cranbury, Richard, of Holdesworthy, tanner 0
5233708 2425446 2425446 defendant Jule John, senior husbandman 601885 601885 Jule, John, senior, of Holdesworthy, husbandman 3
5241955 2427844 2427844 defendant Yeo Thomas husbandman 601885 601885 Yeo, Thomas, of Holdesworthy, husbandman 1
5243606 2428324 2428324 defendant Yoldon William husbandman 601885 601885 Yoldon, William, of Holdesworthy, husbandman 0
5305742 2446731 2446731 plaintiff Lygh Joan   601885 601885 Lygh, Joan, of Holdesworthy, formerly wife of Thomas 0
5305750 2446733 2446733 plaintiff Lygh Joan   601885 601885 Lygh, Joan, of Holdesworthy, formerly wife of Thomas 1
5324215 2452330 2452330 defendant Smale Richard husbandman 601885 601885 Smale, Richard, of Holdesworthy, husbandman 0
5331771 2454583 2454583 defendant Stoteworthy John husbandman 601885 601885 together with Stoteworthy, John, of Holdesworthy, husbandman 1
5331773 2454584 2454584 defendant Stoteworthy John husbandman 601885 601885 Stoteworthy, John, of Holdesworthy, husbandman 0
5338908 2456748 2456748 defendant Aysshecote William chaplain 601885 601885 Aysshecote, William, of Holdesworthy, chaplain 0
5360019 2463171 2463171 defendant Smale Richard drover 601885 601885 Smale, Richard, of Holdesworthy, drover 0
5362842 2464022 2464022 defendant Smale Richard husbandman 601885 601885 Smale, Richard, of Holdesworthy, husbandman 0
5373591 2467340 2467340 defendant Mathewe William fisher 601885 601885 Mathewe, William, of Holdesworthy, fisher 0
5418010 2480312 2480312 defendant Jule John tanner 601885 601885 Jule, John, of Holdesworthy, tanner 0
5418011 2480312 2480312 defendant Wallond John tanner 601885 601885 Wallond, John, of Holdesworthy, tanner 1
5481267 2499343 2499343 defendant Wallen John tanner 601885 601885 Wallen, John, of Holdesworthy, tanner 0
5488826 2501532 2501532 defendant Meryfeld Arnold yeoman 601885 601885 Meryfeld, Arnold, of Holdesworthy, yeoman 2
5488829 2501532 2501532 defendant Page John yeoman 601885 601885 Page, John, of Holdesworthy, yeoman 5
5489056 2501603 2501603 defendant Page John husbandman 601885 601885 Page, John, of Holdesworthy, husbandman 0
5495386 2503521 2503521 defendant Lyghe Joan widow 601885 601885 Lyghe, Joan, of Holdesworthy, widow 0
5496174 2503752 2503752 defendant Barnard John currier 601885 601885 Barnard, John, of Holdesworthy, currier 0
5496176 2503753 2503753 defendant Donne or Doune John currier 601885 601885 Donne or Doune, John, of Holdesworthy, currier 0
5498071 2504364 2504364 defendant Bernard John currier 601885 601885 Bernard, John, of Holdesworthy, currier 0
5498072 2504364 2504364 defendant Donne John currier 601885 601885 Donne, John, of Holdesworthy, currier 1
5510893 2508247 2508247 defendant Page John husbandman 601885 601885 Page, John, of Holdesworthy, husbandman 0
5511215 2508350 2508350 defendant Barnard John currier 601885 601885 Barnard, John, of Holdesworthy, currier 0
5511217 2508351 2508351 defendant Donne or Doune John currier 601885 601885 Donne or Doune, John, of Holdesworthy, currier 0
5540661 2517208 2517208 defendant Martyn William tanner 601885 601885 Martyn, William, of Holdesworthy, tanner 0
5547880 2519400 2519400 defendant Thorn Henry gent 601885 601885 Thorn, Henry, of Holdesworthy, gent 0
5584151 2530115 2530115 defendant Chapman Mark husbandman 601885 601885 Chapman, Mark, of Holdesworthy, husbandman 0
5584154 2530115 2530115 defendant Yeo Richard husbandman 601885 601885 Yeo, Richard, of Holdesworthy, husbandman 3

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