names

35 rows where place_id = 599150

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635526 1905911 1905911 defendant Fysshe John yeoman 599150 599150 Fysshe, John, of Grenewych, Kent, yeoman 0
3648343 1909882 1909882 defendant Duffeld John gent 599150 599150 Duffeld, John, of Grenewych, Kent, gent 1
3660086 1913416 1913416 defendant Raynforth John gent 599150 599150 Raynforth, John, of Grenewych, Kent, gent 2
3660092 1913416 1913416 defendant Smythe Roger gent of the Kinges chamber 599150 599150 Smythe, Roger, of Grenewych, Kent, gent of the Kinges chamber 8
3660572 1913567 1913567 defendant Boleyn Edward   599150 599150 Boleyn, Edward, of Grenewych, Kent, knigh 0
3678515 1919338 1919338 defendant Cannden Margery widow 599150 599150 Cannden, Margery, of Grenewych, Kent, widow 4
3732882 1936512 1936512 defendant Greye Richard   599150 599150 Greye, Richard, of Grenewych, Kent, knight 1
3778386 1950955 1950955 defendant Chyene Thomas   599150 599150 Chyene, Thomas, of Grenewych, Kent, knight 0
3976953 2016502 2016502 defendant Apparry Hugh gent 599150 599150 Apparry, Hugh, of Grenewych, Kent, gent 0
4779099 2289440 2289440 defendant Wodeward Thomas mariner 599150 599150 Wodeward, Thomas, of Grenewych, Kent, mariner 0
4779101 2289441 2289441 defendant Wodeward Thomas mariner 599150 599150 Wodeward, Thomas, of Grenewych, Kent, mariner 0
4869824 2317533 2317533 defendant Dere Thomas yeoman 599150 599150 Dere, Thomas, of Grenewych, Kent, yeoman 1
4876657 2319670 2319670 defendant Bukby John yeoman 599150 599150 Bukby, John, of Grenewych, Kent, yeoman 0
4911358 2330056 2330056 defendant Middelton Richard esq 599150 599150 Middelton, Richard, of Grenewych, Kent, esq 0
4935795 2337586 2337586 defendant Radford Philip   599150 599150 Radford, Philip, of Grenewych, Kent, or of Lincoln, knight 0
4936026 2337669 2337669 defendant Forthey John gent 599150 599150 Forthey, John, of Grenewych, Kent, gent 0
4947961 2341351 2341351 defendant Chapman Ralph yeoman 599150 599150 Chapman, Ralph, of Grenewych, Kent, yeoman 2
4947968 2341352 2341352 defendant Chapman Ralph yeoman 599150 599150 Chapman, Ralph, of Grenewych, Kent, yeoman 2
4950073 2341991 2341991 defendant Chapman Ralph husbandman 599150 599150 Chapman, Ralph, of Grenewych, Kent, husbandman 0
5013521 2360793 2360793 defendant Cheseman Robert husbandman 599150 599150 Cheseman, Robert, of Grenewych, Kent, husbandman 0
5020565 2362904 2362904 defendant Wodeham William esq 599150 599150 Wodeham, William, of Grenewych, Kent, esq 3
5020571 2362905 2362905 defendant Wodeham William esq 599150 599150 Wodeham, William, of Grenewych, Kent, esq 3
5033004 2366541 2366541 defendant Ryder John butcher 599150 599150 Ryder, John, of Grenewych, Kent, butcher 2
5068938 2377209 2377209 defendant Morton John clerk 599150 599150 Morton, John, of Grenewych, Kent, clerk 1
5068945 2377210 2377210 defendant Morton John clerk 599150 599150 Morton, John, of Grenewych, Kent, clerk 1
5075311 2379113 2379113 defendant Bocher William fisher 599150 599150 Bocher, William, of Grenewych, Kent, fisher 2
5084957 2382007 2382007 defendant Seyntclowe Giles esq 599150 599150 Seyntclowe, Giles, of Grenewych, Kent, esq 1
5088175 2382914 2382914 defendant Bocher William fisher 599150 599150 Bocher, William,of Grenewych, Kent, fisher 8
5092564 2384201 2384201 defendant Middelton Thomas esq 599150 599150 Middelton, Thomas, of Grenewych, Kent, esq 0
5287517 2441373 2441373 defendant Stanbrugge John   599150 599150 Stanbrugge, John, of Grenewych, Kent, yeoman, or of Suthwerk, Surrey 0
5486107 2500729 2500729 defendant Seby or Sevy Nicholas yeoman 599150 599150 Seby or Sevy, Nicholas, of Gueen's household, Grenewych, Kent, yeoman 0
5486110 2500730 2500730 defendant Seby or Sevy Nicholas yeoman 599150 599150 Seby or Sevy, Nicholas, of Queen's household, Grenewych, Kent, yeoman 0
5570527 2525951 2525951 defendant Kene George gent 599150 599150 Kene, George, of grenewych, Kent, gent 5
5591619 2532359 2532359 defendant Wellys John gent 599150 599150 Wellys, John, of Grenewych, Kent, gent 0
5591623 2532360 2532360 defendant Wellys John gent 599150 599150 Wellys, John, of Grenewych, Kent, 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);