names

11 rows where case_id = 2256642

✎ 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
4671155 2256642 2256642 plaintiff Camberton Christopher     Camberton, Christopher 0
4671156 2256642 2256642 defendant Brisby Simon de yeoman 781090 781090 Brisby, Simon de, of Brounrige, yeoman 0
4671157 2256642 2256642 defendant Shepherd Robert husbandman 781091 781091 Shepherd, Robert, of Heslehed, husbandman 1
4671158 2256642 2256642 defendant Bregore Henry yeoman 586549 586549 Bregore, Henry, of Hoton, yeoman 2
4671159 2256642 2256642 defendant Jenyn Robert milner 781092 781092 Jenyn, Robert, of Lathe, milner 3
4671160 2256642 2256642 defendant Todde Robert yeoman 774045 774045 Todde, Robert, of Newebiggyng, yeoman 4
4671161 2256642 2256642 defendant Wraa John de husbandman 780591 780591 Wraa, John de, of Newebiggyn, husbandman 5
4671162 2256642 2256642 defendant Knotte William de husbandman 780591 780591 Knotte, William de, of Newebiggyn, husbandman 6
4671163 2256642 2256642 defendant Haskhed William de husbandman 774045 774045 Haskhed, William de, of Newebiggyng, husbandman 7
4671164 2256642 2256642 defendant Burton John de of Penreth shepherd   Burton, John de of Penreth, shepherd 8
4671165 2256642 2256642 defendant Bergiet Robert   593911 593911 Bergiet, Robert, of Penreth, shepherd 9

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