names

6 rows where case_id = 2421046

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5218172 2421046 2421046 plaintiff Gay Thomas, senior tailor 585869 585869 Gay, Thomas, senior, of London, tailor 0
5218173 2421046 2421046 defendant Crystyan Beatrice widow 860504 860504 Crystyan, Beatrice, of Borstall, Plumstede, Kent, widow 0
5218174 2421046 2421046 defendant Cokke John yeoman 629588 629588 Cokke, John, of Plumstede, yeoman 1
5218175 2421046 2421046 defendant Delver Robert laborer 860505 860505 Delver, Robert, of Borstall, Plumstede, laborer 2
5218176 2421046 2421046 defendant Golette Thomas husbandman 860506 860506 Golette, Thomas, of Wellyng, Est Wykeham, Kent, husbandman 3
5218177 2421046 2421046 defendant Payn Thomas yeoman 860507 860507 Payn, Thomas, of Est Wykeham, yeoman 4

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