names

79 rows where place_id = 588130

✎ 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
3593471 1865593 1865593 plaintiff Hewys John   588130 588130 Hewys, John, of Huntyngfeld 0
3648711 1909984 1909984 defendant Larke William clerk 588130 588130 Larke, William, of Huntyngfeld, clerk 0
3676586 1918716 1918716 defendant Cotwayn Robert   588130 588130 Cotwayn, Robert, of Huntyngfeld, wheelwright 0
3747974 1941284 1941284 defendant Larke William clerk 588130 588130 Larke, William, of Huntyngfeld, clerk 0
3761369 1945566 1945566 defendant Blakey Robert husbandman 588130 588130 Blakey, Robert, of Huntyngfeld, husbandman 1
3813470 1962126 1962126 defendant Blakey Thomas husbandman 588130 588130 Blakey, Thomas, of Huntyngfeld, husbandman 0
3828037 1966635 1966635 defendant Russell Robert husbandman 588130 588130 Russell, Robert, of Huntyngfeld, husbandman 1
3832834 1968194 1968194 defendant Cotweyn William husbandman 588130 588130 Cotweyn, William, of Huntyngfeld, husbandman 1
3849727 1973502 1973502 defendant Cotwyn Edmund husbandman 588130 588130 Cotwyn, Edmund, of Huntyngfeld, husbandman 1
3854215 1974956 1974956 defendant Smyth Nicholas gent 588130 588130 Smyth, Nicholas, of Huntyngfeld, gent 0
3864076 1978169 1978169 defendant Richeman Henry husbandman 588130 588130 Richeman, Henry, of Huntyngfeld, husbandman 0
3868576 1979728 1979728 defendant Smyth Nicholas gent 588130 588130 Smyth, Nicholas, of Huntyngfeld, gent 1
3868579 1979729 1979729 defendant Smyth Nicholas gent 588130 588130 Smyth, Nicholas, of Huntyngfeld, gent 1
3868581 1979730 1979730 defendant Smyth Nicholas gent 588130 588130 Smyth, Nicholas, of Huntyngfeld, gent 0
3879695 1983464 1983464 defendant Russell Robert husbandman 588130 588130 Russell, Robert, of Huntyngfeld, husbandman 1
3879696 1983464 1983464 defendant Cotterell Thomas tailor 588130 588130 Cotterell, Thomas, of Huntyngfeld, tailor 2
3879697 1983464 1983464 defendant Canne Robert tailor 588130 588130 Canne, Robert, of Huntyngfeld, tailor 3
3881890 1984197 1984197 defendant Cotwyn Edmund husbandman 588130 588130 Cotwyn, Edmund, of Huntyngfeld, husbandman 0
3881893 1984197 1984197 defendant Blakey Thomas husbandman 588130 588130 Blakey, Thomas, of Huntyngfeld, husbandman 3
3886429 1985714 1985714 defendant Cotwyn Edmund husbandman 588130 588130 Cotwyn, Edmund, of Huntyngfeld, husbandman 0
3895406 1988674 1988674 defendant Cotwyn Edmund   588130 588130 Cotwyn, Edmund, of Huntyngfeld, wheelwright 1
3896021 1988871 1988871 defendant Smyth Nicholas gent 588130 588130 Smyth, Nicholas, of Huntyngfeld, gent 0
3897734 1989448 1989448 defendant Aldred Edmund butcher 588130 588130 Aldred, Edmund, of Huntyngfeld, butcher 4
3900180 1990284 1990284 defendant Salmon Andrew yeoman 588130 588130 Salmon, Andrew, of Huntyngfeld, yeoman 1
3900310 1990336 1990336 defendant Cotwyn Edward husbandman 588130 588130 Cotwyn, Edward, of Huntyngfeld, husbandman 0
3913055 1994696 1994696 defendant Burtur John carpenter 588130 588130 Burtur, John, of Huntyngfeld, carpenter 1
3917152 1996098 1996098 defendant Cotwan Edmund   588130 588130 Cotwan, Edmund, of Huntyngfeld, wheel wright 0
3923880 1998298 1998298 defendant Orlyslowe William husbandman 588130 588130 Orlyslowe, William, of Huntyngfeld, husbandman 1
3923881 1998298 1998298 defendant Bocle John husbandman 588130 588130 Bocle, John, of Huntyngfeld, husbandman 2
3927404 1999512 1999512 plaintiff Arrowsmyth Nicholas esq 588130 588130 Arrowsmyth, Nicholas, of Huntyngfeld, esq 0
3933741 2001580 2001580 defendant Blakey Thomas husbandman 588130 588130 Blakey, Thomas, of Huntyngfeld, husbandman 0
3948653 2006590 2006590 defendant Fossedyke Reginald butcher 588130 588130 Fossedyke, Reginald, of Huntyngfeld, butcher 0
3959618 2010458 2010458 plaintiff Smyth Alice (legal representative) 588130 588130 Smyth, Alice, of Huntyngfeld, widow or Robert Smyth, executors of 0
3961167 2010999 2010999 defendant Boller James   588130 588130 Boller, James, of Huntyngfeld, wheelwright 0
3963769 2011932 2011932 plaintiff Aleyn Robert gent 588130 588130 Aleyn, Robert, of Huntyngfeld, gent 0
3980154 2017668 2017668 plaintiff Paston John esq 588130 588130 Paston, John, of Huntyngfeld, esq 0
3984081 2019073 2019073 plaintiff Stubbard Augustine   588130 588130 Stubbard, Augustine, of Huntyngfeld 0
3984084 2019074 2019074 plaintiff Stubbard Augustine yeoman 588130 588130 Stubbard, Augustine, of Huntyngfeld, yeoman 0
3984092 2019077 2019077 plaintiff Stubberd Augustine   588130 588130 Stubberd, Augustine, of Huntyngfeld 0
3984860 2019340 2019340 plaintiff Thurston Edmund husbandman 588130 588130 Thurston, Edmund, of Huntyngfeld, husbandman 0
3984863 2019341 2019341 plaintiff Thurston Edmund husbandman 588130 588130 Thurston, Edmund, of Huntyngfeld, husbandman 0
3984866 2019342 2019342 plaintiff Thurston Edmund husbandman 588130 588130 Thurston, Edmund, of Huntyngfeld, husbandman 0
4010304 2028451 2028451 defendant Sudbury William yeoman 588130 588130 Sudbury, William, of Huntyngfeld, yeoman 0
4021843 2032542 2032542 plaintiff Aleyn Thomas   588130 588130 Aleyn, Thomas, of Huntyngfeld, gent, attorney of the bench 0
4021845 2032543 2032543 plaintiff Aleyn Thomas   588130 588130 Aleyn, Thomas, of of Huntyngfeld, gent, attorney of the bench 0
4060307 2046085 2046085 defendant Ryck John laborer 588130 588130 Ryck, John, of Huntyngfeld, laborer 2
4137909 2073915 2073915 defendant Milles Thomas husbandman 588130 588130 Milles, Thomas, of Huntyngfeld, husbandman 2
4440271 2181872 2181872 defendant Bulmer John   588130 588130 Bulmer, John, of Huntyngfeld 0
4442253 2182510 2182510 plaintiff Bron Thomas   588130 588130 Bron, Thomas, of Huntyngfeld, parson 0
4449680 2184848 2184848 defendant Horne Thomas   588130 588130 Horne, Thomas, of Huntyngfeld, parson 1
4451700 2185504 2185504 plaintiff Horn Thomas   588130 588130 Horn, Thomas, of Huntyngfeld, parson 0
4469280 2191061 2191061 defendant Edward John chaplain 588130 588130 Edward, John, of Huntyngfeld, chaplain 0
4701153 2265766 2265766 plaintiff Fryston William   588130 588130 Fryston, William, of Huntyngfeld 0
4701154 2265766 2265766 defendant Oldecroft John husbandman 588130 588130 Oldecroft, John, of Huntyngfeld, husbandman 0
4713446 2269527 2269527 defendant Powelyn John husbandman 588130 588130 Powelyn, John, of Huntyngfeld, husbandman 2
4889548 2323527 2323527 defendant Warde Stephen   588130 588130 Warde, Stephen, of Huntyngfeld, wright 2
4889549 2323527 2323527 defendant Baret Robert laborer 588130 588130 Baret, Robert, of Huntyngfeld, laborer 3
4891879 2324193 2324193 defendant Warde Stephen   588130 588130 Warde, Stephen, of Huntyngfeld, wright 2
4891880 2324193 2324193 defendant Baret Robert laborer 588130 588130 Baret, Robert, of Huntyngfeld, laborer 3
4913280 2330653 2330653 defendant Duffeld Nicholas yeoman 588130 588130 Duffeld, Nicholas, of Huntyngfeld, yeoman 0
4916308 2331603 2331603 defendant Parbere John husbandman 588130 588130 Parbere, John, of Huntyngfeld, husbandman 4
4988703 2353578 2353578 defendant Wyvyle Robert gent 588130 588130 Wyvyle, Robert, of Huntyngfeld, gent 0
4997311 2356046 2356046 defendant Wyvyle Robert gent 588130 588130 Wyvyle, Robert, of Huntyngfeld, gent 0
5040134 2368648 2368648 defendant Wylvyle Robert gent 588130 588130 Wylvyle, Robert, of Huntyngfeld, gent 0
5041479 2369055 2369055 defendant Smith Henry butcher 588130 588130 Smith, Henry, of Huntyngfeld, butcher 3
5044410 2369958 2369958 defendant Wyvyle Robert esq 588130 588130 Wyvyle, Robert, of Huntyngfeld, esq 0
5071524 2377979 2377979 defendant Wylleye Geoffrey husbandman 588130 588130 Wylleye, Geoffrey, of Huntyngfeld, husbandman 0
5226318 2423364 2423364 defendant Welby Geoffrey husbandman 588130 588130 Welby, Geoffrey, of Huntyngfeld, husbandman 0
5257691 2432526 2432526 plaintiff Fyn Henry   588130 588130 Fyn, Henry, of Huntyngfeld 0
5257692 2432526 2432526 plaintiff Parys William   588130 588130 Parys, William, of Huntyngfeld 1
5369138 2465948 2465948 defendant Rykwade Henry husbandman 588130 588130 Rykwade, Henry, of Huntyngfeld, husbandman 0
5369143 2465949 2465949 defendant Rykward Henry husbandman 588130 588130 Rykward, Henry, of Huntyngfeld, husbandman 0
5450486 2490030 2490030 defendant Pygot John husbandman 588130 588130 Pygot, John, of Huntyngfeld, husbandman 1
5462623 2493732 2493732 defendant Pygot John husbandman 588130 588130 Pygot, John, of Huntyngfeld, husbandman 1
5462626 2493733 2493733 defendant Pygot John husbandman 588130 588130 Pygot, John, of Huntyngfeld, husbandman 1
5474180 2497250 2497250 defendant Pygot John husbandman 588130 588130 Pygot, John, of Huntyngfeld, husbandman 1
5541239 2517380 2517380 defendant Rosyngton Richard yeoman 588130 588130 Rosyngton, Richard, of Huntyngfeld, yeoman 1
5541241 2517380 2517380 defendant Strynger Richard yeoman 588130 588130 Strynger, Richard, of Huntyngfeld, yeoman 3
5543611 2518107 2518107 defendant Barfot Edmund husbandman 588130 588130 Barfot, Edmund, of Huntyngfeld, husbandman 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);