names

89 rows where place_id = 700842

✎ 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
3711904 1930039 1930039 defendant Baker Geoffrey clerk 700842 700842 Baker, Geoffrey, of Est Walton, clerk 0
3744442 1940163 1940163 defendant Shakill John   700842 700842 Shakill, John, of Est Walton, shepherd 0
3852029 1974225 1974225 defendant Prest Robert, senior (legal representative) 700842 700842 Prest, Robert, senior, of Est Walton, innkeeper, executors of 0
3989738 2021073 2021073 defendant Prest William, senior yeoman 700842 700842 Prest, William, senior, of Est Walton, yeoman 5
4011989 2029018 2029018 plaintiff Prest William husbandman 700842 700842 Prest, William, of Est Walton, husbandman 0
4062272 2046798 2046798 defendant Sallett Simon clerk 700842 700842 Sallett, Simon, of Est Walton, clerk 1
4135420 2072988 2072988 defendant Cooper Henry husbandman 700842 700842 Cooper, Henry, of East Walton, husbandman 0
4135421 2072988 2072988 defendant Cooper Anthony husbandman 700842 700842 Cooper, Anthony, of East Walton, husbandman 1
4135422 2072988 2072988 defendant Boydon Thomas husbandman 700842 700842 Boydon, Thomas, of East Walton, husbandman 2
4226819 2104853 2104853 defendant Nicholas William husbandman 700842 700842 Nicholas, William, of East Walton, husbandman 1
4266651 2118491 2118491 defendant Baker Thomas gent 700842 700842 Baker, Thomas, of East Walton, gent 1
4308847 2133243 2133243 defendant Inglishe Richard tailor 700842 700842 Inglishe, Richard, of Est Walton, or of Cressingham, Norf, tailor 3
4325987 2139065 2139065 defendant Justen James husbandman 700842 700842 Justen, James, of Est Walton, husbandman 0
4328170 2139737 2139737 defendant Nicholles William   700842 700842 Nicholles, William, of Est Walton, medicus 1
4368588 2153816 2153816 defendant Prest William husbandman 700842 700842 Prest, William, of East Walton, husbandman 0
4450923 2185258 2185258 defendant Richende John   700842 700842 Richende, John, of East Walton 1
4450927 2185259 2185259 defendant Rulonde John   700842 700842 Rulonde, John, of East Walton 1
4452519 2185786 2185786 defendant Welle Reginald   700842 700842 Welle, Reginald, of East Walton 0
4464253 2189484 2189484 defendant Rose Thomas   700842 700842 Rose, Thomas, of East Walton 0
4480643 2194611 2194611 defendant Bellessave John   700842 700842 Bellessave, John, of East Walton 0
4485606 2196205 2196205 defendant Belesson John   700842 700842 Belesson, John, of East Walton 2
4485607 2196205 2196205 defendant Leef William   700842 700842 Leef, William, of East Walton 3
4553245 2216945 2216945 defendant Richoude John   700842 700842 Richoude, John, of East Walton 0
4568851 2221841 2221841 defendant Wyghton John   700842 700842 Wyghton, John, of East Walton, shepherd 0
4568852 2221841 2221841 defendant Richoude John   700842 700842 Richoude, John, of East Walton 1
4568854 2221841 2221841 defendant Herman Margaret   700842 700842 Herman, Margaret, of East Walton 3
4568855 2221842 2221842 plaintiff Walton William   700842 700842 Walton, William, of East Walton 0
4569615 2222076 2222076 defendant Richoude John   700842 700842 Richoude, John, of East Walton 0
4657387 2248202 2248202 defendant Smyth Roland smith 700842 700842 Smyth, Roland, of Est Walton, smith 1
4672323 2256993 2256993 defendant Smyth Roland yeoman 700842 700842 Smyth, Roland, of East Walton, yeoman 1
4672328 2256994 2256994 defendant Spyndeler Thomas husbandman 700842 700842 Spyndeler, Thomas, of East Walton, husbandman 0
4682407 2260117 2260117 defendant Bullewer John laborer 700842 700842 Bullewer, John, of East Walton, laborer 0
4689816 2262375 2262375 plaintiff Walton William   700842 700842 Walton, William, of East Walton 0
4689818 2262375 2262375 defendant Croft John laborer 700842 700842 Croft, John, of East Walton, laborer 1
4689819 2262375 2262375 defendant Belle John laborer 700842 700842 Belle, John, of East Walton, laborer 2
4716091 2270340 2270340 defendant Rychoude John husbandman 700842 700842 Rychoude, John, of East Walton, husbandman 0
4737743 2276908 2276908 defendant Belle Clement yeoman 700842 700842 Belle, Clement, of East Walton, yeoman 1
4737744 2276908 2276908 defendant Belle Andrew laborer 700842 700842 Belle, Andrew, of East Walton, laborer 2
4737746 2276909 2276909 defendant Belle John carter 700842 700842 Belle, John, of East Walton, carter 0
4737748 2276910 2276910 defendant Belle John carter 700842 700842 Belle, John, of East Walton, carter 0
4737749 2276910 2276910 defendant Belle Andrew laborer 700842 700842 Belle, Andrew, of East Walton, laborer 1
4737751 2276911 2276911 defendant Belle John carter 700842 700842 Belle, John, of East Walton, carter 0
4737752 2276911 2276911 defendant Belle Andrew laborer 700842 700842 Belle, Andrew, of East Walton, laborer 1
4753278 2281407 2281407 defendant Smyth William   700842 700842 Smyth, William, of East Walton, vicar 1
4753791 2281559 2281559 defendant Pauche John butcher 700842 700842 Pauche, John, of East Walton, butcher 0
4753792 2281559 2281559 defendant Sparwe Thomas husbandman 700842 700842 Sparwe, Thomas, of East Walton, husbandman 1
4798466 2295703 2295703 defendant Belle John yeoman 700842 700842 Belle, John, of Est Walton, yeoman 1
4798485 2295706 2295706 defendant Richonde William husbandman 700842 700842 Richonde, William, of Est Walton, husbandman 1
4800342 2296286 2296286 defendant Boys John yeoman 700842 700842 Boys, John, of Est Walton, yeoman 0
4800344 2296287 2296287 defendant Sponge William yeoman 700842 700842 Sponge, William, of Est Walton, yeoman 0
4860616 2314680 2314680 defendant Richonde or Richoude William yeoman 700842 700842 Richonde or Richoude, William, of Est Walton, yeoman 0
4860618 2314681 2314681 defendant Richonde or Richoude William yeoman 700842 700842 Richonde or Richoude, William, of Est Walton, yeoman 0
4911941 2330241 2330241 defendant Neugate William yeoman 700842 700842 Neugate, William, of East Walton, yeoman 0
4931590 2336267 2336267 plaintiff Walton Willam esq 700842 700842 Walton, Willam, of East Walton, esq 0
4948874 2341632 2341632 defendant Walton William, junior gent 700842 700842 Walton, William, junior, of Est Walton, gent 1
4957009 2344055 2344055 plaintiff Walton William, senior esq 700842 700842 Walton, William, senior, of Est Walton, esq 0
4963224 2345908 2345908 plaintiff Bysschop Geoffrey clerk 700842 700842 Bysschop, Geoffrey, of Est Walton, clerk 0
4963227 2345909 2345909 plaintiff Bysshop Geoffrey clerk 700842 700842 Bysshop, Geoffrey, of Est Walton, clerk 0
4975791 2349726 2349726 defendant Walton William, junior esq 700842 700842 Walton, William, junior, of Est Walton, esq 0
5030274 2365722 2365722 defendant Thakker William husbandman 700842 700842 Thakker, William, of Est Walton, husbandman 1
5035287 2367182 2367182 plaintiff Thacker William   700842 700842 Thacker, William, of Est Walton 0
5056433 2373500 2373500 defendant Taillour Ralph husbandman 700842 700842 Taillour, Ralph, of Est Walton, husbandman 0
5056434 2373500 2373500 defendant Nors Robert   700842 700842 together with Nors, Robert, of Est Walton 1
5074851 2378983 2378983 defendant Thakker William husbandman 700842 700842 Thakker, William, of Est Walton, husbandman 0
5117186 2391455 2391455 defendant Panche John butcher 700842 700842 Panche, John, of Est Walton, butcher 0
5122679 2393065 2393065 plaintiff Walton William esq 700842 700842 Walton, William, of Est Walton, esq 0
5124242 2393542 2393542 defendant Walton William esq 700842 700842 Walton, William, of Est Walton, esq 0
5134994 2396733 2396733 defendant Walton William esq 700842 700842 Walton, William, of East Walton, esq 3
5136305 2397137 2397137 defendant Pauche John butcher 700842 700842 Pauche, John, of East Walton, butcher 1
5139514 2398043 2398043 defendant Bocher Simon butcher 700842 700842 Bocher, Simon, of East Walton, butcher 0
5146062 2399972 2399972 defendant Grenelane William yeoman 700842 700842 Grenelane, William, of East Walton, yeoman 0
5146489 2400105 2400105 defendant Webster John yeoman 700842 700842 Webster, John, of East Walton, yeoman 2
5146493 2400106 2400106 defendant Webster John yeoman 700842 700842 Webster, John, of East Walton, yeoman 2
5166617 2405955 2405955 defendant Webster John yeoman 700842 700842 Webster, John, of East Walton, yeoman 2
5176763 2408889 2408889 plaintiff Walton William esq 700842 700842 Walton, William, of East Walton, esq 0
5199106 2415491 2415491 defendant Webster John yeoman 700842 700842 Webster, John, of East Walton, yeoman 1
5211204 2419006 2419006 defendant Panche John yeoman 700842 700842 (Panche, John, of East Walton, yeoman 1
5211237 2419016 2419016 defendant Panche John yeoman 700842 700842 Panche, John, of East Walton, yeoman 0
5222031 2422146 2422146 defendant Panche or Pauche John butcher 700842 700842 Panche or Pauche, John, of Est Walton, butcher 1
5222032 2422146 2422146 defendant Grenelane William husbandman 700842 700842 Grenelane, William, of Est Walton, husbandman 2
5266629 2435316 2435316 plaintiff Walton William esq 700842 700842 Walton, William, of Est Walton, esq 0
5289536 2441941 2441941 defendant Gay William husbandman 700842 700842 Gay, William, of Est Walton, husbandman 2
5289537 2441941 2441941 defendant Aggys Richard husbandman 700842 700842 Aggys, Richard, of Est Walton, husbandman 3
5339407 2456895 2456895 defendant Gay William husbndman 700842 700842 Gay, William, of Est Walton, husbndman 0
5411307 2478340 2478340 defendant Sweale Thomas   700842 700842 Sweale, Thomas, of East Walton, shepherd 1
5441331 2487324 2487324 plaintiff (illegible) William   700842 700842 _, William, of East Walton 0
5519077 2510812 2510812 plaintiff Baker William, senior (legal representative) 700842 700842 Baker, William, senior, of Est Walton, executors of 0
5534229 2515236 2515236 defendant Sewale Thomas husbandman 700842 700842 Sewale, Thomas, of Est Walton, husbandman 3
5536819 2516002 2516002 defendant West John husbandman 700842 700842 West, John, of Est Walton, husbandman 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);