names

17 rows where place_id = 624952

✎ 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
3761281 1945532 1945532 defendant Alee John yeoman 624952 624952 Alee, John, of Sandwyche, yeoman 1
3761292 1945534 1945534 defendant Wattys John mariner 624952 624952 Wattys, John, of Sandwyche, mariner 1
3887183 1985978 1985978 plaintiff Cokke Thomas mariner 624952 624952 Cokke, Thomas, of Sandwyche, mariner 0
3887185 1985979 1985979 plaintiff Cokke Thomas mariner 624952 624952 Cokke, Thomas, of Sandwyche, mariner 0
3907005 1992631 1992631 defendant Rolffe Thomas esq 624952 624952 Rolffe, Thomas, of Sandwyche, esq 0
3916920 1996024 1996024 defendant Pynoke or Pyncke William yeoman 624952 624952 Pynoke or Pyncke, William, of Sandwyche, yeoman 2
3916924 1996025 1996025 defendant Pynoke William yeoman 624952 624952 Pynoke, William, of Sandwyche, yeoman 2
3946602 2005878 2005878 defendant Parrat Rice or Richard gent 624952 624952 Parrat, Rice or Richard, of Sandwyche, gent 0
4080060 2053173 2053173 defendant Wylkyns Peter yeoman 624952 624952 Wylkyns, Peter, of Sandwyche, yeoman 0
4151701 2078708 2078708 defendant Tysarr Thomas clothier 624952 624952 Tysarr, Thomas, of Sandwyche, clothier 0
4153701 2079390 2079390 defendant Lee Robert gent 624952 624952 Lee, Robert, of Sandwyche, gent 0
4153703 2079391 2079391 defendant Lee Robert gent 624952 624952 Lee, Robert, of Sandwyche, gent 0
4203467 2096765 2096765 defendant Turke Robert yeoman 624952 624952 Turke, Robert, of Sandwyche, or of London, yeoman 0
4619274 2237023 2237023 defendant atte Fanne Thomas   624952 624952 atte Fanne, Thomas, of Sandwyche 1
4628673 2239891 2239891 defendant Brys Henry merchant 624952 624952 Brys, Henry, of Sandwyche, merchant 0
5254702 2431585 2431585 defendant Edmund John mariner 624952 624952 Edmund, John, of Sandwyche, mariner 2
5329157 2453798 2453798 plaintiff Aldy John merchant 624952 624952 Aldy, John, of Sandwyche, merchant 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);