names

28 rows where case_id = 1935833

✎ 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
3730685 1935833 1935833 plaintiff Broun Thomas   619571 619571 Broun, Thomas, of New Inn 0
3730686 1935833 1935833 defendant Sleford Richard gent 585869 585869 Sleford, Richard, of London, gent 0
3730687 1935833 1935833 defendant Russheton Henry gent 585869 585869 Russheton, Henry, of London, gent 1
3730688 1935833 1935833 defendant Ceton Thomas     Ceton, Thomas 2
3730689 1935833 1935833 defendant Constable Robert     Constable, Robert 3
3730690 1935833 1935833 defendant Baton John     Baton, John 4
3730691 1935833 1935833 defendant Chypenham Nicholas     Chypenham, Nicholas 5
3730692 1935833 1935833 defendant Meres Robert     Meres, Robert 6
3730693 1935833 1935833 defendant Lower John     Lower, John 7
3730694 1935833 1935833 defendant Sapcott Edward     Sapcott, Edward 8
3730695 1935833 1935833 defendant Higham Thomas, junior     Higham, Thomas, junior 9
3730696 1935833 1935833 defendant Constable Roger     Constable, Roger 10
3730697 1935833 1935833 defendant Broun Thomas, senior     Broun, Thomas, senior 11
3730698 1935833 1935833 defendant babyngton Thomas     babyngton, Thomas 12
3730699 1935833 1935833 defendant Rede John     Rede, John 13
3730700 1935833 1935833 defendant Butler John     Butler, John 14
3730701 1935833 1935833 defendant Cawndyssh George     Cawndyssh, George 15
3730702 1935833 1935833 defendant Hasilwode Edmund junoor   Hasilwode, Edmund, junoor 16
3730703 1935833 1935833 defendant Constable Marmaduke, junior     Constable, Marmaduke, junior 17
3730704 1935833 1935833 defendant Aylworth Anthony     Aylworth, Anthony 18
3730705 1935833 1935833 defendant Barrett Alexander     Barrett, Alexander 19
3730706 1935833 1935833 defendant Belwode Francis     Belwode, Francis 20
3730707 1935833 1935833 defendant Rous Anthony     Rous, Anthony 21
3730708 1935833 1935833 defendant Semarke homas     Semarke, homas 22
3730709 1935833 1935833 defendant Wheteley Thomas     Wheteley, Thomas 23
3730710 1935833 1935833 defendant Wolmer Richard     Wolmer, Richard 24
3730711 1935833 1935833 defendant Tony Thomas     Tony, Thomas 25
3730712 1935833 1935833 defendant Wastlyn William gent 585869 585869 Wastlyn, William, of London, gent 26

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