names

281 rows where place_id = 598927

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634566 1905614 1905614 defendant James William chapman 598927 598927 James, William, of St Ives, chapman 0
3661211 1913781 1913781 defendant Mylys Michael yeoman 598927 598927 Mylys, Michael, of St Ives, yeoman 0
3668721 1916151 1916151 defendant Ussher Thomas waterman 598927 598927 Ussher, Thomas, of St Ives, waterman 2
3669193 1916302 1916302 defendant Candeler John fishmonger 598927 598927 Candeler, John, of St Ives, fishmonger 0
3669194 1916302 1916302 defendant Palmer Bartholomew fishmonger 598927 598927 Palmer, Bartholomew, of St Ives, fishmonger 1
3674308 1918008 1918008 defendant Sterlyng Richard dyer 598927 598927 Sterlyng, Richard, of St Ives, dyer 1
3692483 1923831 1923831 plaintiff Keache John   598927 598927 Keache, John, of St Ives 0
3727975 1935017 1935017 defendant Crosseley John yeoman 598927 598927 Crosseley, John, of St Ives, yeoman 0
3735285 1937271 1937271 defendant Wright John butcher 598927 598927 Wright, John, of St Ives, butcher 1
3737198 1937865 1937865 defendant Owre John fisher 598927 598927 Owre, John, of St Ives, fisher 2
3743230 1939748 1939748 defendant Yong Thomas yeoman 598927 598927 Yong, Thomas, of St Ives, yeoman 1
3743232 1939748 1939748 defendant Pomesse John yeoman 598927 598927 Pomesse, John, of St Ives, yeoman 3
3751704 1942447 1942447 plaintiff Palmer Bartholomew   598927 598927 Palmer, Bartholomew, of St Ives 0
3755480 1943667 1943667 defendant Weston Ralph butcher 598927 598927 Weston, Ralph, of St Ives, butcher 0
3758341 1944605 1944605 plaintiff Bull Robert yeoman 598927 598927 Bull, Robert, of St Ives, yeoman 0
3759359 1944916 1944916 defendant Bone Henry baker 598927 598927 Bone, Henry, of St Ives, baker 0
3759389 1944925 1944925 defendant Boone Henry carver 598927 598927 Boone, Henry, of St Ives, carver 0
3760258 1945211 1945211 defendant Feld Richard husbandman 598927 598927 Feld, Richard, of St Ives, husbandman 0
3766473 1947171 1947171 defendant Marten Thomas husbandman 598927 598927 Marten, Thomas, of St Ives, husbandman 1
3774527 1949761 1949761 defendant Atkynson Thomas husbandman 598927 598927 Atkynson, Thomas, of St Ives, husbandman 1
3776368 1950361 1950361 plaintiff Bull Robert yeoman 598927 598927 Bull, Robert, of St Ives, yeoman 0
3783640 1952643 1952643 defendant Weston Robert butcher 598927 598927 Weston, Robert, of St Ives, butcher 0
3786092 1953441 1953441 plaintiff Pawmer Bartholomew   598927 598927 Pawmer, Bartholomew, of St Ives 0
3792090 1955380 1955380 defendant Sampson John fishmonger 598927 598927 Sampson, John, of St Ives, fishmonger 1
3793883 1955955 1955955 plaintiff Bull Robert yeoman 598927 598927 Bull, Robert, of St Ives, yeoman 0
3795406 1956435 1956435 defendant Norman William baker 598927 598927 Norman, William, of St Ives, baker 2
3802244 1958596 1958596 plaintiff Palmer Bartholomew   598927 598927 Palmer, Bartholomew, of St Ives 0
3805034 1959517 1959517 defendant Sterlyng John yeoman 598927 598927 Sterlyng, John, of St Ives, yeoman 1
3807151 1960129 1960129 defendant Wryght John butcher 598927 598927 Wryght, John, of St Ives, butcher 0
3808341 1960482 1960482 defendant Bony Thomas husbandman 598927 598927 Bony, Thomas, of St Ives, husbandman 0
3808342 1960482 1960482 defendant Bony John husbandman 598927 598927 Bony, John, of St Ives, husbandman 1
3808837 1960644 1960644 defendant Owndell Peter butcher 598927 598927 Owndell, Peter, of St Ives, butcher 1
3813237 1962050 1962050 defendant Gybson Robert mercer 598927 598927 Gybson, Robert, of St Ives, mercer 0
3817662 1963427 1963427 defendant Dove Thomas roper 598927 598927 Dove, Thomas, of St Ives, roper 0
3817663 1963427 1963427 defendant Bull Robert chapman 598927 598927 Bull, Robert, of St Ives, chapman 1
3817664 1963427 1963427 defendant Gybson Robert chapman 598927 598927 Gybson, Robert, of St Ives, chapman 2
3818434 1963664 1963664 plaintiff Marten John merchant 598927 598927 Marten, John, of St Ives, merchant 0
3819110 1963866 1963866 defendant Bull Robert, junior yeoman 598927 598927 Bull, Robert, junior, of St Ives, yeoman 0
3834974 1968876 1968876 defendant Martyn John yeoman 598927 598927 Martyn, John, of St Ives, yeoman 0
3842907 1971315 1971315 defendant Weston William glover 598927 598927 Weston, William, of St Ives, glover 0
3856011 1975505 1975505 defendant Bull Robert husbandman 598927 598927 Bull, Robert, of St Ives, husbandman 0
3856072 1975523 1975523 defendant Bull Robert husbandman 598927 598927 Bull, Robert, of St Ives, husbandman 0
3865023 1978502 1978502 defendant Weston Ralph butcher 598927 598927 Weston, Ralph, of St Ives, butcher 0
3865860 1978812 1978812 defendant Northffeld John shoemaker 598927 598927 Northffeld, John, of St Ives, shoemaker 0
3865861 1978812 1978812 defendant Fyssher William cordwainer 598927 598927 Fyssher, William, of St Ives, cordwainer 1
3865884 1978820 1978820 plaintiff Palmer Bartholomew   598927 598927 Palmer, Bartholomew, of St Ives 0
3865886 1978820 1978820 defendant Redhed John husbandman 598927 598927 Redhed, John, of St Ives, husbandman 1
3865888 1978820 1978820 defendant Weston Ralph butcher 598927 598927 Weston, Ralph, of St Ives, butcher 3
3865889 1978821 1978821 plaintiff Palmer Bartholomew   598927 598927 Palmer, Bartholomew, of St Ives 0
3879381 1983357 1983357 defendant Weston Ralph butcher 598927 598927 Weston, Ralph, of St Ives, butcher 0
3885581 1985430 1985430 defendant Martyn John yeoman 598927 598927 Martyn, John, of St Ives, yeoman 0
3888061 1986261 1986261 defendant Brown Edward shoemaker 598927 598927 Brown, Edward, of St Ives, shoemaker 0
3892532 1987748 1987748 plaintiff Mylys William (legal representative) 598927 598927 Mylys, William, of St Ives, merchant, administratrix of 0
3909423 1993452 1993452 defendant Marteyn John yeoman 598927 598927 Marteyn, John, of St Ives, yeoman 1
3917571 1996234 1996234 defendant Goldyng Robert Huntsgrocer 598927 598927 Goldyng, Robert, of St Ives, Huntsgrocer 4
3918962 1996663 1996663 defendant Jennyng Richard baker 598927 598927 Jennyng, Richard, of St Ives, baker 0
3920395 1997164 1997164 defendant Spencer Edward husbandman 598927 598927 Spencer, Edward, of St Ives, husbandman 0
3950349 2007204 2007204 plaintiff Fylby Thomas grocer 598927 598927 Fylby, Thomas, of St Ives, grocer 0
3970735 2014356 2014356 plaintiff Dodson William (legal representative) 598927 598927 Dodson, William, of St Ives, butcher, administrator of 0
4010932 2028688 2028688 defendant Palmer Robert waterman 598927 598927 Palmer, Robert, of St Ives, waterman 0
4016896 2030742 2030742 defendant Barrett William merchant 598927 598927 Barrett, William, of St Ives, merchant 0
4016898 2030743 2030743 defendant Penhelak John gent 598927 598927 Penhelak, John, of St Ives, gent 0
4016900 2030744 2030744 defendant Penheleck John gent 598927 598927 Penheleck, John, of St Ives, gent 0
4016901 2030744 2030744 defendant Barrett William merchant 598927 598927 Barrett, William, of St Ives, merchant 1
4027083 2034331 2034331 defendant Chun or Chunne John fishmonger 598927 598927 Chun or Chunne, John, of St Ives, fishmonger 1
4027087 2034332 2034332 defendant Chunne John fishmonger 598927 598927 Chunne, John, of St Ives, fishmonger 1
4027529 2034490 2034490 defendant Gibson Thomas cutler 598927 598927 Gibson, Thomas, of St Ives, cutler 2
4048108 2041757 2041757 defendant Penhelack John gent 598927 598927 Penhelack, John, of St Ives, gent 0
4060366 2046109 2046109 defendant Brown Thomas husbandman 598927 598927 Brown, Thomas, of St Ives, husbandman 1
4064968 2047754 2047754 defendant Curley Thomas yeoman 598927 598927 Curley, Thomas, of St Ives, yeoman 6
4075922 2051692 2051692 plaintiff Scysson Robert yeoman 598927 598927 Scysson, Robert, of St Ives, yeoman 0
4083860 2054500 2054500 defendant Gibson Thomas innholder 598927 598927 Gibson, Thomas, of St Ives, innholder 0
4083865 2054502 2054502 defendant Barnes John driller 598927 598927 Barnes, John, of St Ives, driller 0
4090152 2056764 2056764 defendant Sedgwicke Roger yeoman 598927 598927 Sedgwicke, Roger, of St Ives, yeoman 0
4097958 2059598 2059598 defendant Carvedres John merchant 598927 598927 Carvedres, John, of St Ives, merchant 1
4122643 2068393 2068393 defendant Jons or Jans John chapman 598927 598927 Jons or Jans, John, of St Ives, chapman 0
4125348 2069351 2069351 defendant Curles Thomas tanner 598927 598927 Curles, Thomas, of St Ives, tanner 1
4125352 2069352 2069352 defendant Curles Thomas tanner 598927 598927 Curles, Thomas, of St Ives, tanner 1
4125353 2069352 2069352 defendant Durant Giles tanner 598927 598927 Durant, Giles, of St Ives, tanner 2
4164673 2083154 2083154 defendant Careddris John merchant 598927 598927 Careddris, John, of St Ives, merchant 0
4164675 2083155 2083155 defendant Carveddris John merchant 598927 598927 Carveddris, John, of St Ives, merchant 0
4173422 2086161 2086161 defendant Curles Thomas tanner 598927 598927 Curles, Thomas, of St Ives, tanner 4
4173423 2086161 2086161 defendant Durant Giles tanner 598927 598927 Durant, Giles, of St Ives, tanner 5
4180335 2088601 2088601 defendant Cawnter William husbandman 598927 598927 Cawnter, William, of St Ives, husbandman 2
4180347 2088604 2088604 defendant Cawnter Philip husbandman 598927 598927 Cawnter, Philip, of St Ives, husbandman 3
4187336 2091071 2091071 defendant Dodson William butcher 598927 598927 Dodson, William, of St Ives, butcher 0
4194628 2093678 2093678 defendant Lanyon John gent 598927 598927 Lanyon, John, of St Ives, gent 0
4196743 2094406 2094406 defendant Durant Giles tanner 598927 598927 Durant, Giles, of St Ives, tanner 5
4206141 2097696 2097696 defendant Merifyeld Otis gent 598927 598927 Merifyeld, Otis, of St Ives, gent 0
4212224 2099823 2099823 defendant Sysson Robert yeoman 598927 598927 Sysson, Robert, of St Ives, yeoman 0
4222686 2103425 2103425 defendant Palmer Robert chapman 598927 598927 Palmer, Robert, of St Ives, chapman 0
4238418 2109052 2109052 defendant Francklyn alias Wright Thomas husbandman 598927 598927 Francklyn alias Wright, Thomas, of St Ives, husbandman 0
4242659 2110536 2110536 defendant Sedgwick Roger yeoman 598927 598927 Sedgwick, Roger, of St Ives, yeoman 0
4249918 2112952 2112952 defendant Gonnell Robert yeoman 598927 598927 Gonnell, Robert, of St Ives, yeoman 0
4257385 2115445 2115445 defendant Reve John clerk 598927 598927 Reve, John, of St Ives, clerk 0
4257386 2115445 2115445 defendant Walden William gent 598927 598927 Walden, William, of St Ives, gent 1
4265112 2117970 2117970 defendant Downes George yeoman 598927 598927 Downes, George, of St Ives, yeoman 0
4268781 2119153 2119153 defendant Gonnell Robert gent 598927 598927 Gonnell, Robert, of St Ives, gent 0
4268782 2119153 2119153 defendant Nott Henry salter 598927 598927 Nott, Henry, of St Ives, salter 1
4270385 2119676 2119676 defendant Tregenne John gent 598927 598927 Tregenne, John, of St Ives, gent 0

Next page

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