names

9 rows where case_id = 2379453

✎ 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
5076438 2379453 2379453 plaintiff Barker alias Smythes John parson of Yedfyn Raff, or parson of Crofte, administrators of   Barker alias Smythes, John, parson of Yedfyn Raff, or parson of Crofte, administrators of 0
5076439 2379453 2379453 plaintiff Smyth John     (Smyth, John 1
5076440 2379453 2379453 plaintiff Smyth Richard     Smyth, Richard 2
5076441 2379453 2379453 defendant Smyth John husbandman 843545 843545 Smyth, John, of Hardpyry, or of Upledon, Glos, husbandman 0
5076442 2379453 2379453 defendant Wode John, junior husbandman 843546 843546 Wode, John, junior, of Aylmestre, Wyggemoresland, March of Wales, husbandman 1
5076443 2379453 2379453 defendant Wode John, senior butcher 843547 843547 Wode, John, senior, of Aylmestre, Wyggemoresland, butcher 2
5076444 2379453 2379453 defendant Mounmouthe William husbandman or yeoman 798272 798272 Mounmouthe, William, of Temedebury or Tenbury, Worcs, husbandman or yeoman 3
5076445 2379453 2379453 defendant Stoone William husbandman 606776 606776 Stoone, William, of Warton, husbandman 4
5076446 2379453 2379453 defendant Grene Richard husbandman 606776 606776 Grene, Richard, of Warton, husbandman 5

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