names

14 rows where case_id = 2519969

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5549775 2519969 2519969 plaintiff Brent Agnes widow   Brent, Agnes, widow 0
5549776 2519969 2519969 defendant Barkesdale Thomas clothier 592467 592467 Barkesdale, Thomas, of Kevyll, clothier 0
5549777 2519969 2519969 defendant Smert Edmund tanner 586509 586509 Smert, Edmund, of Neubery, Berks, tanner 1
5549778 2519969 2519969 defendant Stephyns Lawrence weaver 592467 592467 Stephyns, Lawrence, of Kevyll, weaver 2
5549779 2519969 2519969 defendant Shreff John weaver 592467 592467 Shreff, John, of Kevyll, weaver 3
5549780 2519969 2519969 defendant Alwey John laborer 898978 898978 Alwey, John, of Kevyn, laborer 4
5549781 2519969 2519969 defendant Yalde William weaver 592467 592467 Yalde, William, of Kevyll, weaver 5
5549782 2519969 2519969 defendant Blays Humphrey weaver 592467 592467 Blays, Humphrey, of Kevyll, weaver 6
5549783 2519969 2519969 defendant Smyth Thomas weaver 592467 592467 Smyth, Thomas, of Kevyll, weaver 7
5549784 2519969 2519969 defendant Kevylles John husbandman 592467 592467 Kevylles, John, of Kevyll, husbandman 8
5549785 2519969 2519969 defendant Forest John weaver 592467 592467 Forest, John, of Kevyll, weaver 9
5549786 2519969 2519969 defendant Burton John weaver 592467 592467 Burton, John, of Kevyll, weaver 10
5549787 2519969 2519969 defendant Atwode Andrew weaver 592467 592467 Atwode, Andrew, of Kevyll, weaver 11
5549788 2519969 2519969 defendant Clerk Richard husbandman 592467 592467 Clerk, Richard, of Kevyll, 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);