names

13 rows where case_id = 2379122

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5075332 2379122 2379122 defendant Tanne John butcher 585869 585869 Tanne, John, of London, butcher 0
5075333 2379122 2379122 defendant Perette William butcher 585869 585869 Perette, William, of London, butcher 1
5075334 2379122 2379122 defendant Emson Henry butcher 590479 590479 Emson, Henry,of Southwerk, butcher 2
5075335 2379122 2379122 defendant Mason John butcher 585869 585869 Mason, John, of London, butcher 3
5075336 2379122 2379122 defendant Sholder John butcher 585869 585869 Sholder, John, of London, butcher 4
5075337 2379122 2379122 defendant Stone John butcher 586487 586487 Stone, John, of Suthwerk, butcher 5
5075338 2379122 2379122 defendant Wodeward John butcher 585869 585869 Wodeward, John, of London, butcher 6
5075339 2379122 2379122 defendant Taillour William butcher 585869 585869 Taillour, William, of London, butcher 7
5075340 2379122 2379122 defendant Wheler Benedict butcher 585869 585869 Wheler, Benedict, of London, butcher 8
5075341 2379122 2379122 defendant Bilby of London butcher   Bilby, of London, butcher 9
5075342 2379122 2379122 defendant Bocher Henry butcher 843389 843389 Bocher, Henry, of Holburn, Middx, butcher 10
5075343 2379122 2379122 defendant Forth William butcher 585869 585869 Forth, William, of London, butcher 11
5075344 2379122 2379122 defendant Bocher John butcher 843390 843390 Bocher, John, of Holburn, butcher 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);