names

23 rows where place_id = 689304

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4079870 2053100 2053100 defendant France William husbandman 689304 689304 France, William, of Westerkeale, husbandman 1
4084401 2054694 2054694 defendant Kelebecke Christopher gent 689304 689304 Kelebecke, Christopher, of Westerkeale, gent 0
4089114 2056401 2056401 defendant Kilbacke Christopher gent 689304 689304 Kilbacke, Christopher, of Westerkeale, gent 0
4119175 2067148 2067148 defendant Melbourie John yeoman 689304 689304 Melbourie, John, of Westerkeale, yeoman 0
4136134 2073268 2073268 defendant Wylkenson John husbandman 689304 689304 Wylkenson, John, of Westerkeale, husbandman 0
4142041 2075389 2075389 defendant Lee Robert yeoman 689304 689304 Lee, Robert, of Westerkeale, yeoman 0
4200274 2095649 2095649 defendant Boole Peter yeoman 689304 689304 Boole, Peter, of Westerkeale, yeoman 0
4231669 2106578 2106578 defendant Jackson George clerk 689304 689304 Jackson, George, of Westerkeale, clerk 3
4235249 2107889 2107889 defendant Grave Christopher yeoman 689304 689304 Grave Christopher, of Westerkeale, yeoman 0
4236911 2108487 2108487 defendant Jackson George clerk 689304 689304 Jackson, George, of Westerkeale, clerk 0
4238670 2109141 2109141 defendant Jackson George clerk 689304 689304 Jackson, George, of Westerkeale, clerk 1
4240607 2109841 2109841 defendant Jackson George clerk 689304 689304 Jackson, George, of Westerkeale, clerk 3
4335010 2141978 2141978 defendant Heyton John gent 689304 689304 Heyton, John, of Westerkeale, gent 0
4335012 2141979 2141979 defendant Lake William yeoman 689304 689304 Lake, William, of Westerkeale, yeoman 0
4335014 2141980 2141980 defendant Heyton John gent 689304 689304 Heyton, John, of Westerkeale, gent 0
4335015 2141980 2141980 defendant Lake William yeoman 689304 689304 Lake, William, of Westerkeale, yeoman 1
4348366 2146679 2146679 defendant Wrighte Roger yeoman 689304 689304 Wrighte, Roger, of Westerkeale, yeoman 2
4352532 2148123 2148123 defendant Richardson Gilbert husbandman 689304 689304 Richardson, Gilbert, of Westerkeale, husbandman 2
4352533 2148123 2148123 defendant Richerdson Simon husbandman 689304 689304 Richerdson, Simon, of Westerkeale, husbandman 3
4363176 2151894 2151894 defendant Grave Christopher husbandman 689304 689304 Grave, Christopher, of Westerkeale, husbandman 0
4363177 2151894 2151894 defendant Grave Robert   689304 689304 Grave, Robert, of Westerkeale, husbandman, his son 1
4366141 2152932 2152932 defendant Lincoln Thomas husbandman 689304 689304 Lincoln, Thomas, of Westerkeale, husbandman 0
4380188 2158017 2158017 defendant Wrighte Robert yeoman 689304 689304 Wrighte, Robert, of Westerkeale, yeoman 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);