names

20 rows where case_id = 2175910

✎ 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
4435668 2175910 2175910 plaintiff Pette Peter atte (legal representative)   Pette, Peter atte, executors of 0
4435669 2175910 2175910 plaintiff Chessebury Roger parson of the church, in   (Chessebury, Roger, parson of the church, in 1
4435670 2175910 2175910 plaintiff Hanek or Hauek Stephen     Hanek or Hauek, Stephen 2
4435671 2175910 2175910 plaintiff Josekyn Walter     Josekyn, Walter 3
4435672 2175910 2175910 defendant Frenshe Robert     Frenshe, Robert 0
4435673 2175910 2175910 defendant Gyles John   593153 593153 Gyles, John, of Middelton 1
4435674 2175910 2175910 defendant Large John   668484 668484 Large, John, of Mallynge 2
4435675 2175910 2175910 defendant Breseland John     Breseland, John 3
4435676 2175910 2175910 defendant Goldhauekes Thomas   639394 639394 Goldhauekes, Thomas, of Tylbury 4
4435677 2175910 2175910 defendant Grigge William   589393 589393 Grigge, William, of North Flete 5
4435678 2175910 2175910 defendant Stote John     Stote, John 6
4435679 2175910 2175910 defendant Deghere Richard   593153 593153 Deghere, Richard, of Middelton 7
4435680 2175910 2175910 defendant Mayheu John   756236 756236 Mayheu, John, of Regge 8
4435681 2175910 2175910 defendant Regge John   595766 595766 Regge, John, of Chalke 9
4435682 2175910 2175910 defendant Symme John   768759 768759 Symme John, of Renham 10
4435683 2175910 2175910 defendant atte pate Nicholas     atte pate, Nicholas 11
4435684 2175910 2175910 defendant Pope Richard son of John, of Chalke   Pope, Richard, son of John, of Chalke 12
4435685 2175910 2175910 defendant atte Poke Gregory   588641 588641 atte Poke, Gregory, of Denton 13
4435686 2175910 2175910 defendant Pevenersshe Henry de     Pevenersshe, Henry de 14
4435687 2175910 2175910 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);