names

14 rows where case_id = 2203245

✎ 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
4508847 2203245 2203245 plaintiff Armeston William     Armeston, William 0
4508848 2203245 2203245 defendant Bewatre John     Bewatre, John 0
4508849 2203245 2203245 defendant Grace John draper 585869 585869 Grace, John, of London, draper 1
4508850 2203245 2203245 defendant Chapman Alan collier 764716 764716 Chapman, Alan, of Wolkstede, collier 2
4508851 2203245 2203245 defendant Perot Thomas     Perot, Thomas 3
4508852 2203245 2203245 defendant Doune Thomas   588882 588882 together with Doune, Thomas, of Retherfeld 4
4508853 2203245 2203245 defendant Skynner Thomas forester   Skynner, Thomas, forester 5
4508854 2203245 2203245 defendant Chapman John   588882 588882 Chapman, John, of Retherfeld 6
4508855 2203245 2203245 defendant Swayneslond Andrew     Swayneslond, Andrew 7
4508856 2203245 2203245 defendant Pokestye Robert     Pokestye, Robert 8
4508857 2203245 2203245 defendant Shedewell Thomas     Shedewell, Thomas 9
4508858 2203245 2203245 defendant Werengle John     Werengle, John 10
4508859 2203245 2203245 defendant Galop John     Galop, John 11
4508860 2203245 2203245 defendant Boyshudde Richard     Boyshudde, Richard 12

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