names

61 rows where place_id = 587039

✎ 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
3590320 1864615 1864615 defendant Higgys John yeoman 587039 587039 Higgys, John, of Whityngton, yeoman 1
3611074 1871140 1871140 defendant Couper John husbandman 587039 587039 Couper, John, of Whityngton, husbandman 0
3611075 1871140 1871140 defendant Sprentall John husbandman 587039 587039 Sprentall, John, of Whityngton, husbandman 1
3611076 1871140 1871140 defendant Chaddok Adam smith 587039 587039 Chaddok, Adam, of Whityngton, smith 2
3611077 1871140 1871140 defendant Grey Alice widow 587039 587039 Grey, Alice, of Whityngton, widow 3
3616448 1872782 1872782 defendant Onley John gent 587039 587039 Onley, John, of Whityngton, gent 0
3617361 1873049 1873049 defendant Person Richard husbandman 587039 587039 Person, Richard, of Whityngton, husbandman 10
3620206 1873898 1873898 defendant Stone Thomas husbandman 587039 587039 Stone, Thomas, of Whityngton, husbandman 0
3716845 1931557 1931557 defendant Austen Thomas husbandman 587039 587039 Austen, Thomas, of Whityngton, husbandman 0
3719668 1932418 1932418 defendant Sheynton Richard weaver 587039 587039 Sheynton, Richard, of Whityngton, weaver 1
3845658 1972187 1972187 defendant Pereson James butcher 587039 587039 Pereson, James, of Whityngton, butcher 0
4208768 2098614 2098614 defendant Wall John husbandman 587039 587039 Wall, John, of Whityngton, husbandman 0
4456194 2186954 2186954 defendant Tomkynson John   587039 587039 Tomkynson, John, of Whityngton 1
4456197 2186955 2186955 defendant Tomlynson John   587039 587039 Tomlynson, John, of Whityngton 0
4599791 2231158 2231158 defendant Wodewarde John   587039 587039 Wodewarde, John, of Whityngton 0
4654738 2247360 2247360 defendant Hunt Henry yeoman 587039 587039 Hunt, Henry, of Whityngton, yeoman 0
4662275 2249674 2249674 defendant Fox Edmund ploughman 587039 587039 Fox, Edmund, of Whityngton, ploughman 3
4707374 2267682 2267682 defendant Parker Robert husbandman 587039 587039 Parker, Robert, of Whityngton, husbandman 0
4707375 2267682 2267682 defendant Neld Thomas husbandman 587039 587039 Neld, Thomas, of Whityngton, husbandman 1
4707376 2267682 2267682 defendant Webbe Richard husbandman 587039 587039 Webbe, Richard, of Whityngton, husbandman 2
4707377 2267682 2267682 defendant Saunderson John husbandman 587039 587039 Saunderson, John, of Whityngton, husbandman 3
4736312 2276485 2276485 defendant Gervays Richard yeoman 587039 587039 Gervays, Richard, of Whityngton, yeoman 0
4761086 2283819 2283819 defendant Bugge Robert husbandman 587039 587039 Bugge, Robert, of Whityngton, husbandman 1
4761087 2283819 2283819 defendant Letkyn Richard husbandman 587039 587039 Letkyn, Richard, of Whityngton, husbandman 2
4761088 2283819 2283819 defendant Littul Alexander laborer 587039 587039 Littul, Alexander, of Whityngton, laborer 3
4781669 2290280 2290280 defendant Hunt Hugh husbandman 587039 587039 Hunt, Hugh, of Whityngton, husbandman 0
4821260 2302729 2302729 defendant Whityngton Reginald gent 587039 587039 Whityngton, Reginald, of Whityngton, gent 2
4827511 2304652 2304652 defendant Aylmon John husbandman 587039 587039 Aylmon, John, of Whityngton, husbandman 0
4842161 2309086 2309086 defendant Banes Richard yeoman 587039 587039 Banes, Richard, of Whityngton, yeoman 2
4955240 2343527 2343527 defendant Eryngton John gent 587039 587039 Eryngton, John, of Whityngton, gent 0
4955241 2343527 2343527 defendant Eryngton Hugh gent 587039 587039 Eryngton, Hugh, of Whityngton, gent 1
4955242 2343527 2343527 defendant Eryngton William gent 587039 587039 Eryngton, William, of Whityngton, gent 2
4973662 2349074 2349074 defendant Frogmer Walter husbandman 587039 587039 Frogmer, Walter, of Whityngton, husbandman 0
4994189 2355137 2355137 defendant Aylmond John husbandman 587039 587039 Aylmond, John, of Whityngton, husbandman 2
5007171 2358988 2358988 defendant Broke John husbandman 587039 587039 Broke, John, of Whityngton, husbandman 0
5007172 2358988 2358988 defendant Hunte Hugh husbandman 587039 587039 Hunte, Hugh, of whityngton, husbandman 1
5007173 2358988 2358988 defendant Fox John laborer 587039 587039 Fox, John, of Whityngton, laborer 2
5008439 2359359 2359359 defendant Haynys Thomas   587039 587039 Haynys, Thomas, of Whityngton, parson 0
5014041 2360960 2360960 defendant Marten Thomas husbandman 587039 587039 Marten, Thomas, of Whityngton, husbandman 0
5021714 2363248 2363248 defendant Fox John husbandman 587039 587039 Fox, John, of Whityngton, husbandman 3
5059869 2374517 2374517 defendant Smyth William laborer 587039 587039 Smyth, William, of Whityngton, laborer 2
5219028 2421295 2421295 defendant Acton John esq 587039 587039 Acton, John, of Whityngton, esq 0
5219029 2421295 2421295 defendant Bokenhill John yeoman 587039 587039 Bokenhill, John, of Whityngton, yeoman 1
5219030 2421295 2421295 defendant Whitemere Nicholas yeoman 587039 587039 Whitemere, Nicholas, of Whityngton, yeoman 2
5219033 2421295 2421295 defendant Whitemere John yeoman 587039 587039 Whitemere, John, of Whityngton, yeoman 5
5277978 2438648 2438648 defendant Whityngton Reginald (legal representative) 587039 587039 Whityngton, Reginald, of Whityngton, gent, executor of 1
5288356 2441617 2441617 defendant Fydkyn John husbandman 587039 587039 Fydkyn, John, of Whityngton, husbandman 0
5372067 2466859 2466859 defendant Jonson William yeoman 587039 587039 Jonson, William, of Whityngton, yeoman 1
5372068 2466859 2466859 defendant Robynson Richard yeoman 587039 587039 Robynson, Richard, of Whityngton, yeoman 2
5372069 2466859 2466859 defendant Wilson Gilbert yeoman 587039 587039 Wilson, Gilbert, of Whityngton, yeoman 3
5394610 2473519 2473519 defendant Lede James yeoman 587039 587039 Lede, James, of Whityngton, yeoman 0
5402875 2475904 2475904 plaintiff Lupton Edward (legal representative) 587039 587039 Lupton, Edward, of Whityngton, master of the College, & executor of Gilbert Haydok, clerk, executors of 0
5405495 2476653 2476653 defendant Couper John   587039 587039 Couper, John, of Whityngton 0
5405496 2476653 2476653 defendant Couper Thomas butcher 587039 587039 Couper, Thomas, of Whityngton, butcher 1
5408091 2477391 2477391 defendant Lees James yeoman 587039 587039 Lees, James, of Whityngton, yeoman 1
5481491 2499395 2499395 defendant Sparke Robert husbandman 587039 587039 Sparke, Robert, of Whityngton, husbandman 3
5491153 2502254 2502254 defendant Slak Lawrence husbandman 587039 587039 Slak, Lawrence, of Whityngton, husbandman 1
5523234 2512096 2512096 defendant Person Thomas laborer 587039 587039 Person, Thomas, of Whityngton, laborer 2
5523238 2512097 2512097 defendant Tupman Richard weaver 587039 587039 Tupman, Richard, of Whityngton, weaver 0
5523240 2512097 2512097 defendant Dicon William tailor 587039 587039 Dicon, William, of Whityngton, tailor 2
5536107 2515786 2515786 defendant Grene John tailor 587039 587039 Grene, John, of Whityngton, tailor 1

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