names

207 rows where place_id = 588845

✎ 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
3595766 1866308 1866308 defendant Man Roger potter 588845 588845 Man, Roger, of Grymston, potter 0
3604639 1869113 1869113 defendant Benlond John husbandman 588845 588845 Benlond, John, of Grymston, husbandman 3
3627187 1903357 1903357 defendant Saull Richard laborer 588845 588845 Saull, Richard, of Grymston, laborer 0
3627188 1903357 1903357 defendant Gurwald Thomas husbandman 588845 588845 Gurwald, Thomas, of Grymston, husbandman 1
3627189 1903357 1903357 defendant Hall Thomas, senior husbandman 588845 588845 Hall, Thomas, senior, of Grymston, husbandman 2
3627190 1903357 1903357 defendant Awnger Edmund laborer 588845 588845 Awnger, Edmund, of Grymston, laborer 3
3627192 1903357 1903357 defendant Jakeson John husbandman 588845 588845 Jakeson, John, of Grymston, husbandman 5
3627193 1903357 1903357 defendant Bowser Christopher husbandman 588845 588845 Bowser, Christopher, of Grymston, husbandman 6
3627194 1903357 1903357 defendant Jeffereyson John laborer 588845 588845 Jeffereyson, John, of Grymston, laborer 7
3627195 1903357 1903357 defendant Pattanson William laborer 588845 588845 Pattanson, William, of Grymston, laborer 8
3627196 1903357 1903357 defendant Awnger Christopher laborer 588845 588845 Awnger, Christopher, of Grymston, laborer 9
3627197 1903357 1903357 defendant Jakeson Edmund laborer 588845 588845 Jakeson, Edmund, of Grymston, laborer 10
3627198 1903357 1903357 defendant Gurwald William laborer 588845 588845 Gurwald, William, of Grymston, laborer 11
3627199 1903357 1903357 defendant Thomas John laborer 588845 588845 Thomas, John, of Grymston, laborer 12
3627200 1903357 1903357 defendant Dobson Brian laborer 588845 588845 Dobson, Brian, of Grymston, laborer 13
3632601 1905014 1905014 defendant Hall Thomas husbandman 588845 588845 Hall, Thomas, of Grymston, husbandman 1
3636322 1906151 1906151 defendant Copynthorpes Leonard yeoman 588845 588845 Copynthorpes, Leonard, of Grymston, yeoman 0
3636324 1906152 1906152 defendant Copynthorpes Leonard yeoman 588845 588845 Copynthorpes, Leonard, of Grymston, yeoman 0
3638855 1906975 1906975 defendant Connethorp Leonard yeoman 588845 588845 Connethorp, Leonard, of Grymston, yeoman 0
3638856 1906975 1906975 defendant Bateley John carpenter 588845 588845 Bateley, John, of Grymston, carpenter 1
3638857 1906975 1906975 defendant Brown James yeoman 588845 588845 Brown, James, of Grymston, yeoman 2
3638858 1906975 1906975 defendant Nicolson Henry husbandman 588845 588845 Nicolson, Henry, of Grymston, husbandman 3
3643391 1908358 1908358 plaintiff Croft Stephen   588845 588845 Croft, Stephen, of Grymston 0
3649115 1910108 1910108 defendant Paget Thomas yeoman 588845 588845 Paget, Thomas, of Grymston juxta Tadcaster, yeoman 1
3654819 1911767 1911767 defendant Potter Thomas husbandman 588845 588845 Potter, Thomas, of Grymston, husbandman 0
3654820 1911767 1911767 defendant Crane Henry husbandman 588845 588845 Crane, Henry, of Grymston, husbandman 1
3674847 1918161 1918161 defendant Hobert Robert chaplain 588845 588845 Hobert, Robert, of Grymston, chaplain 1
3674849 1918161 1918161 defendant Haveryng John yeoman 588845 588845 Haveryng, John, of Grymston, yeoman 3
3675396 1918342 1918342 defendant Potter Thomas husbandman 588845 588845 Potter, Thomas, of Grymston, husbandman 0
3675399 1918343 1918343 defendant Jurdan Humphrey yeoman 588845 588845 Jurdan, Humphrey, of Grymston, yeoman 0
3688223 1922466 1922466 defendant Grymston Walter   588845 588845 Grymston, Walter, of Grymston, gent, bailiff of Haldernes 0
3697792 1925531 1925531 defendant Colyn William husbandman 588845 588845 Colyn, William, of Grymston, husbandman 1
3697823 1925537 1925537 defendant Byrd Richard husbandman 588845 588845 Byrd, Richard, of Grymston, husbandman 0
3705909 1928132 1928132 defendant Crane Henry husbandman 588845 588845 Crane, Henry, of Grymston, husbandman 0
3705911 1928133 1928133 defendant Potter Thomas husbandman 588845 588845 Potter, Thomas, of Grymston, husbandman 0
3706781 1928405 1928405 defendant Swyft William husbandman 588845 588845 Swyft, William, of Grymston, husbandman 0
3721210 1932935 1932935 plaintiff Brokesby Robert gent 588845 588845 Brokesby, Robert, of Grymston, gent 1
3721213 1932936 1932936 plaintiff Brokysby Robert gent 588845 588845 Brokysby, Robert, of Grymston, gent 1
3745062 1940363 1940363 defendant Hobert Robert clerk 588845 588845 Hobert, Robert, of Grymston, clerk 2
3757721 1944396 1944396 defendant Hobert Robert clerk 588845 588845 Hobert, Robert, of Grymston, clerk 2
3762129 1945797 1945797 defendant Russell Robert husbandman 588845 588845 Russell, Robert, of Grymston, husbandman 2
3773896 1949547 1949547 defendant Barkham Robert   588845 588845 Barkham, Robert, of Grymston, shepherd 0
3778293 1950922 1950922 defendant Gerlyng Nicholas hosteler 588845 588845 Gerlyng, Nicholas, of Grymston, hosteler 0
3806227 1959866 1959866 defendant Barwyk Geoffrey husbandman 588845 588845 Barwyk, Geoffrey, of Grymston, husbandman 0
3829743 1967194 1967194 defendant Percyvall John clerk 588845 588845 Percyvall, John, of Grymston, clerk 0
3839758 1970362 1970362 defendant Salter Thomas yeoman 588845 588845 Salter, Thomas, of Grymston, yeoman 2
3851220 1973977 1973977 defendant Salter Thomas husbandman 588845 588845 Salter, Thomas, of Grymston, husbandman 1
3860792 1977101 1977101 defendant Ivys William husbandman 588845 588845 Ivys, William, of Grymston, husbandman 0
3860793 1977101 1977101 defendant Potter Thomas husbandman 588845 588845 Potter, Thomas, of Grymston, husbandman 1
3877112 1982586 1982586 defendant Alden John laborer 588845 588845 Alden, John, of Grymston, laborer 3
3881476 1984069 1984069 defendant Lorelby Thomas bricklayer 588845 588845 Lorelby, Thomas, of Grymston, bricklayer 3
3922534 1997852 1997852 defendant Felester Robert husbandman 588845 588845 Felester, Robert, of Grymston, husbandman 1
3922535 1997852 1997852 defendant Hekforth Henry husbandman 588845 588845 Hekforth, Henry, of Grymston, husbandman 2
3925187 1998734 1998734 defendant Jurden Humphrey gent 588845 588845 Jurden, Humphrey, of Grymston, gent 1
3944520 2005182 2005182 defendant Mower Lawrence laborer 588845 588845 Mower, Lawrence, of Grymston, laborer 0
3946286 2005777 2005777 plaintiff Busterd John husbandman 588845 588845 Busterd, John, of Grymston, husbandman 0
3963511 2011844 2011844 defendant Berrye Thomas clerk 588845 588845 Berrye, Thomas, of Grymston, clerk 0
3963513 2011845 2011845 defendant Hekkleton Henry   588845 588845 Hekkleton, Henry, of Grymston, shepherd 0
3963517 2011847 2011847 defendant Jurdayne William gent 588845 588845 Jurdayne, William, of Grymston, gent 0
3989244 2020894 2020894 defendant Brudges Thomas carpenter 588845 588845 Brudges, Thomas, of Grymston, carpenter 1
3994117 2022644 2022644 defendant Heydon William yeoman 588845 588845 Heydon, William, of Grymston, yeoman 0
4004721 2026464 2026464 defendant Jackson Peter yeoman 588845 588845 Jackson, Peter, of Grymston, yeoman 0
4036186 2037624 2037624 defendant Clement Robert husbandman 588845 588845 Clement, Robert, of Grymston, husbandman 2
4036190 2037625 2037625 defendant Clement Robert husbandman 588845 588845 Clement, Robert, of Grymston, husbandman 2
4058757 2045525 2045525 defendant Bastard Humphrey gent 588845 588845 Bastard, Humphrey, of Grymston, gent 0
4071738 2050191 2050191 defendant Fenteman Richard husbandman 588845 588845 Fenteman, Richard, of Grymston, husbandman 0
4071740 2050192 2050192 defendant Fenteman Richard husbandman 588845 588845 Fenteman, Richard, of Grymston, husbandman 0
4071741 2050192 2050192 defendant Irys William husbandman 588845 588845 Irys, William, of Grymston, husbandman 1
4071742 2050192 2050192 defendant Irys Anthony husbandman 588845 588845 Irys, Anthony, of Grymston, husbandman 2
4071743 2050192 2050192 defendant Cowper alias Pease John husbandman 588845 588845 Cowper alias Pease, John, of Grymston, husbandman 3
4071744 2050192 2050192 defendant Morrys William laborer 588845 588845 Morrys, William, of Grymston, laborer 4
4105542 2062263 2062263 defendant Neleson Christopher gent 588845 588845 Neleson, Christopher, of Grymston, gent 0
4105784 2062358 2062358 defendant Neleson Christopher gent 588845 588845 Neleson, Christopher, of Grymston, gent 0
4107825 2063075 2063075 defendant Blomefeld Bartholomew husbandman 588845 588845 Blomefeld, Bartholomew, of Grymston, husbandman 0
4107826 2063075 2063075 defendant Goll Thomas laborer 588845 588845 Goll, Thomas, of Grymston, laborer 1
4126483 2069755 2069755 defendant Brooke Lawrence husbandman 588845 588845 Brooke, Lawrence, of Grymston, husbandman 1
4152595 2079021 2079021 defendant Nelson Christopher gent 588845 588845 Nelson, Christopher, of Grymston, gent 0
4152598 2079021 2079021 defendant Fentyman Richard husbandman 588845 588845 Fentyman, Richard, of Grymston, husbandman 3
4173820 2086298 2086298 defendant Harvye Richard yeoman 588845 588845 Harvye, Richard, of Grymston, yeoman 0
4173821 2086298 2086298 defendant Starr John husbandman 588845 588845 Starr, John, of Grymston, husbandman 1
4185947 2090573 2090573 defendant Richardson Henry yeoman 588845 588845 Richardson, Henry, of Grymston, yeoman 0
4197108 2094542 2094542 defendant Harvye Richard yeoman 588845 588845 Harvye, Richard, of Grymston, yeoman 0
4197109 2094542 2094542 defendant Starr John husbandman 588845 588845 Starr, John, of Grymston, husbandman 1
4221822 2103129 2103129 defendant Nelson Christopher gent 588845 588845 Nelson, Christopher, of Grymston, gent 0
4249777 2112907 2112907 defendant Jervys Thomas husbandman 588845 588845 Jervys, Thomas, of Grymston, husbandman 0
4257040 2115328 2115328 defendant Vynnarde Barnard husbandman 588845 588845 Vynnarde, Barnard, of Grymston, husbandman 0
4276114 2121592 2121592 defendant Yelverton Edward gent 588845 588845 (Yelverton, Edward, of Grymston, gent 1
4313819 2134940 2134940 defendant Heckelton Thomas laborer 588845 588845 Heckelton, Thomas, of Grymston, laborer 1
4313820 2134940 2134940 defendant Hindmershe Jari husbandman 588845 588845 Hindmershe, Jari, of Grymston, husbandman 2
4399826 2164530 2164530 defendant Rothwell Thomas gent 588845 588845 Rothwell, Thomas, of Grymston, gent 1
4401489 2165093 2165093 defendant Rothwell Thomas gent 588845 588845 Rothwell, Thomas, of Grymston, gent 1
4409258 2167695 2167695 defendant Rothwell Thomas gent 588845 588845 Rothwell, Thomas, of Grymston, gent 0
4416131 2169932 2169932 defendant Anker William   588845 588845 Anker, William, of Grymston 5
4453957 2186256 2186256 defendant Spenser Richard   588845 588845 Spenser, Richard, of Grymston 1
4496824 2199675 2199675 defendant Bewesher Willliam   588845 588845 Bewesher, Willliam, of Grymston 0
4553508 2217029 2217029 plaintiff Gerard Joan   588845 588845 Gerard, Joan, of Grymston, formerly wife of John de Grymston, knight 0
4661512 2249431 2249431 defendant Taillour John tailor 588845 588845 Taillour, John, of Grymston, tailor 3
4662156 2249637 2249637 defendant Lyon Thomas baker 588845 588845 Lyon, Thomas, of Grymston, baker 0
4668145 2255744 2255744 defendant Portere Ralph yeoman 588845 588845 Portere, Ralph, of Grymston, yeoman 0
4668146 2255744 2255744 defendant Caperon Agnes spinster 588845 588845 Caperon, Agnes, of Grymston, spinster 1

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