names

13 rows where case_id = 2428719

✎ 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
5245021 2428719 2428719 plaintiff Pulteney John esq   Pulteney, John, esq 0
5245022 2428719 2428719 defendant Symkyns John yeoman 596535 596535 Symkyns, John, of Lutterworth, yeoman 0
5245023 2428719 2428719 defendant Broun William tailor 596535 596535 Broun, William, of Lutterworth, tailor 1
5245024 2428719 2428719 defendant Broun Henry tailor 596535 596535 Broun, Henry, of Lutterworth, tailor 2
5245025 2428719 2428719 defendant Rycrofts William husbandman 863605 863605 Rycrofts, William, of Stathewell, husbandman 3
5245026 2428719 2428719 defendant Rodburne William yeoman 611594 611594 Rodburne, William, of Grenburgh, Warks, yeoman 4
5245027 2428719 2428719 defendant Gansill Robert yeoman 595081 595081 Gansill, Robert, of Misterton, yeoman 5
5245028 2428719 2428719 defendant Gunwyn John tailor 596535 596535 Gunwyn, John, of Lutterworth, tailor 6
5245029 2428719 2428719 defendant William Robert     William, Robert 7
5245030 2428719 2428719 defendant Tibnam William     Tibnam, William 8
5245031 2428719 2428719 defendant Warde Thomas     Warde, Thomas 9
5245032 2428719 2428719 defendant Malpas Adam     Malpas, Adam 10
5245033 2428719 2428719 defendant Brokhole William     Brokhole, William 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);