names

13 rows where case_id = 1869066

✎ 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
3604465 1869066 1869066 plaintiff Gresham William     Gresham, William 0
3604466 1869066 1869066 defendant Nytyngale John merchant 591452 591452 Nytyngale, John, of Brentwode, Essex, merchant 0
3604467 1869066 1869066 defendant Smyth Thomas raffman 591453 591453 Smyth, Thomas, of North Tuddenham, raffman 1
3604468 1869066 1869066 defendant Amyson John yeoman 591454 591454 Amyson, John, of Burnham Stache, yeoman 2
3604469 1869066 1869066 defendant Robyns John yeoman 590965 590965 Robyns, John, of Hyndolneston, yeoman 3
3604470 1869066 1869066 defendant Brese Robert yeoman 587836 587836 Brese, Robert, of Folsham, yeoman 4
3604471 1869066 1869066 defendant Wyx Henry husbandman 591455 591455 Wyx, Henry, of Geysdele, husbandman 5
3604472 1869066 1869066 defendant Selwyn Richard gent 591456 591456 Selwyn, Richard, of Feltwell, gent 6
3604473 1869066 1869066 defendant Pullet Thomas (legal representative) 585933 585933 Pullet, Thomas, of Great Yarmouth, chaplain, executors of 7
3604474 1869066 1869066 defendant Gloys Thomas merchant 585933 585933 (Gloys, Thomas, of Great Yarmouth, merchant 8
3604475 1869066 1869066 defendant Cappe Roger yeoman 585933 585933 Cappe, Roger, of Great Yarmouth, yeoman 9
3604476 1869066 1869066 defendant Casterton Thomas (legal representative) 591459 591459 Casterton, Thomas, of Ketelston, yeoman, executor of 10
3604477 1869066 1869066 defendant Casterton William chaplain 591459 591459 Casterton, William, of Ketelston, chaplain 11

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