names

12 rows where case_id = 2341589

✎ 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
4948735 2341589 2341589 plaintiff (not given)   abbot of Meaux Abbey   Meaux Abbey, abbot of 0
4948736 2341589 2341589 defendant Bate Robert   789057 789057 Bate, Robert, of Waghn, wright 0
4948737 2341589 2341589 defendant Bate John   789057 789057 Bate, John, of Waghn, wright 1
4948738 2341589 2341589 defendant Warde William husbandman 789057 789057 Warde, William, of Waghn, husbandman 2
4948739 2341589 2341589 defendant Payntour Thomas husbandman 789057 789057 Payntour, Thomas, of Waghn, husbandman 3
4948740 2341589 2341589 defendant Tomson John husbandman 640355 640355 Tomson, John, of Otryngham, husbandman 4
4948741 2341589 2341589 defendant Cristofer John husbandman 640355 640355 Cristofer, John, of Otryngham, husbandman 5
4948742 2341589 2341589 defendant Drypole John, senior husbandman 640355 640355 Drypole, John, senior, of Otryngham, husbandman 6
4948743 2341589 2341589 defendant Kirke Thomas husbandman 603600 603600 Kirke, Thomas, of Catfosse, husbandman 7
4948744 2341589 2341589 defendant Rayner Stephen husbandman 589274 589274 Rayner, Stephen, of Cotyngham, husbandman 8
4948745 2341589 2341589 defendant Tomson William husbandman 589274 589274 Tomson, William, of Cotyngham, husbandman 9
4948746 2341589 2341589 defendant Cartewryght Thomas husbandman 589274 589274 Cartewryght, Thomas, of Cotyngham, husbandman 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);