names

12 rows where case_id = 2331600

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4916283 2331600 2331600 plaintiff Etton Robert     Etton, Robert, on his own account 0
4916284 2331600 2331600 defendant Grene Thomas husbandman 702332 702332 Grene, Thomas, of Fulletby, husbandman 0
4916285 2331600 2331600 defendant Beldon Walter fisher 606682 606682 Beldon, Walter, of Waynflet, fisher 1
4916286 2331600 2331600 defendant (illegible)   gent 908261 908261 ----, of Markely, gent 2
4916287 2331600 2331600 defendant Neweham Thomas husbandman 623309 623309 Neweham, Thomas, of Fulnetby, husbandman 3
4916288 2331600 2331600 defendant Brouns Emma widow 586682 586682 Brouns, Emma, of Mylton, widow 4
4916289 2331600 2331600 defendant Brett John husbandman 821546 821546 Brett, John, of Wranle, husbandman 5
4916290 2331600 2331600 defendant Goneld Richard shipman 762374 762374 Goneld, Richard, of Saltflet Haven, shipman 6
4916291 2331600 2331600 defendant South Walter husbandman 821547 821547 South, Walter, of Stamilesby, husbandman 7
4916292 2331600 2331600 defendant Parke Thomas husbandman 619102 619102 Parke, Thomas, of Mynyngesby, husbandman 8
4916293 2331600 2331600 defendant Est Robert   586835 586835 Est, Robert, of Soterby, lead beater 9
4916294 2331600 2331600 defendant Markeby Robert chaplain 597124 597124 Markeby, Robert, of Waynflete, chaplain 10

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