names

13 rows where case_id = 2131228

✎ 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
4303143 2131228 2131228 plaintiff Dawtrey Richard gent, attorney   Dawtrey, Richard, gent, attorney 0
4303144 2131228 2131228 defendant Rogers William yeoman 587550 587550 Rogers, William, of Eye, yeoman 0
4303145 2131228 2131228 defendant Tame Thomas yeoman 728531 728531 Tame, Thomas, of Westerfield, yeoman 1
4303146 2131228 2131228 defendant Barber William yeoman 733147 733147 Barber, William, of Trimley St Mary, yeoman 2
4303147 2131228 2131228 defendant Andrewes Thomas yeoman 607926 607926 Andrewes, Thomas, of Darsham, yeoman 3
4303148 2131228 2131228 defendant Good Thomas yeoman 720295 720295 Good, Thomas, of Creatinge St Mary, yeoman 4
4303149 2131228 2131228 defendant Kinge Henry blacksmith 733148 733148 Kinge, Henry, of Grundisborowe, blacksmith 5
4303150 2131228 2131228 defendant Travis Thomas clerk 720295 720295 Travis, Thomas, of Creatinge St Mary, clerk 6
4303151 2131228 2131228 defendant Smyth Robert husbandman 733149 733149 Smyth, Robert, of Bucklesham, husbandman 7
4303152 2131228 2131228 defendant Smyth Edward gent 599419 599419 Smyth, Edward, of Sprowton, gent 8
4303153 2131228 2131228 defendant Spenser Edmund husbandman 591076 591076 Spenser, Edmund, of East Bergholt, husbandman 9
4303154 2131228 2131228 defendant Cove Alan carpenter 586134 586134 Cove, Alan, of Ipswich, carpenter 10
4303155 2131228 2131228 defendant Bramy Thomasine widow 586134 586134 Bramy, Thomasine, of Ipswich, widow 11

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