names

70 rows where place_id = 587116

✎ 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
3590512 1864676 1864676 defendant Mychell Roger husbandman 587116 587116 Mychell, Roger, of Alfyngton, husbandman 2
3590513 1864676 1864676 defendant Hervy Richard husbandman 587116 587116 Hervy, Richard, of Alfyngton, husbandman 3
3702986 1927208 1927208 defendant Bucombe Thomas husbandman 587116 587116 Bucombe, Thomas, of Alfyngton, husbandman 0
3800719 1958137 1958137 defendant Downe John laborer 587116 587116 Downe, John, of Alfyngton, laborer 0
3810325 1961121 1961121 defendant Stone Richard carrier 587116 587116 Stone, Richard, of Alfyngton, carrier 0
3810326 1961121 1961121 defendant Wheton William husbandman 587116 587116 Wheton, William, of Alfyngton, husbandman 1
3845664 1972190 1972190 defendant Stocker Nicholas tainer 587116 587116 Stocker, Nicholas, of Alfyngton, tainer 0
3903406 1991363 1991363 defendant Fowey Thomas yeoman 587116 587116 (Fowey, Thomas, of Alfyngton, yeoman 1
3944700 2005245 2005245 plaintiff Beare John yeoman 587116 587116 Beare, John, of Alfyngton, yeoman 0
3951200 2007487 2007487 defendant Emott Thomas husbandman 587116 587116 Emott, Thomas, of Alfyngton, husbandman 0
3993510 2022424 2022424 defendant Whytrowe Philip   587116 587116 Whytrowe, Philip, of Alfyngton, groom 1
4011620 2028900 2028900 defendant Gotham Roger yeoman 587116 587116 Gotham, Roger, of Alfyngton, or of Kenne, Devon, yeoman 1
4064741 2047675 2047675 defendant Predam Mathew husbandman 587116 587116 Predam, Mathew, of Alfyngton, husbandman 0
4102346 2061129 2061129 defendant Wilse Edward husbandman 587116 587116 Wilse, Edward, of Alfyngton, husbandman 1
4102347 2061129 2061129 defendant Haynes Richard weaver 587116 587116 Haynes, Richard, of Alfyngton, weaver 2
4455573 2186750 2186750 defendant Broun Walter   587116 587116 Broun, Walter, of Alfyngton 0
4544526 2214204 2214204 plaintiff Baunton William (legal representative) 587116 587116 Baunton, William, of Alfyngton, formerly parson, executors of 0
4549505 2215791 2215791 plaintiff Coryton William   587116 587116 Coryton, William, of Alfyngton 0
4549507 2215791 2215791 defendant Marsshall John   587116 587116 Marsshall, John, of Alfyngton 1
4772291 2287301 2287301 defendant Byrche Walter yeoman 587116 587116 Byrche, Walter, of Alfyngton, yeoman 7
4785397 2291450 2291450 defendant Monke William husbandman 587116 587116 Monke, William, of Alfyngton, husbandman 0
4785401 2291452 2291452 defendant Monke William husbandman 587116 587116 Monke, William, of Alfyngton, husbandman 0
4802275 2296902 2296902 plaintiff Mathu John   587116 587116 (Mathu, John, of Alfyngton by Exeter, parson 1
4835334 2307047 2307047 defendant Smyth Smyth husbandman 587116 587116 Smyth, Smyth, of Alfyngton, husbandman 0
4839207 2308190 2308190 defendant Burgate William husbandman 587116 587116 Burgate, William, of Alfyngton, husbandman 0
4848218 2310914 2310914 defendant Crounche John husbandman 587116 587116 Crounche, John, of Alfyngton, husbandman 0
4848219 2310914 2310914 defendant Forde William husbandman 587116 587116 Forde, William, of Alfyngton, husbandman 1
4852658 2312251 2312251 defendant Monk William   587116 587116 Monk, William, of Alfyngton, franklin 0
4852660 2312252 2312252 defendant Monk William   587116 587116 Monk, William, of Alfyngton, franklin 0
4861418 2314942 2314942 defendant Monke William   587116 587116 Monke, William, of Alfyngton, franklin 0
4866498 2316482 2316482 defendant Burgate William husbandman 587116 587116 Burgate, William, of Alfyngton, husbandman 0
4867035 2316654 2316654 defendant Smyth John mercer 587116 587116 Smyth, John, of Alfyngton, mercer 1
4888059 2323067 2323067 defendant Monk William   587116 587116 Monk, William, of Alfyngton, franklin 0
4897712 2325952 2325952 defendant Monk William   587116 587116 Monk, William, of Alfyngton, franklin 0
4912598 2330440 2330440 defendant Smyth John husbandman 587116 587116 Smyth, John, of Alfyngton, husbandman 0
4923793 2333883 2333883 plaintiff Monk William   587116 587116 Monk, William, of Alfyngton 0
4939604 2338773 2338773 defendant Monk William   587116 587116 Monk, William, of Alfyngton, franklin 0
4962101 2345571 2345571 defendant Harry John husbandman 587116 587116 Harry, John, of Alfyngton, husbandman 0
4962726 2345758 2345758 defendant Stracche John laborer 587116 587116 Stracche, John, of Alfyngton, laborer 0
4962728 2345759 2345759 defendant Stracche John laborer 587116 587116 Stracche, John, of Alfyngton, laborer 0
4962734 2345762 2345762 defendant Stracche John laborer 587116 587116 Stracche, John, of Alfyngton, laborer 0
4968351 2347499 2347499 defendant Fitz Richard laborer 587116 587116 Fitz, Richard, of Alfyngton, laborer 0
4974918 2349472 2349472 defendant Bony or Bouy John laborer 587116 587116 Bony or Bouy, John, of Alfyngton, laborer 0
5038168 2368050 2368050 defendant Docer John husbandman 587116 587116 Docer, John, of Alfyngton, husbandman 0
5064883 2376028 2376028 defendant Monk William gent 587116 587116 Monk, William, of Alfyngton, gent 0
5084313 2381816 2381816 defendant Grygge John laborer 587116 587116 Grygge, John, of Alfyngton, laborer 0
5085567 2382173 2382173 defendant Rydon John husbandman 587116 587116 Rydon, John, of Alfyngton, husbandman 3
5089293 2383236 2383236 defendant Monk William gent 587116 587116 Monk, William, of Alfyngton, gent 0
5103165 2387352 2387352 defendant Forst alias Baker Henry (legal representative) 587116 587116 Forst alias Baker, Henry, of Alfyngton, executrix of 0
5104460 2387731 2387731 defendant Bysshop William yeoman 587116 587116 Bysshop, William, of Alfyngton, yeoman 0
5217284 2420789 2420789 defendant Fitz John   587116 587116 Fitz, John, of Alfyngton, husbandman, son of Fitz, John, senior 0
5225045 2422995 2422995 defendant Wherne John husbandman 587116 587116 Wherne, John, of Alfyngton, husbandman 0
5232621 2425121 2425121 defendant Burgat William yeoman 587116 587116 Burgat, William, of Alfyngton, yeoman 2
5259165 2432982 2432982 defendant Blascombe John husbandman 587116 587116 Blascombe, John, of Alfyngton, husbandman 0
5294532 2443375 2443375 defendant Webber John husbandman 587116 587116 Webber, John, of Alfyngton, husbandman 1
5469042 2495668 2495668 defendant Eade John husbandman 587116 587116 Eade, John, of Alfyngton, husbandman 0
5469043 2495668 2495668 defendant fitz John   587116 587116 fitz, John, of Alfyngton, court holder or parish clerk 1
5486144 2500741 2500741 defendant Elyot Martin husbandman 587116 587116 Elyot, Martin, of Alfyngton, husbandman 0
5522743 2511941 2511941 defendant Tothill John husbandman 587116 587116 Tothill, John, of Alfyngton, husbandman 0
5539311 2516781 2516781 defendant Michell Roger husbandman 587116 587116 Michell, Roger, of Alfyngton, husbandman 0
5540705 2517223 2517223 defendant Baron Martin husbandman 587116 587116 Baron, Martin, of Alfyngton, husbandman 0
5564785 2524286 2524286 defendant Falbes Roger husbandman 587116 587116 Falbes, Roger, of Alfyngton, husbandman 1
5564786 2524286 2524286 defendant Clyst William husbandman 587116 587116 Clyst, William, of Alfyngton, husbandman 2
5569512 2525645 2525645 defendant Grigge John husbandman 587116 587116 Grigge, John, of Alfyngton, husbandman 0
5595294 2533475 2533475 defendant Falbas or Fawas William husbandman 587116 587116 Falbas or Fawas, William, of Alfyngton, husbandman 0
5595295 2533475 2533475 defendant Clyft John husbandman 587116 587116 Clyft, John, of Alfyngton, husbandman 1
5595296 2533475 2533475 defendant Toryng Richard husbandman 587116 587116 Toryng, Richard, of Alfyngton, husbandman 2
5626465 2552248 2552248 defendant Sakerlegh Henry laborer 587116 587116 Sakerlegh, Henry, of Alfyngton, laborer 0
5636945 2555498 2555498 defendant Fanell or Favell John   587116 587116 Fanell or Favell, John, of Alfyngton, millward 0
5636948 2555499 2555499 defendant Fanell John   587116 587116 Fanell, John, of Alfyngton, millward 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);