names

205 rows where place_id = 589206

✎ 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
3596892 1866660 1866660 defendant Gossone John yeoman 589206 589206 Gossone, John, of Buntyngford, yeoman 0
3623883 1874997 1874997 defendant Miles William laborer 589206 589206 Miles, William, of Buntyngford, laborer 1
3623884 1874997 1874997 defendant Spark Peter laborer 589206 589206 Spark, Peter, of Buntyngford, laborer 2
3639991 1907324 1907324 defendant Shynner Thomas fishher 589206 589206 Shynner, Thomas, of Buntyngford, fishher 1
3639994 1907324 1907324 defendant Adam Margaret widow 589206 589206 (Adam, Margaret, of Buntyngford, widow 4
3639995 1907324 1907324 defendant Adam Thomas glover 589206 589206 Adam, Thomas, of Buntyngford, glover 5
3648795 1910014 1910014 defendant Bedyll Robert chapman 589206 589206 Bedyll, Robert, of Buntyngford, chapman 0
3650882 1910641 1910641 defendant Carter John glover 589206 589206 Carter, John, of Buntyngford, glover 2
3663322 1914452 1914452 defendant Waren Roger smith 589206 589206 Waren, Roger, of Buntyngford, smith 0
3664678 1914905 1914905 plaintiff Sawyer John   589206 589206 Sawyer, John, of Buntyngford 0
3671273 1916989 1916989 defendant Wheteley Henry butcher 589206 589206 Wheteley, Henry, of Buntyngford, butcher 1
3671275 1916989 1916989 defendant Waren Roger smith 589206 589206 Waren, Roger, of Buntyngford, smith 3
3676123 1918572 1918572 defendant Sparowe Robert cordwainer 589206 589206 Sparowe, Robert, of Buntyngford, cordwainer 1
3679127 1919540 1919540 defendant Lytyll William William hosteler 589206 589206 Lytyll William, William, of Buntyngford, hosteler 0
3687127 1922147 1922147 defendant Whalysby Stephen laborer 589206 589206 Whalysby, Stephen, of Buntyngford, laborer 1
3692120 1923705 1923705 defendant Whetley Henry butcher 589206 589206 Whetley, Henry, of Buntyngford, butcher 0
3692594 1923870 1923870 defendant Akent Thomas draper 589206 589206 Akent, Thomas, of Buntyngford, draper 1
3697214 1925348 1925348 defendant Kyng William tailor 589206 589206 Kyng, William, of Buntyngford, tailor 0
3706981 1928466 1928466 defendant Thorne John tanner 589206 589206 Thorne, John, of Buntyngford, tanner 0
3730054 1935640 1935640 defendant Nunne William tailor 589206 589206 Nunne, William, of Buntyngford, tailor 1
3741147 1939093 1939093 defendant Wolley William draper 589206 589206 Wolley, William, of Buntyngford, draper 1
3749511 1941758 1941758 defendant Wheteley Henry butcher 589206 589206 Wheteley, Henry, of Buntyngford, butcher 1
3762668 1945961 1945961 defendant Sparowe Leonard shoemaker 589206 589206 Sparowe, Leonard, of Buntyngford, shoemaker 1
3772074 1948957 1948957 defendant Coke John laborer 589206 589206 Coke, John, of Buntyngford, laborer 0
3776894 1950512 1950512 defendant Wolley William yeoman 589206 589206 Wolley, William, of Buntyngford, yeoman 1
3780961 1951779 1951779 defendant Nonne William tailor 589206 589206 Nonne, William, of Buntyngford, tailor 2
3780962 1951779 1951779 defendant Randolf Peter tailor 589206 589206 Randolf, Peter, of Buntyngford, tailor 3
3788348 1954156 1954156 defendant Akent Thomas draper 589206 589206 Akent, Thomas, of Buntyngford, draper 0
3794303 1956092 1956092 defendant Barnham William barber 589206 589206 Barnham, William, of Buntyngford, barber 0
3797581 1957139 1957139 defendant Garrard John fuller 589206 589206 Garrard, John, of Buntyngford, fuller 0
3797582 1957140 1957140 plaintiff Gosson Richard yeoman 589206 589206 Gosson, Richard, of Buntyngford, yeoman 0
3797584 1957140 1957140 defendant Wolley William husbandman 589206 589206 Wolley, William, of Buntyngford, husbandman 1
3801094 1958260 1958260 defendant Nonny William yeoman 589206 589206 Nonny, William, of Buntyngford, yeoman 0
3801096 1958261 1958261 defendant Nonny William yeoman 589206 589206 Nonny, William, of Buntyngford, yeoman 0
3801097 1958261 1958261 defendant Randell Peter yeoman 589206 589206 Randell, Peter, of Buntyngford, yeoman 1
3803426 1958973 1958973 defendant Bornam William   589206 589206 Bornam, William, of Buntyngford, wax chandler 0
3803427 1958973 1958973 defendant Sharche John   589206 589206 Sharche, John, of Buntyngford, tallow chandler 1
3807907 1960360 1960360 defendant Randall Anthony bricklayer 589206 589206 Randall, Anthony, of Buntyngford, bricklayer 0
3809140 1960742 1960742 defendant West Richard dyer 589206 589206 West, Richard, of Buntyngford, dyer 1
3809350 1960808 1960808 defendant Wolle William husbandman 589206 589206 Wolle, William, of Buntyngford, husbandman 0
3809353 1960809 1960809 defendant Wolle William husbandman 589206 589206 Wolle, William, of Buntyngford, husbandman 0
3811813 1961596 1961596 defendant Lamkyn Thomas husbandman 589206 589206 Lamkyn, Thomas, of Buntyngford, husbandman 0
3816135 1962950 1962950 defendant Wolley William husbandman 589206 589206 Wolley, William, of Buntyngford, husbandman 1
3819439 1963964 1963964 defendant Inglond Thomas yeoman 589206 589206 Inglond, Thomas, of Buntyngford, yeoman 3
3828592 1966820 1966820 defendant Lamkyn Thomas husbandman 589206 589206 Lamkyn, Thomas, of Buntyngford, husbandman 0
3836302 1969263 1969263 defendant Barnam William   589206 589206 Barnam, William, of Buntyngford, wax chandler 0
3836303 1969263 1969263 defendant Sheryche John   589206 589206 Sheryche, John, of Buntyngford, tallow chandler 1
3836305 1969263 1969263 defendant Bedell Robert yeoman 589206 589206 Bedell, Robert, of Buntyngford, yeoman 3
3837700 1969704 1969704 defendant Fyssher John yeoman 589206 589206 Fyssher, John, of Buntyngford, yeoman 0
3839963 1970428 1970428 defendant Harrys John yeoman 589206 589206 Harrys, John, of Buntyngford, yeoman 0
3841136 1970804 1970804 defendant Northop John yeoman 589206 589206 Northop, John, of Buntyngford, yeoman 0
3842047 1971067 1971067 defendant Edryche William glover 589206 589206 Edryche, William, of Buntyngford, glover 0
3847713 1972856 1972856 defendant Eyre Thomas butcher 589206 589206 Eyre, Thomas, of Buntyngford, butcher 0
3847714 1972856 1972856 defendant Ederyche William glover 589206 589206 Ederyche, William, of Buntyngford, glover 1
3847848 1972902 1972902 defendant Sherche John   589206 589206 Sherche, John, of Buntyngford, tallow chandler 3
3858483 1976314 1976314 defendant Ederiche William glover 589206 589206 Ederiche, William, of Buntyngford, glover 0
3858546 1976340 1976340 defendant Ederiche William glover 589206 589206 Ederiche, William, of Buntyngford, glover 0
3859650 1976724 1976724 defendant Coole John innholder 589206 589206 Coole, John, of Buntyngford, innholder 1
3859651 1976724 1976724 defendant Wolley Thomas husbandman 589206 589206 Wolley, Thomas, of Buntyngford, husbandman 2
3863869 1978091 1978091 defendant Baron John gent 589206 589206 Baron, John, of Buntyngford, gent 0
3869523 1980049 1980049 defendant Lamkyn Thomas husbandman 589206 589206 Lamkyn, Thomas, of Buntyngford, husbandman 0
3869917 1980182 1980182 defendant Dunne Isabel widow 589206 589206 Dunne, Isabel, of Buntyngford, widow 4
3875253 1981962 1981962 defendant Harrys John smith 589206 589206 Harrys, John, of Buntyngford, smith 4
3881922 1984211 1984211 defendant Sutton Edward laborer 589206 589206 Sutton, Edward, of Buntyngford, laborer 0
3881923 1984211 1984211 defendant Fraunceys Robert weaver 589206 589206 Fraunceys, Robert, of Buntyngford, weaver 1
3881924 1984211 1984211 defendant Marsshe Nicholas weaver 589206 589206 Marsshe, Nicholas, of Buntyngford, weaver 2
3885300 1985336 1985336 defendant Northop John glover 589206 589206 Northop, John, of Buntyngford, glover 0
3885302 1985337 1985337 defendant Northorp John glover 589206 589206 Northorp, John, of Buntyngford, glover 0
3900532 1990407 1990407 defendant Cowper Thomas yeoman 589206 589206 Cowper, Thomas, of Buntyngford, yeoman 0
3902464 1991055 1991055 defendant Kynge Robert maltman 589206 589206 Kynge, Robert, of Buntyngford, maltman 1
3902466 1991055 1991055 defendant Bronde Richard weaver 589206 589206 Bronde, Richard, of Buntyngford, weaver 3
3906087 1992326 1992326 defendant Tayler John husbandman 589206 589206 Tayler, John, of Buntyngford, husbandman 0
3906926 1992605 1992605 defendant Coldam Peter yeoman 589206 589206 Coldam, Peter, of Buntyngford, yeoman 0
3907028 1992638 1992638 defendant Lucke Robert maltman 589206 589206 Lucke, Robert, of Buntyngford, maltman 0
3907029 1992638 1992638 defendant Lucke Richard maltman 589206 589206 Lucke, Richard, of Buntyngford, maltman 1
3907331 1992741 1992741 defendant Taylour John husbandman 589206 589206 Taylour, John, of Buntyngford, husbandman 0
3914357 1995143 1995143 plaintiff Bysowthe John yeoman 589206 589206 Bysowthe, John, of Buntyngford, yeoman 0
3916047 1995755 1995755 plaintiff Ederyche William yeoman 589206 589206 Ederyche, William, of Buntyngford, yeoman 0
3933798 2001598 2001598 defendant Harrys Edmund smith 589206 589206 Harrys, Edmund, of Buntyngford, smith 3
3971286 2014514 2014514 plaintiff Ederyche John glover 589206 589206 Ederyche, John, of Buntyngford, glover 0
3971287 2014514 2014514 plaintiff Anteler or Hauntler Robert shoemaker 589206 589206 Anteler or Hauntler, Robert, of Buntyngford, shoemaker 1
4062981 2047063 2047063 defendant Wylderton Richard laborer 589206 589206 Wylderton, Richard, of Buntyngford, laborer 0
4062982 2047063 2047063 defendant Ayre Robert butcher 589206 589206 Ayre Robert, of Buntyngford, butcher 1
4080600 2053377 2053377 defendant Fylewood Gregory baker 589206 589206 Fylewood, Gregory, of Buntyngford, baker 0
4080601 2053377 2053377 defendant Sotherwood Thomas tailor 589206 589206 Sotherwood, Thomas, of Buntyngford, tailor 1
4080602 2053377 2053377 defendant Arnold Henry joiner 589206 589206 Arnold, Henry, of Buntyngford, joiner 2
4094542 2058384 2058384 defendant Newman Agnes widow 589206 589206 Newman, Agnes, of Buntyngford, widow 2
4094564 2058391 2058391 defendant Newman Agnes widow 589206 589206 Newman, Agnes, of Buntyngford, widow 3
4319980 2137092 2137092 defendant Warwicke Michael yeoman 589206 589206 Warwicke, Michael, of Buntyngford, yeoman 3
4432182 2174849 2174849 defendant Cherewynd John merchant 589206 589206 Cherewynd, John, of Buntyngford, merchant 0
4432184 2174850 2174850 defendant Cherewynd John merchant 589206 589206 Cherewynd, John, of Buntyngford, merchant 0
4454033 2186274 2186274 defendant Wodeward Richard   589206 589206 Wodeward, Richard, of Buntyngford 0
4505239 2202168 2202168 plaintiff Smith Thomas   589206 589206 Smith, Thomas, of Buntyngford, 0
4512330 2204297 2204297 defendant Appulby Richard   589206 589206 Appulby, Richard, of Buntyngford 0
4540016 2212786 2212786 plaintiff Warwyk John   589206 589206 Warwyk, John, of Buntyngford 0
4547915 2215282 2215282 defendant Pople Thomas   589206 589206 Pople, Thomas, of Buntyngford 5
4553441 2217004 2217004 defendant Blosme Robert   589206 589206 Blosme, Robert, of Buntyngford 3
4573713 2223295 2223295 defendant Potnoll John   589206 589206 Potnoll, John, of Buntyngford 1
4577995 2224623 2224623 defendant Campe William (legal representative) 589206 589206 Campe, William, of Buntyngford, executrix of 5
4585042 2226743 2226743 defendant Seriand Isabel   589206 589206 Seriand, Isabel, of Buntyngford 6

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