names

96 rows where place_id = 591972

✎ 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
3606165 1869598 1869598 defendant Waltham John husbandman 591972 591972 Waltham, John, of Stapulford, husbandman 0
3625046 1875366 1875366 plaintiff Warde John gent 591972 591972 Warde, John, of Stapulford, gent 0
3632866 1905096 1905096 defendant Warde John miller 591972 591972 Warde, John, of Stapulford, miller 0
3719363 1932342 1932342 defendant Cherard George gent 591972 591972 Cherard, George, of Stapulford, gent 0
3719364 1932342 1932342 defendant Wylson Adam weaver 591972 591972 Wylson, Adam, of Stapulford, weaver 1
3719365 1932342 1932342 defendant Legh William yeoman 591972 591972 Legh, William, of Stapulford, yeoman 2
3719366 1932342 1932342 defendant Abelond Thomas laborer 591972 591972 Abelond, Thomas, of Stapulford, laborer 3
3719367 1932342 1932342 defendant Lound John husbandman 591972 591972 Lound, John, of Stapulford, husbandman 4
3719368 1932342 1932342 defendant Mercer William husbandman 591972 591972 Mercer, William, of Stapulford, husbandman 5
3719369 1932342 1932342 defendant Yates John husbandman 591972 591972 Yates, John, of Stapulford, husbandman 6
3719370 1932342 1932342 defendant Basse Robert husbandman 591972 591972 Basse, Robert, of Stapulford, husbandman 7
3719371 1932342 1932342 defendant Rycarde Robert husbandman 591972 591972 Rycarde, Robert, of Stapulford, husbandman 8
3719372 1932342 1932342 defendant Cale William husbandman 591972 591972 Cale, William, of Stapulford, husbandman 9
3719373 1932342 1932342 defendant Gundeby Richard husbandman 591972 591972 Gundeby, Richard, of Stapulford, husbandman 10
3719652 1932413 1932413 defendant Grenelefe William husbandman 591972 591972 Grenelefe, William, of Stapulford, husbandman 8
3766249 1947097 1947097 defendant Baker Richard husbandman 591972 591972 Baker, Richard, of Stapulford, husbandman 0
3766250 1947097 1947097 defendant Rychardys Richard husbandman 591972 591972 Rychardys, Richard, of Stapulford, husbandman 1
3766251 1947097 1947097 defendant Foster John husbandman 591972 591972 Foster, John, of Stapulford, husbandman 2
3766252 1947097 1947097 defendant Rychardys John, junior husbandman 591972 591972 Rychardys, John, junior, of Stapulford, husbandman 3
3772326 1949030 1949030 defendant Dante Robert yeoman 591972 591972 Dante, Robert, of Stapulford, yeoman 2
3846234 1972379 1972379 plaintiff Gilson Edmund yeoman 591972 591972 Gilson, Edmund, of Stapulford, yeoman 0
3851042 1973917 1973917 defendant Gunby Richard husbandman 591972 591972 Gunby, Richard, of Stapulford, husbandman 1
4475993 2193158 2193158 defendant Milner Robert   591972 591972 Milner, Robert, of Stapulford 0
4486158 2196370 2196370 defendant Clareburgh John   591972 591972 Clareburgh, John, of Stapulford, vicar 0
4497540 2199875 2199875 plaintiff Draughton William de chaplain 591972 591972 Draughton, William de, of Stapulford, chaplain 0
4497541 2199875 2199875 plaintiff Derley Helen de   591972 591972 Derley, Helen de, of Stapulford 1
4500877 2200895 2200895 defendant Baille William   591972 591972 Baille, William, of Stapulford 0
4509999 2203613 2203613 defendant Taillour Thomas   591972 591972 Taillour, Thomas, of Stapulford 0
4512879 2204459 2204459 plaintiff Braughton William de chaplain 591972 591972 Braughton, William de, of Stapulford, chaplain 0
4512880 2204459 2204459 plaintiff Derley Helen de   591972 591972 Derley, Helen de, of Stapulford 1
4518133 2206044 2206044 defendant Taillour Thomas   591972 591972 Taillour, Thomas, of Stapulford 0
4530587 2209863 2209863 defendant Broun Alice   591972 591972 Broun, Alice, of Stapulford 1
4551181 2216312 2216312 plaintiff Derley Helen   591972 591972 Derley, Helen, of Stapulford 1
4640157 2243234 2243234 defendant Netehard Katherine   591972 591972 Netehard, Katherine, of Stapulford 5
4653795 2247100 2247100 defendant Loryng Roger husbandman 591972 591972 Loryng, Roger, of Stapulford, husbandman 0
4653797 2247101 2247101 defendant Loryng Roger husbandman 591972 591972 Loryng, Roger, of Stapulford, husbandman 0
4661414 2249394 2249394 defendant Frank Thomas   591972 591972 Frank, Thomas, of Stapulford, attorney of the bench 0
4691323 2262807 2262807 defendant Bret John spicer & son of Adam Bret 591972 591972 Bret, John, of Stapulford, spicer & son of Adam Bret 0
4763197 2284476 2284476 defendant Baker Edward husbandman 591972 591972 Baker, Edward, of Stapulford, husbandman 0
4786841 2291944 2291944 defendant Baker Edward husbandman 591972 591972 Baker, Edward, of Stapulford, husbandman 2
4803062 2297145 2297145 plaintiff Bagot Robert   591972 591972 Bagot, Robert, of Stapulford 0
4803960 2297421 2297421 plaintiff Statherne William   591972 591972 (Statherne, William, of Stapulford, vicar 1
4812530 2300035 2300035 defendant Hurde Richard farmer 591972 591972 Hurde, Richard, of Stapulford, farmer 2
4818182 2301760 2301760 defendant Taillour Stephen tailor 591972 591972 Taillour, Stephen, of Stapulford, tailor 8
4820510 2302485 2302485 defendant Hormeston John husbandman 591972 591972 Hormeston, John, of Stapulford, husbandman 4
4825900 2304133 2304133 defendant Sherarde Lawrence gent 591972 591972 Sherarde, Lawrence, of Stapulford, gent 0
4836115 2307275 2307275 defendant Edward William husbandman 591972 591972 Edward, William, of Stapulford, husbandman 0
4836117 2307276 2307276 defendant Edward William husbandman 591972 591972 Edward, William, of Stapulford, husbandman 0
4853868 2312619 2312619 defendant Tailour Stephen tailor 591972 591972 Tailour, Stephen, of Stapulford, tailor 3
4865174 2316083 2316083 defendant Dybull Ralph husbandman 591972 591972 Dybull, Ralph, of Stapulford, husbandman 0
4889896 2323629 2323629 defendant Portere Robert husbandman 591972 591972 Portere, Robert, of Stapulford, husbandman 1
4889897 2323629 2323629 defendant Faukenere Geoffrey husbandman 591972 591972 Faukenere, Geoffrey, of Stapulford, husbandman 2
4904464 2328005 2328005 defendant Portere Robert husbandman 591972 591972 Portere, Robert, of Stapulford, husbandman 1
4904465 2328005 2328005 defendant Faukenere Geoffrey husbandman 591972 591972 Faukenere, Geoffrey, of Stapulford, husbandman 2
4924225 2334021 2334021 defendant Toward John husbandman 591972 591972 Toward, John, of Stapulford, husbandman 3
4924232 2334022 2334022 defendant Toward John husbandman 591972 591972 Toward, John, of Stapulford, husbandman 3
4926833 2334819 2334819 defendant Sherard Lawrence esq 591972 591972 Sherard, Lawrence, of Stapulford, esq 0
4926879 2334836 2334836 defendant Milner John   591972 591972 Milner, John, of Stapulford, shepherd 1
4934127 2337060 2337060 defendant Sherard Lawrence esq 591972 591972 Sherard, Lawrence, of Stapulford, esq 0
4936400 2337776 2337776 defendant Harryes Richard (legal representative) 591972 591972 Harryes, Richard, of Stapulford, executors of 0
4936401 2337776 2337776 defendant Harryes John husbandman 591972 591972 (Harryes, John, of Stapulford, husbandman 1
4936402 2337776 2337776 defendant Harryes Edith widow 591972 591972 Harryes, Edith, of Stapulford, widow 2
4956463 2343889 2343889 defendant Elys John husbandman 591972 591972 Elys, John, of Stapulford, husbandman 2
4974980 2349490 2349490 defendant West Simon farmer 591972 591972 West, Simon, of Stapulford, farmer 0
4974981 2349490 2349490 defendant Loryng Roger husbandman 591972 591972 Loryng, Roger, of Stapulford, husbandman 1
4974982 2349490 2349490 defendant Freberne John husbandman 591972 591972 Freberne, John, of Stapulford, farmer, husbandman 2
4978264 2350446 2350446 defendant Sherard Robert esq 591972 591972 Sherard, Robert, of Stapulford, esq 2
5032632 2366428 2366428 plaintiff Schorte John, senior   591972 591972 Schorte, John, senior, of Stapulford 0
5061804 2375126 2375126 defendant Hamond Simon husbandman 591972 591972 Hamond, Simon, of Stapulford Abbot, husbandman 0
5065689 2376263 2376263 defendant Sherard Robert esq 591972 591972 Sherard, Robert, of Stapulford, esq 0
5085868 2382261 2382261 defendant Michell Thomas yeoman 591972 591972 Michell, Thomas, of Stapulford, yeoman 5
5087817 2382817 2382817 defendant Nasshe John, senior husbandman 591972 591972 Nasshe, John, senior, of Stapulford, husbandman 3
5095179 2385005 2385005 defendant Paget John husbandman 591972 591972 Paget, John, of Stapulford, husbandman 0
5129320 2395062 2395062 defendant Lacok John husbandman 591972 591972 Lacok, John, of Stapulford, husbandman 0
5210684 2418863 2418863 defendant Carter Thomas husbandman 591972 591972 Carter, Thomas, of Stapulford, husbandman 6
5211854 2419205 2419205 defendant Olyve John husbandman 591972 591972 Olyve, John, of Stapulford Abbot, husbandman 2
5211909 2419222 2419222 defendant Olyve John husbandman 591972 591972 Olyve, John, of Stapulford Abbot, husbandman 2
5262143 2433910 2433910 defendant Wyte or Wyrte Simon gent 591972 591972 Wyte or Wyrte, Simon, of Stapulford, gent 0
5264256 2434578 2434578 defendant Wyte or Wyrte Simon gent 591972 591972 Wyte or Wyrte, Simon, of Stapulford, gent 0
5489024 2501589 2501589 defendant Waltham John husbandman 591972 591972 Waltham, John, of Stapulford, husbandman 0
5510092 2507993 2507993 plaintiff Grey John husbandman 591972 591972 Grey, John, of Stapulford Abbot, husbandman 0
5534721 2515402 2515402 defendant Sherard Thomas esq 591972 591972 Sherard, Thomas, of Stapulford, esq 0
5547671 2519334 2519334 defendant Carter Andrew carpenter 591972 591972 Carter, Andrew, of Stapulford, carpenter 0
5555201 2521525 2521525 defendant Disney Richard gent 591972 591972 Disney, Richard, of Stapulford, gent 0
5555204 2521526 2521526 defendant Dysney Richard gent 591972 591972 Dysney, Richard, of Stapulford, gent 0
5574756 2527181 2527181 defendant Beves John husbandman 591972 591972 Beves, John, of Stapulford, husbandman 2
5576930 2527828 2527828 defendant Ward John (legal representative) 591972 591972 Ward, John, of Stapulford, executor of 2
5577883 2528156 2528156 defendant Burton John husbandman 591972 591972 Burton, John, of Stapulford, husbandman 0
5577884 2528156 2528156 defendant Mayre Richard husbandman 591972 591972 Mayre, Richard, of Stapulford, husbandman 1
5577885 2528156 2528156 defendant Gresley William husbandman 591972 591972 Gresley, William, of Stapulford, husbandman 2
5577886 2528156 2528156 defendant Chambres John husbandman 591972 591972 Chambres, John, of Stapulford, husbandman 3
5577887 2528156 2528156 defendant Lambe William husbandman 591972 591972 Lambe, William, of Stapulford, husbandman 4
5577888 2528156 2528156 defendant Burton Robert husbandman 591972 591972 Burton, Robert, of Stapulford, husbandman 5
5585632 2530576 2530576 defendant Colyn William husbandman 591972 591972 Colyn, William, of Stapulford Abbot, husbandman 1
5616437 2548939 2548939 plaintiff Hodell William   591972 591972 Hodell, William, of Stapulford 0
5616438 2548939 2548939 defendant Capuntor William milner 591972 591972 Capuntor, William, of Stapulford, milner 0

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