names

16 rows where case_id = 2423543

✎ 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
5226960 2423543 2423543 plaintiff Swete Thomas     Swete, Thomas 0
5226961 2423543 2423543 plaintiff Hatfeld Richard     Hatfeld, Richard 1
5226962 2423543 2423543 defendant Lyete Thomas esq 861523 861523 Lyete, Thomas, of Lytescare, esq 0
5226963 2423543 2423543 defendant Mylbourn John carpenter 602254 602254 Mylbourn, John, of Hynton, carpenter 1
5226964 2423543 2423543 defendant Hunteley Isabel widow 861524 861524 Hunteley, Isabel, of Nether Attebarre, widow 2
5226965 2423543 2423543 defendant Crystian Richard yeoman 861525 861525 Crystian, Richard, of Lytescarre, yeoman 3
5226966 2423543 2423543 defendant Basket Robert husbandman 587210 587210 Basket, Robert, of Merston, husbandman 4
5226967 2423543 2423543 defendant Maundevyle Walter laborer 757244 757244 Maundevyle, Walter, of Modeford, laborer 5
5226968 2423543 2423543 defendant Coke Nicholas laborer 757244 757244 Coke, Nicholas, of Modeford, laborer 6
5226969 2423543 2423543 defendant Permyter John   608576 608576 Permyter, John, of Trent, mason 7
5226970 2423543 2423543 defendant Permyter William laborer 608576 608576 Permyter, William, of Trent, laborer 8
5226971 2423543 2423543 defendant Moure William laborer 608576 608576 Moure, William, of Trent, laborer 9
5226972 2423543 2423543 defendant Broun Thomas laborer 608576 608576 Broun, Thomas, of Trent, laborer 10
5226973 2423543 2423543 defendant Howse John tiler 588135 588135 Howse, John, of Somerton, tiler 11
5226974 2423543 2423543 defendant Rede John   588135 588135 Rede, John, of Somerton, mason 12
5226975 2423543 2423543 defendant Hore John   768084 768084 Hore, John, of Astyngton, servant 13

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