names
124 rows where place_id = 624381
This data as json, CSV (advanced)
Suggested facets: role, forename, occupation, seq
| id ▼ | case_id | role | surname | forename | occupation | place_id | raw_segment | seq |
|---|---|---|---|---|---|---|---|---|
| 3757808 | 1944420 1944420 | defendant | Bythemore | Thomas | gent | 624381 624381 | Bythemore, Thomas, of Middle Temple, London, gent | 3 |
| 3801583 | 1958396 1958396 | defendant | Lamberd | John | gent | 624381 624381 | Lamberd, John, of Middle Temple, London, gent | 0 |
| 3806974 | 1960083 1960083 | defendant | Whorwood | William | gent | 624381 624381 | Whorwood, William, of Middle Temple, London, gent | 3 |
| 3826325 | 1966081 1966081 | defendant | Lambert | John | gent | 624381 624381 | Lambert, John, of Middle Temple, London, gent | 1 |
| 3837048 | 1969501 1969501 | plaintiff | Sewster | John | gent | 624381 624381 | Sewster, John, of Middle Temple, London, gent | 0 |
| 3837053 | 1969502 1969502 | plaintiff | Sewster | John | gent | 624381 624381 | Sewster, John, of Middle Temple, London, gent | 0 |
| 3840776 | 1970680 1970680 | defendant | Lambart | John | gent | 624381 624381 | Lambart, John, of Middle Temple, London, gent | 1 |
| 3874948 | 1981844 1981844 | defendant | Owen | William | gent | 624381 624381 | Owen, William, of Middle Temple, London, gent | 0 |
| 3880622 | 1983782 1983782 | defendant | Bustard | Anthony | gent | 624381 624381 | Bustard, Anthony, of Middle Temple, London, gent | 0 |
| 3919849 | 1996973 1996973 | defendant | Lowe | Thomas | gent | 624381 624381 | Lowe, Thomas, of Middle Temple, London, gent | 2 |
| 3919853 | 1996974 1996974 | defendant | Lowe | Thomas | gent | 624381 624381 | Lowe, Thomas, of Middle Temple, London, gent | 2 |
| 3951228 | 2007500 2007500 | defendant | Dyer | John | gent | 624381 624381 | Dyer, John, of Middle Temple, London, gent | 1 |
| 3959695 | 2010482 2010482 | plaintiff | Smyth | Mathew | gent | 624381 624381 | Smyth, Mathew, of Middle Temple, London, gent | 0 |
| 3964787 | 2012291 2012291 | defendant | Vavasor | Andrew | esq | 624381 624381 | Vavasor, Andrew, of Middle Temple, London, esq | 1 |
| 3967265 | 2013180 2013180 | defendant | Wasse or Wayshe | Henry | gent | 624381 624381 | Wasse or Wayshe, Henry, of Middle Temple, London, gent | 1 |
| 3969945 | 2014087 2014087 | defendant | Clerke | Thomas | gent | 624381 624381 | Clerke, Thomas, of Middle Temple, London, gent | 2 |
| 3971552 | 2014610 2014610 | defendant | Roos | Peter | gent | 624381 624381 | Roos, Peter, of Middle Temple, London, gent | 0 |
| 3972285 | 2014871 2014871 | defendant | Barton | John | 624381 624381 | Barton, John, of Middle Temple, London, gent, attorney of the bench | 0 | |
| 3972546 | 2014975 2014975 | plaintiff | Garnons | John | gent | 624381 624381 | Garnons, John, of Middle Temple, London, gent | 0 |
| 3976064 | 2016198 2016198 | plaintiff | Jerves | Thomas | esq | 624381 624381 | Jerves, Thomas, of Middle Temple, London, esq | 0 |
| 3979742 | 2017508 2017508 | defendant | Snagge | Robert | gent | 624381 624381 | Snagge, Robert, of Middle Temple, London, gent | 0 |
| 3981075 | 2017991 2017991 | defendant | Hussye | Thomas | gent | 624381 624381 | Hussye, Thomas, of Middle Temple, London, gent | 0 |
| 3981084 | 2017994 2017994 | plaintiff | Prynce | Thomas | gent | 624381 624381 | Prynce, Thomas, of Middle Temple, London, gent | 0 |
| 3981090 | 2017995 2017995 | plaintiff | Prynce | Thomas | gent | 624381 624381 | Prynce, Thomas, of Middle Temple, London, gent | 0 |
| 3981094 | 2017996 2017996 | plaintiff | Prynce | Thomas | gent | 624381 624381 | Prynce, Thomas, of Middle Temple, London, gent | 0 |
| 3981098 | 2017997 2017997 | plaintiff | Prynce | Thomas | gent | 624381 624381 | Prynce, Thomas, of Middle Temple, London, gent | 0 |
| 3981720 | 2018221 2018221 | plaintiff | Richard | Nicholas | gent | 624381 624381 | Richard, Nicholas, of Middle Temple, London, gent | 0 |
| 3981961 | 2018310 2018310 | plaintiff | Roos | Peter | gent | 624381 624381 | Roos, Peter, of Middle Temple, London, gent | 0 |
| 3981963 | 2018311 2018311 | plaintiff | Roos | Peter | gent | 624381 624381 | Roos, Peter, of Middle Temple, London, gent | 0 |
| 3981965 | 2018312 2018312 | plaintiff | Roos | Peter | gent | 624381 624381 | Roos, Peter, of Middle Temple, London, gent | 0 |
| 3981967 | 2018313 2018313 | plaintiff | Roos | Peter | gent | 624381 624381 | Roos, Peter, of Middle Temple, London, gent | 0 |
| 3982061 | 2018343 2018343 | defendant | Skynner | Robert | gent | 624381 624381 | Skynner, Robert, of Middle Temple, London, gent | 1 |
| 3987114 | 2020136 2020136 | defendant | Calvert | Robert | gent | 624381 624381 | Calvert, Robert, of Middle Temple, London, gent | 0 |
| 3988528 | 2020641 2020641 | plaintiff | Archedale | Richard | gent | 624381 624381 | Archedale, Richard, of Middle Temple, London, gent | 0 |
| 3993595 | 2022456 2022456 | plaintiff | Chatherton | Robert | (legal representative) | 624381 624381 | Chatherton, Robert, of Middle Temple, London, gent, executors of | 0 |
| 3993606 | 2022460 2022460 | plaintiff | Chatterton | Robert | (legal representative) | 624381 624381 | Chatterton, Robert, of Middle Temple, London, gent, executors of | 0 |
| 3999513 | 2024591 2024591 | defendant | Freman | John | gent | 624381 624381 | Freman, John, of Middle Temple, London, gent | 0 |
| 3999516 | 2024592 2024592 | plaintiff | Fytche | John | (legal representative) | 624381 624381 | Fytche, John, of Middle Temple, London, gent, executor of | 0 |
| 3999518 | 2024592 2024592 | defendant | Freman | John | gent | 624381 624381 | Freman, John, of Middle Temple, London, gent | 0 |
| 4006485 | 2027098 2027098 | plaintiff | Lewkenor | Richard | esq | 624381 624381 | Lewkenor, Richard, of Middle Temple, London, esq | 0 |
| 4006719 | 2027182 2027182 | plaintiff | Love | John | gent | 624381 624381 | Love, John, of Middle Temple, London, gent | 0 |
| 4007868 | 2027590 2027590 | defendant | Smythe | John | 624381 624381 | Smythe, John, of Middle Temple, London | 2 | |
| 4008132 | 2027672 2027672 | defendant | Tusser | William | gent | 624381 624381 | Tusser, William, of Middle Temple, London, gent | 0 |
| 4010376 | 2028480 2028480 | plaintiff | Palmer | Richard | (legal representative) | 624381 624381 | Palmer, Richard, of Middle temple, London, esq, executors of | 0 |
| 4012904 | 2029345 2029345 | plaintiff | Reede | Innocent | esq | 624381 624381 | Reede, Innocent, of Middle Temple, London, esq | 0 |
| 4013206 | 2029455 2029455 | defendant | Rycard | Nicholas | gent | 624381 624381 | Rycard, Nicholas, of Middle Temple, London, gent | 0 |
| 4015337 | 2030179 2030179 | plaintiff | Smyth | Mathew | esq | 624381 624381 | Smyth, Mathew, of Middle Temple, London, esq | 0 |
| 4015531 | 2030251 2030251 | plaintiff | Smythe | Mathew | esq | 624381 624381 | Smythe, Mathew, of Middle Temple, London, esq | 0 |
| 4021489 | 2032413 2032413 | plaintiff | Wynnyngton | John | gent | 624381 624381 | Wynnyngton, John, of Middle Temple, London, gent | 0 |
| 4024642 | 2033491 2033491 | defendant | Snagge | Robert | gent | 624381 624381 | Snagge, Robert, of Middle Temple, London, gent | 1 |
| 4032023 | 2036121 2036121 | plaintiff | Dowle | Samuel | gent | 624381 624381 | (Dowle, Samuel, of Middle Temple, London, gent | 1 |
| 4035857 | 2037494 2037494 | plaintiff | Horde | George | gent | 624381 624381 | Horde, George, of Middle Temple, London, gent | 0 |
| 4046733 | 2041285 2041285 | plaintiff | Smythe | John | gent | 624381 624381 | Smythe, John, of Middle Temple, London, gent | 0 |
| 4047043 | 2041391 2041391 | defendant | Buckland | Diderus | gent | 624381 624381 | Buckland, Diderus, of Middle Temple, London, gent | 0 |
| 4052474 | 2043306 2043306 | plaintiff | Yate | Edward | gent | 624381 624381 | Yate, Edward, of Middle Temple, London, gent | 0 |
| 4052477 | 2043307 2043307 | plaintiff | Yate | Edward | gent | 624381 624381 | Yate, Edward, of Middle Temple, London, gent | 0 |
| 4054269 | 2043916 2043916 | defendant | Kempe | John | gent | 624381 624381 | Kempe, John, of Middle Temple, London, gent | 0 |
| 4058222 | 2045324 2045324 | plaintiff | Cavell | John | gent | 624381 624381 | Cavell, John, of Middle Temple, London, gent, son of Humphrey Cavell, of Middle Temple, gent | 0 |
| 4058529 | 2045440 2045440 | defendant | Bray | Reginald | gent | 624381 624381 | Bray, Reginald, of Middle Temple, London, gent | 1 |
| 4058656 | 2045486 2045486 | plaintiff | Clarke | James | 624381 624381 | Clarke, James, of Middle Temple, London | 0 | |
| 4065103 | 2047806 2047806 | plaintiff | Harris | Thomas | esq | 624381 624381 | Harris, Thomas, of Middle Temple, London, esq | 0 |
| 4065618 | 2047993 2047993 | plaintiff | Hedworthe | John | gent | 624381 624381 | Hedworthe, John, of Middle Temple, London, gent | 0 |
| 4074325 | 2051119 2051119 | plaintiff | Pyrrye | Nicholas | gent | 624381 624381 | Pyrrye, Nicholas, of Middle Temple, London, gent, or of Potterne, Wilts, gent | 0 |
| 4077368 | 2052191 2052191 | plaintiff | Spencer | John | gent | 624381 624381 | Spencer, John, of Middle Temple, London, gent | 0 |
| 4078397 | 2052568 2052568 | defendant | Vavasor | Peter | (legal representative) | 624381 624381 | Vavasor, Peter, of Middle Temple, London, esq, executor of | 0 |
| 4088469 | 2056175 2056175 | defendant | Wigmore | Richard | gent | 624381 624381 | Wigmore, Richard, of Middle Temple, London, gent | 0 |
| 4093522 | 2057999 2057999 | defendant | Stampe | Edward | esq | 624381 624381 | Stampe, Edward, of Middle Temple, London, esq | 0 |
| 4095382 | 2058671 2058671 | defendant | Dowriche | Walter | gent | 624381 624381 | Dowriche, Walter, of Middle Temple, London, gent | 0 |
| 4099163 | 2060026 2060026 | defendant | Dyer | James | gent | 624381 624381 | Dyer, James, of Middle Temple, London, gent | 3 |
| 4109329 | 2063598 2063598 | defendant | Harrys | Thomas | esq | 624381 624381 | Harrys, Thomas, of Middle Temple, London, esq | 0 |
| 4134951 | 2072820 2072820 | defendant | Marshall | John | gent | 624381 624381 | Marshall, John, of Middle Temple, London, gent | 0 |
| 4136130 | 2073266 2073266 | defendant | Dowriche | Walter | esq | 624381 624381 | Dowriche, Walter, of Middle Temple, London, esq | 0 |
| 4139331 | 2074433 2074433 | defendant | Bellyngeham | Henry | gent | 624381 624381 | Bellyngeham, Henry, of Middle Temple, London, gent | 2 |
| 4144107 | 2076100 2076100 | defendant | Love | John | gent | 624381 624381 | Love, John, of Middle Temple, London, gent | 0 |
| 4145894 | 2076720 2076720 | defendant | Marshall | Thomas | gent | 624381 624381 | Marshall, Thomas, of Middle Temple, London, gent | 0 |
| 4151551 | 2078663 2078663 | defendant | Tanfeild | Clement | esq | 624381 624381 | Tanfeild, Clement, of Middle Temple, London, esq | 2 |
| 4159002 | 2081216 2081216 | defendant | Blake | Thomas | gent | 624381 624381 | Blake, Thomas, of Middle Temple, London, gent | 0 |
| 4162787 | 2082541 2082541 | defendant | Chabner | Robert | gent | 624381 624381 | Chabner, Robert, of Middle Temple, London, gent | 3 |
| 4162806 | 2082541 2082541 | defendant | Thomas | John | gent | 624381 624381 | Thomas, John, of Middle Temple, London, gent | 22 |
| 4163694 | 2082823 2082823 | plaintiff | Thomson | Thomas | gent | 624381 624381 | Thomson, Thomas, of Middle Temple, London, gent | 0 |
| 4163696 | 2082824 2082824 | plaintiff | Thomson | Thomas | gent | 624381 624381 | Thomson, Thomas, of Middle Temple, London, gent | 0 |
| 4164845 | 2083216 2083216 | defendant | Cobden | John | gent | 624381 624381 | Cobden, John, of Middle Temple, London, gent | 0 |
| 4179260 | 2088224 2088224 | defendant | Hussey | John | gent | 624381 624381 | Hussey, John, of Middle Temple, London, gent | 0 |
| 4183778 | 2089816 2089816 | defendant | Evelegh | George | gent | 624381 624381 | Evelegh, George, of Middle Temple, London, gent | 0 |
| 4187431 | 2091102 2091102 | defendant | Tubbe | Thomas | gent | 624381 624381 | Tubbe, Thomas, of Middle Temple, London, gent | 0 |
| 4189416 | 2091798 2091798 | plaintiff | Gosnoll | William | esq | 624381 624381 | Gosnoll, William, of Middle Temple, London, esq | 1 |
| 4189422 | 2091799 2091799 | plaintiff | Gosnoll | William | esq | 624381 624381 | Gosnoll, William, of Middle Temple, London, esq | 1 |
| 4189428 | 2091800 2091800 | plaintiff | Gosnoll | William | esq | 624381 624381 | Gosnoll, William, of Middle Temple, London, esq | 1 |
| 4189434 | 2091801 2091801 | plaintiff | Gosnoll | William | esq | 624381 624381 | Gosnoll, William, of Middle Temple, London, esq | 1 |
| 4191442 | 2092576 2092576 | defendant | Prowse | George | gent | 624381 624381 | Prowse, George, of Middle Temple, London, gent | 0 |
| 4195069 | 2093839 2093839 | defendant | Morgan | Thomas | esq | 624381 624381 | Morgan, Thomas, of Middle Temple, London, esq | 0 |
| 4204313 | 2097054 2097054 | defendant | Horde | George | gent | 624381 624381 | Horde, George, of Middle Temple, London, gent | 0 |
| 4211896 | 2099709 2099709 | defendant | Cobden | John | gent | 624381 624381 | Cobden, John, of Middle Temple, London, gent | 0 |
| 4214831 | 2100689 2100689 | defendant | Boys | John, junior | gent | 624381 624381 | Boys, John, junior, of Middle Temple, London, gent | 0 |
| 4252172 | 2113713 2113713 | defendant | Clavell | William | gent | 624381 624381 | Clavell, William, of Middle Temple, London, gent | 0 |
| 4252174 | 2113714 2113714 | defendant | Clavell | William | gent | 624381 624381 | Clavell, William, of Middle Temple, London, gent | 0 |
| 4256958 | 2115297 2115297 | defendant | Wyatt | William | clothier | 624381 624381 | Wyatt, William, of Middle Temple, London, gent, son of Ralph Wyatt, of Worcester, clothier | 0 |
| 4259586 | 2116183 2116183 | defendant | Sayer | Richard | gent | 624381 624381 | Sayer, Richard, of Middle Temple, London, gent | 0 |
| 4263631 | 2117499 2117499 | defendant | Atkyns | Thomas | esq | 624381 624381 | Atkyns, Thomas, of Middle Temple, London, esq | 0 |
| 4265296 | 2118035 2118035 | defendant | Cole | Philip | gent | 624381 624381 | Cole, Philip, of Middle Temple, London, gent | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);