names

14 rows where case_id = 2473675

✎ 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
5395128 2473675 2473675 plaintiff -uller (illegible)     -uller, --- 0
5395129 2473675 2473675 defendant Wyrmegey Robert yeoman 881817 881817 Wyrmegey, Robert, of Wittelyngham, yeoman 0
5395130 2473675 2473675 defendant Mome Henry husbandman 593308 593308 Mome, Henry, of Redeham, husbandman 1
5395131 2473675 2473675 defendant Clitherowe Ralph husbandman 831206 831206 Clitherowe, Ralph, of Little Plumsted, husbandman 2
5395132 2473675 2473675 defendant Bacton John gent 604744 604744 Bacton, John, of Bacton, gent 3
5395133 2473675 2473675 defendant Pycher Robert yeoman 592427 592427 Pycher, Robert, of Kerbrook, yeoman 4
5395134 2473675 2473675 defendant Thrower William husbandman 587172 587172 Thrower, William, of East Derham, husbandman 5
5395135 2473675 2473675 defendant Smyth Robert husbandman 596676 596676 Smyth, Robert, of Halvergate, husbandman 6
5395136 2473675 2473675 defendant Goeryche Richard husbandman 674657 674657 Goeryche, Richard, of Strumpshawe, husbandman 7
5395137 2473675 2473675 defendant Nunne John merchant 585933 585933 Nunne, John, of Great Yarmouth, merchant 8
5395138 2473675 2473675 defendant Burnham Henry tailor 599856 599856 Burnham, Henry, of Beccles, Suff, tailor 9
5395139 2473675 2473675 defendant Skepper William yeoman 587414 587414 Skepper, William, of Thetford, yeoman 10
5395140 2473675 2473675 defendant Preest John turner 585936 585936 Preest, John, of Norwich, turner 11
5395141 2473675 2473675 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);