names

38 rows where case_id = 2169729

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename

id ▼ case_id role surname forename occupation place_id raw_segment seq
4415448 2169729 2169729 plaintiff (not given) John bishop of Hereford   Hereford, John, bishop of 0
4415449 2169729 2169729 defendant Bole William     Bole, William 0
4415450 2169729 2169729 defendant Heort William   638853 638853 Heort, William, of Hulle 1
4415451 2169729 2169729 defendant Gilot William   753730 753730 together with Gilot, William, of Godrich's Castle, vicar 2
4415452 2169729 2169729 defendant Rose William chaplain   Rose, William, chaplain 3
4415453 2169729 2169729 defendant Crouthare Richard le     Crouthare, Richard le 4
4415454 2169729 2169729 defendant Breyban Adam     Breyban, Adam 5
4415455 2169729 2169729 defendant Williames Henry     Williames, Henry 6
4415456 2169729 2169729 defendant Williames John     Williames, John 7
4415457 2169729 2169729 defendant Williames William     Williames, William 8
4415458 2169729 2169729 defendant Palmere Nicholas le     Palmere, Nicholas le 9
4415459 2169729 2169729 defendant Cookes Henry     Cookes, Henry 10
4415460 2169729 2169729 defendant Colyare Christine la     Colyare, Christine la 11
4415461 2169729 2169729 defendant Cady Wiliam     Cady, Wiliam 12
4415462 2169729 2169729 defendant Cady John     Cady, John 13
4415463 2169729 2169729 defendant Cady Robert     Cady, Robert 14
4415464 2169729 2169729 defendant Belhot Roger     Belhot, Roger 15
4415465 2169729 2169729 defendant Croucchare Walter le     Croucchare, Walter le 16
4415466 2169729 2169729 defendant Clerk Philip le     Clerk, Philip le 17
4415467 2169729 2169729 defendant Coupare Thomas le     Coupare, Thomas le 18
4415468 2169729 2169729 defendant Separe John le     Separe, John le 19
4415469 2169729 2169729 defendant Broun Isabel     Broun, Isabel 20
4415470 2169729 2169729 defendant Heygebo William     Heygebo, William 21
4415471 2169729 2169729 defendant Jay Alice     Jay, Alice 22
4415472 2169729 2169729 defendant Maydeson William     Maydeson, William 23
4415473 2169729 2169729 defendant Dobyn Thomas     Dobyn, Thomas 24
4415474 2169729 2169729 defendant Wylkyn John     Wylkyn, John 25
4415475 2169729 2169729 defendant Henyn Adam     Henyn, Adam 26
4415476 2169729 2169729 defendant Bell William     Bell, William 27
4415477 2169729 2169729 defendant Hathewy Walter     Hathewy, Walter 28
4415478 2169729 2169729 defendant Maydesond William     Maydesond, William 29
4415479 2169729 2169729 defendant Smart Adam     Smart, Adam 30
4415480 2169729 2169729 defendant Phelippes Roger     Phelippes, Roger 31
4415481 2169729 2169729 defendant Broun Walter     Broun, Walter 32
4415482 2169729 2169729 defendant Walshe John le     Walshe, John le 33
4415483 2169729 2169729 defendant Walshe Thomas le     Walshe, Thomas le 34
4415484 2169729 2169729 defendant Philippes William     Philippes, William 35
4415485 2169729 2169729 defendant Eliot Roger     Eliot, Roger 36

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