names

580 rows where place_id = 586751

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589528 1864361 1864361 defendant Bradowe William yeoman 586751 586751 Bradowe, William, of Holbech, yeoman 0
3591190 1864867 1864867 defendant Abrodhowe or Broddowe William yeoman or gent 586751 586751 Abrodhowe or Broddowe, William, of Holbech, yeoman or gent 1
3591192 1864868 1864868 defendant Callowe Richard husbandman 586751 586751 Callowe, Richard, of Holbech, husbandman 0
3600229 1867719 1867719 defendant Pulvertoft Gilbert yeoman 586751 586751 Pulvertoft, Gilbert, of Holbech, yeoman 0
3615305 1872432 1872432 defendant Hornsey William husbandman 586751 586751 Hornsey, William, of Holbech, husbandman 2
3618324 1873360 1873360 defendant Geyr Thomas husbandman 586751 586751 Geyr, Thomas, of Holbech, husbandman 1
3663994 1914683 1914683 defendant Weller William yeoman 586751 586751 Weller, William, of Holbech, yeoman 0
3676542 1918708 1918708 plaintiff Jervys William   586751 586751 Jervys, William, of Holbech, administrators of 0
3676544 1918708 1918708 plaintiff Jervys Richard   586751 586751 Jervys, Richard, of Holbech 2
3676549 1918709 1918709 plaintiff Jervys William   586751 586751 Jervys, William, of Holbech, administrators of 0
3676551 1918709 1918709 plaintiff Jervys Richard   586751 586751 Jervys, Richard, of Holbech 2
3676556 1918710 1918710 plaintiff Jervys William   586751 586751 Jervys, William, of Holbech, administrators of 0
3676558 1918710 1918710 plaintiff Jervys Richard   586751 586751 Jervys, Richard, of Holbech 2
3676560 1918710 1918710 defendant Lotys Simon yeoman 586751 586751 Lotys, Simon, of Holbech, yeoman 1
3676564 1918711 1918711 plaintiff Jervys William   586751 586751 Jervys, William, of Holbech, administrators of 0
3676566 1918711 1918711 plaintiff Jervys Richard   586751 586751 Jervys, Richard, of Holbech 2
3676567 1918711 1918711 defendant Hornssey William yeoman 586751 586751 Hornssey, William, of Holbech, yeoman 0
3676568 1918711 1918711 defendant Wright Adam   586751 586751 Wright, Adam, of Holbech, mill maker 1
3676569 1918711 1918711 defendant Parker Robert   586751 586751 Parker, Robert, of Holbech, tile maker 2
3676570 1918711 1918711 defendant Lytton William   586751 586751 Lytton, William, of Holbech, salt weller 3
3676571 1918712 1918712 plaintiff Jervys William   586751 586751 Jervys, William, of Holbech, administrators of 0
3676573 1918712 1918712 plaintiff Jervys Richard   586751 586751 Jervys, Richard, of Holbech 2
3676574 1918712 1918712 defendant Waston Godfrey   586751 586751 Waston, Godfrey, of Holbech, salt weller 0
3676575 1918712 1918712 defendant Watson Thomas   586751 586751 Watson, Thomas, of Holbech, salt weller 1
3679306 1919588 1919588 defendant Stapull John clerk 586751 586751 Stapull, John, of Holbech, clerk 0
3680395 1919951 1919951 defendant Cokke William husbandman 586751 586751 Cokke, William, of Holbech, husbandman 0
3705331 1927958 1927958 defendant Watson Geoffrey husbandman 586751 586751 Watson, Geoffrey, of Holbech, husbandman 0
3705332 1927958 1927958 defendant Leighton Thomas husbandman 586751 586751 Leighton, Thomas, of Holbech, husbandman 1
3705333 1927958 1927958 defendant Cokke William husbandman 586751 586751 Cokke, William, of Holbech, husbandman 2
3708982 1929103 1929103 defendant Pynder Thomas husbandman 586751 586751 Pynder, Thomas, of Holbech, husbandman 0
3708984 1929103 1929103 defendant Bradowe Thomas butcher 586751 586751 Bradowe, Thomas, of Holbech, butcher 2
3716143 1931337 1931337 defendant Benet William husbandman 586751 586751 Benet, William, of Holbech, husbandman 2
3725605 1934299 1934299 defendant Benet John husbandman 586751 586751 Benet, John, of Holbech, husbandman 0
3725607 1934299 1934299 defendant Waren John yeoman 586751 586751 Waren, John, of Holbech, yeoman 2
3725608 1934299 1934299 defendant Benet Thomas laborer 586751 586751 Benet, Thomas, of Holbech, laborer 3
3725614 1934300 1934300 defendant Pye Thomas butcher 586751 586751 Pye, Thomas, of Holbech, butcher 0
3729851 1935593 1935593 defendant Harvy Adam husbandman 586751 586751 Harvy, Adam, of Holbech, husbandman 0
3731190 1935978 1935978 defendant Shepard William   586751 586751 Shepard, William, of Holbech, shepherd 0
3741737 1939278 1939278 defendant Kyng William husbandman 586751 586751 Kyng, William, of Holbech, husbandman 0
3741738 1939278 1939278 defendant Clerke Agnes widow 586751 586751 Clerke, Agnes, of Holbech, widow 1
3741844 1939313 1939313 defendant Suger William glover 586751 586751 Suger, William, of Holbech, glover 0
3742098 1939397 1939397 defendant Howson Richard husbandman 586751 586751 Howson, Richard, of Holbech, husbandman 0
3742099 1939397 1939397 defendant Love Thomas husbandman 586751 586751 Love, Thomas, of Holbech, husbandman 1
3742100 1939397 1939397 defendant Byrde Hugh husbandman 586751 586751 Byrde, Hugh, of Holbech, husbandman 2
3754014 1943207 1943207 defendant Wynde Richard tailor 586751 586751 Wynde, Richard, of Holbech, tailor 0
3754125 1943237 1943237 defendant Swan John husbandman 586751 586751 Swan, John, of Holbech, husbandman 0
3775305 1950015 1950015 defendant Scott Thomas laborer 586751 586751 Scott, Thomas, of Holbech, laborer 0
3776817 1950490 1950490 defendant Pynder Thomas husbandman 586751 586751 Pynder, Thomas, of Holbech, husbandman 1
3805465 1959648 1959648 defendant Garnet Richard cooper 586751 586751 Garnet, Richard, of Holbech, cooper 0
3806783 1960024 1960024 defendant Betson Richard husbandman 586751 586751 Betson, Richard, of Holbech, husbandman 0
3820565 1964315 1964315 defendant Holand John husbandman 586751 586751 Holand, John, of Holbech, husbandman 0
3822598 1964974 1964974 defendant Howell Richard husbandman 586751 586751 Howell, Richard, of Holbech, husbandman 0
3822599 1964974 1964974 defendant Benet William husbandman 586751 586751 Benet, William, of Holbech, husbandman 1
3846162 1972355 1972355 defendant West John husbandman 586751 586751 West, John, of Holbech, husbandman 0
3848183 1972998 1972998 defendant Layton John husbandman 586751 586751 Layton, John, of Holbech, husbandman 0
3852560 1974410 1974410 defendant Jelowe Henry husbandman 586751 586751 Jelowe, Henry, of Holbech, husbandman 0
3852561 1974410 1974410 defendant Peretre Thomas husbandman 586751 586751 Peretre, Thomas, of Holbech, husbandman 1
3852562 1974410 1974410 defendant Pye Thomas husbandman 586751 586751 Pye, Thomas, of Holbech, husbandman 2
3894843 1988481 1988481 defendant Randes Nicholas husbandman 586751 586751 Randes, Nicholas, of Holbech, husbandman 0
4232911 2107019 2107019 defendant Bradley John yeoman 586751 586751 Bradley, John, of Holbech, yeoman 1
4279608 2122785 2122785 defendant Maile alias Prestley Philip husbandman 586751 586751 Maile alias Prestley, Philip, of Holbech, husbandman 0
4423862 2172315 2172315 plaintiff Heir Stephen   586751 586751 Heir, Stephen, of Holbech 0
4424123 2172400 2172400 plaintiff Holdere Leititia daughter of Peter 586751 586751 Holdere, Leititia, of Holbech, daughter of Peter 0
4424125 2172400 2172400 defendant Holdere Joan   586751 586751 Holdere, Joan, of Holbech, formerly wife of Peter 1
4425758 2172866 2172866 defendant Wallewyndere Everardus   586751 586751 Wallewyndere, Everardus, of Holbech 0
4433937 2175375 2175375 plaintiff Heire Stephen   586751 586751 Heire, Stephen, of Holbech 0
4441024 2182116 2182116 plaintiff Blakewell Robert   586751 586751 Blakewell, Robert, of Holbech 0
4441026 2182117 2182117 plaintiff Blakwell Robert de   586751 586751 Blakwell, Robert de, of Holbech 0
4444440 2183241 2183241 plaintiff Cok Robert   586751 586751 Cok, Robert, of Holbech, on his own account 0
4444441 2183241 2183241 defendant Emson John   586751 586751 Emson, John, of Holbech 0
4445584 2183573 2183573 defendant Benet Roger   586751 586751 Benet, Roger, of Holbech 0
4445586 2183573 2183573 defendant Emson John   586751 586751 Emson, John, of Holbech 2
4447577 2184160 2184160 plaintiff Emson John   586751 586751 Emson, John, of Holbech 0
4447578 2184160 2184160 defendant Wolwynder John   586751 586751 Wolwynder, John, of Holbech 0
4447692 2184200 2184200 plaintiff Everard John   586751 586751 Everard, John, of Holbech 0
4460793 2188435 2188435 plaintiff Smyth John   586751 586751 Smyth, John, of Holbech 0
4460794 2188435 2188435 defendant Care John, junior   586751 586751 Care, John, junior, of Holbech 0
4460795 2188436 2188436 plaintiff Smyth John   586751 586751 Smyth, John, of Holbech 0
4460798 2188437 2188437 plaintiff Smyth John   586751 586751 Smyth, John, of Holbech, on his own account 0
4460800 2188437 2188437 defendant Strongbowe William   586751 586751 Strongbowe, William, of Holbech 1
4460994 2188511 2188511 plaintiff Souder William   586751 586751 Souder, William, of Holbech 0
4462102 2188847 2188847 defendant Bicon Simon   586751 586751 Bicon, Simon, of Holbech 0
4465237 2189794 2189794 plaintiff Wirs Robert   586751 586751 Wirs, Robert, of Holbech 0
4468497 2190812 2190812 defendant Martyn John   586751 586751 Martyn, John, of Holbech, bailiff 0
4468499 2190813 2190813 defendant Martyn John   586751 586751 Martyn, John, of Holbech, bailiff 0
4474079 2192545 2192545 defendant Elys John   586751 586751 Elys, John, of Holbech 4
4477359 2193582 2193582 defendant Tomesson John   586751 586751 Tomesson, John, of Holbech 0
4478624 2193980 2193980 defendant Poule William   586751 586751 Poule, William, of Holbech, administrators of 1
4478626 2193980 2193980 defendant Olwyn William   586751 586751 Olwyn, William, of Holbech 3
4486246 2196406 2196406 defendant Cleres Richard   586751 586751 Cleres, Richard, of Holbech 0
4486778 2196579 2196579 defendant Spyrwhite Thomas   586751 586751 Spyrwhite, Thomas, of Holbech 0
4486779 2196579 2196579 defendant Cole Jo--   586751 586751 Cole, Jo--, of Holbech 1
4486780 2196579 2196579 defendant Jonson Godfrey   586751 586751 Jonson, Godfrey, of Holbech 2
4488442 2197104 2197104 defendant Dikson William   586751 586751 Dikson, William, of Holbech 1
4499393 2200463 2200463 defendant Magotesson John   586751 586751 Magotesson, John, of holbech 1
4500001 2200639 2200639 defendant Beler John   586751 586751 Beler, John, of Holbech 1
4500003 2200640 2200640 defendant Wymer Thomas   586751 586751 Wymer, Thomas, of Holbech 0
4505369 2202210 2202210 defendant atte Chapell Hugh   586751 586751 atte Chapell, Hugh, of Holbech 0
4520509 2206764 2206764 defendant Dyconson John   586751 586751 Dyconson, John, of Holbech 0
4521032 2206913 2206913 defendant Ruwold Richard   586751 586751 Ruwold, Richard, of Holbech 0

Next page

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);