names

18 rows where case_id = 1942340

✎ 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
3751328 1942340 1942340 plaintiff Nevile George knight, Lord Burgevenny   Nevile, George, knight, Lord Burgevenny 0
3751329 1942340 1942340 plaintiff Nevyle Thomas knight   Nevyle, Thomas, knight 1
3751330 1942340 1942340 plaintiff Nevyle Edward knight   Nevyle, Edward, knight 2
3751331 1942340 1942340 plaintiff Weyston Richard knight   Weyston, Richard, knight 3
3751332 1942340 1942340 plaintiff Courte Richard     Courte, Richard 4
3751333 1942340 1942340 plaintiff Goryng John     Goryng, John 5
3751334 1942340 1942340 plaintiff Brytt Robert     Brytt, Robert 6
3751335 1942340 1942340 plaintiff Rotes William clerk   Rotes, William, clerk 7
3751336 1942340 1942340 plaintiff Ormeston Robert     Ormeston, Robert 8
3751337 1942340 1942340 defendant Mylle Simon yeoman 623237 623237 Mylle, Simon, of Warkeley, yeoman 0
3751338 1942340 1942340 defendant Rogerman Thomas turner 598986 598986 Rogerman, Thomas, of Saterley, turner 1
3751339 1942340 1942340 defendant Rogerman John   623237 623237 Rogerman, John, of Warkeley, groom 2
3751340 1942340 1942340 defendant Clotworthi Christopher tucker 591749 591749 Clotworthi, Christopher, of South Molton, tucker 3
3751341 1942340 1942340 defendant Clotworthy Robert shoemaker 623239 623239 Clotworthy, Robert, of Soyth Molton, shoemaker 4
3751342 1942340 1942340 defendant Rondon William shoemaker 591749 591749 Rondon, William, of South Molton, shoemaker 5
3751343 1942340 1942340 defendant Clement Hugh yeoman 622455 622455 Clement, Hugh, of Bryghtlegh, yeoman 6
3751344 1942340 1942340 defendant Alvekkeserye Richard smith 623240 623240 Alvekkeserye, Richard, of Hugh Bykyngton, smith 7
3751345 1942340 1942340 defendant Marshall John husbandman 623237 623237 Marshall, John, of Warkeley, husbandman 8

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