names

14 rows where place_id = 886186

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4554117 2217210 2217210 defendant Norton John   886186 886186 (Norton, John, of Notley 1
5260620 2433452 2433452 defendant Basshe Peter glover 886186 886186 Basshe, Peter, of Notley, glover 11
5275599 2437929 2437929 plaintiff Staunton William   886186 886186 Staunton, William, of Notley, abbot of the monastery of the BM & St John Baptist, Augustinian Order 0
5275601 2437930 2437930 plaintiff Staunton William   886186 886186 Staunton, William, of Notley, abbot of the monastery of the BM & St John Baptist, Augustinian Order 0
5377909 2468666 2468666 plaintiff Caversham Peter   886186 886186 Caversham, Peter, of Notley, abbot of the Monastery of Blessed Mary 1
5380683 2469523 2469523 plaintiff Caversham Peter   886186 886186 Caversham, Peter, of Notley, abbot of the monastery of the BM 0
5397821 2474447 2474447 plaintiff Caversham Peter   886186 886186 Caversham, Peter, of Notley, abbot of the House & House of BM 0
5397823 2474448 2474448 plaintiff Caversham Peter   886186 886186 Caversham, Peter, of Notley, abbot of the House or Monastery of BM 0
5410987 2478238 2478238 plaintiff Caversham Peter   886186 886186 Caversham, Peter, of Notley, abbot of the House or monastery church of the BM 0
5410989 2478239 2478239 plaintiff Caversham Peter   886186 886186 Caversham, Peter, of Notley, abbot of the House or monastery church of the BM 0
5420916 2481185 2481185 defendant Steven William yeoman 886186 886186 Steven, William, of Notley, yeoman 0
5425135 2482481 2482481 plaintiff Caversham Peter   886186 886186 Caversham, Peter, of Notley, abbot of the monastery of the BM & St John Baptist 0
5425138 2482482 2482482 plaintiff Caversham Peter   886186 886186 Caversham, Peter, of Notley, abbot of the monastery of the BM & St John Baptist 0
5456404 2491836 2491836 plaintiff Caversham Peter   886186 886186 Caversham, Peter, of Notley, abbot of the monastery of the BM & St John baptist 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);