names

7 rows where case_id = 1994621

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3912820 1994621 1994621 plaintiff Atwood Robert yeoman 650573 650573 Atwood, Robert, of Foshawe, yeoman 0
3912821 1994621 1994621 plaintiff Baggar alias Badjar Thomas mercer 650574 650574 Baggar alias Badjar, Thomas, of Bytford Graunge, mercer 1
3912822 1994621 1994621 defendant Bysshop John smith 650575 650575 Bysshop, John, of Wallysborne, smith 0
3912823 1994621 1994621 defendant Peers John yeoman 586738 586738 Peers, John, of Alston, yeoman 1
3912824 1994621 1994621 defendant Hyckes John clerk 592525 592525 Hyckes, John, of Wolverton, clerk 2
3912825 1994621 1994621 defendant Edward William smith 600810 600810 Edward, William, of Brayles, smith 3
3912826 1994621 1994621 defendant Freman John husbandman 620752 620752 Freman, John, of Inkebarowe, Worcs, husbandman 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);