names

30 rows where case_id = 1926757

✎ 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
3701622 1926757 1926757 plaintiff Broune Thomas principal of New Inn   Broune, Thomas, principal of New Inn 0
3701623 1926757 1926757 defendant Sleford Richard gent 585929 585929 Sleford, Richard, of St Clement Danes, gent 0
3701624 1926757 1926757 defendant Russheton Henry gent 585929 585929 Russheton, Henry, of St Clement Danes, gent 1
3701625 1926757 1926757 defendant Ceton Thomas     Ceton, Thomas 2
3701626 1926757 1926757 defendant Constable Robert     Constable, Robert 3
3701627 1926757 1926757 defendant Bacon John     Bacon, John 4
3701628 1926757 1926757 defendant Chypenham Nicholas     Chypenham, Nicholas 5
3701629 1926757 1926757 defendant Meres Robert     Meres, Robert 6
3701630 1926757 1926757 defendant Lower John     Lower, John 7
3701631 1926757 1926757 defendant Sapcottys Edward     Sapcottys, Edward 8
3701632 1926757 1926757 defendant Higham Thomas     Higham, Thomas 9
3701633 1926757 1926757 defendant Constable Roger     Constable, Roger 10
3701634 1926757 1926757 defendant Broune Thomas     Broune, Thomas 11
3701635 1926757 1926757 defendant Babyngton Thomas     Babyngton, Thomas 12
3701636 1926757 1926757 defendant Reede John     Reede, John 13
3701637 1926757 1926757 defendant Butler Philip     Butler, Philip 14
3701638 1926757 1926757 defendant Bray Reginald     Bray, Reginald 15
3701639 1926757 1926757 defendant Candisshe George     Candisshe, George 16
3701640 1926757 1926757 defendant Hasylwood Edmund, junior     Hasylwood, Edmund, junior 17
3701641 1926757 1926757 defendant Constable Marmaduke, junior     Constable, Marmaduke, junior 18
3701642 1926757 1926757 defendant Ayleworth Anthony     Ayleworth, Anthony 19
3701643 1926757 1926757 defendant Belwode Francis     Belwode, Francis 20
3701644 1926757 1926757 defendant Rous Anthony     Rous, Anthony 21
3701645 1926757 1926757 defendant Semarke Thomas     Semarke, Thomas 22
3701646 1926757 1926757 defendant Whetley Thomas     Whetley, Thomas 23
3701647 1926757 1926757 defendant Wolmer Richard     Wolmer, Richard 24
3701648 1926757 1926757 defendant Walpole William     Walpole, William 25
3701649 1926757 1926757 defendant Whatton Thomas     Whatton, Thomas 26
3701650 1926757 1926757 defendant Tony Thomas     Tony, Thomas 27
3701651 1926757 1926757 defendant Wastlyn William gent 585929 585929 Wastlyn, William, of St Clement Danes, gent 28

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