names

12 rows where case_id = 2346105

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4963867 2346105 2346105 plaintiff Champernoun Roger     Champernoun, Roger 0
4963868 2346105 2346105 defendant Bouker Henry husbandman 828088 828088 Bouker, Henry, of North Lodbroke, husbandman 0
4963869 2346105 2346105 defendant Haredon John, junior husbandman 828088 828088 Haredon, John, junior, of North Lodbroke, husbandman 1
4963870 2346105 2346105 defendant Tresule Richard husbandman 828088 828088 Tresule, Richard, of North Lodbroke, husbandman 2
4963871 2346105 2346105 defendant Tope or Tepe John husbandman 828088 828088 Tope or Tepe, John, of North Lodbroke, husbandman 3
4963872 2346105 2346105 defendant Shortecombe William husbandman 828088 828088 Shortecombe, William, of North Lodbroke, husbandman 4
4963873 2346105 2346105 defendant Cornyssh John husbandman 828088 828088 Cornyssh, John, of North Lodbroke, husbandman 5
4963874 2346105 2346105 defendant Polyng Thomas weaver 828088 828088 Polyng, Thomas, of North Lodbroke, weaver 6
4963875 2346105 2346105 defendant Tavystok Joan widow 828088 828088 Tavystok, Joan, of North Lodbroke, widow 7
4963876 2346105 2346105 defendant Michell Thomas tailor 828088 828088 Michell, Thomas, of North Lodbroke, tailor 8
4963877 2346105 2346105 defendant Vantard Michael husbandman 828088 828088 Vantard, Michael, of North Lodbroke, husbandman 9
4963878 2346105 2346105 defendant Ravystok Roger husbandman 828088 828088 Ravystok, Roger, of North Lodbroke, husbandman 10

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