names

32 rows where place_id = 754361

✎ 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
4419562 2171004 2171004 plaintiff Belle William   754361 754361 Belle, William, of Morpath 0
4462711 2189038 2189038 defendant del Grene John   754361 754361 del Grene, John, of Morpath 3
4462720 2189039 2189039 defendant del Grene John   754361 754361 del Grene, John, of Morpath 3
4524985 2208152 2208152 defendant Flesshewer William   754361 754361 Flesshewer, William, of Morpath 0
4527658 2208933 2208933 plaintiff Lorymer John   754361 754361 Lorymer, John, of Morpath 0
4527662 2208933 2208933 defendant Rede William   754361 754361 Rede, William, of Morpath 3
4528296 2209126 2209126 defendant Flecher Margaret   754361 754361 Flecher, Margaret, of Morpath 3
4623613 2238365 2238365 defendant Lok William   754361 754361 Lok, William, of Morpath 0
4644033 2244353 2244353 defendant Creke William   754361 754361 Creke, William, of Morpath 0
4655476 2247607 2247607 defendant Forster John yeoman 754361 754361 Forster, John, of Morpath, yeoman 6
4659911 2248954 2248954 defendant Croke William gent 754361 754361 Croke, William, of Morpath, gent 0
4663702 2250130 2250130 defendant Ussher Roger esq 754361 754361 Ussher, Roger, of Morpath, esq 0
4665198 2250600 2250600 defendant Startill Thomas yeoman 754361 754361 Startill, Thomas, of Morpath, yeoman 0
4674056 2257496 2257496 defendant Forster John yeoman 754361 754361 Forster, John, of Morpath, yeoman 1
4674057 2257496 2257496 defendant Smales Richard yeoman 754361 754361 Smales, Richard, of Morpath, yeoman 2
4743477 2278621 2278621 defendant Darley Walter   754361 754361 Darley, Walter, of Morpath, parson 0
4743535 2278637 2278637 defendant Mawedyt William gent 754361 754361 Mawedyt, William, of Morpath, gent 0
4752491 2281190 2281190 defendant Wardhalgh William yeoman 754361 754361 Wardhalgh, William, of Morpath, yeoman 0
4752492 2281190 2281190 defendant Bron John yeoman 754361 754361 Bron, John, of Morpath, yeoman 1
4781185 2290126 2290126 defendant Swynburn William yeoman 754361 754361 Swynburn, William, of Morpath, yeoman 0
4843340 2309433 2309433 defendant Buk James yeoman 754361 754361 Buk, James, of Morpath, yeoman 2
4843341 2309433 2309433 defendant Chestre William mercer 754361 754361 Chestre, William, of Morpath, mercer 3
4870761 2317834 2317834 defendant Buk James yeoman 754361 754361 Buk, James, of Morpath, yeoman 1
4870762 2317834 2317834 defendant Chestre William mercer 754361 754361 Chestre, William, of Morpath, mercer 2
4872246 2318279 2318279 defendant Yonger Robert husbandman 754361 754361 Yonger, Robert, of Morpath, husbandman 2
5035487 2367239 2367239 defendant Bukke James gent 754361 754361 Bukke, James, of Morpath, gent 0
5042024 2369219 2369219 defendant Symper Gilbert yeoman 754361 754361 Symper, Gilbert, of Morpath, yeoman 1
5378087 2468725 2468725 defendant Graystok Ralph   754361 754361 Graystok, Ralph, of Morpath, knight, Baron of Graystok & Weme 0
5378090 2468726 2468726 defendant Graystok Ralph   754361 754361 Graystok, Ralph, of Morpath, knight, Baron of Graystok & Weme 0
5378093 2468727 2468727 defendant Graystok Ralph   754361 754361 Graystok, Ralph, of Morpath, knight, Baron of Graystok & Weme 0
5378096 2468728 2468728 defendant Graystok Ralph   754361 754361 Graystok, Ralph, of Morpath, knight, Baron of Graystok & Weme 0
5626395 2552225 2552225 defendant Smale Richard yeoman 754361 754361 Smale, Richard, of Morpath, yeoman 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);