names

57 rows where case_id = 2181208

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4438024 2181208 2181208 plaintiff Amesley Thomas de     Amesley, Thomas de 0
4438025 2181208 2181208 defendant Rose William   597438 597438 Rose, William, of Colston Basset 0
4438026 2181208 2181208 defendant Rose John   597438 597438 Rose, John, of Colston Basset 1
4438027 2181208 2181208 defendant Rose Robert   597438 597438 Rose, Robert, of Colston Basset 2
4438028 2181208 2181208 defendant Colston Basset Richard of, son of Henry   Colston, Basset, Richard of, son of Henry 3
4438029 2181208 2181208 defendant Richardson John, senior     Richardson, John, senior 4
4438030 2181208 2181208 defendant Richardson John, junior     Richardson, John, junior 5
4438031 2181208 2181208 defendant Colston Basset William son of Richard of   Colston Basset, William, son of Richard of 6
4438032 2181208 2181208 defendant Buxom Adam     Buxom, Adam 7
4438033 2181208 2181208 defendant (not given) John his son   John, his son 8
4438034 2181208 2181208 defendant Pyke John     Pyke, John 9
4438035 2181208 2181208 defendant Greyne John     Greyne, John 10
4438036 2181208 2181208 defendant Greyne William     Greyne, William 11
4438037 2181208 2181208 defendant William son of Robert     William, son of Robert 12
4438038 2181208 2181208 defendant John son of Robert     John, son of Robert 13
4438039 2181208 2181208 defendant Bronkes Robert     Bronkes, Robert 14
4438040 2181208 2181208 defendant del Grene Hugh     del Grene, Hugh 15
4438041 2181208 2181208 defendant Baker John     Baker, John 16
4438042 2181208 2181208 defendant Baker Robert     Baker, Robert 17
4438043 2181208 2181208 defendant Colston Basset Richard son of Adam, of   Colston Basset, Richard, son of Adam, of 18
4438044 2181208 2181208 defendant Wyke John     Wyke, John 19
4438045 2181208 2181208 defendant Monkesman Thomas     Monkesman, Thomas 20
4438046 2181208 2181208 defendant Barwe John de     Barwe, John de 21
4438047 2181208 2181208 defendant Shole William     Shole, William 22
4438048 2181208 2181208 defendant Nade William     Nade, William 23
4438049 2181208 2181208 defendant Doget William     Doget, William 24
4438050 2181208 2181208 defendant Rose Robert     Rose, Robert 25
4438051 2181208 2181208 defendant Wylymot Richard     Wylymot, Richard 26
4438052 2181208 2181208 defendant Wylymot John     Wylymot, John 27
4438053 2181208 2181208 defendant Taillour Thomas     Taillour, Thomas 28
4438054 2181208 2181208 defendant Taillour John     Taillour, John 29
4438055 2181208 2181208 defendant Shovyn Adam     Shovyn, Adam 30
4438056 2181208 2181208 defendant Showyn William     Showyn, William 31
4438057 2181208 2181208 defendant Smith William     Smith, William 32
4438058 2181208 2181208 defendant Flesshewer William     Flesshewer, William 33
4438059 2181208 2181208 defendant Barre John     Barre, John 34
4438060 2181208 2181208 defendant Barre Geoffrey     Barre, Geoffrey 35
4438061 2181208 2181208 defendant Pyle Robert     Pyle, Robert 36
4438062 2181208 2181208 defendant Hamond John     Hamond, John 37
4438063 2181208 2181208 defendant A--- John     A---, John 38
4438064 2181208 2181208 defendant del Wold Richard     del Wold, Richard 39
4438065 2181208 2181208 defendant Flesshewer John     Flesshewer, John 40
4438066 2181208 2181208 defendant Herle John     Herle, John 41
4438067 2181208 2181208 defendant Herle William     Herle, William 42
4438068 2181208 2181208 defendant Hamond William     Hamond, William 43
4438069 2181208 2181208 defendant Willy John     Willy, John 44
4438070 2181208 2181208 defendant Colston Basset Robert son of John of   Colston Basset, Robert, son of John of 45
4438071 2181208 2181208 defendant Stanton John de     Stanton, John de 46
4438072 2181208 2181208 defendant Stanton Robert de     Stanton, Robert de 47
4438073 2181208 2181208 defendant Pyke William     Pyke, William 48
4438074 2181208 2181208 defendant Bole John     Bole, John 49
4438075 2181208 2181208 defendant Heston Robert de     Heston, Robert de 50
4438076 2181208 2181208 defendant Hert William     Hert, William 51
4438077 2181208 2181208 defendant Wymarkes John     Wymarkes, John 52
4438078 2181208 2181208 defendant Baker William     Baker, William 53
4438079 2181208 2181208 defendant Geffray John     Geffray, John 54
4438080 2181208 2181208 defendant Smyth John   756472 756472 Smyth, John, of ColstonBasset 55

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