names

14 rows where case_id = 2475600

✎ 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
5401864 2475600 2475600 plaintiff Holer John     Holer, John 0
5401865 2475600 2475600 defendant Wirmegey Robert yeoman 881817 881817 Wirmegey, Robert, of Wittelyngham, yeoman 0
5401866 2475600 2475600 defendant Mome Henry husbandman 593308 593308 Mome, Henry, of Redeham, husbandman 1
5401867 2475600 2475600 defendant Clitherowe Ralph husbandman 831206 831206 Clitherowe, Ralph, of Little Plumsted, husbandman 2
5401868 2475600 2475600 defendant Bacton John gent 604744 604744 Bacton, John, of Bacton, gent 3
5401869 2475600 2475600 defendant Pycher Robert yeoman 592427 592427 Pycher, Robert, of Kerbrook, yeoman 4
5401870 2475600 2475600 defendant Thrower William husbandman 587172 587172 Thrower, William, of East Derham, husbandman 5
5401871 2475600 2475600 defendant Smyth Robert husbandman 596676 596676 Smyth, Robert, of Halvergate, husbandman 6
5401872 2475600 2475600 defendant Goderyche Richard husbandman 674657 674657 Goderyche, Richard, of Strumpshawe, husbandman 7
5401873 2475600 2475600 defendant Nunne John merchant 585933 585933 Nunne, John, of Great Yarmouth, merchant 8
5401874 2475600 2475600 defendant Burnham Henry tailor 599856 599856 Burnham, Henry, of Beccles, Suff, tailor 9
5401875 2475600 2475600 defendant Skepper William yeoman 587414 587414 Skepper, William, of Thetford, yeoman 10
5401876 2475600 2475600 defendant Preest John turner 585936 585936 Preest, John, of Norwich, turner 11
5401877 2475600 2475600 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);