names

95 rows where place_id = 620270

✎ 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
3734779 1937123 1937123 defendant Androwe John merchant 620270 620270 Androwe, John, of Honyton, Devon, merchant 0
3742672 1939578 1939578 defendant Keterik Thomas bowyer 620270 620270 Keterik, Thomas, of Honyton, Devon, bowyer 2
3818401 1963654 1963654 defendant Monke John merchant 620270 620270 Monke, John, of Honyton, Devon, merchant 0
3856851 1975770 1975770 defendant Trobelfyld John yeoman 620270 620270 Trobelfyld, John, of Honyton, Devon, yeoman 0
3877632 1982759 1982759 defendant Gregory John mercer 620270 620270 Gregory, John, of Honyton, Devon, mercer 0
3895729 1988779 1988779 defendant Monke John yeoman 620270 620270 Monke, John, of Honyton, Devon, yeoman 0
3925446 1998823 1998823 defendant Monke Andrew merchant 620270 620270 Monke, Andrew, of Honyton, Devon, merchant 0
3936121 2002403 2002403 defendant Monke John clerk of the market 620270 620270 Monke, John, of Honyton, Devon, clerk of the market 0
3938696 2003285 2003285 defendant Flatcher William merchant 620270 620270 Flatcher, William, of Honyton, Devon, merchant 0
3952716 2008020 2008020 defendant Monke John merchant 620270 620270 Monke, John, of Honyton, Devon, merchant 0
3962052 2011309 2011309 defendant Lyle John mercer 620270 620270 Lyle, John, of Honyton, Devon, mercer 2
3987328 2020217 2020217 defendant Bennett William chapman 620270 620270 Bennett, William, of Honyton, Devon, chapman 0
3995502 2023138 2023138 defendant Vowell John innholder 620270 620270 Vowell, John, of Honyton, Devon, innholder 0
4031610 2035969 2035969 plaintiff Forde William (legal representative) 620270 620270 Forde, William, of Honyton, Devon, merchant, administratrix of 0
4031613 2035970 2035970 plaintiff Forde William (legal representative) 620270 620270 Forde, William, of Honyton, Devon, merchant, administratrix of 0
4048001 2041728 2041728 defendant Vowell John innholder 620270 620270 Vowell, John, of Honyton, Devon, innholder 0
4081555 2053710 2053710 defendant Leman or Lewman John haberdasher 620270 620270 Leman or Lewman, John, of Honyton, Devon, haberdasher 3
4089596 2056569 2056569 defendant Lowman or Lemman John merchant or "habbersher" 620270 620270 Lowman or Lemman, John, of Honyton, Devon, merchant or "habbersher" 0
4096292 2059004 2059004 defendant Lowman or Loman John haberdasher 620270 620270 Lowman or Loman, John, of Honyton, Devon, haberdasher 0
4098199 2059683 2059683 defendant Loman John hatter 620270 620270 Loman, John, of Honyton, Devon, haberdasher, hatter 0
4126308 2069701 2069701 defendant Baxtor Thomas husbandman 620270 620270 Baxtor, Thomas, of Honyton, Devon, husbandman 0
4127341 2070069 2070069 defendant Bussell John yeoman 620270 620270 Bussell, John, of Honyton, Devon, yeoman 0
4132624 2071990 2071990 defendant Follett John   620270 620270 Follett, John, of Honyton, Devon, linen draper or linen cloth coutter 0
4140913 2074986 2074986 defendant Vowell John innholder 620270 620270 Vowell, John, of Honyton, Devon, innholder 0
4144194 2076129 2076129 defendant Lowman Edmund dyer 620270 620270 Lowman, Edmund, of Honyton, Devon, dyer 0
4145925 2076730 2076730 defendant Quyntrell John husbandman 620270 620270 Quyntrell, John, of Honyton, Devon, husbandman 0
4171913 2085638 2085638 defendant Balstone Christopher glover 620270 620270 Balstone, Christopher, of Honyton, Devon, yeoman, glover 0
4179012 2088135 2088135 defendant Darke John weaver 620270 620270 Darke, John, of Honyton, Devon, weaver 2
4188991 2091634 2091634 defendant Thomas John husbandman 620270 620270 Thomas, John, of Honyton, Devon, husbandman 0
4207281 2098099 2098099 defendant Faytor Charles yeoman 620270 620270 Faytor, Charles, of Honyton, Devon, yeoman 0
4210501 2099228 2099228 defendant Lowman Edmund dyer 620270 620270 Lowman, Edmund, of Honyton, Devon, dyer 0
4211264 2099491 2099491 defendant Lacye John gent 620270 620270 Lacye, John, of Honyton, Devon, gent 0
4240686 2109867 2109867 defendant Lacye John   620270 620270 Lacye, John, of Honyton, Devon 3
4247206 2112041 2112041 defendant Stone John haberdasher 620270 620270 Stone, John, of Honyton, Devon, haberdasher 0
4247255 2112059 2112059 defendant Stone John haberdasher 620270 620270 Stone, John, of Honyton, Devon, haberdasher 0
4264865 2117887 2117887 defendant Nicholles Henry clerk 620270 620270 Nicholles, Henry, of Honyton, Devon, clerk 0
4307796 2132866 2132866 defendant Turbervile Richard merchant 620270 620270 Turbervile, Richard, of Honyton, Devon, merchant 0
4320089 2137133 2137133 defendant Dowryche Henry   620270 620270 Dowryche, Henry, of Honyton, Devon, Bachelor of Theology 1
4349652 2147142 2147142 defendant Dowriche Hugh clerk 620270 620270 Dowriche, Hugh, of Honyton, Devon, clerk 0
4357639 2149905 2149905 defendant Tayler Adam innholder 620270 620270 Tayler, Adam, of Honyton, Devon, or of Sherborne, Dorset, innholder 0
4370614 2154542 2154542 defendant Taylor Adam yeoman 620270 620270 Taylor, Adam, of Honyton, Devon, yeoman 0
4384288 2159440 2159440 defendant Taylor Adam yeoman 620270 620270 Taylor, Adam, of Honyton, Devon, yeoman 0
4389378 2161072 2161072 defendant Stone John   620270 620270 Stone, John, of Honyton, Devon, haberdasher, felt maker 0
4684267 2260683 2260683 defendant Pomeray Thomas   620270 620270 Pomeray, Thomas, of Honyton, Devon, knight 0
4721120 2271940 2271940 defendant Sandy Richard butcher 620270 620270 Sandy, Richard, of Honyton, Devon, butcher 0
4722908 2272482 2272482 defendant Faryngdon William yeoman 620270 620270 Faryngdon, William, of Honyton, Devon, yeoman 1
4727458 2273831 2273831 defendant Lopynford Nicholas husbandman 620270 620270 Lopynford, Nicholas, of Honyton, Devon, husbandman 3
4798348 2295671 2295671 defendant Pound Thomas tucker 620270 620270 Pound, Thomas, of Honyton, Devon, tucker 1
4808789 2298915 2298915 defendant Davy John butcher 620270 620270 (Davy, John, of Honyton, Devon, butcher 1
4808797 2298918 2298918 defendant Davy John butcher 620270 620270 (Davy, John, of Honyton, Devon, butcher 1
4812696 2300087 2300087 defendant Trapel Richard yeoman 620270 620270 Trapel, Richard, of Honyton, Devon, yeoman 0
4812706 2300088 2300088 defendant Trapel Richard yeoman 620270 620270 Trapel, Richard, of Honyton, Devon, yeoman 0
4858181 2313927 2313927 defendant Faryngdon William husbandman 620270 620270 Faryngdon, William, of Honyton, Devon, husbandman 0
4991627 2354378 2354378 defendant Bocher Alexander butcher 620270 620270 (Bocher, Alexander, of Honyton, Devon, butcher 1
5007111 2358969 2358969 defendant Phelip Thomas laborer 620270 620270 Phelip, Thomas, of Honyton, Devon, laborer 2
5007115 2358970 2358970 defendant Phelip Thomas laborer 620270 620270 Phelip, Thomas, of Honyton, Devon, laborer 2
5007119 2358971 2358971 defendant Phelip Thomas laborer 620270 620270 Phelip, Thomas, of Honyton, Devon, laborer 2
5007123 2358972 2358972 defendant Phelip Thomas laborer 620270 620270 Phelip, Thomas, of Honyton, Devon, laborer 2
5027055 2364783 2364783 defendant Bradford James fisher 620270 620270 Bradford, James, of Honyton, Devon, fisher 0
5027221 2364832 2364832 defendant Bradford James fisher 620270 620270 Bradford, James, of Honyton, Devon, fisher 0
5040659 2368816 2368816 defendant Pope William chapman 620270 620270 Pope, William, of Honyton, Devon, chapman 0
5043572 2369697 2369697 defendant Pope William dyer 620270 620270 Pope, William, of Honyton, Devon, dyer 1
5043575 2369698 2369698 defendant Pope William dyer 620270 620270 Pope, William, of Honyton, Devon, dyer 1
5083721 2381634 2381634 defendant Knyght William husbandman 620270 620270 Knyght, William, of Honyton, Devon, husbandman 0
5083723 2381635 2381635 defendant Knyght William husbandman 620270 620270 Knyght, William, of Honyton, Devon, husbandman 0
5121323 2392671 2392671 defendant Heed Thomas chapman 620270 620270 Heed, Thomas, of Honyton, Devon, chapman 1
5121327 2392672 2392672 defendant Heed Thomas chapman 620270 620270 Heed, Thomas, of Honyton, Devon, chapman 1
5121370 2392682 2392682 defendant Stephens Thomas dyer 620270 620270 Stephens, Thomas, of Honyton, Devon, dyer 0
5121373 2392683 2392683 defendant Stephens Thomas dyer 620270 620270 Stephens, Thomas, of Honyton, Devon, dyer 0
5141094 2398520 2398520 defendant Tryvet John yeoman 620270 620270 with Tryvet, John, of Honyton, Devon, yeoman 1
5141902 2398751 2398751 defendant Aleyn alias Bailly Walter weaver 620270 620270 Aleyn alias Bailly, Walter, of Honyton, Devon, weaver 0
5162274 2404693 2404693 defendant Tryvet John yeoman 620270 620270 Tryvet, John, of Honyton, Devon, yeoman 0
5162969 2404897 2404897 defendant Aleyn Walter weaver 620270 620270 Aleyn, Walter, of Honyton, Devon, weaver 0
5175857 2408621 2408621 defendant Knyght William gent 620270 620270 Knyght, William, of Honyton, Devon, gent 3
5191081 2413130 2413130 defendant Hede Thomas clothier 620270 620270 Hede, Thomas, of Honyton, Devon, clothier 0
5194446 2414101 2414101 defendant Tryvet John yeoman 620270 620270 Tryvet, John, of Honyton, Devon, yeoman 1
5210120 2418690 2418690 defendant Knyght William gent 620270 620270 Knyght, William, of Honyton, Devon, gent 2
5224535 2422844 2422844 defendant Tryvet or Trynet John yeoman 620270 620270 Tryvet or Trynet, John, of Honyton, Devon, yeoman 1
5227073 2423573 2423573 defendant Trevette John chapman 620270 620270 Trevette, John, of Honyton, Devon, chapman 0
5227317 2423616 2423616 defendant Trevette John chapman 620270 620270 Trevette, John, of Honyton, Devon, chapman 0
5230235 2424462 2424462 defendant Trenette John chapman 620270 620270 Trenette, John, of Honyton, Devon, chapman 3
5230242 2424463 2424463 defendant Trenette John chapman 620270 620270 Trenette, John, of Honyton, Devon, chapman 4
5232417 2425054 2425054 defendant Tryvet John yeoman 620270 620270 Tryvet, John, of Honyton, Devon, yeoman 0
5251431 2430546 2430546 defendant Trevet John merchant 620270 620270 Trevet, John, of Honyton, Devon, merchant 0
5287419 2441344 2441344 defendant Godde John merchant 620270 620270 Godde, John, of Honyton, Devon, merchant 0
5306073 2446803 2446803 defendant God William merchant 620270 620270 God, William, of Honyton, Devon, merchant 4
5306079 2446804 2446804 defendant God William merchant 620270 620270 God, William, of Honyton, Devon, merchant 4
5318677 2450679 2450679 defendant Pope William husbandman 620270 620270 Pope, William, of Honyton, Devon, husbandman 3
5333653 2455138 2455138 defendant Godde William chapman 620270 620270 Godde, William, of Honyton, Devon, chapman 0
5335193 2455591 2455591 defendant Good William weaver 620270 620270 Good, William, of Honyton, Devon, weaver 2
5362334 2463876 2463876 defendant God William merchant 620270 620270 God, William, of Honyton, Devon, merchant 0
5481700 2499459 2499459 defendant Pope John dyer 620270 620270 Pope, John, of Honyton, Devon, dyer 3
5515516 2509697 2509697 defendant Benet John merchant 620270 620270 Benet, John, of Honyton, Devon, merchant 0
5520596 2511267 2511267 defendant Gilpeyn Richard husbandman 620270 620270 Gilpeyn, Richard, of Honyton, Devon, husbandman 0
5539235 2516757 2516757 defendant Wright John yeoman 620270 620270 Wright, John, of Honyton, Devon, yeoman 0

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