names

31 rows where case_id = 1870864

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610225 1870864 1870864 plaintiff Vernon Henry knight   Vernon, Henry, knight 0
3610226 1870864 1870864 defendant Eyre Robert, junior gent 593055 593055 Eyre, Robert, junior, of Over Padley, gent 0
3610227 1870864 1870864 defendant Eyre Robert Northeleysse, gent   Eyre, Robert, Northeleysse, gent 1
3610228 1870864 1870864 defendant Eyre Nicholas gent 591227 591227 Eyre, Nicholas, of Hope, gent 2
3610229 1870864 1870864 defendant Balgy Thomas, junior gent 587352 587352 Balgy, Thomas, junior, of Aston, gent 3
3610230 1870864 1870864 defendant Balgy Thomas, senior gent 587352 587352 Balgy, Thomas, senior, of Aston, gent 4
3610231 1870864 1870864 defendant Eyre Thomas gent 593056 593056 Eyre, Thomas, of Padley, gent 5
3610232 1870864 1870864 defendant Eyre Philip     Eyre, Philip 6
3610233 1870864 1870864 defendant Eyre Thomas     Eyre, Thomas 7
3610234 1870864 1870864 defendant Eyre Stephen     Eyre, Stephen 8
3610235 1870864 1870864 defendant Eyre Ralph     Eyre, Ralph 9
3610236 1870864 1870864 defendant Marshall Roger     Marshall, Roger 10
3610237 1870864 1870864 defendant Marshall Henry     Marshall, Henry 11
3610238 1870864 1870864 defendant Halam John     Halam, John 12
3610239 1870864 1870864 defendant Marshall John     Marshall, John 13
3610240 1870864 1870864 defendant Balgy Robert     Balgy, Robert 14
3610241 1870864 1870864 defendant Warde Roger     Warde, Roger 15
3610242 1870864 1870864 defendant Hamore Edward     Hamore, Edward 16
3610243 1870864 1870864 defendant Lowe Thurstan     Lowe, Thurstan 17
3610244 1870864 1870864 defendant Roland Roger     Roland, Roger 18
3610245 1870864 1870864 defendant Dycuns John     Dycuns, John 19
3610246 1870864 1870864 defendant Roworth Robert     Roworth, Robert 20
3610247 1870864 1870864 defendant Treket John     Treket, John 21
3610248 1870864 1870864 defendant Treket Thomas     Treket, Thomas 22
3610249 1870864 1870864 defendant Treket Ralph     Treket, Ralph 23
3610250 1870864 1870864 defendant Slake Henry     Slake, Henry 24
3610251 1870864 1870864 defendant Bokyng Hugh     Bokyng, Hugh 25
3610252 1870864 1870864 defendant Eyre Nicholas     Eyre, Nicholas 26
3610253 1870864 1870864 defendant Morwode John     Morwode, John 27
3610254 1870864 1870864 defendant Hall Thurstan     Hall, Thurstan 28
3610255 1870864 1870864 defendant Bagsha Nicholas     Bagsha, Nicholas 29

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