names

207 rows where place_id = 588665

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595216 1866138 1866138 defendant Seynton John yeoman 588665 588665 Seynton, John, of Dartford, yeoman 0
3631693 1904725 1904725 defendant Longe William smith 588665 588665 Longe, William, of Dartford, smith 2
3631695 1904725 1904725 defendant Barnard William yeoman 588665 588665 Barnard, William, of Dartford, yeoman 4
3633346 1905244 1905244 plaintiff Kenham William   588665 588665 Kenham, William, of Dartford 0
3647850 1909723 1909723 defendant Hobgood Thomas laborer 588665 588665 Hobgood, Thomas, of Dartford, laborer 2
3658913 1913048 1913048 defendant Appulton Roger yeoman 588665 588665 Appulton, Roger, of Dartford, yeoman 0
3660467 1913535 1913535 defendant Wodde Simon glover 588665 588665 Wodde, Simon, of Dartford, glover 0
3670586 1916762 1916762 defendant Willard John   588665 588665 Willard, John, of Dartford 0
3674386 1918035 1918035 defendant Jenkyn John cordwainer 588665 588665 Jenkyn, John, of Dartford, cordwainer 0
3674389 1918035 1918035 defendant Clever Thomas husbandman 588665 588665 Clever, Thomas, of Dartford, husbandman 3
3674434 1918050 1918050 defendant Toppysfeyld John butcher 588665 588665 Toppysfeyld, John, of Dartford, butcher 0
3693382 1924145 1924145 defendant Hatcher John husbandman 588665 588665 Hatcher, John, of Dartford, husbandman 1
3694749 1924562 1924562 defendant Stokemede William baker 588665 588665 Stokemede, William, of Dartford, baker 0
3694750 1924562 1924562 defendant Meryell Robert husbandman 588665 588665 Meryell, Robert, of Dartford, husbandman 1
3698591 1925776 1925776 defendant Marshall John gent 588665 588665 Marshall, John, of Dartford, gent 0
3698592 1925776 1925776 defendant Stokemede William beker 588665 588665 Stokemede, William, of Dartford, beker 1
3699551 1926091 1926091 defendant Holynden John carpenter 588665 588665 Holynden, John, of Dartford, carpenter 2
3705725 1928074 1928074 defendant Cowley John gent 588665 588665 Cowley, John, of Dartford, gent 1
3705748 1928078 1928078 defendant Brande John draper 588665 588665 Brande, John, of Dartford, draper 4
3706500 1928316 1928316 defendant Mere Stephen baker 588665 588665 Mere, Stephen, of Dartford, baker 1
3706501 1928316 1928316 defendant Buryman William miller 588665 588665 Buryman, William, of Dartford, miller 2
3707614 1928679 1928679 defendant Stokmede William baker 588665 588665 Stokmede, William, of Dartford, baker 3
3712188 1930128 1930128 defendant Stokmede William baker 588665 588665 Stokmede, William, of Dartford, baker 0
3725001 1934105 1934105 defendant Wigan William clerk 588665 588665 Wigan, William, of Dartford, clerk 0
3725002 1934105 1934105 defendant Churche Thomas husbandman 588665 588665 Churche, Thomas, of Dartford, husbandman 1
3725004 1934105 1934105 defendant Bylwalter Thomas laborer 588665 588665 Bylwalter, Thomas, of Dartford, laborer 3
3734173 1936929 1936929 defendant Appulton Roger gent 588665 588665 Appulton, Roger, of Dartford, gent 0
3734174 1936929 1936929 defendant Stokemede William yeoman 588665 588665 Stokemede, William, of Dartford, yeoman 1
3737077 1937838 1937838 defendant Churche Thomas yeoman 588665 588665 Churche, Thomas, of Dartford, yeoman 0
3737078 1937838 1937838 defendant Ford Robert butcher 588665 588665 Ford, Robert, of Dartford, butcher 1
3737079 1937838 1937838 defendant Russell John   588665 588665 Russell, John, of Dartford, parish clerk 2
3743316 1939782 1939782 defendant Cotyar Margery widow 588665 588665 Cotyar, Margery, of Dartford, widow 0
3743317 1939782 1939782 defendant Frythe Agnes spinster 588665 588665 Frythe, Agnes, of Dartford, spinster 1
3743318 1939782 1939782 defendant Helgoode Agnes widow 588665 588665 Helgoode, Agnes, of Dartford, widow 2
3756606 1944048 1944048 defendant Stokmede William baker 588665 588665 Stokmede, William, of Dartford, baker 0
3763286 1946149 1946149 defendant Garbrand Nicholas shoemaker 588665 588665 Garbrand, Nicholas, of Dartford, shoemaker 3
3765506 1946876 1946876 defendant Stokmede William baker 588665 588665 Stokmede, William, of Dartford, baker 3
3768173 1947685 1947685 defendant Makyn William yeoman 588665 588665 Makyn, William, of Dartford, yeoman 0
3792191 1955409 1955409 defendant Mayken William yeoman 588665 588665 Mayken, William, of Dartford, yeoman 0
3792193 1955410 1955410 defendant Maykyn William yeoman 588665 588665 Maykyn, William, of Dartford, yeoman 0
3808763 1960620 1960620 defendant Stokmede William baker 588665 588665 Stokmede, William, of Dartford, baker 0
3832999 1968240 1968240 plaintiff Kennam William yeoman 588665 588665 Kennam, William, of Dartford, yeoman 0
3917903 1996350 1996350 plaintiff Hayhowe alias Maho Dorothy widow 588665 588665 Hayhowe alias Maho, Dorothy, of Dartford, widow 0
4002223 2025580 2025580 plaintiff Heathe Christopher yeoman 588665 588665 Heathe, Christopher, of Dartford, yeoman 0
4020161 2031933 2031933 defendant Marshall Hugh yeoman 588665 588665 Marshall, Hugh, of Dartford, yeoman 1
4020165 2031934 2031934 defendant Marshall Hugh yeoman 588665 588665 Marshall, Hugh, of Dartford, yeoman 1
4047743 2041641 2041641 defendant Fremlyn John baker 588665 588665 Fremlyn, John, of Dartford, baker 0
4047745 2041642 2041642 defendant Fremlyn John baker 588665 588665 Fremlyn, John, of Dartford, baker 0
4051045 2042812 2042812 defendant Gamble John yeoman 588665 588665 Gamble, John, of Dartford, yeoman 2
4079833 2053087 2053087 defendant Moore Herbert shoemaker 588665 588665 Moore, Herbert, of Dartford, shoemaker 0
4079835 2053088 2053088 defendant More Herbert shoemaker 588665 588665 More, Herbert, of Dartford, shoemaker 0
4082559 2054066 2054066 defendant Nott Nicholas yeoman 588665 588665 Nott, Nicholas, of Dartford, yeoman 0
4104280 2061809 2061809 defendant Monox George gent 588665 588665 Monox, George, of Dartford, gent 0
4126920 2069921 2069921 defendant Beere Nicholas esq 588665 588665 Beere, Nicholas, of Dartford, esq 0
4149036 2077782 2077782 defendant Bere Nicholas gent 588665 588665 Bere, Nicholas, of Dartford, gent 0
4167063 2083983 2083983 defendant Turner Joan widow 588665 588665 Turner, Joan, of Dartford, widow 1
4172621 2085882 2085882 defendant Turner Thomas (legal representative) 588665 588665 Turner, Thomas, of Dartford, husbandman, administratrix of 0
4172622 2085882 2085882 defendant Turner Joan widow 588665 588665 Turner, Joan, of Dartford, widow 1
4174189 2086428 2086428 defendant Turner Thomas (legal representative) 588665 588665 Turner, Thomas, of Dartford, husbandman, administratrix of 0
4174190 2086428 2086428 defendant Turner Joan widow 588665 588665 Turner, Joan, of Dartford, widow 1
4177473 2087596 2087596 defendant Turner Joan widow 588665 588665 Turner, Joan, of Dartford, widow 1
4177890 2087741 2087741 defendant Turner Thomas (legal representative) 588665 588665 Turner, Thomas, of Dartford, husbandman, administratrix of 0
4177891 2087741 2087741 defendant Turner Joan widow 588665 588665 Turner, Joan, of Dartford, widow 1
4182091 2089215 2089215 defendant Turner Thomas (legal representative) 588665 588665 Turner, Thomas, of Dartford, husbandman, administratrix of 0
4182092 2089215 2089215 defendant Turner Joan widow 588665 588665 Turner, Joan, of Dartford, widow 1
4184118 2089943 2089943 defendant Turner Joan widow 588665 588665 Turner, Joan, of Dartford, widow 1
4191800 2092688 2092688 defendant Parker Henry gent 588665 588665 Parker, Henry, of Dartford, gent 1
4197490 2094681 2094681 defendant Bevington Richard glasier 588665 588665 Bevington, Richard, of Dartford, glasier 0
4197491 2094681 2094681 defendant Cotman John, junior   588665 588665 Cotman, John, junior, of Dartford 1
4197492 2094681 2094681 defendant Bendleyes William tailor 588665 588665 Bendleyes, William, of Dartford, tailor 2
4223838 2103823 2103823 defendant Brett Robert tanner 588665 588665 Brett, Robert, of Dartford, tanner 0
4223839 2103823 2103823 defendant Ruck Richard gent 588665 588665 Ruck, Richard, of Dartford, gent 1
4233216 2107127 2107127 defendant Parkes John butcher 588665 588665 Parkes, John, of Dartford, butcher 0
4249282 2112742 2112742 defendant Brett Robert tanner 588665 588665 Brett, Robert, of Dartford, tanner 0
4249283 2112742 2112742 defendant Ruck Richard gent 588665 588665 Ruck, Richard, of Dartford, gent 1
4318769 2136677 2136677 defendant Vaughan James gent 588665 588665 Vaughan, James, of Dartford, gent 0
4334639 2141853 2141853 defendant Gayler John (legal representative) 588665 588665 Gayler, John, of Dartford, yeoman, executors of 0
4334640 2141853 2141853 defendant Dunce Thomas innkeeper 588665 588665 (Dunce, Thomas, of Dartford, innkeeper 1
4369032 2153988 2153988 defendant Birde John   588665 588665 Birde, John, of Dartford, or of Bocton Malherbe, chapman, son of Thomas 0
4395634 2163126 2163126 defendant Watson Thomas   588665 588665 Watson, Thomas, of Dartford, or of Chelmesford, Essex, apothecary 0
4395635 2163126 2163126 defendant Ballard George yeoman 588665 588665 Ballard, George, of Dartford, or of Mulsham, Chelmesford, yeoman 1
4395637 2163127 2163127 defendant Gowge or Gowche Thomas gent 588665 588665 Gowge or Gowche, Thomas, of Dartford, or of Goodester, Essex, gent 0
4407861 2167194 2167194 defendant Ballard George yeoman 588665 588665 Ballard, George, of Dartford, or of Moulsham, Chelmesford, Essex, yeoman 0
4407863 2167195 2167195 defendant Ballard George yeoman 588665 588665 Ballard, George, of Dartford, or of Chelmesford, Essex, yeoman 0
4407864 2167195 2167195 defendant Watson Thomas   588665 588665 Watson, Thomas, of Dartford, apothecary 1
4509141 2203335 2203335 plaintiff Astenelayn Thomas (legal representative) 588665 588665 Astenelayn, Thomas, of Dartford, cook, executor of 0
4516428 2205547 2205547 defendant Glover Thomas   588665 588665 Glover, Thomas, of Dartford 0
4523161 2207573 2207573 defendant Clerk John   588665 588665 Clerk, John, of Dartford 3
4592826 2229090 2229090 defendant Saundres Richard   588665 588665 Saundres, Richard, of Dartford 0
4604006 2232424 2232424 plaintiff Wylkyn Thomas   588665 588665 Wylkyn, Thomas, of Dartford 0
4604009 2232424 2232424 defendant Hallyngge John   588665 588665 Hallyngge, John, of Dartford 2
4698058 2264880 2264880 plaintiff Couper Richard   588665 588665 Couper, Richard, of Dartford 0
4703130 2266356 2266356 plaintiff (not given) Thomas vicar of Havecroft 588665 588665 Havecroft, Thomas, of Dartford, vicar of the church 0
4703399 2266444 2266444 defendant Boston London John hostler 588665 588665 Boston London, John, of Dartford, hostler 0
4706073 2267275 2267275 defendant Hewe John laborer 588665 588665 Hewe, John, of Dartford, laborer 0
4717509 2270812 2270812 plaintiff Rothele William   588665 588665 Rothele, William, of Dartford 1
4733875 2275779 2275779 plaintiff Rotheley William   588665 588665 Rotheley, William, of Dartford 0
4733879 2275780 2275780 plaintiff Boost John   588665 588665 Boost, John, of Dartford 1
4754888 2281908 2281908 defendant Rokesley Richard husbandman 588665 588665 Rokesley, Richard, of Dartford, husbandman 0
4760297 2283574 2283574 plaintiff Coupere Richard   588665 588665 Coupere, Richard, of Dartford 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);