names

24 rows where case_id = 2268869

✎ 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
4711250 2268869 2268869 plaintiff Roys Alan mercer 585869 585869 Roys, Alan, of London, mercer 0
4711251 2268869 2268869 plaintiff Skern William     Skern, William 1
4711252 2268869 2268869 plaintiff Tyrell John     Tyrell, John 2
4711253 2268869 2268869 plaintiff Rolf Thomas     Rolf, Thomas 3
4711254 2268869 2268869 plaintiff Whitby John clerk   Whitby, John, clerk 4
4711255 2268869 2268869 plaintiff Rykedon Robert     Rykedon, Robert 5
4711256 2268869 2268869 plaintiff Darcy Robert     Darcy, Robert 6
4711257 2268869 2268869 plaintiff Roys John     Roys, John 7
4711258 2268869 2268869 plaintiff Heuster Thomas     Heuster, Thomas 8
4711259 2268869 2268869 plaintiff Spileman John     Spileman, John 9
4711260 2268869 2268869 plaintiff Fray John     Fray, John 10
4711261 2268869 2268869 plaintiff Duk Guy     Duk, Guy 11
4711262 2268869 2268869 plaintiff Michell Andrew     Michell, Andrew 12
4711263 2268869 2268869 defendant Hoberd Thomas tanner 585874 585874 Hoberd, Thomas, of Hatfeld Peverell, Essex, tanner 0
4711264 2268869 2268869 defendant Colman John yeoman 789062 789062 together with Colman, John, of Falkburn, Essex, yeoman 1
4711265 2268869 2268869 defendant Herde Thomas   600843 600843 Herde, Thomas, of Witham, husb 2
4711266 2268869 2268869 defendant Skilman John husbandman 587920 587920 Skilman, John, of Maldon, husbandman 3
4711267 2268869 2268869 defendant Pulter John   589032 589032 Pulter, John, of White Notley, husb 4
4711268 2268869 2268869 defendant Bryd Edmund husbandman 600843 600843 Bryd, Edmund, of Witham, husbandman 5
4711269 2268869 2268869 defendant Pultere Thomas   789065 789065 Pultere, Thomas, of Withm, husb 6
4711270 2268869 2268869 defendant Mallere William   600843 600843 Mallere, William, of Witham, husb 7
4711271 2268869 2268869 defendant Sakkere John   589032 589032 Sakkere, John, of White Notley, husb 8
4711272 2268869 2268869 defendant Swetyng John cutler 589376 589376 Swetyng, John, of Thaxstede, cutler 9
4711273 2268869 2268869 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);