names

14 rows where case_id = 2455249

✎ 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
5334019 2455249 2455249 plaintiff Dynham Joan widow of Dynham, John, knight   Dynham, Joan, widow of Dynham, John, knight 0
5334020 2455249 2455249 defendant Milward William husbandman 593020 593020 Milward, William, of Ipelpen, husbandman 0
5334021 2455249 2455249 defendant Croppe John husbandman 593020 593020 Croppe, John, of Ipelpen, husbandman 1
5334022 2455249 2455249 defendant atte Wylle John   622235 622235 atte Wylle, John, of Eggenyswyll, "helyer" 2
5334023 2455249 2455249 defendant Cole Robert husbandman 593020 593020 Cole, Robert, of Ipelpen, husbandman 3
5334024 2455249 2455249 defendant Drewe William husbandman 593020 593020 Drewe, William, of Ipelpen, husbandman 4
5334025 2455249 2455249 defendant Bartour Peter husbandman 593020 593020 Bartour, Peter, of Ipelpen, husbandman 5
5334026 2455249 2455249 defendant atte Wylle Robert husbandman 593020 593020 atte Wylle, Robert, of Ipelpen, husbandman 6
5334027 2455249 2455249 defendant Taillour Thomas husbandman 781922 781922 Taillour, Thomas, of Kynges Carswyll, husbandman 7
5334028 2455249 2455249 defendant Bykeford Henry husbandman 781922 781922 Bykeford, Henry, of Kynges Carswyll, husbandman 8
5334029 2455249 2455249 defendant Grey Alfred husbandman 781922 781922 Grey, Alfred, of Kynges Carswyll, husbandman 9
5334030 2455249 2455249 defendant Sampson John husbandman 781922 781922 Sampson, John, of Kynges Carswyll, husbandman 10
5334031 2455249 2455249 defendant Revell or Renell Stephen husbandman 781922 781922 Revell or Renell, Stephen, of Kynges Carswyll, husbandman 11
5334032 2455249 2455249 defendant Martyn William husbandman 781922 781922 Martyn, William, of Kynges Carswyll, 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);