names

50 rows where case_id = 2028865

✎ 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
4011433 2028865 2028865 plaintiff Plowden Edmund esq, treasurer of Middle Temple   Plowden, Edmund, esq, treasurer of Middle Temple 0
4011434 2028865 2028865 defendant Boughton William gent 670653 670653 Boughton, William, of London, Middle Temple, gent 0
4011435 2028865 2028865 defendant Chyshull Lawrence gent 670653 670653 Chyshull, Lawrence, of London, Middle Temple, gent 1
4011436 2028865 2028865 defendant Sandford Humphrey gent 670653 670653 Sandford, Humphrey, of London, Middle Temple, gent 2
4011437 2028865 2028865 defendant Luter Thomas gent 670653 670653 Luter, Thomas, of London, Middle Temple, gent 3
4011438 2028865 2028865 defendant Berkley Henry gent 670653 670653 Berkley, Henry, of London, Middle Temple, gent 4
4011439 2028865 2028865 defendant Sand Anthony gent 670653 670653 Sand, Anthony, of London, Middle Temple, gent 5
4011440 2028865 2028865 defendant Clamppe Richard gent 670653 670653 Clamppe, Richard, of London, Middle Temple, gent 6
4011441 2028865 2028865 defendant Halley Gabriel gent 670653 670653 Halley, Gabriel, of London, Middle Temple, gent 7
4011442 2028865 2028865 defendant Houldforte Gregory gent 670653 670653 Houldforte, Gregory, of London, Middle Temple, gent 8
4011443 2028865 2028865 defendant Mocket Timpthy gent 670653 670653 Mocket, Timpthy, of London, Middle Temple, gent 9
4011444 2028865 2028865 defendant Tyrrell Thomas   670653 670653 Tyrrell, Thomas, of London, Middle Temple, gent, son of Henry Tirrell, of Herne, Essex 10
4011445 2028865 2028865 defendant Coll or Coles John gent 670653 670653 Coll or Coles, John, of London, Middle Temple, gent 11
4011446 2028865 2028865 defendant Tennaunt Thomas gent 670653 670653 Tennaunt, Thomas, of London, Middle Temple, gent 12
4011447 2028865 2028865 defendant Cave Thomas     Cave, Thomas 13
4011448 2028865 2028865 defendant Holte Edward     Holte, Edward 14
4011449 2028865 2028865 defendant Goddard William     Goddard, William 15
4011450 2028865 2028865 defendant Buckfilde George     Buckfilde, George 16
4011451 2028865 2028865 defendant Frevyll Robert     Frevyll, Robert 17
4011452 2028865 2028865 defendant Grymston Edward     Grymston, Edward 18
4011453 2028865 2028865 defendant Lewkenor Edward     Lewkenor, Edward 19
4011454 2028865 2028865 defendant Yonger Thomas     Yonger, Thomas 20
4011455 2028865 2028865 defendant Jenkes Francis     Jenkes, Francis 21
4011456 2028865 2028865 defendant Armytage John     Armytage, John 22
4011457 2028865 2028865 defendant Blunden Andrew     Blunden, Andrew 23
4011458 2028865 2028865 defendant Bysse James     Bysse, James 24
4011459 2028865 2028865 defendant Beynes Roger     Beynes, Roger 25
4011460 2028865 2028865 defendant Bartlam John     Bartlam, John 26
4011461 2028865 2028865 defendant Butler Francis     Butler, Francis 27
4011462 2028865 2028865 defendant Atkyns Thomas     Atkyns, Thomas 28
4011463 2028865 2028865 defendant Brouncker Henry     Brouncker, Henry 29
4011464 2028865 2028865 defendant Cole Edmund     Cole, Edmund 30
4011465 2028865 2028865 defendant Rogers John     Rogers, John 31
4011466 2028865 2028865 defendant Corbett George     Corbett, George 32
4011467 2028865 2028865 defendant Corbet Robert son of Andrew Corbet, of Morton, Salop, knight   Corbet, Robert, son of Andrew Corbet, of Morton, Salop, knight 33
4011468 2028865 2028865 defendant Wyndesore Andrew     Wyndesore, Andrew 34
4011469 2028865 2028865 defendant Cary George: Southcott George   Cary, George: Southcott, George 35
4011470 2028865 2028865 defendant Cornewayll Thomas     Cornewayll, Thomas 36
4011471 2028865 2028865 defendant Bray Reginald     Bray, Reginald 37
4011472 2028865 2028865 defendant Catesbye William     Catesbye, William 38
4011473 2028865 2028865 defendant Chauncy Tobias     Chauncy, Tobias 39
4011474 2028865 2028865 defendant Duckett Stephen     Duckett, Stephen 40
4011475 2028865 2028865 defendant Dillon Thomas     Dillon, Thomas 41
4011476 2028865 2028865 defendant Bathe John     Bathe, John 42
4011477 2028865 2028865 defendant Eyton Ralph son of Hugh Eaton, of Chesterhurste, Staffs, gent   Eyton, Ralph, son of Hugh Eaton, of Chesterhurste, Staffs, gent 43
4011478 2028865 2028865 defendant Farryngton Francis     Farryngton, Francis 44
4011479 2028865 2028865 defendant Grymestone Marmaduke     Grymestone, Marmaduke 45
4011480 2028865 2028865 defendant Gill Edward     Gill, Edward 46
4011481 2028865 2028865 defendant Wright William     Wright, William 47
4011482 2028865 2028865 defendant Greneham Francis all of London, Middle Temple, gents   Greneham, Francis, all of London, Middle Temple, gents 48

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