names

30 rows where case_id = 2082541

✎ 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
4162783 2082541 2082541 plaintiff Stone Thomas Principal of New Inn, St Clement Danes, Middx   Stone, Thomas, Principal of New Inn, St Clement Danes, Middx 0
4162784 2082541 2082541 defendant Edward James gent 706409 706409 Edward, James, of Churche Stoke, Montgomery, gent 0
4162785 2082541 2082541 defendant Waters Edward gent 706410 706410 Waters, Edward, of Sturton, Wilts, gent 1
4162786 2082541 2082541 defendant Hunston Richard gent 594193 594193 Hunston, Richard, of Walsoken, Norf, gent 2
4162787 2082541 2082541 defendant Chabner Robert gent 624381 624381 Chabner, Robert, of Middle Temple, London, gent 3
4162788 2082541 2082541 defendant Manley Robert gent 645644 645644 Manley, Robert, of Stoke Nayland, Suff, gent 4
4162789 2082541 2082541 defendant Grymshawe James gent 585869 585869 Grymshawe, James, of London, or of St Pulkers , Middx, gent 5
4162790 2082541 2082541 defendant Cowper William gent 672405 672405 Cowper, William, of Shelford Parva, Cams, gent 6
4162791 2082541 2082541 defendant Harrys Andrew gent 586859 586859 Harrys, Andrew, of Salisbury, gent 7
4162792 2082541 2082541 defendant Coker Luke Gent 706412 706412 Coker, Luke, of Mawpowder, Dorset, Gent 8
4162793 2082541 2082541 defendant Alleyn John gent 618349 618349 Alleyn, John, of Hynton, Cams, gent 9
4162794 2082541 2082541 defendant Rogers John gent 675543 675543 Rogers, John, of Shelford Magna, Cams, gent 10
4162795 2082541 2082541 defendant Webberston Giles gent 592760 592760 Webberston, Giles, of New Inn, St Clement Danes, gent 11
4162796 2082541 2082541 defendant Welby Humphrey gent 706413 706413 Welby, Humphrey, of Fsdick, Lincs, gent 12
4162797 2082541 2082541 defendant Cole Robert gent 706414 706414 Cole, Robert, of Lamerton, Cornw, gent 13
4162798 2082541 2082541 defendant Newcourte Philip gent 706415 706415 Newcourte, Philip, of Holdesworthy, Devon, gent 14
4162799 2082541 2082541 defendant Opy Thomas gent 587862 587862 Opy, Thomas, of Bodmyn, Cornw, gent 15
4162800 2082541 2082541 defendant Kempthorn Nicholas gent 587114 587114 Kempthorn, Nicholas, of Bodmyn, gent 16
4162801 2082541 2082541 defendant Manley John gent 585869 585869 Manley, John, of London, gent 17
4162802 2082541 2082541 defendant Cradock Francis gent 587516 587516 Cradock, Francis, of Stafford, gent 18
4162803 2082541 2082541 defendant Vaughan William   667732 667732 Vaughan, William, of Glasbury, Radnorm gent 19
4162804 2082541 2082541 defendant ap Richard Jenkin gent 706417 706417 ap Richard, Jenkin, of Netle, Glamorgan, gent 20
4162805 2082541 2082541 defendant Raydon Giles or Truerowe, Cornw, gent   Raydon, Giles, or Truerowe, Cornw, gent 21
4162806 2082541 2082541 defendant Thomas John gent 624381 624381 Thomas, John, of Middle Temple, London, gent 22
4162807 2082541 2082541 defendant Whytehead William gent 706418 706418 Whytehead, William, of Monk Warmothe, Durham, gent 23
4162808 2082541 2082541 defendant Barnard Edmund gent 706419 706419 Barnard, Edmund, of London, St Brigitte, gent 24
4162809 2082541 2082541 defendant Tylston Hugh gent 706420 706420 Tylston, Hugh, of Goldston, Salop, gent 25
4162810 2082541 2082541 defendant Tylston William gent 592760 592760 Tylston, William, of New Inn, St Clement Danes, gent 26
4162811 2082541 2082541 defendant Johnson John gent 661752 661752 Johnson, John, of Thornham, Norf, gent 27
4162812 2082541 2082541 defendant Ascough Robert gent 706421 706421 Ascough, Robert, of Askeby, Lincs, gent 28

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