names

59 rows where case_id = 2082542

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation

id ▼ case_id role surname forename occupation place_id raw_segment seq
4162813 2082542 2082542 plaintiff Stone Thomas Principal of New Inn, St Clement Danes, Middx   Stone, Thomas, Principal of New Inn, St Clement Danes, Middx 0
4162814 2082542 2082542 defendant Pett Jerome gent 621196 621196 Pett, Jerome, of Borden, Kent, gent 0
4162815 2082542 2082542 defendant Bowdem Luke gent 590317 590317 Bowdem, Luke, of Dorchester, Dorset, gent 1
4162816 2082542 2082542 defendant Wood William gent 585869 585869 Wood, William, of London, gent 2
4162817 2082542 2082542 defendant Hunt John gent 706422 706422 Hunt, John, of Lyndon, Rutland, gent 3
4162818 2082542 2082542 defendant Freman Richard gent 646094 646094 Freman, Richard, of Blockeley, Worcs, gent 4
4162819 2082542 2082542 defendant Salmon Simon gent 684575 684575 Salmon, Simon, of Midsomer Norton, Soms, gent 5
4162820 2082542 2082542 defendant Force John gent 706423 706423 Force, John, of Farryngton, Devon, gent 6
4162821 2082542 2082542 defendant Lloyd Richard gent 585869 585869 Lloyd, Richard, of London, gent 7
4162822 2082542 2082542 defendant Michell Thomas gent 706424 706424 Michell, Thomas, of Bangor, Carnarvon, gent 8
4162823 2082542 2082542 defendant Shirwood Thomas gent 650425 650425 Shirwood, Thomas, of Walkyngton, Yorks, gent 9
4162824 2082542 2082542 defendant Holland Robert gent 585869 585869 Holland, Robert, of London, gent 10
4162825 2082542 2082542 defendant Holland William gent 585869 585869 Holland, William, of London, gent 11
4162826 2082542 2082542 defendant Gybbes John gent 596561 596561 Gybbes, John, of Bath, Soms, gent 12
4162827 2082542 2082542 defendant Wyllowes Robert gent 706425 706425 Wyllowes, Robert, of Barlowe, Cams, gent 13
4162828 2082542 2082542 defendant Kyrkham William gent 706426 706426 Kyrkham, William, of Pynne, Devon, gent 14
4162829 2082542 2082542 defendant Lovell Francis gent 585869 585869 Lovell, Francis, of London, gent 15
4162830 2082542 2082542 defendant Baker John gent 585869 585869 Baker, John, of London, gent 16
4162831 2082542 2082542 defendant Walden William gent 585869 585869 Walden, William, of London, gent 17
4162832 2082542 2082542 defendant Mathewe Richard gent 690942 690942 Mathewe, Richard, of Barryngton, Glos, gent 18
4162833 2082542 2082542 defendant Tucker Thomas gent 585869 585869 Tucker, Thomas, of London, gent 19
4162834 2082542 2082542 defendant Thorpe John gent 669036 669036 Thorpe, John, of Torksey, Lincs, gent 20
4162835 2082542 2082542 defendant Nevell Francis gent 706427 706427 Nevell, Francis, of Bedmynster, Kent , gent 21
4162836 2082542 2082542 defendant Webbe German gent 587936 587936 Webbe, German, of Feversham, Kent, gent 22
4162837 2082542 2082542 defendant Champneis William Devon, gent 666929 666929 Champneis William, of Torrington Magna, Devon, gent 23
4162838 2082542 2082542 defendant Griffith Richard gent 706428 706428 Griffith, Richard, of Bewmarys, Anglesey, gent 24
4162839 2082542 2082542 defendant Kyrford William gent 608735 608735 Kyrford, William, of Charde, Soms, gent 25
4162840 2082542 2082542 defendant Barnes William gent 706429 706429 Barnes, William, of Calton, Worcs, gent 26
4162841 2082542 2082542 defendant Penry Lewis gent 700708 700708 Penry, Lewis, of Penbrey, Carmarthen, gent 27
4162842 2082542 2082542 defendant Jones Thomas gent 706430 706430 Jones, Thomas, of Kedwely, Carmarthen, gent 28
4162843 2082542 2082542 defendant Amyas William gent 706431 706431 Amyas, William, of Stoterton, Salop, gent 29
4162844 2082542 2082542 defendant Swynborne Thomas gent 706432 706432 Swynborne, Thomas, of Captheton, Northumb, gent 30
4162845 2082542 2082542 defendant Tempest William gent 706433 706433 Tempest, William, of Holmested, Durham, gent 31
4162846 2082542 2082542 defendant Bourcher Daniel gent 700455 700455 Bourcher, Daniel, of Wyndsor, Berks, gent 32
4162847 2082542 2082542 defendant Longe William gent 706434 706434 Longe, William, of Box, Wilts, gent 33
4162848 2082542 2082542 defendant Carter William gent 706435 706435 Carter, William, of Sanbyche, Cheshire, gent 34
4162849 2082542 2082542 defendant Edward Henry gent 706436 706436 Edward, Henry, of Michelstouwe, Glamorgan, gent 35
4162850 2082542 2082542 defendant Wylls Peter gent 662293 662293 Wylls, Peter, of Lanrake, Cornw, gent 36
4162851 2082542 2082542 defendant Carmynowe Nicholas gent 626592 626592 Carmynowe, Nicholas, of Peryn, Cornw, gent 37
4162852 2082542 2082542 defendant Carmynowe John gent 608316 608316 Carmynowe, John, of Peryn, gent 38
4162853 2082542 2082542 defendant Conway Denis gent 585921 585921 Conway, Denis, of Arrowe, Warks, gent 39
4162854 2082542 2082542 defendant Raynesford Thomas gent 650763 650763 Raynesford, Thomas, of Lincolns Inn, Middx, gent 40
4162855 2082542 2082542 defendant Smyth Paul gent 706437 706437 Smyth, Paul, of Whitechappell, Middx, gent 41
4162856 2082542 2082542 defendant Newman Geoffrey gent 706438 706438 Newman, Geoffrey, of Fisshed, Dorset, gent 42
4162857 2082542 2082542 defendant Whithall Francis gent 706439 706439 Whithall, Francis, of Blokeswyke, Staffs, gent 43
4162858 2082542 2082542 defendant Morrys James   650539 650539 Morrys, James, of Uske, Monmouth 44
4162859 2082542 2082542 defendant Sybthorpe Christopher gent 695397 695397 Sybthorpe, Christopher, of Hallingbury, Essex, gent 45
4162860 2082542 2082542 defendant Evans Richard gent 586697 586697 Evans, Richard, of Shrewsbury, gent 46
4162861 2082542 2082542 defendant Lloid David gent 586697 586697 Lloid, David, of Shrewsbury, gent 47
4162862 2082542 2082542 defendant Brett Warham gent 665313 665313 Brett, Warham, of Leed, Kent, gent 48
4162863 2082542 2082542 defendant Newton Christopher gent 629733 629733 Newton, Christopher, of South Petherton, Soms, gent 49
4162864 2082542 2082542 defendant Vymcomb Simon gent 643405 643405 Vymcomb, Simon, of North Petherton, Soms, gent 50
4162865 2082542 2082542 defendant Games or Gaines Walter gent 654873 654873 Games or Gaines, Walter, of Brekenock, gent 51
4162866 2082542 2082542 defendant Laughton Edward gent 659207 659207 Laughton, Edward, of Uxbridge, Middx, gent 52
4162867 2082542 2082542 defendant Williams John gent 662211 662211 Williams, John, of Cardiff, Glamorgan, gent 53
4162868 2082542 2082542 defendant Smyth Henry gent 689104 689104 Smyth, Henry, of Cressing, Essex, gent 54
4162869 2082542 2082542 defendant Wyllymott James gent 599017 599017 Wyllymott, James, of Kelsey, gent 55
4162870 2082542 2082542 defendant Greene James gent 706440 706440 Greene, James, of Mylton, Soms, gent 56
4162871 2082542 2082542 defendant Elrington Robert   590317 590317 Elrington, Robert, of Dorchester, Dorset, gent, et al 57

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