names

20 rows where place_id = 686339

✎ 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
4066323 2048245 2048245 plaintiff Holland Nicholas gent 686339 686339 Holland, Nicholas, of Hathersedge, gent 0
4215254 2100830 2100830 defendant Barker alias Hakesworth Hugh carpenter 686339 686339 Barker alias Hakesworth, Hugh, of Hathersedge, carpenter 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
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
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
4319094 2136795 2136795 defendant Barker alias Hawkesworth John husbandman 686339 686339 Barker alias Hawkesworth, John, of Hathersedge, husbandman 1
4319096 2136796 2136796 defendant Barker alias Hawkesworth John husbandman 686339 686339 Barker alias Hawkesworth, John, of Hathersedge, husbandman 0
4403360 2165692 2165692 defendant Dakyn Richard yeoman 686339 686339 Dakyn, Richard, of Hathersedge, yeoman 0

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