names

12 rows where place_id = 654100

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3930988 2000696 2000696 defendant Harvyffall or Harnyffall John gent 654100 654100 Harvyffall or Harnyffall, John, of St John Street, Middx, gent 0
4065162 2047823 2047823 plaintiff Harrys Robert esq 654100 654100 Harrys, Robert, of St John Street, Middx, esq 0
4667874 2255651 2255651 defendant Turveye Adam brewer 654100 654100 Turveye, Adam, of St John Street, Middx, brewer 0
4807113 2298423 2298423 plaintiff Blakburn Edmund   654100 654100 Blakburn, Edmund, of St John Street, Middx, tailor, on their own account 1
4993167 2354836 2354836 defendant Neell John clerk 654100 654100 Neell, John, of St John Street, Middx, clerk 2
5136094 2397067 2397067 defendant St George (illegible) gent 654100 654100 St George, ----, of St John Street, Middx, gent 1
5136097 2397068 2397068 defendant St George Baldwin gent 654100 654100 St George, Baldwin, of St John Street, Middx, gent 1
5172311 2407628 2407628 defendant Kerver Henry yeoman 654100 654100 Kerver, Henry, of St John Street, Middx, without the bars of West Smithfield, London, yeoman 0
5311542 2448475 2448475 defendant Horsley Robert gent 654100 654100 Horsley, Robert, of St John Street, Middx, gent 2
5460812 2493182 2493182 defendant Irlond Edward gent 654100 654100 Irlond, Edward, of St John Street, Middx, gent 1
5472414 2496715 2496715 defendant Irlond Edward gent 654100 654100 Irlond, Edward, of St John Street, Middx, gent 0
5476398 2497943 2497943 defendant Bulbek William baker 654100 654100 Bulbek, William, of St John Street, Middx, baker 1

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