names

15 rows where case_id = 2039666

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4042102 2039666 2039666 plaintiff Pacocke Ralph     Pacocke, Ralph 0
4042103 2039666 2039666 defendant Makyns William yeoman 680784 680784 Makyns, William, of Waghen, yeoman 0
4042104 2039666 2039666 defendant Bethell Edward yeoman 680784 680784 Bethell, Edward, of Waghen, yeoman 1
4042105 2039666 2039666 defendant Tompson Bartholomew husbandman 680784 680784 Tompson, Bartholomew, of Waghen, husbandman 2
4042106 2039666 2039666 defendant Truslay John carpenter 680784 680784 Truslay, John, of Waghen, carpenter 3
4042107 2039666 2039666 defendant Bayxter Thomas husbandman 680784 680784 Bayxter, Thomas, of Waghen, husbandman 4
4042108 2039666 2039666 defendant Kydd William husbandman 680784 680784 Kydd, William, of Waghen, husbandman 5
4042109 2039666 2039666 defendant Prattye Robert husbandman 680784 680784 Prattye, Robert, of Waghen, husbandman 6
4042110 2039666 2039666 defendant Tompson Richard husbandman 680784 680784 Tompson, Richard, of Waghen, husbandman 7
4042111 2039666 2039666 defendant Mary John husbandman 680784 680784 Mary, John, of Waghen, husbandman 8
4042112 2039666 2039666 defendant Sturwall Henry husbandman 680784 680784 Sturwall, Henry, of Waghen, husbandman 9
4042113 2039666 2039666 defendant Browne Ralph husbandman 680784 680784 Browne, Ralph, of Waghen, husbandman 10
4042114 2039666 2039666 defendant Marten Bartholomew husbandman 680784 680784 Marten, Bartholomew, of Waghen, husbandman 11
4042115 2039666 2039666 defendant Harper William husbandman 680784 680784 Harper, William, of Waghen, husbandman 12
4042116 2039666 2039666 defendant Noble John husbandman 680784 680784 Noble, John, of Waghen, husbandman 13

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