names

24 rows where case_id = 2268870

✎ 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
4711274 2268870 2268870 plaintiff Roys Alan mercer 585869 585869 Roys, Alan, of London, mercer 0
4711275 2268870 2268870 plaintiff Skren William     Skren, William 1
4711276 2268870 2268870 plaintiff Tyrell John     Tyrell, John 2
4711277 2268870 2268870 plaintiff Rolf Thomas     Rolf, Thomas 3
4711278 2268870 2268870 plaintiff Whitby John clerk   Whitby, John, clerk 4
4711279 2268870 2268870 plaintiff Rykedon Robert     Rykedon, Robert 5
4711280 2268870 2268870 plaintiff Darcy Robert     Darcy, Robert 6
4711281 2268870 2268870 plaintiff Roys John     Roys, John 7
4711282 2268870 2268870 plaintiff Heuster Thomas     Heuster, Thomas 8
4711283 2268870 2268870 plaintiff Spileman John     Spileman, John 9
4711284 2268870 2268870 plaintiff Fray John     Fray, John 10
4711285 2268870 2268870 plaintiff Duk Guy     Duk, Guy 11
4711286 2268870 2268870 plaintiff Michell Andrew     Michell, Andrew 12
4711287 2268870 2268870 defendant Hoberd Thomas tanner 585874 585874 Hoberd, Thomas, of Hatfeld Peverell, Essex, tanner 0
4711288 2268870 2268870 defendant Colman John yeoman 789062 789062 together with Colman, John, of Falkburn, Essex, yeoman 1
4711289 2268870 2268870 defendant Herde Thomas husbandman 600843 600843 Herde, Thomas, of Witham, husbandman 2
4711290 2268870 2268870 defendant Skilman John husbandman 587920 587920 Skilman, John, of Maldon, husbandman 3
4711291 2268870 2268870 defendant Pulter John husbandman 589032 589032 Pulter, John, of White Notley, husbandman 4
4711292 2268870 2268870 defendant Bryd Edmund husbandman 600843 600843 Bryd, Edmund, of Witham, husbandman 5
4711293 2268870 2268870 defendant Pultere Thomas husbandman 600843 600843 Pultere, Thomas, of Witham, husbandman 6
4711294 2268870 2268870 defendant Mellere William husbandman 600843 600843 Mellere, William, of Witham, husbandman 7
4711295 2268870 2268870 defendant Saklere John husbandman 589032 589032 Saklere, John, of White Notley, husbandman 8
4711296 2268870 2268870 defendant Swetyng John cutler 589376 589376 Swetyng, John, of Thaxstede, cutler 9
4711297 2268870 2268870 defendant Vynter William laborer 600843 600843 Vynter, William, of Witham, laborer 10

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