names

139 rows where place_id = 612114

✎ 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
3596644 1866586 1866586 plaintiff Pondir or Poudir John (legal representative) 612114 612114 Pondir or Poudir, John, of Bunwell, yeoman, executors of 0
3691629 1923539 1923539 defendant Randolff Robert husbandman 612114 612114 Randolff, Robert, of Bunwell, husbandman 0
3696748 1925209 1925209 plaintiff Skarborough Robert yeoman 612114 612114 Skarborough, Robert, of Bunwell, yeoman 0
3748435 1941445 1941445 defendant Forde Gregory smith 612114 612114 Forde, Gregory, of Bunwell, smith 1
3748436 1941445 1941445 defendant Galard John husbandman 612114 612114 Galard, John, of Bunwell, husbandman 2
3760220 1945200 1945200 defendant Scysley Richard chaplain 612114 612114 Scysley, Richard, of Bunwell, chaplain 0
3761456 1945595 1945595 defendant Archebold John chaplain 612114 612114 Archebold, John, of Bunwell, chaplain 0
3766283 1947105 1947105 defendant Scysley Richard chaplain 612114 612114 Scysley, Richard, of Bunwell, chaplain 0
3780782 1951724 1951724 defendant Brett William husbandman 612114 612114 Brett, William, of Bunwell, husbandman 3
3797232 1957017 1957017 defendant Beverton John husbandman 612114 612114 Beverton, John, of Bunwell, husbandman 0
3798216 1957340 1957340 defendant Cesteby Richard clerk 612114 612114 Cesteby, Richard, of Bunwell, clerk 0
3809715 1960927 1960927 defendant Dyver Richard singleman 612114 612114 Dyver, Richard, of Bunwell, singleman 0
3820777 1964389 1964389 defendant Dyver Richard husbandman 612114 612114 Dyver, Richard, of Bunwell, husbandman 0
3829973 1967268 1967268 defendant Cayster John husbandman 612114 612114 Cayster, John, of Bunwell, husbandman 3
3859259 1976590 1976590 defendant Yelde Roger husbandman 612114 612114 Yelde, Roger, of Bunwell, husbandman 1
3866775 1979124 1979124 defendant Thurston John husbandman 612114 612114 Thurston, John, of Bunwell, husbandman 2
3866776 1979124 1979124 defendant Drake William husbandman 612114 612114 Drake, William, of Bunwell, husbandman 3
3875335 1981996 1981996 defendant Drake William husbandman 612114 612114 Drake, William, of Bunwell, husbandman 0
3875336 1981996 1981996 defendant Thirston John husbandman 612114 612114 Thirston, John, of Bunwell, husbandman 1
3875337 1981996 1981996 defendant Greve Thomas husbandman 612114 612114 Greve, Thomas, of Bunwell, husbandman 2
3875338 1981996 1981996 defendant Pytman Stephen husbandman 612114 612114 Pytman, Stephen, of Bunwell, husbandman 3
3893875 1988174 1988174 defendant Thurston John husbandman 612114 612114 Thurston, John, of Bunwell, husbandman 0
3902749 1991150 1991150 defendant Broune Thomas husbandman 612114 612114 Broune, Thomas, of Bunwell, husbandman 0
3902752 1991150 1991150 defendant Drake William husbandman 612114 612114 Drake, William, of Bunwell, husbandman 3
3904461 1991738 1991738 defendant Talour Robert yeoman 612114 612114 Talour, Robert, of Bunwell, yeoman 2
3907212 1992703 1992703 plaintiff Okerburgh Robert   612114 612114 Okerburgh, Robert, of Bunwell 0
3908126 1993015 1993015 defendant Thurston John husbandman 612114 612114 Thurston, John, of Bunwell, husbandman 0
3908127 1993015 1993015 defendant Drake William husbandman 612114 612114 Drake, William, of Bunwell, husbandman 1
3908128 1993015 1993015 defendant Bryan William, senior husbandman 612114 612114 Bryan, William, senior, of Bunwell, husbandman 2
3961212 2011016 2011016 defendant Randolff John husbandman 612114 612114 Randolff, John, of Bunwell, husbandman 0
3996009 2023327 2023327 defendant Newby John yeoman 612114 612114 Newby, John, of Bunwell, yeoman 2
3996014 2023329 2023329 defendant Newby John yeoman 612114 612114 Newby, John, of Bunwell, yeoman 0
4015031 2030074 2030074 defendant Bennett William clerk 612114 612114 Bennett, William, of Bunwell, clerk 7
4020305 2031984 2031984 defendant Tayler Peter husbandman 612114 612114 Tayler, Peter, of Bunwell, husbandman 1
4029838 2035315 2035315 defendant Wade Thomas ropemaker 612114 612114 Wade, Thomas, of Bunwell, ropemaker 0
4057931 2045219 2045219 defendant Cobbe Richard husbandman 612114 612114 Cobbe, Richard, of Bunwell, husbandman 0
4057962 2045227 2045227 defendant Newby John yeoman 612114 612114 Newby, John, of Bunwell, yeoman 0
4058883 2045571 2045571 defendant Nubye John yeoman 612114 612114 Nubye, John, of Bunwell, yeoman 0
4067705 2048761 2048761 defendant Nuby John, senior yeoman 612114 612114 Nuby, John, senior, of Bunwell, yeoman 0
4072115 2050326 2050326 defendant Cullynder Peter shoemaker 612114 612114 Cullynder, Peter, of Bunwell, shoemaker 2
4076644 2051942 2051942 defendant Newebye John husbandman 612114 612114 Newebye, John, of Bunwell, husbandman 7
4086630 2055505 2055505 defendant Nuby Thomas, junior yeoman 612114 612114 Nuby, Thomas, junior, of Bunwell, yeoman 0
4088213 2056076 2056076 defendant Newye or Newbye John yeoman 612114 612114 Newye or Newbye, John, of Bunwell, yeoman 0
4091139 2057119 2057119 defendant Cullendar Peter cordwainer 612114 612114 Cullendar, Peter, of Bunwell, cordwainer 0
4093147 2057869 2057869 defendant Wekes Peter husbandman 612114 612114 Wekes, Peter, of Bunwell, husbandman 1
4093241 2057901 2057901 defendant Lyncolne John husbandman 612114 612114 Lyncolne, John, of Bunwell, yeoman, or of Carleton Rode, husbandman 0
4093242 2057901 2057901 defendant Lyncolne Edward husbandman 612114 612114 Lyncolne, Edward, of Bunwell, yeoman, on of William Lyncolne, of Bunwell, husbandman 1
4098167 2059672 2059672 defendant Toly John yeoman 612114 612114 Toly, John, of Bunwell, yeoman 0
4098171 2059673 2059673 defendant Tolye John yeoman 612114 612114 Tolye, John, of Bunwell, yeoman 0
4103918 2061678 2061678 defendant Allen Thomas beer brewer 612114 612114 Allen, Thomas, of Bunwell, beer brewer 2
4103919 2061678 2061678 defendant Sporle Henry laborer 612114 612114 Sporle, Henry, of Bunwell, laborer 3
4104335 2061830 2061830 defendant Wyxe Peter cordwainer 612114 612114 Wyxe, Peter, of Bunwell, cordwainer 2
4119065 2067102 2067102 defendant Ingram William yeoman 612114 612114 Ingram, William, of Bunwell, yeoman 3
4121628 2068030 2068030 defendant Ingram William yeoman 612114 612114 Ingram, William, of Bunwell, yeoman 0
4125230 2069310 2069310 defendant Randall John yeoman 612114 612114 Randall, John, of Bunwell, yeoman 0
4137020 2073590 2073590 defendant Ingram William yeoman 612114 612114 Ingram, William, of Bunwell, yeoman 0
4138647 2074188 2074188 defendant Ingram William yeoman 612114 612114 Ingram, William, of Bunwell, yeoman 0
4139121 2074358 2074358 defendant Ingram William yeoman 612114 612114 Ingram, William, of Bunwell, yeoman 0
4145988 2076751 2076751 defendant Ingram William yeoman 612114 612114 Ingram, William, of Bunwell, yeoman 1
4148374 2077562 2077562 defendant Lyncolne Edward husbandman 612114 612114 Lyncolne, Edward, of Bunwell, husbandman 0
4148375 2077562 2077562 defendant Lyncolne John yeoman 612114 612114 Lyncolne, John, of Bunwell, yeoman 1
4148376 2077562 2077562 defendant Mathewe William yeoman 612114 612114 Mathewe, William, of Bunwell, yeoman 2
4148781 2077694 2077694 defendant Tooley John yeoman 612114 612114 Tooley, John, of Bunwell, yeoman 0
4149014 2077772 2077772 defendant Page Richard husbandman 612114 612114 Page, Richard, of Bunwell, husbandman 2
4150541 2078323 2078323 defendant Ninbye Thomas yeoman 612114 612114 Ninbye, Thomas, of Bunwell, yeoman 0
4150542 2078323 2078323 defendant Nynby Richard husbandman 612114 612114 Nynby, Richard, of Bunwell, husbandman 1
4150543 2078323 2078323 defendant Nynby John, junior husbandman 612114 612114 Nynby, John, junior, of Bunwell, husbandman 2
4150545 2078324 2078324 defendant Nuby Thomas yeoman 612114 612114 Nuby, Thomas, of Bunwell, yeoman 0
4150546 2078324 2078324 defendant Nubye Richard husbandman 612114 612114 Nubye, Richard, of Bunwell, husbandman 1
4150547 2078324 2078324 defendant Nuby John, junior husbandman or yeoman 612114 612114 Nuby, John, junior, of Bunwell, husbandman or yeoman 2
4152834 2079100 2079100 defendant Newby Thomas yeoman 612114 612114 Newby, Thomas, of Bunwell, yeoman 0
4152835 2079100 2079100 defendant Newbye Thomas, senior yeoman 612114 612114 Newbye, Thomas, senior, of Bunwell, yeoman 1
4156602 2080386 2080386 defendant Lincoln Edward laborer 612114 612114 Lincoln, Edward, of Bunwell, laborer 1
4157037 2080540 2080540 defendant Lyncoln Edward yeoman 612114 612114 Lyncoln, Edward, of Bunwell, yeoman 0
4157038 2080540 2080540 defendant Bucke Edward yeoman or weaver 612114 612114 Bucke, Edward, of Bunwell, yeoman or weaver 1
4157937 2080846 2080846 defendant Newbye Thomas husbandman 612114 612114 Newbye, Thomas, of Bunwell, husbandman 0
4158310 2080976 2080976 defendant Lyncolne John yeoman 612114 612114 Lyncolne, John, of Bunwell, yeoman 0
4163735 2082841 2082841 defendant Ingraham William yeoman 612114 612114 Ingraham, William, of Bunwell, yeoman 0
4178456 2087939 2087939 defendant Eldred alias Skynner Richard weaver 612114 612114 Eldred alias Skynner, Richard, of Bunwell, weaver 0
4178458 2087940 2087940 defendant Randolfe John yeoman 612114 612114 Randolfe, John, of Bunwell, yeoman 0
4180467 2088648 2088648 defendant Ingram Richard yeoman 612114 612114 Ingram, Richard, of Bunwell, yeoman 1
4181066 2088853 2088853 defendant Newby Thomas singleman 612114 612114 Newby, Thomas, of Bunwell, singleman 0
4198801 2095140 2095140 defendant Lincoln Edward husbandman 612114 612114 Lincoln, Edward, of Bunwell, husbandman 0
4198802 2095140 2095140 defendant Drake Thomas husbandman 612114 612114 Drake, Thomas, of Bunwell, husbandman 1
4202123 2096289 2096289 defendant Browning Robert yeoman 612114 612114 Browning, Robert, of Bunwell, yeoman 1
4203187 2096664 2096664 defendant Lincoln Edward laborer or husbandman 612114 612114 Lincoln, Edward, of Bunwell, laborer or husbandman 0
4204731 2097200 2097200 defendant Browne Thomas   612114 612114 Browne, Thomas, of Bunwell, sieve maker 1
4207072 2098019 2098019 defendant Awdye George thatcher 612114 612114 Awdye, George, of Bunwell, thatcher 0
4212386 2099881 2099881 defendant Cullynder Peter cordwainer 612114 612114 Cullynder, Peter, of Bunwell, cordwainer 2
4215420 2100889 2100889 defendant Mathen or Matheu Thomas carpenter 612114 612114 Mathen or Matheu, Thomas, of Bunwell, carpenter 0
4216317 2101199 2101199 defendant Bullar Nicholas thatcher 612114 612114 Bullar, Nicholas, of Bunwell, thatcher 3
4217707 2101683 2101683 defendant Tyte Walter tailor 612114 612114 Tyte, Walter, of Bunwell, tailor 1
4217988 2101785 2101785 defendant Pyle Richard yeoman 612114 612114 Pyle, Richard, of Bunwell, yeoman 0
4222310 2103293 2103293 defendant Taylor Peter husbandman 612114 612114 Taylor, Peter, of Bunwell, husbandman 2
4244527 2111149 2111149 defendant Pyle Richard yeoman 612114 612114 Pyle, Richard, of Bunwell, yeoman 0
4250293 2113079 2113079 defendant Cobbe Robert weaver 612114 612114 Cobbe, Robert, of Bunwell, weaver 0
4250821 2113251 2113251 defendant Cann William husbandman 612114 612114 Cann, William, of Bunwell, husbandman 0
4250822 2113251 2113251 defendant Thurston William husbandman 612114 612114 Thurston, William, of Bunwell, husbandman 1
4263154 2117343 2117343 defendant Wolston Robert carpenter 612114 612114 Wolston, Robert, of Bunwell, carpenter 1
4273473 2120685 2120685 defendant Newby Thomas husbandman 612114 612114 Newby, Thomas, of Bunwell, husbandman 2

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