names

85 rows where place_id = 586764

✎ 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
3589562 1864376 1864376 defendant Wanell or Wavell Robert yeoman 586764 586764 Wanell or Wavell, Robert, of Morton Hampstede, yeoman 0
3589563 1864376 1864376 defendant Houton or Honton John husbandman 586764 586764 Houton or Honton, John, of Morton Hampstede, husbandman 1
3590538 1864682 1864682 defendant Wanell or Wavell Robert husbandman 586764 586764 Wanell or Wavell, Robert, of Morton Hampstede, husbandman 0
3590540 1864683 1864683 defendant Wanell or Wavell Robert husbandman 586764 586764 Wanell or Wavell, Robert, of Morton Hampstede, husbandman 0
3590541 1864683 1864683 defendant Seynthyll John, junior husbandman 586764 586764 Seynthyll, John, junior, of Morton Hampstede, husbandman 1
3590542 1864683 1864683 defendant Broundwynde John husbandman 586764 586764 Broundwynde, John, of Morton Hampstede, husbandman 2
3590543 1864683 1864683 defendant Wanell or Wavell John husbandman 586764 586764 Wanell or Wavell, John, of Morton Hampstede, husbandman 3
3590544 1864683 1864683 defendant Mate Ralph husbandman 586764 586764 Mate, Ralph, of Morton Hampstede, husbandman 4
3590545 1864683 1864683 defendant Seynthyll William baker 586764 586764 Seynthyll, William, of Morton Hampstede, baker 5
3590546 1864683 1864683 defendant Wonston John husbandman 586764 586764 Wonston, John, of Morton Hampstede, husbandman 6
3590554 1864686 1864686 defendant Wanell or Wavell Robert husbandman 586764 586764 Wanell or Wavell, Robert, of Morton Hampstede, husbandman 0
3609481 1870628 1870628 defendant Wall Robert yeoman 586764 586764 Wall, Robert, of Morton Hampstede, yeoman 0
3610075 1870819 1870819 defendant Willyam William husbandman 586764 586764 Willyam, William, of Morton Hampstede, husbandman 0
3630781 1904451 1904451 defendant Wanell or Wavell Robert yeoman 586764 586764 Wanell or Wavell, Robert, of Morton Hampstede, yeoman 0
3630787 1904452 1904452 defendant Hoper John mercer 586764 586764 Hoper, John, of Morton Hampstede, mercer 0
3657222 1912523 1912523 defendant Houghton William husbandman 586764 586764 Houghton, William, of Morton Hampstede, husbandman 0
3657223 1912523 1912523 defendant Bremelcombe Richard husbandman 586764 586764 Bremelcombe, Richard, of Morton Hampstede, husbandman 1
3985766 2019671 2019671 plaintiff Wannell Richard, junior gent 586764 586764 Wannell, Richard, junior, of Morton Hampstede, gent 0
4197452 2094666 2094666 defendant Wannell John yeoman 586764 586764 Wannell, John, of Morton Hampstede, yeoman 0
4197453 2094666 2094666 defendant Hall Thomas tanner 586764 586764 Hall, Thomas, of Morton Hampstede, tanner 1
4304790 2131809 2131809 defendant Colcher Richard yeoman 586764 586764 Colcher, Richard, of Morton Hampstede, yeoman 0
4304791 2131809 2131809 defendant Cornyshe Richard yeoman 586764 586764 Cornyshe, Richard, of Morton Hampstede, yeoman 1
5241997 2427858 2427858 defendant Alford John mercer 586764 586764 Alford, John, of Morton Hampstede, mercer 0
5306785 2447024 2447024 defendant Alford John husbandman 586764 586764 Alford, John, of Morton Hampstede, husbandman 0
5306786 2447024 2447024 defendant Charles William husbandman 586764 586764 Charles, William, of Morton Hampstede, husbandman 1
5306787 2447024 2447024 defendant Wolcote John tailor 586764 586764 Wolcote, John, of Morton Hampstede, tailor 2
5313306 2449017 2449017 defendant Touker John laborer 586764 586764 Touker, John, of Morton Hampstede, laborer 1
5350831 2460370 2460370 defendant Wanell or Wavell Richard husbandman 586764 586764 Wanell or Wavell, Richard, of Morton Hampstede, husbandman 0
5356242 2462029 2462029 defendant Nytherton John, senior yeoman 586764 586764 Nytherton, John, senior, of Morton Hampstede, yeoman 0
5358278 2462644 2462644 defendant Wanell or Wavell Richard yeoman 586764 586764 Wanell or Wavell, Richard, of Morton Hampstede, yeoman 0
5358279 2462644 2462644 defendant Wanell or Wavell John, junior laborer 586764 586764 Wanell or Wavell, John, junior, of Morton Hampstede, laborer 1
5358280 2462644 2462644 defendant Hunte John laborer 586764 586764 Hunte, John, of Morton Hampstede, laborer 2
5358282 2462645 2462645 defendant Wanell or Wavell Robert carpenter 586764 586764 Wanell or Wavell, Robert, of Morton Hampstede, carpenter 0
5358283 2462645 2462645 defendant Langmeth William weaver 586764 586764 Langmeth, William, of Morton Hampstede, weaver 1
5358284 2462645 2462645 defendant Wanell or Wavell Richard yeoman 586764 586764 together with Wanell or Wavell, Richard, of Morton Hampstede, yeoman 2
5358285 2462645 2462645 defendant Wanell or Wavell John, junior laborer 586764 586764 Wanell or Wavell, John, junior, of Morton Hampstede, laborer 3
5358286 2462645 2462645 defendant Hunte John laborer 586764 586764 Hunte, John, of Morton Hampstede, laborer 4
5363212 2464149 2464149 defendant Charlys William carpenter 586764 586764 Charlys, William, of Morton Hampstede, carpenter 0
5379307 2469119 2469119 defendant Corset William husbandman 586764 586764 Corset, William, of Morton Hampstede, husbandman 0
5411794 2478482 2478482 defendant Wanell or Wavell Richard yeoman 586764 586764 Wanell or Wavell, Richard, of Morton Hampstede, yeoman 0
5423353 2481945 2481945 defendant Wonston John fisher 586764 586764 Wonston, John, of Morton Hampstede, fisher 0
5426301 2482820 2482820 defendant Wanell Richard yeoman 586764 586764 Wanell, Richard, of Morton Hampstede, yeoman 0
5444455 2488249 2488249 defendant Wavell Richard yeoman 586764 586764 Wavell, Richard, of Morton Hampstede, yeoman 0
5453954 2491073 2491073 defendant Borset William yeoman 586764 586764 Borset, William, of Morton Hampstede, yeoman 1
5457185 2492046 2492046 defendant Wavell Richard yeoman 586764 586764 Wavell, Richard, of Morton Hampstede, yeoman 0
5465572 2494609 2494609 defendant Coysshe Richard husbandman 586764 586764 Coysshe, Richard, of Morton Hampstede, husbandman 0
5465574 2494610 2494610 defendant Coysshe Richard husbandman 586764 586764 Coysshe, Richard, of Morton Hampstede, husbandman 0
5465576 2494611 2494611 defendant Coysshe Richard husbandman 586764 586764 Coysshe, Richard, of Morton Hampstede, husbandman 0
5465870 2494709 2494709 defendant Corset William yeoman 586764 586764 Corset, William, of Morton Hampstede, yeoman 1
5469051 2495671 2495671 defendant Wavell Richard yeoman 586764 586764 Wavell, Richard, of Morton Hampstede, yeoman 0
5477050 2498141 2498141 defendant Coysshe Richard husbandman 586764 586764 Coysshe, Richard, of Morton Hampstede, husbandman 0
5477343 2498233 2498233 defendant Corset William yeoman 586764 586764 Corset, William, of Morton Hampstede, yeoman 1
5492583 2502694 2502694 defendant Seynthill John, junior husbandman 586764 586764 Seynthill, John, junior, of Morton Hampstede, husbandman 0
5492584 2502694 2502694 defendant Brouonwynde John husbandman 586764 586764 Brouonwynde, John, of Morton Hampstede, husbandman 1
5492585 2502694 2502694 defendant Maye Ralph husbandman 586764 586764 Maye, Ralph, of Morton Hampstede, husbandman 2
5492586 2502694 2502694 defendant Seynthill William baker 586764 586764 Seynthill, William, of Morton Hampstede, baker 3
5492587 2502694 2502694 defendant Wonston John husbandman 586764 586764 Wonston, John, of Morton Hampstede, husbandman 4
5494355 2503213 2503213 defendant Hamelyn Geoffrey husbandman 586764 586764 Hamelyn, Geoffrey, of Morton Hampstede, husbandman 0
5494356 2503213 2503213 defendant Losky John husbandman 586764 586764 Losky, John, of Morton Hampstede, husbandman 1
5494357 2503213 2503213 defendant Estbroke William husbandman 586764 586764 Estbroke, William, of Morton Hampstede, husbandman 2
5507443 2507223 2507223 defendant Wavell or Wanell Robert   586764 586764 Wavell or Wanell, Robert, of Morton Hampstede, court holder 0
5507445 2507224 2507224 defendant Wavell or Wanell Robert husbandman 586764 586764 Wavell or Wanell, Robert, of Morton Hampstede, husbandman 0
5507451 2507225 2507225 defendant Wavell or Wanell Robert husbandman 586764 586764 Wavell or Wanell, Robert, of Morton Hampstede, husbandman 0
5507453 2507225 2507225 defendant Bronwynde John husbandman 586764 586764 Bronwynde, John, of Morton Hampstede, husbandman 2
5507454 2507225 2507225 defendant Wavell or Wanell John husbandman 586764 586764 Wavell or Wanell, John, of Morton Hampstede, husbandman 3
5507455 2507225 2507225 defendant Maye Ralph husbandman 586764 586764 Maye, Ralph, of Morton Hampstede, husbandman 4
5507456 2507225 2507225 defendant Seynthill William baker 586764 586764 Seynthill, William, of Morton Hampstede, baker 5
5507457 2507225 2507225 defendant Wonston John husbandman 586764 586764 Wonston, John, of Morton Hampstede, husbandman 6
5507459 2507226 2507226 defendant Wavell or Wanell Robert husbandman 586764 586764 Wavell or Wanell, Robert, of Morton Hampstede, husbandman 0
5518088 2510492 2510492 defendant Wonston John yeoman 586764 586764 Wonston, John, of Morton Hampstede, yeoman 2
5521945 2511680 2511680 defendant Charlys John gent 586764 586764 Charlys, John, of Morton Hampstede, gent 0
5535519 2515637 2515637 defendant Bromelcombe John yeoman 586764 586764 Bromelcombe, John, of Morton Hampstede, yeoman 0
5537485 2516217 2516217 defendant Bremelcombe John husbandman 586764 586764 Bremelcombe, John, of Morton Hampstede, husbandman 0
5537486 2516217 2516217 defendant Bremelcombe Richard husbandman 586764 586764 Bremelcombe, Richard, of Morton Hampstede, husbandman 1
5537487 2516217 2516217 defendant Wavell or Wanell Robert, senior carpenter 586764 586764 Wavell or Wanell, Robert, senior, of Morton Hampstede, carpenter 2
5537488 2516217 2516217 defendant Wavell or Wanell Richard laborer 586764 586764 Wavell or Wanell, Richard, of Morton Hampstede, laborer 3
5537489 2516217 2516217 defendant Wavell or Wanell Robert, junior laborer 586764 586764 Wavell or Wanell, Robert, junior, of Morton Hampstede, laborer 4
5537490 2516217 2516217 defendant Wavell or Wanell John husbandman 586764 586764 Wavell or Wanell, John, of Morton Hampstede, husbandman 5
5537492 2516217 2516217 defendant Cove William husbandman 586764 586764 Cove, William, of Morton Hampstede, husbandman 7
5537494 2516217 2516217 defendant Toker Richard husbandman 586764 586764 Toker, Richard, of Morton Hampstede, husbandman 9
5549993 2520034 2520034 defendant Wollesdon John yeoman 586764 586764 Wollesdon, John, of Morton Hampstede, yeoman 2
5597310 2534069 2534069 defendant Wyndeyate Richard husbandman 586764 586764 Wyndeyate, Richard, of Morton Hampstede, husbandman 2
5597311 2534069 2534069 defendant Iwart Thomas   586764 586764 Iwart, Thomas, of Morton Hampstede, "crokemaker" 3
5597312 2534069 2534069 defendant Pawelyn John tailor 586764 586764 Pawelyn, John, of Morton Hampstede, tailor 4
5597313 2534069 2534069 defendant Halle John butcher 586764 586764 Halle, John, of Morton Hampstede, butcher 5

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