names

23 rows where case_id = 2507165

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5507228 2507165 2507165 plaintiff Copley William     Copley, William 0
5507229 2507165 2507165 defendant Tocotys Roger   609225 609225 Tocotys, Roger, of Bromham, Wilts, knight 0
5507230 2507165 2507165 defendant Pudsey Henry gent 724520 724520 Pudsey, Henry, of Arneford, yorks, gent 1
5507231 2507165 2507165 defendant Radcliff Christopher gent 586286 586286 Radcliff, Christopher, of Boston, gent 2
5507232 2507165 2507165 defendant Orchard Thomas yeoman 789441 789441 Orchard, Thomas, of Tuttebury, Staffs, yeoman 3
5507233 2507165 2507165 defendant Maclon Thomas drover 894546 894546 Maclon, Thomas, of Penkhull, Staffs, drover 4
5507234 2507165 2507165 defendant Smyth Richard yeoman 677835 677835 Smyth, Richard, of Wirkesworth, Derbs, yeoman 5
5507235 2507165 2507165 defendant Patenson Richard yeoman 606537 606537 Patenson, Richard, of Newcastle under Lyne, Staffs, yeoman 6
5507236 2507165 2507165 defendant Johnson William yeoman 598666 598666 Johnson, William, of Newcastle under Lyne, yeoman 7
5507237 2507165 2507165 defendant Boleyn William yeoman 586286 586286 Boleyn, William, of Boston, yeoman 8
5507238 2507165 2507165 defendant Savyll John   894547 894547 Savyll, John, of Sandall juxta Wakefeld, Yorks, knight 9
5507239 2507165 2507165 defendant Bell John yeoman 591739 591739 Bell, John, of Wymbersley, Yorks, yeoman 10
5507240 2507165 2507165 defendant Jacson Richard yeoman 612489 612489 Jacson, Richard, of Pountfret, Yorks, yeoman 11
5507241 2507165 2507165 defendant Coke John yeoman 894548 894548 Coke, John, of Brotilby, Lincs, yeoman 12
5507242 2507165 2507165 defendant Wilkyn John yeoman 587053 587053 Wilkyn, John, of Sutton, Lincs, yeoman 13
5507243 2507165 2507165 defendant Cotton Thomas gent 611503 611503 Cotton, Thomas, of Adderston, Warks, gent 14
5507244 2507165 2507165 defendant Rothewell Richard yeoman 612495 612495 Rothewell, Richard, of Acworth, Yorks, yeoman 15
5507245 2507165 2507165 defendant Morewode William yeoman 894549 894549 Morewode, William, of Wakefeld, Yroks, yeoman 16
5507246 2507165 2507165 defendant Baxter Alexander yeoman 894550 894550 Baxter, Alexander, of Barley, Yorks, yeoman 17
5507247 2507165 2507165 defendant Danby James   868302 868302 Danby, James, of Farnley, Yorks, knight 18
5507248 2507165 2507165 defendant Willoughby Henry   632294 632294 Willoughby, Henry, of Middelton, Warks, knight 19
5507249 2507165 2507165 defendant Hastyges Hugh knight   Hastyges, Hugh, knight, executrix of 20
5507250 2507165 2507165 defendant Hastynges Anne widow 591632 591632 Hastynges, Anne, of Fenwyke, Yorks, widow 21

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