names

23 rows where case_id = 2007546

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3951360 2007546 2007546 plaintiff Gryffyth Walter esq   Gryffyth, Walter, esq 0
3951361 2007546 2007546 defendant Seynquintyn Gabriel esq 659160 659160 Seynquintyn, Gabriel, of Harpam, esq 0
3951362 2007546 2007546 defendant Asshe William husbandman 659160 659160 Asshe, William, of Harpam, husbandman 1
3951363 2007546 2007546 defendant Clerkson Robert laborer 659160 659160 Clerkson, Robert, of Harpam, laborer 2
3951364 2007546 2007546 defendant Bowman John laborer 659160 659160 Bowman, John, of Harpam, laborer 3
3951365 2007546 2007546 defendant Smyth Thomas husbandman 659160 659160 Smyth, Thomas, of Harpam, husbandman 4
3951366 2007546 2007546 defendant Monckman William laborer 659160 659160 Monckman, William, of Harpam, laborer 5
3951367 2007546 2007546 defendant Hogeson Edward husbandman 659160 659160 Hogeson, Edward, of Harpam, husbandman 6
3951368 2007546 2007546 defendant Haryson John laborer 659160 659160 Haryson, John, of Harpam, laborer 7
3951369 2007546 2007546 defendant Weddere John husbandman 659160 659160 Weddere, John, of Harpam, husbandman 8
3951370 2007546 2007546 defendant Capullman William husbandman 659160 659160 Capullman, William, of Harpam, husbandman 9
3951371 2007546 2007546 defendant Chapman William husbandman 659160 659160 Chapman, William, of Harpam, husbandman 10
3951372 2007546 2007546 defendant Helme Thomas laborer 659160 659160 Helme, Thomas, of Harpam, laborer 11
3951373 2007546 2007546 defendant Helme Robert laborer 659160 659160 Helme, Robert, of Harpam, laborer 12
3951374 2007546 2007546 defendant Hunter Robert husbandman 659160 659160 Hunter, Robert, of Harpam, husbandman 13
3951375 2007546 2007546 defendant Smyth John laborer 659160 659160 Smyth, John, of Harpam, laborer 14
3951376 2007546 2007546 defendant Guye Richard laborer 659160 659160 Guye, Richard, of Harpam, laborer 15
3951377 2007546 2007546 defendant Barnabye Thomas laborer 659160 659160 Barnabye, Thomas, of Harpam, laborer 16
3951378 2007546 2007546 defendant Cooke Peter weaver 659160 659160 Cooke, Peter, of Harpam, weaver 17
3951379 2007546 2007546 defendant Clerke Brian laborer 659160 659160 Clerke, Brian, of Harpam, laborer 18
3951380 2007546 2007546 defendant Staynes Robert weaver 659160 659160 Staynes, Robert, of Harpam, weaver 19
3951381 2007546 2007546 defendant Joy James laborer 659160 659160 Joy, James, of Harpam, laborer 20
3951382 2007546 2007546 defendant Clarkson Thomas laborer 659160 659160 Clarkson, Thomas, of Harpam, laborer 21

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