names

176 rows where place_id = 587914

✎ 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
3592816 1865366 1865366 defendant Kemys William yeoman 587914 587914 Kemys, William, of Compton, yeoman 0
3597374 1866800 1866800 defendant Cassy John esq 587914 587914 Cassy, John, of Compton, esq 0
3616851 1872900 1872900 defendant Page William husbandman 587914 587914 Page, William, of Compton, husbandman 2
3631365 1904621 1904621 plaintiff Gildon John, senior (legal representative) 587914 587914 Gildon, John, senior, of Compton, yeoman, executors of 0
3638256 1906786 1906786 defendant Chyverelt William husbandman 587914 587914 Chyverelt, William, of Compton, husbandman 3
3638814 1906960 1906960 defendant Whorewod John gent 587914 587914 Whorewod, John, of Compton, gent 1
3673354 1917682 1917682 defendant Fetiplace Thomas   587914 587914 Fetiplace, Thomas, of Compton, knight 0
3673356 1917683 1917683 defendant Fetiplace Thomas   587914 587914 Fetiplace, Thomas, of Compton, knight 0
3679552 1919673 1919673 defendant Salter William yeoman 587914 587914 Salter, William, of Compton, yeoman 2
3680091 1919839 1919839 defendant Whyghtwyk Thomas, senior yeoman 587914 587914 Whyghtwyk, Thomas, senior, of Compton, yeoman 0
3689657 1922923 1922923 defendant Hardyng William clerk 587914 587914 Hardyng, William, of Compton, clerk 0
3692962 1923999 1923999 defendant Whightwyke William husbandman 587914 587914 Whightwyke, William, of Compton, husbandman 1
3692969 1924000 1924000 defendant Toye Nicholas husbandman 587914 587914 Toye, Nicholas, of Compton, husbandman 3
3692970 1924000 1924000 defendant Witgwyke William husbandman 587914 587914 Witgwyke, William, of Compton, husbandman 4
3709171 1929165 1929165 defendant Pytman Richard husbandman 587914 587914 Pytman, Richard, of Compton, husbandman 0
3737493 1937968 1937968 defendant Wodwarde Joan widow 587914 587914 Wodwarde, Joan, of Compton, widow 1
3750356 1942030 1942030 defendant Howle Robert yeoman 587914 587914 Howle, Robert, of Compton, yeoman 1
3752967 1942860 1942860 defendant Salter William wheeler 587914 587914 Salter, William, of Compton, wheeler 0
3755558 1943695 1943695 defendant Rodford Thomas husbandman 587914 587914 Rodford, Thomas, of Compton, husbandman 0
3755559 1943695 1943695 defendant Mylward Robert husbandman 587914 587914 Mylward, Robert, of Compton, husbandman 1
3770442 1948435 1948435 defendant Wheler Thomas yeoman 587914 587914 Wheler, Thomas, of Compton, yeoman 1
3770443 1948435 1948435 defendant Chalner Henry husbandman 587914 587914 Chalner, Henry, of Compton, husbandman 2
3781383 1951918 1951918 defendant Wightwik John, junior yeoman 587914 587914 Wightwik, John, junior, of Compton, yeoman 2
3787406 1953855 1953855 defendant Dorry William husbandman 587914 587914 Dorry, William, of Compton, husbandman 0
3795371 1956422 1956422 defendant Style William husbandman 587914 587914 Style, William, of Compton, husbandman 0
3795372 1956422 1956422 defendant Codde James husbandman 587914 587914 Codde, James, of Compton, husbandman 1
3795373 1956422 1956422 defendant Wason Thomas husbandman 587914 587914 Wason, Thomas, of Compton, husbandman 2
3812300 1961741 1961741 defendant Salter William husbandman 587914 587914 Salter, William, of Compton, husbandman 0
3831454 1967723 1967723 defendant Pope John husbandman 587914 587914 Pope, John, of Compton, husbandman 0
3842075 1971074 1971074 defendant Plumer John husbandman 587914 587914 Plumer, John, of Compton, husbandman 2
3854038 1974898 1974898 defendant Sambage William yeoman 587914 587914 Sambage, William, of Compton, yeoman 0
3854039 1974898 1974898 defendant Sambage William, junior yeoman 587914 587914 Sambage, William, junior, of Compton, yeoman 1
3855334 1975306 1975306 defendant Aylmer Thomas husbandman 587914 587914 Aylmer, Thomas, of Compton, husbandman 2
3862870 1977773 1977773 defendant Sambage William yeoman 587914 587914 Sambage, William, of Compton, yeoman 0
3876331 1982328 1982328 defendant Browne Thomas husbandman 587914 587914 Browne, Thomas, of Compton, husbandman 0
3904890 1991900 1991900 defendant Wattys William husbandman 587914 587914 Wattys, William, of Compton, husbandman 2
3927808 1999640 1999640 defendant Hyll Morris husbandman 587914 587914 Hyll, Morris, of Compton, husbandman 0
3930630 2000589 2000589 defendant Gryffyn alias Toye Margaret widow 587914 587914 Gryffyn alias Toye, Margaret, of Compton, widow 0
3944348 2005121 2005121 defendant Wyghtwyke Richard yeoman 587914 587914 Wyghtwyke, Richard, of Compton, yeoman 0
3960106 2010636 2010636 defendant Smyth William yeoman 587914 587914 Smyth, William, of Compton, yeoman 0
3963169 2011719 2011719 defendant Neyse Robert husbandman 587914 587914 Neyse, Robert, of Compton, husbandman 0
3980471 2017786 2017786 plaintiff Peter John   587914 587914 Peter, John, of Compton 0
3980473 2017787 2017787 plaintiff Peter John   587914 587914 Peter, John, of Compton 0
3993427 2022391 2022391 plaintiff Chamber Christopher yeoman 587914 587914 Chamber, Christopher, of Compton, yeoman 0
4005107 2026613 2026613 plaintiff Kemyshe Walter clerk 587914 587914 Kemyshe, Walter, of Compton, clerk 0
4014377 2029861 2029861 defendant Byrd Richard husbandman 587914 587914 Byrd, Richard, of Compton, husbandman 0
4014379 2029862 2029862 defendant Hale John yeoman 587914 587914 Hale, John, of Compton, yeoman 0
4014380 2029862 2029862 defendant Hollyman Roger laborer 587914 587914 Hollyman, Roger, of Compton, laborer 1
4014383 2029863 2029863 defendant Hale John yeoman 587914 587914 Hale, John, of Compton, yeoman 0
4014531 2029921 2029921 defendant Gybbes John yeoman 587914 587914 Gybbes, John, of Compton, yeoman 1
4034033 2036829 2036829 plaintiff Hale John   587914 587914 Hale, John, of Compton 0
4043900 2040269 2040269 plaintiff Pryston John, junior husbandman 587914 587914 Pryston, John, junior, of Compton, husbandman 0
4043902 2040270 2040270 plaintiff Pryston John, junior husbandman 587914 587914 Pryston, John, junior, of Compton, husbandman 0
4063899 2047371 2047371 defendant Gravener John weaver 587914 587914 Gravener, John, of Compton, weaver 0
4064202 2047471 2047471 defendant Davyes John laborer 587914 587914 Davyes, John, of Compton, laborer 0
4065899 2048094 2048094 defendant Lawley David yeoman 587914 587914 Lawley, David, of Compton, yeoman 4
4096307 2059010 2059010 defendant Halle John yeoman 587914 587914 Halle, John, of Compton, yeoman 1
4108932 2063449 2063449 defendant Prestwoode alias Fowler William yeoman 587914 587914 Prestwoode alias Fowler, William, of Compton, yeoman 1
4111817 2064477 2064477 defendant Woodcocke William tanner 587914 587914 Woodcocke, William, of Compton, tanner 0
4123947 2068864 2068864 defendant Byrde Richard yeoman 587914 587914 Byrde, Richard, of Compton, yeoman 0
4138882 2074279 2074279 defendant Morse Robert   587914 587914 Morse, Robert, of Compton, Enford. husbandman 2
4147108 2077132 2077132 defendant Byrde Richard yeoman 587914 587914 Byrde, Richard, of Compton, yeoman 0
4153225 2079225 2079225 defendant Warrand Thomas yeoman 587914 587914 Warrand, Thomas, of Compton, yeoman 0
4153226 2079225 2079225 defendant Byrd Richard yeoman 587914 587914 Byrd, Richard, of Compton, yeoman 1
4154424 2079638 2079638 defendant Durneforde Thomas yeoman 587914 587914 Durneforde, Thomas, of Compton Abbot, yeoman 0
4156707 2080424 2080424 defendant Pyddle John husbandman 587914 587914 Pyddle, John, of Compton, husbandman 1
4170589 2085212 2085212 plaintiff Byrde Richaerd   587914 587914 Byrde, Richaerd, of Compton 0
4173097 2086047 2086047 defendant Smyth Richard yeoman 587914 587914 Smyth, Richard, of Compton, yeoman 0
4216638 2101312 2101312 defendant Darton John yeoman 587914 587914 Darton, John, of Compton, yeoman 0
4216639 2101312 2101312 defendant Mayne Richard yeoman 587914 587914 Mayne, Richard, of Compton, yeoman 1
4219127 2102186 2102186 defendant Freeman Richard laborer 587914 587914 Freeman, Richard, of Compton, laborer 0
4223336 2103655 2103655 defendant Jukes John   587914 587914 Jukes, John, of Compton, wheelwright 0
4233402 2107196 2107196 defendant Inkes or Jukes John husbandman 587914 587914 Inkes or Jukes, John, of Compton, husbandman 0
4233403 2107196 2107196 defendant Inkes or Jukes William husbandman 587914 587914 Inkes or Jukes, William, of Compton, husbandman 1
4265513 2118103 2118103 defendant Inkes or Jukes John husbandman 587914 587914 Inkes or Jukes, John, of Compton, husbandman 0
4265514 2118103 2118103 defendant Inkes or Jukes William husbandman 587914 587914 Inkes or Jukes, William, of Compton, husbandman 1
4306804 2132519 2132519 defendant Harris Thomas or of Egginswell, Devon, gent 587914 587914 Harris Thomas, of Compton, or of Egginswell, Devon, gent 2
4314728 2135264 2135264 defendant Twyforde John gent 587914 587914 Twyforde, John, of Compton, gent 2
4340416 2143912 2143912 defendant Whorwood Gerard gent 587914 587914 Whorwood, Gerard, of Compton, gent 0
4342938 2144805 2144805 defendant Pynnell Christopher yeoman 587914 587914 Pynnell, Christopher, of Compton, yeoman 1
4366795 2153172 2153172 defendant Pynnell Christopher yeoman 587914 587914 Pynnell, Christopher, of Compton, yeoman 1
4387265 2160388 2160388 defendant Pyddell or Pedell John   587914 587914 Pyddell or Pedell, John, of Compton, linen weaver 0
4416161 2169937 2169937 defendant Roger William clerk 587914 587914 Roger, William, of Compton, clerk 0
4424345 2172456 2172456 defendant Potter Thomas le chaplain 587914 587914 Potter, Thomas le, of Compton, chaplain 2
4425288 2172736 2172736 defendant Rogers William clerk 587914 587914 Rogers, William, of Compton, clerk 0
4431476 2174611 2174611 defendant Selekot John   587914 587914 Selekot, John, of Compton 0
4460443 2188330 2188330 defendant Dodesson John   587914 587914 Dodesson, John, of Compton 0
4489955 2197567 2197567 defendant Rychard Thomas   587914 587914 Rychard, Thomas, of Compton 1
4547241 2215070 2215070 defendant Bernard John   587914 587914 Bernard, John, of Compton 1
4556401 2217941 2217941 plaintiff Hull Henry   587914 587914 Hull, Henry, of Compton 1
4569922 2222161 2222161 defendant Knyght John   587914 587914 Knyght, John, of Compton 2
4573056 2223109 2223109 defendant Eyr John   587914 587914 Eyr, John, of Compton 0
4584592 2226597 2226597 defendant Wychard Adam   587914 587914 Wychard, Adam, of Compton 4
4610160 2234259 2234259 defendant Wodelok John   587914 587914 Wodelok, John, of Compton 0
4636741 2242310 2242310 defendant Morys John   587914 587914 Morys, John, of Compton 0
4653166 2246926 2246926 defendant Harryes William husbandman 587914 587914 Harryes, William, of Compton, husbandman 0
4653167 2246926 2246926 defendant Wylly Richard laborer 587914 587914 Wylly, Richard, of Compton, laborer 1
4671581 2256756 2256756 defendant Roddok John   587914 587914 Roddok, John, of Compton, in diocese of Winchester, parson 0
4684964 2260893 2260893 defendant Radforde Thomas   587914 587914 Radforde, Thomas, of Compton, vicar 0
4686164 2261267 2261267 defendant Gilbard William gent 587914 587914 Gilbard, William, of Compton, gent 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);