names

86 rows where place_id = 621854

✎ 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
3743984 1940008 1940008 defendant Jacob Thomas husbandman 621854 621854 Jacob, Thomas, of Iselham, husbandman 0
3756035 1943843 1943843 defendant Jacob Thomas husbandman 621854 621854 Jacob, Thomas, of Iselham, husbandman 0
3778802 1951088 1951088 defendant Akent Robert husbandman 621854 621854 Akent, Robert, of Iselham, husbandman 1
3802715 1958746 1958746 plaintiff Peyton Robert   621854 621854 Peyton, Robert, of Iselham, knight 0
3819977 1964128 1964128 plaintiff Payton Robert   621854 621854 Payton, Robert, of Iselham, knight 0
3849604 1973465 1973465 defendant Reve Thomas   621854 621854 Reve, Thomas, of Iselham, wax chandler 2
3855524 1975371 1975371 defendant Lambart William husbandman 621854 621854 Lambart, William, of Iselham, husbandman 0
3977290 2016628 2016628 plaintiff Peyton Robert esq 621854 621854 Peyton, Robert, of Iselham, esq 1
3997151 2023749 2023749 defendant Edward Francis husbandman 621854 621854 Edward, Francis, of Iselham, husbandman 2
3997155 2023750 2023750 defendant Edwardes Francis husbandman 621854 621854 Edwardes, Francis, of Iselham, husbandman 2
4019896 2031848 2031848 defendant Sare Robert husbandman 621854 621854 Sare, Robert, of Iselham, or of Strettam, Isle of Ely, husbandman 0
4020207 2031950 2031950 defendant Wyatt Henry husbandman 621854 621854 Wyatt, Henry, of Iselham, husbandman 0
4020208 2031950 2031950 defendant Dawson John husbandman 621854 621854 Dawson, John, of Iselham, husbandman 1
4061174 2046405 2046405 defendant Jacobbe Philip husbandman 621854 621854 Jacobbe, Philip, of Iselham, husbandman 1
4088735 2056272 2056272 defendant Furbancke William cooper 621854 621854 Furbancke, William, of Iselham, cooper 0
4088736 2056272 2056272 defendant Cowper William butcher 621854 621854 Cowper, William, of Iselham, butcher 1
4204680 2097184 2097184 defendant Carter Thomas husbandman 621854 621854 Carter, Thomas, of Iselham, husbandman 0
4271678 2120109 2120109 defendant Leache Miles husbandman 621854 621854 Leache, Miles, of Iselham, or of Kennett, Cams, husbandman 0
4299432 2129888 2129888 defendant Casborne Richard husbandman 621854 621854 Casborne, Richard, of Iselham, husbandman 0
4347307 2146313 2146313 defendant Cropley Richard yeoman 621854 621854 Cropley, Richard, of Iselham, yeoman 1
4347308 2146313 2146313 defendant Jacob John yeoman 621854 621854 Jacob, John, of Iselham, yeoman 2
4347309 2146313 2146313 defendant Trowell Henry yeoman 621854 621854 Trowell, Henry, of Iselham, yeoman 3
4347310 2146313 2146313 defendant Whytley Richard yeoman 621854 621854 Whytley, Richard, of Iselham, yeoman 4
4352469 2148100 2148100 defendant Prigge James husbandman 621854 621854 Prigge, James, of Iselham, husbandman 2
4513620 2204685 2204685 defendant Fokes Robert   621854 621854 Fokes, Robert, of Iselham 0
4693959 2263619 2263619 defendant Wygenale William gent 621854 621854 Wygenale, William, of Iselham, gent 0
4693962 2263620 2263620 defendant Lylye John (legal representative) 621854 621854 Lylye, John, of Iselham, executors of 0
4693963 2263620 2263620 defendant Lylye John chapman 621854 621854 (Lylye, John, of Iselham, chapman 1
4693964 2263620 2263620 defendant Lylye Robert husbandman 621854 621854 Lylye, Robert, of Iselham, husbandman 2
4693966 2263621 2263621 defendant Knyghlee John husbandman 621854 621854 Knyghlee, John, of iselham, husbandman 0
4693967 2263621 2263621 defendant Flaumar Laurence husbandman 621854 621854 Flaumar, Laurence, of Iselham, husbandman 1
4693968 2263621 2263621 defendant Foulere Robert husbandman 621854 621854 Foulere, Robert, of Iselham, husbandman 2
4700304 2265511 2265511 defendant Lylye John mercer 621854 621854 Lylye, John, of Iselham, mercer 0
4701347 2265823 2265823 defendant Bernard John clerk 621854 621854 Bernard, John, of Iselham, clerk 0
4709131 2268221 2268221 defendant Bernard John clerk 621854 621854 Bernard, John, of Iselham, clerk 1
4709913 2268459 2268459 defendant Flawener Laurence husbandman 621854 621854 Flawener, Laurence, of Iselham, husbandman 1
4709914 2268459 2268459 defendant Walbot John husbandman 621854 621854 Walbot, John, of Iselham, husbandman 2
4712178 2269120 2269120 defendant Bernard John clerk 621854 621854 Bernard, John, of Iselham, clerk 0
4712184 2269122 2269122 defendant Bernard Denis yeoman 621854 621854 Bernard, Denis, of Iselham, servant of Bernard, yeoman 0
4719235 2271364 2271364 defendant Bertram Nicholas yeoman 621854 621854 Bertram, Nicholas, of Iselham, yeoman 0
4719236 2271364 2271364 defendant Sokirman Robert yeoman 621854 621854 Sokirman, Robert, of Iselham, yeoman 1
4734737 2276019 2276019 defendant Bernard John clerk 621854 621854 Bernard, John, of Iselham, clerk 0
4738061 2277006 2277006 defendant Wardon William clerk 621854 621854 Wardon, William, of Iselham, clerk 0
4753468 2281463 2281463 defendant Hampton Thomas gent 621854 621854 Hampton, Thomas, of Iselham, gent 0
4753469 2281463 2281463 defendant Bernard Thomas husbandman 621854 621854 Bernard, Thomas, of Iselham, husbandman 1
4753470 2281463 2281463 defendant Somery Gilbert yeoman 621854 621854 Somery, Gilbert, of Iselham, yeoman 2
4756612 2282432 2282432 defendant Bertram Nicholas yeoman 621854 621854 Bertram, Nicholas, of Iselham, yeoman 0
4757203 2282622 2282622 plaintiff Borle John   621854 621854 Borle, John, of Iselham 0
4757205 2282623 2282623 plaintiff Borle John   621854 621854 Borle, John, of Iselham 0
4767025 2285676 2285676 plaintiff Lyly John   621854 621854 Lyly, John, of Iselham 0
4769289 2286372 2286372 defendant Wardon William chaplain 621854 621854 Wardon, William, of Iselham, chaplain 1
4769669 2286488 2286488 defendant Fraunceys John husbandman 621854 621854 Fraunceys, John, of Iselham, husbandman 3
4779199 2289470 2289470 defendant Lylye Robert husbandman 621854 621854 Lylye, Robert, of Iselham, husbandman 0
4779201 2289471 2289471 defendant Lylye Robert husbandman 621854 621854 Lylye, Robert, of Iselham, husbandman 0
4788512 2292468 2292468 defendant Bernard John clerk 621854 621854 Bernard, John, of Iselham, clerk 0
4791374 2293395 2293395 defendant Lelye John husbandman 621854 621854 Lelye, John, of Iselham, husbandman 4
4791381 2293396 2293396 defendant Lelye John husbandman 621854 621854 Lelye, John, of Iselham, husbandman 4
4816849 2301374 2301374 defendant Dowene Gilbert husbandman 621854 621854 Dowene, Gilbert, of Iselham, husbandman 0
4819340 2302124 2302124 defendant Lelye John chapman 621854 621854 Lelye, John, of Iselham, chapman 0
4832137 2306081 2306081 defendant fitz Piers Thomas gent 621854 621854 fitz Piers, Thomas, of Iselham, gent 0
4845788 2310193 2310193 defendant Lylye John yeoman 621854 621854 Lylye, John, of Iselham, yeoman 0
4846224 2310322 2310322 defendant Lylly John chapman 621854 621854 Lylly, John, of Iselham, chapman 0
4846225 2310323 2310323 plaintiff Polyt Walter   621854 621854 Polyt, Walter, of Iselham, formerly vicar 0
4852450 2312182 2312182 defendant Woberne Richard yeoman 621854 621854 Woberne, Richard, of Iselham, yeoman 0
4852667 2312254 2312254 defendant Boteler William husbandman 621854 621854 Boteler, William, of Iselham, husbandman 0
4852668 2312254 2312254 defendant Fuller Henry husbandman 621854 621854 Fuller, Henry, of Iselham, husbandman 1
4858842 2314143 2314143 defendant Bernard John clerk 621854 621854 Bernard, John, of Iselham, clerk 0
4858970 2314184 2314184 defendant Irmynglond William gent 621854 621854 Irmynglond, William, of Iselham, gent 0
4873419 2318644 2318644 defendant Lylye John yeoman 621854 621854 Lylye, John, of Iselham, yeoman 0
4873817 2318749 2318749 defendant Lylly John chapman 621854 621854 Lylly, John, of Iselham, chapman 0
4873848 2318759 2318759 defendant Irmynglond William gent 621854 621854 Irmynglond, William, of Iselham, gent 0
4903299 2327640 2327640 defendant Wardon William   621854 621854 Wardon, William, of Iselham, parson of Frekynham, Suff 0
4903300 2327640 2327640 defendant Dowe Gilbert husbandman 621854 621854 Dowe, Gilbert, of Iselham, husbandman 1
4903301 2327640 2327640 defendant Helgey John husbandman 621854 621854 Helgey, John, of Iselham, husbandman 2
4903302 2327640 2327640 defendant Lylye John husbandman 621854 621854 Lylye, John, of Iselham, husbandman 3
4911760 2330177 2330177 defendant Helgey John husbandman 621854 621854 Helgey, John, of Iselham, husbandman 2
4953215 2342921 2342921 defendant Drenchard William   621854 621854 Drenchard, William, of Iselham, shepherd 0
4953217 2342922 2342922 defendant Lone of Love John husbandman 621854 621854 Lone of Love, John, of Iselham, husbandman 0
4953219 2342923 2342923 defendant Love or Lone John husbandman 621854 621854 Love or Lone, John, of Iselham, husbandman 0
4953220 2342923 2342923 defendant Dranchard William   621854 621854 Dranchard, William, of Iselham, shepherd 1
5123649 2393375 2393375 defendant Sokyrman John butcher 621854 621854 Sokyrman, John, of Iselham, butcher 1
5329095 2453782 2453782 defendant Borley William gent 621854 621854 Borley, William, of Iselham, gent 1
5341006 2457388 2457388 plaintiff Peyton Thomas esq 621854 621854 Peyton, Thomas, of Iselham, esq 0
5499246 2504720 2504720 defendant Dow Thomas, senior husbandman 621854 621854 Dow, Thomas, senior, of Iselham, husbandman 0
5499247 2504720 2504720 defendant Barnard John husbandman 621854 621854 Barnard, John, of Iselham, husbandman 1
5522585 2511887 2511887 defendant Brandon William husbandman 621854 621854 Brandon, William, of Iselham, husbandman 2

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