names

13 rows where case_id = 2398564

✎ 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
5141249 2398564 2398564 plaintiff Uffenham John     Uffenham, John, on his own account 0
5141250 2398564 2398564 defendant Aleyn John husbandman 595281 595281 Aleyn, John, of Dounton, husbandman 0
5141251 2398564 2398564 defendant Ryghthonde Thomas smith 595281 595281 Ryghthonde, Thomas, of Dounton, smith 1
5141252 2398564 2398564 defendant More Nicholas   594871 594871 More, Nicholas, of Devyses, cloth maker 2
5141253 2398564 2398564 defendant Auntours Robert husbandman 673709 673709 Auntours, Robert, of Hale, Hants, husbandman 3
5141254 2398564 2398564 defendant Wylkyns Robert husbandman 592782 592782 Wylkyns, Robert, of Hale, husbandman 4
5141255 2398564 2398564 defendant Pecok William laborer 595281 595281 Pecok, William, of Dounton, laborer 5
5141256 2398564 2398564 defendant Pecok Robert husbandman 595281 595281 Pecok, Robert, of Dounton, husbandman 6
5141257 2398564 2398564 defendant Wyther Richard   852186 852186 Wyther, Richard, of Westbury, baillif 7
5141258 2398564 2398564 defendant Page Robert clothier 665544 665544 Page, Robert, of Crokerton, clothier 8
5141259 2398564 2398564 defendant Gibbys John husbandman 590942 590942 Gibbys, John, of Swyndon, husbandman 9
5141260 2398564 2398564 defendant Sticheale Thomas mercer 590942 590942 Sticheale, Thomas, of Swyndon, mercer 10
5141261 2398564 2398564 defendant Wylkyns William husbandman 590942 590942 Wylkyns, William, of Swyndon, 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);