names

9 rows where place_id = 781922

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4675019 2257796 2257796 defendant Hylman William   781922 781922 Hylman, William, of Kynges Carswyll 0
5078050 2379918 2379918 defendant Bykeford Henry husbandman 781922 781922 Bykeford, Henry, of Kynges Carswyll, husbandman 0
5334027 2455249 2455249 defendant Taillour Thomas husbandman 781922 781922 Taillour, Thomas, of Kynges Carswyll, husbandman 7
5334028 2455249 2455249 defendant Bykeford Henry husbandman 781922 781922 Bykeford, Henry, of Kynges Carswyll, husbandman 8
5334029 2455249 2455249 defendant Grey Alfred husbandman 781922 781922 Grey, Alfred, of Kynges Carswyll, husbandman 9
5334030 2455249 2455249 defendant Sampson John husbandman 781922 781922 Sampson, John, of Kynges Carswyll, husbandman 10
5334031 2455249 2455249 defendant Revell or Renell Stephen husbandman 781922 781922 Revell or Renell, Stephen, of Kynges Carswyll, husbandman 11
5334032 2455249 2455249 defendant Martyn William husbandman 781922 781922 Martyn, William, of Kynges Carswyll, husbandman 12
5334034 2455250 2455250 defendant Potter William   781922 781922 Potter, William, of Kynges Carswyll, holy water clerk 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);