names

21 rows where case_id = 2399925

✎ 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
5145882 2399925 2399925 plaintiff Bruyn Henry knight   Bruyn, Henry, knight 0
5145883 2399925 2399925 defendant Mewes William gent 595238 595238 Mewes, William, of New Lemyngton, gent 0
5145884 2399925 2399925 defendant Mewes Henry gent 595238 595238 Mewes, Henry, of New Lemyngton, gent 1
5145885 2399925 2399925 defendant Logge Thomas yeoman 600272 600272 Logge, Thomas, of Newport, Isle of Wight, yeoman 2
5145886 2399925 2399925 defendant Trowbryge Edmund yeoman 805962 805962 Trowbryge, Edmund, of Caresbrok, Isle of Wight, yeoman 3
5145887 2399925 2399925 defendant Spegge William   596973 596973 Spegge, William, of Newport, mill ward 4
5145888 2399925 2399925 defendant Logge Robert fishmonger 596973 596973 Logge, Robert, of Newport, fishmonger 5
5145889 2399925 2399925 defendant (not given)   Mayor of Barnard, butcher 596973 596973 Barnard, Mayor, of Newport, butcher 6
5145890 2399925 2399925 defendant Keneby James yeoman 596973 596973 Keneby James, of Newport, yeoman 7
5145891 2399925 2399925 defendant Turnour Stephen husbandman 594407 594407 Turnour, Stephen, of Alvyngton, husbandman 8
5145892 2399925 2399925 defendant Arnewode John yeoman 766992 766992 Arnewode, John, of Arnewode, yeoman 9
5145893 2399925 2399925 defendant Dommer Thomas yeoman 595238 595238 Dommer, Thomas, of New Lemyngton, yeoman 10
5145894 2399925 2399925 defendant Colyn Peter tailor 596973 596973 Colyn, Peter, of Newport, tailor 11
5145895 2399925 2399925 defendant Lyghtfote Edmund   595238 595238 Lyghtfote, Edmund, of New Lemyngton, arrow maker 12
5145896 2399925 2399925 defendant Broun William   628719 628719 Broun, William, of Yarmouth, Isle of Wight, boat man 13
5145897 2399925 2399925 defendant Whiteborn Thomas husbandman 767402 767402 Whiteborn, Thomas, of Caresbroke, husbandman 14
5145898 2399925 2399925 defendant Mudford Thomas yeoman 596973 596973 Mudford, Thomas, of Newport, yeoman 15
5145899 2399925 2399925 defendant Hogekyn Richard weaver 596973 596973 Hogekyn, Richard, of Newport, weaver 16
5145900 2399925 2399925 defendant Philipp John laborer 768642 768642 Philipp, John, of Godeshill, laborer 17
5145901 2399925 2399925 defendant Arnewode Ralph husbandman 766992 766992 Arnewode, Ralph, of Arnewode, husbandman 18
5145902 2399925 2399925 defendant Rawlyn John yeoman 596973 596973 Rawlyn, John, of Newport, 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);