names

35 rows where case_id = 2237173

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename

id ▼ case_id role surname forename occupation place_id raw_segment seq
4619777 2237173 2237173 plaintiff Horne Thomas     Horne, Thomas 0
4619778 2237173 2237173 plaintiff Horne Margery     Margery, his wife 1
4619779 2237173 2237173 defendant Longe John son of William   Longe, John, son of William 0
4619780 2237173 2237173 defendant Sefoghel John     Sefoghel, John 1
4619781 2237173 2237173 defendant Wylmot John     Wylmot, John 2
4619782 2237173 2237173 defendant Marchaunt John     Marchaunt, John 3
4619783 2237173 2237173 defendant Canterbury John prior of Christchurch, in   Canterbury, John, prior of Christchurch, in 4
4619784 2237173 2237173 defendant Jan William     Jan, William 5
4619785 2237173 2237173 defendant Edeux John     Edeux, John 6
4619786 2237173 2237173 defendant Philip John     Philip, John 7
4619787 2237173 2237173 defendant Feldeswell John     Feldeswell, John 8
4619788 2237173 2237173 defendant Cleydiche Robert     Cleydiche, Robert 9
4619789 2237173 2237173 defendant Andrewe John     Andrewe, John 10
4619790 2237173 2237173 defendant Brome John de     Brome, John de 11
4619791 2237173 2237173 defendant Hornbroke William     Hornbroke, William 12
4619792 2237173 2237173 defendant Reygate Simon     Reygate, Simon 13
4619793 2237173 2237173 defendant Toune Simon     Toune, Simon 14
4619794 2237173 2237173 defendant Bullyng William     Bullyng, William 15
4619795 2237173 2237173 defendant Welbald John     Welbald, John 16
4619796 2237173 2237173 defendant Chaloner John     Chaloner, John 17
4619797 2237173 2237173 defendant (not given) William his brother   William, his brother 18
4619798 2237173 2237173 defendant Chaloner William     Chaloner, William 19
4619799 2237173 2237173 defendant Longe Alice     Longe, Alice 20
4619800 2237173 2237173 defendant Olman John     Olman, John 21
4619801 2237173 2237173 defendant Olman Clemency     Clemency, his wife 22
4619802 2237173 2237173 defendant Strete William     Strete, William 23
4619803 2237173 2237173 defendant Strete Agnes     Agnes, his wife 24
4619804 2237173 2237173 defendant Horne Henry     Horne, Henry 25
4619805 2237173 2237173 defendant Bery Thomas     Bery, Thomas 26
4619806 2237173 2237173 defendant Toune Thomas     Toune, Thomas 27
4619807 2237173 2237173 defendant Edynden Thomas     Edynden, Thomas 28
4619808 2237173 2237173 defendant Balkebourne Thomas     Balkebourne, Thomas 29
4619809 2237173 2237173 defendant Longe John   775134 775134 Longe, John, of Apoldre 30
4619810 2237173 2237173 defendant Horne Robert     Horne, Robert 31
4619811 2237173 2237173 defendant Brykynden John     Brykynden, John 32

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