names

14 rows where case_id = 2360371

✎ 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
5012038 2360371 2360371 plaintiff Wyghton Edmund     Wyghton, Edmund 0
5012039 2360371 2360371 defendant Bocher Richard butcher 586748 586748 Bocher, Richard, of Welles, butcher 0
5012040 2360371 2360371 defendant Sharyngton John   834917 834917 Sharyngton, John, of Blakynney, shoe maker 1
5012041 2360371 2360371 defendant Colyn John smith 589532 589532 Colyn, John, of Fakenham, smith 2
5012042 2360371 2360371 defendant Buk Richard husbandman 592093 592093 Buk, Richard, of Wyghton, husbandman 3
5012043 2360371 2360371 defendant Fechet Richard yeoman 834918 834918 Fechet, Richard, of Salt House, yeoman 4
5012044 2360371 2360371 defendant Roo James husbandman 603983 603983 Roo, James, of Little Walsyngham, husbandman 5
5012045 2360371 2360371 defendant Gannok John yeoman 604697 604697 Gannok, John, of Castle Acre, yeoman 6
5012046 2360371 2360371 defendant Bray James chapman 755389 755389 Bray, James, of Bishop's Lenn, chapman 7
5012047 2360371 2360371 defendant Kenell John yeoman 587201 587201 Kenell, John, of Sharyngton, yeoman 8
5012048 2360371 2360371 defendant Ailsham Thomas   640425 640425 Ailsham, Thomas, of Holkeham, brass worker 9
5012049 2360371 2360371 defendant Thornkyn Edmund yeoman 834919 834919 Thornkyn, Edmund, of Beston by Leccham, yeoman 10
5012050 2360371 2360371 defendant Edy Robert butcher 586938 586938 Edy, Robert, of Thornham, butcher 11
5012051 2360371 2360371 defendant Pyper Henry   723240 723240 Pyper, Henry, of Taterford, pipe maker 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);