names

24 rows where place_id = 768688

✎ 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
4551259 2216334 2216334 defendant Selby Thomas   768688 768688 Selby, Thomas, of Cales 2
4551260 2216334 2216334 defendant atte Staire Roger   768688 768688 atte Staire, Roger, of Cales 3
4551263 2216335 2216335 defendant Warde John   768688 768688 Warde, John, of Cales 0
4551268 2216335 2216335 defendant Wotton Lawrence   768688 768688 Wotton, Lawrence, of Cales 5
4575960 2223974 2223974 defendant Orwell William   768688 768688 Orwell, William, of Cales 0
4597123 2230342 2230342 defendant Selby Thomas   768688 768688 Selby, Thomas, of Cales 0
4597130 2230343 2230343 defendant Selby Thomas   768688 768688 Selby, Thomas, of Cales 0
4608238 2233685 2233685 defendant Cliderowe Richard soldier 768688 768688 Cliderowe, Richard, of Cales, soldier 0
4608328 2233717 2233717 plaintiff Boteler John merchant 768688 768688 Boteler, John, of Cales, merchant 0
4608330 2233718 2233718 plaintiff Boteler John merchant 768688 768688 Boteler, John, of Cales, merchant 0
4617378 2236447 2236447 defendant Hunt Michael slater 768688 768688 Hunt, Michael, of Cales, slater 5
4710361 2268595 2268595 plaintiff Pykeryng John   768688 768688 Pykeryng, John, of Cales 0
4710362 2268595 2268595 plaintiff Pykeryng William   768688 768688 Pykeryng, William, of Cales 1
4710365 2268596 2268596 plaintiff Pykeryng John   768688 768688 Pykeryng, John, of Cales 0
4733122 2275537 2275537 plaintiff Preston John soldier 768688 768688 Preston, John, of Cales, soldier 0
4852457 2312186 2312186 plaintiff Waylond Walter   768688 768688 Waylond, Walter, of Cales 0
4917059 2331842 2331842 defendant Page Giles butcher 768688 768688 Page, Giles, of Cales, butcher 3
4931205 2336144 2336144 defendant S--- Richard esq 768688 768688 S---, Richard, of Cales, esq 0
5156874 2403159 2403159 defendant Challey John merchant 768688 768688 Challey, John, of Cales, merchant 2
5156929 2403172 2403172 defendant Challey John merchant 768688 768688 Challey, John, of Cales, merchant 4
5247475 2429417 2429417 plaintiff Spevy John   768688 768688 Spevy, John, of Cales 0
5250774 2430353 2430353 plaintiff Wodehous John esq 768688 768688 Wodehous, John, of Cales, esq 0
5388256 2471690 2471690 plaintiff Gower Thomas (legal representative) 768688 768688 Gower, Thomas, of Cales, executor of 0
5429327 2483704 2483704 plaintiff Gower Thomas (legal representative) 768688 768688 Gower, Thomas, of Cales, 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);