names

33 rows where place_id = 608841

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3656130 1912171 1912171 defendant Walaxton John esq 608841 608841 Walaxton, John, of East Grenewych, Kent, esq 0
3663426 1914488 1914488 defendant Coke William yeoman 608841 608841 Coke, William, of East Grenewych, Kent, yeoman 0
3664733 1914919 1914919 defendant Cobham Edward   608841 608841 Cobham, Edward, of East Grenewych, Kent, knight 4
3675741 1918446 1918446 defendant Alwyn Philip yeoman 608841 608841 Alwyn, Philip, of Est Grenewych, Kent, yeoman 2
3700379 1926356 1926356 defendant Braband Hugh yeoman of the crown 608841 608841 Braband, Hugh, of Est Grenewych, Kent, yeoman of the crown 0
3700693 1926466 1926466 defendant Sakvyle Thomas gent 608841 608841 Sakvyle, Thomas, of king's household, Est Grenewych, Kent, gent 0
3700695 1926467 1926467 defendant Sakvyle Thomas gent 608841 608841 Sakvyle, Thomas, of King's household, Est Grenewych, Kent, gent 0
3706647 1928365 1928365 defendant Hamerton George esq 608841 608841 Hamerton, George, of Est Grenewych, Kent, esq 0
3706652 1928366 1928366 defendant hamerton George esq 608841 608841 hamerton, George, of Est Grenewych, Kent, esq 0
3708867 1929065 1929065 defendant Compton Thomas gent 608841 608841 Compton, Thomas, of Est Grenewych, Kent, gent 0
3714845 1930943 1930943 defendant Norreys Henry esq 608841 608841 Norreys, Henry, of Est Grenewych, Kent, esq 0
3725497 1934262 1934262 defendant Cook Richard yeoman 608841 608841 Cook, Richard, of Est Grenewych, Kent, yeoman 0
3767196 1947382 1947382 defendant Standysshe Christopher gent 608841 608841 Standysshe, Christopher, of Est Grenewych, Kent, gent 0
3795595 1956507 1956507 defendant Kyng Robert skinner 608841 608841 Kyng, Robert, of East Grenewych, Kent, skinner 1
3808209 1960449 1960449 defendant Goldyngham Philip yeoman 608841 608841 Goldyngham, Philip, of Est Grenewych, Kent, yeoman 2
3809297 1960789 1960789 defendant Aleyn Thomas gent 608841 608841 Aleyn, Thomas, of Est Grenewych, Kent, gent 0
3819010 1963837 1963837 defendant Bryan Francis   608841 608841 Bryan, Francis, of King's household, Est Grenewych, Kent, knight 0
3826315 1966079 1966079 defendant Byrd Henry yeoman of the chamber 608841 608841 Byrd, Henry, of Est Grenewych, Kent, yeoman of the chamber 1
3842879 1971306 1971306 defendant Forest Edward gentleman of the chamber 608841 608841 Forest, Edward, of Est Grenewych, Kent, gentleman of the chamber 0
3854281 1974973 1974973 defendant Grymysdyche John yeoman 608841 608841 Grymysdyche, John, of Est Grenewych, Kent, yeoman 1
3855135 1975240 1975240 defendant Long Richard esq 608841 608841 Long, Richard, of Est Grenewych, Kent, esq 0
3855154 1975247 1975247 defendant Long Richard esq 608841 608841 Long, Richard, of Est Grenewych, Kent, esq 0
3940854 2003948 2003948 defendant Stockes Richard butcher 608841 608841 Stockes, Richard, of East Grenewych, Kent, butcher 0
4672409 2257024 2257024 plaintiff Cofyn or Cosyn Richard   608841 608841 Cofyn or Cosyn, Richard, of East Grenewych, Kent, on his own account 0
4979487 2350822 2350822 defendant Meredeth Morgan esq 608841 608841 Meredeth, Morgan, of Est Grenewych, Kent, esq 0
5112580 2390063 2390063 defendant Cheseman Thomas yeoman 608841 608841 (Cheseman, Thomas, of Est Grenewych, Kent, yeoman 1
5121830 2392816 2392816 defendant Cheseman Thomas gent 608841 608841 Cheseman, Thomas, of Est Grenewych, Kent, gent 0
5274695 2437676 2437676 defendant Herberd John yeoman 608841 608841 Herberd, John, of East Grenewych, Kent, yeoman 2
5275666 2437948 2437948 plaintiff Stile Richard yeoman 608841 608841 Stile, Richard, of East Grenewych, Kent, yeoman 0
5288832 2441744 2441744 defendant Cok Roger gent 608841 608841 Cok, Roger, of Est Grenewych, Kent, gent 2
5292236 2442728 2442728 defendant Herbert John yeoman 608841 608841 Herbert, John, of Est Grenewych, Kent, yeoman 0
5391690 2472695 2472695 defendant Causton William carpenter 608841 608841 Causton, William, of East Grenewych, Kent, carpenter 1
5505181 2506528 2506528 defendant Asshenden Thomas gent 608841 608841 Asshenden, Thomas, of Est Grenewych, Kent, gent 4

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