names

10 rows where case_id = 2484037

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5430440 2484037 2484037 plaintiff Hesill John   801846 801846 Hesill, John, of Kyrk Smeton, administrators of 0
5430441 2484037 2484037 plaintiff Craven Richard     (Craven, Richard 1
5430442 2484037 2484037 plaintiff Craven Elizabeth formerly wife of John   Elizabeth, his wife, formerly wife of John 2
5430443 2484037 2484037 defendant Aubrey Thomas husbandman 810966 810966 Aubrey, Thomas, of Bargh, husbandman 0
5430444 2484037 2484037 defendant Calvert William yeoman 886744 886744 Calvert, William, of Husilve or Husiwe, Lincs, yeoman 1
5430445 2484037 2484037 defendant Shirburn Richard husbandman 806952 806952 Shirburn, Richard, of Epworth, on the Isle of Axholme, Lincs, husbandman 2
5430446 2484037 2484037 defendant Spabald William (legal representative) 675722 675722 Spabald, William, of Elmesall, executors of 3
5430447 2484037 2484037 defendant Spabald William husbandman 595202 595202 (Spabald, William, of Swanby, Notts, husbandman 4
5430448 2484037 2484037 defendant Cotton John husbandman 680679 680679 Cotton, John, of Saunby, husbandman 5
5430449 2484037 2484037 defendant Cotton Isabel formerly wife of William   Isabel, his wife, formerly wife of William 6

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