names

18 rows where case_id = 1906293

✎ 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
3636766 1906293 1906293 plaintiff Rowe John   599434 599434 Rowe, John, of sergeant at law 0
3636767 1906293 1906293 plaintiff Cary Robert esq   Cary, Robert, esq 1
3636768 1906293 1906293 defendant Rede William yeoman 587161 587161 Rede, William, of Cornewode, yeoman 0
3636769 1906293 1906293 defendant Rede Thomas yeoman 586833 586833 Rede, Thomas, of South Brent, yeoman 1
3636770 1906293 1906293 defendant Rowe John husbandman 587161 587161 Rowe, John, of Cornewode, husbandman 2
3636771 1906293 1906293 defendant Towsan Nicholas husbandman 587161 587161 Towsan, Nicholas, of Cornewode, husbandman 3
3636772 1906293 1906293 defendant Wodeham John husbandman 587161 587161 Wodeham, John, of Cornewode, husbandman 4
3636773 1906293 1906293 defendant Donston Ralph husbandman 587161 587161 Donston, Ralph, of Cornewode, husbandman 5
3636774 1906293 1906293 defendant Toll Thomas yeoman 587161 587161 Toll, Thomas, of Cornewode, yeoman 6
3636775 1906293 1906293 defendant Romayn William   587161 587161 Romayn, William, of Cornewode, groom 7
3636776 1906293 1906293 defendant Larde Thomas   587161 587161 Larde, Thomas, of Cornewode, groom 8
3636777 1906293 1906293 defendant Sowton Robert   587161 587161 Sowton, Robert, of Cornewode, groom 9
3636778 1906293 1906293 defendant Foster Richard   587161 587161 Foster, Richard, of Cornewode, groom 10
3636779 1906293 1906293 defendant Miller George yeoman 587161 587161 Miller, George, of Cornewode, yeoman 11
3636780 1906293 1906293 defendant Towsan William   587161 587161 Towsan, William, of Cornewode, groom 12
3636781 1906293 1906293 defendant Weryng Thomas   587161 587161 Weryng, Thomas, of Cornewode, mason 13
3636782 1906293 1906293 defendant Gyll John yeoman 599437 599437 Gyll, John, of Yalmeton, yeoman 14
3636783 1906293 1906293 defendant Forde John, senior yeoman 599438 599438 Forde, John, senior, of Byckelegh, yeoman 15

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