names

27 rows where place_id = 659160

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3951311 2007524 2007524 defendant Saynt Quyntyne Gabriel esq 659160 659160 Saynt Quyntyne, Gabriel, of Harpam, 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
3965461 2012534 2012534 defendant Wetherall John yeoman 659160 659160 Wetherall, John, of Harpam, yeoman 1
4876049 2319468 2319468 defendant Mauncemors Thomas tailor 659160 659160 Mauncemors, Thomas, of Harpam, tailor 0
5057131 2373714 2373714 defendant Halome John yeoman 659160 659160 Halome, John, of Harpam, yeoman 0
5382539 2470065 2470065 defendant St Quyntyn John esq 659160 659160 St Quyntyn, John, of Harpam, esq 0

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