names

11 rows where case_id = 2280044

✎ 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
4748419 2280044 2280044 plaintiff Marler John (legal representative)   Marler, John, executors of 0
4748420 2280044 2280044 plaintiff Marler Joan formerly wife of Testator   (Marler, Joan, formerly wife of Testator 1
4748421 2280044 2280044 plaintiff Hurtecombe Philip     Hurtecombe, Philip 2
4748422 2280044 2280044 defendant Stonard Richard husbandman 766577 766577 Stonard, Richard, of Wrentych, husbandman 0
4748423 2280044 2280044 defendant Hunt John husbandman 718864 718864 Hunt, John, of Stowey, husbandman 1
4748424 2280044 2280044 defendant Pal John husbandman 660628 660628 Pal, John, of Meryet, husbandman 2
4748425 2280044 2280044 defendant Smyth John smith 610621 610621 Smyth, John, of Cryche, smith 3
4748426 2280044 2280044 defendant Seymour Roger (legal representative) 775994 775994 Seymour, Roger, of Hacche Beauchamp, executors of 4
4748427 2280044 2280044 defendant Hacche Beauchamp Richard parson of the church, in   (Hacche Beauchamp, Richard, parson of the church, in 5
4748428 2280044 2280044 defendant Cleydon Richard yeoman 775994 775994 Cleydon, Richard, of Hacche Beauchamp, yeoman 6
4748429 2280044 2280044 defendant Fresell John yeoman 775994 775994 Fresell, John, of Hacche Beauchamp, yeoman 7

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