names

17 rows where case_id = 2248379

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4657969 2248379 2248379 plaintiff Conyers Margaret     Conyers, Margaret 0
4657970 2248379 2248379 defendant Porter Thomas husbandman 585995 585995 Porter, Thomas, of Neweton Morker, husbandman 0
4657971 2248379 2248379 defendant Gefson William husbandman 585995 585995 Gefson, William, of Neweton Morker, husbandman 1
4657972 2248379 2248379 defendant Lemyng Richard husbandman 585995 585995 Lemyng, Richard, of Neweton Morker, husbandman 2
4657973 2248379 2248379 defendant Hunton William husbandman 585995 585995 Hunton, William, of Neweton Morker, husbandman 3
4657974 2248379 2248379 defendant Lytster Thomas husbandman 585995 585995 Lytster, Thomas, of Neweton Morker, husbandman 4
4657975 2248379 2248379 defendant Shephyrd William husbandman 585995 585995 Shephyrd, William, of Neweton Morker, husbandman 5
4657976 2248379 2248379 defendant Nicolson Thomas husbandman 585995 585995 Nicolson, Thomas, of Neweton Morker, husbandman 6
4657977 2248379 2248379 defendant Smyth Adam husbandman 585995 585995 Smyth, Adam, of Neweton Morker, husbandman 7
4657978 2248379 2248379 defendant More John husbandman 585995 585995 More, John, of Neweton Morker, husbandman 8
4657979 2248379 2248379 defendant Spense John husbandman 585995 585995 Spense, John, of Neweton Morker, husbandman 9
4657980 2248379 2248379 defendant Gefson John husbandman 585995 585995 Gefson, John, of Neweton Morker, husbandman 10
4657981 2248379 2248379 defendant Carter Stephen husbandman 585995 585995 Carter, Stephen, of Neweton Morker, husbandman 11
4657982 2248379 2248379 defendant Pygot John husbandman 585995 585995 Pygot, John, of Neweton Morker, husbandman 12
4657983 2248379 2248379 defendant del Kechyn Thomas husbandman 672756 672756 del Kechyn, Thomas, of Est Brompton, husbandman 13
4657984 2248379 2248379 defendant Hardy Thomas husbandman 672756 672756 Hardy, Thomas, of Est Brompton, husbandman 14
4657985 2248379 2248379 defendant Wynspere John husbandman 672756 672756 Wynspere, John, of Est Brompton, husbandman 15

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