names

14 rows where case_id = 2021335

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3990436 2021335 2021335 plaintiff Bigilston Philip gent, attorney of the bench   Bigilston, Philip, gent, attorney of the bench 0
3990437 2021335 2021335 defendant Babbe Richard yeoman 668766 668766 Babbe, Richard, of Teingrace, Devon, yeoman 0
3990438 2021335 2021335 defendant Vylbayne Thomas   588808 588808 Vylbayne, Thomas, of Brodeclyst, Devon gent 1
3990439 2021335 2021335 defendant Kingwell William yeoman 668768 668768 Kingwell, William, of Cheriton Bishop, Devon, yeoman 2
3990440 2021335 2021335 defendant Sture Barnard husbandman 668769 668769 Sture, Barnard, of Cheriton Bishop, husbandman 3
3990441 2021335 2021335 defendant Cove Richard husbandman 668770 668770 Cove, Richard, of Boundley, Devon, husbandman 4
3990442 2021335 2021335 defendant Knapman William tinner 668771 668771 Knapman, William, of Throughley, Devon, tinner 5
3990443 2021335 2021335 defendant Knapman John tinner 668772 668772 Knapman, John, of Throughley, tinner 6
3990444 2021335 2021335 defendant Gaye Thomas weaver 668773 668773 Gaye, Thomas, of Stocke Canon, Devon, weaver 7
3990445 2021335 2021335 defendant Drewe Thomasine widow 668774 668774 Drewe, Thomasine, of Hobeton, Devon, widow 8
3990446 2021335 2021335 defendant Davye John smith 668775 668775 Davye, John, of Witherudge, Devon, smith 9
3990447 2021335 2021335 defendant Babbe Robert yeoman 668776 668776 Babbe, Robert, of Dawogh, Devon, yeoman 10
3990448 2021335 2021335 defendant Langbridge Walter husbandman 668777 668777 Langbridge, Walter, of Bunley, Devon, husbandman 11
3990449 2021335 2021335 defendant Risedon Walter weaver 668778 668778 Risedon, Walter, of Paynton, Devon, weaver 12

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