names

14 rows where case_id = 2460472

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5351204 2460472 2460472 plaintiff Damme Simon     Damme, Simon 0
5351205 2460472 2460472 defendant Benet Nicholas clerk 758818 758818 Benet, Nicholas, of Leryngsete, clerk 0
5351206 2460472 2460472 defendant Brouster Richard yeoman 642130 642130 Brouster, Richard, of Mutford, Suff, yeoman 1
5351207 2460472 2460472 defendant Couper Richard yeoman 585869 585869 Couper, Richard, of London, yeoman 2
5351208 2460472 2460472 defendant Estgate Roger yeoman 589000 589000 Estgate, Roger, of Bradfeld, yeoman 3
5351209 2460472 2460472 defendant Brook Roger gent 585869 585869 Brook, Roger, of London, gent 4
5351210 2460472 2460472 defendant Lynstede Robert husbandman 605374 605374 Lynstede, Robert, of Brynton, husbandman 5
5351211 2460472 2460472 defendant Lyng Robert mercer 603966 603966 Lyng, Robert, of Pokethorp, mercer 6
5351212 2460472 2460472 defendant Byrlyngham Robert husbandman 599088 599088 Byrlyngham, Robert, of Thornage, husbandman 7
5351213 2460472 2460472 defendant Lynstede Robert butcher 586420 586420 Lynstede, Robert, of Est Ruston, butcher 8
5351214 2460472 2460472 defendant Langdon Thomas yeoman 836481 836481 Langdon, Thomas, of Hempsted juxta Holt, yeoman 9
5351215 2460472 2460472 defendant Whocclerk Thomas smith 596932 596932 Whocclerk, Thomas, of Magna Walsyngham, smith 10
5351216 2460472 2460472 defendant Weston William clerk 595097 595097 Weston, William, of Holt Market, clerk 11
5351217 2460472 2460472 defendant Baret William gent 586180 586180 Baret, William, of Bury St Edmunds, gent 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);