names

14 rows where case_id = 1950230

✎ 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
3775970 1950230 1950230 plaintiff (not given)   abbot of Brewern Abbey   Brewern Abbey, abbot of 0
3775971 1950230 1950230 defendant Morrys William miner 627391 627391 Morrys, William, of Byryngton, miner 0
3775972 1950230 1950230 defendant Fysher Thomas miner 627392 627392 Fysher, Thomas, of Pennette, miner 1
3775973 1950230 1950230 defendant Wekys John miner 625890 625890 Wekys, John, of Compton Martyn, miner 2
3775974 1950230 1950230 defendant Style Robert miner 625890 625890 Style, Robert, of Compton Martyn, miner 3
3775975 1950230 1950230 defendant Mayne Robert miner 625890 625890 Mayne, Robert, of Compton Martyn, miner 4
3775976 1950230 1950230 defendant Pokysstone John miner 627393 627393 Pokysstone, John, of Este Harpetre, miner 5
3775977 1950230 1950230 defendant Murton Thomas miner 627394 627394 Murton, Thomas, of Blackedon, miner 6
3775978 1950230 1950230 defendant Predie William miner 627394 627394 Predie, William, of Blackedon, miner 7
3775979 1950230 1950230 defendant Maynston John miner 627394 627394 Maynston, John, of Blackedon, miner 8
3775980 1950230 1950230 defendant Bultyn John miner 627394 627394 Bultyn, John, of Blackedon, miner 9
3775981 1950230 1950230 defendant Smyth John miner 627394 627394 Smyth, John, of Blackedon, miner 10
3775982 1950230 1950230 defendant Jamys Thomas miner 596054 596054 Jamys, Thomas, of Chedder, miner 11
3775983 1950230 1950230 defendant Hasell John miner 627391 627391 Hasell, John, of Byryngton, miner 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);