names

22 rows where place_id = 666342

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3980647 2017845 2017845 plaintiff Plomer William gent 666342 666342 Plomer, William, of Barnards Inn, Middx, gent 0
4001536 2025327 2025327 defendant Broke Thomas gent 666342 666342 Broke, Thomas, of Barnards Inn, Middx, gent 9
4020976 2032229 2032229 defendant Harecourt Robert gent 666342 666342 Harecourt, Robert, of Barnards Inn, Middx, gent 2
4029006 2035018 2035018 defendant Challice Thomas gent 666342 666342 Challice, Thomas, of Barnards Inn, Middx, gent 0
4029937 2035353 2035353 plaintiff Doryngton John   666342 666342 Doryngton, John, of Barnards Inn, Middx 0
4034707 2037095 2037095 plaintiff Hatley Richard gent 666342 666342 Hatley, Richard, of Barnards Inn, Middx, gent 0
4057934 2045220 2045220 defendant Goldsmyth John, junior gent 666342 666342 Goldsmyth, John, junior, of Barnards Inn, Middx, gent 0
4081474 2053684 2053684 plaintiff Whytynge John gent 666342 666342 Whytynge, John, of Barnards Inn, Middx, gent 0
4084071 2054578 2054578 defendant Brooke Thomas   666342 666342 Brooke, Thomas, of Barnards Inn, Middx, gent, attorney of the bench 0
4100851 2060621 2060621 plaintiff Kenwarde John gent 666342 666342 Kenwarde, John, of Barnards Inn, Middx, gent 0
4109648 2063707 2063707 defendant Mighell Anthony gent 666342 666342 Mighell, Anthony, of Barnards Inn, Middx, gent 2
4199817 2095488 2095488 defendant Rant John singleman 666342 666342 Rant, John, of Barnards Inn, Middx, gent, or of North Walsham, singleman 0
4209536 2098886 2098886 defendant Nwman John gent 666342 666342 Nwman, John, of Barnards Inn, Middx, gent 0
4210115 2099097 2099097 defendant Barnard William gent 666342 666342 Barnard, William, of Barnards Inn, Middx, gent 1
4242578 2110511 2110511 defendant Wylcock William gent 666342 666342 Wylcock, William, of Barnards Inn, Middx, gent 3
4242583 2110512 2110512 defendant Wylcock William gent 666342 666342 Wylcock, William, of Barnards Inn, Middx, gent 3
4258269 2115738 2115738 defendant Wolfreston Hersey gent 666342 666342 Wolfreston, Hersey, of Barnards Inn, Middx, gent 1
4270310 2119652 2119652 defendant Wolfreyston Hersey gent 666342 666342 Wolfreyston, Hersey, of Barnards Inn, Middx, gent 1
4284990 2124680 2124680 defendant Rant John gent 666342 666342 Rant, John, of Barnards Inn, Middx, gent 0
4327905 2139656 2139656 defendant Stopford William gent 666342 666342 Stopford, William, of Barnards Inn, Middx, gent 2
4344759 2145446 2145446 defendant Tekeridge Arnold gent 666342 666342 Tekeridge, Arnold, of Barnards Inn, Middx, gent 0
4370918 2154654 2154654 defendant Emerye Thomas gent 666342 666342 Emerye, Thomas, of Barnards Inn, Middx, gent 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);