names

12 rows where case_id = 2364604

✎ 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
5026378 2364604 2364604 plaintiff Laweson William     Laweson, William 0
5026379 2364604 2364604 defendant Pykden John yeoman 623077 623077 Pykden, John, of Bokenfeld, yeoman 0
5026380 2364604 2364604 defendant Pykden John yeoman 778742 778742 Pykden, John, of Rothebury, yeoman 1
5026381 2364604 2364604 defendant Treghen Thomas yeoman 778742 778742 Treghen, Thomas, of Rothebury, yeoman 2
5026382 2364604 2364604 defendant Bagot Hugh yeoman 595857 595857 Bagot, Hugh, of Alnewyk, yeoman 3
5026383 2364604 2364604 defendant Clugh John yeoman 836748 836748 Clugh, John, of Hartwaton, yeoman 4
5026384 2364604 2364604 defendant Browell Richard yeoman 828873 828873 Browell, Richard, of Esshet, yeoman 5
5026385 2364604 2364604 defendant Fresell Roland yeoman 778742 778742 Fresell, Roland, of Rothebury, yeoman 6
5026386 2364604 2364604 defendant Hog Thomas yeoman 588641 588641 Hog, Thomas, of Denton, yeoman 7
5026387 2364604 2364604 defendant Hyne or Hyve Richard yeoman 691597 691597 Hyne or Hyve, Richard, of Hexham, yeoman 8
5026388 2364604 2364604 defendant Kneshawe William yeoman 836749 836749 Kneshawe, William, of Heslesyde, yeoman 9
5026389 2364604 2364604 defendant Elyson William husbandman 594908 594908 Elyson, William, of Ovyngton, husbandman 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);