names

39 rows where place_id = 651618

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3918926 1996651 1996651 defendant Algood Leonard husbandman 651618 651618 Algood, Leonard, of Fen Drayton, husbandman 0
3946295 2005779 2005779 defendant Stockwell John tailor 651618 651618 (Stockwell, John, of Fen Drayton, tailor 2
3948925 2006690 2006690 defendant Woodwarde John husbandman 651618 651618 Woodwarde, John, of Fen Drayton, husbandman 0
3952538 2007955 2007955 defendant Woodwarde John husbandman 651618 651618 (Woodwarde, John, of Fen Drayton, husbandman 1
4176014 2087090 2087090 defendant Croxton Henry yeoman 651618 651618 Croxton, Henry, of Fen Drayton, yeoman 0
4176015 2087090 2087090 defendant Whytlocke William husbandman 651618 651618 Whytlocke, William, of Fen Drayton, husbandman 1
4330135 2140379 2140379 defendant Croxton Henry yeoman 651618 651618 Croxton, Henry, of Fen Drayton, yeoman 0
4478820 2194045 2194045 defendant Flekke John   651618 651618 Flekke, John, of Fen Drayton 0
4495127 2199163 2199163 defendant Davy John   651618 651618 Davy, John, of Fen Drayton 3
4495133 2199164 2199164 defendant Davy John   651618 651618 Davy, John, of Fen Drayton 3
4508194 2203039 2203039 plaintiff Crouchere William   651618 651618 Crouchere, William, of Fen Drayton, parson 3
4514871 2205066 2205066 defendant Mannyng John clerk 651618 651618 Mannyng, John, of Fen Drayton, clerk 1
4542408 2213518 2213518 plaintiff Crouchere William   651618 651618 (Crouchere, William, of Fen Drayton, parson 1
4542416 2213519 2213519 plaintiff Crouchere William   651618 651618 (Crouchere, William, of Fen Drayton, parson 1
4579991 2225228 2225228 defendant Smyth Walter   651618 651618 Smyth, Walter, of Fen Drayton 8
4592714 2229062 2229062 defendant Bernewell John   651618 651618 Bernewell, John, of Fen Drayton 0
4601060 2231561 2231561 defendant Crowechere William   651618 651618 Crowechere, William, of Fen Drayton 0
4601061 2231561 2231561 defendant Crowecher John   651618 651618 Crowecher, John, of Fen Drayton 1
4609655 2234114 2234114 defendant Davy John   651618 651618 Davy, John, of Fen Drayton 5
4638001 2242647 2242647 defendant Davy John   651618 651618 Davy, John, of Fen Drayton 3
4685930 2261190 2261190 defendant Smyth Walter husbandman 651618 651618 Smyth, Walter, of Fen Drayton, husbandman 1
4763702 2284637 2284637 plaintiff Gryme John clerk 651618 651618 Gryme, John, of Fen Drayton, clerk 0
4763703 2284637 2284637 defendant Madd William husbandman 651618 651618 Madd, William, of Fen Drayton, husbandman 0
4837814 2307760 2307760 defendant Mylys William yeoman 651618 651618 Mylys, William, of Fen Drayton, yeoman 2
4852423 2312174 2312174 defendant Pycard William chapman 651618 651618 Pycard, William, of Fen Drayton, chapman 3
5056853 2373624 2373624 defendant Myles William husbandman 651618 651618 Myles, William, of Fen Drayton, husbandman 0
5147206 2400323 2400323 defendant Plommer John carpenter 651618 651618 Plommer, John, of Fen Drayton, carpenter 0
5155228 2402677 2402677 defendant Boleyn William husbandman 651618 651618 Boleyn, William, of Fen Drayton, husbandman 0
5155229 2402677 2402677 defendant Boleyn Alice widow 651618 651618 Boleyn, Alice, of Fen Drayton, widow 1
5164229 2405274 2405274 defendant Mayday Simon husbandman 651618 651618 Mayday, Simon, of Fen Drayton, husbandman 4
5166999 2406081 2406081 defendant Plommer John carpenter 651618 651618 Plommer, John, of Fen Drayton, carpenter 0
5171944 2407508 2407508 defendant Boleyn William husbandman 651618 651618 Boleyn, William, of Fen Drayton, husbandman 0
5171945 2407508 2407508 defendant Boleyn Alice widow 651618 651618 Boleyn, Alice, of Fen Drayton, widow 1
5281563 2439673 2439673 defendant Boleyn Nicholas husbandman 651618 651618 Boleyn, Nicholas, of Fen Drayton, husbandman 1
5355994 2461958 2461958 defendant Boure John yeoman 651618 651618 Boure, John, of Fen Drayton, yeoman 0
5382911 2470179 2470179 defendant Russheley William husbandman 651618 651618 Russheley, William, of Fen Drayton, husbandman 0
5382912 2470179 2470179 defendant Theyn John, senior husbandman 651618 651618 Theyn, John, senior, of Fen Drayton, husbandman 1
5564184 2524137 2524137 plaintiff Beton John   651618 651618 Beton, John, of Fen Drayton 0
5610329 2546938 2546938 defendant Sareson Roger butcher 651618 651618 Sareson, Roger, of Fen Drayton, butcher 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);