names

13 rows where case_id = 2381131

✎ 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
5082065 2381131 2381131 plaintiff de Scales Thomas Lord Scales, knight   de Scales, Thomas, Lord Scales, knight 0
5082066 2381131 2381131 defendant Chappes Richard esq 602914 602914 Chappes, Richard, of Frekenham, esq 0
5082067 2381131 2381131 defendant Hethe George oif Mildenhale, gent   Hethe, George, oif Mildenhale, gent 1
5082068 2381131 2381131 defendant Swyft William   844223 844223 together with Swyft, William, of Wyrdelyngton, shepherd 2
5082069 2381131 2381131 defendant Coftyn or Costyn John   602914 602914 Coftyn or Costyn, John, of Frekenham, shepherd 3
5082070 2381131 2381131 defendant Eton William tailor 602914 602914 Eton, William, of Frekenham, tailor 4
5082071 2381131 2381131 defendant Paye Robert roper 602914 602914 Paye, Robert, of Frekenham, roper 5
5082072 2381131 2381131 defendant Fyson Simon weaver 602914 602914 Fyson, Simon, of Frekenham, weaver 6
5082073 2381131 2381131 defendant Baker John laborer 602914 602914 Baker, John, of Frekenham, laborer 7
5082074 2381131 2381131 defendant Scocher George laborer 602914 602914 Scocher, George, of Frekenham, laborer 8
5082075 2381131 2381131 defendant Hancok Thomas yeoman 602914 602914 Hancok, Thomas, of Frekenham, yeoman 9
5082076 2381131 2381131 defendant Reve Reginald laborer 602914 602914 Reve, Reginald, of Frekenham, laborer 10
5082077 2381131 2381131 defendant Scot Edmund laborer 602914 602914 Scot, Edmund, of Frekenham, laborer 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);