names

1,725 rows where place_id = 586175

✎ 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
3588084 1863922 1863922 defendant Frere Thomas grocer 586175 586175 Frere, Thomas, of Canterbury, grocer 0
3591367 1864925 1864925 defendant Poleyn Thomas yeoman 586175 586175 Poleyn, Thomas, of Canterbury, yeoman 0
3591761 1865043 1865043 defendant Fermour Thomas baker 586175 586175 Fermour, Thomas, of Canterbury, baker 1
3591762 1865043 1865043 defendant Poleyn Thomas yeoman 586175 586175 Poleyn, Thomas, of Canterbury, yeoman 2
3591990 1865109 1865109 defendant Frere Thomas yeoman 586175 586175 Frere, Thomas, of Canterbury, yeoman 1
3591994 1865110 1865110 defendant Frere Thomas yeoman 586175 586175 Frere, Thomas, of Canterbury, yeoman 1
3592279 1865198 1865198 defendant Fouler John husbandman 586175 586175 Fouler, John, of Canterbury, husbandman 3
3592280 1865198 1865198 defendant Johnson Thomas laborer 586175 586175 Johnson, Thomas, of Canterbury, laborer 4
3592284 1865199 1865199 defendant Buklond William tailor 586175 586175 Buklond, William, of Canterbury, tailor 0
3592285 1865199 1865199 defendant Bukland John fletcher 586175 586175 Bukland, John, of Canterbury, fletcher 1
3592885 1865391 1865391 defendant Mannyng Robert chaplain 586175 586175 Mannyng, Robert, of Canterbury, chaplain 4
3592889 1865392 1865392 defendant Mannyng Robert clerk 586175 586175 Mannyng, Robert, of Canterbury, clerk 0
3592891 1865393 1865393 defendant Mannyng Robert clerk 586175 586175 Mannyng, Robert, of Canterbury, clerk 0
3593235 1865517 1865517 defendant Gerard Joan widow 586175 586175 Gerard, Joan, of Canterbury, widow 1
3593591 1865633 1865633 defendant Whytwey John cordwainer 586175 586175 Whytwey, John, of Canterbury, cordwainer 0
3593592 1865633 1865633 defendant Hamon John brewer 586175 586175 Hamon, John, of Canterbury, brewer 1
3593907 1865732 1865732 defendant Godfrey John carver 586175 586175 Godfrey, John, of Canterbury, carver 0
3593910 1865733 1865733 defendant Godfrey John carver 586175 586175 Godfrey, John, of Canterbury, carver 0
3594342 1865863 1865863 defendant Frere Thomas grocer 586175 586175 Frere, Thomas, of Canterbury, grocer 0
3594753 1865983 1865983 defendant Edmond Thomas butcher 586175 586175 Edmond, Thomas, of Canterbury, butcher 1
3594754 1865983 1865983 defendant Harman Robert chapman 586175 586175 Harman, Robert, of Canterbury, chapman 2
3597012 1866691 1866691 defendant Colman Euastace yeoman 586175 586175 Colman, Euastace, of Canterbury, yeoman 3
3598614 1867191 1867191 defendant Typpenden Robert yeoman 586175 586175 Typpenden, Robert, of Canterbury, yeoman 3
3599414 1867458 1867458 plaintiff Tregonwall John   586175 586175 Tregonwall, John, of Canterbury, son of Henry 2
3599420 1867459 1867459 plaintiff Trewonwall John   586175 586175 Trewonwall, John, of Canterbury, son of Henry 2
3599638 1867529 1867529 defendant Weldisshe Thomas brewer 586175 586175 Weldisshe, Thomas, of Canterbury, brewer 3
3601222 1868044 1868044 defendant Reynold John barber 586175 586175 Reynold, John, of Canterbury, barber 2
3602024 1868293 1868293 defendant Hamon John yeoman 586175 586175 Hamon, John, of Canterbury, yeoman 0
3602037 1868297 1868297 defendant Hamon John yeoman 586175 586175 Hamon, John, of Canterbury, yeoman 0
3603469 1868752 1868752 defendant Gate John capper 586175 586175 Gate, John, of Canterbury, capper 0
3603470 1868752 1868752 defendant Brokbank John capper 586175 586175 Brokbank, John, of Canterbury, capper 1
3605128 1869268 1869268 defendant Hewet John mercer 586175 586175 Hewet, John, of Canterbury, mercer 0
3606419 1869675 1869675 plaintiff Mydenall Richard   586175 586175 Mydenall, Richard, of Canterbury 0
3606862 1869812 1869812 defendant Reynold John barber 586175 586175 Reynold, John, of Canterbury, barber 1
3608233 1870230 1870230 defendant Tenam William   586175 586175 Tenam, William, of Canterbury, freemason 1
3609084 1870498 1870498 defendant Assheton Richard (legal representative) 586175 586175 Assheton, Richard, of Canterbury, merchant, administratrix of 4
3609404 1870602 1870602 defendant Carlyll John grocer 586175 586175 Carlyll, John, of Canterbury, grocer 0
3610158 1870839 1870839 defendant Frere Thomas grocer 586175 586175 Frere, Thomas, of Canterbury, grocer 0
3611446 1871257 1871257 defendant Gosborne Henry brewer 586175 586175 Gosborne, Henry, of Canterbury, brewer 0
3613360 1871826 1871826 plaintiff Baker John (legal representative) 586175 586175 Baker, John, of Canterbury, executors of 0
3613625 1871907 1871907 defendant Framer William yeoman 586175 586175 Framer, William, of Canterbury, yeoman 0
3613626 1871907 1871907 defendant Basse William yeoman 586175 586175 Basse, William, of Canterbury, yeoman 1
3614336 1872138 1872138 defendant Brokisbanke John capper 586175 586175 Brokisbanke, John, of Canterbury, capper 2
3615137 1872380 1872380 defendant Weste John brasier 586175 586175 Weste, John, of Canterbury, brasier 0
3615199 1872400 1872400 defendant Baker William yeoman 586175 586175 Baker, William, of Canterbury, yeoman 0
3615216 1872405 1872405 defendant Courte Thomas dyer 586175 586175 Courte, Thomas, of Canterbury, dyer 0
3615217 1872405 1872405 defendant Hunte Thomas dyer 586175 586175 Hunte, Thomas, of Canterbury, dyer 1
3615219 1872406 1872406 defendant Courte Thomas dyer 586175 586175 Courte, Thomas, of Canterbury, dyer 0
3615220 1872406 1872406 defendant Hunte Thomas dyer 586175 586175 Hunte, Thomas, of Canterbury, dyer 1
3615490 1872487 1872487 defendant Mascall John yeoman 586175 586175 Mascall, John, of Canterbury, yeoman 2
3615491 1872487 1872487 defendant Venytry Thomas yeoman 586175 586175 Venytry, Thomas, of Canterbury, yeoman 3
3616386 1872762 1872762 defendant Mette William yeoman 586175 586175 Mette, William, of Canterbury, yeoman 1
3617182 1872998 1872998 defendant Blynkynsop Robert   586175 586175 Blynkynsop, Robert, of Canterbury, mattress maker 2
3617685 1873156 1873156 defendant Franham William yeoman 586175 586175 Franham, William, of Canterbury, yeoman 1
3617687 1873157 1873157 defendant Farnham William yeoman 586175 586175 Farnham, William, of Canterbury, yeoman 0
3617688 1873157 1873157 defendant Barse William yeoman 586175 586175 Barse, William, of Canterbury, yeoman 1
3617756 1873178 1873178 defendant Rose William gent 586175 586175 Rose, William, of Canterbury, gent 0
3618856 1873510 1873510 defendant Gilbert Thomas gent 586175 586175 Gilbert, Thomas, of Canterbury, gent 0
3618893 1873519 1873519 defendant Belser George yeoman 586175 586175 Belser, George, of Canterbury, yeoman 0
3619869 1873789 1873789 defendant Edynden Walter chapman 586175 586175 Edynden, Walter, of Canterbury, chapman 1
3619879 1873791 1873791 defendant Edynden Walter chapman 586175 586175 Edynden, Walter, of Canterbury, chapman 3
3622629 1874607 1874607 defendant Bratford John innholder 586175 586175 Bratford, John, of Canterbury, innholder 0
3622639 1874611 1874611 defendant Bratford John innholder 586175 586175 Bratford, John, of Canterbury, innholder 0
3623961 1875025 1875025 defendant Wright John innholder 586175 586175 Wright, John, of Canterbury, innholder 2
3623965 1875026 1875026 defendant Hamond John brewer 586175 586175 Hamond, John, of Canterbury, brewer 0
3623966 1875026 1875026 defendant Edynden Walter yeoman 586175 586175 Edynden, Walter, of Canterbury, yeoman 1
3623996 1875038 1875038 plaintiff Steylle Alice widow 586175 586175 Steylle, Alice, of Canterbury, widow 0
3624498 1875197 1875197 plaintiff Toke William   586175 586175 Toke, William, of Canterbury 0
3626004 1902990 1902990 defendant Broke John mercer 586175 586175 Broke, John, of Canterbury, mercer 0
3626299 1903082 1903082 defendant Haukyns John (legal representative) 586175 586175 Haukyns, John, of Canterbury, clerk, executor of Willesford, Richard, of Benynden, Kent, clerk, executors of 0
3626300 1903082 1903082 defendant Squyer Roger clerk 586175 586175 (Squyer, Roger, of Canterbury, clerk 1
3626983 1903297 1903297 defendant Squyer Roger clerk 586175 586175 Squyer, Roger, of Canterbury, clerk 0
3627786 1903549 1903549 defendant Chettes Katherine widow 586175 586175 Chettes, Katherine, of Canterbury, widow 4
3630641 1904413 1904413 defendant Mogge William yeoman 586175 586175 Mogge, William, of Canterbury, yeoman 0
3631015 1904522 1904522 defendant Meg William yeoman 586175 586175 Meg, William, of Canterbury, yeoman 0
3631018 1904523 1904523 defendant Meg William yeoman 586175 586175 Meg, William, of Canterbury, yeoman 0
3632429 1904960 1904960 defendant Vertue William yeoman 586175 586175 Vertue, William, of Canterbury, yeoman 0
3632439 1904963 1904963 plaintiff Heynys Edward draper 586175 586175 Heynys, Edward, of Canterbury, draper 0
3635098 1905776 1905776 defendant Retclyff John yeoman 586175 586175 Retclyff, John, of Canterbury, yeoman 0
3636736 1906284 1906284 plaintiff Rotheram George esq 586175 586175 Rotheram, George, of Canterbury, esq 0
3636737 1906284 1906284 defendant Rutlande William grocer 586175 586175 Rutlande, William, of Canterbury, grocer 0
3637388 1906501 1906501 defendant Tego William tailor 586175 586175 Tego, William, of Canterbury, tailor 0
3639057 1907038 1907038 defendant Amys Robert yeoman 586175 586175 Amys, Robert, of Canterbury, yeoman 0
3641680 1907855 1907855 plaintiff Breten Thomas   586175 586175 Breten, Thomas, of Canterbury 0
3641792 1907882 1907882 defendant Long William yeoman 586175 586175 Long, William, of Canterbury, yeoman 0
3642542 1908109 1908109 defendant Rutland William grocer 586175 586175 Rutland, William, of Canterbury, grocer 0
3647980 1909769 1909769 defendant Clyfford Thomas gent 586175 586175 Clyfford, Thomas, of Canterbury, gent 0
3648108 1909801 1909801 defendant Watson Edward saddler 586175 586175 Watson, Edward, of Canterbury, saddler 3
3648114 1909803 1909803 defendant Russell Henry husbandman 586175 586175 Russell, Henry, of Canterbury, husbandman 0
3648361 1909887 1909887 defendant Tayllour Philip clerk 586175 586175 Tayllour, Philip, of Canterbury, clerk 1
3648812 1910016 1910016 defendant Withwell John fletcher 586175 586175 Withwell, John, of Canterbury, fletcher 2
3649390 1910200 1910200 defendant Farborn William clerk 586175 586175 Farborn, William, of Canterbury, clerk 0
3650686 1910581 1910581 defendant Whittalles James yeoman 586175 586175 Whittalles, James, of Canterbury, yeoman 0
3651289 1910772 1910772 plaintiff Stephynson Richard (legal representative) 586175 586175 Stephynson, Richard, of Canterbury, executors of 0
3653191 1911333 1911333 defendant Sale John clerk 586175 586175 Sale, John, of Canterbury, clerk 0
3659941 1913367 1913367 plaintiff Hampton Thomas   586175 586175 Hampton, Thomas, of Canterbury, abbot of the Monastery of St Augustine without the walls 0
3662440 1914165 1914165 defendant Wylcokke Edmund (legal representative) 586175 586175 Wylcokke, Edmund, of Canterbury, yeoman, executrix of 0
3662441 1914165 1914165 defendant Wylcokke Agnes widow 586175 586175 Wylcokke, Agnes, of Canterbury, widow 1
3663158 1914394 1914394 defendant Crips William yeoman 586175 586175 Crips, William, of Canterbury, yeoman 0
3664714 1914916 1914916 defendant Prowde Christopher brewer 586175 586175 Prowde, Christopher, of Canterbury, brewer 3

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