names

23 rows where case_id = 2268871

✎ 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
4711298 2268871 2268871 plaintiff Roys Alan mercer 585869 585869 Roys, Alan, of London, mercer 0
4711299 2268871 2268871 plaintiff Skren William     Skren, William 1
4711300 2268871 2268871 plaintiff Tyrell John     Tyrell, John 2
4711301 2268871 2268871 plaintiff Rolf Thomas     Rolf, Thomas 3
4711302 2268871 2268871 plaintiff Whitby John clerk   Whitby, John, clerk 4
4711303 2268871 2268871 plaintiff Rykedon Robert     Rykedon, Robert 5
4711304 2268871 2268871 plaintiff Darcy Robert     Darcy, Robert 6
4711305 2268871 2268871 plaintiff Roys John     Roys, John 7
4711306 2268871 2268871 plaintiff Heuster Thomas     Heuster, Thomas 8
4711307 2268871 2268871 plaintiff Spileman John     Spileman, John 9
4711308 2268871 2268871 plaintiff Fray John     Fray, John 10
4711309 2268871 2268871 plaintiff Duk Guy     Duk, Guy 11
4711310 2268871 2268871 plaintiff Michell Andrew     Michell, Andrew 12
4711311 2268871 2268871 defendant Colman John yeoman 789062 789062 Colman, John, of Falkburn, Essex, yeoman 0
4711312 2268871 2268871 defendant Herde Thomas husbandman 600843 600843 Herde, Thomas, of Witham, husbandman 1
4711313 2268871 2268871 defendant Skilman John husbandman 587920 587920 Skilman, John, of Maldon, husbandman 2
4711314 2268871 2268871 defendant Pulter John husbandman 589032 589032 Pulter, John, of White Notley, husbandman 3
4711315 2268871 2268871 defendant Bryd Edmund husbandman 600843 600843 Bryd, Edmund, of Witham, husbandman 4
4711316 2268871 2268871 defendant Pultere Thomas husbandman 600843 600843 Pultere, Thomas, of Witham, husbandman 5
4711317 2268871 2268871 defendant Mellere William   789066 789066 Mellere, William, of Witham, husbandamn 6
4711318 2268871 2268871 defendant Saklere John husbandman 589032 589032 Saklere, John, of White Notley, husbandman 7
4711319 2268871 2268871 defendant Swetyng John cutler 589376 589376 Swetyng, John, of Thaxstede, cutler 8
4711320 2268871 2268871 defendant Vynter William laborer 600843 600843 Vynter, William, of Witham, laborer 9

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