names

19 rows where case_id = 2353439

✎ 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
4988181 2353439 2353439 plaintiff Boteler Ralph knight   Boteler, Ralph, knight 0
4988182 2353439 2353439 plaintiff Beauchamp John knight   Beauchamp, John, knight 1
4988183 2353439 2353439 plaintiff Mountford William knight   Mountford, William, knight 2
4988184 2353439 2353439 plaintiff Norreys John     Norreys, John 3
4988185 2353439 2353439 plaintiff Nanfan John esq   Nanfan, John, esq 4
4988186 2353439 2353439 plaintiff Menston William     Menston, William 5
4988187 2353439 2353439 defendant Yate John husbandman 591817 591817 Yate, John, of Hatherop, husbandman 0
4988188 2353439 2353439 defendant Yate Thomas husbandman 591817 591817 Yate, Thomas, of Hatherop, husbandman 1
4988189 2353439 2353439 defendant Webbe Thomas laborer 831152 831152 Webbe, Thomas, of Langcote, Berks, laborer 2
4988190 2353439 2353439 defendant Geyles William laborer 831153 831153 Geyles, William, of Hatherop, Gloucs, laborer 3
4988191 2353439 2353439 defendant Martyn John miller 609540 609540 Martyn, John, of Fayreford, miller 4
4988192 2353439 2353439 defendant Tayllour John chaplain 609540 609540 Tayllour, John, of Fayreford, chaplain 5
4988193 2353439 2353439 defendant Penne Abel laborer 609540 609540 Penne, Abel, of Fayreford, laborer 6
4988194 2353439 2353439 defendant Lecchelawe Thomas   609540 609540 Lecchelawe, Thomas, of Fayreford, parish clerk 7
4988195 2353439 2353439 defendant Mey John husbandman 831155 831155 Mey, John, of Horcote, husbandman 8
4988196 2353439 2353439 defendant Cove John husbandman 831156 831156 Cove, John, of Merston Meysy, Wilts, husbandman 9
4988197 2353439 2353439 defendant Neuenton John skinner 831157 831157 Neuenton, John, of Criklad, Wilts, skinner 10
4988198 2353439 2353439 defendant Hunte Thomas chapman 600795 600795 Hunte, Thomas, of Criklade, chapman 11
4988199 2353439 2353439 defendant Hamstall John laborer 831158 831158 Hamstall, John, of Arlyngton, Gloucs, laborer 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);