names

22 rows where case_id = 2524954

✎ 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
5567067 2524954 2524954 plaintiff Dacre Ralph esq   Dacre, Ralph, esq 0
5567068 2524954 2524954 plaintiff Tyndyng Ralph clerk   Tyndyng, Ralph, clerk 1
5567069 2524954 2524954 defendant Browham Christopher gent 900869 900869 Browham, Christopher, of Browham, Westmor, gent 0
5567070 2524954 2524954 defendant Crakenthorp John gent 900870 900870 Crakenthorp, John, of Newbiging, Westmor, gent 1
5567071 2524954 2524954 defendant Barwise Richard   900871 900871 Barwise, Richard, of Newbiging 2
5567072 2524954 2524954 defendant Boste Christopher yeoman 900872 900872 Boste, Christopher, of Clybborne, Westmor, yeoman 3
5567073 2524954 2524954 defendant Lancastre John esq 817674 817674 Lancastre, John, of Brampton, Westmor, esq 4
5567074 2524954 2524954 defendant Moreland John esq 900873 900873 Moreland, John, of Penrethen, Cumber, esq 5
5567075 2524954 2524954 defendant Fleke John yeoman 586779 586779 Fleke, John, of Brampton, yeoman 6
5567076 2524954 2524954 defendant Berkeley James esq 645681 645681 Berkeley, James, of Berkeley, Glos, esq 7
5567077 2524954 2524954 defendant Byford William yeoman 841762 841762 Byford, William, of Slymbrygge, Glos, yeoman 8
5567078 2524954 2524954 defendant Baylly John yeoman 900874 900874 Baylly, John, of Hamme, Glos, yeoman 9
5567079 2524954 2524954 defendant Warcop Robert gent 900875 900875 Warcop, Robert, of Kowby, Westmor, gent 10
5567080 2524954 2524954 defendant Wolff Alan yeoman 900876 900876 Wolff, Alan, of Kowby, yeoman 11
5567081 2524954 2524954 defendant Wyber William esq   Wyber, William, esq 12
5567082 2524954 2524954 defendant Fallofeld Christopher     Fallofeld, Christopher 13
5567083 2524954 2524954 defendant Bowkyll John yeoman   Bowkyll, John, yeoman 14
5567084 2524954 2524954 defendant Warcop Edward gent 900877 900877 Warcop, Edward, of Smerdall, Westmor, gent 15
5567085 2524954 2524954 defendant Warcop Robert gent 629464 629464 Warcop, Robert, of Warcop, of Westmor, gent 16
5567086 2524954 2524954 defendant Blyncarn Richard yeoman 900879 900879 Blyncarn, Richard, of Watby, Westmor, yeoman 17
5567087 2524954 2524954 defendant Clybborne Thomas gent 900880 900880 Clybborne, Thomas, of Clybborne, gent 18
5567088 2524954 2524954 defendant Warcop Thomas gent 900876 900876 Warcop, Thomas, of Kowby, gent 19

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