names

33 rows where place_id = 609976

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3681320 1920247 1920247 defendant Palmer Robert yeoman 609976 609976 Palmer, Robert, of Est Grenewiche, yeoman 0
3681322 1920248 1920248 defendant Palmer Robert yeoman 609976 609976 Palmer, Robert, of Est Grenewiche, yeoman 0
3682402 1920596 1920596 defendant Lewes Morgan yeoman 609976 609976 Lewes, Morgan, of Est Grenewiche, yeoman 1
3695584 1924847 1924847 defendant Stephynson Hugh scrivener 609976 609976 Stephynson, Hugh, of Est Grenewiche, scrivener 0
3724610 1933979 1933979 defendant Aldwyn Philip yeoman 609976 609976 Aldwyn, Philip, of Est Grenewiche, yeoman 0
3725900 1934378 1934378 defendant Aldwyn Philip yeoman 609976 609976 Aldwyn, Philip, of Est Grenewiche, yeoman 0
3726121 1934434 1934434 defendant Dobson John tailor 609976 609976 Dobson, John, of Est Grenewiche, tailor 0
3745295 1940436 1940436 defendant Germyn Thomas yeoman 609976 609976 Germyn, Thomas, of Est Grenewiche, yeoman 0
3745296 1940436 1940436 defendant Gyles John gent 609976 609976 Gyles, John, of Est Grenewiche, gent 1
3806928 1960076 1960076 defendant Vaughan James   609976 609976 Vaughan, James, of Est Grenewiche 3
3823421 1965235 1965235 defendant Wheteacres Reginald yeoman of the crown 609976 609976 Wheteacres, Reginald, of Est Grenewiche, yeoman of the crown 1
3823422 1965235 1965235 defendant Pyers William yeoman de la chaundrey 609976 609976 Pyers, William, of Est Grenewiche, yeoman de la chaundrey 2
3825182 1965742 1965742 defendant Norres Henry esq 609976 609976 Norres, Henry, of Est Grenewiche, esq 1
3825206 1965748 1965748 defendant Walshe Walter   609976 609976 Walshe, Walter, of Est Grenewiche, esq, groom of the Privy Chamber 2
3825254 1965758 1965758 defendant Brown Anthony   609976 609976 Brown, Anthony, of Est Grenewiche, knight 1
3827707 1966530 1966530 defendant Astell Edmund gent 609976 609976 Astell, Edmund, of Est Grenewiche, gent 0
3853063 1974578 1974578 defendant Cullbake Richard butcher 609976 609976 Cullbake, Richard, of Est Grenewiche, butcher 0
3853071 1974579 1974579 defendant Bulbake Richard butcher 609976 609976 Bulbake, Richard, of Est Grenewiche, butcher 1
3860033 1976853 1976853 defendant Boreham Thomas yeoman of the guard 609976 609976 Boreham, Thomas, of Est Grenewiche, yeoman of the guard 0
3864578 1978349 1978349 defendant Darknall Robert gentleman usher of the King's chamber 609976 609976 Darknall, Robert, of Est Grenewiche, gentleman usher of the King's chamber 4
3864588 1978351 1978351 defendant Darknall Robert gentleman usher of the King's chamber 609976 609976 Darknall, Robert, of Est Grenewiche, gentleman usher of the King's chamber 4
3887541 1986084 1986084 defendant Foxe Edward gent 609976 609976 Foxe, Edward, of Est Grenewiche, gent 1
3891256 1987342 1987342 plaintiff Kyng Robert   609976 609976 Kyng, Robert, of Est Grenewiche 0
3891258 1987343 1987343 plaintiff Kyng Robert   609976 609976 Kyng, Robert, of Est Grenewiche 0
3892750 1987825 1987825 defendant Leighton Edward clerk of the closet 609976 609976 Leighton, Edward, of Est Grenewiche, clerk of the closet 0
4041128 2039320 2039320 defendant Proves William yeoman or wharfinger 609976 609976 Proves, William, of Est Grenewiche, yeoman or wharfinger 0
4150529 2078318 2078318 defendant Hynde John   609976 609976 Hynde, John, of Est Grenewiche, yeoman, "wharffinger" or wharf keeper 0
4166657 2083835 2083835 defendant Wood Anthony vintner 609976 609976 (Wood, Anthony, of Est Grenewiche, vintner 4
4175280 2086821 2086821 defendant Hynde John   609976 609976 Hynde, John, of East Grenewiche, yeoman, "wharffinger" or wharf keeper 0
4323137 2138153 2138153 defendant Gardener John tailor 609976 609976 Gardener, John, of East Grenewiche, or of Malden, Essex, tailor 0
4405753 2166494 2166494 defendant Hutcher Richard   609976 609976 Hutcher, Richard, of East Grenewiche, "ka-" 0
5386945 2471333 2471333 defendant Constantyne William gent 609976 609976 Constantyne, William, of East Grenewiche, gent 0
5416531 2479862 2479862 defendant Henman John carpenter 609976 609976 Henman, John, of East Grenewiche, carpenter 1

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