names

104 rows where place_id = 587843

✎ 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
3592599 1865302 1865302 defendant Charlys Richard chapman 587843 587843 Charlys, Richard, of Tenterden, Kent, chapman 1
3592604 1865303 1865303 defendant Charlys Richard chapman 587843 587843 Charlys, Richard, of Tenterden, Kent, chapman 1
3618836 1873502 1873502 defendant Iden Thomas clothier 587843 587843 Iden, Thomas, of Tenterden, Kent, clothier 0
3619704 1873732 1873732 defendant Pette Moise clothier 587843 587843 Pette, Moise, of Tenterden, Kent, clothier 1
3619730 1873741 1873741 defendant Iden Thomas clothier 587843 587843 Iden, Thomas, of Tenterden, Kent, clothier 1
3622067 1874441 1874441 defendant Byrcheley Nicholas clothmaker 587843 587843 Byrcheley, Nicholas, of Tenterden, Kent, clothmaker 2
3654749 1911743 1911743 defendant Creche John   587843 587843 Creche, John, of Tenterden, Kent, cloth maker 0
3772285 1949019 1949019 defendant Parker John gent 587843 587843 Parker, John, of Tenterden, Kent, gent 1
3808670 1960592 1960592 defendant Fowle John gent and clothier 587843 587843 Fowle, John, of Tenterden, Kent, gent and clothier 0
3816709 1963132 1963132 defendant Parker John yeoman 587843 587843 Parker, John, of Tenterden, Kent, yeoman 1
3832645 1968137 1968137 defendant Short Thomas clothier 587843 587843 Short, Thomas, of Tenterden, Kent, clothier 0
3838599 1969999 1969999 defendant Brekynden William yeoman 587843 587843 Brekynden, William, of Tenterden, Kent, yeoman 1
3853014 1974563 1974563 defendant Hope Richard yeoman 587843 587843 Hope, Richard, of Tenterden, Kent, yeoman 1
3874240 1981605 1981605 defendant Fowle John clothier 587843 587843 Fowle, John, of Tenterden, Kent, clothier 0
3896066 1988888 1988888 defendant Lamden John clothmaker 587843 587843 Lamden, John, of Tenterden, Kent, clothmaker 0
3913593 1994884 1994884 defendant Baker Christopher chapman 587843 587843 Baker, Christopher, of Tenterden, Kent, chapman 1
3930645 2000594 2000594 defendant Bowle Stephen gent 587843 587843 Bowle, Stephen, of Tenterden, Kent, gent 3
3974419 2015626 2015626 defendant Awsten Thomas clothier 587843 587843 Awsten, Thomas, of Tenterden, Kent, clothier 0
3986677 2019976 2019976 plaintiff Whytfyld John yeoman 587843 587843 Whytfyld, John, of Tenterden, Kent, yeoman 0
3988978 2020798 2020798 defendant Borges Thomas mercer 587843 587843 Borges, Thomas, of Tenterden, Kent, mercer 0
3999389 2024542 2024542 defendant Burges Thomas yeoman 587843 587843 Burges, Thomas, of Tenterden, Kent, yeoman 0
4028705 2034917 2034917 defendant Harman William carpenter 587843 587843 Harman, William, of Tenterden, Kent, or of Bexhill, Sussex, carpenter 0
4034044 2036834 2036834 plaintiff Hales Edward esq 587843 587843 Hales, Edward, of Tenterden, Kent, esq 0
4052680 2043389 2043389 defendant Marden William yeoman 587843 587843 Marden, William, of Tenterden, Kent, yeoman 0
4064787 2047690 2047690 defendant Lewkenor Roger yeoman 587843 587843 Lewkenor, Roger, of Tenterden, Kent, yeoman 1
4072413 2050438 2050438 defendant Marden William yeoman 587843 587843 Marden, William, of Tenterden, Kent, yeoman 0
4076380 2051850 2051850 plaintiff Short Peter clothier 587843 587843 Short, Peter, of Tenterden, Kent, clothier 0
4081297 2053621 2053621 plaintiff Whitefeld John gent 587843 587843 Whitefeld, John, of Tenterden, Kent, gent 0
4081301 2053622 2053622 defendant Fraye John yeoman 587843 587843 Fraye, John, of Tenterden, kent, yeoman 1
4081418 2053663 2053663 defendant Haffenden George yeoman 587843 587843 Haffenden, George, of Tenterden, Kent, yeoman 0
4081421 2053664 2053664 defendant Haffenden George yeoman 587843 587843 Haffenden, George, of Tenterden, Kent, yeoman 0
4081426 2053667 2053667 plaintiff Whytfeld John gent 587843 587843 Whytfeld, John, of Tenterden, Kent, gent 0
4088084 2056036 2056036 defendant Barnett Joan widow 587843 587843 Barnett, Joan, of Tenterden, Kent, widow 0
4089935 2056691 2056691 defendant Fraye John husbandman 587843 587843 Fraye, John, of Tenterden, Kent, husbandman 0
4098468 2059780 2059780 defendant Burges Thomas yeoman 587843 587843 Burges, Thomas, of Tenterden, Kent, yeoman 0
4102253 2061099 2061099 defendant Fraye John yeoman 587843 587843 Fraye, John, of Tenterden, Kent, yeoman 0
4110483 2064012 2064012 defendant Ramsden Richard yeoman 587843 587843 Ramsden, Richard, of Tenterden, Kent, yeoman 0
4168582 2084495 2084495 defendant Stace Thomas yeoman 587843 587843 Stace, Thomas, of Tenterden, Kent, yeoman 0
4205124 2097340 2097340 defendant Dome or Donne John draper 587843 587843 Dome or Donne, John, of Tenterden, Kent, draper 1
4222377 2103317 2103317 defendant Cheston Thomas yeoman 587843 587843 Cheston, Thomas, of Tenterden, Kent, yeoman 0
4346465 2146014 2146014 defendant Browne Thomas chapman 587843 587843 Browne, Thomas, of Tenterden, Kent, chapman 1
4346624 2146074 2146074 defendant Austen Thomas yeoman 587843 587843 Austen, Thomas, of Tenterden, Kent, yeoman 2
4348467 2146715 2146715 defendant Jarvis George yeoman 587843 587843 Jarvis, George, of Tenterden, Kent, yeoman 1
4639794 2243142 2243142 defendant Warde Thomas   587843 587843 Warde, Thomas, of Tenterden, Kent, wood man 0
4821939 2302934 2302934 defendant Bekwell John draper 587843 587843 Bekwell, John, of Tenterden, Kent, draper 0
4838436 2307937 2307937 defendant Chevelyng John dyer 587843 587843 Chevelyng, John, of Tenterden, Kent, dyer 0
4852525 2312213 2312213 defendant Chevelyng John dyer 587843 587843 Chevelyng, John, of Tenterden, Kent, dyer 3
4852566 2312224 2312224 defendant Chenelyng or Chevelyng John dyer 587843 587843 Chenelyng or Chevelyng, John, of Tenterden, Kent, dyer 3
4870975 2317897 2317897 defendant Bekwell John draper 587843 587843 Bekwell, John, of Tenterden, Kent, draper 3
4882213 2321342 2321342 defendant Haymes Thomas husbandman 587843 587843 Haymes, Thomas, of Tenterden, Kent, husbandman 0
4908595 2329243 2329243 defendant Treweman Thomas husbandman 587843 587843 Treweman, Thomas, of Tenterden, Kent, husbandman 1
4908601 2329244 2329244 defendant Treweman Thomas husbandman 587843 587843 Treweman, Thomas, of Tenterden, Kent, husbandman 0
4926188 2334615 2334615 defendant Markle John dyer 587843 587843 Markle, John, of Tenterden, Kent, dyer 3
4948643 2341559 2341559 defendant Bekwell John draper 587843 587843 Bekwell, John, of Tenterden, Kent, draper 0
4948836 2341617 2341617 defendant Grybell William husbandman 587843 587843 Grybell, William, of Tenterden, Kent, husbandman 1
5030429 2365769 2365769 defendant Aston Simon draper 587843 587843 Aston, Simon, of Tenterden, Kent, or of Mafeld, draper 0
5031338 2366023 2366023 plaintiff Pytelesden Thomas gent 587843 587843 Pytelesden, Thomas, of Tenterden, Kent, gent 0
5068908 2377201 2377201 defendant Stevenys Thomas chapman 587843 587843 Stevenys, Thomas, of Tenterden, Kent, chapman 1
5087184 2382631 2382631 defendant Pittelesden Thomas gent 587843 587843 Pittelesden, Thomas, of Tenterden, Kent, gent 0
5110324 2389423 2389423 defendant Iden William chapman 587843 587843 Iden, William, of Tenterden, Kent, chapman 4
5111920 2389874 2389874 defendant Pittelesden Thomas gent 587843 587843 Pittelesden, Thomas, of Tenterden, Kent, gent 0
5115052 2390820 2390820 defendant Byrcheley Nicholas, senior husbandman 587843 587843 Byrcheley, Nicholas, senior, of Tenterden, Kent, husbandman 0
5133075 2396159 2396159 defendant Pittelesden Thomas gent 587843 587843 Pittelesden, Thomas, of Tenterden, Kent, gent 0
5133490 2396287 2396287 defendant Arnold Robert   587843 587843 Arnold, Robert, of Tenterden, Kent 1
5153293 2402115 2402115 defendant Arnold Robert husbandman 587843 587843 Arnold, Robert, of Tenterden, Kent, husbandman 1
5157994 2403462 2403462 plaintiff Pitelesden Thomas gent 587843 587843 Pitelesden, Thomas, of Tenterden, Kent, gent 0
5170486 2407095 2407095 defendant Pittelesden Thomas gent 587843 587843 Pittelesden, Thomas, of Tenterden, Kent, gent 0
5173716 2408009 2408009 plaintiff Pitelesden Thomas gent 587843 587843 Pitelesden, Thomas, of Tenterden, Kent, gent 0
5188251 2412275 2412275 defendant Pittelesden Thomas gent 587843 587843 Pittelesden, Thomas, of Tenterden, Kent, gent 0
5188254 2412276 2412276 defendant Pittelesden Thomas gent 587843 587843 Pittelesden, Thomas, of Tenterden, Kent, gent 0
5195175 2414332 2414332 defendant Wette Richard chapman 587843 587843 Wette, Richard, of Tenterden, Kent, chapman 2
5208771 2418290 2418290 plaintiff Pytelesden Thomas gent 587843 587843 Pytelesden, Thomas, of Tenterden, Kent, gent 0
5209140 2418401 2418401 defendant Wette Richard chapman 587843 587843 Wette, Richard, of Tenterden, Kent, chapman 2
5212255 2419324 2419324 defendant Byrchele Stephen husbandman 587843 587843 Byrchele, Stephen, of Tenterden, Kent, husbandman 0
5212258 2419325 2419325 defendant Byrchele Stephen husbandman 587843 587843 Byrchele, Stephen, of Tenterden, Kent, husbandman 0
5219991 2421557 2421557 defendant Pittelesden Thomas gent 587843 587843 Pittelesden, Thomas, of Tenterden, Kent, gent 0
5219994 2421558 2421558 defendant Pittelesden Thomas gent 587843 587843 Pittelesden, Thomas, of Tenterden, Kent, gent 0
5224170 2422741 2422741 plaintiff Pitelesden Thomas gent 587843 587843 Pitelesden, Thomas, of Tenterden, Kent, gent 0
5225693 2423185 2423185 defendant Iden William chapman 587843 587843 Iden, William, of Tenterden, Kent, chapman 2
5251481 2430563 2430563 defendant Cristian John chapman 587843 587843 Cristian, John, of Tenterden, Kent, chapman 1
5290518 2442229 2442229 defendant Gylford John   587843 587843 Gylford, John, of Tenterden, Kent, knight 3
5290526 2442230 2442230 defendant Gylford John   587843 587843 Gylford, John, of Tenterden, Kent, knight 3
5312729 2448845 2448845 defendant Harrys William yeoman 587843 587843 Harrys, William, of Tenterden, Kent, yeoman 1
5318397 2450597 2450597 defendant Whythed Thomas dyer 587843 587843 Whythed, Thomas, of Tenterden, Kent, dyer 0
5359360 2462966 2462966 defendant Pert Stephen yeoman 587843 587843 Pert, Stephen, of Tenterden, Kent, yeoman 0
5373420 2467282 2467282 defendant Cristian John chapman 587843 587843 Cristian, John, of Tenterden, Kent, chapman 0
5374810 2467716 2467716 defendant Broke John husbandman 587843 587843 Broke, John, of Tenterden, Kent, husbandman 1
5380644 2469512 2469512 defendant Gylford Richard esq 587843 587843 Gylford, Richard, of Tenterden, Kent, esq 3
5385552 2470937 2470937 defendant Gylford Richard esq 587843 587843 Gylford, Richard, of Tenterden, Kent, esq 3
5397656 2474400 2474400 defendant Gyldford Richard esq 587843 587843 Gyldford, Richard, of Tenterden, Kent, esq 2
5433042 2484848 2484848 defendant Hay_ Richard chapman 587843 587843 Hay_, Richard, of Tenterden, Kent, chapman 0
5496441 2503845 2503845 defendant Carder William clothmaker 587843 587843 Carder, William, of Tenterden, Kent, clothmaker 2
5496447 2503846 2503846 defendant Carder William clothmaker 587843 587843 Carder, William, of Tenterden, Kent, clothmaker 2
5519061 2510807 2510807 defendant Dey William yeoman 587843 587843 Dey, William, of Tenterden, Kent, yeoman 0
5529449 2513720 2513720 defendant Benet William carrier 587843 587843 Benet, William, of Tenterden, Kent, carrier 2
5529455 2513721 2513721 defendant Benet William carrier 587843 587843 Benet, William, of Tenterden, Kent, carrier 2
5543494 2518081 2518081 defendant Tournowre Hugh clothmaker 587843 587843 Tournowre, Hugh, of Tenterden, Kent, clothmaker 1
5543508 2518083 2518083 defendant Tournowr Hugh clothmaker 587843 587843 Tournowr, Hugh, of Tenterden, Kent, clothmaker 2
5570975 2526071 2526071 defendant Fougyll George yeoman 587843 587843 Fougyll, George, of Tenterden, Kent, yeoman 0
5570979 2526073 2526073 defendant Foughill George yeoman 587843 587843 Foughill, George, of Tenterden, Kent, 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);