names

17 rows where case_id = 2383206

✎ 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
5089167 2383206 2383206 plaintiff Lenche Thomas     Lenche, Thomas 0
5089168 2383206 2383206 defendant Tanne John butcher 585869 585869 Tanne, John, of London, butcher 0
5089169 2383206 2383206 defendant Perette William butcher 585869 585869 Perette, William, of London, butcher 1
5089170 2383206 2383206 defendant Machon John butcher 585869 585869 Machon, John, of London, butcher 2
5089171 2383206 2383206 defendant Emson Henry butcher 590479 590479 Emson, Henry, of Southwerk, butcher 3
5089172 2383206 2383206 defendant Wodeward John butcher 585869 585869 Wodeward, John, of London, butcher 4
5089173 2383206 2383206 defendant Taillour William butcher 585869 585869 Taillour, William, of London, butcher 5
5089174 2383206 2383206 defendant Wheler Benedict butcher 585869 585869 Wheler, Benedict, of London, butcher 6
5089175 2383206 2383206 defendant Stone John butcher 586487 586487 Stone, John, of Suthwerk, butcher 7
5089176 2383206 2383206 defendant Bilby Richard butcher 585869 585869 Bilby, Richard, of London, butcher 8
5089177 2383206 2383206 defendant Bocher Henry butcher 843389 843389 Bocher, Henry, of Holburn, Middx, butcher 9
5089178 2383206 2383206 defendant North William butcher 585869 585869 North, William, of London, butcher 10
5089179 2383206 2383206 defendant Bocher John butcher 843390 843390 Bocher, John, of Holburn, butcher 11
5089180 2383206 2383206 defendant Heyd Thomas ofLondon, butcher   Heyd, Thomas,ofLondon,butcher 12
5089181 2383206 2383206 defendant Stokes Thomas butcher 585869 585869 Stokes, Thomas, of London, butcher 13
5089182 2383206 2383206 defendant Stone John (legal representative)   Stone, John, executrix of 14
5089183 2383206 2383206 defendant Stone Christine widow 585869 585869 Stone, Christine, of London, widow 15

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