names

76 rows where case_id = 2323024

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4887829 2323024 2323024 plaintiff Kemp John Archbishop of York   Kemp, John, Archbishop of York 0
4887830 2323024 2323024 defendant (not given) Robert abbot of Neusham Abbey   Neusham Abbey, Robert, abbot of 0
4887831 2323024 2323024 defendant Hoton John abbot of Thornton Abbey   Hoton, John, abbot of Thornton Abbey 1
4887832 2323024 2323024 defendant (not given) John abbot of Norton Abbey   Norton Abbey, John, abbot of 2
4887833 2323024 2323024 defendant (not given) John prior of Newested Priory   Newested Priory, John, prior of 3
4887834 2323024 2323024 defendant Wardale John prior of Malton Priory   Wardale, John, prior of Malton Priory 4
4887835 2323024 2323024 defendant Groute Walter prior of St Katherine, Lincoln   Groute, Walter, prior of St Katherine, Lincoln 5
4887836 2323024 2323024 defendant Holland Robert prior of Spaldyng Priory   Holland, Robert, prior of Spaldyng Priory 6
4887837 2323024 2323024 defendant Clynton Mary Lady Clynton   Clynton, Mary, Lady Clynton 7
4887838 2323024 2323024 defendant Radford Henry knight   Radford, Henry, knight 8
4887839 2323024 2323024 defendant Thorley Nicholas knight   Thorley, Nicholas, knight 9
4887840 2323024 2323024 defendant Savyle Thomas knight   Savyle, Thomas, knight 10
4887841 2323024 2323024 defendant Zouche John knight   Zouche, John, knight 11
4887842 2323024 2323024 defendant Rempston Thomas knight   Rempston, Thomas, knight 12
4887843 2323024 2323024 defendant Wentworth Roger esq   Wentworth, Roger, esq 13
4887844 2323024 2323024 defendant Mortymer Robert esq   Mortymer, Robert, esq 14
4887845 2323024 2323024 defendant Hilliard Robert esq   Hilliard, Robert, esq 15
4887846 2323024 2323024 defendant Malet William esq   Malet, William, esq 16
4887847 2323024 2323024 defendant Haitfeld John esq   Haitfeld, John, esq 17
4887848 2323024 2323024 defendant Harwode Richard clerk   Harwode, Richard, clerk 18
4887849 2323024 2323024 defendant de Bothe Thomas esq   de Bothe, Thomas, esq 19
4887850 2323024 2323024 defendant Westelyn Robert esq   Westelyn, Robert, esq 20
4887851 2323024 2323024 defendant Halton Robert clerk   Halton, Robert, clerk 21
4887852 2323024 2323024 defendant Kelke Roger     Kelke, Roger 22
4887853 2323024 2323024 defendant Baker John     Baker, John 23
4887854 2323024 2323024 defendant Clyderowe Thomas     Clyderowe, Thomas 24
4887855 2323024 2323024 defendant Metford Thomas     Metford, Thomas 25
4887856 2323024 2323024 defendant Crull Robert     Crull, Robert 26
4887857 2323024 2323024 defendant Kyghley Hugh     Kyghley, Hugh 27
4887858 2323024 2323024 defendant de Kirgarth Richard     de Kirgarth, Richard 28
4887859 2323024 2323024 defendant Supp John     Supp, John 29
4887860 2323024 2323024 defendant Broun William     Broun, William 30
4887861 2323024 2323024 defendant Greme Margaret     Greme, Margaret 31
4887862 2323024 2323024 defendant Yokeflete Thomas     Yokeflete, Thomas 32
4887863 2323024 2323024 defendant Grene John     Grene, John 33
4887864 2323024 2323024 defendant Athall William     Athall, William 34
4887865 2323024 2323024 defendant Coke Robert     Coke, Robert 35
4887866 2323024 2323024 defendant Robynson William     Robynson, William 36
4887867 2323024 2323024 defendant Cignell John     Cignell, John 37
4887868 2323024 2323024 defendant Wether John, senior     Wether, John, senior 38
4887869 2323024 2323024 defendant Wether John, junior     Wether, John, junior 39
4887870 2323024 2323024 defendant de Flyxburgh Ralph     de Flyxburgh, Ralph 40
4887871 2323024 2323024 defendant Ufflete John     Ufflete, John 41
4887872 2323024 2323024 defendant Hecham Thomas     Hecham, Thomas 42
4887873 2323024 2323024 defendant Hartyll William     Hartyll, William 43
4887874 2323024 2323024 defendant Wyghtman Nicholas     Wyghtman, Nicholas 44
4887875 2323024 2323024 defendant Thelby Margaret     Thelby, Margaret 45
4887876 2323024 2323024 defendant Feryby Thomas   586344 586344 Feryby, Thomas, of Burton 46
4887877 2323024 2323024 defendant Coke William   586344 586344 Coke, William, of Burton 47
4887878 2323024 2323024 defendant Haddelsey Robert     Haddelsey, Robert 48
4887879 2323024 2323024 defendant Ulsby Robert     Ulsby, Robert 49
4887880 2323024 2323024 defendant Croll Robert     Croll, Robert 50
4887881 2323024 2323024 defendant Hamlyn Robert     Hamlyn, Robert 51
4887882 2323024 2323024 defendant Bygge John     Bygge, John 52
4887883 2323024 2323024 defendant Robynson Richard     Robynson, Richard 53
4887884 2323024 2323024 defendant de Braytoft John     de Braytoft, John 54
4887885 2323024 2323024 defendant Denys William     Denys, William 55
4887886 2323024 2323024 defendant Elynson William     Elynson, William 56
4887887 2323024 2323024 defendant Ales William     Ales, William 57
4887888 2323024 2323024 defendant Harley Geoffrey     Harley, Geoffrey 58
4887889 2323024 2323024 defendant Kirkeby John clerk   Kirkeby, John, clerk 59
4887890 2323024 2323024 defendant Hansson William     Hansson, William 60
4887891 2323024 2323024 defendant Boys Brian     Boys, Brian 61
4887892 2323024 2323024 defendant Manfilde John     Manfilde, John 62
4887893 2323024 2323024 defendant Beverley William     Beverley, William 63
4887894 2323024 2323024 defendant Cletam Richard     Cletam, Richard 64
4887895 2323024 2323024 defendant Folgham Thomas     Folgham, Thomas 65
4887896 2323024 2323024 defendant Grome John     Grome, John 66
4887897 2323024 2323024 defendant Milner John     Milner, John 67
4887898 2323024 2323024 defendant Cerfe John     Cerfe, John 68
4887899 2323024 2323024 defendant West Robert     West, Robert 69
4887900 2323024 2323024 defendant de Bothe Thomas     de Bothe, Thomas 70
4887901 2323024 2323024 defendant Coke John   619262 619262 Coke, John, of Theleby 71
4887902 2323024 2323024 defendant Feryby Robert     Feryby, Robert 72
4887903 2323024 2323024 defendant Stethy Richard     Stethy, Richard 73
4887904 2323024 2323024 defendant Robertson Robert     Robertson, Robert 74

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