names

15 rows where case_id = 2355238

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4994566 2355238 2355238 plaintiff Folkyngham Thomas   612120 612120 Folkyngham, Thomas, of Sleford 0
4994567 2355238 2355238 defendant Housewryght John miller 619096 619096 Housewryght, John, of New Lafford, miller 0
4994568 2355238 2355238 defendant Douke or Donke John husbandman 599982 599982 Douke or Donke, John, of Fulbek, husbandman 1
4994569 2355238 2355238 defendant Gedney John husbandman 589413 589413 Gedney, John, of Aswardby, husbandman 2
4994570 2355238 2355238 defendant Gelle Richard husbandman 603450 603450 Gelle, Richard, of Evedon, husbandman 3
4994571 2355238 2355238 defendant Cropwell John husbandman 812463 812463 Cropwell, John, of Eston by Stoke, husbandman 4
4994572 2355238 2355238 defendant Martill Ralph   731463 731463 Martill, Ralph, of Westburgh, parson 5
4994573 2355238 2355238 defendant Andrewe John clerk 832222 832222 Andrewe, John, of Tye, Leics, clerk 6
4994574 2355238 2355238 defendant Blyklyng John   832223 832223 Blyklyng, John, of Little Bytham 7
4994575 2355238 2355238 defendant Botery Robert yeoman 779161 779161 Botery, Robert, of Ryskyngton, yeoman 8
4994576 2355238 2355238 defendant Doland John mercer 585869 585869 Doland, John, of London, mercer 9
4994577 2355238 2355238 defendant Goldsmyth John merchant 794804 794804 Goldsmyth, John, of Melton Moubray, Leics, merchant 10
4994578 2355238 2355238 defendant Lewys William merchant 592105 592105 Lewys, William, of Okeham, Rutland, merchant 11
4994579 2355238 2355238 defendant Lewys John husbandman 601614 601614 Lewys, John, of Tymberland, husbandman 12
4994580 2355238 2355238 defendant Multon William chaplain 756733 756733 Multon, William, of Kirketon in Holand, chaplain 13

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