names

22 rows where case_id = 1873972

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620431 1873972 1873972 plaintiff London Henry     London, Henry 0
3620432 1873972 1873972 defendant Tenell John yeoman 586019 586019 Tenell, John, of South Cave, yeoman 0
3620433 1873972 1873972 defendant Mounder Stephen yeoman 586019 586019 Mounder, Stephen, of South Cave, yeoman 1
3620434 1873972 1873972 defendant Teler Robert yeoman 595420 595420 Teler, Robert, of Brounflete, yeoman 2
3620435 1873972 1873972 defendant Smyth John yeoman 595421 595421 Smyth, John, of Faxflete, yeoman 3
3620436 1873972 1873972 defendant Frampton Robert yeoman 586281 586281 Frampton, Robert, of Yokeflete, yeoman 4
3620437 1873972 1873972 defendant Loweson John yeoman 591977 591977 Loweson, John, of Laxton, yeoman 5
3620438 1873972 1873972 defendant Hothom Thomas yeoman 595422 595422 Hothom, Thomas, of Cotnasse, yeoman 6
3620439 1873972 1873972 defendant Proudefelowe Richard yeoman 595423 595423 Proudefelowe, Richard, of Skelton, yeoman 7
3620440 1873972 1873972 defendant Storme John yeoman 595424 595424 Storme, John, of Belby, yeoman 8
3620441 1873972 1873972 defendant Jakson William yeoman 589590 589590 Jakson, William, of Portyngton, yeoman 9
3620442 1873972 1873972 defendant Beson John yeoman 595425 595425 Beson, John, of Estryngton, yeoman 10
3620443 1873972 1873972 defendant Webster Peter yeoman 595426 595426 Webster, Peter, of Owesthorp, yeoman 11
3620444 1873972 1873972 defendant Bailly William yeoman 595427 595427 Bailly, William, of Hith, yeoman 12
3620445 1873972 1873972 defendant Tasker Thomas yeoman 595428 595428 Tasker, Thomas, of Gilberdike, yeoman 13
3620446 1873972 1873972 defendant Walker John yeoman 595429 595429 Walker, John, of Benetland, yeoman 14
3620447 1873972 1873972 defendant Hill William yeoman 595430 595430 Hill, William, of Skalby, yeoman 15
3620448 1873972 1873972 defendant Smyth John yeoman 595430 595430 Smyth, John, of Skalby, yeoman 16
3620449 1873972 1873972 defendant Webster Henry yeoman 588306 588306 Webster, Henry, of Greneake, yeoman 17
3620450 1873972 1873972 defendant Twysell Robert yeoman 595431 595431 Twysell, Robert, of North Cave, yeoman 18
3620451 1873972 1873972 defendant Abbot Thomas yeoman 595431 595431 Abbot, Thomas, of North Cave, yeoman 19
3620452 1873972 1873972 defendant Comyn John yeoman 595432 595432 Comyn, John, of Everthorp, yeoman 20

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