names

13 rows where case_id = 2324274

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4892106 2324274 2324274 plaintiff Pynchebek Richard     Pynchebek, Richard 0
4892107 2324274 2324274 defendant Randolf John husbandman 594819 594819 Randolf, John, of Quaplod, husbandman 0
4892108 2324274 2324274 defendant Murwold William shoemaker 586751 586751 Murwold, William, of Holbech, shoemaker 1
4892109 2324274 2324274 defendant Pynder Henry husbandman 594819 594819 Pynder, Henry, of Quaplod, husbandman 2
4892110 2324274 2324274 defendant Thirlowe William husbandman 594819 594819 Thirlowe, William, of Quaplod, husbandman 3
4892111 2324274 2324274 defendant Thomas son of Benet Roger husbandman 586751 586751 Thomas son of Benet, Roger, of Holbech, husbandman 4
4892112 2324274 2324274 defendant Clerk Thomas husbandman 586751 586751 Clerk, Thomas, of Holbech, husbandman 5
4892113 2324274 2324274 defendant Gamull Simon husbandman 594819 594819 Gamull, Simon, of Quaplod, husbandman 6
4892114 2324274 2324274 defendant Everard John husbandman 594819 594819 Everard, John, of Quaplod, husbandman 7
4892115 2324274 2324274 defendant Burnwell William husbandman 594819 594819 Burnwell, William, of Quaplod,husbandman 8
4892116 2324274 2324274 defendant Mosse Katherine widow 594819 594819 Mosse, Katherine, of Quaplod, widow 9
4892117 2324274 2324274 defendant Willyamson Richard laborer 594819 594819 Willyamson, Richard, of Quaplod, laborer 10
4892118 2324274 2324274 defendant Coker Richard husbandman 586751 586751 Coker, Richard, of Holbech, husbandman 11

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