names

23 rows where case_id = 2512730

✎ 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
5526022 2512730 2512730 plaintiff Hobart James     Hobart, James 0
5526023 2512730 2512730 defendant Dulcombe William gent 585970 585970 Dulcombe, William, of Oxford, gent 0
5526024 2512730 2512730 defendant Harveys William gent 896398 896398 Harveys, William, of Milton Harveys, Geds, gent 1
5526025 2512730 2512730 defendant Nevyll Thomas gent 590437 590437 Nevyll, Thomas, of Dorchester, Oxon, gent 2
5526026 2512730 2512730 defendant Knyght Thomas gent 589851 589851 Knyght, Thomas, of Dorchester, gent 3
5526027 2512730 2512730 defendant Knyght John gent 589851 589851 Knyght, John, of Dorchester, gent 4
5526028 2512730 2512730 defendant Pole Christopher     Pole, Christopher 5
5526029 2512730 2512730 defendant Taillour Henry     Taillour, Henry 6
5526030 2512730 2512730 defendant Foweler William     Foweler, William 7
5526031 2512730 2512730 defendant Newman Reginald     Newman, Reginald 8
5526032 2512730 2512730 defendant Broun Wiston     Broun, Wiston 9
5526033 2512730 2512730 defendant Lewes Thomas     Lewes, Thomas 10
5526034 2512730 2512730 defendant FitzGeffrey John     FitzGeffrey, John 11
5526035 2512730 2512730 defendant Gedy John     Gedy, John 12
5526036 2512730 2512730 defendant Keweney Leonard     Keweney, Leonard 13
5526037 2512730 2512730 defendant Smyth Thomas     Smyth, Thomas 14
5526038 2512730 2512730 defendant Bruan William     Bruan, William 15
5526039 2512730 2512730 defendant Elwode Robert     Elwode, Robert 16
5526040 2512730 2512730 defendant Miller Nicholas     Miller, Nicholas 17
5526041 2512730 2512730 defendant Hochyn John     Hochyn, John 18
5526042 2512730 2512730 defendant Myll John     Myll, John 19
5526043 2512730 2512730 defendant Cokkys Richard     Cokkys, Richard 20
5526044 2512730 2512730 defendant Dunwych John     Dunwych, John 21

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