names

27 rows where case_id = 2423907

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5228362 2423907 2423907 plaintiff Wastenes John esq, sheriffof Notts, administrators of   Wastenes, John, esq, sheriffof Notts, administrators of 0
5228363 2423907 2423907 plaintiff Beaumont Adam     (Beaumont, Adam 1
5228364 2423907 2423907 plaintiff Wyke Richard     Wyke, Richard 2
5228365 2423907 2423907 plaintiff Johnson John     Johnson, John 3
5228366 2423907 2423907 defendant Clyot William mercer 585869 585869 Clyot, William, of London, mercer 0
5228367 2423907 2423907 defendant Outhorp Ralph gent 590424 590424 Outhorp, Ralph, of Outhorp, gent 1
5228368 2423907 2423907 defendant Preston Peter yeoman 586058 586058 Preston, Peter, of Enfeld, Middx, yeoman 2
5228369 2423907 2423907 defendant Porter Richard husbandman 790105 790105 Porter, Richard, of Hokenall Torkard, husbandman 3
5228370 2423907 2423907 defendant Kelet Christopher yeoman 596009 596009 Kelet, Christopher, of Newethorp, yeoman 4
5228371 2423907 2423907 defendant Preston Hugh yeoman 861702 861702 Preston, Hugh, of Bylburgh, yeoman 5
5228372 2423907 2423907 defendant Boude Hugh husbandman 861703 861703 Boude, Hugh, of Oukney, husbandman 6
5228373 2423907 2423907 defendant Milner William husbandman 805125 805125 Milner, William, of Over Broghton, husbandman 7
5228374 2423907 2423907 defendant Bagshawe Oliver yeoman 600144 600144 Bagshawe, Oliver, of Tykhill, yeoman 8
5228375 2423907 2423907 defendant Tomson John   612266 612266 Tomson, John, of Blythe, cartwright 9
5228376 2423907 2423907 defendant Morehouse alias Fleccher Robert yeoman or fletcher 597418 597418 Morehouse alias Fleccher, Robert, of Calverton, yeoman or fletcher 10
5228377 2423907 2423907 defendant Gebbe Thomas husbandman 597418 597418 Gebbe, Thomas, of Calverton, husbandman 11
5228378 2423907 2423907 defendant atte Well William husbandman 777111 777111 atte Well, William, of Maunsfeld Wodehouse, husbandman 12
5228379 2423907 2423907 defendant Rodes John husbandman 861705 861705 Rodes, John, of Skaftesworth, husbandman 13
5228380 2423907 2423907 defendant Lede John yeoman 590719 590719 Lede, John, of Rufford, yeoman 14
5228381 2423907 2423907 defendant Clogh William yeoman 590719 590719 Clogh, William, of Rufford, yeoman 15
5228382 2423907 2423907 defendant Oldham Nicholas husbandman 587919 587919 Oldham, Nicholas, of Edynstowe, husbandman 16
5228383 2423907 2423907 defendant Wybbe Robert husbandman 587919 587919 Wybbe, Robert, of Edynstowe, husbandman 17
5228384 2423907 2423907 defendant Wybbe William husbandman or weaver 590308 590308 Wybbe, William, of Westhorp, husbandman or weaver 18
5228385 2423907 2423907 defendant Machon John laborer 587919 587919 Machon, John, of Edynstowe, laborer 19
5228386 2423907 2423907 defendant Sterry John laborer 587948 587948 Sterry, John, of Newerk, laborer 20
5228387 2423907 2423907 defendant Bever William laborer 587919 587919 Bever, William, of Edynstowe, laborer 21
5228388 2423907 2423907 defendant Archebold John laborer 587948 587948 Archebold, John, of Newerk, laborer 22

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