names

13 rows where case_id = 2365111

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5028167 2365111 2365111 plaintiff Milborne Richard esq   Milborne, Richard, esq 0
5028168 2365111 2365111 defendant Dewale John esq 767599 767599 Dewale, John, of Dauntesey, esq 0
5028169 2365111 2365111 defendant Hayne Richard gent 586859 586859 Hayne, Richard, of Salisbury, gent 1
5028170 2365111 2365111 defendant Langto Edmund gent 586859 586859 Langto, Edmund, of Salisbury, gent 2
5028171 2365111 2365111 defendant Penston Edmund gent 586859 586859 Penston, Edmund, of Salisbury, gent 3
5028172 2365111 2365111 defendant Wylly John merchant 586859 586859 Wylly, John, of Salisbury, merchant 4
5028173 2365111 2365111 defendant Thacham William husbandman 720430 720430 Thacham, William, of Idmeston, husbandman 5
5028174 2365111 2365111 defendant Thacham Richard husbandman 720430 720430 Thacham, Richard, of Idmeston, husbandman 6
5028175 2365111 2365111 defendant Croke John gent 626632 626632 Croke, John, of Haselbere, gent 7
5028176 2365111 2365111 defendant Croke Reginald gent 729955 729955 Croke, Reginald, of Codford, gent 8
5028177 2365111 2365111 defendant Ambrose Richard yeoman 836954 836954 Ambrose, Richard, of Allewardbury, yeoman 9
5028178 2365111 2365111 defendant Hasard Thomas gent 595192 595192 Hasard, Thomas, of Lee, gent 10
5028179 2365111 2365111 defendant Morgan Philip gent 816234 816234 Morgan, Philip, of Chytterne, gent 11

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