names

10 rows where case_id = 2232350

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4603714 2232350 2232350 plaintiff Wryghte Robert   773728 773728 Wryghte, Robert, of Toftes Rokelound 0
4603715 2232350 2232350 plaintiff Wryghte Margery     Margery, his wife 1
4603716 2232350 2232350 plaintiff Caus Richard   773729 773729 Caus, Richard, of Hhengham 2
4603717 2232350 2232350 defendant Grym John   630160 630160 Grym, John, of Watlisfeld, son of Amory 0
4603718 2232350 2232350 defendant Goos John   773731 773731 Goos, John, of Hilderkle 1
4603719 2232350 2232350 defendant Busshell John   587901 587901 Busshell, John, of Holkham 2
4603720 2232350 2232350 defendant Mannyng John jun, of Shropham   Mannyng, John, jun, of Shropham 3
4603721 2232350 2232350 defendant Clerk John   588844 588844 together with Clerk, John, of Banham 4
4603722 2232350 2232350 defendant Deye Richard   755676 755676 Deye, Richard, of Little Elyngham 5
4603723 2232350 2232350 defendant Seye Robert   756563 756563 Seye, Robert, of Bokyngham 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);