names

13 rows where place_id = 767014

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598456 1867147 1867147 plaintiff Spryng Thomas (legal representative) 767014 767014 Spryng, Thomas, of Levenham, executors of 0
3598460 1867148 1867148 plaintiff Spryng Thomas (legal representative) 767014 767014 Spryng, Thomas, of Levenham, executors of 0
4534616 2211096 2211096 plaintiff Scarlet Robert   767014 767014 Scarlet, Robert, of Levenham 0
4580370 2225342 2225342 plaintiff Daunvers John   767014 767014 Daunvers, John, of Levenham, parson 0
4580372 2225343 2225343 plaintiff Daunvers John   767014 767014 Daunvers, John, of Levenham, parson 0
4580374 2225344 2225344 plaintiff Daunvers John   767014 767014 Daunvers, John, of Levenham, parson 0
4628490 2239831 2239831 plaintiff Scarlet Robert   767014 767014 Scarlet, Robert, of Levenham 0
4813297 2300275 2300275 defendant Merke Thomas weaver 767014 767014 Merke, Thomas, of Levenham, weaver 0
4814611 2300680 2300680 defendant Grome William weaver 767014 767014 Grome, William, of Levenham, weaver 0
4826199 2304229 2304229 defendant Clement William yeoman 767014 767014 Clement, William, of Levenham, yeoman 0
4920513 2332930 2332930 plaintiff Jeffrey John smith 767014 767014 Jeffrey, John, of Levenham, smith 0
4920514 2332930 2332930 defendant Jeffrey John smith 767014 767014 Jeffrey, John, of Levenham, smith 0
5525240 2512488 2512488 plaintiff Grome Rose (legal representative) 767014 767014 Grome, Rose, of Levenham, widow, 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);