names

15 rows where case_id = 1951350

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3779592 1951350 1951350 plaintiff Fakys Thomas     Fakys, Thomas 0
3779593 1951350 1951350 defendant Croftys John gent 601642 601642 Croftys, John, of Westowe, gent 0
3779594 1951350 1951350 defendant Grene John   601642 601642 Grene, John, of Westowe, shepherd 1
3779595 1951350 1951350 defendant Trewes John thatcher 601642 601642 Trewes, John, of Westowe, thatcher 2
3779596 1951350 1951350 defendant Bosshop John   601642 601642 Bosshop, John, of Westowe, shepherd 3
3779597 1951350 1951350 defendant Crowe Edmund   601642 601642 Crowe, Edmund, of Westowe, shepherd 4
3779598 1951350 1951350 defendant Bache Thomas carver 601642 601642 Bache, Thomas, of Westowe, carver 5
3779599 1951350 1951350 defendant Calowe Richard fuller 601642 601642 Calowe, Richard, of Westowe, fuller 6
3779600 1951350 1951350 defendant Burdews John husbandman 601642 601642 Burdews, John, of Westowe, husbandman 7
3779601 1951350 1951350 defendant Layman John carpenter 601642 601642 Layman, John, of Westowe, carpenter 8
3779602 1951350 1951350 defendant Bache John, junior miller 601642 601642 Bache, John, junior, of Westowe, miller 9
3779603 1951350 1951350 defendant Parkyn alias Wolman Edmund fuller 601642 601642 Parkyn alias Wolman, Edmund, of Westowe, fuller 10
3779604 1951350 1951350 defendant Salter John tailor 601642 601642 Salter, John, of Westowe, tailor 11
3779605 1951350 1951350 defendant Frogge Thomas laborer 601642 601642 Frogge, Thomas, of Westowe, laborer 12
3779606 1951350 1951350 defendant Yngham Thomas husbandman 601642 601642 Yngham, Thomas, of Westowe, 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);