names

15 rows where case_id = 2372776

✎ 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
5053941 2372776 2372776 plaintiff Benalva William     Benalva, William 0
5053942 2372776 2372776 defendant Kent William yeoman 588802 588802 Kent, William, of Wotton, yeoman 0
5053943 2372776 2372776 defendant Burges Thomas yeoman 840808 840808 Burges, Thomas, of Moditon, yeoman 1
5053944 2372776 2372776 defendant Calpoll John yeoman 840808 840808 Calpoll, John, of Moditon, yeoman 2
5053945 2372776 2372776 defendant Scut John yeoman 840809 840809 Scut, John, of Modyton, yeoman 3
5053946 2372776 2372776 defendant Bolde Peter yeoman 840809 840809 Bolde, Peter, of Modyton, yeoman 4
5053947 2372776 2372776 defendant Somer Thomas yeoman 840809 840809 Somer, Thomas, of Modyton, yeoman 5
5053948 2372776 2372776 defendant Harry Nicholas husbandman 840810 840810 Harry, Nicholas, of Trevelmyn, husbandman 6
5053949 2372776 2372776 defendant Turner Richard yeoman 599162 599162 Turner, Richard, of Saltasshe, yeoman 7
5053950 2372776 2372776 defendant Harry John husbandman 840811 840811 Harry, John, of Popeton, husbandman 8
5053951 2372776 2372776 defendant Colyn Nicholas husbandman 614268 614268 Colyn, Nicholas, of Polgover, husbandman 9
5053952 2372776 2372776 defendant Colyn Walter husbandman 614268 614268 Colyn, Walter, of Polgover, husbandman 10
5053953 2372776 2372776 defendant Molde Richard husbandman 840808 840808 Molde, Richard, of Moditon, husbandman 11
5053954 2372776 2372776 defendant Rowe John husbandman 840812 840812 Rowe, John, of Nytheratrewen, husbandman 12
5053955 2372776 2372776 defendant Kyng John husbandman 840813 840813 Kyng, John, of Treyr, 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);