names

16 rows where place_id = 611607

✎ 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
3689149 1922770 1922770 defendant Southcote John gent 611607 611607 Southcote, John, of Bovy Tracy, Devon, gent 0
3696021 1924993 1924993 defendant Braban John yeoman 611607 611607 Braban, John, of Bovy Tracy, Devon, yeoman 3
3743647 1939889 1939889 defendant Brabon John gent 611607 611607 Brabon, John, of Bovy Tracy, Devon, gent 0
3743673 1939902 1939902 defendant Stapylhyll Thomas yeoman 611607 611607 Stapylhyll, Thomas, of Bovy Tracy, Devon, yeoman 0
3773547 1949438 1949438 defendant Furlondon John   611607 611607 Furlondon, John, of Bovy Tracy, Devon, yeoman, son of Furlondon, William, of Bovy Tracy 1
3786921 1953713 1953713 defendant Pynson John yeoman 611607 611607 Pynson, John, of Bovy Tracy, Devon, yeoman 0
3866500 1979025 1979025 defendant Southcote John gent 611607 611607 Southcote, John, of Bovy Tracy, Devon, gent 0
3969355 2013886 2013886 defendant Gilberd Edward gent 611607 611607 Gilberd, Edward, of Bovy Tracy, Devon, gent 3
4214842 2100693 2100693 defendant Jeffrye alias Cristofer Thomas butcher 611607 611607 Jeffrye alias Cristofer, Thomas, of Bovy Tracy, Devon, butcher 0
4241220 2110051 2110051 defendant Jeffreye alias Cristofer Thomas butcher 611607 611607 Jeffreye alias Cristofer, Thomas, of Bovy Tracy, Devon, butcher 0
4398885 2164210 2164210 defendant Southcott Peter gent 611607 611607 Southcott, Peter, of Bovy Tracy, Devon, gent 0
4787038 2292010 2292010 defendant Bronnewynd John chapman 611607 611607 Bronnewynd, John, of Bovy Tracy, Devon, chapman 2
5029467 2365491 2365491 defendant Wratte William chapman 611607 611607 Wratte, William, of Bovy Tracy, Devon, chapman 0
5066752 2376585 2376585 defendant Wrot William merchant 611607 611607 Wrot, William, of Bovy Tracy, Devon, merchant 0
5471817 2496525 2496525 defendant Frenshe John mercer 611607 611607 Frenshe, John, of Bovy Tracy, Devon, mercer 0
5471829 2496527 2496527 defendant Frenshe John mercer 611607 611607 Frenshe, John, of Bovy Tracy, Devon, mercer 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);