names

21 rows where place_id = 789010

✎ 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
4710940 2268777 2268777 plaintiff Roger John   789010 789010 Roger, John, of Bryaneston 0
4710951 2268780 2268780 plaintiff Rogger John   789010 789010 Rogger, John, of Bryaneston 0
4733538 2275666 2275666 plaintiff Reger John   789010 789010 Reger, John, of Bryaneston 0
4770831 2286858 2286858 plaintiff Roger John   789010 789010 Roger, John, of Bryaneston 0
4795650 2294792 2294792 plaintiff Roger John   789010 789010 Roger, John, of Bryaneston 0
4847305 2310660 2310660 plaintiff Roger John   789010 789010 Roger, John, of Bryaneston 0
4847308 2310661 2310661 plaintiff Roger John   789010 789010 Roger, John, of Bryaneston 0
4847310 2310662 2310662 plaintiff Roger John   789010 789010 Roger, John, of Bryaneston 0
4875019 2319136 2319136 plaintiff Roger John   789010 789010 Roger, John, of Bryaneston 0
4952359 2342662 2342662 defendant Broun Walter yeoman 789010 789010 Broun, Walter, of Bryaneston, yeoman 0
4952360 2342662 2342662 defendant Coker Ralph gent 789010 789010 Coker, Ralph, of Bryaneston, gent 1
4952376 2342665 2342665 plaintiff Rogger John esq 789010 789010 Rogger, John, of Bryaneston, esq 0
4972069 2348584 2348584 plaintiff John John (legal representative) 789010 789010 John, John, of Bryaneston, executors of 0
5005366 2358472 2358472 plaintiff Roger John (legal representative) 789010 789010 Roger, John, of Bryaneston, executors of 0
5031797 2366171 2366171 plaintiff Roger John (legal representative) 789010 789010 Roger, John, of Bryaneston, executor of 0
5031804 2366173 2366173 plaintiff Roger John, senior (legal representative) 789010 789010 Roger, John, senior, of Bryaneston, executor of 0
5048488 2371187 2371187 plaintiff Roger John esq 789010 789010 Roger, John, of Bryaneston, esq 0
5048497 2371189 2371189 defendant (illegible) Robert butcher 789010 789010 ---, Robert, of Bryaneston, butcher 0
5048542 2371203 2371203 plaintiff Roger John, senior esq 789010 789010 Roger, John, senior, of Bryaneston, esq 0
5629812 2553322 2553322 defendant atte Wylle John   789010 789010 atte Wylle, John, of Bryaneston, Jonesservant Rogger 0
5629814 2553323 2553323 defendant Broune Walter   789010 789010 Broune, Walter, of Bryaneston, Jonesservant Rogger 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);