names

337 rows where place_id = 589057

✎ 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
3596394 1866503 1866503 defendant Bonour Thomas husbandman 589057 589057 Bonour, Thomas, of Abendon, husbandman 0
3597608 1866878 1866878 defendant Clement John husbandman 589057 589057 Clement, John, of Abendon, husbandman 0
3597609 1866878 1866878 defendant Gamage William smith 589057 589057 Gamage, William, of Abendon, smith 1
3597610 1866878 1866878 defendant Gagwyn John fuller 589057 589057 Gagwyn, John, of Abendon, fuller 2
3597612 1866878 1866878 defendant Somerset William weaver 589057 589057 Somerset, William, of Abendon, weaver 4
3616449 1872783 1872783 plaintiff Do Richard (legal representative) 589057 589057 Do, Richard, of Abendon, executor of 0
3618705 1873472 1873472 defendant Dykar Robert yeoman 589057 589057 Dykar, Robert, of Abendon, yeoman 4
3623236 1874795 1874795 plaintiff Say Thomas gent 589057 589057 Say, Thomas, of Abendon, gent 0
3623239 1874796 1874796 defendant Aylmere Thomas dyer 589057 589057 Aylmere, Thomas, of Abendon, dyer 0
3625574 1875533 1875533 defendant Belyngham David gent 589057 589057 Belyngham, David, of Abendon, gent 1
3629577 1904108 1904108 plaintiff Danold William   589057 589057 Danold, William, of Abendon 0
3629579 1904109 1904109 plaintiff Danold William   589057 589057 Danold, William, of Abendon 0
3629580 1904109 1904109 defendant Scarlett Augustine dyer 589057 589057 Scarlett, Augustine, of Abendon, dyer 0
3629581 1904109 1904109 defendant Coterell Richard butcher 589057 589057 Coterell, Richard, of Abendon, butcher 1
3650543 1910537 1910537 defendant Scarlet Augustine dyer 589057 589057 Scarlet, Augustine, of Abendon, dyer 0
3664950 1914982 1914982 plaintiff Doget William gent 589057 589057 Doget, William, of Abendon, gent 1
3669396 1916366 1916366 defendant Hunt William draper 589057 589057 Hunt, William, of Abendon, draper 0
3685171 1921510 1921510 defendant Stokwell Robert butcher 589057 589057 Stokwell, Robert, of Abendon, butcher 0
3685172 1921510 1921510 defendant Marchall Thomas butcher 589057 589057 Marchall, Thomas, of ABendon, butcher 1
3690107 1923068 1923068 defendant Woodward Leonard innholder 589057 589057 Woodward, Leonard, of Abendon, innholder 1
3690108 1923068 1923068 defendant Wellysbourn Oliver gent 589057 589057 Wellysbourn, Oliver, of Abendon, gent 2
3690109 1923068 1923068 defendant Bysley William gent 589057 589057 Bysley, William, of Abendon, gent 3
3690111 1923068 1923068 defendant Edwardys Richard draper 589057 589057 Edwardys, Richard, of Abendon, draper 5
3690112 1923068 1923068 defendant Smyth Lionel yeoman 589057 589057 Smyth, Lionel, of Abendon, yeoman 6
3695598 1924852 1924852 defendant Asten Christopher clothier 589057 589057 Asten, Christopher, of Abendon, clothier 0
3700251 1926313 1926313 plaintiff Audelet John   589057 589057 Audelet, John, of Abendon 0
3707442 1928622 1928622 defendant Salary John yeoman 589057 589057 Salary, John, of Abendon, yeoman 0
3707822 1928744 1928744 defendant Salary John fuller 589057 589057 Salary, John, of Abendon, fuller 0
3721263 1932955 1932955 defendant Lloid Richard glover 589057 589057 Lloid, Richard, of Abendon, glover 0
3724831 1934051 1934051 plaintiff Schyngylton William   589057 589057 Schyngylton, William, of Abendon 0
3744284 1940111 1940111 plaintiff Audelett John esq 589057 589057 Audelett, John, of Abendon, esq 0
3756566 1944034 1944034 plaintiff Audelett John esq 589057 589057 Audelett, John, of Abendon, esq 0
3802843 1958784 1958784 defendant Acryge Thomas dyer 589057 589057 Acryge, Thomas, of Abendon, dyer 1
3826272 1966064 1966064 plaintiff Asshton Christopher draper 589057 589057 Asshton, Christopher, of Abendon, draper 0
3861450 1977290 1977290 defendant Gooderyge John innholder 589057 589057 Gooderyge, John, of Abendon, innholder 1
3861451 1977290 1977290 defendant Ockeley John hostler 589057 589057 Ockeley, John, of Abendon, hostler 2
3863896 1978099 1978099 plaintiff Jones William mercer 589057 589057 Jones, William, of Abendon, mercer 0
3863898 1978100 1978100 plaintiff Jones William mercer 589057 589057 Jones, William, of Abendon, mercer 0
3863899 1978100 1978100 defendant Pyfold William butcher 589057 589057 Pyfold, William, of Abendon, butcher 0
3877457 1982697 1982697 plaintiff Hore William bowyer 589057 589057 Hore, William, of Abendon, bowyer 0
3877462 1982698 1982698 plaintiff Hore William bowyer 589057 589057 Hore, William, of Abendon, bowyer 0
3877969 1982876 1982876 plaintiff Jones William mercer 589057 589057 Jones, William, of Abendon, mercer 0
3877970 1982876 1982876 defendant Pynfold William butcher 589057 589057 Pynfold, William, of Abendon, butcher 0
3877971 1982877 1982877 plaintiff Jones William mercer 589057 589057 Jones, William, of Abendon, mercer 0
3877972 1982877 1982877 defendant Pynfold William butcher 589057 589057 Pynfold, William, of Abendon, butcher 0
3883193 1984641 1984641 defendant Pynfold William butcher 589057 589057 Pynfold, William, of Abendon, butcher 0
3927188 1999428 1999428 defendant Wylford Thomas weaver 589057 589057 Wylford, Thomas, of Abendon, weaver 0
4551512 2216413 2216413 plaintiff Dyer Robert   589057 589057 Dyer, Robert, of Abendon 0
4551514 2216414 2216414 plaintiff Dyer Robert   589057 589057 Dyer, Robert, of Abendon 0
4551515 2216414 2216414 defendant Hudde Thomas baker 589057 589057 Hudde, Thomas, of Abendon, baker 0
4551516 2216415 2216415 plaintiff Dyer Thomas   589057 589057 Dyer, Thomas, of Abendon 0
4551519 2216416 2216416 plaintiff Dyer Thomas   589057 589057 Dyer, Thomas, of Abendon 0
4551531 2216419 2216419 plaintiff Dyere Thomas   589057 589057 Dyere, Thomas, of Abendon 0
4559929 2219060 2219060 defendant atte Shoppe Thomas   589057 589057 atte Shoppe, Thomas, of Abendon 0
4567356 2221348 2221348 defendant Bailly John   589057 589057 Bailly, John, of Abendon 0
4567361 2221350 2221350 defendant Glover Henry   589057 589057 Glover, Henry, of Abendon 0
4568136 2221601 2221601 defendant Wynchecombe John   589057 589057 Wynchecombe, John, of Abendon 0
4568138 2221601 2221601 defendant Whatle William   589057 589057 Whatle, William, of Abendon 2
4568139 2221601 2221601 defendant Nelkyn John   589057 589057 Nelkyn, John, of Abendon 3
4569702 2222108 2222108 defendant Stone John weaver 589057 589057 Stone, John, of Abendon, weaver 0
4569703 2222108 2222108 defendant Tiele John   589057 589057 Tiele, John, of Abendon 1
4582343 2225921 2225921 defendant Chambre Thomas   589057 589057 Chambre, Thomas, of Abendon 0
4582354 2225923 2225923 defendant Pulter John   589057 589057 Pulter, John, of Abendon 3
4582934 2226090 2226090 plaintiff Fisshere Robert   589057 589057 Fisshere, Robert, of Abendon 0
4591142 2228585 2228585 defendant Bocher Edmund   589057 589057 Bocher, Edmund, of Abendon 0
4607842 2233568 2233568 defendant Goldsmyth Robert   589057 589057 Goldsmyth, Robert, of Abendon 0
4612306 2234916 2234916 defendant Ody Alan   589057 589057 Ody, Alan, of Abendon 0
4612601 2235006 2235006 defendant Redyng John   589057 589057 Redyng, John, of Abendon 1
4612602 2235006 2235006 defendant Dumbervile John   589057 589057 Dumbervile, John, of Abendon 2
4620310 2237335 2237335 defendant Fysshere William   589057 589057 Fysshere, William, of Abendon 0
4620315 2237336 2237336 defendant Fysshere William   589057 589057 Fysshere, William, of Abendon 0
4625275 2238869 2238869 defendant Polley Simon   589057 589057 Polley, Simon, of Abendon 0
4626039 2239101 2239101 defendant Bullok Richard   589057 589057 Bullok, Richard, of Abendon 0
4628794 2239934 2239934 defendant Hudde John baker 589057 589057 Hudde, John, of Abendon, baker 0
4631305 2240684 2240684 defendant Bullok William   589057 589057 Bullok, William, of Abendon 0
4634003 2241487 2241487 defendant Bradewell Giles   589057 589057 Bradewell, Giles, of Abendon 0
4654354 2247235 2247235 defendant Stone Ralph tailor 589057 589057 Stone, Ralph, of Abendon, tailor 1
4656624 2247965 2247965 plaintiff Chambre William   589057 589057 Chambre, William, of Abendon 0
4656625 2247965 2247965 defendant Luncsombe Nicholas chapman 589057 589057 Luncsombe, Nicholas, of Abendon, chapman 0
4656626 2247965 2247965 defendant Crowele John chapman 589057 589057 Crowele, John, of Abendon, chapman 1
4657680 2248290 2248290 defendant Smyth John laborer 589057 589057 Smyth, John, of Abendon, laborer 0
4663870 2250185 2250185 defendant Stone Richard weaver 589057 589057 Stone, Richard, of Abendon, weaver 0
4665303 2250639 2250639 plaintiff Hilder Richard   589057 589057 Hilder, Richard, of Abendon 0
4665304 2250639 2250639 defendant Lavender William launderer 589057 589057 Lavender, William, of Abendon, launderer 0
4665700 2250745 2250745 plaintiff Hordewell Simon   589057 589057 Hordewell, Simon, of Abendon 0
4665702 2250745 2250745 defendant Cobeler John cobbler 589057 589057 Cobeler, John, of Abendon, cobbler 1
4665704 2250745 2250745 defendant Wyttenham Emma widow 589057 589057 Wyttenham, Emma, of Abendon, widow 3
4666729 2255322 2255322 defendant Caker John baker 589057 589057 Caker, John, of Abendon, baker 0
4670320 2256423 2256423 defendant Apperle William husbandman 589057 589057 Apperle, William, of Abendon, husbandman 0
4672637 2257083 2257083 defendant Leveden Nicholas husbandman 589057 589057 Leveden, Nicholas, of Abendon, husbandman 0
4676115 2258143 2258143 plaintiff Garsyngton Thomas   589057 589057 Garsyngton, Thomas, of Abendon 0
4676116 2258143 2258143 defendant Sadeler Nicholas sadler 589057 589057 Sadeler, Nicholas, of Abendon, sadler 0
4677213 2258492 2258492 defendant Wollemonger Thomas clerk 589057 589057 Wollemonger, Thomas, of Abendon, clerk 0
4729845 2274540 2274540 plaintiff London John   589057 589057 London, John, of Abendon 0
4739840 2277534 2277534 defendant Chaundeler Roger chandler 589057 589057 Chaundeler, Roger, of Abendon, chandler 0
4741536 2278019 2278019 defendant Nichol John husbandman 589057 589057 Nichol, John, of Abendon, husbandman 0
4741537 2278019 2278019 defendant Nichol Joan   589057 589057 Nichol, Joan, of Abendon 1
4741995 2278158 2278158 defendant Jurdan John   589057 589057 Jurdan, John, of Abendon, holy water clerk 0
4743572 2278646 2278646 defendant Baker Henry baker 589057 589057 Baker, Henry, of Abendon, baker 0
4743573 2278646 2278646 defendant Faryngdon John weaver 589057 589057 Faryngdon, John, of Abendon, weaver 1

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