names

15 rows where case_id = 1919518

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3679042 1919518 1919518 plaintiff Palmes Nicholas     Palmes, Nicholas 0
3679043 1919518 1919518 defendant Watson Robert husbandman 609558 609558 Watson, Robert, of Gaitfulforde, husbandman 0
3679044 1919518 1919518 defendant Anderson John husbandman 609558 609558 Anderson, John, of Gaitfulforde, husbandman 1
3679045 1919518 1919518 defendant Jakson John husbandman 609559 609559 Jakson, John, of Water Fulforde, husbandman 2
3679046 1919518 1919518 defendant Walshefurth Robert husbandman 609559 609559 Walshefurth, Robert, of Water Fulforde, husbandman 3
3679047 1919518 1919518 defendant Elys Henry husbandman 606257 606257 Elys, Henry, of Dyghton, husbandman 4
3679048 1919518 1919518 defendant Ingleby John husbandman 606257 606257 Ingleby, John, of Dyghton, husbandman 5
3679049 1919518 1919518 defendant Hunte William husbandman 606257 606257 Hunte, William, of Dyghton, husbandman 6
3679050 1919518 1919518 defendant Kyrkby John husbandman 606257 606257 Kyrkby, John, of Dyghton, husbandman 7
3679051 1919518 1919518 defendant Symson Richard husbandman 606257 606257 Symson, Richard, of Dyghton, husbandman 8
3679052 1919518 1919518 defendant Spirman Adam husbandman 606257 606257 Spirman, Adam, of Dyghton, husbandman 9
3679053 1919518 1919518 defendant Fetherston William husbandman 606257 606257 Fetherston, William, of Dyghton, husbandman 10
3679054 1919518 1919518 defendant Trewe Richard husbandman 606257 606257 Trewe, Richard, of Dyghton, husbandman 11
3679055 1919518 1919518 defendant Spice Richard husbandman 606257 606257 Spice, Richard, of Dyghton, husbandman 12
3679056 1919518 1919518 defendant Pulros Robert husbandman 606257 606257 Pulros, Robert, of Dyghton, husbandman 13

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