names

18 rows where case_id = 2346517

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4965194 2346517 2346517 plaintiff Coterell Nicholas     Coterell, Nicholas 0
4965195 2346517 2346517 plaintiff Burgh John bailiffs of Stane, Stapilho and Flendiche   Burgh, John, bailiffs of Stane, Stapilho and Flendiche 1
4965196 2346517 2346517 defendant Poperyke John   602161 602161 Poperyke, John, of Chipenham, holy water clerk 0
4965197 2346517 2346517 defendant Lak John laborer 602161 602161 Lak, John, of Chipenham, laborer 1
4965198 2346517 2346517 defendant Carpenter Thomas constable of Chipenham, husbandman   Carpenter, Thomas, constable of Chipenham, husbandman 2
4965199 2346517 2346517 defendant Hervy Thomas husbandman 602161 602161 Hervy, Thomas, of Chipenham, husbandman 3
4965200 2346517 2346517 defendant Hervy John husbandman 602161 602161 Hervy, John, of Chipenham, husbandman 4
4965201 2346517 2346517 defendant Norman William husbandman 602161 602161 Norman, William, of Chipenham, husbandman 5
4965202 2346517 2346517 defendant Baker John husbandman 602161 602161 Baker, John, of Chipenham, husbandman 6
4965203 2346517 2346517 defendant Berford John husbandman 602161 602161 Berford, John, of Chipenham, husbandman 7
4965204 2346517 2346517 defendant Cate John husbandman 602161 602161 Cate, John, of Chipenham, husbandman 8
4965205 2346517 2346517 defendant Pygot Thomas husbandman 602161 602161 Pygot, Thomas, of Chipenham, husbandman 9
4965206 2346517 2346517 defendant Asshele John husbandman 602161 602161 Asshele, John, of Chipenham, husbandman 10
4965207 2346517 2346517 defendant Blaker John husbandman 602161 602161 Blaker, John, of Chipenham, husbandman 11
4965208 2346517 2346517 defendant Hakka John husbandman 602161 602161 Hakka, John, of Chipenham, husbandman 12
4965209 2346517 2346517 defendant Busshell Robert husbandman 602161 602161 Busshell, Robert, of Chipenham, husbandman 13
4965210 2346517 2346517 defendant Smyth Adam husbandman 602161 602161 Smyth, Adam, of Chipenham, husbandman 14
4965211 2346517 2346517 defendant Lak John husbandman 602161 602161 Lak, John, of Chipenham, husbandman 15

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