names

36 rows where case_id = 2512832

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename

id ▼ case_id role surname forename occupation place_id raw_segment seq
5526400 2512832 2512832 plaintiff Huby Marmaduke abbot of Fountains Abbey   Huby, Marmaduke, abbot of Fountains Abbey 0
5526401 2512832 2512832 defendant Willesthorp Miles esq 588774 588774 Willesthorp, Miles, of Willesthorp, esq 0
5526402 2512832 2512832 defendant Topham William Willesthorp, walker   Topham, William, Willesthorp, walker 1
5526403 2512832 2512832 defendant Lawson William     Lawson, William 2
5526404 2512832 2512832 defendant Topham Robert     Topham, Robert 3
5526405 2512832 2512832 defendant Spynke John     Spynke, John 4
5526406 2512832 2512832 defendant Thurstane Robert     Thurstane, Robert 5
5526407 2512832 2512832 defendant Johnson William     Johnson, William 6
5526408 2512832 2512832 defendant Stott Anthony     Stott, Anthony 7
5526409 2512832 2512832 defendant Nelson John     Nelson, John 8
5526410 2512832 2512832 defendant Nelson Ralph     Nelson, Ralph 9
5526411 2512832 2512832 defendant Spynke Thomas     Spynke, Thomas 10
5526412 2512832 2512832 defendant Gibson William     Gibson, William 11
5526413 2512832 2512832 defendant Beke Richard     Beke, Richard 12
5526414 2512832 2512832 defendant Richardson Brian     Richardson, Brian 13
5526415 2512832 2512832 defendant Topsham Henry     Topsham, Henry 14
5526416 2512832 2512832 defendant Lawson Thomas     Lawson, Thomas 15
5526417 2512832 2512832 defendant Proktour Roger     Proktour, Roger 16
5526418 2512832 2512832 defendant Bateson John     Bateson, John 17
5526419 2512832 2512832 defendant Halis Robert     Halis, Robert 18
5526420 2512832 2512832 defendant Eland Henry     Eland, Henry 19
5526421 2512832 2512832 defendant Bolton Thomas     Bolton, Thomas 20
5526422 2512832 2512832 defendant Thomlynson William     Thomlynson, William 21
5526423 2512832 2512832 defendant Hunsyngore William     Hunsyngore, William 22
5526424 2512832 2512832 defendant Smyth John     Smyth, John 23
5526425 2512832 2512832 defendant Abbey Thomas     Abbey, Thomas 24
5526426 2512832 2512832 defendant Wrey John     Wrey, John 25
5526427 2512832 2512832 defendant Hunter John, senior     Hunter, John, senior 26
5526428 2512832 2512832 defendant Hunter John, junior     Hunter, John, junior 27
5526429 2512832 2512832 defendant Stag Miles     Stag, Miles 28
5526430 2512832 2512832 defendant Ketilwell Robert     Ketilwell, Robert 29
5526431 2512832 2512832 defendant Eys Robert     Eys, Robert 30
5526432 2512832 2512832 defendant Coke Thomas     Coke, Thomas 31
5526433 2512832 2512832 defendant Leyke Richard     Leyke, Richard 32
5526434 2512832 2512832 defendant Herryson Richard     Herryson, Richard 33
5526435 2512832 2512832 defendant Stokdall Richard     Stokdall, Richard 34

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