names

23 rows where place_id = 628730

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3784020 1952781 1952781 defendant William John husbandman 628730 628730 William, John, of St Stephens, husbandman 0
3784021 1952781 1952781 defendant Trebulok Robert husbandman 628730 628730 Trebulok, Robert, of St Stephens, husbandman 1
4152002 2078810 2078810 defendant Cocke Richard husbandman 628730 628730 Cocke, Richard, of St Stephens, husbandman 0
4153045 2079169 2079169 defendant Bartmouth Anthony   628730 628730 Bartmouth, Anthony, of St Stephens, groom 0
4153046 2079169 2079169 defendant Trethewey Thomas husbandman 628730 628730 Trethewey, Thomas, of St Stephens, husbandman 1
4175930 2087059 2087059 defendant Trevill Richard gent 628730 628730 Trevill, Richard, of St Stephens, or of Trematon, gent 0
4199185 2095273 2095273 defendant Trevill Richard gent 628730 628730 Trevill, Richard, of St Stephens, or of Tremanon, gent 0
4218633 2102015 2102015 defendant Courtyer John weaver 628730 628730 Courtyer, John, of St Stephens, weaver 0
4218634 2102015 2102015 defendant Courtyer Henry weaver 628730 628730 Courtyer, Henry, of St Stephens, weaver 1
4218635 2102015 2102015 defendant Courtyer William husbandman 628730 628730 Courtyer, William, of St Stephens, husbandman 2
4245009 2111313 2111313 defendant Palmer Peter baker 628730 628730 Palmer, Peter, of St Stephens, baker 0
4245021 2111318 2111318 defendant Palmer Peter baker 628730 628730 Palmer, Peter, of St Stephens, baker 0
4246457 2111792 2111792 defendant Horwell Christopher husbandman 628730 628730 Horwell, Christopher, of St Stephens, husbandman 0
4246458 2111792 2111792 defendant Toker Robert husbandman 628730 628730 Toker, Robert, of St Stephens, husbandman Toker, Richard, of St Stephens, husbandman 1
4246459 2111792 2111792 defendant Courtyer William husbandman 628730 628730 Courtyer, William, of St Stephens, husbandman 2
4298525 2129574 2129574 defendant Jollyff George gent 628730 628730 Jollyff, George, of St Stephens, gent 2
4310754 2133904 2133904 defendant Coll John husbandman 628730 628730 (Coll, John, of St Stephens, husbandman 3
4386367 2160120 2160120 defendant Tregensa Nicholas husbandman 628730 628730 Tregensa, Nicholas, of St Stephens, husbandman 0
4386368 2160120 2160120 defendant Vanson Edward husbandman 628730 628730 Vanson, Edward, of St Stephens, husbandman 1
4386369 2160120 2160120 defendant Rose William husbandman 628730 628730 Rose, William, of St Stephens, husbandman 2
4386370 2160120 2160120 defendant Starke William husbandman 628730 628730 Starke, William, of St Stephens, husbandman 3
4390740 2161513 2161513 defendant Vynton Thomas husbandman 628730 628730 Vynton, Thomas, of St Stephens, husbandman 0
5198985 2415455 2415455 plaintiff Walesby William (legal representative) 628730 628730 Walesby, William, of St Stephens, Westminister, clerk & prebendary of the prebend of Wrytlyngton, executors of 0

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