names

14 rows where case_id = 2246488

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4651554 2246488 2246488 plaintiff Arundell John knight   Arundell, John, knight 0
4651555 2246488 2246488 defendant Montesdon Richard   778033 778033 Montesdon, Richard, of Tetborn, bailiff 0
4651556 2246488 2246488 defendant Hethman Henry   600119 600119 Hethman, Henry, of Ken, bailiff 1
4651557 2246488 2246488 defendant Gille Richard   778035 778035 Gille, Richard, of Hurbornford, bailiff 2
4651558 2246488 2246488 defendant Corn- Robert   587162 587162 Corn-, Robert, of Ermyngton bailiff 3
4651559 2246488 2246488 defendant Bugge Richard   597531 597531 Bugge, Richard, of Horebrigge, bailiff 4
4651560 2246488 2246488 defendant Godyer William   586378 586378 Godyer, William, of Tavestoke, bailiff 5
4651561 2246488 2246488 defendant Mostard William, junior   612035 612035 Mostard, William, junior, of Lyfton, bailiff 6
4651562 2246488 2246488 defendant Jon Richard, junior   593027 593027 Jon, Richard, junior, of Thornbury, bailiff 7
4651563 2246488 2246488 defendant Giffard Balrwin   586459 586459 Giffard, Balrwin, of Stoke, bailiff 8
4651564 2246488 2246488 defendant Couke Richard   778042 778042 Couke, Richard, of Yeylston or Yeylstou, bailiff 9
4651565 2246488 2246488 defendant Drayton Geoffrey   587214 587214 Drayton, Geoffrey, of Cruys Morchard, bailiff 10
4651566 2246488 2246488 defendant Archebold Robert   593082 593082 Archebold, Robert, of Wynkelegh, bailiff 11
4651567 2246488 2246488 defendant Spynkhull Nicholas   591028 591028 Spynkhull, Nicholas, of Crediton, bailiff 12

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