names

23 rows where case_id = 2208777

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4527152 2208777 2208777 plaintiff Levesham William   586067 586067 Levesham, William, of York 0
4527153 2208777 2208777 defendant Totty Lawrence     Totty, Lawrence 0
4527154 2208777 2208777 defendant Beleby Thomas de     Beleby, Thomas de 1
4527155 2208777 2208777 defendant Couper John   595515 595515 Couper, John, of Fenton 2
4527156 2208777 2208777 defendant Taillour Thomas   597527 597527 Taillour, Thomas, of Stokton 3
4527157 2208777 2208777 defendant Elynson Thomas     Elynson, Thomas 4
4527158 2208777 2208777 defendant Wath Ralph de     Wath, Ralph de 5
4527159 2208777 2208777 defendant Totty John     Totty, John 6
4527160 2208777 2208777 defendant Haldenby Robert   590152 590152 Haldenby, Robert, of Clyfton 7
4527161 2208777 2208777 defendant Foxholes John     Foxholes, John 8
4527162 2208777 2208777 defendant Rudby William     Rudby, William 9
4527163 2208777 2208777 defendant Fareman William     Fareman, William 10
4527164 2208777 2208777 defendant Blythe John de     Blythe, John de 11
4527165 2208777 2208777 defendant Haverbek Thomas     Haverbek, Thomas 12
4527166 2208777 2208777 defendant Godebarn Robert, sen     Godebarn, Robert, sen 13
4527167 2208777 2208777 defendant Godebarn Robert jun   Godebarn, Robert, jun 14
4527168 2208777 2208777 defendant Godebarn Robert son of the same Robert Godebarn, jun   Godebarn, Robert, son of the same Robert Godebarn, jun 15
4527169 2208777 2208777 defendant Abell Robert     Abell, Robert 16
4527170 2208777 2208777 defendant Abell Henry     Abell, Henry 17
4527171 2208777 2208777 defendant Damoly_ William     Damoly_, William 18
4527172 2208777 2208777 defendant Pety Robert     Pety, Robert 19
4527173 2208777 2208777 defendant Pety John jun   Pety, John, jun 20
4527174 2208777 2208777 defendant Pety John son of the same John   Pety, John, son of the same 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);