names

114 rows where place_id = 590542

✎ 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
3601560 1868143 1868143 defendant Mandolfe Robert husbandman 590542 590542 Mandolfe, Robert, of Fouldon, husbandman 0
3613424 1871846 1871846 defendant Mandolf Robert husbandman 590542 590542 Mandolf, Robert, of Fouldon, husbandman 0
3616699 1872853 1872853 defendant Mandolff Henry shoemaker 590542 590542 Mandolff, Henry, of Fouldon, shoemaker 1
3616700 1872853 1872853 defendant Mandolff Robert shoemaker 590542 590542 Mandolff, Robert, of Fouldon, shoemaker 2
3620378 1873958 1873958 defendant Hewer John yeoman 590542 590542 Hewer, John, of Fouldon, yeoman 0
3624536 1875211 1875211 defendant Hewar John yeoman 590542 590542 Hewar, John, of Fouldon, yeoman 1
3624537 1875211 1875211 defendant Whitepayn John husbandman 590542 590542 Whitepayn, John, of Fouldon, husbandman 2
3638057 1906721 1906721 defendant Toftys Richard husbandman 590542 590542 (Toftys, Richard, of Fouldon, husbandman 1
3719987 1932522 1932522 plaintiff Hewar Thomas   590542 590542 Hewar, Thomas, of Fouldon 1
3724777 1934033 1934033 defendant Boche Robert butcher 590542 590542 Boche, Robert, of Fouldon, butcher 3
3738726 1938318 1938318 defendant Fuller John merchant 590542 590542 Fuller, John, of Fouldon, merchant 0
3761073 1945464 1945464 defendant Mowle John carpenter 590542 590542 Mowle, John, of Fouldon, carpenter 0
3806356 1959901 1959901 defendant Kentyng John husbandman 590542 590542 Kentyng, John, of Fouldon, husbandman 1
3864377 1978282 1978282 plaintiff Leder Richard clerk 590542 590542 Leder, Richard, of Fouldon, clerk 0
3876720 1982456 1982456 defendant Heward thmoas yeoman 590542 590542 Heward, thmoas, of Fouldon, yeoman 0
3892906 1987874 1987874 defendant Benet Margaret widow 590542 590542 Benet, Margaret, of Fouldon, widow 0
3892907 1987874 1987874 defendant Marteyn Thomas laborer 590542 590542 Marteyn, Thomas, of Fouldon, laborer 1
3899002 1989872 1989872 defendant Alyston John husbandman 590542 590542 Alyston, John, of Fouldon, husbandman 0
3908724 1993215 1993215 defendant Barker Thomas husbandman 590542 590542 Barker, Thomas, of Fouldon, husbandman 0
3923958 1998323 1998323 defendant Shillyng William tailor 590542 590542 Shillyng, William, of Fouldon, tailor 0
4015343 2030180 2030180 defendant Pylgryme William weaver 590542 590542 Pylgryme, William, of Fouldon, weaver 3
4029870 2035326 2035326 defendant Sewell John husbandman 590542 590542 Sewell, John, of Fouldon, husbandman 0
4029871 2035326 2035326 defendant Tassell Nicholas tailor 590542 590542 Tassell, Nicholas, of Fouldon, tailor 1
4085514 2055096 2055096 defendant Bearflower Robert husbandman 590542 590542 Bearflower, Robert, of Fouldon, husbandman 0
4129597 2070889 2070889 defendant Roberd William husbandman 590542 590542 Roberd, William, of Fouldon, husbandman 0
4129598 2070889 2070889 defendant Roberd Henry husbandman 590542 590542 Roberd, Henry, of Fouldon, husbandman 1
4184804 2090194 2090194 defendant Bereflower Roger husbandman 590542 590542 Bereflower, Roger, of Fouldon, husbandman 0
4210058 2099079 2099079 defendant Wylkyns Richard husbandman 590542 590542 Wylkyns, Richard, of Fouldon, husbandman 2
4224780 2104135 2104135 defendant Robert John yeoman 590542 590542 Robert, John, of Fouldon, yeoman 0
4224781 2104135 2104135 defendant Cattelyn Faith spinster 590542 590542 Cattelyn, Faith, of Fouldon, spinster 1
4227235 2105005 2105005 defendant Olyver William yeoman 590542 590542 Olyver, William, of Fouldon, yeoman 0
4227236 2105005 2105005 defendant Olyver Batilda spinster 590542 590542 Olyver, Batilda, of Fouldon, spinster 1
4227237 2105005 2105005 defendant Bareflower Roger laborer 590542 590542 Bareflower, Roger, of Fouldon, laborer 2
4227239 2105006 2105006 defendant Robert John yeoman 590542 590542 Robert, John, of Fouldon, yeoman 0
4255384 2114797 2114797 defendant Olyver William yeoman 590542 590542 Olyver, William, of Fouldon, yeoman 0
4255385 2114797 2114797 defendant Olyver Batilda spinster 590542 590542 Olyver, Batilda, of Fouldon, spinster 1
4255386 2114797 2114797 defendant Bareflower Roger laborer 590542 590542 Bareflower, Roger, of Fouldon, laborer 2
4258234 2115726 2115726 defendant Cubett Christopher husbandman 590542 590542 Cubett, Christopher, of Fouldon, husbandman 1
4426235 2173012 2173012 plaintiff Norman John   590542 590542 Norman, John, of Fouldon 0
4479511 2194251 2194251 defendant Burgh Petronella de   590542 590542 Burgh, Petronella de, of Fouldon 1
4567447 2221379 2221379 defendant Werhous John   590542 590542 Werhous, John, of Fouldon 6
4572249 2222861 2222861 defendant Stede Richard   590542 590542 Stede, Richard, of Fouldon 0
4583049 2226121 2226121 defendant Lynforde John   590542 590542 Lynforde, John, of Fouldon 1
4594388 2229503 2229503 defendant Bynde William   590542 590542 Bynde, William, of Fouldon 0
4600876 2231499 2231499 defendant Lynneforth Simon   590542 590542 Lynneforth, Simon, of Fouldon 0
4602457 2231988 2231988 defendant Est William   590542 590542 Est, William, of Fouldon 6
4641557 2243629 2243629 defendant Wardon Seamus (legal representative) 590542 590542 Wardon, Seamus, of Fouldon, executrix of 1
4641558 2243629 2243629 defendant Wardon Agnes   590542 590542 Wardon, Agnes, of Fouldon, formerly wife of Seamus 2
4642226 2243845 2243845 defendant Redhede Thomas   590542 590542 Redhede, Thomas, of Fouldon 0
4650984 2246310 2246310 defendant Sharpyng William   590542 590542 Sharpyng, William, of Fouldon, shepherd 0
4652826 2246819 2246819 defendant Stede Richard   590542 590542 Stede, Richard, of Fouldon, shepherd 0
4652827 2246819 2246819 defendant Bynde William   590542 590542 Bynde, William, of Fouldon, shepherd 1
4663902 2250192 2250192 defendant Stede Richard   590542 590542 Stede, Richard, of Fouldon, shepherd 1
4679359 2259160 2259160 plaintiff Kele Agnes (legal representative) 590542 590542 Kele, Agnes, of Fouldon, executors of 0
4679362 2259160 2259160 defendant Stede Richard husbandman 590542 590542 Stede, Richard, of Fouldon, husbandman 0
4695082 2263955 2263955 defendant Greve Thomas   590542 590542 Greve, Thomas, of Fouldon, shoe maker 0
4698348 2264963 2264963 defendant Kemp Richard laborer 590542 590542 Kemp, Richard, of Fouldon, laborer 1
4710927 2268774 2268774 defendant Adam Henry husbandman 590542 590542 Adam, Henry, of Fouldon, husbandman 0
4712345 2269175 2269175 defendant Stede Richard   590542 590542 Stede, Richard, of Fouldon 3
4716111 2270345 2270345 defendant Stede John yeoman 590542 590542 Stede, John, of Fouldon, yeoman 2
4750497 2280628 2280628 defendant Stede John yeoman 590542 590542 Stede, John, of Fouldon, yeoman 3
4750499 2280628 2280628 defendant Stede Richard yeoman 590542 590542 Stede, Richard, of Fouldon, yeoman 5
4755130 2281991 2281991 defendant Stede John husbandman 590542 590542 Stede, John, of Fouldon, husbandman 0
4763994 2284728 2284728 defendant Cleye Henry yeoman 590542 590542 Cleye, Henry, of Fouldon, yeoman 1
4776957 2288779 2288779 defendant Stede John husbandman 590542 590542 Stede, John, of Fouldon, husbandman 0
4797987 2295554 2295554 defendant Bettys Lawrence laborer 590542 590542 Bettys, Lawrence, of Fouldon, laborer 0
4828623 2304992 2304992 defendant Stede Richard husbandman 590542 590542 Stede, Richard, of Fouldon, husbandman 0
4828624 2304992 2304992 defendant Talbot Robert husbandman 590542 590542 Talbot, Robert, of Fouldon, husbandman 1
4876761 2319704 2319704 defendant Stede John yeoman 590542 590542 Stede, John, of Fouldon, yeoman 3
4882310 2321377 2321377 defendant Elys Richard carpenter 590542 590542 Elys, Richard, of Fouldon, carpenter 0
4924321 2334040 2334040 defendant Talbot Robert   590542 590542 Talbot, Robert, of Fouldon 4
4943581 2339960 2339960 defendant Stede Richard (legal representative) 590542 590542 Stede, Richard, of Fouldon, yeoman, executor of 3
4943582 2339960 2339960 defendant Styward William gent 590542 590542 Styward, William, of Fouldon, gent 4
4947732 2341276 2341276 defendant Treget Robert courser 590542 590542 Treget, Robert, of Fouldon, courser 0
4971953 2348548 2348548 defendant Greve John husbandman 590542 590542 Greve, John, of Fouldon, husbandman 0
4985259 2352517 2352517 defendant Talbot Robert husbandman 590542 590542 Talbot, Robert, of Fouldon, husbandman 4
5008673 2359429 2359429 defendant Lynford Simon yeoman 590542 590542 Lynford, Simon, of Fouldon, yeoman 0
5027856 2365027 2365027 defendant Talbot Robert husbandman 590542 590542 Talbot, Robert, of Fouldon, husbandman 1
5225934 2423256 2423256 plaintiff Smyth John (legal representative) 590542 590542 Smyth, John, of Fouldon, executors of 0
5225937 2423256 2423256 defendant Crakecheld Henry husbandman 590542 590542 Crakecheld, Henry, of Fouldon, husbandman 0
5282047 2439822 2439822 plaintiff Greve John, junior   590542 590542 Greve, John, junior, of Fouldon 1
5285220 2440701 2440701 defendant Ladyll John laborer 590542 590542 Ladyll, John, of Fouldon, laborer 0
5286692 2441119 2441119 defendant Goodwyn Robert husbandman 590542 590542 Goodwyn, Robert, of Fouldon, husbandman 0
5293791 2443148 2443148 defendant Crakessheld Henry smith 590542 590542 Crakessheld, Henry, of Fouldon, smith 0
5299523 2444837 2444837 defendant Godewyn Robert husbandman 590542 590542 Godewyn, Robert, of Fouldon, husbandman 0
5303021 2445893 2445893 defendant Godewyn Robert husbandman 590542 590542 Godewyn, Robert, of Fouldon, husbandman 1
5310395 2448144 2448144 defendant Grene John yeoman 590542 590542 Grene, John, of Fouldon, yeoman 2
5318832 2450724 2450724 defendant Mandolf Robert husbandman 590542 590542 Mandolf, Robert, of Fouldon, husbandman 0
5318833 2450724 2450724 defendant Godewyn Robert husbandman 590542 590542 Godewyn, Robert, of Fouldon, husbandman 1
5337300 2456226 2456226 defendant Grene John yeoman 590542 590542 Grene, John, of Fouldon, yeoman 3
5343202 2458067 2458067 defendant Grene John yeoman 590542 590542 Grene, John, of Fouldon, yeoman 2
5343265 2458088 2458088 defendant Grene John yeoman 590542 590542 Grene, John, of Fouldon, yeoman 0
5356914 2462225 2462225 defendant Walour John husbandman 590542 590542 Walour, John, of Fouldon, husbandman 2
5358675 2462774 2462774 defendant Goodwyn Robert husbandman 590542 590542 Goodwyn, Robert, of Fouldon, husbandman 0
5359509 2463005 2463005 defendant Mandolff Robert husbandman 590542 590542 Mandolff, Robert, of Fouldon, husbandman 1
5361051 2463482 2463482 defendant Mercaunt Robert husbandman 590542 590542 Mercaunt, Robert, of Fouldon, husbandman 1
5404540 2476370 2476370 defendant Goodwyn Robert husbandman 590542 590542 Goodwyn, Robert, of Fouldon, husbandman 4
5417670 2480207 2480207 defendant Goodwyn Robert husbandman 590542 590542 Goodwyn, Robert, of Fouldon, husbandman 4
5430696 2484120 2484120 defendant Mandolf Robert shoemaker 590542 590542 Mandolf, Robert, of Fouldon, shoemaker 0
5435087 2485425 2485425 defendant Goodwyn Robert husbandman 590542 590542 Goodwyn, Robert, of Fouldon, 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);