names

15 rows where case_id = 2487803

✎ 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
5442949 2487803 2487803 plaintiff Bremelcombe Henry     Bremelcombe, Henry 0
5442950 2487803 2487803 defendant (illegible) of Stephynston yeoman   _, of Stephynston, yeoman 0
5442951 2487803 2487803 defendant Hayne Philip laborer 886061 886061 Hayne, Philip, of Stephynston, laborer 1
5442952 2487803 2487803 defendant Manecote John laborer 886061 886061 Manecote, John, of Stephynston, laborer 2
5442953 2487803 2487803 defendant Maior John laborer 886061 886061 Maior, John, of Stephynston, laborer 3
5442954 2487803 2487803 defendant Clerke John husbandman 797416 797416 Clerke, John, of Great Torrington, husbandman 4
5442955 2487803 2487803 defendant Clerke Richard tailor 797416 797416 Clerke, Richard, of Great Torrington, tailor 5
5442956 2487803 2487803 defendant Gorant Robert husbandman 797416 797416 Gorant, Robert, of Great Torrington, husbandman 6
5442957 2487803 2487803 defendant Beare Richard butcher 797416 797416 Beare, Richard, of Great Torrington, butcher 7
5442958 2487803 2487803 defendant Buryman John hoper 797416 797416 Buryman, John, of Great Torrington, hoper 8
5442959 2487803 2487803 defendant Lewys John husbandman 797416 797416 Lewys, John, of Great Torrington, husbandman 9
5442960 2487803 2487803 defendant Rede John husbandman 797416 797416 Rede, John, of Great Torrington, husbandman 10
5442961 2487803 2487803 defendant Haddon William carpenter 681762 681762 Haddon, William, of Beauford, carpenter 11
5442962 2487803 2487803 defendant Clement John   878217 878217 Clement, John, of Whitteslegh 12
5442963 2487803 2487803 defendant Lucas Richard husbandman 878217 878217 together with Lucas, Richard, of Whitteslegh, husbandman 13

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