names

55 rows where case_id = 2232838

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation

id ▼ case_id role surname forename occupation place_id raw_segment seq
4605406 2232838 2232838 plaintiff Armeston William     Armeston, William 0
4605407 2232838 2232838 defendant Rappok Thomas     Rappok, Thomas 0
4605408 2232838 2232838 defendant del Haye Robert     del Haye, Robert 1
4605409 2232838 2232838 defendant Bagshawe Thomas de jun   Bagshawe, Thomas de, jun 2
4605410 2232838 2232838 defendant del Kirke Walter     del Kirke, Walter 3
4605411 2232838 2232838 defendant Sergeant Robert     Sergeant, Robert 4
4605412 2232838 2232838 defendant del Kyrke Hugh jun   del Kyrke, Hugh, jun 5
4605413 2232838 2232838 defendant Daweson William son of Richard   Daweson, William, son of Richard 6
4605414 2232838 2232838 defendant Olleronshawe Hugh     Olleronshawe, Hugh 7
4605415 2232838 2232838 defendant del Sherde William     del Sherde, William 8
4605416 2232838 2232838 defendant Mewerell John     Mewerell, John 9
4605417 2232838 2232838 defendant Bosvyle John     Bosvyle, John 10
4605418 2232838 2232838 defendant Northcroft John de     Northcroft, John de 11
4605419 2232838 2232838 defendant Burton John de son of Nicholas   Burton, John de, son of Nicholas 12
4605420 2232838 2232838 defendant Taillour Robert   767807 767807 Taillour, Robert, of Fairefeld 13
4605421 2232838 2232838 defendant Foter John   591227 591227 Foter, John, of Hope 14
4605422 2232838 2232838 defendant Henryson Roger   760860 760860 Henryson, Roger, of Hordelowe 15
4605423 2232838 2232838 defendant del Kirke Thomas son of William   del Kirke, Thomas, son of William 16
4605424 2232838 2232838 defendant Holand Charles de     Holand, Charles de 17
4605425 2232838 2232838 defendant Prestclyf John son of John   Prestclyf, John, son of John 18
4605426 2232838 2232838 defendant Balgy Robert   587352 587352 Balgy, Robert, of Aston 19
4605427 2232838 2232838 defendant Balgy Robert   773888 773888 Balgy, Robert, of Aston, jun 20
4605428 2232838 2232838 defendant del Fryth John son of Thomas   del Fryth, John, son of Thomas 21
4605429 2232838 2232838 defendant Fort Alan     Fort, Alan 22
4605430 2232838 2232838 defendant Whithill John de   625044 625044 Whithill, John de, of Bankewell 23
4605431 2232838 2232838 defendant Smythesson Richard   588089 588089 Smythesson, Richard, of Bakewell 24
4605432 2232838 2232838 defendant Padley Thomas   773889 773889 Padley, Thomas, of Bukstones. Shene, Nicholas 25
4605433 2232838 2232838 defendant Wryght William son of John, of Tunstydes   Wryght, William, son of John, of Tunstydes 26
4605434 2232838 2232838 defendant Penhulton Peter de     Penhulton, Peter de 27
4605435 2232838 2232838 defendant Willeson del Chapell Thomas son of John   Willeson del Chapell, Thomas, son of John 28
4605436 2232838 2232838 defendant Redythe Robert son of Richard, Kirk, Maud de   Redythe, Robert, son of Richard, Kirk, Maud de 29
4605437 2232838 2232838 defendant Dycson John son of William   Dycson, John, son of William 30
4605438 2232838 2232838 defendant Cange John     Cange, John 31
4605439 2232838 2232838 defendant Dankyn Henry son of John   Dankyn, Henry, son of John 32
4605440 2232838 2232838 defendant Walschawe Nicholas de     Walschawe, Nicholas de 33
4605441 2232838 2232838 defendant Abell Henry     Abell, Henry 34
4605442 2232838 2232838 defendant Baret Roger     Baret, Roger 35
4605443 2232838 2232838 defendant Broke John de     Broke, John de 36
4605444 2232838 2232838 defendant Halghton John de son of Adam     Halghton John de, son of Adam 37
4605445 2232838 2232838 defendant Droffeld Richard de     Droffeld, Richard de 38
4605446 2232838 2232838 defendant Swyndene Robert de     Swyndene, Robert de 39
4605447 2232838 2232838 defendant Waynewryght John son of Roger   Waynewryght, John, son of Roger 40
4605448 2232838 2232838 defendant Crosshagh William de   773890 773890 Crosshagh, William de, of Haselbache 41
4605449 2232838 2232838 defendant Roworth Thomas de   586784 586784 Roworth, Thomas de, of Burgh 42
4605450 2232838 2232838 defendant Merpel John de Robynson, Robert, son of John   Merpel, John de, Robynson, Robert, son of John 43
4605451 2232838 2232838 defendant Robert James     Robert, James 44
4605452 2232838 2232838 defendant Adlastre Robert     Adlastre, Robert 45
4605453 2232838 2232838 defendant Stanhyrst Henry de     Stanhyrst, Henry de 46
4605454 2232838 2232838 defendant Hothcote Thomas son of John   Hothcote, Thomas, son of John 47
4605455 2232838 2232838 defendant Wynteworth William de   589000 589000 Wynteworth, William de, of Bradfeld 48
4605456 2232838 2232838 defendant Horelowe Thomas son of John, son of Stephen   Horelowe, Thomas, son of John, son of Stephen 49
4605457 2232838 2232838 defendant Meller Adam de     Meller, Adam de 50
4605458 2232838 2232838 defendant Cay Robert   587861 587861 Cay, Robert, of Berley, servant of Robert 51
4605459 2232838 2232838 defendant Hullay John de tailor   Hullay, John de, tailor 52
4605460 2232838 2232838 defendant Barlowe John jun   Barlowe, John, jun 53

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