names

10 rows where place_id = 586671

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589337 1864306 1864306 defendant Barnard Benedict gent 586671 586671 Barnard, Benedict, of St Mary Strond, Middx, gent 2
3774182 1949638 1949638 defendant Baron George innholder 586671 586671 Baron, George, of St Mary Strond, Middx, innholder 0
4963932 2346123 2346123 defendant Nowers Richard gent 586671 586671 Nowers, Richard, of St Mary Strond, Middx, gent 1
4974629 2349378 2349378 defendant Huntyngdon John gent 586671 586671 Huntyngdon, John, of St Mary Strond, Middx, gent 0
5014219 2361009 2361009 defendant Huntyngdon John brewer 586671 586671 Huntyngdon, John, of St Mary Strond, Middx, brewer 3
5060909 2374835 2374835 defendant Osbarn Robert gent 586671 586671 Osbarn, Robert, of St Mary Strond, Middx, gent 0
5282292 2439880 2439880 defendant Turges Richard gent 586671 586671 Turges, Richard, of St Mary Strond, Middx, gent 0
5282294 2439881 2439881 defendant Turges Richard gent 586671 586671 Turges, Richard, of St Mary Strond, Middx, gent 0
5284688 2440535 2440535 defendant Osbarn Richard gent 586671 586671 Osbarn, Richard, of St Mary Strond, Middx, gent 2
5532944 2514846 2514846 defendant Watson Andrew tailor 586671 586671 Watson, Andrew, of St Mary Strond, Middx, tailor 0

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