names

15 rows where case_id = 2185012

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4450163 2185012 2185012 plaintiff Halgate John     Halgate, John 0
4450164 2185012 2185012 defendant Alesson Thomas   757971 757971 Alesson, Thomas, of Hustewayt 0
4450165 2185012 2185012 defendant Alisson Thomas   757971 757971 Alisson, Thomas, of Hustewayt 1
4450166 2185012 2185012 defendant Mason Henry   757971 757971 Mason, Henry, of Hustewayt 2
4450167 2185012 2185012 defendant Benet John   757971 757971 Benet, John, of Hustewayt 3
4450168 2185012 2185012 defendant Stapilton Emma de formerly wife of Thomas, of Hustewayt   Stapilton, Emma de, formerly wife of Thomas, of Hustewayt 4
4450169 2185012 2185012 defendant Jopson Geoffrey   757971 757971 Jopson, Geoffrey, of Hustewayt 5
4450170 2185012 2185012 defendant Norowd John   757971 757971 Norowd, John, of Hustewayt, son of Robert 6
4450171 2185012 2185012 defendant Nelson William   757971 757971 Nelson, William, of Hustewayt 7
4450172 2185012 2185012 defendant Godryk Thomas     Godryk, Thomas 8
4450173 2185012 2185012 defendant Robynson John     Robynson, John 9
4450174 2185012 2185012 defendant Carleton Thomas de   757971 757971 Carleton, Thomas de, of Hustewayt 10
4450175 2185012 2185012 defendant Colynson Adam   689481 689481 Colynson, Adam, of Ulleston 11
4450176 2185012 2185012 defendant elmet Stephen   689481 689481 elmet, Stephen, of Ulleston 12
4450177 2185012 2185012 defendant Sotter William   689481 689481 Sotter, William, of Ulleston 13

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