names

11 rows where place_id = 639343

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3848330 1973053 1973053 defendant Marshe Thomas clerk 639343 639343 Marshe, Thomas, of Throkkyng, clerk 0
3956411 2009303 2009303 defendant Hyde William esq 639343 639343 Hyde, William, of Throkkyng, esq 0
3956412 2009303 2009303 defendant Crede George husbandman 639343 639343 Crede, George, of Throkkyng, husbandman 1
4825846 2304119 2304119 defendant Brasyere John husbandman 639343 639343 Brasyere, John, of Throkkyng, husbandman 0
4850522 2311625 2311625 defendant Brasyer John husbandman 639343 639343 Brasyer, John, of Throkkyng, husbandman 0
4877406 2319887 2319887 defendant Barton Robert yeoman 639343 639343 Barton, Robert, of Throkkyng, yeoman 4
4923097 2333642 2333642 defendant Grene John laborer 639343 639343 Grene, John, of Throkkyng, laborer 3
4932375 2336520 2336520 defendant Launam or Lannam Thomas laborer 639343 639343 Launam or Lannam, Thomas, of Throkkyng, laborer 1
5088009 2382867 2382867 defendant Hude George gent 639343 639343 Hude, George, of Throkkyng, gent 0
5196612 2414763 2414763 defendant Hyde George esq 639343 639343 Hyde, George, of Throkkyng, esq 0
5355221 2461705 2461705 defendant Couper John yeoman 639343 639343 Couper, John, of Throkkyng, yeoman 0

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