names

44 rows where case_id = 2173708

✎ 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
4428371 2173708 2173708 plaintiff Stratford William de son of John   Stratford, William de, son of John 0
4428372 2173708 2173708 defendant Stratford Isabel de formerly wife of John   Stratford, Isabel de, formerly wife of John 0
4428373 2173708 2173708 defendant Aldeswell William de     Aldeswell, William de 1
4428374 2173708 2173708 defendant Chedewode Nicholas parson of the church, in   Chedewode, Nicholas, parson of the church, in 2
4428375 2173708 2173708 defendant William brother of Nicholas     William, brother of Nicholas 3
4428376 2173708 2173708 defendant Robert brother of Nicholas     Robert, brother of Nicholas 4
4428377 2173708 2173708 defendant Walter brother of Nicholas     Walter, brother of Nicholas 5
4428378 2173708 2173708 defendant Roo Henry le chaplain   Roo, Henry le, chaplain 6
4428379 2173708 2173708 defendant Chetwode Robert de     Chetwode, Robert de 7
4428380 2173708 2173708 defendant Wyhot Richard     Wyhot, Richard 8
4428381 2173708 2173708 defendant Wyhot Roger     Wyhot, Roger 9
4428382 2173708 2173708 defendant West William     West, William 10
4428383 2173708 2173708 defendant Langeport Robert de     Langeport, Robert de 11
4428384 2173708 2173708 defendant Muleward William le   586035 586035 Muleward, William le, of Buckingham 12
4428385 2173708 2173708 defendant Horn Simon draper   Horn, Simon, draper 13
4428386 2173708 2173708 defendant Mory Reginald     Mory, Reginald 14
4428387 2173708 2173708 defendant Hawardyn Robert     Hawardyn, Robert 15
4428388 2173708 2173708 defendant Dames John Basset, Robert   Dames, John, Basset, Robert 16
4428389 2173708 2173708 defendant Hickus Richard     Hickus, Richard 17
4428390 2173708 2173708 defendant Clemens John chaplain 597874 597874 Clemens, John, of Stowe, chaplain 18
4428391 2173708 2173708 defendant Hesel Richard   755448 755448 Hesel, Richard, of Heybern 19
4428392 2173708 2173708 defendant Taillour John   588600 588600 Taillour, John, of Westbury 20
4428393 2173708 2173708 defendant St Luz Simon   588600 588600 St Luz, Simon, of Westbury 21
4428394 2173708 2173708 defendant Leyr Roger of Fynemere     Leyr, Roger of Fynemere 22
4428395 2173708 2173708 defendant Blethe John   590061 590061 Blethe, John, of Barton 23
4428396 2173708 2173708 defendant Achard Thomas   755449 755449 Achard, Thomas, of Evershawe 24
4428397 2173708 2173708 defendant Bruttom John millward   Bruttom, John, millward 25
4428398 2173708 2173708 defendant Grusset James   620888 620888 Grusset, James, of Bourton 26
4428399 2173708 2173708 defendant Bonde John le   588600 588600 Bonde, John le, of Westbury 27
4428400 2173708 2173708 defendant Howes William   597874 597874 Howes, William, of Stowe 28
4428401 2173708 2173708 defendant West Robert bailiff of Radeclyve   West, Robert, bailiff of Radeclyve 29
4428402 2173708 2173708 defendant Godeshome Henry     Godeshome, Henry 30
4428403 2173708 2173708 defendant Preest Hugh   755450 755450 Preest, Hugh, of Checkemor 31
4428404 2173708 2173708 defendant Coupe John   755450 755450 Coupe, John, of Checkemor 32
4428405 2173708 2173708 defendant Wodeward Ralph   755449 755449 Wodeward, Ralph, of Evershawe 33
4428406 2173708 2173708 defendant Sale Roger de la     Sale, Roger de la 34
4428407 2173708 2173708 defendant Hickus Ralph chaplain   Hickus, Ralph, chaplain 35
4428408 2173708 2173708 defendant Faber John   755451 755451 Faber, John, of Shaldeston 36
4428409 2173708 2173708 defendant Lynot John   755452 755452 Lynot, John, of Westraford, parson 37
4428410 2173708 2173708 defendant atte Sale William   755453 755453 atte Sale, William, of Boycote 38
4428411 2173708 2173708 defendant John son of the same William     John, son of the same William 39
4428412 2173708 2173708 defendant Horsham John de     Horsham, John de 40
4428413 2173708 2173708 defendant Spenser Thomas   588600 588600 Spenser, Thomas, of Westbury 41
4428414 2173708 2173708 defendant Reve Robert   755451 755451 Reve, Robert, of Shaldeston 42

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