names

13 rows where case_id = 2517882

✎ 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
5542841 2517882 2517882 plaintiff Neell Richard     Neell, Richard 0
5542842 2517882 2517882 defendant Porter Robert gent 636776 636776 Porter, Robert, of Over Etyngton, gent 0
5542843 2517882 2517882 defendant Rysshall Thomas husbandman 636776 636776 Rysshall, Thomas, of Over Etyngton, husbandman 1
5542844 2517882 2517882 defendant Colyn Thomas husbandman 636776 636776 Colyn, Thomas, of Over Etyngton, husbandman 2
5542845 2517882 2517882 defendant Bousher Roger husbandman 636776 636776 Bousher, Roger, of Over Etyngton, husbandman 3
5542846 2517882 2517882 defendant Benet John husbandman 636776 636776 Benet, John, of Over Etyngton, husbandman 4
5542847 2517882 2517882 defendant Colyn William husbandman 636776 636776 Colyn, William, of Over Etyngton, husbandman 5
5542848 2517882 2517882 defendant Fauconer John husbandman 636776 636776 Fauconer, John, of Over Etyngton, husbandman 6
5542849 2517882 2517882 defendant Floder John husbandman 636776 636776 Floder, John, of Over Etyngton, husbandman 7
5542850 2517882 2517882 defendant Saunder James husbandman 636776 636776 Saunder, James, of Over Etyngton, husbandman 8
5542851 2517882 2517882 defendant Colyn Thomas, senior husbandman 636776 636776 Colyn, Thomas, senior, of Over Etyngton, husbandman 9
5542852 2517882 2517882 defendant Colyn Thomas, junior husbandman 636776 636776 Colyn, Thomas, junior, of Over Etyngton, husbandman 10
5542853 2517882 2517882 defendant Aley Thomas husbandman 636776 636776 Aley, Thomas, of Over Etyngton, husbandman 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);