names

13 rows where case_id = 2074573

✎ 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
4139733 2074573 2074573 plaintiff Vaughan Francis esq   Vaughan, Francis, esq 0
4139734 2074573 2074573 defendant Scaundrett Rice dyer 593772 593772 Scaundrett, Rice, of Kyngton, dyer 0
4139735 2074573 2074573 defendant Taylor Thomas husbandman 593772 593772 Taylor, Thomas, of Kyngton, husbandman 1
4139736 2074573 2074573 defendant Powell John yeoman 593772 593772 Powell, John, of Kyngton, yeoman 2
4139737 2074573 2074573 defendant Burgwyn Jevan yeoman 664141 664141 Burgwyn, Jevan, of Kington, yeoman 3
4139738 2074573 2074573 defendant Powell Richard yeoman 664141 664141 Powell, Richard, of Kington, yeoman 4
4139739 2074573 2074573 defendant Lewys Thomas husbandman 664141 664141 Lewys, Thomas, of Kington, husbandman 5
4139740 2074573 2074573 defendant Wyllyms Thomas shoemaker 593772 593772 Wyllyms, Thomas, of Kyngton, shoemaker 6
4139741 2074573 2074573 defendant Turner John yeoman 593772 593772 Turner, John, of Kyngton, yeoman 7
4139742 2074573 2074573 defendant Knowe Richard, junior husbandman 663038 663038 together with Knowe, Richard, junior, of Bradnor, husbandman 8
4139743 2074573 2074573 defendant Meredith Richard yeoman 664141 664141 Meredith, Richard, of Kington, yeoman 9
4139744 2074573 2074573 defendant Scaundrett Richard yeoman 664141 664141 Scaundrett, Richard, of Kington, yeoman 10
4139745 2074573 2074573 defendant Heywood Richard yeoman 664141 664141 Heywood, Richard, of Kington, yeoman 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);