names

18 rows where case_id = 1936917

✎ 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
3734097 1936917 1936917 plaintiff Fox John     Fox, John 0
3734098 1936917 1936917 defendant Cole John gent 587161 587161 Cole, John, of Cornewode, gent 0
3734099 1936917 1936917 defendant Brend Nicholas   587161 587161 Brend, Nicholas, of Cornewode, groom 1
3734100 1936917 1936917 defendant Ley Thomas husbandman 587161 587161 Ley, Thomas, of Cornewode, husbandman 2
3734101 1936917 1936917 defendant Kenycote William carpenter 587161 587161 Kenycote, William, of Cornewode, carpenter 3
3734102 1936917 1936917 defendant Kerswyll John husbandman 587161 587161 Kerswyll, John, of Cornewode, husbandman 4
3734103 1936917 1936917 defendant Hullond Thomas miller 587161 587161 Hullond, Thomas, of Cornewode, miller 5
3734104 1936917 1936917 defendant Jefferey Robert chapman 587161 587161 Jefferey, Robert, of Cornewode, chapman 6
3734105 1936917 1936917 defendant Iryshe John   587161 587161 Iryshe, John, of Cornewode, groom 7
3734106 1936917 1936917 defendant Hollond thomas, junior   587161 587161 Hollond, thomas, junior, of Cornewode, groom 8
3734107 1936917 1936917 defendant Cumppe Edward laborer 587161 587161 Cumppe, Edward, of Cornewode, laborer 9
3734108 1936917 1936917 defendant Hoper William laborer 587161 587161 Hoper, William, of Cornewode, laborer 10
3734109 1936917 1936917 defendant Hoper Walter   587161 587161 Hoper, Walter, of Cornewode, groom 11
3734110 1936917 1936917 defendant Flessheman John husbandman 587161 587161 Flessheman, John, of Cornewode, husbandman 12
3734111 1936917 1936917 defendant Jefferey Thomas laborer 600979 600979 Jefferey, Thomas, of Plympton St Mary, laborer 13
3734112 1936917 1936917 defendant Stert Reginald husbandman 587161 587161 Stert, Reginald, of Cornewode, husbandman 14
3734113 1936917 1936917 defendant Wyght Thomas laborer 586834 586834 Wyght, Thomas, of Plymmouth, laborer 15
3734114 1936917 1936917 defendant Smale Richard husbandman 586459 586459 Smale, Richard, of Stoke, husbandman 16

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