names

38 rows where place_id = 611346

✎ 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
3687946 1922389 1922389 defendant Spicer Gilbert yeoman 611346 611346 Spicer, Gilbert, of Swafham Markett, yeoman 0
3724775 1934033 1934033 defendant Pavys or Panys Robert husbandman 611346 611346 Pavys or Panys, Robert, of Swafham Markett, husbandman 1
3727329 1934822 1934822 defendant Langham William husbandman 611346 611346 Langham, William, of Swafham Markett, husbandman 0
3729229 1935392 1935392 defendant Ymaye Simon husbandman 611346 611346 Ymaye, Simon, of Swafham Markett, husbandman 0
3729242 1935396 1935396 defendant Bosom Robert chaplain 611346 611346 Bosom, Robert, of Swafham Markett, chaplain 1
3729259 1935402 1935402 defendant Lagman John husbandman 611346 611346 Lagman, John, of Swafham Markett, husbandman 0
3749813 1941853 1941853 defendant Grygge Ambrose gent 611346 611346 Grygge, Ambrose, of Swafham Markett, gent 1
3750991 1942238 1942238 defendant Gryggis Alvered gent 611346 611346 Gryggis, Alvered, of Swafham Markett, gent 0
3774110 1949617 1949617 defendant Owold John beer brewer 611346 611346 Owold, John, of Swafham Markett, beer brewer 0
3779957 1951457 1951457 defendant Antyngham Nicholas husbandman 611346 611346 Antyngham, Nicholas, of Swafham Markett, husbandman 0
3799375 1957725 1957725 defendant Tanne Edmund shoemaker 611346 611346 Tanne, Edmund, of Swafham Markett, shoemaker 1
3802075 1958545 1958545 defendant Levyk John skinner 611346 611346 Levyk, John, of Swafham Markett, skinner 3
3810955 1961327 1961327 defendant Coo John husbandman 611346 611346 Coo, John, of Swafham Markett, husbandman 0
3819953 1964122 1964122 plaintiff Payn Walter   611346 611346 Payn, Walter, of Swafham Markett 0
3861127 1977201 1977201 plaintiff Eydd William   611346 611346 Eydd, William, of Swafham Markett, administrators of 0
3862736 1977729 1977729 defendant Levelowe Walter husbandman 611346 611346 Levelowe, Walter, of Swafham Markett, husbandman 0
3866156 1978910 1978910 plaintiff Payne Walter (legal representative) 611346 611346 Payne, Walter, of Swafham Markett, executor of 0
3881966 1984227 1984227 defendant Wesenam Gerard fletcher 611346 611346 Wesenam, Gerard, of Swafham Markett, fletcher 0
3890033 1986902 1986902 defendant Watson Thomas haberdasher 611346 611346 Watson, Thomas, of Swafham Markett, haberdasher 0
3890034 1986902 1986902 defendant Walter William yeoman 611346 611346 Walter, William, of Swafham Markett, yeoman 1
3890431 1987056 1987056 defendant Large Henry tailor 611346 611346 Large, Henry, of Swafham Markett, tailor 0
3890432 1987056 1987056 defendant Lebold John skinner 611346 611346 Lebold, John, of Swafham Markett, skinner 1
3896518 1989043 1989043 defendant Ryplyngham Richard (legal representative) 611346 611346 Ryplyngham, Richard, of Swafham Markett, beer brewer, executrix of 0
3913227 1994755 1994755 plaintiff Barwyke Robert   611346 611346 Barwyke, Robert, of Swafham Markett 0
3915696 1995624 1995624 defendant Hall John mercer 611346 611346 Hall, John, of Swafham Markett, mercer 0
3918201 1996420 1996420 defendant Fludd Richard butcher 611346 611346 Fludd, Richard, of Swafham Markett, butcher 2
3921360 1997487 1997487 defendant May Thomas laborer 611346 611346 May, Thomas, of Swafham Markett, laborer 0
3973820 2015412 2015412 defendant Raynolde Thomas butcher 611346 611346 Raynolde, Thomas, of Swafham Markett, butcher 0
3977404 2016668 2016668 defendant Morrell John tanner 611346 611346 Morrell, John, of Swafham Markett, tanner 0
3979429 2017393 2017393 plaintiff Nobes Robert husbandman 611346 611346 Nobes, Robert, of Swafham Markett, husbandman 0
3979430 2017393 2017393 defendant Purveys Thomas blacksmith 611346 611346 Purveys, Thomas, of Swafham Markett, blacksmith 0
4044176 2040370 2040370 plaintiff Qwippe alias Whyppe John clerk 611346 611346 Qwippe alias Whyppe, John, of Swafham Markett, clerk 0
4044178 2040371 2040371 plaintiff Qwippe or Whyppe John clerk 611346 611346 Qwippe or Whyppe, John, of Swafham Markett, clerk 0
4050346 2042555 2042555 defendant Skylman Thomas yeoman 611346 611346 Skylman, Thomas, of Swafham Markett, yeoman 1
4084582 2054762 2054762 defendant Tebbold Thomas husbandman 611346 611346 Tebbold, Thomas, of Swafham Markett, husbandman 2
4107541 2062984 2062984 defendant Armes Robert husbandman 611346 611346 Armes, Robert, of Swafham Markett, or of Massingham Parva, husbandman 0
4222125 2103229 2103229 defendant Graye Robert laborer 611346 611346 Graye, Robert, of Swafham Markett, laborer 1
4394956 2162898 2162898 defendant Holdynge or Holden John miller 611346 611346 Holdynge or Holden, John, of Swafham Markett, miller 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);