names

19 rows where case_id = 2382696

✎ 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
5087398 2382696 2382696 plaintiff Hull Edward knight   Hull, Edward, knight, executrix of 0
5087399 2382696 2382696 plaintiff Hull Eleanor     Hull, Eleanor 1
5087400 2382696 2382696 defendant Sperke William   803148 803148 Sperke, William, of Dupeford, bailiff 0
5087401 2382696 2382696 defendant Handy Walter   587196 587196 Handy, Walter, of Fremyngton, bailiff 1
5087402 2382696 2382696 defendant Barry William yeoman 807142 807142 Barry, William, of Roughburgh, yeoman 2
5087403 2382696 2382696 defendant Wavell or Wavell John husbandman 807142 807142 Wavell or Wavell, John, of Roughburgh, husbandman 3
5087404 2382696 2382696 defendant Melton John husbandman 844867 844867 Melton, John, of Ynstowe, husbandman 4
5087405 2382696 2382696 defendant Vantord John   588557 588557 Vantord, John, of Tyverton, bailiff 5
5087406 2382696 2382696 defendant Jesse William   597014 597014 Jesse, William, of Bokerell, bailiff 6
5087407 2382696 2382696 defendant Hill Richard   641926 641926 Hill, Richard, of Coliton, bailiff 7
5087408 2382696 2382696 defendant Hopkyn William   612035 612035 Hopkyn, William, of Lyfton, bailiff 8
5087409 2382696 2382696 defendant Foldhay John   843730 843730 Foldhay, John, of Seynt Sydewelisse, Exeter, bailiff 9
5087410 2382696 2382696 defendant Oxenham Henry   587162 587162 Oxenham, Henry, of Ermyngton, bailiff 10
5087411 2382696 2382696 defendant Perys William   807142 807142 Perys, William, of Roughburgh, bailiff 11
5087412 2382696 2382696 defendant Whityng William   587395 587395 Whityng, William, of Tavystoke, bailiff 12
5087413 2382696 2382696 defendant Mouns William husbandman 630846 630846 Mouns, William, of Gydlegh, husbandman 13
5087414 2382696 2382696 defendant Garlond John husbandman 598601 598601 Garlond, John, of Columpton, husbandman 14
5087415 2382696 2382696 defendant Murry John   622532 622532 Murry, John, of St Mary Churche, bailiff 15
5087416 2382696 2382696 defendant Lange William weaver 585995 585995 Lange, William, of Neweton Abbot, weaver 16

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