names

7 rows where case_id = 2524433

✎ 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
5565284 2524433 2524433 plaintiff Buggy Richard     Buggy, Richard 0
5565285 2524433 2524433 defendant Pegyn William yeoman 900673 900673 Pegyn, William, of Straford on Avon, Warks, yeoman 0
5565286 2524433 2524433 defendant Grene William yeoman 835389 835389 Grene, William, of Ippewell, yeoman 1
5565287 2524433 2524433 defendant Sargent John yeoman 638942 638942 Sargent, John, of Tysowe, Warks, yeoman 2
5565288 2524433 2524433 defendant Grene Edward husbandman 900674 900674 Grene, Edward, of Wrouxston, husbandman 3
5565289 2524433 2524433 defendant Mason John husbandman 900674 900674 Mason, John, of Wrouxston, husbandman 4
5565290 2524433 2524433 defendant Argent John husbandman 900674 900674 Argent, John, of Wrouxston, 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);