names

6 rows where case_id = 2393207

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5123152 2393207 2393207 plaintiff Welyngton William   814648 814648 Welyngton, William, of Warmestre 0
5123153 2393207 2393207 defendant Bene Thomas merchant 585907 585907 Bene, Thomas, of Bishops Lenn, merchant 0
5123154 2393207 2393207 defendant Melcheborne John merchant 585907 585907 Melcheborne, John, of Bishops Lenn, merchant 1
5123155 2393207 2393207 defendant Joynour alias Emmethe John merchant 585907 585907 Joynour alias Emmethe, John, of Bishops Lenn, merchant 2
5123156 2393207 2393207 defendant Philpott William merchant 585907 585907 Philpott, William, of Bishops Lenn, merchant 3
5123157 2393207 2393207 defendant Ormylle Thomas merchant 585907 585907 Ormylle, Thomas, of Bishops Lenn, merchant 4

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