names

19 rows where case_id = 2230916

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4599017 2230916 2230916 plaintiff Staverton John     Staverton, John 0
4599018 2230916 2230916 plaintiff rykedon Robert     rykedon, Robert 1
4599019 2230916 2230916 plaintiff Martyn John     Martyn, John 2
4599020 2230916 2230916 plaintiff Moys William     Moys, William 3
4599021 2230916 2230916 plaintiff Martyn Thomas     Martyn, Thomas 4
4599022 2230916 2230916 plaintiff Rolf Alexander     Rolf, Alexander 5
4599023 2230916 2230916 defendant Estwode Geoffrey   770120 770120 Estwode, Geoffrey, of Great Bromley 0
4599024 2230916 2230916 defendant Gaseweyde William   770120 770120 Gaseweyde, William, of Great Bromley 1
4599025 2230916 2230916 defendant Rydale John     Rydale, John 2
4599026 2230916 2230916 defendant Cowey Thomas   773296 773296 Cowey, Thomas, of Little Bromley 3
4599027 2230916 2230916 defendant Kyng Robert   770120 770120 Kyng, Robert, of Great Bromley 4
4599028 2230916 2230916 defendant Kyng John   770120 770120 Kyng, John, of Great Bromley 5
4599029 2230916 2230916 defendant Heyward John   770120 770120 Heyward, John, of Great Bromley 6
4599030 2230916 2230916 defendant Cowey William   770120 770120 Cowey, William, of Great Bromley 7
4599031 2230916 2230916 defendant Hylp John   765268 765268 Hylp, John, of Little Benteley 8
4599032 2230916 2230916 defendant Hylp Robert   765268 765268 Hylp, Robert, of Little Benteley 9
4599033 2230916 2230916 defendant Sexteyn John   773297 773297 Sexteyn, John, of Little Bromely 10
4599034 2230916 2230916 defendant Webbe John   773296 773296 Webbe, John,of Little Bromley 11
4599035 2230916 2230916 defendant Sturgeon Mathew   773296 773296 Sturgeon, Mathew, of Little Bromley 12

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);