names

21 rows where case_id = 2405843

✎ 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
5166210 2405843 2405843 plaintiff Bruyn Henry knight   Bruyn, Henry, knight 0
5166211 2405843 2405843 defendant Mewes William gent 595238 595238 Mewes, William, of New Lemyngton, gent 0
5166212 2405843 2405843 defendant Mewes Henry gent 595238 595238 Mewes, Henry, of New Lemyngton, gent 1
5166213 2405843 2405843 defendant Logge Thomas yeoman 600272 600272 Logge, Thomas, of Newport, Isle of Wight, yeoman 2
5166214 2405843 2405843 defendant Trowbryge Edmund yeoman 609093 609093 Trowbryge, Edmund, of Caresbroke, Isle of Wight, yeoman 3
5166215 2405843 2405843 defendant Spegge William   600272 600272 Spegge, William, of Newport, Isle of Wight, mill ward 4
5166216 2405843 2405843 defendant Logge Robert fishmonger 596973 596973 Logge, Robert, of Newport, fishmonger 5
5166217 2405843 2405843 defendant Barnard Maior butcher 600272 600272 Barnard, Maior, of Newport, Isle of Wight, butcher 6
5166218 2405843 2405843 defendant Keneby James yeoman 596973 596973 Keneby, James, of Newport, yeoman 7
5166219 2405843 2405843 defendant Turnour Stephen husbandman 855328 855328 Turnour, Stephen, of Alvyngton, Isle of Wight, husbandman 8
5166220 2405843 2405843 defendant Arnewode John yeoman 766992 766992 Arnewode, John, of Arnewode, yeoman 9
5166221 2405843 2405843 defendant Dommer Thomas yeoman 855329 855329 Dommer, Thomas, of New Lemington, yeoman 10
5166222 2405843 2405843 defendant Colyn Peter tailor 596973 596973 Colyn, Peter, of Newport, tailor 11
5166223 2405843 2405843 defendant Lyghtfote Edmund fletcher 595238 595238 Lyghtfote, Edmund, of New Lemyngton, fletcher 12
5166224 2405843 2405843 defendant Broun William of Yarmouth Isle of Wight, boat man   Broun, William of Yarmouth, Isle of Wight, boat man 13
5166225 2405843 2405843 defendant Whoteborn Thomas husbandman 609093 609093 Whoteborn, Thomas, of Caresbroke, Isle of Wight, husbandman 14
5166226 2405843 2405843 defendant Mudford Thomas yeoman 600272 600272 Mudford, Thomas, of Newport, Isle of Wight, yeoman 15
5166227 2405843 2405843 defendant Hogekyn Richard weaver 596973 596973 Hogekyn, Richard, of Newport, weaver 16
5166228 2405843 2405843 defendant Philipp John laborer 747262 747262 Philipp, John, of Godeshill, Isle of Wight, laborer 17
5166229 2405843 2405843 defendant Arnewode Ralph husbandman 766992 766992 Arnewode, Ralph, of Arnewode, husbandman 18
5166230 2405843 2405843 defendant Rawlyn John yeoman 600272 600272 Rawlyn, John, of Newport, Isle of Wight, yeoman 19

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