names

69 rows where place_id = 594040

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614323 1872136 1872136 defendant Horne William brewer 594040 594040 Horne, William, of St Giles in the Fields, brewer 1
3614324 1872136 1872136 defendant Richardson William brewer 594040 594040 Richardson, William, of St Giles in the Fields, brewer 2
3614325 1872136 1872136 defendant Harryson John husbandman 594040 594040 Harryson, John, of St Giles in the Fields, husbandman 3
3614326 1872136 1872136 defendant Smalley William husbandman 594040 594040 Smalley, William, of St Giles in the Fields, husbandman 4
3614329 1872137 1872137 defendant Wymprowe John brewer 594040 594040 Wymprowe, John, of St Giles in the Fields, brewer 0
3623009 1874723 1874723 defendant Raulyns Philip yeoman 594040 594040 Raulyns, Philip, of St Giles in the Fields, yeoman 0
3625255 1875433 1875433 defendant Harryes John brewer 594040 594040 Harryes, John, of St Giles in the Fields, brewer 4
3628412 1903752 1903752 defendant Sutton George gent 594040 594040 Sutton, George, of St Giles in the Fields, gent 1
3629709 1904147 1904147 defendant Sutton George gent 594040 594040 Sutton, George, of St Giles in the Fields, gent 1
3772927 1949233 1949233 defendant Horne Edmund brewer 594040 594040 Horne, Edmund, of St Giles in the Fields, brewer 0
3789064 1954390 1954390 defendant Sutton George gent 594040 594040 Sutton, George, of St Giles in the Fields, gent 1
3789774 1954633 1954633 defendant Horne Edmund brewer 594040 594040 Horne, Edmund, of St Giles in the Fields, brewer 0
3790578 1954876 1954876 defendant Horne Edmund brewer 594040 594040 Horne, Edmund, of St Giles in the Fields, brewer 0
3794006 1955989 1955989 defendant Horne Edmund brewer 594040 594040 Horne, Edmund, of St Giles in the Fields, brewer 1
3794007 1955989 1955989 defendant Harrys William   594040 594040 Harrys, William, of St Giles in the Fields, wheel wright 2
3815641 1962809 1962809 plaintiff Harrys William wheeler 594040 594040 Harrys, William, of St Giles in the Fields, wheeler 0
3815642 1962809 1962809 defendant Horne Edmund brewer 594040 594040 Horne, Edmund, of St Giles in the Fields, brewer 0
3815643 1962810 1962810 plaintiff Harrys William wheeler 594040 594040 Harrys, William, of St Giles in the Fields, wheeler 0
3833451 1968391 1968391 defendant Colt Thomas   594040 594040 Colt, Thomas, of St Giles in the Fields, wheelwright 0
3842951 1971331 1971331 defendant Tayler Richard innholder and brewer 594040 594040 Tayler, Richard, of St Giles in the Fields, innholder and brewer 0
3849359 1973397 1973397 defendant Colt Thomas   594040 594040 Colt, Thomas, of St Giles in the Fields, wheel wright 0
3849361 1973398 1973398 defendant Colt Thomas   594040 594040 Colt, Thomas, of St Giles in the Fields, wheelwright 0
3856308 1975591 1975591 defendant Tayler Richard innholder 594040 594040 Tayler, Richard, of St Giles in the Fields, innholder 0
3868278 1979629 1979629 defendant Maker Nicholas yeoman 594040 594040 Maker, Nicholas, of St Giles in the Fields, yeoman 0
3870147 1980260 1980260 defendant Wylkynson William brewer 594040 594040 Wylkynson, William, of St Giles in the Fields, brewer 0
3877473 1982701 1982701 defendant Horne Anne widow 594040 594040 Horne, Anne, of St Giles in the Fields, widow 0
3883743 1984833 1984833 defendant Newman William yeoman 594040 594040 Newman, William, of St Giles in the Fields, yeoman 0
3894200 1988278 1988278 defendant Wynter Thomas clerk 594040 594040 Wynter, Thomas, of St Giles in the Fields, clerk 0
4018904 2031494 2031494 defendant Crocke William saddler 594040 594040 Crocke, William, of St Giles in the Fields, saddler 0
4025783 2033875 2033875 plaintiff Bryan John gent 594040 594040 Bryan, John, of St Giles in the Fields, gent 0
4034716 2037097 2037097 defendant Petyvale Edward innholder 594040 594040 Petyvale, Edward, of St Giles in the Fields, innholder 1
4039934 2038904 2038904 plaintiff Mascall Roger brewer 594040 594040 Mascall, Roger, of St Giles in the Fields, brewer 0
4039936 2038905 2038905 plaintiff Mascall Roger brewer 594040 594040 Mascall, Roger, of St Giles in the Fields, brewer 0
4066338 2048252 2048252 plaintiff Hollingbrigge John gent 594040 594040 Hollingbrigge, John, of St Giles in the Fields, gent 0
4066340 2048253 2048253 plaintiff Hollingbrigge John gent 594040 594040 Hollingbrigge, John, of St Giles in the Fields, gent 0
4066342 2048254 2048254 plaintiff Hollingbrigge John gent 594040 594040 Hollingbrigge, John, of St Giles in the Fields, gent 0
4119515 2067269 2067269 defendant ap Dio David ap Jevan ap Holl yeoman 594040 594040 ap Dio, David ap Jevan ap Holl, of St Giles in the Fields, or of Wigo, Montgomery, yeoman 0
4119516 2067269 2067269 defendant ap Jevan Lewis ap David yeoman 594040 594040 ap Jevan, Lewis ap David, of St Giles in the Fields, or of Wigo, yeoman 1
4119517 2067269 2067269 defendant Gynneth Jevan ap Griffith yeoman 594040 594040 Gynneth, Jevan ap Griffith, of St Giles in the Fields, or of Garthill, Montgomery, yeoman 2
4119518 2067269 2067269 defendant ap Madock James ap Owen yeoman 594040 594040 ap Madock, James ap Owen, of St Giles in the Fields, or of Grange, Montgomery, yeoman 3
4130631 2071266 2071266 defendant Hopton William esq 594040 594040 Hopton, William, of St Giles in the Fields, yeoman, or of Chirburie, Salop, esq 0
4137296 2073687 2073687 defendant Sanforde John weaver 594040 594040 Sanforde, John, of St Giles in the Fields, weaver 0
4138284 2074059 2074059 defendant Minckfield Edward Mary gent 594040 594040 Minckfield, Edward Mary, of St Giles in the Fields, gent 2
4142488 2075544 2075544 defendant ap Dio David ap Jevan ap Howell yeoman 594040 594040 ap Dio, David ap Jevan ap Howell, of St Giles in the Fields, or of Wige, Montgomery, yeoman 0
4142489 2075544 2075544 defendant ap Jevan Lewis ap David yeoman 594040 594040 ap Jevan, Lewis ap David, of St Giles in the Fields, or of Wige, yeoman 1
4142490 2075544 2075544 defendant Eynneth or Gynneth Griffith yeoman 594040 594040 Eynneth or Gynneth, Griffith, of St Giles in the Fields, or of Garthillym, Montgomery, yeoman 2
4142491 2075544 2075544 defendant ap Maddock James ap Owen yeoman 594040 594040 ap Maddock, James ap Owen, of St Giles in the Fields, or of Graige, Montgomery, yeoman 3
4154300 2079598 2079598 defendant Hopton William esq 594040 594040 Hopton, William, of St Giles in the Fields, or of Chirburye, Salop, esq 0
4170709 2085250 2085250 defendant Sutton William   594040 594040 Sutton, William, of St Giles in the Fields, glover, administrators of 2
4185324 2090378 2090378 defendant Cole or Coe John baker 594040 594040 Cole or Coe, John, of St Giles in the Fields, baker 0
4190849 2092363 2092363 defendant Tuttell Franics yeoman 594040 594040 Tuttell, Franics, of St Giles in the Fields, baker, or of Milcott, Warks, yeoman 0
4240758 2109890 2109890 defendant Morgan John laborer 594040 594040 Morgan, John, of St Giles in the Fields, laborer 0
4268629 2119101 2119101 defendant Rownckhorne Alexander yeoman 594040 594040 Rownckhorne, Alexander, of St Giles in the Fields, yeoman 0
4296224 2128748 2128748 defendant Burton John   594040 594040 Burton, John, of St Giles in the Fields, collar maker 0
4395454 2163064 2163064 defendant Amptill John Middx, yeoman 594040 594040 Amptill John, of St Giles in the Fields, Middx, yeoman, executor of 0
4407174 2166963 2166963 defendant Wright John shoemaker 594040 594040 Wright, John, of St Giles in the Fields, shoemaker 0
4982614 2351712 2351712 defendant Basset Henry brewer 594040 594040 Basset, Henry, of St Giles in the Fields, brewer 1
5013038 2360642 2360642 defendant Paunton Thomas laborer 594040 594040 Paunton, Thomas, of St Giles in the Fields, laborer 3
5013044 2360643 2360643 defendant Paunton Thomas laborer 594040 594040 Paunton, Thomas, of St Giles in the Fields, laborer 3
5228215 2423859 2423859 defendant Brooke Henry gent 594040 594040 Brooke, Henry, of St Giles in the Fields, gent 0
5376841 2468349 2468349 defendant Thomas John   594040 594040 Thomas, John, of St Giles in the fields, inn holder 0
5399928 2475071 2475071 plaintiff Fercloue John   594040 594040 Fercloue, John, of St Giles in the Fields 0
5412923 2478812 2478812 plaintiff Ferclove John   594040 594040 Ferclove, John, of St Giles in the Fields 0
5495231 2503468 2503468 defendant Walgrave William husbandman 594040 594040 Walgrave, William, of St Giles in the Fields, husbandman 3
5495236 2503469 2503469 defendant Walgrave William husbandman 594040 594040 Walgrave, William, of St Giles in the Fields, husbandman 3
5499166 2504699 2504699 defendant Herford John   594040 594040 Herford, John, of St Giles in the Fields, freemason 0
5503868 2506126 2506126 defendant Smyth William brewer 594040 594040 Smyth, William, of St Giles in the Fields, brewer 0
5518323 2510558 2510558 defendant Smyth William brewer 594040 594040 Smyth, William, of St Giles in the Fields, brewer 0
5551702 2520539 2520539 defendant Fyssher Thomas tanner 594040 594040 Fyssher, Thomas, of St Giles in the Fields, tanner 0

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