names

22 rows where case_id = 2256723

✎ 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
4671457 2256723 2256723 plaintiff (not given) John prior of Castell 586067 586067 Castell, John, of York, prior of Holy Trinity 0
4671458 2256723 2256723 defendant Marchall Richard yeoman 616192 616192 Marchall, Richard, of Kypax, yeoman 0
4671459 2256723 2256723 defendant Huchonson John husbandman 616192 616192 Huchonson, John, of Kypax, husbandman 1
4671460 2256723 2256723 defendant Lowe John husbandman 616192 616192 Lowe, John, of Kypax, husbandman 2
4671461 2256723 2256723 defendant Huchonson Robert --- husbandman 616192 616192 Huchonson, Robert ---, of Kypax, husbandman 3
4671462 2256723 2256723 defendant Hogeson Robert husbandman 616192 616192 Hogeson, Robert, of Kypax, husbandman 4
4671463 2256723 2256723 defendant Thomlynson John husbandman 616192 616192 Thomlynson, John, of Kypax, husbandman 5
4671464 2256723 2256723 defendant Brymston William husbandman 616192 616192 Brymston, William, of Kypax, husbandman 6
4671465 2256723 2256723 defendant Brigge Thomas de husbandman 616192 616192 Brigge, Thomas de, of Kypax, husbandman 7
4671466 2256723 2256723 defendant Smyth Robert husbandman 616192 616192 Smyth, Robert, of Kypax, husbandman 8
4671467 2256723 2256723 defendant Smyth Richard husbandman 616192 616192 Smyth, Richard, of Kypax, husbandman 9
4671468 2256723 2256723 defendant Smyth Simon husbandman 616192 616192 Smyth, Simon, of Kypax, husbandman 10
4671469 2256723 2256723 defendant Tournoure Thomas husbandman 616192 616192 Tournoure, Thomas, of Kypax, husbandman 11
4671470 2256723 2256723 defendant Hunte John husbandman 616192 616192 Hunte, John, of Kypax, husbandman 12
4671471 2256723 2256723 defendant Shalooke Richard husbandman 616192 616192 Shalooke, Richard, of Kypax, husbandman 13
4671472 2256723 2256723 defendant Yarum Henry husbandman 616192 616192 Yarum, Henry, of Kypax, husbandman 14
4671473 2256723 2256723 defendant Attkynson Henry husbandman   Attkynson, Henry, husbandman 15
4671474 2256723 2256723 defendant Milnar Willaim husbandman 616192 616192 Milnar, Willaim, of Kypax, husbandman 16
4671475 2256723 2256723 defendant Williamson Gilson John husbandman 616192 616192 Williamson Gilson, John, of Kypax, husbandman 17
4671476 2256723 2256723 defendant Dogeson Robert husbandman 616192 616192 Dogeson, Robert, of Kypax, husbandman 18
4671477 2256723 2256723 defendant Medley John husbandman 616192 616192 Medley, John, of Kypax, husbandman 19
4671478 2256723 2256723 defendant Hillom Thomas husbandman 616192 616192 Hillom, Thomas, of Kypax, husbandman 20

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