names

80 rows where place_id = 596246

✎ 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
3623853 1874990 1874990 defendant Everard alias Neweman William husbandman 596246 596246 Everard alias Neweman, William, of Henton, husbandman 0
3654268 1911594 1911594 defendant Witney William husbandman 596246 596246 Witney, William, of Henton, husbandman 1
3701845 1926826 1926826 defendant Wade William husbandman 596246 596246 Wade, William, of Henton, husbandman 1
3732904 1936515 1936515 defendant Monby Thomas   596246 596246 Monby, Thomas, of Henton 0
3756296 1943930 1943930 defendant Hall Thomas gent 596246 596246 Hall, Thomas, of Henton, gent 0
3793211 1955735 1955735 defendant Wytteney Richard husbandman 596246 596246 Wytteney, Richard, of Henton, husbandman 0
3793213 1955736 1955736 defendant Wytteney Richard husbandman 596246 596246 Wytteney, Richard, of Henton, husbandman 0
3818112 1963577 1963577 defendant Boner Thomas husbandman 596246 596246 Boner, Thomas, of Henton, husbandman 0
3862486 1977649 1977649 defendant Stevyns Stephen husbandman 596246 596246 Stevyns, Stephen, of Henton, husbandman 2
3862487 1977649 1977649 defendant Johnson Henry husbandman 596246 596246 Johnson, Henry, of Henton, husbandman 3
3862488 1977649 1977649 defendant Selat John husbandman 596246 596246 Selat, John, of Henton, husbandman 4
3862489 1977649 1977649 defendant Clerke John carpenter 596246 596246 Clerke, John, of Henton, carpenter 5
3862490 1977649 1977649 defendant Mede Edward carpenter 596246 596246 Mede, Edward, of Henton, carpenter 6
3862491 1977649 1977649 defendant Bygge Thomas husbandman 596246 596246 Bygge, Thomas, of Henton, husbandman 7
3862492 1977649 1977649 defendant Mondy William laborer 596246 596246 Mondy, William, of Henton, laborer 8
3885100 1985276 1985276 plaintiff Baker John   596246 596246 Baker, John, of Henton 0
3904762 1991851 1991851 defendant Symes Richard butcher 596246 596246 Symes, Richard, of Henton, butcher 3
3969798 2014042 2014042 defendant Bartor John yeoman 596246 596246 Bartor, John, of Henton, yeoman 0
4040907 2039237 2039237 plaintiff Morye John clerk 596246 596246 Morye, John, of Henton, clerk 0
4059221 2045696 2045696 plaintiff Collyns William   596246 596246 Collyns, William, of Henton 0
4177729 2087684 2087684 defendant Owsley John, senior victualer 596246 596246 Owsley, John, senior, of Henton, victualer 0
4329143 2140059 2140059 defendant Chappell John yeoman 596246 596246 Chappell, John, of Henton, yeoman 0
4450053 2184973 2184973 defendant Benyn John   596246 596246 Benyn, John, of Henton 2
4462675 2189024 2189024 defendant Cook John   596246 596246 Cook, John, of Henton 0
4476417 2193289 2193289 defendant Purse Walter   596246 596246 Purse, Walter, of Henton 0
4480513 2194569 2194569 defendant Gore John   596246 596246 Gore, John, of Henton 0
4481684 2194969 2194969 defendant Johan John   596246 596246 Johan, John, of Henton 0
4519086 2206325 2206325 defendant Wyn Thomas   596246 596246 Wyn, Thomas, of Henton, prior 0
4552350 2216687 2216687 defendant Shoteswell William   596246 596246 Shoteswell, William, of Henton 0
4554031 2217182 2217182 defendant Chapell Robert   596246 596246 Chapell, Robert, of Henton 0
4554032 2217182 2217182 defendant Fayrey John   596246 596246 Fayrey, John, of Henton 1
4554033 2217182 2217182 defendant Abbot John chaplain 596246 596246 together with Abbot, John, of Henton, chaplain 2
4557047 2218131 2218131 defendant Smyth Nicholas   596246 596246 Smyth, Nicholas, of Henton 0
4558677 2218668 2218668 defendant Shoteswell William   596246 596246 Shoteswell, William, of Henton 0
4565543 2220794 2220794 defendant Havell Hugh   596246 596246 Havell, Hugh, of Henton 2
4570860 2222453 2222453 defendant Cole John   596246 596246 Cole, John, of Henton, son of William 0
4573805 2223324 2223324 defendant Shottiswell William   596246 596246 Shottiswell, William, of Henton 0
4579376 2225027 2225027 defendant Dawe Thomas   596246 596246 Dawe, Thomas, of Henton 2
4579380 2225028 2225028 defendant Dawe Thomas   596246 596246 Dawe, Thomas, of Henton 1
4614722 2235617 2235617 defendant Webbe John   596246 596246 Webbe, John, of Henton 1
4628504 2239836 2239836 plaintiff Schort William   596246 596246 Schort, William, of Henton 0
4630134 2240338 2240338 defendant Mulle Thomas   596246 596246 Mulle, Thomas, of Henton 0
4634264 2241557 2241557 defendant Dolle John (legal representative) 596246 596246 Dolle, John, of Henton, executors of 0
4634266 2241557 2241557 defendant Cornyssh Thomas   596246 596246 Cornyssh, Thomas, of Henton 2
4636622 2242281 2242281 defendant Levys Robert   596246 596246 Levys, Robert, of Henton 1
4639266 2243001 2243001 defendant Balle John   596246 596246 Balle, John, of Henton 1
4704339 2266734 2266734 defendant Ryssheton William yeoman 596246 596246 Ryssheton, William, of Henton, yeoman 1
4725972 2273408 2273408 defendant Stevenes John   596246 596246 Stevenes, John, of Henton, wool monger 3
4748468 2280055 2280055 defendant Chaper William butcher 596246 596246 Chaper, William, of Henton, butcher 1
4751298 2280858 2280858 defendant Jervoys John merchant 596246 596246 Jervoys, John, of Henton, merchant 0
4751299 2280858 2280858 defendant Jervoys John butcher 596246 596246 Jervoys, John, of Henton, butcher 1
4751300 2280858 2280858 defendant Jervoys Robert butcher 596246 596246 Jervoys, Robert, of Henton, butcher 2
4751301 2280858 2280858 defendant Jervoyes John, junior husbandman 596246 596246 Jervoyes, John, junior, of Henton, husbandman 3
4776272 2288567 2288567 defendant Fyles Richard yeoman 596246 596246 Fyles, Richard, of Henton, yeoman 4
4784326 2291094 2291094 defendant Rose John husbandman 596246 596246 Rose, John, of Henton, husbandman 1
4791648 2293483 2293483 plaintiff Malyns Reginald gent 596246 596246 Malyns, Reginald, of Henton, gent 0
4796917 2295192 2295192 defendant Spiryng Thomas husbandman 596246 596246 Spiryng, Thomas, of Henton, husbandman 1
4817358 2301515 2301515 defendant Ilberd alias Bailly Mathew yeoman 596246 596246 Ilberd alias Bailly, Mathew, of Henton, yeoman 0
4828220 2304870 2304870 defendant Artour John husbandman 596246 596246 Artour, John, of Henton, husbandman 1
4852046 2312071 2312071 defendant Breton William husbandman 596246 596246 Breton, William, of Henton, husbandman 1
4877467 2319909 2319909 defendant Cope Richard, junior husbandman 596246 596246 Cope, Richard, junior, of Henton, husbandman 0
4893932 2324802 2324802 defendant Gladwyn Nicholas husbandman 596246 596246 Gladwyn, Nicholas, of Henton, husbandman 3
4903566 2327726 2327726 defendant Gladewyn Nicholas husbandman 596246 596246 Gladewyn, Nicholas, of Henton, husbandman 1
4978508 2350521 2350521 plaintiff Rokes John gent 596246 596246 Rokes, John, of Henton, gent 0
4995609 2355525 2355525 defendant Jerveys John   596246 596246 Jerveys, John, of Henton, laborer, son of John 0
5038522 2368163 2368163 defendant Bysshop Edward   596246 596246 Bysshop, Edward, of Henton, servant 0
5045262 2370212 2370212 defendant Barnard William husbandman 596246 596246 Barnard, William, of Henton, husbandman 0
5069703 2377436 2377436 plaintiff Rookes John esq 596246 596246 Rookes, John, of Henton, esq 0
5104614 2387785 2387785 defendant Berehill William husbandman 596246 596246 Berehill, William, of Henton, husbandman 0
5121545 2392733 2392733 defendant Gordon John husbandman 596246 596246 Gordon, John, of Henton, husbandman 0
5240080 2427299 2427299 defendant Chaper John husbandman 596246 596246 Chaper, John, of Henton Abbot, husbandman 1
5293636 2443102 2443102 defendant Crowecher John husbandman 596246 596246 Crowecher, John, of Henton, husbandman 4
5359628 2463046 2463046 defendant Ryche William, junior yeoman 596246 596246 Ryche, William, junior, of Henton, yeoman 0
5454081 2491115 2491115 defendant Barnard John husbandman 596246 596246 Barnard, John, of Henton, husbandman 2
5478229 2498516 2498516 defendant Bocher John husbandman 596246 596246 Bocher, John, of Henton, husbandman 0
5615952 2548787 2548787 defendant Pekke John mercer 596246 596246 Pekke, John, of Henton, mercer 0
5617160 2549181 2549181 defendant Stacy John   596246 596246 Stacy, John, of Henton 0
5617976 2549436 2549436 defendant Cook Joan   596246 596246 Cook, Joan, of Henton, formerly wife of Richard 1
5623491 2551279 2551279 defendant Lecynyn John   596246 596246 Lecynyn, John, of Henton 2
5632155 2554080 2554080 defendant Iman William husbandman 596246 596246 Iman, William, of Henton, husbandman 2

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