names

14 rows where case_id = 2348359

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4971326 2348359 2348359 plaintiff Hopton Thomas     Hopton, Thomas 0
4971327 2348359 2348359 defendant Mynstrell William of Bekkey husbandman   Mynstrell, William of Bekkey, husbandman 0
4971328 2348359 2348359 defendant Bekker Roger husbandman   Bekker, Roger, husbandman 1
4971329 2348359 2348359 defendant Warde Richard husbandman 828965 828965 Warde, Richard, of Bekkey, husbandman 2
4971330 2348359 2348359 defendant Aleyn Roger husbandman 622366 622366 Aleyn, Roger, of Bedston, husbandman 3
4971331 2348359 2348359 defendant Taillour John husbandman 622366 622366 Taillour, John, of Bedston, husbandman 4
4971332 2348359 2348359 defendant Persons John husbandman 622366 622366 Persons, John, of Bedston, husbandman 5
4971333 2348359 2348359 defendant Brians William husbandman 622366 622366 Brians, William, of Bedston, husbandman 6
4971334 2348359 2348359 defendant Mathewe John husbandman 607261 607261 Mathewe, John, of Marlowe, husbandman 7
4971335 2348359 2348359 defendant Longford David husbandman 828966 828966 Longford, David, of Keymptyn, husbandman 8
4971336 2348359 2348359 defendant Wallker Philip husbandman 598357 598357 Wallker, Philip, of Bukton, husbandman 9
4971337 2348359 2348359 defendant Eynon or Gynon William husbandman 828967 828967 Eynon or Gynon, William, of Leyntwardyn, March of Wales, husbandman 10
4971338 2348359 2348359 defendant Scarn or Soarn John husbandman 828966 828966 Scarn or Soarn, John, of Keymptyn, husbandman 11
4971339 2348359 2348359 defendant Turnour Walter husbandman 660549 660549 Turnour, Walter, of Leyntwardyn, husbandman 12

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