names

27 rows where place_id = 804664

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, raw_segment

id ▼ case_id role surname forename occupation place_id raw_segment seq
4804694 2297666 2297666 defendant of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4804696 2297667 2297667 defendant of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4805627 2297968 2297968 defendant Navarre Joan de   804664 804664 Navarre, Joan de, of England, Queen 0
4805687 2297988 2297988 defendant Navarre Joan of   804664 804664 Navarre, Joan of, of England, Queen 0
4805689 2297989 2297989 defendant Navarre Joan of   804664 804664 Navarre, Joan of, of England, Queen 0
4805691 2297990 2297990 defendant of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4817893 2301679 2301679 plaintiff Navarre Joan de   804664 804664 Navarre, Joan de, of England, Queen 0
4817895 2301680 2301680 plaintiff Navarre Joan of   804664 804664 Navarre, Joan of, of England, Queen 0
4817897 2301681 2301681 plaintiff Navarre Joan   804664 804664 Navarre, Joan, of England, queen 0
4818468 2301857 2301857 plaintiff of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4818473 2301858 2301858 plaintiff of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4818475 2301859 2301859 plaintiff of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4818477 2301860 2301860 plaintiff of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4818479 2301861 2301861 plaintiff of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4818894 2301995 2301995 defendant of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4819959 2302320 2302320 defendant of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4822365 2303077 2303077 defendant of Navarre Joan   804664 804664 of Navarre, Joan, of England, Queen 0
4824016 2303587 2303587 defendant Navarre Joan of   804664 804664 Navarre, Joan of, of England, Queen 0
4824019 2303588 2303588 defendant Navarre Joan of   804664 804664 Navarre, Joan of, of England, Queen 0
4825603 2304051 2304051 plaintiff Valois Katherine de   804664 804664 Valois, Katherine de, of England, Queen 0
4825611 2304052 2304052 plaintiff Valois Katherine de   804664 804664 Valois, Katherine de, of England, Queen 0
4825618 2304053 2304053 plaintiff Valois Katherine de   804664 804664 Valois, Katherine de, of England, Queen 0
4825624 2304054 2304054 plaintiff Valois Katherine de   804664 804664 Valois, Katherine de, of England, Queen 0
4825626 2304055 2304055 plaintiff Valois Katherine de   804664 804664 Valois, Katherine de, of England, Queen 0
4825635 2304056 2304056 plaintiff Valois Katherine de   804664 804664 Valois, Katherine de, of England, Queen 0
5141371 2398599 2398599 plaintiff Valois-Anjou Margaret   804664 804664 Valois-Anjou, Margaret, of England, Queen 0
5141375 2398600 2398600 plaintiff Valois-Anjou Margaret   804664 804664 Valois-Anjou, Margaret, of England, Queen 0

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