names

15 rows where case_id = 2248065

✎ 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
4656940 2248065 2248065 plaintiff Chichele Henry Archbishop of Canterbury   Chichele, Henry, Archbishop of Canterbury 0
4656941 2248065 2248065 defendant atte Bergh John farmer 599360 599360 atte Bergh, John, of Newynton juxta Hethe, farmer 0
4656942 2248065 2248065 defendant (not given) Thomas his son, laborer   Thomas his son, of Newynton juxta Hethe, laborer 1
4656943 2248065 2248065 defendant Meller John husbandman 612917 612917 Meller, John, of Hethe, husbandman 2
4656944 2248065 2248065 defendant Meller Robert husbandman 612917 612917 Meller, Robert, of Hethe, husbandman 3
4656945 2248065 2248065 defendant (not given) Thomas son of John Dyn, gent   Thomas son of John Dyn, of Hethe, gent 4
4656946 2248065 2248065 defendant (not given) Thomas son of John Waryn, husbandman   Thomas son of John Waryn, of Hethe, husbandman 5
4656947 2248065 2248065 defendant atte Wode John spicer 612917 612917 atte Wode, John, of Hethe, spicer 6
4656948 2248065 2248065 defendant Yve Thomas shoemaker 612917 612917 Yve, Thomas, of Hethe, shoemaker 7
4656949 2248065 2248065 defendant atte Vyne Thomas tailor 612917 612917 atte Vyne, Thomas, of Hethe, tailor 8
4656950 2248065 2248065 defendant Shobery John weaver 612917 612917 Shobery, John, of Hethe, weaver 9
4656951 2248065 2248065 defendant Potman Lawrence spicer 612917 612917 Potman, Lawrence, of Hethe, spicer 10
4656952 2248065 2248065 defendant Tomyston William   624795 624795 Tomyston, William, of Saltewode, "parkerman" 11
4656953 2248065 2248065 defendant Pecchyng William baker 611875 611875 Pecchyng, William, of Saltwode, baker 12
4656954 2248065 2248065 defendant (not given) John son of William bergreve, husbandman   John son of William bergreve, of Hethe, husbandman 13

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