names

4,102 rows where place_id = 586180

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588095 1863926 1863926 defendant Skynner Thomas husbandman 586180 586180 Skynner, Thomas, of Bury St Edmunds, husbandman 0
3588096 1863926 1863926 defendant Skynner Adam husbandman 586180 586180 Skynner, Adam, of Bury St Edmunds, husbandman 1
3588097 1863926 1863926 defendant Broun William tailor 586180 586180 Broun, William, of Bury St Edmunds, tailor 2
3588098 1863926 1863926 defendant Dene John barber 586180 586180 Dene, John, of Bury St Edmunds, barber 3
3588099 1863926 1863926 defendant Currour William barker 586180 586180 Currour, William, of Bury St Edmunds, barker 4
3588100 1863926 1863926 defendant Fyrmyn John barker 586180 586180 Fyrmyn, John, of Bury St Edmunds, barker 5
3588131 1863938 1863938 defendant Jermeyn Thomas gent 586180 586180 Jermeyn, Thomas, of Bury St Edmunds, gent 0
3588376 1864016 1864016 defendant Bull Robert   586180 586180 Bull, Robert, of Bury St Edmunds, bed weaver 0
3588377 1864016 1864016 defendant Clement William sherman 586180 586180 Clement, William, of Bury St Edmunds, sherman 1
3588379 1864016 1864016 defendant Tylly John weaver 586180 586180 Tylly, John, of Bury St Edmunds, weaver 3
3588389 1864018 1864018 defendant Reysyn Thomas tailor 586180 586180 Reysyn, Thomas, of Bury St Edmunds, tailor 1
3588390 1864018 1864018 defendant Abbot John dyer 586180 586180 Abbot, John, of Bury St Edmunds, dyer 2
3589022 1864215 1864215 defendant Dene John yeoman 586180 586180 Dene, John, of Bury St Edmunds, yeoman 1
3589536 1864364 1864364 defendant Nonne William scrivener 586180 586180 Nonne, William, of Bury St Edmunds, scrivener 1
3589727 1864426 1864426 defendant Bury Thomas yeoman 586180 586180 Bury, Thomas, of Bury St Edmunds, yeoman 2
3589728 1864426 1864426 defendant Grene Richard weaver 586180 586180 Grene, Richard, of Bury St Edmunds, weaver 3
3591319 1864910 1864910 defendant Chylde William brasier 586180 586180 Chylde, William, of Bury St Edmunds, brasier 4
3591459 1864955 1864955 defendant Lacy Thomas grocer 586180 586180 Lacy, Thomas, of Bury St Edmunds, grocer 0
3591465 1864956 1864956 defendant Lacy Thomas grocer 586180 586180 Lacy, Thomas, of Bury St Edmunds, grocer 0
3591835 1865067 1865067 defendant Kygill William dyer 586180 586180 Kygill, William, of Bury St Edmunds, dyer 0
3591866 1865076 1865076 defendant Jerves John gent 586180 586180 Jerves, John, of Bury St Edmunds, gent 1
3592202 1865178 1865178 defendant Godebody John butcher 586180 586180 Godebody, John, of Bury St Edmunds, butcher 0
3592203 1865178 1865178 defendant Legat John laborer 586180 586180 Legat, John, of Bury St Edmunds, laborer 1
3592206 1865178 1865178 defendant Merymouth Eleanor widow 586180 586180 Merymouth, Eleanor, of Bury St Edmunds, widow 4
3592321 1865213 1865213 plaintiff Galyet John merchant 586180 586180 Galyet, John, of Bury St Edmunds, merchant 0
3592323 1865214 1865214 plaintiff Galyet John merchant 586180 586180 Galyet, John, of Bury St Edmunds, merchant 0
3592325 1865215 1865215 plaintiff Galyett John merchant 586180 586180 Galyett, John, of Bury St Edmunds, merchant 0
3592727 1865339 1865339 defendant Roket John   586180 586180 Roket, John, of Bury St Edmunds, bed weaver 1
3592728 1865339 1865339 defendant Balon John yeoman 586180 586180 Balon, John, of Bury St Edmunds, yeoman 2
3593576 1865628 1865628 defendant Baret William gent 586180 586180 Baret, William, of Bury St Edmunds, gent 0
3593589 1865632 1865632 defendant Baret William gent 586180 586180 Baret, William, of Bury St Edmunds, gent 0
3593841 1865714 1865714 defendant Baret William gent 586180 586180 Baret, William, of Bury St Edmunds, gent 0
3594018 1865768 1865768 defendant Beton John laborer 586180 586180 Beton, John, of Bury St Edmunds, laborer 0
3594548 1865924 1865924 defendant Bussh John fuller 586180 586180 Bussh, John, of Bury St Edmunds, fuller 0
3594549 1865924 1865924 defendant Aylwyn Robert weaver 586180 586180 Aylwyn, Robert, of Bury St Edmunds, weaver 1
3595059 1866088 1866088 defendant Styng Thomas   586180 586180 Styng, Thomas, of Bury St Edmunds, coverlet weaver 0
3595181 1866126 1866126 defendant Salman Thomas chapman 586180 586180 Salman, Thomas, of Bury St Edmunds, chapman 0
3595951 1866364 1866364 plaintiff Newehawe Adam   586180 586180 Newehawe, Adam, of Bury St Edmunds 0
3595953 1866364 1866364 defendant Newehawe Nicholas mercer 586180 586180 Newehawe, Nicholas, of Bury St Edmunds, mercer 1
3595979 1866373 1866373 defendant Hasyll Thomas butcher 586180 586180 Hasyll, Thomas, of Bury St Edmunds, butcher 0
3595980 1866373 1866373 defendant Pyke William butcher 586180 586180 Pyke, William, of Bury St Edmunds, butcher 1
3596272 1866463 1866463 defendant Baret William gent 586180 586180 Baret, William, of Bury St Edmunds, gent 0
3596273 1866464 1866464 plaintiff Parfey John draper 586180 586180 Parfey, John, of Bury St Edmunds, draper 0
3596573 1866562 1866562 defendant Dymour William tiler 586180 586180 Dymour, William, of Bury St Edmunds, tiler 0
3596895 1866661 1866661 defendant Pyke William butcher 586180 586180 Pyke, William, of Bury St Edmunds, butcher 0
3597377 1866801 1866801 defendant Hasyll Thomas butcher 586180 586180 Hasyll, Thomas, of Bury St Edmunds, butcher 1
3598241 1867081 1867081 plaintiff Smyth John grocer 586180 586180 Smyth, John, of Bury St Edmunds, grocer 0
3598242 1867081 1867081 defendant Broun William yeoman or stainer 586180 586180 Broun, William, of Bury St Edmunds, yeoman or stainer 0
3598243 1867081 1867081 defendant Rynggold Richard fishmonger 586180 586180 Rynggold, Richard, of Bury St Edmunds, fishmonger 1
3598246 1867081 1867081 defendant Lawe John plumber 586180 586180 Lawe, John, of Bury St Edmunds, plumber 4
3598316 1867102 1867102 plaintiff Snowe Nicholas skinner 586180 586180 Snowe, Nicholas, of Bury St Edmunds, skinner 0
3598319 1867102 1867102 defendant Fleccher William fletcher 586180 586180 Fleccher, William, of Bury St Edmunds, fletcher 2
3598409 1867132 1867132 plaintiff Spenser John   586180 586180 Spenser, John, of Bury St Edmunds 0
3598692 1867215 1867215 defendant Honyborne William dyer 586180 586180 Honyborne, William, of Bury St Edmunds, dyer 3
3599730 1867561 1867561 defendant Hasell Thomas butcher 586180 586180 Hasell, Thomas, of Bury St Edmunds, butcher 0
3599731 1867561 1867561 defendant Parmenter John hosier 586180 586180 Parmenter, John, of Bury St Edmunds, hosier 1
3599733 1867561 1867561 defendant Halton John spurrier 586180 586180 Halton, John, of Bury St Edmunds, spurrier 3
3600199 1867709 1867709 defendant Gardener John dyer 586180 586180 Gardener, John, of Bury St Edmunds, dyer 2
3600205 1867711 1867711 defendant Gardener John dyer 586180 586180 Gardener, John, of Bury St Edmunds, dyer 2
3600356 1867755 1867755 defendant Broun William shoemaker 586180 586180 Broun, William, of Bury St Edmunds, shoemaker 3
3600494 1867801 1867801 defendant Gardener John dyer 586180 586180 Gardener, John, of Bury St Edmunds, dyer 2
3600502 1867804 1867804 defendant Gardener John dyer 586180 586180 Gardener, John, of Bury St Edmunds, dyer 2
3601138 1868019 1868019 defendant Skynner Thomas husbandman 586180 586180 Skynner, Thomas, of Bury St Edmunds, husbandman 1
3601139 1868019 1868019 defendant Grene John fuller 586180 586180 Grene, John, of Bury St Edmunds, fuller 2
3601455 1868111 1868111 defendant Lacy Thomas grocer 586180 586180 Lacy, Thomas, of Bury St Edmunds, grocer 2
3601456 1868111 1868111 defendant Purpell William grocer 586180 586180 Purpell, William, of Bury St Edmunds, grocer 3
3601464 1868112 1868112 defendant Lacy Thomas grocer 586180 586180 Lacy, Thomas, of Bury St Edmunds, grocer 2
3601465 1868112 1868112 defendant Purpell William grocer 586180 586180 Purpell, William, of Bury St Edmunds, grocer 3
3601701 1868186 1868186 plaintiff Batayle Richard (legal representative) 586180 586180 Batayle, Richard, of Bury St Edmunds, gent, executors of 0
3601705 1868186 1868186 defendant Copynger Richard yeoman 586180 586180 Copynger, Richard, of Bury St Edmunds, yeoman 0
3601991 1868282 1868282 defendant Twaytes William gent 586180 586180 Twaytes, William, of Bury St Edmunds, gent 0
3602472 1868434 1868434 plaintiff Byrd John scrivener 586180 586180 Byrd, John, of Bury St Edmunds, scrivener 0
3602475 1868435 1868435 plaintiff Byrd John scrivener 586180 586180 Byrd, John, of Bury St Edmunds, scrivener 0
3603060 1868624 1868624 defendant Skynner Thomas husbandman 586180 586180 Skynner, Thomas, of Bury St Edmunds, husbandman 1
3603061 1868624 1868624 defendant Bole Robert   586180 586180 Bole, Robert, of Bury St Edmunds, coverlet weaver 2
3603062 1868624 1868624 defendant Hogge Thomas husbandman 586180 586180 Hogge, Thomas, of Bury St Edmunds, husbandman 3
3603064 1868625 1868625 plaintiff Copynger Walter   586180 586180 Copynger, Walter, of Bury St Edmunds 0
3603533 1868773 1868773 defendant Pertre Robert yeoman 586180 586180 Pertre, Robert, of Bury St Edmunds, yeoman 0
3603563 1868784 1868784 defendant Langley William fishmonger 586180 586180 Langley, William, of Bury St Edmunds, fishmonger 0
3603909 1868895 1868895 defendant Lynge Roger weaver 586180 586180 Lynge, Roger, of Bury St Edmunds, weaver 0
3603916 1868896 1868896 defendant Lynge Roger weaver 586180 586180 Lynge, Roger, of Bury St Edmunds, weaver 0
3604431 1869054 1869054 defendant Drakbowe Nicholas laborer 586180 586180 Drakbowe, Nicholas, of Bury St Edmunds, laborer 2
3604432 1869054 1869054 defendant Feer Robert barber 586180 586180 Feer, Robert, of Bury St Edmunds, barber 3
3604662 1869121 1869121 defendant Busshe John fuller 586180 586180 Busshe, John, of Bury St Edmunds, fuller 0
3605326 1869331 1869331 defendant Brampton William clothman 586180 586180 Brampton, William, of Bury St Edmunds, clothman 2
3605401 1869357 1869357 defendant Nicoll William husbandman 586180 586180 Nicoll, William, of Bury St Edmunds, husbandman 0
3605405 1869357 1869357 defendant Godard Thomas husbandman 586180 586180 Godard, Thomas, of Bury St Edmunds, husbandman 4
3605480 1869380 1869380 defendant Blaunche Robert fishmonger 586180 586180 Blaunche, Robert, of Bury St Edmunds, fishmonger 0
3605484 1869381 1869381 defendant Blaunche Robert fishmonger 586180 586180 Blaunche, Robert, of Bury St Edmunds, fishmonger 0
3605514 1869389 1869389 plaintiff Kedgell Thomas   586180 586180 Kedgell, Thomas, of Bury St Edmunds 0
3605518 1869391 1869391 plaintiff Keggell Thomas clothmaker 586180 586180 Keggell, Thomas, of Bury St Edmunds, clothmaker 0
3605606 1869419 1869419 plaintiff Kyng Richard mercer 586180 586180 Kyng, Richard, of Bury St Edmunds, mercer 0
3605608 1869419 1869419 defendant James John   586180 586180 James, John, of Bury St Edmunds, wheel wright 1
3605610 1869419 1869419 defendant Wryght Richard   586180 586180 Wryght, Richard, of Bury St Edmunds, wheel wright 3
3605627 1869426 1869426 plaintiff Kyrton John (legal representative) 586180 586180 Kyrton, John, of Bury St Edmunds, executors of 0
3605628 1869426 1869426 plaintiff Drury John gent 586180 586180 (Drury, John, of Bury St Edmunds, gent 1
3605632 1869427 1869427 plaintiff Kyrton John (legal representative) 586180 586180 Kyrton, John, of Bury St Edmunds, executors of 0
3605633 1869427 1869427 plaintiff Drury John gent 586180 586180 (Drury, John, of Bury St Edmunds, gent 1
3605718 1869451 1869451 defendant Lacy Thomas grocer 586180 586180 Lacy, Thomas, of Bury St Edmunds, grocer 0
3605971 1869531 1869531 defendant Purpyll William grocer 586180 586180 Purpyll, William, of Bury St Edmunds, grocer 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);