names

72 rows where place_id = 606051

✎ 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
3663851 1914631 1914631 defendant Freston John fisher 606051 606051 Freston, John, of Yakesley, fisher 0
3687932 1922385 1922385 defendant Swetbone Thomas husbandman 606051 606051 Swetbone, Thomas, of Yakesley, husbandman 0
3747883 1941262 1941262 plaintiff Foster Adam gent 606051 606051 Foster, Adam, of Yakesley, gent 0
3780024 1951478 1951478 plaintiff Foster Adam gent 606051 606051 Foster, Adam, of Yakesley, gent 0
3780028 1951478 1951478 defendant Skeggys Robert (legal representative) 606051 606051 Skeggys, Robert, of Yakesley, fishmonger, executrix of 3
3780029 1951478 1951478 defendant Skeggys Elizabeth widow 606051 606051 Skeggys, Elizabeth, of Yakesley, widow 4
3783458 1952575 1952575 defendant Browne Simon husbandman 606051 606051 Browne, Simon, of Yakesley, husbandman 0
4438110 2181220 2181220 defendant Herlyngton John   606051 606051 Herlyngton, John, of Yakesley 0
4438112 2181221 2181221 defendant Herlyngton John   606051 606051 Herlyngton, John, of Yakesley, on his own account 0
4472757 2192148 2192148 defendant Brewester Thomas   606051 606051 Brewester, Thomas, of Yakesley 0
4488387 2197085 2197085 defendant Weston William   606051 606051 Weston, William, of Yakesley 0
4488580 2197150 2197150 plaintiff Stoke Henry   606051 606051 Stoke, Henry, of Yakesley 1
4488581 2197150 2197150 defendant Weston William   606051 606051 Weston, William, of Yakesley 0
4489914 2197552 2197552 defendant Wykele John   606051 606051 Wykele, John, of Yakesley, bailiff 1
4491918 2198158 2198158 plaintiff Wycle Geoffrey   606051 606051 Wycle, Geoffrey, of Yakesley, on his own account 0
4516079 2205444 2205444 defendant Suffyn Richard   606051 606051 Suffyn, Richard, of Yakesley 1
4516090 2205446 2205446 defendant Suffyn Richard   606051 606051 Suffyn, Richard, of Yakesley 1
4521401 2207038 2207038 defendant Stoke Richard   606051 606051 Stoke, Richard, of Yakesley 0
4526759 2208645 2208645 defendant Harlyngton John   606051 606051 Harlyngton, John, of Yakesley 0
4526761 2208646 2208646 defendant Harlyngton John   606051 606051 Harlyngton, John, of Yakesley 0
4526762 2208646 2208646 defendant Scot John   606051 606051 Scot, John, of Yakesley 1
4557633 2218322 2218322 defendant Emerton Wiliam   606051 606051 Emerton, Wiliam, of Yakesley 0
4615011 2235706 2235706 defendant Tilly John   606051 606051 Tilly, John, of Yakesley 0
4625952 2239071 2239071 defendant Bocher John   606051 606051 Bocher, John, of Yakesley 0
4639897 2243175 2243175 plaintiff Curteys William   606051 606051 Curteys, William, of Yakesley 0
4640488 2243330 2243330 defendant Hoggesson Walter   606051 606051 Hoggesson, Walter, of Yakesley 0
4640491 2243331 2243331 defendant Hoggesson Walter   606051 606051 Hoggesson, Walter, of Yakesley 0
4643468 2244189 2244189 defendant Potton William clerk 606051 606051 Potton, William, of Yakesley, clerk 0
4656185 2247820 2247820 defendant Barbour Richard barber 606051 606051 Barbour, Richard, of Yakesley, barber 1
4663427 2250035 2250035 defendant Peek John yeoman 606051 606051 Peek, John, of Yakesley, yeoman 0
4676523 2258273 2258273 defendant Peeke John yeoman 606051 606051 Peeke, John, of Yakesley, yeoman 0
4691037 2262721 2262721 defendant Hoggeson Walter husbandman 606051 606051 Hoggeson, Walter, of Yakesley, husbandman 1
4693832 2263573 2263573 defendant Curteys William butcher 606051 606051 Curteys, William, of Yakesley, butcher 0
4693833 2263573 2263573 defendant Bocher Robert butcher 606051 606051 Bocher, Robert, of Yakesley, butcher 1
4695804 2264171 2264171 defendant Whit Richard husbandman 606051 606051 Whit, Richard, of Yakesley, husbandman 1
4707252 2267648 2267648 plaintiff Meelton Thomas   606051 606051 Meelton, Thomas, of Yakesley 0
4709999 2268485 2268485 defendant Spore Nicholas   606051 606051 Spore, Nicholas, of Yakesley, shoe maker 0
4710000 2268485 2268485 defendant Chapman Thomas mercer 606051 606051 Chapman, Thomas, of Yakesley, mercer 1
4718270 2271050 2271050 defendant Bolewer Robert butcher 606051 606051 Bolewer, Robert, of Yakesley, butcher 0
4718272 2271051 2271051 defendant Bolewer Robert butcher 606051 606051 Bolewer, Robert, of Yakesley, butcher 0
4719028 2271299 2271299 defendant Bocher Robert husbandman 606051 606051 Bocher, Robert, of Yakesley, husbandman 0
4773677 2287741 2287741 defendant Faldeyate Robert husbandman 606051 606051 Faldeyate, Robert, of Yakesley, husbandman 0
4773678 2287741 2287741 defendant Coupland John husbandman 606051 606051 Coupland, John, of Yakesley, husbandman 1
4782919 2290678 2290678 defendant Lokyer John smith 606051 606051 Lokyer, John, of Yakesley, smith 0
4792247 2293663 2293663 plaintiff Melton Thomas   606051 606051 Melton, Thomas, of Yakesley 0
4850578 2311643 2311643 defendant Freman Thomas esq 606051 606051 Freman, Thomas, of Yakesley, esq 0
4852421 2312174 2312174 defendant Barker Thomas chapman 606051 606051 Barker, Thomas, of Yakesley, chapman 1
4863101 2315439 2315439 defendant Dunsford John   606051 606051 Dunsford, John, of Yakesley, wright 0
4867875 2316924 2316924 defendant Hulker William chapman 606051 606051 Hulker, William, of Yakesley, chapman 1
4889916 2323634 2323634 defendant Marsshe Andrew chapman 606051 606051 Marsshe, Andrew, of Yakesley, chapman 3
4889917 2323634 2323634 defendant Luy Thomas baker 606051 606051 Luy, Thomas, of Yakesley, baker 4
4902305 2327330 2327330 defendant Sendell John shoemaker 606051 606051 Sendell, John, of Yakesley, shoemaker 1
4902586 2327427 2327427 defendant Ryvell or Rynell John fishmonger 606051 606051 Ryvell or Rynell, John, of Yakesley, fishmonger 0
4931592 2336267 2336267 defendant Freseton Robert yeoman 606051 606051 Freseton, Robert, of Yakesley, yeoman 1
4931594 2336267 2336267 defendant Curteyse Willam husbandman 606051 606051 Curteyse, Willam, of Yakesley, husbandman 3
4931595 2336267 2336267 defendant Pyjkewelle Willam husbandman 606051 606051 Pyjkewelle, Willam, of Yakesley, husbandman 4
5008861 2359485 2359485 defendant Howeson Richard yeoman 606051 606051 Howeson, Richard, of Yakesley, yeoman 0
5036851 2367653 2367653 defendant Wryght John (legal representative) 606051 606051 Wryght, John, of Yakesley, executrix of 2
5036857 2367654 2367654 defendant Wryght Margaret widow 606051 606051 Wryght, Margaret, of Yakesley, widow 3
5041579 2369085 2369085 defendant Isham Nicholas yeoman 606051 606051 Isham, Nicholas, of Yakesley, yeoman 1
5103898 2387567 2387567 plaintiff Bukke John merchant 606051 606051 Bukke, John, of Yakesley, merchant 0
5122728 2393082 2393082 defendant Dekyn Henry husbandman 606051 606051 Dekyn, Henry, of Yakesley, husbandman 1
5122729 2393082 2393082 defendant Grymesham John butcher 606051 606051 Grymesham, John, of Yakesley, butcher 2
5122731 2393082 2393082 defendant Smyth William yeoman 606051 606051 Smyth, William, of Yakesley, yeoman 4
5198062 2415177 2415177 defendant Blaundell John yeoman 606051 606051 Blaundell, John, of Yakesley, yeoman 0
5198063 2415177 2415177 defendant Philip Henry yeoman 606051 606051 Philip, Henry, of Yakesley, yeoman 1
5198064 2415177 2415177 defendant Butteler Richard yeoman 606051 606051 Butteler, Richard, of Yakesley, yeoman 2
5254672 2431581 2431581 defendant Breyton Richard husbandman 606051 606051 Breyton, Richard, of Yakesley, husbandman 2
5352933 2461005 2461005 defendant Sexteyn John yeoman 606051 606051 Sexteyn, John, of Yakesley, yeoman 0
5369348 2466015 2466015 defendant Smyth alias Sexten John yeoman 606051 606051 Smyth alias Sexten, John, of Yakesley, yeoman 0
5459966 2492910 2492910 defendant Best John yeoman 606051 606051 Best, John, of Yakesley, yeoman 1
5507347 2507192 2507192 defendant Saxten Andrew yeoman 606051 606051 Saxten, Andrew, of Yakesley, yeoman 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);