names

13 rows where case_id = 2302409

✎ 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
4820266 2302409 2302409 plaintiff Pykeryng Richard knight   Pykeryng, Richard, knight 0
4820267 2302409 2302409 defendant Hastynges John gent 805260 805260 Hastynges, John, of Hilderskelfe, gent 0
4820268 2302409 2302409 defendant Hastynges Edmund gent 805260 805260 Hastynges, Edmund, of Hilderskelfe, gent 1
4820269 2302409 2302409 defendant Wellys John de gent 805260 805260 Wellys, John de, of Hilderskelfe, gent 2
4820270 2302409 2302409 defendant Buk James yeoman 805260 805260 Buk, James, of Hilderskelfe, yeoman 3
4820271 2302409 2302409 defendant Garde Richard yeoman 805261 805261 Garde, Richard, of Womylton, yeoman 4
4820272 2302409 2302409 defendant Bakere William yeoman 805262 805262 Bakere, William, of Hillderskelfe, yeoman 5
4820273 2302409 2302409 defendant Potter William yeoman 807427 807427 Potter, William, of Helderskelfe, yeoman 6
4820274 2302409 2302409 defendant Potter Robert yeoman 805260 805260 Potter, Robert, of Hilderskelfe, yeoman 7
4820275 2302409 2302409 defendant Suthwyk William yeoman 805260 805260 Suthwyk, William, of Hilderskelfe, yeoman 8
4820276 2302409 2302409 defendant de Dyghton of Grymthorp yeoman   de Dyghton, of Grymthorp, yeoman 9
4820277 2302409 2302409 defendant Fauwedyr William butcher 600457 600457 Fauwedyr, William, of Malton, butcher 10
4820278 2302409 2302409 defendant Trope John yeoman 600457 600457 Trope, John, of Malton, yeoman 11

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