names

15 rows where case_id = 2298703

✎ 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
4808069 2298703 2298703 plaintiff Cote Robert   782254 782254 Cote, Robert, of Neweton Graunge 0
4808070 2298703 2298703 defendant Hastynges John gent 805260 805260 Hastynges, John, of Hilderskelfe, gent 0
4808071 2298703 2298703 defendant Hastynges Edmund gent 805260 805260 Hastynges, Edmund, of Hilderskelfe, gent 1
4808072 2298703 2298703 defendant Welles John gent 805260 805260 Welles, John, of Hilderskelfe, gent 2
4808073 2298703 2298703 defendant Buk James yeoman 805260 805260 Buk, James, of Hilderskelfe, yeoman 3
4808074 2298703 2298703 defendant Suthwyk John yeoman 805260 805260 Suthwyk, John, of HIlderskelfe, yeoman 4
4808075 2298703 2298703 defendant Hale William de yeoman 805260 805260 Hale, William de, of HIlderskelfe, yeoman 5
4808076 2298703 2298703 defendant Garde Richard yeoman 805261 805261 Garde, Richard, of Womylton, yeoman 6
4808077 2298703 2298703 defendant Bakere William shoemaker 805262 805262 Bakere, William, of Hillderskelfe, shoemaker 7
4808078 2298703 2298703 defendant Potter William yeoman 805263 805263 Potter, William, of HIlderkelfe, yeoman 8
4808079 2298703 2298703 defendant Suthywyk William yeoman 805260 805260 Suthywyk, William, of HIlderskelfe, yeoman 9
4808080 2298703 2298703 defendant Dyghton John de yeoman 776411 776411 Dyghton, John de, of Grymthorp, yeoman 10
4808081 2298703 2298703 defendant Fanwedyr William   600457 600457 Fanwedyr, William, of Malton 11
4808082 2298703 2298703 defendant Trope John yeoman 600457 600457 Trope, John, of Malton, yeoman 12
4808083 2298703 2298703 defendant Nesse Thomas de yeoman 805264 805264 Nesse, Thomas de, of Maras, yeoman 13

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