names

16 rows where case_id = 2184254

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4447838 2184254 2184254 plaintiff Fastolf John, senior     Fastolf, John, senior 0
4447839 2184254 2184254 defendant Wype Henry     Wype, Henry 0
4447840 2184254 2184254 defendant Cather William   600051 600051 Cather, William, of Castre or Caister 1
4447841 2184254 2184254 defendant Oky John   608255 608255 Oky, John, of runham, shepherd 2
4447842 2184254 2184254 defendant Ferier John   665940 665940 Ferier, John, of Thirne 3
4447843 2184254 2184254 defendant Taillour Thomas   622977 622977 Taillour, Thomas, of Ouby 4
4447844 2184254 2184254 defendant Merston William     Merston, William 5
4447845 2184254 2184254 defendant atte Feld Edmund     atte Feld, Edmund 6
4447846 2184254 2184254 defendant Howard John   600634 600634 Howard, John, of Reppes 7
4447847 2184254 2184254 defendant Hetersete William de     Hetersete, William de 8
4447848 2184254 2184254 defendant Edward Thomas     Edward, Thomas 9
4447849 2184254 2184254 defendant Curteys Geoffrey     Curteys, Geoffrey 10
4447850 2184254 2184254 defendant Herman Richard     Herman, Richard 11
4447851 2184254 2184254 defendant Pautrik John     Pautrik, John 12
4447852 2184254 2184254 defendant Lyther John     Lyther, John 13
4447853 2184254 2184254 defendant Rogers Robert     Rogers, Robert 14

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