names

27 rows where place_id = 601331

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3644854 1908799 1908799 defendant Bladys Stephen yeoman 601331 601331 Bladys, Stephen, of Sledmer, yeoman 0
3814863 1962564 1962564 defendant Banke John husbandman 601331 601331 Banke, John, of Sledmer, husbandman 1
4054341 2043943 2043943 defendant Netleton Robert gent 601331 601331 Netleton, Robert, of Sledmer, gent 0
4054342 2043943 2043943 defendant Netleton Elizabeth widow 601331 601331 Elizabeth his wife, formerly Elizabeth Swandell, of Sledmer, widow 1
4444648 2183304 2183304 plaintiff Collom Joan de   601331 601331 Collom, Joan de, of Sledmer, wife of Robert 0
4444649 2183304 2183304 plaintiff Collum Thomas de   601331 601331 Collum, Thomas de, of Sledmer, son of Robert 1
4584059 2226434 2226434 plaintiff Geffray John   601331 601331 Geffray, John, of Sledmer 0
4584060 2226434 2226434 defendant Jonson John smith 601331 601331 Jonson, John, of Sledmer, smith 0
4705158 2266984 2266984 defendant Ledys Robert yeoman 601331 601331 Ledys, Robert, of Sledmer, yeoman 0
4783763 2290943 2290943 defendant Darnelove Thomas laborer 601331 601331 Darnelove, Thomas, of Sledmer, laborer 0
4790822 2293220 2293220 plaintiff Ledes Robert   601331 601331 Ledes, Robert, of Sledmer 0
4834855 2306905 2306905 defendant Ledes Robert gent 601331 601331 Ledes, Robert, of Sledmer, gent 0
4842130 2309073 2309073 defendant Ledes Robert gent 601331 601331 Ledes, Robert, of Sledmer, gent 0
4846042 2310267 2310267 defendant Halskarth John smith 601331 601331 Halskarth, John, of Sledmer, smith 0
4861808 2315069 2315069 defendant Ledes Robert gent 601331 601331 Ledes, Robert, of Sledmer, gent 0
4869626 2317462 2317462 defendant Lodes Robert gent 601331 601331 Lodes, Robert, of Sledmer, gent 0
4896675 2325622 2325622 defendant Ledys Robert gent 601331 601331 Ledys, Robert, of Sledmer, gent 0
4908628 2329252 2329252 defendant Halsbarth John husbandman 601331 601331 Halsbarth, John, of Sledmer, husbandman 3
4928816 2335433 2335433 defendant Ledes Robert   601331 601331 Ledes, Robert, of Sledmer 0
4959894 2344921 2344921 defendant Pacok William husbandman 601331 601331 Pacok, William, of Sledmer, husbandman 1
4968477 2347540 2347540 defendant Wester Thomas husbandman 601331 601331 Wester, Thomas, of Sledmer, husbandman 0
4968478 2347540 2347540 defendant Sawer John husbandman 601331 601331 Sawer, John, of Sledmer, husbandman 1
5009042 2359529 2359529 defendant Ledis William gent 601331 601331 Ledis, William, of Sledmer, gent 0
5035640 2367281 2367281 defendant Ledes William gent 601331 601331 Ledes, William, of Sledmer, gent 0
5101264 2386779 2386779 defendant Gatilwod John laborer 601331 601331 Gatilwod, John, of Sledmer, laborer 3
5235961 2426101 2426101 defendant Cape William husbandman 601331 601331 Cape, William, of Sledmer, husbandman 0
5296181 2443873 2443873 defendant Ledys John gent 601331 601331 Ledys, John, of Sledmer, gent 2

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