names

27 rows where case_id = 2197643

✎ 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
4490163 2197643 2197643 plaintiff Venour William (legal representative)   Venour, William, executors of 0
4490164 2197643 2197643 plaintiff Venour William son of William   (Venour, William, son of William 1
4490165 2197643 2197643 plaintiff Hamerton John clerk   Hamerton, John, clerk 2
4490166 2197643 2197643 plaintiff Stapulford John     Stapulford, John 3
4490167 2197643 2197643 plaintiff Wykwine Roger     Wykwine, Roger 4
4490168 2197643 2197643 defendant Swynburn Thomas knight   Swynburn, Thomas, knight 0
4490169 2197643 2197643 defendant Tylle John dyer 762681 762681 Tylle, John, of Boxford, Suffolk, dyer 1
4490170 2197643 2197643 defendant Kempston John   599400 599400 Kempston, John, of Hadlegh, Suff 2
4490171 2197643 2197643 defendant Brewes William dyer 586470 586470 Brewes, William, of Colchester, dyer 3
4490172 2197643 2197643 defendant Barre Robert   596238 596238 Barre, Robert, of Suffolk 4
4490173 2197643 2197643 defendant Bartelot Nicholas   760098 760098 Bartelot, Nicholas, of Haveryng, Essex 5
4490174 2197643 2197643 defendant Alisaundre John     Alisaundre, John 6
4490175 2197643 2197643 defendant Mevyle Richard     Mevyle, Richard 7
4490176 2197643 2197643 defendant Clerk John farcarter 756563 756563 Clerk, John, of Bokyngham, farcarter 8
4490177 2197643 2197643 defendant Heyt- John   600796 600796 Heyt-, John, of Alynton 9
4490178 2197643 2197643 defendant Lewys Roger   586470 586470 Lewys, Roger, of Colchester 10
4490179 2197643 2197643 defendant Glym William clerk   Glym, William, clerk 11
4490180 2197643 2197643 defendant Touner Robert   745609 745609 Touner, Robert, of Misterton, Soms 12
4490181 2197643 2197643 defendant Lestraunge Roger knight   Lestraunge, Roger, knight 13
4490182 2197643 2197643 defendant Hathell William     Hathell, William 14
4490183 2197643 2197643 defendant Maples Thomas spicer 585869 585869 Maples, Thomas, of London, spicer 15
4490184 2197643 2197643 defendant Coggeshale William knight   Coggeshale, William, knight 16
4490185 2197643 2197643 defendant Shelford Henry     Shelford, Henry 17
4490186 2197643 2197643 defendant Bache John esq   Bache, John, esq 18
4490187 2197643 2197643 defendant le Moigne John   624085 624085 le Moigne, John, of Dorset, knight 19
4490188 2197643 2197643 defendant Lytilman Thomas   590032 590032 Lytilman, Thomas, of Kent, formerly bailiff of Great Dele 20
4490189 2197643 2197643 defendant Clyfton Richard shoemaker 762684 762684 Clyfton, Richard, of Baldoc, shoemaker 21

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