names

83 rows where place_id = 606750

✎ 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
3666397 1915441 1915441 defendant Wray John yoeman 606750 606750 Wray, John, of Holbyche, yoeman 0
3719782 1932450 1932450 defendant Larke Robert yeoman 606750 606750 Larke, Robert, of Holbyche, yeoman 2
3758718 1944722 1944722 plaintiff Calowe Thomas (legal representative) 606750 606750 Calowe, Thomas, of Holbyche, yeoman, executors of 0
3758721 1944722 1944722 plaintiff Calowe William, senior   606750 606750 Calowe, William, senior, of Holbyche 3
3758728 1944723 1944723 plaintiff Calowe Thomas (legal representative) 606750 606750 Calowe, Thomas, of Holbyche, yeoman, executors of 0
3758731 1944723 1944723 plaintiff Calowe William, senior   606750 606750 Calowe, William, senior, of Holbyche 3
3758736 1944723 1944723 defendant Kyng William husbandman 606750 606750 Kyng, William, of Holbyche, husbandman 4
3758740 1944724 1944724 plaintiff Calowe Thomas (legal representative) 606750 606750 Calowe, Thomas, of Holbyche, yeoman, executors of 0
3758743 1944724 1944724 plaintiff Calowe William, senior   606750 606750 Calowe, William, senior, of Holbyche 3
3767987 1947625 1947625 plaintiff Ongar alias Sewker William mercer 606750 606750 Ongar alias Sewker, William, of Holbyche, mercer 0
3767988 1947625 1947625 plaintiff Blysset Thomas husbandman 606750 606750 Blysset, Thomas, of Holbyche, husbandman 1
3771375 1948739 1948739 plaintiff Sugar or Sewker William mercer 606750 606750 Sugar or Sewker, William, of Holbyche, mercer 0
3771376 1948739 1948739 plaintiff Blyssett Thomas husbandman 606750 606750 Blyssett, Thomas, of Holbyche, husbandman 1
3776820 1950492 1950492 plaintiff Calowe Thomas (legal representative) 606750 606750 Calowe, Thomas, of Holbyche, yeoman, executors of 0
3776823 1950492 1950492 plaintiff Calowe William, senior   606750 606750 Calowe, William, senior, of Holbyche 3
3776827 1950493 1950493 plaintiff Calowe Thomas (legal representative) 606750 606750 Calowe, Thomas, of Holbyche, yeoman, executors of 0
3776830 1950493 1950493 plaintiff Calowe William, senior   606750 606750 Calowe, William, senior, of Holbyche 3
3776834 1950494 1950494 plaintiff Calowe Thomas (legal representative) 606750 606750 Calowe, Thomas, of Holbyche, yeoman, executors of 0
3776837 1950494 1950494 plaintiff Calowe William, senior   606750 606750 Calowe, William, senior, of Holbyche 3
3776839 1950495 1950495 plaintiff Calowe Thomas (legal representative) 606750 606750 Calowe, Thomas, of Holbyche, yeoman, executors of 0
3776842 1950495 1950495 plaintiff Calowe William, senior   606750 606750 Calowe, William, senior, of Holbyche 3
3776846 1950497 1950497 plaintiff Calowe William   606750 606750 Calowe, William, of Holbyche 0
3788398 1954170 1954170 defendant Gybson Richard yeoman 606750 606750 Gybson, Richard, of Holbyche, yeoman 0
3829957 1967263 1967263 defendant Pye Thomas husbandman 606750 606750 Pye, Thomas, of Holbyche, husbandman 0
3834822 1968829 1968829 defendant Pye Thomas husbandman 606750 606750 Pye, Thomas, of Holbyche, husbandman 0
3837818 1969740 1969740 defendant Pye Thomas husbandman 606750 606750 Pye, Thomas, of Holbyche, husbandman 0
3840494 1970587 1970587 defendant Watson Robert husbandman 606750 606750 Watson, Robert, of Holbyche, husbandman 1
3842957 1971334 1971334 defendant Blyssytt Thomas, senior husbandman 606750 606750 Blyssytt, Thomas, senior, of Holbyche, husbandman 0
3842958 1971334 1971334 defendant Benett William husbandman 606750 606750 Benett, William, of Holbyche, husbandman 1
3842959 1971334 1971334 defendant Borowe Thomas husbandman 606750 606750 Borowe, Thomas, of Holbyche, husbandman 2
3843471 1971495 1971495 defendant Pyrcher Thomas sherman 606750 606750 Pyrcher, Thomas, of Holbyche, sherman 0
3846372 1972418 1972418 defendant Elman Henry yeoman 606750 606750 Elman, Henry, of Holbyche, yeoman 0
3868017 1979537 1979537 defendant Lamkyn John gent 606750 606750 Lamkyn, John, of Holbyche, gent 1
3876939 1982527 1982527 defendant Botheby Thomas husbandman 606750 606750 Botheby, Thomas, of Holbyche, husbandman 0
3876941 1982527 1982527 defendant Spowe John husbandman 606750 606750 Spowe, John, of Holbyche, husbandman 2
3877514 1982716 1982716 defendant Eston John husbandman 606750 606750 Eston, John, of Holbyche, husbandman 0
3877523 1982720 1982720 defendant Calowe William yeoman 606750 606750 Calowe, William, of Holbyche, yeoman 0
3887379 1986043 1986043 defendant Davy William yeoman 606750 606750 Davy, William, of Holbyche, yeoman 0
3887380 1986043 1986043 defendant Bennett John husbandman 606750 606750 Bennett, John, of Holbyche, husbandman 1
3890076 1986915 1986915 defendant Murre Thomas laborer 606750 606750 Murre, Thomas, of Holbyche, laborer 0
3890077 1986915 1986915 defendant Stawper Stephen laborer 606750 606750 Stawper, Stephen, of Holbyche, laborer 1
3890078 1986915 1986915 defendant Burton Thomas laborer 606750 606750 Burton, Thomas, of Holbyche, laborer 2
3894194 1988275 1988275 defendant Brodyng Thomas   606750 606750 Brodyng, Thomas, of Holbyche, salt weller 0
3895740 1988784 1988784 defendant Davy William yeoman 606750 606750 Davy, William, of Holbyche, yeoman 0
3895741 1988784 1988784 defendant Bennet John husbandman 606750 606750 Bennet, John, of Holbyche, husbandman 1
3900525 1990405 1990405 defendant Glatton John laborer 606750 606750 Glatton, John, of Holbyche, laborer 2
3906062 1992317 1992317 defendant Benett William, junior husbandman 606750 606750 Benett, William, junior, of Holbyche, husbandman 0
3914402 1995161 1995161 plaintiff Callowe William, senior   606750 606750 Callowe, William, senior, of Holbyche 1
3914406 1995162 1995162 defendant Blyssett Thomas husbandman 606750 606750 Blyssett, Thomas, of Holbyche, husbandman 0
3914407 1995162 1995162 defendant Johnson alias Glover William husbandman 606750 606750 Johnson alias Glover, William, of Holbyche, husbandman 1
3914408 1995162 1995162 defendant Robartson alias Brodyng Thomas   606750 606750 Robartson alias Brodyng, Thomas, of Holbyche, salt weller 2
3916519 1995901 1995901 defendant Marser John smith 606750 606750 Marser, John, of Holbyche, smith 1
3924680 1998569 1998569 defendant Byrde Richard laborer 606750 606750 Byrde, Richard, of Holbyche, laborer 1
3924681 1998569 1998569 defendant Owghty William husbandman 606750 606750 Owghty, William, of Holbyche, husbandman 2
3929516 2000219 2000219 defendant Browne William   606750 606750 Browne, William, of Holbyche, "shopre" or shepherd 2
3932408 2001127 2001127 defendant Gaunte Brian husbandman 606750 606750 Gaunte, Brian, of Holbyche, husbandman 1
3942437 2004482 2004482 defendant Pye Robert husbandman 606750 606750 Pye, Robert, of Holbyche, husbandman 1
3944880 2005304 2005304 defendant Heydon Anthony gent 606750 606750 Heydon, Anthony, of Holbyche, gent 0
3953383 2008252 2008252 defendant Day Charles laborer 606750 606750 Day, Charles, of Holbyche, laborer 1
3954166 2008531 2008531 defendant Gaunt Brian yeoman 606750 606750 Gaunt, Brian, of Holbyche, yeoman 2
3954168 2008531 2008531 defendant Noble Isabel (legal representative) 606750 606750 Noble, Isabel, of Holbyche, widow, executor of 4
3967852 2013386 2013386 defendant Foster Nicholas (legal representative) 606750 606750 Foster, Nicholas, of Holbyche, executors of 2
3967854 2013386 2013386 defendant Stowe William husbandman 606750 606750 Stowe, William, of Holbyche, husbandman 4
3967857 2013386 2013386 defendant Burnett William yeoman 606750 606750 Burnett, William, of Holbyche, yeoman 7
3967858 2013386 2013386 defendant Crompe William yeoman 606750 606750 Crompe, William, of Holbyche, yeoman 8
3972021 2014772 2014772 defendant West Thomas clerk 606750 606750 West, Thomas, of Holbyche, clerk 1
3985182 2019456 2019456 plaintiff Tunck William yeoman 606750 606750 Tunck, William, of Holbyche, yeoman 0
3992947 2022234 2022234 defendant Mayn Robert husbandman 606750 606750 Mayn, Robert, of Holbyche, husbandman 0
3992951 2022236 2022236 plaintiff Callowe William gent 606750 606750 Callowe, William, of Holbyche, gent 0
3992953 2022237 2022237 plaintiff Callowe William gent 606750 606750 Callowe, William, of Holbyche, gent 0
4005233 2026652 2026652 defendant Smyth Thomas husbandman 606750 606750 Smyth, Thomas, of Holbyche, husbandman 0
4048688 2041975 2041975 defendant Burnett Richard husbandman 606750 606750 Burnett, Richard, of Holbyche, husbandman 0
4058026 2045251 2045251 defendant Whyte Thomas gent 606750 606750 Whyte, Thomas, of Holbyche, gent 0
4058028 2045252 2045252 defendant Whyte Thomas gent 606750 606750 Whyte, Thomas, of Holbyche, gent 0
4058908 2045580 2045580 defendant Alderson John husbandman 606750 606750 Alderson, John, of Holbyche, husbandman 0
4081328 2053632 2053632 defendant Callocke Edward husbandman 606750 606750 Callocke, Edward, of Holbyche, husbandman 2
4081332 2053632 2053632 defendant Whyte Thomas esq 606750 606750 Whyte, Thomas, of Holbyche, esq 6
4081334 2053633 2053633 defendant White Thomas esq 606750 606750 White, Thomas, of Holbyche, esq 0
4088279 2056102 2056102 defendant Whyte Thomas gent 606750 606750 Whyte, Thomas, of Holbyche, gent 0
4139416 2074459 2074459 defendant Clerke Ambrose glover 606750 606750 Clerke, Ambrose, of Holbyche, glover 0
4235646 2108037 2108037 defendant Wilson William yeoman 606750 606750 Wilson, William, of Holbyche, yeoman 0
5035974 2367377 2367377 defendant Unet or Vuet John husbandman 606750 606750 Unet or Vuet, John, of Holbyche, husbandman 1
5356779 2462184 2462184 defendant Sawelkeld Roland gent 606750 606750 Sawelkeld, Roland, of Holbyche, gent 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);