names

269 rows where place_id = 586447

✎ 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
3588744 1864123 1864123 defendant Hunt John husbandman 586447 586447 Hunt, John, of West Mallyng, husbandman 1
3592277 1865198 1865198 defendant Botiller John gent 586447 586447 Botiller, John, of West Mallyng, gent 1
3594218 1865832 1865832 defendant Sawyer Thomas   586447 586447 Sawyer, Thomas, of West Mallyng, tallow chandler 2
3594222 1865833 1865833 defendant Sawyer Thomas   586447 586447 Sawyer, Thomas, of West Mallyng, tallow chandler 2
3599317 1867431 1867431 plaintiff Towe alias Gowe Thomas gent 586447 586447 Towe alias Gowe, Thomas, of West Mallyng, gent 0
3600740 1867888 1867888 defendant Whate Simon husbandman 586447 586447 Whate, Simon, of West Mallyng, husbandman 0
3600741 1867888 1867888 defendant Hoo William cordwainer 586447 586447 Hoo, William, of West Mallyng, cordwainer 1
3601992 1868283 1868283 plaintiff Bore John   586447 586447 Bore, John, of West Mallyng 0
3604562 1869091 1869091 defendant Hunt John husbandman 586447 586447 Hunt, John, of West Mallyng, husbandman 0
3606424 1869677 1869677 defendant Hunt John husbandman 586447 586447 Hunt, John, of West Mallyng, husbandman 0
3606427 1869678 1869678 plaintiff Myllys William yeoman or parchment maker 586447 586447 Myllys, William, of West Mallyng, yeoman or parchment maker 0
3609043 1870485 1870485 defendant Hunt John husbandman 586447 586447 Hunt, John, of West Mallyng, husbandman 0
3610407 1870913 1870913 defendant Hobyll Edmund sherman 586447 586447 Hobyll, Edmund, of West Mallyng, sherman 0
3610409 1870914 1870914 defendant Hobyll Edmund sherman 586447 586447 Hobyll, Edmund, of West Mallyng, sherman 0
3615537 1872499 1872499 defendant Sharpe Thomas laborer 586447 586447 Sharpe, Thomas, of West Mallyng, laborer 0
3618372 1873377 1873377 defendant Hoo William smith 586447 586447 Hoo, William, of West Mallyng, smith 2
3621047 1874139 1874139 defendant William John husbandman 586447 586447 William, John, of West Mallyng, husbandman 0
3621049 1874140 1874140 defendant William John husbandman 586447 586447 William, John, of West Mallyng, husbandman 0
3624981 1875344 1875344 defendant Sharpe Thomas laborer 586447 586447 Sharpe, Thomas, of West Mallyng, laborer 0
3636970 1906359 1906359 defendant Prentyse John tailor 586447 586447 Prentyse, John, of West Mallyng, tailor 0
3643752 1908474 1908474 plaintiff Dawson John   586447 586447 Dawson, John, of West Mallyng 0
3667271 1915700 1915700 defendant Myllys Robert (legal representative) 586447 586447 Myllys, Robert, of West Mallyng, gent, executrix of 0
3667272 1915700 1915700 defendant Myllys Margaret widow 586447 586447 Myllys, Margaret, of West Mallyng, widow 1
3676179 1918594 1918594 defendant Fremon Edward husbandman 586447 586447 Fremon, Edward, of West Mallyng, husbandman 1
3681652 1920356 1920356 defendant Smyth Thomas cordwainer 586447 586447 Smyth, Thomas, of West Mallyng, cordwainer 3
3683987 1921124 1921124 defendant Milles Robert (legal representative) 586447 586447 Milles, Robert, of West Mallyng, gent, executors of 0
3687336 1922218 1922218 defendant Bogherst John yeoman 586447 586447 Bogherst, John, of West Mallyng, yeoman 1
3688375 1922520 1922520 defendant Giles Thomas tiler 586447 586447 Giles, Thomas, of West Mallyng, tiler 0
3693977 1924318 1924318 defendant Huntwyke Robert shoemaker 586447 586447 Huntwyke, Robert, of West Mallyng, shoemaker 3
3693991 1924323 1924323 plaintiff Millys Robert (legal representative) 586447 586447 Millys, Robert, of West mallyng, yeoman, executors of 0
3698009 1925602 1925602 defendant Hykmott Nicholas baker 586447 586447 Hykmott, Nicholas, of West Mallyng, baker 2
3702757 1927133 1927133 defendant Claygate Geoffrey tailor 586447 586447 Claygate, Geoffrey, of West Mallyng, tailor 0
3708246 1928874 1928874 plaintiff Myllys Robert (legal representative) 586447 586447 Myllys, Robert, of West Mallyng, executors of 0
3716870 1931564 1931564 defendant Hykmote Nicholas shoemaker 586447 586447 Hykmote, Nicholas, of West Mallyng, shoemaker 2
3731438 1936058 1936058 defendant Catlyn Joyce widow 586447 586447 Catlyn, Joyce, of West Mallyng, widow 0
3731440 1936059 1936059 defendant Catlyn Joyce widow 586447 586447 Catlyn, Joyce, of West Mallyng, widow 0
3731442 1936060 1936060 defendant Colbrond Thomas gent 586447 586447 Colbrond, Thomas, of West Mallyng, gent 0
3731443 1936060 1936060 defendant Scath William tailor 586447 586447 Scath, William, of West Mallyng, tailor 1
3731444 1936060 1936060 defendant Lyndall Robert   586447 586447 Lyndall, Robert, of West Mallyng, groom 2
3731446 1936061 1936061 defendant Colbrond Thomas gent 586447 586447 Colbrond, Thomas, of West Mallyng, gent 0
3732491 1936392 1936392 defendant Hyllys Richard baker 586447 586447 Hyllys, Richard, of West Mallyng, baker 0
3732545 1936408 1936408 defendant Hykmote Nicholas shoemaker 586447 586447 Hykmote, Nicholas, of West Mallyng, shoemaker 0
3748680 1941514 1941514 defendant Hikmott Nicholas yeoman 586447 586447 Hikmott, Nicholas, of West Mallyng, yeoman 0
3762360 1945869 1945869 defendant Stephynson William yeoman 586447 586447 Stephynson, William, of West Mallyng, yeoman 0
3762361 1945869 1945869 defendant Style John shoemaker 586447 586447 Style, John, of West Mallyng, shoemaker 1
3762362 1945869 1945869 defendant Hykmote Nicholas shoemaker 586447 586447 Hykmote, Nicholas, of West Mallyng, shoemaker 2
3764201 1946455 1946455 defendant Saunder Thomas yeoman 586447 586447 Saunder, Thomas, of West Mallyng, yeoman 0
3782185 1952179 1952179 defendant Saunders Thomas husbandman 586447 586447 Saunders, Thomas, of West Mallyng, husbandman 4
3790789 1954947 1954947 defendant Hickmoll Nicholas yeoman 586447 586447 Hickmoll, Nicholas, of West Mallyng, yeoman 0
3790791 1954947 1954947 defendant Claygat Geoffrey tailor 586447 586447 Claygat, Geoffrey, of West Mallyng, tailor 2
3790795 1954948 1954948 defendant Hickmot Nicholas yeoman 586447 586447 Hickmot, Nicholas, of West Mallyng, yeoman 0
3790797 1954948 1954948 defendant Claygat Geoffrey tailor 586447 586447 Claygat, Geoffrey, of West Mallyng, tailor 2
3790802 1954949 1954949 defendant Hykmot Nicholas yeoman 586447 586447 (Hykmot, Nicholas, of West Mallyng, yeoman 1
3790807 1954950 1954950 defendant Hykmott Nicholas yeoman 586447 586447 Hykmott, Nicholas, of West Mallyng, yeoman 0
3807117 1960118 1960118 defendant Hykmotte Nicholas yeoman 586447 586447 Hykmotte, Nicholas, of West Mallyng, yeoman 0
3816898 1963190 1963190 defendant Dank William husbandman 586447 586447 Dank, William, of West Mallyng, husbandman 1
3820799 1964395 1964395 defendant Lylly William tailor or yeoman 586447 586447 Lylly, William, of West Mallyng, tailor or yeoman 0
3821106 1964495 1964495 defendant Hasylle Richard butcher 586447 586447 Hasylle, Richard, of West Mallyng, butcher 0
3824667 1965589 1965589 defendant Howe John yeoman 586447 586447 Howe, John, of West Mallyng, yeoman 0
3824672 1965590 1965590 defendant Saunder Thomas yeoman 586447 586447 Saunder, Thomas, of West Mallyng, yeoman 3
3839392 1970243 1970243 defendant Cokke Richard butcher 586447 586447 Cokke, Richard, of West Mallyng, butcher 1
3839393 1970243 1970243 defendant Lylly John glover 586447 586447 Lylly, John, of West Mallyng, glover 2
3859566 1976690 1976690 plaintiff Claygat Geoffrey (legal representative) 586447 586447 Claygat, Geoffrey, of West Mallyng, administratrix of 0
3860113 1976879 1976879 defendant Style John shoemaker 586447 586447 Style, John, of West Mallyng, shoemaker 1
3865016 1978500 1978500 defendant Lurchyn William husbandman 586447 586447 Lurchyn, William, of West Mallyng, husbandman 0
3865017 1978500 1978500 defendant Baby John laborer 586447 586447 Baby, John, of West Mallyng, laborer 1
3881916 1984208 1984208 defendant Dene William tanner 586447 586447 Dene, William, of West Mallyng, tanner 0
3884897 1985221 1985221 defendant Style John shoemaker 586447 586447 Style, John, of West Mallyng, shoemaker 2
3884903 1985222 1985222 defendant Style John shoemaker 586447 586447 Style, John, of West Mallyng, shoemaker 2
3896813 1989146 1989146 defendant Skathe William tailor 586447 586447 Skathe, William, of West Mallyng, tailor 0
3896814 1989146 1989146 defendant Godfrey Nicholas butcher 586447 586447 Godfrey, Nicholas, of West Mallyng, butcher 1
3896815 1989146 1989146 defendant Style John shoemaker 586447 586447 Style, John, of West Mallyng, shoemaker 2
3996588 2023539 2023539 defendant Claygate Robert yeoman 586447 586447 Claygate, Robert, of West Mallyng, yeoman 0
4002995 2025832 2025832 defendant Claygatt Robert, senior yeoman 586447 586447 Claygatt, Robert, senior, of West Mallyng, yeoman 0
4009974 2028333 2028333 defendant Bennett William yeoman 586447 586447 Bennett, William, of West Mallyng, yeoman 0
4325041 2138758 2138758 defendant Chowninge Edward shoemaker 586447 586447 Chowninge, Edward, of West Mallyng, shoemaker 1
4586412 2227165 2227165 defendant Rokeslee John   586447 586447 Rokeslee, John, of West Mallyng 1
4607621 2233494 2233494 defendant Sprot William   586447 586447 Sprot, William, of West Mallyng 0
4612179 2234876 2234876 defendant Sprot William   586447 586447 Sprot, William, of West Mallyng 0
4612183 2234877 2234877 defendant Taillour William   586447 586447 Taillour, William, of West Mallyng 0
4623413 2238296 2238296 defendant Rokesle John tailor 586447 586447 Rokesle, John, of West Mallyng, tailor 0
4626482 2239231 2239231 defendant Clerk William   586447 586447 Clerk, William, of West Mallyng 0
4631003 2240591 2240591 defendant Sprot William   586447 586447 Sprot, William, of West Mallyng 1
4644995 2244609 2244609 defendant Hoo John   586447 586447 Hoo, John, of West Mallyng 2
4672904 2257165 2257165 defendant Sextayn William husbandman 586447 586447 Sextayn, William, of West Mallyng, husbandman 0
4675081 2257816 2257816 defendant Draper Thomas husbandman 586447 586447 Draper, Thomas, of West Mallyng, husbandman 0
4675082 2257816 2257816 defendant Proturatour John husbandman 586447 586447 Proturatour, John, of West Mallyng, husbandman 1
4675083 2257816 2257816 defendant Pardoner Roger pardoner 586447 586447 with Pardoner, Roger, of West Mallyng, pardoner 2
4679298 2259136 2259136 defendant Michelot Nicholas weaver 586447 586447 Michelot, Nicholas, of West Mallyng, weaver 0
4679299 2259136 2259136 defendant Michelot John carpenter 586447 586447 Michelot, John, of West Mallyng, carpenter 1
4680535 2259524 2259524 defendant Dyne Henry husbandman 586447 586447 Dyne, Henry, of West Mallyng, husbandman 0
4680536 2259524 2259524 defendant Kene Richard yeoman 586447 586447 Kene, Richard, of West Mallyng, yeoman 1
4680537 2259524 2259524 defendant Rokesley John tailor 586447 586447 Rokesley, John, of West Mallyng, tailor 2
4681290 2259774 2259774 defendant Kyne Richard husbandman 586447 586447 Kyne, Richard, of West Mallyng, husbandman 0
4689899 2262396 2262396 plaintiff Wardon John   586447 586447 Wardon, John, of West Mallyng 0
4689903 2262397 2262397 plaintiff Wardon John   586447 586447 Wardon, John, of West Mallyng 0
4689905 2262397 2262397 defendant Sexteyn William husbandman 586447 586447 Sexteyn, William, of West Mallyng, husbandman 0
4690146 2262473 2262473 defendant Duraunt Richard porter 586447 586447 Duraunt, Richard, of West Mallyng, porter 1
4690147 2262473 2262473 defendant Sextayn John husbandman 586447 586447 Sextayn, John, of West Mallyng, husbandman 2
4690319 2262528 2262528 defendant Hayton Roger husbandman 586447 586447 Hayton, Roger, of West Mallyng, husbandman 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);