names

17 rows where case_id = 2424759

✎ 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
5231320 2424759 2424759 plaintiff Blenkensop Thomas     Blenkensop, Thomas 0
5231321 2424759 2424759 defendant Richardson Robynson William yeoman 589420 589420 Richardson Robynson, William, of Crosby Garet, yeoman 0
5231322 2424759 2424759 defendant Richardson Robynson John yeoman 588481 588481 Richardson Robynson, John, of Appulby, yeoman 1
5231323 2424759 2424759 defendant Richardson Robynson Thomas yeoman 862060 862060 Richardson Robynson, Thomas, of Ruthowr, yeoman 2
5231324 2424759 2424759 defendant Richardson Robynson James yeoman 862060 862060 Richardson Robynson, James, of Ruthowr, yeoman 3
5231325 2424759 2424759 defendant Richardson Robynson Henry yeoman 589420 589420 Richardson Robynson, Henry, of Crosby Garet, yeoman 4
5231326 2424759 2424759 defendant Williamson Robynson John yeoman 862061 862061 Williamson Robynson, John, of Halowgill, yeoman 5
5231327 2424759 2424759 defendant Robertson William yeoman 862062 862062 Robertson, William, of Magna Asbe, yeoman 6
5231328 2424759 2424759 defendant Parkyn John yeoman 589420 589420 Parkyn, John, of Crosby Garet, yeoman 7
5231329 2424759 2424759 defendant Parkyn Roland yeoman 589420 589420 Parkyn, Roland, of Crosby Garet, yeoman 8
5231330 2424759 2424759 defendant Atkynson Thomas     Atkynson, Thomas 9
5231331 2424759 2424759 defendant Hertley John     Hertley, John 10
5231332 2424759 2424759 defendant Kunkstub John     Kunkstub, John 11
5231333 2424759 2424759 defendant Rowkyn Rowland     Rowkyn, Rowland 12
5231334 2424759 2424759 defendant Thomlynson Richard     Thomlynson, Richard 13
5231335 2424759 2424759 defendant Middelton Geoffrey     Middelton, Geoffrey 14
5231336 2424759 2424759 defendant Middelton Edward     Middelton, Edward 15

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