names

16 rows where case_id = 2052492

✎ 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
4078153 2052492 2052492 plaintiff Swayne Godfrey attorney of the bench   Swayne, Godfrey, attorney of the bench 0
4078154 2052492 2052492 defendant Davys Hugh gent 585869 585869 Davys, Hugh, of London, gent 0
4078155 2052492 2052492 defendant Saunders John yeoman 585869 585869 Saunders, John, of London, yeoman 1
4078156 2052492 2052492 defendant Mott John chapman 585869 585869 Mott, John, of London, chapman 2
4078157 2052492 2052492 defendant Gibson Christopher innholder 585869 585869 Gibson, Christopher, of London, innholder 3
4078158 2052492 2052492 defendant Gibson John clerk 585869 585869 Gibson, John, of London, clerk 4
4078159 2052492 2052492 defendant Longe Thomas husbandman 617722 617722 Longe, Thomas, of Parva Thurlowe, Suff, husbandman 5
4078160 2052492 2052492 defendant Flower Lancelot husbandman 597465 597465 Flower, Lancelot, of Ely, Cams, husbandman 6
4078161 2052492 2052492 defendant Blande Roger weaver 626163 626163 Blande, Roger, of Swaffham Prior, Cams, weaver 7
4078162 2052492 2052492 defendant Clerke Richard   586033 586033 Clerke, Richard, of Westminster, serving man 8
4078163 2052492 2052492 defendant Backhpwse   John, of Swaffham Prior, gent   Backhpwse, ,John, of Swaffham Prior, gent 9
4078164 2052492 2052492 defendant Richarde John gent 658130 658130 Richarde, John, of Huntington, Hunts, gent 10
4078165 2052492 2052492 defendant Cordall Thomas haberdasher 587719 587719 Cordall, Thomas, of St Ives, Hunts, haberdasher 11
4078166 2052492 2052492 defendant Raynscrofte Richard scrivener 585869 585869 Raynscrofte, Richard, of London, scrivener 12
4078167 2052492 2052492 defendant Bowman Henry yeoman 585869 585869 Bowman, Henry, of London, yeoman 13
4078168 2052492 2052492 defendant Taylor Robert butcher 585869 585869 Taylor, Robert, of London, butcher 14

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