names

12 rows where place_id = 815000

✎ 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
4868325 2317070 2317070 defendant Whyte Roger yeoman 815000 815000 Whyte, Roger, of Temedbury, yeoman 0
4878672 2320270 2320270 defendant Lye Roger husbandman 815000 815000 Lye, Roger, of Temedbury, husbandman 8
4878673 2320270 2320270 defendant Corveser Richard cordwainer 815000 815000 Corveser, Richard, of Temedbury, cordwainer 9
4878674 2320270 2320270 defendant Corveser John cordwainer 815000 815000 Corveser, John, of Temedbury, cordwainer 10
4878678 2320270 2320270 defendant Corveser Wulliam laborer 815000 815000 Corveser, Wulliam, of Temedbury, laborer 14
4878679 2320270 2320270 defendant Wynchester William husbandman 815000 815000 Wynchester, William, of Temedbury, husbandman 15
4878680 2320270 2320270 defendant Milward John laborer 815000 815000 Milward, John, of Temedbury, laborer 16
5024424 2364053 2364053 defendant White Roger cordwainer 815000 815000 White, Roger, of Temedbury, cordwainer 0
5024425 2364053 2364053 defendant White William cordwainer 815000 815000 White, William, of Temedbury, cordwainer 1
5024426 2364053 2364053 defendant Radenore John   815000 815000 Radenore, John, of Temedbury, millward 2
5024427 2364053 2364053 defendant Newbold John spicer 815000 815000 Newbold, John, of Temedbury, spicer 3
5296924 2444093 2444093 defendant White Roger yeoman 815000 815000 White, Roger, of Temedbury, yeoman 1

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