names

14 rows where case_id = 2278046

✎ 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
4741625 2278046 2278046 plaintiff Bowet Anne formerly wife of William Bowet, knight   Bowet, Anne, formerly wife of William Bowet, knight 0
4741626 2278046 2278046 defendant Warde Richard yeoman 754344 754344 Warde, Richard, of Costeseye, yeoman 0
4741627 2278046 2278046 defendant Wode John husbandman 754344 754344 Wode, John, of Costeseye, husbandman 1
4741628 2278046 2278046 defendant Wode Martin husbandman 754344 754344 Wode, Martin, of Costeseye, husbandman 2
4741629 2278046 2278046 defendant Gunton Roger husbandman 754344 754344 Gunton, Roger, of Costeseye, husbandman 3
4741630 2278046 2278046 defendant Blakemanhagh John husbandman 754344 754344 Blakemanhagh, John, of Costeseye, husbandman 4
4741631 2278046 2278046 defendant Coche John husbandman 754344 754344 Coche, John, of Costeseye, husbandman 5
4741632 2278046 2278046 defendant Neugate Clement husbandman 754344 754344 Neugate, Clement, of Costeseye, husbandman 6
4741633 2278046 2278046 defendant Poune or Pomme William husbandman 754344 754344 Poune or Pomme, William, of Costeseye, husbandman 7
4741634 2278046 2278046 defendant Elbold Thomas husbandman 754344 754344 Elbold, Thomas, of Costeseye, husbandman 8
4741635 2278046 2278046 defendant Dyrre John husbandman 754344 754344 Dyrre, John, of Costeseye, husbandman 9
4741636 2278046 2278046 defendant Wysse William husbandman 754344 754344 Wysse, William, of Costeseye, husbandman 10
4741637 2278046 2278046 defendant Mous or Mons Geoffrey   589537 589537 Mous or Mons, Geoffrey, of Banburgh, corsour 11
4741638 2278046 2278046 defendant atte Cherche Thomas husbandman 594671 594671 atte Cherche, Thomas, of Felthorp, husbandman 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);