names

10 rows where case_id = 1938304

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3738668 1938304 1938304 plaintiff Mynton John   593282 593282 Mynton, John, of Drayton 0
3738669 1938304 1938304 defendant Colle William husbandman 620961 620961 Colle, William, of Wullerton, husbandman 0
3738670 1938304 1938304 defendant Chaundeler William husbandman 620962 620962 Chaundeler, William, of Cold Hatton, husbandman 1
3738671 1938304 1938304 defendant Cardelesse William husbandman 618580 618580 Cardelesse, William, of Magna Sowdeley, husbandman 2
3738672 1938304 1938304 defendant Tasker Thomas husbandman 620963 620963 Tasker, Thomas, of Lylleshull, husbandman 3
3738673 1938304 1938304 defendant Nunche Thomas husbandman 620964 620964 Nunche, Thomas, of Wrokewarden, husbandman 4
3738674 1938304 1938304 defendant Alkyn or Awyn John husbandman 620965 620965 Alkyn or Awyn, John, of Ocheham, husbandman 5
3738675 1938304 1938304 defendant Felton homas husbandman 620962 620962 Felton, homas, of Cold Hatton, husbandman 6
3738676 1938304 1938304 defendant Hurleston William husbandman 620966 620966 Hurleston, William, of Howle, husbandman 7
3738677 1938304 1938304 defendant Grensell William husbandman 594497 594497 Grensell, William, of Parva Drayton, husbandman 8

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