names

18 rows where place_id = 602245

✎ 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
3649140 1910118 1910118 defendant Watson Watson yeoman 602245 602245 Watson, Watson, of Westerdale, yeoman 1
3751377 1942346 1942346 defendant Watson Leonard yeoman 602245 602245 Watson, Leonard, of Westerdale, yeoman 0
3751378 1942346 1942346 defendant Fleccher Edward laborer 602245 602245 Fleccher, Edward, of Westerdale, laborer 1
3751379 1942346 1942346 defendant Strynger William laborer 602245 602245 Strynger, William, of Westerdale, laborer 2
3751380 1942346 1942346 defendant Thystylwayth Richard laborer 602245 602245 Thystylwayth, Richard, of Westerdale, laborer 3
3894377 1988336 1988336 defendant Yowerd Thomas yeoman 602245 602245 Yowerd, Thomas, of Westerdale, yeoman 0
4114756 2065566 2065566 defendant Trowsdale Agnes widow 602245 602245 Trowsdale, Agnes, of Westerdale, widow 0
4114757 2065566 2065566 defendant Westerdale Robert yeoman 602245 602245 Westerdale, Robert, of Westerdale, yeoman 1
4114758 2065566 2065566 defendant Hodgson John   602245 602245 Hodgson, John, of Westerdale 2
4263434 2117432 2117432 defendant White Robert yeoman 602245 602245 White, Robert, of Westerdale, yeoman 0
4323434 2138255 2138255 defendant White Edmund yeoman 602245 602245 White, Edmund, of Westerdale, yeoman 0
4323436 2138256 2138256 defendant White Robert yeoman 602245 602245 White, Robert, of Westerdale, yeoman 0
4588380 2227754 2227754 defendant Addyson John   602245 602245 Addyson, John, of Westerdale 11
4877737 2319999 2319999 defendant Cokull John chaplain 602245 602245 Cokull, John, of Westerdale, chaplain 1
5073879 2378680 2378680 plaintiff Watson Robert   602245 602245 Watson, Robert, of Westerdale 0
5073882 2378681 2378681 plaintiff Watson Robert   602245 602245 Watson, Robert, of Westerdale 0
5073885 2378682 2378682 plaintiff Watson Robert   602245 602245 Watson, Robert, of Westerdale 0
5296056 2443839 2443839 plaintiff Watson Robert (legal representative) 602245 602245 Watson, Robert, of Westerdale, executor of 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);