names

11 rows where case_id = 1912341

✎ 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
3656677 1912341 1912341 plaintiff Clerke William clerk   Clerke, William, clerk, executors of 0
3656678 1912341 1912341 plaintiff Clerk John     (Clerk, John 1
3656679 1912341 1912341 plaintiff Shawell Thomas     Shawell, Thomas 2
3656680 1912341 1912341 defendant Long Richard fuller of cloth 588611 588611 Long, Richard, of Strode water, fuller of cloth 0
3656681 1912341 1912341 defendant Long John fuller of cloth 604054 604054 Long, John, of Mynchynghampton, fuller of cloth 1
3656682 1912341 1912341 defendant Bronyng Robert husbandman 604055 604055 Bronyng, Robert, of Abenyng, husbandman 2
3656683 1912341 1912341 defendant Chamber Robert of Mynchynghampton weaver   Chamber, Robert of Mynchynghampton, weaver 3
3656684 1912341 1912341 defendant Toly Giles husbandman 604049 604049 Toly, Giles, of Uley, husbandman 4
3656685 1912341 1912341 defendant Clerk John glover 588466 588466 Clerk, John, of Cleve, glover 5
3656686 1912341 1912341 defendant Petyt John laborer 588432 588432 Petyt, John, of Strodwater, laborer 6
3656687 1912341 1912341 defendant Hynde Philip carrier 604054 604054 Hynde, Philip, of Mynchynghampton, carrier 7

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