names

199 rows where place_id = 586305

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588394 1864019 1864019 defendant Courby Nicholas husbandman 586305 586305 Courby, Nicholas, of Fordham, husbandman 1
3603232 1868680 1868680 defendant Savage William husbandman 586305 586305 Savage, William, of Fordham, husbandman 0
3604069 1868941 1868941 defendant Jenyn Roger husbandman 586305 586305 Jenyn, Roger, of Fordham, husbandman 2
3624468 1875188 1875188 defendant Fawene Thomas husbandman 586305 586305 Fawene, Thomas, of Fordham, husbandman 2
3624472 1875189 1875189 defendant Fawene Thomas husbandman 586305 586305 Fawene, Thomas, of Fordham, husbandman 2
3667906 1915902 1915902 defendant Swan William husbandman 586305 586305 Swan, William, of Fordham, husbandman 2
3672658 1917450 1917450 defendant Stowe John husbandman 586305 586305 Stowe, John, of Fordham, husbandman 0
3673024 1917570 1917570 defendant Symond Patrick laborer 586305 586305 Symond, Patrick, of Fordham, laborer 1
3687321 1922214 1922214 defendant Bray John husbandman 586305 586305 Bray, John, of Fordham, husbandman 0
3691261 1923425 1923425 defendant Lovet Richard husbandman 586305 586305 Lovet, Richard, of Fordham, husbandman 0
3691262 1923425 1923425 defendant Wynte Thomas husbandman 586305 586305 Wynte, Thomas, of Fordham, husbandman 1
3691265 1923425 1923425 defendant Akeris John butcher 586305 586305 Akeris, John, of Fordham, butcher 4
3691494 1923496 1923496 defendant Pope Nicholas (legal representative) 586305 586305 Pope, Nicholas, of Fordham, miller, administratrix of 1
3691495 1923496 1923496 defendant Pope Alice widow 586305 586305 Pope, Alice, of Fordham, widow 2
3691507 1923501 1923501 defendant Pope Nicholas (legal representative) 586305 586305 Pope, Nicholas, of Fordham, administratrix of 1
3691508 1923501 1923501 defendant Pope Alice widow 586305 586305 Pope, Alice, of Fordham, widow 2
3691511 1923502 1923502 defendant Pope Nicholas (legal representative) 586305 586305 Pope, Nicholas, of Fordham, miller, administratrix of 1
3691512 1923502 1923502 defendant Pope Alice widow 586305 586305 Pope, Alice, of Fordham, widow 2
3706170 1928221 1928221 defendant Aleyn John butcher 586305 586305 Aleyn, John, of Fordham, butcher 2
3713583 1930558 1930558 defendant Cokkys William yeoman 586305 586305 Cokkys, William, of Fordham, yeoman 0
3726578 1934569 1934569 defendant Nevett Richard husbandman 586305 586305 Nevett, Richard, of Fordham, husbandman 1
3734457 1937020 1937020 defendant Man Roger husbandman 586305 586305 Man, Roger, of Fordham, husbandman 3
3734458 1937020 1937020 defendant Holand John husbandman 586305 586305 Holand, John, of Fordham, husbandman 4
3744498 1940181 1940181 defendant Alowe Ralph drover 586305 586305 Alowe, Ralph, of Fordham, drover 1
3744499 1940181 1940181 defendant Alowe Randolph drover 586305 586305 Alowe, Randolph, of Fordham, drover 2
3779196 1951214 1951214 defendant Stowe Roger husbandman 586305 586305 Stowe, Roger, of Fordham, husbandman 2
3794539 1956171 1956171 defendant Baker Geoffrey husbandman 586305 586305 Baker, Geoffrey, of Fordham, husbandman 2
3814599 1962477 1962477 defendant Vynt Thomas husbandman 586305 586305 Vynt, Thomas, of Fordham, husbandman 1
3878725 1983134 1983134 defendant Benson William yeoman 586305 586305 Benson, William, of Fordham, yeoman 0
3904060 1991600 1991600 defendant Holond John laborer 586305 586305 Holond, John, of Fordham, laborer 2
3905174 1991994 1991994 plaintiff Jerves Philip roper 586305 586305 Jerves, Philip, of Fordham, roper 0
3973057 2015146 2015146 defendant Motte Thomas husbandman 586305 586305 Motte, Thomas, of Fordham, husbandman 3
4015094 2030088 2030088 defendant Erlonde Salmon husbandman 586305 586305 Erlonde, Salmon, of Fordham, husbandman 0
4027851 2034608 2034608 defendant Flyngant George yeoman 586305 586305 Flyngant, George, of Fordham, yeoman 0
4075366 2051493 2051493 defendant Smythe George esq 586305 586305 Smythe, George, of Fordham, or of Pentlowe, Essex, esq 0
4113846 2065237 2065237 defendant Barrett Leonard (legal representative) 586305 586305 Barrett, Leonard, of Fordham, gent, executrix of 0
4113847 2065237 2065237 defendant Barrett Joan widow 586305 586305 Barrett, Joan, of Fordham, widow 1
4121581 2068012 2068012 defendant Ungley John miller 586305 586305 Ungley, John, of Fordham, miller 0
4136630 2073444 2073444 defendant Parker George husbandman 586305 586305 Parker, George, of Fordham, husbandman 0
4204681 2097184 2097184 defendant Graystoke Henry thatcher 586305 586305 Graystoke, Henry, of Fordham, thatcher 1
4255949 2114964 2114964 defendant Ravensdayle John yeoman 586305 586305 Ravensdayle, John, of Fordham, yeoman 2
4305350 2132012 2132012 defendant Grayve John yeoman 586305 586305 Grayve, John, of Fordham, yeoman, son of John Grayve, senior, yeoman 0
4352460 2148098 2148098 defendant Cornewell Stephen laborer 586305 586305 Cornewell, Stephen, of Fordham, laborer 3
4352467 2148100 2148100 defendant Randall Hillary carpenter 586305 586305 Randall, Hillary, of Fordham, carpenter 0
4383405 2159161 2159161 defendant Duke Isaac yeoman 586305 586305 Duke, Isaac, of Fordham, yeoman 1
4383409 2159162 2159162 defendant Newton Joshua yeoman 586305 586305 Newton, Joshua, of Fordham, yeoman 1
4390913 2161574 2161574 defendant Chamberlyne John husbandman 586305 586305 Chamberlyne, John, of Fordham, husbandman 1
4413978 2169277 2169277 plaintiff Chaus or Chans John   586305 586305 Chaus or Chans, John, of Fordham 0
4415285 2169675 2169675 defendant Notehale Thomas   586305 586305 Notehale, Thomas, of Fordham 0
4417210 2170260 2170260 defendant atte Crosse Simon, junior   586305 586305 atte Crosse, Simon, junior, of Fordham 2
4419311 2170923 2170923 plaintiff Barkere Henry le   586305 586305 Barkere, Henry le, of Fordham 0
4420475 2171310 2171310 defendant Cok John   586305 586305 Cok, John, of Fordham 3
4434923 2175682 2175682 defendant Not William   586305 586305 Not, William, of Fordham 0
4434926 2175683 2175683 defendant Not William   586305 586305 Not, William, of Fordham 0
4441726 2182350 2182350 plaintiff Brampton John   586305 586305 Brampton, John, of Fordham 0
4441728 2182350 2182350 defendant Brampton William   586305 586305 Brampton, William, of Fordham 0
4443455 2182915 2182915 defendant Martyn William   586305 586305 Martyn, William, of Fordham 0
4443456 2182915 2182915 defendant Gerard William   586305 586305 Gerard, William, of Fordham 1
4448202 2184356 2184356 plaintiff fitz Piers John   586305 586305 fitz Piers, John, of Fordham 0
4454209 2186332 2186332 plaintiff Lucas John   586305 586305 Lucas, John, of Fordham 0
4458684 2187760 2187760 plaintiff Rede Thomas   586305 586305 Rede, Thomas, of Fordham 0
4469659 2191177 2191177 defendant Fraunceys Thomas   586305 586305 Fraunceys, Thomas, of Fordham 1
4469995 2191279 2191279 defendant Halle John   586305 586305 Halle, John, of Fordham 7
4472310 2192011 2192011 defendant Brampton John   586305 586305 Brampton, John, of Fordham 0
4472312 2192012 2192012 defendant Brampton John   586305 586305 Brampton, John, of Fordham 0
4476996 2193465 2193465 defendant Malyn John   586305 586305 Malyn, John, of Fordham 1
4489250 2197357 2197357 defendant Culho Adam   586305 586305 Culho, Adam, of Fordham 1
4514210 2204862 2204862 defendant Bakere Thomas clerk 586305 586305 Bakere, Thomas, of Fordham, clerk 0
4520630 2206801 2206801 defendant Cobbe John   586305 586305 Cobbe, John, of Fordham 0
4545788 2214611 2214611 defendant Resam Robert   586305 586305 Resam, Robert, of Fordham 0
4549581 2215812 2215812 defendant Frere John   586305 586305 Frere, John, of Fordham 0
4559509 2218923 2218923 defendant Lydegate Thomas   586305 586305 Lydegate, Thomas, of Fordham, prior 0
4560244 2219154 2219154 defendant Porter Simon   586305 586305 Porter, Simon, of Fordham 0
4560245 2219154 2219154 defendant Wyk John   586305 586305 Wyk, John, of Fordham 1
4560246 2219154 2219154 defendant Byslee Thomas   586305 586305 Byslee, Thomas, of Fordham 2
4565230 2220698 2220698 defendant Ede John   586305 586305 Ede, John, of Fordham, shepherd 0
4575289 2223786 2223786 defendant Cobbe Thomas   586305 586305 Cobbe, Thomas, of Fordham 0
4598524 2230774 2230774 defendant Broun Thomas   586305 586305 Broun, Thomas, of Fordham 1
4598528 2230775 2230775 defendant Broun Thomas   586305 586305 Broun, Thomas, of Fordham 1
4600503 2231378 2231378 defendant Refham Robert   586305 586305 Refham, Robert, of Fordham 7
4600504 2231378 2231378 defendant Floure Henry   586305 586305 Floure, Henry, of Fordham 8
4608275 2233697 2233697 defendant Warner John   586305 586305 Warner, John, of Fordham 0
4620122 2237274 2237274 defendant Flouer Henry   586305 586305 Flouer, Henry, of Fordham 0
4620123 2237274 2237274 defendant Refham Robert   586305 586305 Refham, Robert, of Fordham 1
4620124 2237274 2237274 defendant Brampton John   586305 586305 Brampton, John, of Fordham 2
4620127 2237275 2237275 defendant Fullere Simon   586305 586305 Fullere, Simon, of Fordham 0
4620128 2237275 2237275 defendant Gerard Robert   586305 586305 Gerard, Robert, of Fordham 1
4620129 2237275 2237275 defendant Barkere John   586305 586305 Barkere, John, of Fordham 2
4631740 2240812 2240812 defendant Refham Robert   586305 586305 Refham, Robert, of Fordham 0
4631741 2240812 2240812 defendant Foure Henry   586305 586305 Foure, Henry, of Fordham 1
4641854 2243720 2243720 defendant Cattesson Nicholas   586305 586305 Cattesson, Nicholas, of Fordham 1
4641856 2243721 2243721 defendant Spycer John   586305 586305 Spycer, John, of Fordham 0
4646187 2244958 2244958 defendant Floure Henry   586305 586305 Floure, Henry, of Fordham 0
4653850 2247111 2247111 defendant Floure Henry ploughman 586305 586305 Floure, Henry, of Fordham, ploughman 0
4668818 2255954 2255954 defendant Frost John glover 586305 586305 Frost, John, of Fordham, glover 0
4670251 2256403 2256403 plaintiff Broun William   586305 586305 Broun, William, of Fordham, on his own account 0
4683065 2260319 2260319 defendant Derby Thomas husbandman 586305 586305 Derby, Thomas, of Fordham, husbandman 3
4683066 2260319 2260319 defendant Fichon John husbandman 586305 586305 Fichon, John, of Fordham, husbandman 4
4695520 2264081 2264081 plaintiff Broun William   586305 586305 Broun, William, of Fordham 0
4700278 2265503 2265503 defendant Barkere John husbandman 586305 586305 Barkere, John, of Fordham, husbandman 3

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