names

44 rows where case_id = 2001276

✎ 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
3932805 2001276 2001276 plaintiff Garnerus William attorney of the Court of Common Pleas   Garnerus, William, attorney of the Court of Common Pleas 0
3932806 2001276 2001276 defendant Wynton John yeoman 608637 608637 Wynton, John, of Bromyard, yeoman 0
3932807 2001276 2001276 defendant Elmore John yeoman 608637 608637 Elmore, John, of Bromyard, yeoman 1
3932808 2001276 2001276 defendant Jones Thomas husbandman 654535 654535 Jones, Thomas, of Aubury or Anbury, husbandman 2
3932809 2001276 2001276 defendant Gilbert Walter laborer 604145 604145 Gilbert, Walter, of Pembridge, laborer 3
3932810 2001276 2001276 defendant Counope George gent 604145 604145 Counope, George, of Pembridge, gent 4
3932811 2001276 2001276 defendant Gyles John yeoman 654536 654536 Gyles, John, of Erbeche, yeoman 5
3932812 2001276 2001276 defendant Morgan Hugo husbandman 605812 605812 Morgan, Hugo, of Wylley, husbandman 6
3932813 2001276 2001276 defendant Downe Edward tailor 654537 654537 Downe, Edward, of Kynges Pewne, tailor 7
3932814 2001276 2001276 defendant Flecher John husbandman 654538 654538 Flecher, John, of Come, husbandman 8
3932815 2001276 2001276 defendant Wodhowse William husbandman 654539 654539 Wodhowse, William, of Sanbache, husbandman 9
3932816 2001276 2001276 defendant Crose Hugh husbandman 602351 602351 Crose, Hugh, of Stretton, husbandman 10
3932817 2001276 2001276 defendant Griffyth Richard yeoman 646685 646685 Griffyth, Richard, of Wigmore, yeoman 11
3932818 2001276 2001276 defendant Rychardes John husbandman 586422 586422 Rychardes, John, of Lynton, husbandman 12
3932819 2001276 2001276 defendant Brodford William husbandman 654540 654540 Brodford, William, of Dymyngton, husbandman 13
3932820 2001276 2001276 defendant Cradock Humphrey laborer 654541 654541 Cradock, Humphrey, of Dymygton, laborer 14
3932821 2001276 2001276 defendant Edwyn Richard   623651 623651 Edwyn, Richard, of Kynton, shoe maker 15
3932822 2001276 2001276 defendant Bell Henry sadler 586392 586392 Bell, Henry, of Leomynster, sadler 16
3932823 2001276 2001276 defendant Rede John husbandman 587494 587494 Rede, John, of Webley, husbandman 17
3932824 2001276 2001276 defendant ap Thomas Roger husbandman 600182 600182 ap Thomas, Roger, of Dorston, husbandman 18
3932825 2001276 2001276 defendant More John husbandman 650171 650171 More, John, of Lynhales, husbandman 19
3932826 2001276 2001276 defendant Baker John yeoman 586392 586392 Baker, John, of Leomynster, yeoman 20
3932827 2001276 2001276 defendant Longeston Thomas yeoman 587058 587058 Longeston, Thomas, of Sutton, yeoman 21
3932828 2001276 2001276 defendant David Lewis husbandman 600182 600182 David, Lewis, of Dorston, husbandman 22
3932829 2001276 2001276 defendant Jones Nicholas yeoman 586422 586422 Jones, Nicholas, of Lynton, yeoman 23
3932830 2001276 2001276 defendant ap Robert Partrige Thomas husbandman 600182 600182 ap Robert Partrige, Thomas, of Dorston, husbandman 24
3932831 2001276 2001276 defendant Toke Thomas clerk 612825 612825 Toke, Thomas, of Yarkehyll, clerk 25
3932832 2001276 2001276 defendant ap Jenkyn Simon husbandman 654543 654543 ap Jenkyn, Simon, of Harlesyewes, husbandman 26
3932833 2001276 2001276 defendant Wyllys Richard husbandman 654544 654544 Wyllys, Richard, of Morton Jeffres, husbandman 27
3932834 2001276 2001276 defendant Carter James laborer 608637 608637 Carter, James, of Bromyard, laborer 28
3932835 2001276 2001276 defendant Harys Robert husbandman 593739 593739 Harys, Robert, of Pencombe, husbandman 29
3932836 2001276 2001276 defendant Taylor Richard husbandman 586392 586392 Taylor, Richard, of Leomynster, husbandman 30
3932837 2001276 2001276 defendant Dekyns Thomas husbandman 601796 601796 Dekyns, Thomas, of Luston, husbandman 31
3932838 2001276 2001276 defendant Ryse William husbandman 594529 594529 Ryse, William, of Bodenham, husbandman 32
3932839 2001276 2001276 defendant Ryle John husbandman 594529 594529 Ryle, John, of Bodenham, husbandman 33
3932840 2001276 2001276 defendant Bullock William husbandman 654545 654545 Bullock, William, of Docyngton, husbandman 34
3932841 2001276 2001276 defendant Carponder Robert husbandman 654546 654546 Carponder, Robert, of Mathern, husbandman 35
3932842 2001276 2001276 defendant Bullocke John husbandman 654547 654547 Bullocke, John, of Codynton, husbandman 36
3932843 2001276 2001276 defendant Ceane Richard yeoman 646195 646195 Ceane, Richard, of Erdysley, yeoman 37
3932844 2001276 2001276 defendant Lewys Richard gent 630011 630011 Lewys, Richard, of Radnors, gent 38
3932845 2001276 2001276 defendant Crofte or Croste John yeoman 609571 609571 Crofte or Croste, John, of Arderley, yeoman 39
3932846 2001276 2001276 defendant Noblett William husbandman   Noblett, William, husbandman 40
3932847 2001276 2001276 defendant Coke William laborer 592031 592031 Coke, William, of Madley, laborer 41
3932848 2001276 2001276 defendant Lewys John yeoman 587494 587494 Lewys, John, of Webley, yeoman 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);