names

17 rows where case_id = 2235148

✎ 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
4613071 2235148 2235148 plaintiff Curson John (legal representative) 755389 755389 Curson, John, of Bishop's Lenn, executors of 0
4613072 2235148 2235148 plaintiff Beteryng John de     (Beteryng, John de 1
4613073 2235148 2235148 plaintiff Trute Thomas     Trute, Thomas 2
4613074 2235148 2235148 plaintiff Swanton Andrew     Swanton, Andrew 3
4613075 2235148 2235148 plaintiff Todenham Walter   755389 755389 Todenham, Walter, of Bishop's Lenn, burgess 4
4613076 2235148 2235148 defendant Buke John   612532 612532 Buke, John, of Beston 0
4613077 2235148 2235148 defendant Smyth Nicholas   774522 774522 Smyth, Nicholas, of Creyek 1
4613078 2235148 2235148 defendant Smyth Richard   599140 599140 Smyth, Richard, of Barsham 2
4613079 2235148 2235148 defendant Prowdeberd James   599093 599093 Prowdeberd, James, of Cougham 3
4613080 2235148 2235148 defendant Meryell William   597928 597928 Meryell, William, of Melred 4
4613081 2235148 2235148 defendant Bakwell Robert Oundell   Bakwell, Robert, Oundell 5
4613082 2235148 2235148 defendant Skynner John   774523 774523 Skynner, John, of Hawalton 6
4613083 2235148 2235148 defendant Pavell Thomas   774524 774524 Pavell, Thomas, of Rydeswell 7
4613084 2235148 2235148 defendant Dykon Thomas   611254 611254 Dykon, Thomas, of Bedeford 8
4613085 2235148 2235148 defendant Smyth Nicholas   591495 591495 Smyth, Nicholas, of Dodyngton 9
4613086 2235148 2235148 defendant Porynge John smith 761702 761702 Porynge, John, of Marcheford, smith 10
4613087 2235148 2235148 defendant Grene Thomas   589617 589617 Grene, Thomas, of Dounham 11

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