names

78 rows where place_id = 602938

✎ 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
3652386 1911082 1911082 defendant Kene George gent 602938 602938 Kene, George, of Est Grenewiche, Kent, gent 1
3670771 1916820 1916820 defendant Dey John yeoman 602938 602938 Dey, John, of king's household, Est Grenewiche, Kent, yeoman 0
3679598 1919688 1919688 defendant Swynarton Edward esq 602938 602938 Swynarton, Edward, of King's Household, Est Grenewiche, Kent, esq 2
3679603 1919689 1919689 defendant Swynarton Edward esq 602938 602938 Swynarton, Edward, of Est Grenewiche, Kent, esq 2
3682401 1920596 1920596 defendant Audeley John esq 602938 602938 Audeley, John, of Est Grenewiche, Kent, esq 0
3684748 1921366 1921366 defendant Hope Richard yeoman of the crown 602938 602938 Hope, Richard, of Est Grenewiche, Kent, yeoman of the crown 0
3685705 1921688 1921688 defendant Sakvyle Thomas gent 602938 602938 Sakvyle, Thomas, of Est Grenewiche, Kent, gent 0
3685708 1921689 1921689 defendant Sakvyle Thomas gent 602938 602938 Sakvyle, Thomas, of Est Grenewiche, Kent, gent 0
3686465 1921919 1921919 defendant Rycher Richard tailor 602938 602938 Rycher, Richard, of Est Grenewiche, Kent, tailor 3
3689490 1922870 1922870 defendant Grey Richard   602938 602938 Grey, Richard, of Est Grenewiche, Kent, knight 1
3692999 1924013 1924013 defendant Grey Richard   602938 602938 Grey, Richard, of Est Grenewiche, Kent, knight, Lord Grey 1
3695595 1924851 1924851 defendant Stephynson Hugh scrivener 602938 602938 Stephynson, Hugh, of Est Grenewiche, Kent, scrivener 0
3698854 1925858 1925858 defendant Raynforth John gent 602938 602938 Raynforth, John, of Est Grenewiche, Kent, gent 0
3709508 1929279 1929279 defendant Stephynson Hugh scrivener 602938 602938 Stephynson, Hugh, of Est Grenewiche, Kent, scrivener 0
3709909 1929414 1929414 defendant Bowman William gent 602938 602938 Bowman, William, of Est Grenewiche, Kent, gent 0
3709915 1929415 1929415 defendant Bowman William gent 602938 602938 Bowman, William, of Est Grenewiche, Kent, gent 2
3714434 1930809 1930809 defendant Coke Thomas lighterman 602938 602938 Coke, Thomas, of Est Grenewiche, Kent, lighterman 0
3720719 1932772 1932772 defendant Nevyle Edward   602938 602938 Nevyle, Edward, of Est Grenewiche, Kent, knight 0
3720722 1932773 1932773 defendant Pole Arthur   602938 602938 Pole, Arthur, of Est Grenewiche, Kent, knight 0
3721350 1932985 1932985 defendant Coke Thomas yeoman 602938 602938 Coke, Thomas, of Est Grenewiche, Kent, yeoman 0
3721401 1933002 1933002 defendant Coke Thomas yeoman 602938 602938 Coke, Thomas, of Est Grenewiche, Kent, yeoman 0
3735862 1937454 1937454 defendant Cropson Robert or Richard yeoman of King's chamber 602938 602938 Cropson, Robert or Richard, of Est Grenewiche, Kent, yeoman of King's chamber 0
3744015 1940020 1940020 defendant Carewe Nicholas   602938 602938 Carewe, Nicholas, of Est Grenewiche, Kent, knight 0
3744682 1940231 1940231 defendant Tyll John gent 602938 602938 Tyll, John, of Est Grenewiche, Kent, gent 1
3745689 1940559 1940559 defendant Brandeley Richard gent 602938 602938 Brandeley, Richard, of Est Grenewiche, Kent, gent 1
3749791 1941844 1941844 defendant Carewe Nicholas   602938 602938 Carewe, Nicholas, of Est Grenewiche, Kent, knight 1
3756266 1943919 1943919 defendant Bryan Francis   602938 602938 Bryan, Francis, of Est Grenewiche, Kent, knight 0
3764205 1946457 1946457 defendant Care William esq 602938 602938 Care, William, of Est Grenewiche, Kent, esq 0
3764208 1946458 1946458 defendant Care William esq 602938 602938 Care, William, of Est Grenewiche, Kent, esq 0
3767098 1947365 1947365 defendant Holand Adam yeoman of the guard 602938 602938 Holand, Adam, of Est Grenewiche, Kent, yeoman of the guard 0
3767271 1947404 1947404 defendant Webbe William   602938 602938 Webbe, William, of Est Grenewiche, Kent, yeoman, groom of the stirrup to the king 1
3775714 1950152 1950152 defendant Luskyn George gent 602938 602938 Luskyn, George, of Est Grenewiche, Kent, gent 2
3777801 1950787 1950787 defendant Dynglay John gent 602938 602938 Dynglay, John, of East Grenewiche, Kent, gent 0
3779873 1951435 1951435 defendant Phillip Robert gent 602938 602938 Phillip, Robert, of Est Grenewiche, kent, gent 3
3780424 1951612 1951612 defendant Wyat Thomas esq 602938 602938 Wyat, Thomas, of Est Grenewiche, Kent, esq 0
3781503 1951954 1951954 defendant Raynsforth John   602938 602938 Raynsforth, John, of Est Grenewiche, Kent, knight 0
3807010 1960088 1960088 defendant Robert Thomas gent 602938 602938 Robert, Thomas, of Est Grenewiche, Kent, gent 6
3807028 1960091 1960091 defendant Darcy Arthur   602938 602938 Darcy, Arthur, of Est Grenewiche, Kent, knight 0
3809295 1960788 1960788 defendant Aleyn Thomas gent 602938 602938 Aleyn, Thomas, of Est Grenewiche, Kent, gent 0
3815225 1962678 1962678 defendant Johnson John gent 602938 602938 Johnson, John, of Est Grenewiche, Kent, gent 0
3817825 1963486 1963486 defendant Marchall Thomas yeoman 602938 602938 Marchall, Thomas, of Est Grenewiche, Kent, yeoman 0
3818932 1963821 1963821 defendant Webbe Henry esq 602938 602938 Webbe, Henry, of Est Grenewiche, Kent, esq 0
3820413 1964266 1964266 defendant Aleyn Thomas   602938 602938 Aleyn, Thomas, of Est Grenewiche, Kent, gent, King's servant 0
3820454 1964281 1964281 defendant Cannucle John   602938 602938 Cannucle, John, of Est Grenewiche, Kent, yeoman, of the king's pastry 1
3823420 1965235 1965235 defendant Lodesman Henry   602938 602938 Lodesman, Henry, of Est Grenewiche, Kent, king's servant "de la chaundrey" 0
3823432 1965237 1965237 defendant Turwytt Robert esq 602938 602938 Turwytt, Robert, of Est Grenewiche, Kent, esq 1
3825186 1965744 1965744 defendant Rolte William   602938 602938 Rolte, William, of Est Grenewiche, Kent, sergeant at arms 0
3825190 1965745 1965745 defendant Carewe John esq 602938 602938 Carewe, John, of Est Grenewiche, Kent, esq 0
3825204 1965748 1965748 defendant Breerton William   602938 602938 Breerton, William, of Est Grenewiche, Kent, esq, groom of the Privy Chamber 0
3825253 1965758 1965758 defendant FitzWilliam William treasurer of the household 602938 602938 FitzWilliam, William, of Est Grenewiche, Kent, knight, treasurer of the household 0
3827058 1966319 1966319 defendant Howard Edward   602938 602938 Howard, Edward, of Est Grenewiche, Kent, knight, Lord Howard 0
3834988 1968882 1968882 defendant Vaughan James esq 602938 602938 Vaughan, James, of Est Grenewiche, Kent, esq 0
3839704 1970346 1970346 defendant Skelton Thomas gent 602938 602938 Skelton, Thomas, of Est Grenewiche, Kent, gent 0
3841883 1971035 1971035 defendant Stoner Edmund yeoman of the guard 602938 602938 Stoner, Edmund, of Est Grenewiche, Kent, yeoman of the guard 2
3851454 1974049 1974049 defendant Beynton Edward   602938 602938 Beynton, Edward, of Est Grenewiche, Kent, knight 0
3851458 1974050 1974050 defendant Beynton Edward   602938 602938 Beynton, Edward, of Est Grenewiche, Kent, knight 0
3860030 1976852 1976852 defendant Boreham Thomas yeoman of the guard 602938 602938 Boreham, Thomas, of Est Grenewiche, Kent, yeoman of the guard 0
3862751 1977734 1977734 defendant Care Thomas gent 602938 602938 Care, Thomas, of Est Grenewiche, Kent, gent 0
3864577 1978349 1978349 defendant Austyn Edward yeoman 602938 602938 Austyn, Edward, of Est Grenewiche, Kent, yeoman 3
3864587 1978351 1978351 defendant Austyn Edward yeoman 602938 602938 Austyn, Edward, of Est Grenewiche, Kent, yeoman 3
3870254 1980301 1980301 defendant Copynger John gent 602938 602938 Copynger, John, of Est Grenewiche, Kent, gent 0
3875836 1982172 1982172 defendant Kelham John yeoman of the guard 602938 602938 Kelham, John, of Est Grenewiche, Kent, yeoman of the guard 0
3938316 2003153 2003153 plaintiff Provese Hugh (legal representative) 602938 602938 Provese, Hugh, of East Grenewiche, Kent, yeoman, executors of 0
4003967 2026189 2026189 plaintiff Hussey Lawrence yeoman 602938 602938 Hussey, Lawrence, of Est Grenewiche, Kent, yeoman 0
4014020 2029750 2029750 plaintiff Sampson William   602938 602938 Sampson, William, of Est Grenewiche, Kent, baker, administrators of 0
4038183 2038295 2038295 defendant Wyseman Robert gent 602938 602938 Wyseman, Robert, of Est Grenewiche, Kent, gent 0
4041044 2039287 2039287 defendant Smythson Henry   602938 602938 Smythson, Henry, of Est Grenewiche, Kent, cook 0
4042069 2039652 2039652 defendant Kytchener John yeoman 602938 602938 Kytchener, John, of Est Grenewiche, Kent, yeoman 0
4050629 2042655 2042655 defendant Fowle Robert gent 602938 602938 Fowle, Robert, of East Grenewiche, Kent, gent 0
4050631 2042656 2042656 defendant Fowle Robert gent 602938 602938 Fowle, Robert, of Est Grenewiche, Kent, gent 0
4101507 2060847 2060847 defendant Wyseman Robert gent 602938 602938 Wyseman, Robert, of East Grenewiche, Kent, gent 0
4160773 2081846 2081846 defendant Hunys William gent 602938 602938 Hunys, William, of Est Grenewiche, Kent, gent 0
4340105 2143804 2143804 defendant Stout Robert yeoman 602938 602938 Stout, Robert, of East Grenewiche, Kent, yeoman 0
4347025 2146216 2146216 defendant Wyseman Robert esq 602938 602938 Wyseman, Robert, of East Grenewiche, Kent, esq 0
4361156 2151154 2151154 defendant Smytheson Henry yeoman 602938 602938 Smytheson, Henry, of East Grenewiche, Kent, yeoman 0
4380043 2157965 2157965 defendant Symond Thomas fisherman 602938 602938 Symond, Thomas, of East Grenewiche, Kent, fisherman 1
4380045 2157966 2157966 defendant Nicoll John waterman 602938 602938 Nicoll, John, of East Grenewiche, Kent, waterman 0
5357656 2462465 2462465 defendant Michell John yeoman 602938 602938 Michell, John, of Est Grenewiche, Kent, yeoman 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);