names

22 rows where case_id = 2101886

✎ 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
4218247 2101886 2101886 plaintiff Hurt Richard     Hurt, Richard 0
4218248 2101886 2101886 defendant Heald Thomas husbandman 717166 717166 Heald, Thomas, of Grindleforth, husbandman 0
4218249 2101886 2101886 defendant Abell Christopher husbandman 717167 717167 Abell, Christopher, of Leame, husbandman 1
4218250 2101886 2101886 defendant Redferne Richard   717168 717168 Redferne, Richard, of Nether Padley, millstone maker 2
4218251 2101886 2101886 defendant Gregorye Roger husbandman 686339 686339 Gregorye, Roger, of Hathersedge, husbandman 3
4218252 2101886 2101886 defendant Base Thomas laborer 686339 686339 Base, Thomas, of Hathersedge, laborer 4
4218253 2101886 2101886 defendant Swyndell William laborer 686339 686339 Swyndell, William, of Hathersedge, laborer 5
4218254 2101886 2101886 defendant Syddall John laborer 686339 686339 Syddall, John, of Hathersedge, laborer 6
4218255 2101886 2101886 defendant Cowper John laborer 686339 686339 Cowper, John, of Hathersedge, laborer 7
4218256 2101886 2101886 defendant Bricklebancke John laborer 686339 686339 Bricklebancke, John, of Hathersedge, laborer 8
4218257 2101886 2101886 defendant Came or Caine Robert laborer 686339 686339 Came or Caine, Robert, of Hathersedge, laborer 9
4218258 2101886 2101886 defendant Heaton Robert laborer 686339 686339 Heaton, Robert, of Hathersedge, laborer 10
4218259 2101886 2101886 defendant Hodgekynson Denis   717166 717166 Hodgekynson, Denis, of Grindleforth, millstone maker 11
4218260 2101886 2101886 defendant Heyward Thomas   717170 717170 Heyward, Thomas, of Kettlehowse, millstone maker 12
4218261 2101886 2101886 defendant Barker Andrew husbandman 686339 686339 Barker, Andrew, of Hathersedge, husbandman 13
4218262 2101886 2101886 defendant Heald Anthony   686339 686339 Heald, Anthony, of Hathersedge, millstone maker 14
4218263 2101886 2101886 defendant Bamforth John laborer 686339 686339 Bamforth, John, of Hathersedge, yeoman Burrowes, Henry, of Hathersedge, laborer 15
4218264 2101886 2101886 defendant Lucas Robert laborer 686339 686339 Lucas, Robert, of Hathersedge, laborer 16
4218265 2101886 2101886 defendant Eastree Robert   686339 686339 Eastree, Robert, of Hathersedge, millstone maker 17
4218266 2101886 2101886 defendant Dakyn Richard yeoman 593056 593056 Dakyn, Richard, of Padley, yeoman 18
4218267 2101886 2101886 defendant Ferneley Edward laborer 686339 686339 Ferneley, Edward, of Hathersedge, laborer 19
4218268 2101886 2101886 defendant Waynwright John laborer 686339 686339 Waynwright, John, of Hathersedge, laborer 20

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