names

13 rows where case_id = 2377808

✎ 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
5070962 2377808 2377808 plaintiff Skypwych or Skypwyth William knight   Skypwych or Skypwyth, William, knight 0
5070963 2377808 2377808 defendant Thomson Walrter husbandman 588375 588375 Thomson, Walrter, of Garnethorp, husbandman 0
5070964 2377808 2377808 defendant Hubbylday John husbandman 588375 588375 Hubbylday, John, of Garnethorp, husbandman 1
5070965 2377808 2377808 defendant Kyrthorp Robert husbandman 588375 588375 Kyrthorp, Robert, of Garnethorp, husbandman 2
5070966 2377808 2377808 defendant Neuman William husbandman 588375 588375 Neuman, William, of Garnethorp, husbandman 3
5070967 2377808 2377808 defendant Gilbertson John husbandman 588375 588375 Gilbertson, John, of Garnethorp, husbandman 4
5070968 2377808 2377808 defendant Ulsby Thomas husbandman 842869 842869 Ulsby, Thomas, of Wargholm, husbandman 5
5070969 2377808 2377808 defendant Rumbald Robert husbandman 842869 842869 Rumbald, Robert, of Wargholm, husbandman 6
5070970 2377808 2377808 defendant Belle Richard husbandman 586291 586291 Belle, Richard, of Fulstowe, husbandman 7
5070971 2377808 2377808 defendant Haynson Richard husbandman 842869 842869 Haynson, Richard, of Wargholm, husbandman 8
5070972 2377808 2377808 defendant Rowson Walter husbandman 842869 842869 Rowson, Walter, of Wargholm, husbandman 9
5070973 2377808 2377808 defendant Wryght John husbandman 842869 842869 Wryght, John, of Wargholm, husbandman 10
5070974 2377808 2377808 defendant Trayle John husbandman 588375 588375 Trayle, John, of Garnethorp, husbandman 11

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