names

48 rows where case_id = 2214769

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4546236 2214769 2214769 plaintiff Braybrok Robert   604628 604628 Braybrok, Robert, of London, bishop 0
4546237 2214769 2214769 plaintiff Erpyngham Thomas knight   Erpyngham, Thomas, knight 1
4546238 2214769 2214769 plaintiff Rikhill William     Rikhill, William 2
4546239 2214769 2214769 plaintiff Churcheman John     Churcheman, John 3
4546240 2214769 2214769 plaintiff Sturmy John     Sturmy, John 4
4546241 2214769 2214769 plaintiff Weyland Thomas     Weyland, Thomas 5
4546242 2214769 2214769 plaintiff Curson William   587754 587754 Curson, William, of Byllyngford 6
4546243 2214769 2214769 plaintiff Gurnay John son of Edmund   Gurnay, John, son of Edmund 7
4546244 2214769 2214769 plaintiff Byllyngford James     Byllyngford, James 8
4546245 2214769 2214769 defendant Avelyn Henry   587915 587915 Avelyn, Henry, of Gyssyng 0
4546246 2214769 2214769 defendant Stradsill John   605102 605102 Stradsill, John, of New Bukenham 1
4546247 2214769 2214769 defendant Caly John   587745 587745 Caly, John, of Shymplyng 2
4546248 2214769 2214769 defendant Huberd William   587745 587745 Huberd, William, of Shymplyng 3
4546249 2214769 2214769 defendant Wymere Reginald   615362 615362 Wymere, Reginald, of Disse 4
4546250 2214769 2214769 defendant Alrede William   615362 615362 Alrede, William, of Disse 5
4546251 2214769 2214769 defendant Camp John   615362 615362 Camp, John, of Disse 6
4546252 2214769 2214769 defendant Lewen John   768125 768125 Lewen, John, of Dysse, Cressy, John, of Shelfhangur 7
4546253 2214769 2214769 defendant Drewe Thomas   768126 768126 Drewe, Thomas, of Shelfhangur 8
4546254 2214769 2214769 defendant Coke John   768127 768127 Coke, John, of Wynneferthyng, vicar 9
4546255 2214769 2214769 defendant Coke Henry     Coke, Henry 10
4546256 2214769 2214769 defendant Goche Hugh     Goche, Hugh 11
4546257 2214769 2214769 defendant Turnour Stephen     Turnour, Stephen 12
4546258 2214769 2214769 defendant Baron John jun   Baron, John, jun 13
4546259 2214769 2214769 defendant Midyldyke Thomas     Midyldyke, Thomas 14
4546260 2214769 2214769 defendant Aleyn Roger     Aleyn, Roger 15
4546261 2214769 2214769 defendant Aleyn John     Aleyn, John 16
4546262 2214769 2214769 defendant Ivell Reginald     Ivell, Reginald 17
4546263 2214769 2214769 defendant Perot John     Perot, John 18
4546264 2214769 2214769 defendant Butturkythe John     Butturkythe, John 19
4546265 2214769 2214769 defendant atte Halleyate John     atte Halleyate, John 20
4546266 2214769 2214769 defendant Wylde Thomas     Wylde, Thomas 21
4546267 2214769 2214769 defendant Jurdan William     Jurdan, William 22
4546268 2214769 2214769 defendant Jurdan Richard     Jurdan, Richard 23
4546269 2214769 2214769 defendant Dodde Robert     Dodde, Robert 24
4546270 2214769 2214769 defendant James Richard     James, Richard 25
4546271 2214769 2214769 defendant Lebald John     Lebald, John 26
4546272 2214769 2214769 defendant Breton Robert     Breton, Robert 27
4546273 2214769 2214769 defendant Breton John jun   Breton, John, jun 28
4546274 2214769 2214769 defendant Dobbe John     Dobbe, John 29
4546275 2214769 2214769 defendant Reve Stephen     Reve, Stephen 30
4546276 2214769 2214769 defendant Thurston Walter     Thurston, Walter 31
4546277 2214769 2214769 defendant Vaus John     Vaus, John 32
4546278 2214769 2214769 defendant Warenger John     Warenger, John 33
4546279 2214769 2214769 defendant Savage John     Savage, John 34
4546280 2214769 2214769 defendant Wyndham John     Wyndham, John 35
4546281 2214769 2214769 defendant Clare John     Clare, John 36
4546282 2214769 2214769 defendant Wadthorp Nicholas     Wadthorp, Nicholas 37
4546283 2214769 2214769 defendant Baron John turner   Baron, John, turner 38

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