names

122 rows where place_id = 586635

✎ 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
3589273 1864285 1864285 defendant Kyng Thomas husbandman 586635 586635 Kyng, Thomas, of Kessynglond, husbandman 1
3596137 1866420 1866420 defendant Caunseller William mariner 586635 586635 Caunseller, William, of Kessynglond, mariner 2
3623710 1874948 1874948 defendant Smyth John chaplain 586635 586635 Smyth, John, of Kessynglond, chaplain 0
3631810 1904755 1904755 defendant Nicoll Richard mariner 586635 586635 Nicoll, Richard, of Kessynglond, mariner 4
3634651 1905636 1905636 defendant Childerous Robert husbandman 586635 586635 Childerous, Robert, of Kessynglond, husbandman 0
3634756 1905668 1905668 plaintiff Mountgomery John   586635 586635 Mountgomery, John, of Kessynglond 0
3646670 1909362 1909362 defendant Walysshe Robert mariner 586635 586635 Walysshe, Robert, of Kessynglond, mariner 0
3691085 1923373 1923373 defendant Walshe Robert mariner 586635 586635 Walshe, Robert, of Kessynglond, mariner 0
3694439 1924466 1924466 defendant Bokenham Robert husbandman 586635 586635 Bokenham, Robert, of Kessynglond, husbandman 0
3694441 1924467 1924467 defendant Bokenham Robert husbandman 586635 586635 Bokenham, Robert, of Kessynglond, husbandman 0
3698327 1925696 1925696 defendant Mychell Richard husbandman 586635 586635 Mychell, Richard, of Kessynglond, husbandman 0
3702901 1927179 1927179 defendant Hasburgh Margery widow 586635 586635 Hasburgh, Margery, of Kessynglond, widow 2
3705431 1927986 1927986 defendant Hewas John husbandman 586635 586635 Hewas, John, of Kessynglond, husbandman 0
3706312 1928261 1928261 defendant Trenchemer William (legal representative) 586635 586635 Trenchemer, William,of Kessynglond, yeoman, executor of 0
3710980 1929749 1929749 defendant Montgomery John yeoman 586635 586635 Montgomery, John, of Kessynglond, yeoman 0
3719208 1932294 1932294 defendant Mongomery John yeoman 586635 586635 Mongomery, John, of Kessynglond, yeoman 0
3724238 1933869 1933869 defendant Mountgomerey John yeoman 586635 586635 Mountgomerey, John, of Kessynglond, yeoman 1
3732483 1936390 1936390 defendant Mongomery John yeoman 586635 586635 Mongomery, John, of Kessynglond, yeoman 0
3734859 1937144 1937144 defendant Cudde Richard mercer 586635 586635 Cudde, Richard, of Kessynglond, mercer 2
3734863 1937145 1937145 defendant Gudde Richard mariner 586635 586635 Gudde, Richard, of Kessynglond, mariner 2
3737805 1938046 1938046 defendant Nuddys Robert husbandman 586635 586635 Nuddys, Robert, of Kessynglond, husbandman 0
3737806 1938046 1938046 defendant Weston John husbandman 586635 586635 Weston, John, of Kessynglond, husbandman 1
3741076 1939071 1939071 defendant Smyth Richard mariner 586635 586635 Smyth, Richard, of Kessynglond, mariner 1
3749507 1941757 1941757 defendant Trenchmer William (legal representative) 586635 586635 Trenchmer, William, of Kessynglond, yeoman, executor of 0
3768109 1947661 1947661 defendant Fayerwether John husbandman 586635 586635 Fayerwether, John, of Kessynglond, husbandman 0
3773971 1949574 1949574 defendant Mongomery John yeoman 586635 586635 Mongomery, John, of Kessynglond, yeoman 1
3778231 1950899 1950899 defendant Edmunde Robert butcher 586635 586635 Edmunde, Robert, of Kessynglond, butcher 0
3793553 1955843 1955843 defendant Clarke Richard husbandman 586635 586635 (Clarke, Richard, of Kessynglond, husbandman 5
3816988 1963221 1963221 defendant Mongomery John yeoman 586635 586635 Mongomery, John, of Kessynglond, yeoman 0
3841223 1970834 1970834 defendant Colt William merchant 586635 586635 Colt, William, of Kessynglond, merchant 0
3848235 1973016 1973016 defendant Trenchmer William (legal representative) 586635 586635 Trenchmer, William, of Kessynglond, yeoman, executor of 0
3852395 1974350 1974350 defendant Hasburgh Nicholas mercer 586635 586635 Hasburgh, Nicholas, of Kessynglond, mercer 0
3886060 1985590 1985590 plaintiff Brame Robert (legal representative) 586635 586635 Brame, Robert, of Kessynglond, executors of 0
3889783 1986821 1986821 defendant Powle John   586635 586635 Powle, John, of Kessynglond, parish clerk 0
3898498 1989711 1989711 defendant Sileham Edward mariner 586635 586635 Sileham, Edward, of Kessynglond, mariner 0
3906033 1992305 1992305 defendant Mungomerey Thomas husbandman 586635 586635 Mungomerey, Thomas, of Kessynglond, husbandman 0
3908405 1993107 1993107 defendant Salowes William yeoman 586635 586635 Salowes, William, of Kessynglond, yeoman 1
3928330 1999810 1999810 defendant Harryson alais Blacamour Roger husbandman 586635 586635 Harryson alais Blacamour, Roger, of Kessynglond, husbandman 1
3934829 2001949 2001949 plaintiff Hullocke Thomas   586635 586635 Hullocke, Thomas, of Kessynglond 0
3963982 2012012 2012012 defendant Brame or Braine William husbandman 586635 586635 Brame or Braine, William, of Kessynglond, husbandman 0
3982934 2018675 2018675 defendant Echyngham Mary widow 586635 586635 Echyngham, Mary, of Kessynglond, widow 0
3982935 2018675 2018675 defendant Echyngham Edward gent 586635 586635 Echyngham, Edward, of Kessynglond, gent 1
4022142 2032648 2032648 defendant Bowyer Robert husbandman 586635 586635 Bowyer, Robert, of Kessynglond, husbandman 0
4045277 2040769 2040769 defendant Davye William husbandman 586635 586635 Davye, William, of Kessynglond, husbandman 0
4474736 2192765 2192765 plaintiff Dunston Henry de (legal representative) 586635 586635 Dunston, Henry de, of Kessynglond, vicar, executors of 0
4474740 2192765 2192765 defendant Megre John   586635 586635 Megre, John, of Kessynglond 1
4483536 2195538 2195538 defendant Salyng alis Alger John   586635 586635 Salyng alis Alger, John, of Kessynglond, vicar 0
4520919 2206881 2206881 defendant Megre Richard   586635 586635 Megre, Richard, of Kessynglond 4
4578143 2224664 2224664 defendant Aleyn John   586635 586635 Aleyn, John, of Kessynglond 7
4599429 2231036 2231036 defendant Aleyn John   586635 586635 Aleyn, John, of Kessynglond 3
4623337 2238270 2238270 plaintiff Megre John   586635 586635 Megre, John, of Kessynglond 0
4623338 2238270 2238270 defendant White John   586635 586635 White, John, of Kessynglond 0
4657883 2248351 2248351 defendant Shanke Henry butcher 586635 586635 Shanke, Henry, of Kessynglond, butcher 0
4657884 2248351 2248351 defendant Bocher Geoffery butcher 586635 586635 Bocher, Geoffery, of Kessynglond, butcher 1
4664949 2250519 2250519 defendant Jeckes Robert ploughman 586635 586635 Jeckes, Robert, of Kessynglond, ploughman 0
4682601 2260177 2260177 defendant Cherchehous Thomas (legal representative) 586635 586635 Cherchehous, Thomas, of Kessynglond, executrix of 0
4733084 2275524 2275524 defendant Draper Thomas draper 586635 586635 Draper, Thomas, of Kessynglond, draper 0
4745416 2279166 2279166 defendant Draper Thomas draper 586635 586635 Draper, Thomas, of Kessynglond, draper 3
4754452 2281771 2281771 defendant Jekkys Robert ploughman 586635 586635 Jekkys, Robert, of Kessynglond, ploughman 1
4802310 2296911 2296911 defendant Cane John butcher 586635 586635 Cane, John, of Kessynglond, butcher 1
4807394 2298509 2298509 defendant Betys John yeoman 586635 586635 Betys, John, of Kessynglond, yeoman 0
4809520 2299148 2299148 defendant Chaummbyrleyn John yeoman 586635 586635 Chaummbyrleyn, John, of Kessynglond, yeoman 0
4809521 2299148 2299148 defendant Betys John yeoman 586635 586635 Betys, John, of Kessynglond, yeoman 1
4809522 2299148 2299148 defendant Cave or Cane John butcher 586635 586635 Cave or Cane, John, of Kessynglond, butcher 2
4814236 2300555 2300555 defendant Betys John yeoman 586635 586635 Betys, John, of Kessynglond, yeoman 3
4837050 2307546 2307546 defendant Herward Thomas yeoman 586635 586635 Herward, Thomas, of Kessynglond, yeoman 0
4850663 2311664 2311664 defendant Talmage Thomas chapman 586635 586635 Talmage, Thomas, of Kessynglond, chapman 0
4891858 2324189 2324189 defendant Sexteyn Thomas husbandman 586635 586635 Sexteyn, Thomas, of Kessynglond, husbandman 1
4954575 2343325 2343325 defendant Jekkys Robert husbandman 586635 586635 Jekkys, Robert, of Kessynglond, husbandman 1
5007132 2358974 2358974 defendant Stronder Henry husbandman 586635 586635 Stronder, Henry, of Kessynglond, husbandman 0
5007133 2358974 2358974 defendant Man John butcher 586635 586635 Man, John, of Kessynglond, butcher 1
5007284 2359025 2359025 plaintiff Kaunceler Robert   586635 586635 Kaunceler, Robert, of Kessynglond 1
5007285 2359025 2359025 plaintiff Myghhell Thomas   586635 586635 Myghhell, Thomas, of Kessynglond 2
5007286 2359025 2359025 plaintiff Mowset Richard   586635 586635 Mowset, Richard, of Kessynglond 3
5007287 2359025 2359025 plaintiff Tylle John   586635 586635 Tylle, John, of Kessynglond 4
5021463 2363186 2363186 defendant Sperlyng John clerk 586635 586635 Sperlyng, John, of Kessynglond, clerk 0
5028012 2365072 2365072 defendant Hakun John smith 586635 586635 Hakun, John, of Kessynglond, smith 1
5041306 2369007 2369007 defendant Steyngate John husbandman 586635 586635 Steyngate, John, of Kessynglond, husbandman 1
5063218 2375530 2375530 defendant Aylesham John shipman 586635 586635 Aylesham, John, of Kessynglond, shipman 0
5063219 2375530 2375530 defendant Palmer William shipman 586635 586635 Palmer, William, of Kessynglond, shipman 1
5063220 2375530 2375530 defendant Hokeryng Richard shipman 586635 586635 Hokeryng, Richard, of Kessynglond, shipman 2
5068984 2377218 2377218 defendant Godewyn William butcher 586635 586635 Godewyn, William, of Kessynglond, butcher 0
5078813 2380151 2380151 plaintiff Bryght John shipman 586635 586635 Bryght, John, of Kessynglond, shipman 0
5083836 2381667 2381667 defendant Godewene William butcher 586635 586635 Godewene, William,of Kessynglond, butcher 0
5092731 2384255 2384255 defendant Grey Nicholas cordwainer 586635 586635 Grey, Nicholas, of Kessynglond, cordwainer 0
5097246 2385623 2385623 defendant Sparhauk John baker 586635 586635 Sparhauk, John, of Kessynglond, baker 1
5130975 2395542 2395542 defendant Tulyard Richard husbandman 586635 586635 Tulyard, Richard, of Kessynglond, husbandman 1
5232508 2425088 2425088 defendant Syleham John husbandman 586635 586635 Syleham, John, of Kessynglond, husbandman 0
5238590 2426878 2426878 defendant Furbyshour John husbandman 586635 586635 Furbyshour, John, of Kessynglond, husbandman 0
5251260 2430497 2430497 defendant Olderyng Alexander husbandman 586635 586635 Olderyng, Alexander, of Kessynglond, husbandman 0
5278228 2438729 2438729 defendant Oldryng Thomas barker 586635 586635 Oldryng, Thomas, of Kessynglond, barker 0
5284897 2440604 2440604 defendant Blaksale Thomas cooper 586635 586635 Blaksale, Thomas, of Kessynglond, cooper 0
5286863 2441161 2441161 defendant Fysshe Richard mariner 586635 586635 Fysshe, Richard, of Kessynglond, mariner 2
5298407 2444510 2444510 defendant Oldyng Thomas tanner 586635 586635 Oldyng, Thomas, of Kessynglond, tanner 0
5350788 2460357 2460357 defendant Hunte John shoemaker 586635 586635 Hunte, John, of Kessynglond, shoemaker 1
5350789 2460357 2460357 defendant Betany Nicholas mariner 586635 586635 Betany, Nicholas, of Kessynglond, mariner 2
5350790 2460357 2460357 defendant Aylesham Robert mariner 586635 586635 Aylesham, Robert, of Kessynglond, mariner 3
5350989 2460422 2460422 defendant Lound Adam baker 586635 586635 Lound, Adam, of Kessynglond, baker 0
5368235 2465690 2465690 defendant Wylde Robert husbandman 586635 586635 Wylde, Robert, of Kessynglond, husbandman 1
5423390 2481955 2481955 defendant Oldryng Thomas husbandman 586635 586635 Oldryng, Thomas, of Kessynglond, 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);