names

15 rows where case_id = 1932034

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3718384 1932034 1932034 plaintiff Foxe Richard Bishop of Winchester   Foxe, Richard, Bishop of Winchester 0
3718385 1932034 1932034 plaintiff Howard Thomas Duke of Norfolk   Howard, Thomas, Duke of Norfolk 1
3718386 1932034 1932034 plaintiff Somerset Charles Earl of Worcester   Somerset, Charles, Earl of Worcester 2
3718387 1932034 1932034 plaintiff Somerset Henry Lord Herbert   Somerset, Henry, Lord Herbert 3
3718388 1932034 1932034 plaintiff West Thomas Lord de Warre   West, Thomas, Lord de Warre 4
3718389 1932034 1932034 plaintiff Owen David knight   Owen, David, knight 5
3718390 1932034 1932034 plaintiff Drury Robert knight   Drury, Robert, knight 6
3718391 1932034 1932034 plaintiff Calthorp Philip knight   Calthorp, Philip, knight 7
3718392 1932034 1932034 plaintiff Paston William knight   Paston, William, knight 8
3718393 1932034 1932034 plaintiff FitzHerbert Anthony Justice   FitzHerbert, Anthony, Justice 9
3718394 1932034 1932034 plaintiff Nudygate John sergeant at law   Nudygate, John, sergeant at law 10
3718395 1932034 1932034 plaintiff griffitz Philip     griffitz, Philip 11
3718396 1932034 1932034 plaintiff Barott William     Barott, William 12
3718397 1932034 1932034 defendant Aldryche Richard husbandman 604128 604128 Aldryche, Richard, of Rumborough, husbandman 0
3718398 1932034 1932034 defendant Aldryche Robert husbandman 601686 601686 Aldryche, Robert, of Carleton Colvyle, husbandman 1

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