names

15 rows where case_id = 1873250

✎ 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
3617989 1873250 1873250 plaintiff Godwyn Robert husbandman 587314 587314 Godwyn, Robert, of Sethyng, husbandman 0
3617990 1873250 1873250 plaintiff Sponer John, senior husbandman   Sponer, John, senior, husbandman 1
3617991 1873250 1873250 plaintiff Broke Roger husbandman   Broke, Roger, husbandman 2
3617992 1873250 1873250 plaintiff Sponer John son of Sponer, Richard, husbandman   Sponer, John, son of Sponer, Richard, husbandman 3
3617993 1873250 1873250 plaintiff Sponer William husbandman   Sponer, William, husbandman 4
3617994 1873250 1873250 plaintiff Calf John husbandman   Calf, John, husbandman 5
3617995 1873250 1873250 plaintiff Colman John husbandman   Colman, John, husbandman 6
3617996 1873250 1873250 plaintiff Wodery Richard husbandman   Wodery, Richard, husbandman 7
3617997 1873250 1873250 plaintiff Stanford John husbandman   Stanford, John, husbandman 8
3617998 1873250 1873250 plaintiff Wrot John husbandman   Wrot, John, husbandman 9
3617999 1873250 1873250 plaintiff Skernyng John husbandman   Skernyng, John, husbandman 10
3618000 1873250 1873250 plaintiff Frenche William husbandman 587314 587314 Frenche, William, of Sethyng, husbandman 11
3618001 1873250 1873250 defendant Havell or Hanell William mercer 587456 587456 Havell or Hanell, William, of Nedham Market, Suff, mercer 0
3618002 1873250 1873250 defendant Burton William carver 586405 586405 Burton, William, of Nedham Market, carver 1
3618003 1873250 1873250 defendant Bett William carpenter 586534 586534 Bett, William, of Helmyngham, Suff, carpenter 2

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