names

28 rows where case_id = 2183610

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4445692 2183610 2183610 plaintiff Cursom Thomas     Cursom, Thomas 0
4445693 2183610 2183610 defendant Lawes Adam     Lawes, Adam 0
4445694 2183610 2183610 defendant Flaxman Andrew     Flaxman, Andrew 1
4445695 2183610 2183610 defendant Ropere John     Ropere, John 2
4445696 2183610 2183610 defendant Bredbuclte Richard     Bredbuclte, Richard 3
4445697 2183610 2183610 defendant Ladde William     Ladde, William 4
4445698 2183610 2183610 defendant fox Geoffrey     fox, Geoffrey 5
4445699 2183610 2183610 defendant Giould Edmund     Giould, Edmund 6
4445700 2183610 2183610 defendant Cuffe John     Cuffe, John 7
4445701 2183610 2183610 defendant Cuffe Robert     Cuffe, Robert 8
4445702 2183610 2183610 defendant Cuffe Randolf     Cuffe, Randolf 9
4445703 2183610 2183610 defendant Rook John     Rook, John 10
4445704 2183610 2183610 defendant Smyth John     Smyth, John 11
4445705 2183610 2183610 defendant Garr John   587166 587166 Garr, John, of Salle 12
4445706 2183610 2183610 defendant Oldhous William   591536 591536 Oldhous, William, of Corpsty 13
4445707 2183610 2183610 defendant Berfild Adam     Berfild, Adam 14
4445708 2183610 2183610 defendant Barkere William     Barkere, William 15
4445709 2183610 2183610 defendant Conpere William     Conpere, William 16
4445710 2183610 2183610 defendant Coupere John servant of William Coupere   Coupere, John, servant of William Coupere 17
4445711 2183610 2183610 defendant Ades Roger     Ades, Roger 18
4445712 2183610 2183610 defendant Ulf John     Ulf, John 19
4445713 2183610 2183610 defendant Aleyn Richard     Aleyn, Richard 20
4445714 2183610 2183610 defendant Colt William     Colt, William 21
4445715 2183610 2183610 defendant Smyth William     Smyth, William 22
4445716 2183610 2183610 defendant Gery Thomas     Gery, Thomas 23
4445717 2183610 2183610 defendant Burt Thomas     Burt, Thomas 24
4445718 2183610 2183610 defendant Sturmy Alan     Sturmy, Alan 25
4445719 2183610 2183610 defendant Redere Thomas     Redere, Thomas 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);