names

19 rows where case_id = 2416534

✎ 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
5202629 2416534 2416534 plaintiff Bruyn Henry knight   Bruyn, Henry, knight 0
5202630 2416534 2416534 defendant Mewes William gent 595238 595238 Mewes, William, of New Lemyngton, gent 0
5202631 2416534 2416534 defendant Mewes Henry gent 595238 595238 Mewes, Henry, of New Lemyngton, gent 1
5202632 2416534 2416534 defendant Logge Thomas yeoman 600272 600272 Logge, Thomas, of Newport, Isle of Wight, yeoman 2
5202633 2416534 2416534 defendant Trowbryge Edmund yeoman 609093 609093 Trowbryge, Edmund, of Caresbroke, Isle of Wight, yeoman 3
5202634 2416534 2416534 defendant Spegge William   600272 600272 Spegge, William, of Newport, Isle of Wight, mill ward 4
5202635 2416534 2416534 defendant Logge Robert fishmonger 596973 596973 Logge, Robert, of Newport, fishmonger 5
5202636 2416534 2416534 defendant Barnard Maior butcher 596973 596973 Barnard, Maior, of Newport, butcher 6
5202637 2416534 2416534 defendant Keneby James yeoman 596973 596973 Keneby, James, of Newport, yeoman 7
5202638 2416534 2416534 defendant Turnour Stephen husbandman 859006 859006 Turnour, Stephen, of Abbyngton, Isle of Wight, husbandman 8
5202639 2416534 2416534 defendant Arnewode John yeoman 766992 766992 Arnewode, John, of Arnewode, yeoman 9
5202640 2416534 2416534 defendant Dommer Thomas yeoman 595238 595238 Dommer, Thomas, of New Lemyngton, yeoman 10
5202641 2416534 2416534 defendant Colyn Peter tailor 600272 600272 Colyn, Peter, of Newport, Isle of Wight, tailor 11
5202642 2416534 2416534 defendant Lyghtfote Edmund   595238 595238 Lyghtfote, Edmund, of New Lemyngton, arrow maker 12
5202643 2416534 2416534 defendant Broun William   628719 628719 Broun, William, of Yarmouth, Isle of Wight, boat man 13
5202644 2416534 2416534 defendant Whoteborn Thomas weaver 767402 767402 Whoteborn, Thomas, of Caresbroke, weaver 14
5202645 2416534 2416534 defendant Philipp John laborer 859007 859007 Philipp, John, of Godehill, Isle of Wight, laborer 15
5202646 2416534 2416534 defendant Arnewode Ralph husbandman 766992 766992 Arnewode, Ralph, of Arnewode, husbandman 16
5202647 2416534 2416534 defendant Rawlyn John yeoman 596973 596973 Rawlyn, John, of Newport, yeoman 17

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