names

11 rows where place_id = 768097

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4451106 2185311 2185311 defendant Norton Thomas de   768097 768097 Norton, Thomas de, of Staynton Wadyngham, son of William 0
4546023 2214698 2214698 defendant None or Nove Hugh   768097 768097 None or Nove, Hugh, of Staynton Wadyngham 0
4563516 2220164 2220164 defendant Boys John   768097 768097 Boys, John, of Staynton Wadyngham 0
4592299 2228939 2228939 plaintiff None Hugh   768097 768097 None, Hugh, of Staynton Wadyngham 0
4592300 2228939 2228939 defendant Wryght Richard   768097 768097 Wryght, Richard, of Staynton Wadyngham 0
4640139 2243230 2243230 defendant Joy John   768097 768097 Joy, John, of Staynton Wadyngham 10
4640140 2243230 2243230 defendant Spetyll Thomas of the   768097 768097 Spetyll, Thomas of the, of Staynton Wadyngham 11
4681998 2259986 2259986 defendant Stynt Thomas esq 768097 768097 Stynt, Thomas, of Staynton Wadyngham, esq 1
4707860 2267827 2267827 defendant Stynt Thomas esq 768097 768097 Stynt, Thomas, of Staynton Wadyngham, esq 0
4742668 2278363 2278363 defendant Howet William husbandman 768097 768097 Howet, William, of Staynton Wadyngham, husbandman 0
4922355 2333401 2333401 defendant Nove or None Roger husbandman 768097 768097 Nove or None, Roger, of Staynton Wadyngham, husbandman 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);