names

15 rows where case_id = 2184747

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4449355 2184747 2184747 plaintiff Gloucester   in   Gloucester, abbot of St Peter's, in 0
4449356 2184747 2184747 defendant Somury John   587657 587657 Somury, John, of North Lech 0
4449357 2184747 2184747 defendant Skynnere Robert   587657 587657 Skynnere, Robert, of North Lech 1
4449358 2184747 2184747 defendant shepherd Thomas   587657 587657 shepherd, Thomas, of North Lech 2
4449359 2184747 2184747 defendant Walkere John   587657 587657 Walkere, John, of North Lech 3
4449360 2184747 2184747 defendant Smyth William   587657 587657 Smyth, William, of North Lech 4
4449361 2184747 2184747 defendant Harpour John   587657 587657 Harpour, John, of North Lech 5
4449362 2184747 2184747 defendant Fraunceys John     Fraunceys, John 6
4449363 2184747 2184747 defendant Roo Henry le     Roo, Henry le 7
4449364 2184747 2184747 defendant Chapman Richard   587657 587657 Chapman, Richard, of North Lech 8
4449365 2184747 2184747 defendant Yateman John     Yateman, John 9
4449366 2184747 2184747 defendant Borsford Richard     Borsford, Richard 10
4449367 2184747 2184747 defendant Porter Philip   587657 587657 Porter, Philip, of North Lech 11
4449368 2184747 2184747 defendant Collarn Richard     Collarn, Richard 12
4449369 2184747 2184747 defendant Colpton Joan de   587657 587657 Colpton, Joan de, of North Lech 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);