names

12 rows where case_id = 2271709

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4720373 2271709 2271709 plaintiff Brook Joan formerly wife of Thomas Brook, knight   Brook, Joan, formerly wife of Thomas Brook, knight 0
4720374 2271709 2271709 defendant Tort Hugh gent 624220 624220 Tort, Hugh, of Crukern, gent 0
4720375 2271709 2271709 defendant Denebaud William gent 632410 632410 Denebaud, William, of Thorny, gent 1
4720376 2271709 2271709 defendant Popham John laborer 624220 624220 Popham, John, of Crukern, laborer 2
4720377 2271709 2271709 defendant Boche Nicholas butcher 624220 624220 Boche, Nicholas, of Crukern, butcher 3
4720378 2271709 2271709 defendant Palmer John butcher 624220 624220 Palmer, John, of Crukern, butcher 4
4720379 2271709 2271709 defendant Keylewey John   624220 624220 Keylewey, John, of Crukern, shoe maker 5
4720380 2271709 2271709 defendant Sencler William yeoman 610825 610825 Sencler, William, of Mysterton, yeoman 6
4720381 2271709 2271709 defendant Barry John tailor 624220 624220 Barry, John, of Crukern, tailor 7
4720382 2271709 2271709 defendant Spore John yeoman 624220 624220 Spore, John, of Crukern, yeoman 8
4720383 2271709 2271709 defendant Rugge Wiliam glover 624220 624220 Rugge, Wiliam, of Crukern, glover 9
4720384 2271709 2271709 defendant Roper Simon   624220 624220 Roper, Simon, of Crukern, rope maker 10

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);