names

45 rows where place_id = 617579

✎ 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
3720241 1932607 1932607 defendant Brandeley Richard gent 617579 617579 Brandeley, Richard, of Chesterton, Cams, gent 2
3764939 1946697 1946697 defendant Bray Richard goldsmith 617579 617579 Bray, Richard, of Chesterton, Cams, gent, and of London, goldsmith 0
3820123 1964172 1964172 defendant Adam Thomas yeoman 617579 617579 (Adam, Thomas, of Chesterton, Cams, yeoman 1
3865821 1978799 1978799 defendant Horne Thomas husbandman 617579 617579 Horne, Thomas, of Chesterton, Cams, husbandman 2
3970738 2014356 2014356 defendant Tebelde John (legal representative) 617579 617579 Tebelde, John, of Chesterton, Cams, yeoman, executors of 1
3983399 2018837 2018837 defendant Foster Richard innholder 617579 617579 Foster, Richard, of Chesterton, Cams, innholder 0
4034068 2036843 2036843 defendant Brakyn Richard esq 617579 617579 Brakyn, Richard, of Chesterton, Cams, esq 0
4034070 2036844 2036844 defendant Cobbe Richard yeoman 617579 617579 Cobbe, Richard, of Chesterton, Cams, yeoman 0
4052988 2043504 2043504 defendant Curdy Robert chapman 617579 617579 Curdy, Robert, of Chesterton, Cams, chapman 1
4054801 2044106 2044106 defendant Cobbe William yeoman 617579 617579 Cobbe, William, of Chesterton, Cams, yeoman 0
4054804 2044107 2044107 defendant Cobbe Richard yeoman 617579 617579 Cobbe, Richard, of Chesterton, Cams, yeoman 0
4061664 2046570 2046570 defendant Tusser Thomas gent 617579 617579 Tusser, Thomas, of Chesterton, Cams, or of Trinity College, Cambridge, gent 0
4063494 2047232 2047232 defendant Sawyer Michael yeoman 617579 617579 Sawyer, Michael, of Chesterton, Cams, yeoman 0
4063924 2047380 2047380 defendant Newsam John gent 617579 617579 Newsam, John, of Chesterton, Cams, gent 0
4075215 2051441 2051441 defendant Newseham John gent 617579 617579 Newseham, John, of Chesterton, Cams, gent 0
4089106 2056398 2056398 defendant Paryshe or Parrys Thomas, senior yeoman 617579 617579 Paryshe or Parrys, Thomas, senior, of Chesterton, Cams, yeoman 1
4093371 2057946 2057946 defendant Parishe Richard maltster 617579 617579 Parishe, Richard, of Chesterton, Cams, maltster 0
4097323 2059360 2059360 defendant Garrett Richard husbandman 617579 617579 Garrett, Richard, of Chesterton, Cams, husbandman 0
4097326 2059361 2059361 defendant Newsam John gent 617579 617579 Newsam, John, of Chesterton, Cams, gent 0
4099831 2060264 2060264 defendant Brakyn Richard esq 617579 617579 Brakyn, Richard, of Chesterton, Cams, esq 0
4109035 2063485 2063485 defendant Newsam John gent 617579 617579 Newsam, John, of Chesterton, Cams, gent 2
4118200 2066794 2066794 defendant Newsan John gent 617579 617579 Newsan, John, of Chesterton, Cams, gent 1
4127093 2069980 2069980 defendant Kyllyngback Robert chapman 617579 617579 Kyllyngback, Robert, of Chesterton, Cams, chapman 1
4160423 2081722 2081722 defendant Brakyn Thomas gent 617579 617579 Brakyn, Thomas, of Chesterton, Cams, gent 0
4208523 2098533 2098533 defendant Bolton James yeoman 617579 617579 Bolton, James, of Chesterton, Cams, yeoman 1
4208527 2098534 2098534 defendant Bolton James yeoman 617579 617579 Bolton, James, of Chesterton, Cams, yeoman 2
4259607 2116190 2116190 defendant Ranowe John yeoman 617579 617579 Ranowe, John, of Chesterton, Cams, yeoman 0
4307021 2132596 2132596 defendant Westley Robert yeoman 617579 617579 Westley, Robert, of Chesterton, Cams, yeoman 3
4334936 2141948 2141948 defendant Dawson Gregory miller 617579 617579 Dawson, Gregory, of Chesterton, Cams, or of Cambridge University, miller 0
4339293 2143509 2143509 defendant Genn John yeoman 617579 617579 Genn, John, of Chesterton, Cams, yeoman 1
4343213 2144899 2144899 defendant Newman Hugh bricklayer 617579 617579 Newman, Hugh,of Chesterton, Cams, bricklayer 0
4350126 2147301 2147301 defendant Dayntre Robert yeoman 617579 617579 Dayntre, Robert, of Chesterton, Cams, yeoman 0
4662392 2249712 2249712 defendant Hogge Thomas husbandman 617579 617579 Hogge, Thomas, of Chesterton, Cams, husbandman 0
4665115 2250569 2250569 defendant Britby Thomas husbandman 617579 617579 Britby, Thomas, of Chesterton, Cams, husbandman 0
4790977 2293270 2293270 defendant James John yeoman 617579 617579 James, John, of Chesterton, Cams, yeoman 1
4950862 2342239 2342239 defendant Battysford John gent 617579 617579 Battysford, John, of Chesterton, Cams, gent 1
4950866 2342240 2342240 defendant Batysford John gent 617579 617579 Batysford, John, of Chesterton, Cams, gent 1
4974097 2349215 2349215 defendant Batisford John gent 617579 617579 Batisford, John, of Chesterton, Cams, gent 1
5065144 2376110 2376110 plaintiff Lounell or Louvell John gent 617579 617579 Lounell or Louvell, John, of Chesterton, Cams, gent 0
5065146 2376111 2376111 plaintiff Lounell or Louvell John gent 617579 617579 Lounell or Louvell, John, of Chesterton, Cams, gent 0
5100757 2386645 2386645 defendant Whitfeld John esq 617579 617579 Whitfeld, John, of Chesterton, Cams, esq 2
5247786 2429498 2429498 defendant Batisford John gent 617579 617579 Batisford, John, of Chesterton, Cams, gent 0
5282115 2439841 2439841 defendant Haylys William husbandman 617579 617579 Haylys, William, of Chesterton, Cams, husbandman 4
5282124 2439843 2439843 defendant Haylys William husbandman 617579 617579 Haylys, William, of Chesterton, Cams, husbandman 4
5316406 2449986 2449986 defendant Parys John husbandman 617579 617579 Parys, John, of Chesterton, Cams, 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);