names

65 rows where place_id = 590541

✎ 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
3601559 1868143 1868143 plaintiff Barbour John clerk 590541 590541 Barbour, John, of Howton, clerk 0
3680863 1920095 1920095 defendant Walpole Edward gent 590541 590541 Walpole, Edward, of Howton, gent 0
3730269 1935697 1935697 defendant Taillour Morgan yeoman 590541 590541 Taillour, Morgan, of Howton, yeoman 0
3750773 1942166 1942166 defendant Walpole Henry gent 590541 590541 Walpole, Henry, of Howton, gent 0
3766594 1947216 1947216 defendant Walpole Henry gent 590541 590541 Walpole, Henry, of Howton, gent 0
3769823 1948216 1948216 defendant Walpoole Edward gent 590541 590541 Walpoole, Edward, of Howton, gent 0
3803339 1958943 1958943 defendant Walpole Henry gent 590541 590541 Walpole, Henry, of Howton, gent 0
3812513 1961801 1961801 defendant Walpole Edward gent 590541 590541 Walpole, Edward, of Howton, gent 0
3844162 1971723 1971723 defendant Walpole Edward gent 590541 590541 Walpole, Edward, of Howton, gent 0
3861196 1977220 1977220 defendant Pegge Thomas gent 590541 590541 Pegge, Thomas, of Howton, gent 0
3883613 1984788 1984788 defendant Bownd John husbandman 590541 590541 Bownd, John, of Howton, husbandman 1
3898702 1989773 1989773 defendant Cocke Richard husbandman 590541 590541 Cocke, Richard, of Howton, husbandman 0
3965772 2012643 2012643 defendant Watkyn Philip smith 590541 590541 Watkyn, Philip, of Howton, smith 2
3988407 2020598 2020598 defendant Wylcock Simon yeoman 590541 590541 Wylcock, Simon, of Howton, or of Kenderchurche, yeoman 0
4000439 2024925 2024925 defendant Johnson John yeoman 590541 590541 Johnson, John, of Howton, yeoman 1
4038071 2038257 2038257 defendant ap Jenkyn Philip husbandman 590541 590541 ap Jenkyn, Philip, of Howton, husbandman 2
4042487 2039783 2039783 defendant ap Rosser Hugh yeoman 590541 590541 ap Rosser, Hugh, of Howton, yeoman 10
4042500 2039784 2039784 defendant ap Rosser Hugh Thomas yeoman 590541 590541 ap Rosser, Hugh Thomas, of Howton, yeoman 10
4053425 2043601 2043601 defendant Morgan Thomas yeoman 590541 590541 Morgan, Thomas, of Howton, yeoman 0
4053426 2043601 2043601 defendant Morgan David yeoman 590541 590541 Morgan, David, of Howton, yeoman 1
4053427 2043601 2043601 defendant ap Rees John gent 590541 590541 ap Rees, John, of Howton, gent 2
4053919 2043779 2043779 defendant Wilcoxe Simon yeoman 590541 590541 Wilcoxe, Simon, of Howton, yeoman 0
4056920 2044858 2044858 defendant Paget Guy salter 590541 590541 Paget, Guy, of Howton, salter 1
4056923 2044859 2044859 defendant Pagett Guy salter 590541 590541 Pagett, Guy, of Howton, salter 1
4061790 2046616 2046616 defendant Jenkyn Philip yeoman 590541 590541 Jenkyn, Philip, of Howton, yeoman 0
4067717 2048766 2048766 defendant Moris David Thomas yeoman 590541 590541 Moris, David Thomas, of Howton, yeoman 0
4067756 2048778 2048778 defendant Jolyff John laborer 590541 590541 Jolyff, John, of Howton, laborer 0
4069991 2049555 2049555 defendant Wilcok Simon yeoman 590541 590541 Wilcok, Simon, of Howton, yeoman 0
4072683 2050528 2050528 defendant Morys David Thomas yeoman 590541 590541 Morys, David Thomas, of Howton, yeoman 3
4072684 2050528 2050528 defendant Jenkyn Philip yeoman 590541 590541 Jenkyn, Philip, of Howton, yeoman 4
4075916 2051689 2051689 defendant Wylcocke Simon yeoman 590541 590541 Wylcocke, Simon, of Howton, yeoman 0
4075972 2051703 2051703 defendant Dounynge or Dunnynge Robert salter 590541 590541 Dounynge or Dunnynge, Robert, of Howton, salter 1
4076441 2051869 2051869 defendant Bawdhedd John husbandman 590541 590541 Bawdhedd, John, of Howton, husbandman 1
4081453 2053677 2053677 defendant ap Rees John gent 590541 590541 ap Rees, John, of Howton, gent 2
4083164 2054266 2054266 defendant Wylcoxe Simon yeoman 590541 590541 Wylcoxe, Simon, of Howton, yeoman 0
4106752 2062707 2062707 defendant Leachman Thomas smith 590541 590541 Leachman, Thomas, of Howton, smith 2
4119582 2067292 2067292 defendant Morgan John yeoman 590541 590541 Morgan, John, of Howton, yeoman 0
4152034 2078824 2078824 defendant Price John gent 590541 590541 Price, John, of Howton, gent 1
4170798 2085277 2085277 defendant Watkyn John Morgan yeoman 590541 590541 Watkyn, John Morgan, of Howton, yeoman 0
4219543 2102337 2102337 defendant Pytte Thomas yeoman 590541 590541 Pytte, Thomas, of Howton, yeoman 0
4219544 2102337 2102337 defendant Pytte William yeoman 590541 590541 Pytte, William, of Howton, yeoman 1
4224117 2103922 2103922 defendant Pigge Leonard yeoman 590541 590541 Pigge, Leonard, of Howton, yeoman 0
4227993 2105267 2105267 defendant Milton Hugh husbandman 590541 590541 Milton, Hugh, of Howton, husbandman 0
4234975 2107783 2107783 defendant Hall Thomas yeoman 590541 590541 Hall, Thomas, of Howton, yeoman 1
4245728 2111550 2111550 defendant Elvishe Emma widow 590541 590541 Elvishe, Emma, of Howton, widow 1
4248611 2112522 2112522 defendant Beatnif William laborer 590541 590541 Beatnif, William, of Howton, laborer 0
4248613 2112523 2112523 defendant Beatnif William laborer 590541 590541 Beatnif, William, of Howton, laborer 0
4257948 2115629 2115629 defendant Elvishe Emma widow 590541 590541 Elvishe, Emma, of Howton, widow 1
4263185 2117352 2117352 defendant Beatinf or Beatnif William laborer 590541 590541 Beatinf or Beatnif, William, of Howton, laborer 0
4347882 2146510 2146510 defendant Elvyshe George laborer 590541 590541 Elvyshe, George, of Howton, laborer 0
4367585 2153461 2153461 defendant Elvishe Robert husbandman 590541 590541 Elvishe, Robert, of Howton, husbandman 0
4367590 2153463 2153463 defendant Elvishe Robert husbandman 590541 590541 Elvishe, Robert, of Howton, husbandman 0
4394916 2162886 2162886 defendant Morgan John yeoman 590541 590541 Morgan, John, of Howton, yeoman 0
4394917 2162886 2162886 defendant Morgan Anne spinster 590541 590541 Morgan, Anne, of Howton, spinster 1
4403985 2165902 2165902 defendant Pytt William yeoman 590541 590541 Pytt, William, of Howton, yeoman 0
4408576 2167456 2167456 defendant Barter Henry yeoman 590541 590541 Barter, Henry, of Howton, yeoman 0
5054622 2372958 2372958 defendant Pratt John husbandman 590541 590541 Pratt, John, of Howton, husbandman 1
5229489 2424239 2424239 defendant Holond John husbandman 590541 590541 Holond, John, of Howton, husbandman 0
5248897 2429799 2429799 defendant West James husbandman 590541 590541 West, James, of Howton, husbandman 0
5422451 2481663 2481663 plaintiff Barbour John chaplain & rector 590541 590541 Barbour, John, of Howton, chaplain & rector 0
5422456 2481664 2481664 plaintiff Barbour John chaplain & rector 590541 590541 Barbour, John, of Howton, chaplain & rector 0
5442116 2487559 2487559 plaintiff Barbour John chaplain & rector 590541 590541 Barbour, John, of Howton, chaplain & rector 0
5454234 2491174 2491174 plaintiff (not given) John rector of _ 590541 590541 _, John, of Howton, rector of the church 0
5495726 2503616 2503616 defendant Sepens Thomas husbandman 590541 590541 Sepens, Thomas, of Howton, husbandman 0
5603050 2535838 2535838 defendant Tough William husbandman 590541 590541 Tough, William, of Howton, 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);