names

13 rows where case_id = 2033392

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4024351 2033392 2033392 plaintiff Bigilston Philip attorney of the bench   Bigilston, Philip, attorney of the bench 0
4024352 2033392 2033392 defendant Peers Anthony draper 642255 642255 Peers, Anthony, of Tyverton, Devon, draper 0
4024353 2033392 2033392 defendant Dudney William gent 676842 676842 Dudney, William, of Doddescombesley, Devon, gent 1
4024354 2033392 2033392 defendant Lenard Roger tailor 676843 676843 Lenard, Roger, of Kyngesbridge, Devon, tailor 2
4024355 2033392 2033392 defendant Adams Christopher smith 676844 676844 Adams, Christopher, of Colford, Devon, smith 3
4024356 2033392 2033392 defendant Bordfild John gent 586036 586036 Bordfild, John, of Exeter,, gent 4
4024357 2033392 2033392 defendant Strobridge Richard merchant 655894 655894 Strobridge, Richard, of Pynho, Devon, merchant 5
4024358 2033392 2033392 defendant Rysedon Walter husbandman 668778 668778 Rysedon, Walter, of Paynton, Devon, husbandman 6
4024359 2033392 2033392 defendant Cowche Thomas husbandman 676846 676846 Cowche, Thomas, of Sandford, Devon, husbandman 7
4024360 2033392 2033392 defendant Major John husbandman 670741 670741 Major, John, of Alphington, Devon, husbandman 8
4024361 2033392 2033392 defendant Clase John husbandman 676847 676847 Clase, John, of Alphington, husbandman 9
4024362 2033392 2033392 defendant Osworthe Nicholas husbandman 668773 668773 Osworthe, Nicholas, of Stocke Canon, Devon, husbandman 10
4024363 2033392 2033392 defendant Stocker Robert yeoman 662399 662399 Stocker, Robert, of Colford, yeoman 11

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