names

13 rows where case_id = 2224467

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4577457 2224467 2224467 plaintiff Carlton Thomas formerly vicar of St Paul's church, Canterbury   Carlton, Thomas, formerly vicar of St Paul's church, Canterbury, executors of 0
4577458 2224467 2224467 plaintiff Carlton Thomas chaplain 586175 586175 (Carlton, Thomas, of Canterbury, chaplain 1
4577459 2224467 2224467 plaintiff Medbourne Nicholas     Medbourne, Nicholas 2
4577460 2224467 2224467 defendant Kyngeston by Barham Robert parson of the church, in   Kyngeston by Barham, Robert, parson of the church, in 0
4577461 2224467 2224467 defendant Curteys Richard   771363 771363 Curteys, Richard, of Kyngeston by Barham 1
4577462 2224467 2224467 defendant Gylys Henry   594064 594064 Gylys, Henry, of Barham 2
4577463 2224467 2224467 defendant Perebrok John     Perebrok, John 3
4577464 2224467 2224467 defendant Lynche John   594064 594064 Lynche, John, of Barham 4
4577465 2224467 2224467 defendant Haytesbury John     Haytesbury, John 5
4577466 2224467 2224467 defendant Brenehill Thomas   586175 586175 Brenehill, Thomas, of Canterbury 6
4577467 2224467 2224467 defendant Trippe John (legal representative)   Trippe, John, executors of 7
4577468 2224467 2224467 defendant Trippe Joan formerly wife of John   (Trippe, Joan, formerly wife of John 8
4577469 2224467 2224467 defendant Perker John     Perker, John 9

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