names

11 rows where case_id = 2093410

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4193831 2093410 2093410 plaintiff Bynck John administrators, administrators of   Bynck, John, administrators, administrators of 0
4193832 2093410 2093410 plaintiff Turner Thomas     (Turner, Thomas 1
4193833 2093410 2093410 plaintiff Turner Katherine administrators during minority of Agnes Bynck, daughter of John Bynck   Katherine his wife, administrators during minority of Agnes Bynck, daughter of John Bynck 2
4193834 2093410 2093410 defendant Wheler John cooper 585869 585869 Wheler, John, of London, or of Greenwich, Kent, cooper 0
4193835 2093410 2093410 defendant Puttrell Thomas carpenter 585869 585869 Puttrell, Thomas, of London, or of St Martin in the Fields, Middx, carpenter 1
4193836 2093410 2093410 defendant Turpyne Roger yeoman 585869 585869 Turpyne, Roger, of London, or of Westminster, yeoman 2
4193837 2093410 2093410 defendant Petley Henry (legal representative) 586033 586033 Petley, Henry, of Westminster, scrivener, executors of 3
4193838 2093410 2093410 defendant Petley Gregory yeoman 586033 586033 (Petley, Gregory, of Westminster, yeoman 4
4193839 2093410 2093410 defendant Petley Ellen widow 586033 586033 Petley, Ellen, of Westminster, widow 5
4193840 2093410 2093410 defendant Siston John (legal representative) 585929 585929 Siston, John, of St Clement Danes, Queen's messanger, executors of 6
4193841 2093410 2093410 defendant Miller David yeoman 593673 593673 (Miller, David, of St Clement Danes, Middx, yeoman 7

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