names

49 rows where place_id = 590236

✎ 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
3600331 1867748 1867748 defendant Eme John husbandman 590236 590236 Eme, John, of Earl Soham, husbandman 4
3704886 1927821 1927821 defendant Harman alias Hermer William yeoman 590236 590236 Harman alias Hermer, William, of Earl Soham, yeoman 0
3761254 1945522 1945522 plaintiff Eme John   590236 590236 Eme, John, of Earl Soham 0
3761337 1945553 1945553 defendant Lacy William tanner 590236 590236 Lacy, William, of Earl Soham, tanner 0
3761936 1945738 1945738 defendant Bedyngfeld William husbandman 590236 590236 Bedyngfeld, William, of Earl Soham, husbandman 1
3910794 1993931 1993931 defendant Fanner alias Weybe John yeoman 590236 590236 Fanner alias Weybe, John, of Earl Soham, yeoman 0
3910796 1993932 1993932 defendant Fanner alias Weybe John yeoman 590236 590236 Fanner alias Weybe, John, of Earl Soham, yeoman 0
4158780 2081145 2081145 defendant Lacye James husbandman 590236 590236 Lacye James, of Earl Soham, husbandman 2
4183977 2089894 2089894 defendant Game or Gaine John yeoman 590236 590236 Game or Gaine, John, of Earl Soham, yeoman 0
4188751 2091544 2091544 defendant Wade Arthur yeoman 590236 590236 Wade, Arthur, of Earl Soham, yeoman 1
4196158 2094202 2094202 defendant Lascy or Lacy Thomas tanner 590236 590236 Lascy or Lacy, Thomas, of Earl Soham, tanner 2
4204514 2097127 2097127 defendant Wade Arthur yeoman 590236 590236 Wade, Arthur, of Earl Soham, yeoman 0
4204618 2097160 2097160 defendant Ryvett John sawyer 590236 590236 Ryvett, John, of Earl Soham, sawyer 2
4220907 2102807 2102807 defendant Nicholl Robert yeoman 590236 590236 Nicholl, Robert, of Earl Soham, yeoman 1
4282845 2123898 2123898 defendant Foolkes Thomas husbandman 590236 590236 Foolkes, Thomas, of Earl Soham, husbandman 1
4307529 2132771 2132771 defendant Game or Gaine John carpenter 590236 590236 Game or Gaine, John, of Earl Soham, carpenter 2
4338535 2143230 2143230 defendant Samlen James yeoman 590236 590236 Samlen, James, of Earl Soham, yeoman 1
4393232 2162342 2162342 defendant Levick Simon yeoman 590236 590236 Levick, Simon, of Earl Soham, yeoman 0
4403659 2165799 2165799 defendant Nycolls Robert yeoman 590236 590236 Nycolls, Robert, of Earl Soham, yeoman 1
4738432 2277111 2277111 defendant Fox William ploughman 590236 590236 Fox, William, of Earl Soham, ploughman 0
4738433 2277111 2277111 defendant Homond John laborer 590236 590236 Homond, John, of Earl Soham, laborer 1
4738434 2277111 2277111 defendant Prest Richard chaplain 590236 590236 Prest, Richard, of Earl Soham, chaplain 2
4768304 2286057 2286057 defendant Wrestlyngworth John clerk 590236 590236 Wrestlyngworth, John, of Earl Soham, clerk 0
4775124 2288213 2288213 defendant Fox William yeoman 590236 590236 Fox, William, of Earl Soham, yeoman 0
4827194 2304553 2304553 plaintiff Wrastlyngwurth John   590236 590236 Wrastlyngwurth, John, of Earl Soham, parson 0
5074511 2378878 2378878 defendant Cakebred Thomas husbandman 590236 590236 Cakebred, Thomas, of Earl Soham, husbandman 1
5216226 2420481 2420481 defendant Fox Thomas husbandman 590236 590236 Fox, Thomas, of Earl Soham, husbandman 0
5263043 2434184 2434184 defendant Herman Alexander yeoman 590236 590236 Herman, Alexander, of Earl Soham, yeoman 0
5263044 2434184 2434184 defendant Cade James clerk 590236 590236 Cade, James, of Earl Soham, clerk 1
5280715 2439437 2439437 defendant Cade James clerk 590236 590236 Cade, James, of Earl Soham, clerk 0
5284198 2440398 2440398 plaintiff Foxe Thomas   590236 590236 Foxe, Thomas, of Earl Soham 0
5294117 2443252 2443252 defendant Dey Philip husbandman 590236 590236 Dey, Philip, of Earl Soham, husbandman 3
5294127 2443255 2443255 defendant Dey Philip husbandman 590236 590236 Dey, Philip, of Earl Soham, husbandman 2
5338989 2456765 2456765 defendant Deve Robert husbandman 590236 590236 Deve, Robert, of Earl Soham, husbandman 1
5338990 2456765 2456765 defendant Revet John smith 590236 590236 Revet, John, of Earl Soham, smith 2
5354648 2461531 2461531 defendant Rede William yeoman 590236 590236 Rede, William, of Earl Soham, yeoman 0
5414911 2479393 2479393 plaintiff Howard Thomas   590236 590236 Howard, Thomas, of Earl Soham 0
5414913 2479393 2479393 defendant Campell John laborer 590236 590236 Campell, John, of Earl Soham, laborer 1
5430865 2484173 2484173 plaintiff Howard Thomas   590236 590236 Howard, Thomas, of Earl Soham 0
5430869 2484174 2484174 plaintiff Howard Thomas   590236 590236 Howard, Thomas, of Earl Soham 0
5458104 2492331 2492331 defendant Harman Alexander yeoman 590236 590236 Harman, Alexander, of Earl Soham, yeoman 0
5483416 2499988 2499988 defendant Renet or Revet John yeoman 590236 590236 Renet or Revet, John, of Earl Soham, yeoman 0
5491761 2502435 2502435 defendant Revet John yeoman 590236 590236 Revet, John, of Earl Soham, yeoman 0
5491763 2502436 2502436 defendant Revet John yeoman 590236 590236 Revet, John, of Earl Soham, yeoman 0
5497395 2504159 2504159 defendant Boton Robert (legal representative) 590236 590236 Boton, Robert, of Earl Soham, husbandman, administrator of 2
5497396 2504159 2504159 defendant Boton John   590236 590236 Boton, John, of Earl Soham, husbandman, 3
5512193 2508675 2508675 defendant Boton Robert (legal representative) 590236 590236 Boton, Robert, of Earl Soham, husbandman, administrator of 0
5512194 2508675 2508675 defendant Boton John husbandman 590236 590236 Boton, John, of Earl Soham, husbandman 1
5534959 2515468 2515468 defendant Beket Richard husbandman 590236 590236 Beket, Richard, of Earl Soham, 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);