names

21 rows where place_id = 685926

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4064574 2047612 2047612 plaintiff Gyll William   685926 685926 Gyll, William, of Ossett 0
4064919 2047738 2047738 defendant Lee George clothier 685926 685926 Lee, George, of Ossett, clothier 0
4085892 2055231 2055231 defendant Boyne John yeoman 685926 685926 Boyne, John, of Ossett, yeoman 3
4099635 2060194 2060194 defendant Townend Robert laborer 685926 685926 Townend, Robert, of Ossett, laborer 0
4099636 2060194 2060194 defendant Dawson Edmund laborer 685926 685926 Dawson, Edmund, of Ossett, laborer 1
4099637 2060194 2060194 defendant Walker William laborer 685926 685926 Walker, William, of Ossett, laborer 2
4099638 2060194 2060194 defendant Dyckonson John laborer 685926 685926 Dyckonson, John, of Ossett, laborer 3
4099639 2060194 2060194 defendant Baldon John laborer 685926 685926 Baldon, John, of Ossett, laborer 4
4128313 2070410 2070410 defendant Wayde John clothier 685926 685926 Wayde, John, of Ossett, clothier 0
4170876 2085303 2085303 defendant Robynson John husbandman 685926 685926 Robynson, John, of Ossett, husbandman 1
4174840 2086669 2086669 defendant Wade John clothier 685926 685926 Wade, John, of Ossett, clothier 0
4263060 2117310 2117310 defendant Wade James clothier 685926 685926 Wade, James, of Ossett, clothier 1
4263076 2117316 2117316 defendant Wade James clothier 685926 685926 Wade, James, of Ossett, clothier 1
4312740 2134587 2134587 defendant Bleasbye Robert yeoman 685926 685926 Bleasbye, Robert, of Ossett, yeoman 1
4323183 2138168 2138168 defendant Hobson William gent 685926 685926 Hobson, William, of Ossett, gent 0
4339325 2143520 2143520 defendant Waterhouse Humphrey yeoman 685926 685926 Waterhouse, Humphrey, of Ossett, yeoman 0
4349722 2147165 2147165 defendant Dishefurthe Edmund clothier 685926 685926 Dishefurthe, Edmund, of Ossett, clothier 0
4366644 2153117 2153117 defendant Nayler John clothier 685926 685926 Nayler, John, of Ossett, clothier 0
4373351 2155535 2155535 defendant Gill William, junior clothier 685926 685926 Gill, William, junior, of Ossett, clothier 0
4397526 2163753 2163753 defendant Naylor George clothier 685926 685926 Naylor, George, of Ossett, clothier 0
4865084 2316054 2316054 defendant Hill William, junior husbandman 685926 685926 Hill, William, junior, of Ossett, husbandman 2

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