names

16 rows where case_id = 2014385

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3970867 2014385 2014385 plaintiff Dowle James (legal representative)   Dowle, James, executors of 0
3970868 2014385 2014385 plaintiff Saxy William     (Saxy, William 1
3970869 2014385 2014385 plaintiff Saxy Elizabeth     Elizabeth his wife, alias Elizabeth Dowle 2
3970870 2014385 2014385 defendant Wynter John gent 654743 654743 Wynter, John, of Brecknock, Brecon, gent 0
3970871 2014385 2014385 defendant Bryght Henry merchant 599868 599868 Bryght, Henry, of Barstable, Devon, merchant 1
3970872 2014385 2014385 defendant Brayne Thomas gent 663952 663952 Brayne, Thomas, of Clorewall, Glos, gent 2
3970873 2014385 2014385 defendant Hall Christopher gent 663953 663953 Hall, Christopher, of Heymedowe, Glos, gent 3
3970874 2014385 2014385 defendant Williams Simon tailor 663954 663954 Williams, Simon, of St Bryavell, Glos, tailor 4
3970875 2014385 2014385 defendant Morse John yeoman 663955 663955 Morse, John, of Colford, Glos, yeoman 5
3970876 2014385 2014385 defendant Griffith George yeoman 662399 662399 Griffith, George, of Colford, yeoman 6
3970877 2014385 2014385 defendant Goughe Philip chapman 663956 663956 Goughe, Philip, of Clorewall, chapman 7
3970878 2014385 2014385 defendant Jones Charles gent 637583 637583 Jones, Charles, of Lydney, Glos, gent 8
3970879 2014385 2014385 defendant Dounyng John yeoman 663957 663957 Dounyng, John, of Etlowe, Glos, yeoman 9
3970880 2014385 2014385 defendant Byde Robert yeoman 663958 663958 Byde, Robert, of Aylberton, Glos, yeoman 10
3970881 2014385 2014385 defendant Mallet William yeoman 661477 661477 Mallet, William, of Alvyngton, Glos, yeoman 11
3970882 2014385 2014385 defendant Goughe William yeoman 663959 663959 Goughe, William, of Nasshe, Glos, yeoman 12

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