names

32 rows where case_id = 1904592

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631233 1904592 1904592 plaintiff Gaunte John     Gaunte, John 0
3631234 1904592 1904592 defendant Barker John   590243 590243 Barker, John, of Newmarket 0
3631235 1904592 1904592 defendant Couper William   590243 590243 Couper, William, of Newmarket 1
3631236 1904592 1904592 defendant Holyngworth Robert   590243 590243 Holyngworth, Robert, of Newmarket 2
3631237 1904592 1904592 defendant Jurden Henry   590243 590243 Jurden, Henry, of Newmarket 3
3631238 1904592 1904592 defendant Whitwall John   590243 590243 Whitwall, John, of Newmarket 4
3631239 1904592 1904592 defendant Sadler Ralph   590243 590243 Sadler, Ralph, of Newmarket 5
3631240 1904592 1904592 defendant Teverham or Tenerham John   590243 590243 Teverham or Tenerham, John, of Newmarket 6
3631241 1904592 1904592 defendant Harrison John   590243 590243 Harrison, John, of Newmarket 7
3631242 1904592 1904592 defendant Love John, senior   590243 590243 Love, John, senior, of Newmarket 8
3631243 1904592 1904592 defendant Love John, junior   590243 590243 Love, John, junior, of Newmarket 9
3631244 1904592 1904592 defendant Fonston Henry   598127 598127 Fonston, Henry, of Wood Ditton 10
3631245 1904592 1904592 defendant Colyn Walter   598127 598127 Colyn, Walter, of Wood Ditton 11
3631246 1904592 1904592 defendant Hasylwode Thomas   598127 598127 Hasylwode, Thomas, of Wood Ditton 12
3631247 1904592 1904592 defendant Ray John   598127 598127 Ray, John, of Wood Ditton 13
3631248 1904592 1904592 defendant Parker Thomas   597006 597006 Parker, Thomas, of Assheley 14
3631249 1904592 1904592 defendant Fenmall John   597006 597006 Fenmall, John, of Assheley 15
3631250 1904592 1904592 defendant Smyth Thomas   597006 597006 Smyth, Thomas, of Assheley 16
3631251 1904592 1904592 defendant Almer William   597006 597006 Almer, William, of Assheley 17
3631252 1904592 1904592 defendant Warryn John   598128 598128 Warryn, John, of Kertelyng 18
3631253 1904592 1904592 defendant Tylbrook William   598128 598128 Tylbrook, William, of Kertelyng 19
3631254 1904592 1904592 defendant Dirsley Richard   598128 598128 Dirsley, Richard, of Kertelyng 20
3631255 1904592 1904592 defendant Dirsley William   598128 598128 Dirsley, William, of Kertelyng 21
3631256 1904592 1904592 defendant Peche John   598128 598128 Peche, John, of Kertelyng 22
3631257 1904592 1904592 defendant Dirsle Thomas   598128 598128 Dirsle, Thomas, of Kertelyng 23
3631258 1904592 1904592 defendant Hovell or Houell of Kertelyng     Hovell or Houell, of Kertelyng 24
3631259 1904592 1904592 defendant Everard William   597626 597626 Everard, William, of Cheveley 25
3631260 1904592 1904592 defendant Sible Henry   598129 598129 Sible, Henry, of Chevele 26
3631261 1904592 1904592 defendant Norbury Thomas   598129 598129 Norbury, Thomas, of Chevele 27
3631262 1904592 1904592 defendant Cagge Thomas   598129 598129 Cagge, Thomas, of Chevele 28
3631263 1904592 1904592 defendant Gateward John   598130 598130 Gateward, John, of Saxton 29
3631264 1904592 1904592 defendant Taillour Henry   598131 598131 Taillour, Henry, of Ditton Valence 30

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