names

293 rows where place_id = 588760

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595487 1866223 1866223 defendant Wilsher Thomas ironmonger 588760 588760 Wilsher, Thomas, of Dertford, ironmonger 0
3595606 1866253 1866253 defendant Dimok John husbandman 588760 588760 Dimok, John, of Dertford, husbandman 3
3595607 1866253 1866253 defendant Mattok William husbandman 588760 588760 Mattok, William, of Dertford, husbandman 4
3595625 1866259 1866259 plaintiff Miller William (legal representative) 588760 588760 Miller, William, of Dertford, executrix of 0
3595627 1866259 1866259 defendant Gennyn Thomas husbandman 588760 588760 Gennyn, Thomas, of Dertford, husbandman 0
3595629 1866260 1866260 plaintiff Miller William (legal representative) 588760 588760 Miller, William, of Dertford, executrix of 0
3595631 1866260 1866260 defendant Genyn Thomas husbandman 588760 588760 Genyn, Thomas, of Dertford, husbandman 0
3597780 1866923 1866923 defendant Hamond Thomas husbandman 588760 588760 Hamond, Thomas, of Dertford, husbandman 1
3599430 1867461 1867461 defendant Jenkyn Thomas smith 588760 588760 Jenkyn, Thomas, of Dertford, smith 0
3599431 1867461 1867461 defendant Coryer Thomas husbandman 588760 588760 Coryer, Thomas, of Dertford, husbandman 1
3599654 1867534 1867534 defendant Sale Richard yeoman 588760 588760 Sale, Richard, of Dertford, yeoman 1
3604500 1869073 1869073 defendant Appylton Roger gent 588760 588760 Appylton, Roger, of Dertford, gent 1
3606934 1869833 1869833 defendant Seynton John innholder 588760 588760 Seynton, John, of Dertford, innholder 2
3608866 1870428 1870428 defendant Cotear Thomas yeoman 588760 588760 Cotear, Thomas, of Dertford, yeoman 4
3610558 1870966 1870966 defendant Sherley John laborer 588760 588760 Sherley, John, of Dertford, laborer 0
3610559 1870966 1870966 defendant White Edward laborer 588760 588760 White, Edward, of Dertford, laborer 1
3611499 1871269 1871269 defendant Shorley John laborer 588760 588760 Shorley, John, of Dertford, laborer 2
3611500 1871269 1871269 defendant Rankehorn William laborer 588760 588760 Rankehorn, William, of Dertford, laborer 3
3613919 1872007 1872007 defendant Brandys Rose widow 588760 588760 Brandys, Rose, of Dertford, widow 2
3617462 1873081 1873081 defendant Seynton John yeoman 588760 588760 Seynton, John, of Dertford, yeoman 3
3620723 1874056 1874056 defendant Thomas Roger clothmaker 588760 588760 Thomas, Roger, of Dertford, clothmaker 0
3620778 1874072 1874072 defendant Neweman Nicholas chaplain 588760 588760 Neweman, Nicholas, of Dertford, chaplain 0
3633349 1905244 1905244 defendant Sprever William yeoman 588760 588760 Sprever, William, of Dertford, yeoman 2
3633350 1905244 1905244 defendant Cobbe Henry yeoman 588760 588760 Cobbe, Henry, of Dertford, yeoman 3
3637663 1906593 1906593 defendant Jones William yeoman 588760 588760 Jones, William, of Dertford, yeoman 1
3666384 1915437 1915437 defendant Todde Margaret widow 588760 588760 Todde, Margaret, of Dertford, widow 0
3666387 1915438 1915438 defendant Cresnor Edward gent 588760 588760 Cresnor, Edward, of Dertford, gent 0
3666388 1915438 1915438 defendant Brand John tailor 588760 588760 Brand, John, of Dertford, tailor 1
3666389 1915438 1915438 defendant Burlton William yeoman 588760 588760 Burlton, William, of Dertford, yeoman 2
3666390 1915438 1915438 defendant Underhill John laborer 588760 588760 Underhill, John, of Dertford, laborer 3
3666391 1915438 1915438 defendant Kery Thomas   588760 588760 Kery, Thomas, of Dertford, "coke" 4
3666637 1915510 1915510 defendant Alisaunder Richard woodmonger 588760 588760 Alisaunder, Richard, of Dertford, woodmonger 0
3696339 1925076 1925076 defendant Willard John yeoman 588760 588760 Willard, John, of Dertford, yeoman 1
3702321 1926984 1926984 defendant Merryell Robert husbandman 588760 588760 Merryell, Robert, of Dertford, husbandman 5
3705727 1928074 1928074 defendant Bronde Thomas tailor 588760 588760 Bronde, Thomas, of Dertford, tailor 3
3720857 1932817 1932817 plaintiff Jones William (legal representative) 588760 588760 Jones, William, of Dertford, executors of 0
3723327 1933566 1933566 defendant Porter John smith 588760 588760 Porter, John, of Dertford, smith 1
3723328 1933566 1933566 defendant Bullyn Richard smith 588760 588760 Bullyn, Richard, of Dertford, smith 2
3731678 1936138 1936138 defendant Ketyll Thomas husbandman 588760 588760 Ketyll, Thomas, of Dertford, husbandman 1
3738528 1938260 1938260 defendant Stokemede William baker 588760 588760 Stokemede, William, of Dertford, baker 1
3743319 1939782 1939782 defendant Crowder Elizabeth spinster 588760 588760 Crowder, Elizabeth, of Dertford, spinster 3
3756605 1944048 1944048 plaintiff Awditor Thomas yeoman 588760 588760 Awditor, Thomas, of Dertford, yeoman 0
3792128 1955391 1955391 defendant Topysfeld John butcher 588760 588760 Topysfeld, John, of Dertford, butcher 0
3792187 1955408 1955408 defendant Greves William tailor 588760 588760 Greves, William, of Dertford, tailor 0
3792189 1955408 1955408 defendant Bolton John laborer 588760 588760 Bolton, John, of Dertford, laborer 2
3794762 1956240 1956240 defendant Hyll John miller 588760 588760 Hyll, John, of Dertford, miller 0
3794763 1956240 1956240 defendant Dalby Richard miller 588760 588760 Dalby, Richard, of Dertford, miller 1
3807751 1960311 1960311 defendant Mannyng Thomas husbandman 588760 588760 Mannyng, Thomas, of Dertford, husbandman 2
3807762 1960312 1960312 defendant Gruffith Elias yeoman 588760 588760 Gruffith, Elias, of Dertford, yeoman 4
3816604 1963094 1963094 defendant Lee Alan husbandman 588760 588760 Lee, Alan, of Dertford, husbandman 0
3858016 1976156 1976156 defendant Hollyngworth John yeoman 588760 588760 Hollyngworth, John, of Dertford, yeoman 1
3858017 1976156 1976156 defendant Kyllyngworth Thomas husbandman 588760 588760 Kyllyngworth, Thomas, of Dertford, husbandman 2
3858018 1976156 1976156 defendant Churcheyate Thomas laborer 588760 588760 Churcheyate, Thomas, of Dertford, laborer 3
3858019 1976156 1976156 defendant Taylor John laborer 588760 588760 Taylor, John, of Dertford, laborer 4
3862415 1977623 1977623 defendant Lampe Robert chapman 588760 588760 Lampe, Robert, of Dertford, chapman 0
3917904 1996350 1996350 defendant Ade Roger baker 588760 588760 Ade, Roger, of Dertford, baker 0
3954316 2008578 2008578 defendant Bayle William miller 588760 588760 Bayle, William, of Dertford, miller 1
3991782 2021814 2021814 defendant Camberleyn Christopher gent 588760 588760 Camberleyn, Christopher, of Dertford, gent 0
4015919 2030383 2030383 defendant Eglysfeilde Christopher gent 588760 588760 Eglysfeilde, Christopher, of Dertford, gent 1
4320086 2137132 2137132 defendant Spencer William gent 588760 588760 Spencer, William, of Dertford, gent 2
4400564 2164780 2164780 defendant Smyth Thomas yeoman 588760 588760 Smyth, Thomas, of Dertford, yeoman 0
4443712 2183002 2183002 defendant Denys Geoffrey   588760 588760 Denys, Geoffrey, of Dertford 0
4455443 2186704 2186704 plaintiff Millere Ralph   588760 588760 Millere, Ralph, of Dertford 0
4455445 2186705 2186705 plaintiff Millere Ralph   588760 588760 Millere, Ralph, of Dertford 0
4547110 2215029 2215029 defendant Saunder Richard   588760 588760 Saunder, Richard, of Dertford 0
4584660 2226623 2226623 defendant Balle John butcher 588760 588760 Balle, John, of Dertford, butcher 1
4584664 2226624 2226624 defendant Balle John butcher 588760 588760 Balle, John, of Dertford, butcher 1
4688755 2262041 2262041 defendant Milot Richard laborer 588760 588760 Milot, Richard, of Dertford, laborer 0
4719358 2271396 2271396 plaintiff Beston John yeoman 588760 588760 Beston, John, of Dertford, yeoman 0
4733882 2275781 2275781 plaintiff Boost John   588760 588760 Boost, John, of Dertford 1
4757920 2282854 2282854 defendant Aleyn Robert yeoman 588760 588760 Aleyn, Robert, of Dertford, yeoman 0
4782663 2290591 2290591 plaintiff Gardener John   588760 588760 Gardener, John, of Dertford 1
4798334 2295665 2295665 defendant Andrewe Peter hosteler 588760 588760 Andrewe, Peter, of Dertford, hosteler 0
4804776 2297694 2297694 defendant Rodle Roger chandler 588760 588760 Rodle, Roger, of Dertford, chandler 0
4822501 2303111 2303111 plaintiff slynggesby John   588760 588760 slynggesby, John, of Dertford, on his own account 0
4822503 2303112 2303112 plaintiff Slynggesby John   588760 588760 Slynggesby, John, of Dertford, on his own account 0
4864274 2315803 2315803 defendant Stynere John husbandman 588760 588760 Stynere, John, of Dertford, husbandman 0
4896226 2325479 2325479 defendant Venore John carpenter 588760 588760 Venore, John, of Dertford, carpenter 1
4896227 2325479 2325479 defendant Neweman William tailor 588760 588760 Neweman, William, of Dertford, tailor 2
4907597 2328940 2328940 defendant Tailour John   588760 588760 Tailour, John, of Dertford, parish clerk 0
4916216 2331575 2331575 defendant Movelyght Robert husbandman 588760 588760 Movelyght, Robert, of Dertford, husbandman 3
4958523 2344517 2344517 defendant Chapman William butcher 588760 588760 Chapman, William, of Dertford, butcher 3
4961241 2345328 2345328 defendant Isak Geoffrey tailor 588760 588760 Isak, Geoffrey, of Dertford, tailor 1
4961626 2345442 2345442 plaintiff Bost John   588760 588760 Bost, John, of Dertford 0
4968707 2347607 2347607 defendant Bulfand or Bulsand John carpenter 588760 588760 Bulfand or Bulsand, John, of Dertford, carpenter 0
4978442 2350500 2350500 plaintiff Rodeley or Rotheley William   588760 588760 Rodeley or Rotheley, William, of Dertford 0
4978632 2350557 2350557 plaintiff Rotheley William   588760 588760 Rotheley, William, of Dertford 0
4978634 2350558 2350558 plaintiff Rotheley William   588760 588760 Rotheley, William, of Dertford 0
5005019 2358366 2358366 plaintiff Redele William   588760 588760 Redele, William, of Dertford 0
5005638 2358548 2358548 plaintiff Rotheley William   588760 588760 Rotheley, William, of Dertford 0
5015293 2361353 2361353 plaintiff Bost Thomas   588760 588760 Bost, Thomas, of Dertford 0
5015514 2361423 2361423 defendant Lorkyn William tiler 588760 588760 Lorkyn, William, of Dertford, tiler 0
5030295 2365731 2365731 defendant Kyrkeby John husbandman 588760 588760 Kyrkeby, John, of Dertford, husbandman 0
5030421 2365765 2365765 defendant Hardell Lawrence laborer 588760 588760 Hardell, Lawrence, of Dertford, laborer 2
5031791 2366168 2366168 defendant Kyrkeby John husbandman 588760 588760 Kyrkeby, John, of Dertford, husbandman 3
5032034 2366243 2366243 plaintiff Rotheley William   588760 588760 Rotheley, William, of Dertford 0
5035407 2367214 2367214 defendant Laurens Robert waterman 588760 588760 Laurens, Robert, of Dertford, waterman 1
5035408 2367214 2367214 defendant Grey Henry waterman 588760 588760 Grey, Henry, of Dertford, waterman 2
5045177 2370189 2370189 defendant Worth William husbandman 588760 588760 Worth, William, of Dertford, husbandman 1
5046235 2370503 2370503 defendant Grey Henry shipman 588760 588760 Grey, Henry, of Dertford, shipman 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);