names

10 rows where case_id = 1867437

✎ 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
3599334 1867437 1867437 plaintiff Trase Robert, junior     Trase, Robert, junior 0
3599335 1867437 1867437 defendant Wyke Alice widow 587380 587380 Wyke, Alice, of Sourton, widow 0
3599336 1867437 1867437 defendant Carre Robert husbandman 587380 587380 Carre, Robert, of Sourton, husbandman 1
3599337 1867437 1867437 defendant Raddon John, junior   587380 587380 Raddon, John, junior, of Sourton, groom 2
3599338 1867437 1867437 defendant Horwell Thomas laborer 587380 587380 Horwell, Thomas, of Sourton, laborer 3
3599339 1867437 1867437 defendant Hudman William laborer 587380 587380 Hudman, William, of Sourton, laborer 4
3599340 1867437 1867437 defendant Combe Henry laborer 587380 587380 Combe, Henry, of Sourton, laborer 5
3599341 1867437 1867437 defendant Abourne John husbandman 589946 589946 Abourne, John, of Bredstowe, husbandman 6
3599342 1867437 1867437 defendant Walter Richard husbandman 589946 589946 Walter, Richard, of Bredstowe, husbandman 7
3599343 1867437 1867437 defendant Stondon John husbandman 587380 587380 Stondon, John, of Sourton, husbandman 8

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