names

12 rows where case_id = 2496064

✎ 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
5470380 2496064 2496064 plaintiff Gay Thomas jun, of London   Gay, Thomas, jun, of London 0
5470381 2496064 2496064 defendant Talbot Brian esq 604961 604961 Talbot, Brian, of Westminster, Middx, esq 0
5470382 2496064 2496064 defendant Ryver Robert de la (legal representative) 585869 585869 Ryver, Robert de la, of London, gent, executrix of 1
5470383 2496064 2496064 defendant Codryngton Agnes   890876 890876 Codryngton, Agnes, of Codryngton, Gloucs, widow, formerly Agnes de la Ryver 2
5470384 2496064 2496064 defendant Austyll John (legal representative) 831726 831726 Austyll, John, of Chirchehill, Soms, esq, executors of 3
5470385 2496064 2496064 defendant Champernoun Joan widow 831726 831726 (Champernoun, Joan, of Chirchehill, Soms, widow 4
5470386 2496064 2496064 defendant Austyll Thomas clerk 890878 890878 Austyll, Thomas, of Exeter, Deveon, clerk 5
5470387 2496064 2496064 defendant Belknap Philip (legal representative) 650209 650209 Belknap, Philip, of Moote, Kent, gent, administratrix of 6
5470388 2496064 2496064 defendant Delafeld Elizabeth widow 890880 890880 Delafeld, Elizabeth, of Well, Kent, widow 7
5470389 2496064 2496064 defendant Radclyff Nicholas   604877 604877 Radclyff, Nicholas, of Old Bokenham, Norf, esq, administrators of 8
5470390 2496064 2496064 defendant Wyngfeld William esq 890882 890882 (Wyngfeld, William, of Speksale, Suff, esq 9
5470391 2496064 2496064 defendant Wyngfeld Margaret     Margaret, his wife 10

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