names

22 rows where place_id = 826622

✎ 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
4795648 2294791 2294791 plaintiff Roger John   826622 826622 Roger, John, of Brianeston 0
4795658 2294795 2294795 plaintiff Rogere John   826622 826622 Rogere, John, of Brianeston 0
4821209 2302714 2302714 plaintiff Roger John   826622 826622 Roger, John, of Brianeston, on his own account 0
4952295 2342654 2342654 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4952304 2342655 2342655 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4952311 2342656 2342656 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4952318 2342657 2342657 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4952327 2342658 2342658 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4952335 2342659 2342659 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4952340 2342660 2342660 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4952345 2342660 2342660 defendant Sherman Robert sherman 826622 826622 Sherman, Robert, of Brianeston, sherman 1
4952349 2342661 2342661 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4952355 2342662 2342662 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4952364 2342663 2342663 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4952371 2342664 2342664 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
4978466 2350507 2350507 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
5005345 2358466 2358466 defendant Coker Ralph gent 826622 826622 Coker, Ralph, of Brianeston, gent 0
5005353 2358469 2358469 plaintiff Roger John   826622 826622 Roger, John, of Brianeston 0
5005356 2358470 2358470 plaintiff Roger John   826622 826622 Roger, John, of Brianeston 0
5005359 2358471 2358471 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, executors of 0
5048552 2371206 2371206 plaintiff Rogger John esq 826622 826622 Rogger, John, of Brianeston, esq 0
5094165 2384699 2384699 plaintiff Roger John (legal representative) 826622 826622 Roger, John, of Brianeston, son of Roger, John, of Brianeston, executors 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);