names

14 rows where case_id = 2033383

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4024273 2033383 2033383 plaintiff Bigilston John attorney of the bench   Bigilston, John, attorney of the bench 0
4024274 2033383 2033383 defendant Mathewe Elizabeth widow 655894 655894 Mathewe, Elizabeth, of Pynho, Devon, widow 0
4024275 2033383 2033383 defendant Parker William tailor 676810 676810 Parker, William, of Pynho, tailor 1
4024276 2033383 2033383 defendant White John shoemaker 586036 586036 White, John, of Exeter, shoemaker 2
4024277 2033383 2033383 defendant Payne William yeoman 676811 676811 Payne, William, of St Ciric, Devon, yeoman 3
4024278 2033383 2033383 defendant Maunder Thomas smith 668768 668768 Maunder, Thomas, of Cheriton Bishop, Devon, smith 4
4024279 2033383 2033383 defendant Crowce Anne widow 676812 676812 Crowce, Anne, of Worthbovy, Devon, widow 5
4024280 2033383 2033383 defendant Hancok Henry husbandman 676813 676813 Hancok, Henry, of West Putford, Devon, husbandman 6
4024281 2033383 2033383 defendant Hunt Richard   676546 676546 Hunt, Richard, of Loxbeare, Devon 7
4024282 2033383 2033383 defendant Frost Mathew   663170 663170 Frost, Mathew, of Crediton, Devon 8
4024283 2033383 2033383 defendant Syms Leonard husbandman 673008 673008 Syms, Leonard, of Wytheridge, Devon, husbandman 9
4024284 2033383 2033383 defendant Elworthy Hugh husbandman 676814 676814 Elworthy, Hugh, of Est Worlington, Devon, husbandman 10
4024285 2033383 2033383 defendant Cloke Edward clerk 676815 676815 Cloke, Edward, of Thelbridge, Devon, clerk 11
4024286 2033383 2033383 defendant Weneman Edward husbandman 676816 676816 Weneman, Edward, of St Sydwyll, Devon, husbandman 12

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