names

13 rows where case_id = 2294959

✎ 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
4796186 2294959 2294959 plaintiff Salle Robert     Salle, Robert 0
4796187 2294959 2294959 defendant Martyn Thomas saddler 762298 762298 Martyn, Thomas, of Chilmelegh, saddler 0
4796188 2294959 2294959 defendant Forde John tailor 606557 606557 Forde, John, of Wynkelegh Keynes, tailor 1
4796189 2294959 2294959 defendant Raddok John laborer 592268 592268 Raddok, John, of Brodewodekelly, laborer 2
4796190 2294959 2294959 defendant Bobyssh John husbandman 592268 592268 Bobyssh, John, of Brodewodekelly, husbandman 3
4796191 2294959 2294959 defendant Bobyssh John weaver 592268 592268 Bobyssh, John, of Brodewodekelly, weaver 4
4796192 2294959 2294959 defendant Benet John husbandman 803435 803435 Benet, John, of Ingwardlegh, husbandman 5
4796193 2294959 2294959 defendant Bury John laborer 592010 592010 Bury, John, of Hatherlegh, laborer 6
4796194 2294959 2294959 defendant Fynyan Henry laborer 803436 803436 Fynyan, Henry, of Yedeslegh, laborer 7
4796195 2294959 2294959 defendant Best John husbandman 592010 592010 Best, John, of Hatherlegh, husbandman 8
4796196 2294959 2294959 defendant Sandre William husbandman 803437 803437 Sandre, William, of Ikesburn, husbandman 9
4796197 2294959 2294959 defendant Webber John smith 586378 586378 Webber, John, of Tavestoke, smith 10
4796198 2294959 2294959 defendant Craston John husbandman 803438 803438 Craston, John, of Petrestavy, husbandman 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);