names

44 rows where case_id = 2085366

✎ 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
4171078 2085366 2085366 plaintiff Cave Anthony gent, principal of Clements Inn, St Clement Dabes, Middx   Cave, Anthony, gent, principal of Clements Inn, St Clement Dabes, Middx 0
4171079 2085366 2085366 defendant Burton James gent 585869 585869 Burton, James, of London, or of Lynley, Leics, gent 0
4171080 2085366 2085366 defendant Pratt John gent 585869 585869 Pratt, John, of London, or of Lutterworth, Leics, gent 1
4171081 2085366 2085366 defendant Byllinghay Robert gent 585869 585869 Byllinghay, Robert, of London, or of Dillington, Soms, gent 2
4171082 2085366 2085366 defendant Sherwood Christopher gent 585869 585869 Sherwood, Christopher, of London, or of Well, Soms, gent 3
4171083 2085366 2085366 defendant Brett John gent 585869 585869 Brett, John, of London, gent 4
4171084 2085366 2085366 defendant Chamberleyne John gent 585869 585869 Chamberleyne, John, of London, gent 5
4171085 2085366 2085366 defendant Lye Thomas gent 585869 585869 Lye, Thomas, of London, gent 6
4171086 2085366 2085366 defendant Paskyn Thomas gent 585869 585869 Paskyn, Thomas, of London, gent 7
4171087 2085366 2085366 defendant Pryce Evan gent 585869 585869 Pryce, Evan, of London, gent 8
4171088 2085366 2085366 defendant Saunders Valentine gent 585869 585869 Saunders, Valentine, of London, or of Wansden, Suff, gent 9
4171089 2085366 2085366 defendant Sturman John gent 585869 585869 Sturman, John, of London, gent 10
4171090 2085366 2085366 defendant Whytley John gent 585869 585869 Whytley, John, of London, gent 11
4171091 2085366 2085366 defendant Cornwall John gent 585869 585869 Cornwall, John, of London, or of More Parke, Herts, gent 12
4171092 2085366 2085366 defendant Coxe Richard gent 585869 585869 Coxe, Richard, of London, gent 13
4171093 2085366 2085366 defendant Cudworthe William gent 585869 585869 Cudworthe, William, of London, or of Darfeld, Yorks, gent 14
4171094 2085366 2085366 defendant Pearson Richard gent 585869 585869 Pearson, Richard, of London, or of Holden, Yorks, gent 15
4171095 2085366 2085366 defendant Raysinge Marmaduke gent 585869 585869 Raysinge, Marmaduke, of London, or of Malton, Yorks, gent 16
4171096 2085366 2085366 defendant Wilkinson Richard gent 585869 585869 Wilkinson, Richard, of London, or of Burstall, Yorks, gent 17
4171097 2085366 2085366 defendant Wilkinson Richard gent 585869 585869 Wilkinson, Richard, of London, or of Bolton on Derne, Yorks, gent 18
4171098 2085366 2085366 defendant Fenne John gent 585869 585869 Fenne, John, of London, or of Fletcham, Norf, gent 19
4171099 2085366 2085366 defendant Kempe Robert gent 585869 585869 Kempe, Robert, of London, or of Gyssinge, Norf, gent 20
4171100 2085366 2085366 defendant Graye George gent 686157 686157 Graye, George, of Envelde, Staffs, gent 21
4171101 2085366 2085366 defendant Jarvys Robert gent 708057 708057 Jarvys, Robert, of Chatkyll, Staffs, gent 22
4171102 2085366 2085366 defendant Robynson John gent 644876 644876 Robynson, John, of Drayton Bassett, gent 23
4171103 2085366 2085366 defendant Hopton George gent 585869 585869 Hopton, George, of London, or of Hopton, Salop, gent 24
4171104 2085366 2085366 defendant Litleton Thomas gent 585869 585869 Litleton, Thomas, of London, or of Mounslowe, Salop, gent 25
4171105 2085366 2085366 defendant Mungumbrye Richard gent 585869 585869 Mungumbrye, Richard, of London, or of Shrewsbury, gent 26
4171106 2085366 2085366 defendant Purcell Thomas gent 585869 585869 Purcell, Thomas, of London, or of Dinthill, Salop, gent 27
4171107 2085366 2085366 defendant Purcell Thomas gent 585869 585869 Purcell, Thomas, of London, or of Onslowe, Salop, gent 28
4171108 2085366 2085366 defendant Hampden Edmund gent 585869 585869 Hampden, Edmund, of London, or of Hartwell, Bucks, gent 29
4171109 2085366 2085366 defendant Wright Edmund gent 585869 585869 Wright, Edmund, of London, or of Kingsaye, Bucks, gent 30
4171110 2085366 2085366 defendant Wyrdman Robert gent 585869 585869 Wyrdman, Robert, of London, or of Charleton, berks, gent 31
4171111 2085366 2085366 defendant Lenton Thomas gent 708064 708064 Lenton, Thomas, of Silke Jenningham, Essex, gent 32
4171112 2085366 2085366 defendant Watton John gent 585869 585869 Watton, John, of London, or of Romforde, Essex, gent 33
4171113 2085366 2085366 defendant Poole William of London or of Poole, Cheshire, gent   Poole, William of London, or of Poole, Cheshire, gent 34
4171114 2085366 2085366 defendant Rosseter Edward gent 585869 585869 Rosseter, Edward, of London, or of Somerbye, Lincs, gent 35
4171115 2085366 2085366 defendant Stowford James gent 585869 585869 Stowford, James, of London, or of Witheridge, Devon, gent 36
4171116 2085366 2085366 defendant Shalcrosse William gent 585869 585869 Shalcrosse, William, of London, or of Shalcrosse, Derbs, gent 37
4171117 2085366 2085366 defendant Thwayte James gent 606678 606678 Thwayte, James, of Marston, Yorks, gent 38
4171118 2085366 2085366 defendant Wrothe William gent 585869 585869 Wrothe, William, of London, or of Islington, Middx, gent 39
4171119 2085366 2085366 defendant Widowson Gabrielson gent 585869 585869 Widowson, Gabrielson, of London, or of Lowdam, Notts, gent 40
4171120 2085366 2085366 defendant Loyshe John gent 585869 585869 Loyshe, John, of London, or of Oxford, gent 41
4171121 2085366 2085366 defendant Ferne Anthony gent 585869 585869 Ferne, Anthony, of London, or of Oxford, gent 42

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