names

14 rows where case_id = 2471950

✎ 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
5389153 2471950 2471950 plaintiff Hole John     Hole, John, on his own account 0
5389154 2471950 2471950 defendant Wirmegey Robert yeoman 881817 881817 Wirmegey, Robert, of Wittelyngham, yeoman 0
5389155 2471950 2471950 defendant Mome Henry husbandman 593308 593308 Mome, Henry, of Redeham, husbandman 1
5389156 2471950 2471950 defendant Clytherewe Ralph husbandman 587076 587076 Clytherewe, Ralph, of Plumsted, husbandman 2
5389157 2471950 2471950 defendant Bacton John gent 604744 604744 Bacton, John, of Bacton, gent 3
5389158 2471950 2471950 defendant Pycher Robert yeoman 592427 592427 Pycher, Robert, of Kerbrook, yeoman 4
5389159 2471950 2471950 defendant Thrower William husbandman 587172 587172 Thrower, William, of Est Derham, husbandman 5
5389160 2471950 2471950 defendant Smyth Robert husbandman 596676 596676 Smyth, Robert, of Halvergate, husbandman 6
5389161 2471950 2471950 defendant Goderyche Richard husbandman 881818 881818 Goderyche, Richard, of Strumpshed, husbandman 7
5389162 2471950 2471950 defendant Nunme John merchant 585933 585933 Nunme, John, of Great Yarmouth, merchant 8
5389163 2471950 2471950 defendant Burnham Henry tailor 588021 588021 Burnham, Henry, of Becclys, Suff, tailor 9
5389164 2471950 2471950 defendant Skepper William yeoman 587414 587414 Skepper, William, of Thetford, yeoman 10
5389165 2471950 2471950 defendant Preest John turner 585936 585936 Preest, John, of Norwich, turner 11
5389166 2471950 2471950 defendant Maynard Robert yeoman 590405 590405 Maynard, Robert, of Martham, yeoman 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);