names

16 rows where case_id = 1991900

✎ 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
3904887 1991900 1991900 plaintiff Huntley John     Huntley, John 0
3904888 1991900 1991900 defendant Baskerfeld Thomas gent 649084 649084 Baskerfeld, Thomas, of Netherwood, Heref, gent 0
3904889 1991900 1991900 defendant Moreton Thomas yeoman 614895 614895 Moreton, Thomas, of Magna Teyngton, yeoman 1
3904890 1991900 1991900 defendant Wattys William husbandman 587914 587914 Wattys, William, of Compton, husbandman 2
3904891 1991900 1991900 defendant Wele William husbandman 590714 590714 Wele, William, of Magna Teynton, husbandman 3
3904892 1991900 1991900 defendant Ellye John husbandman 590714 590714 Ellye, John, of Magna Teynton, husbandman 4
3904893 1991900 1991900 defendant Horne Edward husbandman 590714 590714 Horne, Edward, of Magna Teynton, husbandman 5
3904894 1991900 1991900 defendant Fyssher Roger shoemaker 590714 590714 Fyssher, Roger, of Magna Teynton, shoemaker 6
3904895 1991900 1991900 defendant Adys John husbandman 588010 588010 Adys, John, of Newent, husbandman 7
3904896 1991900 1991900 defendant Hartland John husbandman 590714 590714 Hartland, John, of Magna Teynton, husbandman 8
3904897 1991900 1991900 defendant Horne Richard husbandman 649085 649085 Horne, Richard, of Hartburye, husbandman 9
3904898 1991900 1991900 defendant Fawkener John collier 590714 590714 Fawkener, John, of Magna Teynton, collier 10
3904899 1991900 1991900 defendant Dale Philip collier 590714 590714 Dale, Philip, of Magna Teynton, collier 11
3904900 1991900 1991900 defendant Philippes John laborer 601198 601198 Philippes, John, of Pauntley, laborer 12
3904901 1991900 1991900 defendant Bond John laborer 601198 601198 Bond, John, of Pauntley, laborer 13
3904902 1991900 1991900 defendant Cradock Hugh laborer 590714 590714 Cradock, Hugh,of Magna Teynton, laborer 14

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