names

20 rows where case_id = 2175911

✎ 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
4435688 2175911 2175911 plaintiff Pette Peter atte (legal representative)   Pette, Peter atte, executors of 0
4435689 2175911 2175911 plaintiff Chessebury Roger parson of the church, in   (Chessebury, Roger, parson of the church, in 1
4435690 2175911 2175911 plaintiff Hanek or Hauek Stephen     Hanek or Hauek, Stephen 2
4435691 2175911 2175911 plaintiff Josekyn Walter     Josekyn, Walter 3
4435692 2175911 2175911 defendant Frenshe Robert     Frenshe, Robert 0
4435693 2175911 2175911 defendant Gyles John   593153 593153 Gyles, John, of Middelton 1
4435694 2175911 2175911 defendant Large John   668484 668484 Large, John, of Mallynge 2
4435695 2175911 2175911 defendant Breseland John     Breseland, John 3
4435696 2175911 2175911 defendant Goldhauekes Thomas   639394 639394 Goldhauekes, Thomas, of Tylbury 4
4435697 2175911 2175911 defendant Grigge William   589393 589393 Grigge, William, of North Flete 5
4435698 2175911 2175911 defendant Stote John     Stote, John 6
4435699 2175911 2175911 defendant Deghere Richard   593153 593153 Deghere, Richard, of Middelton 7
4435700 2175911 2175911 defendant Mayheu John   756236 756236 Mayheu, John, of Regge 8
4435701 2175911 2175911 defendant Regge John   595766 595766 Regge, John, of Chalke 9
4435702 2175911 2175911 defendant Symme John   768759 768759 Symme John, of Renham 10
4435703 2175911 2175911 defendant atte Pate Nicholas     atte Pate, Nicholas 11
4435704 2175911 2175911 defendant Pope Richard son of John, of Chalke   Pope, Richard, son of John, of Chalke 12
4435705 2175911 2175911 defendant atte Poke Gregory   588641 588641 atte Poke, Gregory, of Denton 13
4435706 2175911 2175911 defendant Pevenersshe Henry de     Pevenersshe, Henry de 14
4435707 2175911 2175911 defendant Pevenesshe Richard de     Pevenesshe, Richard de 15

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