names

19 rows where place_id = 626188

✎ 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
3768554 1947811 1947811 defendant Dawby Richard miller 626188 626188 Dawby, Richard, of Detford, Kent, miller 0
3793864 1955948 1955948 defendant Taillor William fishmonger 626188 626188 Taillor, William, of Detford, Kent, fishmonger 1
3796245 1956690 1956690 defendant Taillour William fishmonger 626188 626188 Taillour, William, of Detford, Kent, fishmonger 1
3812638 1961841 1961841 defendant Johnson John   626188 626188 Johnson, John, of Detford, Kent, shipwright 2
3919101 1996711 1996711 defendant Tyson Richard yeoman 626188 626188 Tyson, Richard, of Detford, Kent, yeoman 2
3938435 2003198 2003198 defendant Thompson Robert   626188 626188 Thompson, Robert, of Detford, Kent, parson 0
3953644 2008349 2008349 defendant Gamble John yeoman 626188 626188 Gamble, John, of Detford, Kent, yeoman 0
4032842 2036400 2036400 defendant Fyllyon Henry carpenter 626188 626188 Fyllyon, Henry, of Detford, Kent, or of London, carpenter 0
4032844 2036401 2036401 defendant Fyllyon Henry carpenter 626188 626188 Fyllyon, Henry, of Detford, Kent, or of London, carpenter 0
4119101 2067117 2067117 defendant Mawnder Thomas clerk 626188 626188 Mawnder, Thomas, of Detford, Kent, clerk 0
4121675 2068049 2068049 defendant goodson John   626188 626188 goodson, John, of Detford, Kent, rope maker 1
4204807 2097225 2097225 defendant Goodstone John yeoman 626188 626188 Goodstone, John, of Detford, Kent, yeoman 1
4208582 2098551 2098551 defendant Rawson William innholder 626188 626188 Rawson, William, of Detford, Kent, innholder 0
4208588 2098553 2098553 defendant Rawson William vintner 626188 626188 Rawson, William, of Detford, Kent, vintner 0
4266862 2118558 2118558 defendant Adams Edward gent 626188 626188 (Adams, Edward, of Detford, Kent, gent 2
4357703 2149929 2149929 defendant Botyvant Roger gent 626188 626188 Botyvant, Roger, of Detford, Kent, gent 0
4370740 2154589 2154589 defendant Bagley Philip (legal representative) 626188 626188 Bagley, Philip, of Detford, Kent, butcher, executor of 0
4371496 2154860 2154860 defendant Spylman John gent 626188 626188 Spylman, John, of Detford, Kent, gent 0
4394595 2162781 2162781 defendant Crumpton Elias laborer 626188 626188 Crumpton, Elias, of Detford, Kent, laborer 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);