names

12 rows where case_id = 2323997

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4891261 2323997 2323997 plaintiff Macworth John clerk   Macworth, John, clerk 0
4891262 2323997 2323997 defendant Knyveton Agnes widow 601780 601780 Knyveton, Agnes, of Assheburne, widow 0
4891263 2323997 2323997 defendant Serle Richard husbandman 818080 818080 Serle, Richard, of Malefeld, Staffs, husbandman 1
4891264 2323997 2323997 defendant Stanlowe Thomas husbandman 588959 588959 Stanlowe, Thomas, of Mapulton, husbandman 2
4891265 2323997 2323997 defendant Elyot John husbandman 588959 588959 Elyot, John, of Mapulton, husbandman 3
4891266 2323997 2323997 defendant Bagger John butcher 601780 601780 Bagger, John, of Assheburne, butcher 4
4891267 2323997 2323997 defendant Alenson Thomas yeoman 591850 591850 Alenson, Thomas, of Bradley, yeoman 5
4891268 2323997 2323997 defendant Hobson Richard husbandman 588958 588958 Hobson, Richard, of Perwyche, husbandman 6
4891269 2323997 2323997 defendant Harryson John husbandman 588958 588958 Harryson, John, of Perwyche, husbandman 7
4891270 2323997 2323997 defendant Bradburne John esq   Bradburne, John, esq, executors of 8
4891271 2323997 2323997 defendant Storterede Henry parson of Kirke Ireton   (Storterede, Henry, parson of Kirke Ireton 9
4891272 2323997 2323997 defendant Forde John del Hough, chaplain   Forde, John, del Hough, chaplain 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);