names

16 rows where case_id = 1932344

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3719382 1932344 1932344 plaintiff Hall John     Hall, John 0
3719383 1932344 1932344 defendant Sherard George gent 617410 617410 Sherard, George, of Stapulford, Leics, gent 0
3719384 1932344 1932344 defendant Mone Thomas yeoman 613270 613270 Mone, Thomas, of Tygh, yeoman 1
3719385 1932344 1932344 defendant Chapman William yeoman 613270 613270 Chapman, William, of Tygh, yeoman 2
3719386 1932344 1932344 defendant Gyng John husbandman 613270 613270 Gyng, John, of Tygh, husbandman 3
3719387 1932344 1932344 defendant Quenborowe William husbandman 613270 613270 Quenborowe, William, of Tygh, husbandman 4
3719388 1932344 1932344 defendant Wade William husbandman 613270 613270 Wade, William, of Tygh, husbandman 5
3719389 1932344 1932344 defendant Mone William     Mone, William 6
3719390 1932344 1932344 defendant Chapman Robert, senior     Chapman, Robert, senior 7
3719391 1932344 1932344 defendant Chapman Robert, junior     Chapman, Robert, junior 8
3719392 1932344 1932344 defendant Waltham Richard     Waltham, Richard 9
3719393 1932344 1932344 defendant Wilcokke William     Wilcokke, William 10
3719394 1932344 1932344 defendant Pulleyn John     Pulleyn, John 11
3719395 1932344 1932344 defendant Grene Richard     Grene, Richard 12
3719396 1932344 1932344 defendant Waltam John     Waltam, John 13
3719397 1932344 1932344 defendant Plonge Thomas     Plonge, Thomas 14

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