names

170 rows where place_id = 586799

✎ 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
3589647 1864405 1864405 defendant Bellyngton John yeoman 586799 586799 Bellyngton, John, of Ewell, yeoman 1
3595926 1866358 1866358 defendant Brewer alias Taillour John tailor 586799 586799 Brewer alias Taillour, John, of Ewell, tailor 0
3595927 1866358 1866358 defendant Erysley or Grysley William yeoman 586799 586799 Erysley or Grysley, William, of Ewell, yeoman 1
3600623 1867842 1867842 defendant Osynere or Osyvere John yeoman 586799 586799 Osynere or Osyvere, John, of Ewell, yeoman 0
3614147 1872090 1872090 defendant Felowe Thomas carpenter 586799 586799 Felowe, Thomas, of Ewell, carpenter 1
3614148 1872090 1872090 defendant Cole Thomas laborer 586799 586799 Cole Thomas, of Ewell, laborer 2
3617937 1873234 1873234 defendant Exham William yeoman 586799 586799 Exham, William, of Ewell, yeoman 0
3637050 1906386 1906386 defendant Codyngton William husbandman 586799 586799 Codyngton, William, of Ewell, husbandman 0
3637051 1906386 1906386 defendant Grace Thomas husbandman 586799 586799 Grace, Thomas, of Ewell, husbandman 1
3647350 1909557 1909557 defendant Donne John yeoman 586799 586799 Donne, John, of Ewell, yeoman 0
3662116 1914074 1914074 defendant Johnson Thomas carpenter 586799 586799 Johnson, Thomas, of Ewell, carpenter 0
3667740 1915853 1915853 defendant Starky Henry yeoman 586799 586799 Starky, Henry, of Ewell, yeoman 2
3668438 1916081 1916081 plaintiff at Fenne John   586799 586799 at Fenne, John, of Ewell 0
3680882 1920104 1920104 defendant Johnson Thomas carpenter 586799 586799 Johnson, Thomas, of Ewell, carpenter 0
3680883 1920104 1920104 defendant Langham Thomas husbandman 586799 586799 Langham, Thomas, of Ewell, husbandman 1
3690785 1923283 1923283 defendant Johnson Thomas carpenter 586799 586799 Johnson, Thomas, of Ewell, carpenter 2
3692223 1923735 1923735 defendant Lye John husbandman 586799 586799 Lye, John, of Ewell, husbandman 0
3693024 1924023 1924023 defendant Saunder William gent 586799 586799 Saunder, William, of Ewell, gent 0
3695241 1924728 1924728 defendant Agland John sawyer 586799 586799 Agland, John, of Ewell, sawyer 0
3695857 1924939 1924939 defendant Johnson Thomas carpenter 586799 586799 Johnson, Thomas, of Ewell, carpenter 0
3710201 1929505 1929505 defendant Sandes Joan widow 586799 586799 Sandes, Joan, of Ewell, widow 0
3710467 1929592 1929592 defendant Johnson Thomas carpenter 586799 586799 Johnson, Thomas, of Ewell, carpenter 0
3710470 1929593 1929593 defendant Jonson Thomas carpenter 586799 586799 Jonson, Thomas, of Ewell, carpenter 0
3715018 1930992 1930992 defendant Grace Thomas husbandman 586799 586799 Grace, Thomas, of Ewell, husbandman 0
3734251 1936952 1936952 defendant Marten Elizabeth single woman 586799 586799 Marten, Elizabeth, of Ewell, single woman, daughter of Marten, Thomas, of Clerkenwell, Middx, gent 0
3735709 1937405 1937405 defendant Saunder William   586799 586799 Saunder, William, of Ewell 1
3770023 1948286 1948286 defendant Waren Christopher miller 586799 586799 Waren, Christopher, of Ewell, miller 0
3771594 1948815 1948815 defendant Nycolson James tailor 586799 586799 Nycolson, James, of Ewell, tailor 0
3772908 1949226 1949226 defendant Langham Margaret widow 586799 586799 Langham, Margaret, of Ewell, widow 0
3772909 1949226 1949226 defendant Keyes Richard gent 586799 586799 Keyes, Richard, of Ewell, gent 1
3772910 1949226 1949226 defendant Heryng Robert yeoman 586799 586799 Heryng, Robert, of Ewell, yeoman 2
3772911 1949226 1949226 defendant Heyton Thomas husbandman 586799 586799 Heyton, Thomas, of Ewell, husbandman 3
3807087 1960109 1960109 defendant Langham Margaret widow 586799 586799 Langham, Margaret, of Ewell, widow 0
3807088 1960109 1960109 defendant Keyes Richard gent 586799 586799 Keyes, Richard, of Ewell, gent 1
3807089 1960109 1960109 defendant Heryng Robert yeoman 586799 586799 Heryng, Robert, of Ewell, yeoman 2
3807090 1960109 1960109 defendant Hayton Thomas husbandman 586799 586799 Hayton, Thomas, of Ewell, husbandman 3
3807092 1960110 1960110 defendant Langham Margaret widow 586799 586799 Langham, Margaret, of Ewell, widow 0
3807093 1960110 1960110 defendant Keyes Richard gent 586799 586799 Keyes, Richard, of Ewell, gent 1
3807094 1960110 1960110 defendant Heryng Robert yeoman 586799 586799 Heryng, Robert, of Ewell, yeoman 2
3807095 1960110 1960110 defendant Hayton Thomas husbandman 586799 586799 Hayton, Thomas, of Ewell, husbandman 3
3863825 1978075 1978075 defendant Hoke Thomas laborer 586799 586799 Hoke, Thomas, of Ewell, laborer 0
3876758 1982468 1982468 defendant Roger Richard husbandman 586799 586799 Roger, Richard, of Ewell, husbandman 3
3876759 1982468 1982468 defendant Roger Henry husbandman 586799 586799 Roger, Henry, of Ewell, husbandman 4
3881283 1984008 1984008 defendant Seynt John Joan widow 586799 586799 Seynt John, Joan, of Ewell, widow 0
3883630 1984794 1984794 defendant Myllys Thomas miller 586799 586799 Myllys, Thomas, of Ewell, miller 2
3891337 1987369 1987369 defendant Seynt John John esq 586799 586799 Seynt John, John, of Ewell, esq 0
3891339 1987370 1987370 defendant Seyntjohn John esq 586799 586799 Seyntjohn, John, of Ewell, esq 0
3958455 2010028 2010028 defendant Rogers Robert husbandman 586799 586799 Rogers, Robert, of Ewell, husbandman 0
3958456 2010028 2010028 defendant Dowse Richard husbandman 586799 586799 Dowse, Richard, of Ewell, husbandman 1
3980730 2017870 2017870 defendant Clement William yeoman 586799 586799 Clement, William, of Ewell, yeoman 3
4136232 2073304 2073304 defendant Wyer William bricklayer 586799 586799 Wyer, William, of Ewell, bricklayer 1
4204368 2097075 2097075 defendant Clement William (legal representative) 586799 586799 Clement, William, of Ewell, executor of 0
4204369 2097075 2097075 defendant Clement John yeoman 586799 586799 Clement, John, of Ewell, yeoman 1
4234633 2107660 2107660 defendant Venner Alice widow 586799 586799 Venner, Alice, of Ewell, widow 0
4234634 2107660 2107660 defendant Venner Nicholas yeoman 586799 586799 Venner, Nicholas, of Ewell, yeoman 1
4234635 2107660 2107660 defendant Staunton Richard husbandman 586799 586799 Staunton Richard, of Ewell, husbandman 2
4234636 2107660 2107660 defendant Pyerson Thomas husbandman 586799 586799 Pyerson, Thomas, of Ewell, husbandman 3
4325505 2138906 2138906 defendant Clement Richard husbandman 586799 586799 Clement, Richard, of Ewell, husbandman 0
4325506 2138906 2138906 defendant Fawkner Clement husbandman 586799 586799 Fawkner, Clement, of Ewell, husbandman 1
4390377 2161404 2161404 defendant Caryngton Thomas yeoman 586799 586799 Caryngton, Thomas, of Ewell, yeoman 1
4578690 2224824 2224824 defendant North William   586799 586799 North, William, of Ewell 0
4654406 2247252 2247252 defendant Estrych Thomas   586799 586799 Estrych, Thomas, of Ewell, bailiff 0
4678320 2258827 2258827 defendant Cake Thomas   586799 586799 Cake, Thomas, of Ewell, milward 3
4738420 2277108 2277108 defendant Bole William tailor 586799 586799 Bole, William, of Ewell, tailor 3
4741419 2277985 2277985 defendant Janyn James yeoman 586799 586799 Janyn, James, of Ewell, yeoman 0
4744323 2278862 2278862 defendant Jenyn James husbandman 586799 586799 Jenyn, James, of Ewell, husbandman 0
4754774 2281877 2281877 defendant Galon William husbandman 586799 586799 Galon, William, of Ewell, husbandman 1
4754789 2281878 2281878 defendant Galon William husbandman 586799 586799 Galon, William, of Ewell, husbandman 11
4771304 2287007 2287007 defendant Stokmede Thomas husbandman 586799 586799 Stokmede, Thomas, of Ewell, husbandman 0
4772798 2287461 2287461 defendant Bovehome William weaver 586799 586799 Bovehome, William, of Ewell, weaver 0
4772799 2287461 2287461 defendant Frere Thomas skinner 586799 586799 Frere, Thomas, of Ewell, skinner 1
4772800 2287461 2287461 defendant Salman Alexander baker 586799 586799 Salman, Alexander, of Ewell, baker 2
4772801 2287461 2287461 defendant Salman William laborer 586799 586799 Salman, William, of Ewell, laborer 3
4775947 2288480 2288480 defendant Bole William tailor alias husbandman 586799 586799 Bole, William, of Ewell, tailor alias husbandman 0
4775959 2288483 2288483 defendant Padele John husbandman 586799 586799 Padele, John, of Ewell, husbandman 1
4776340 2288593 2288593 defendant Galon William husbandman 586799 586799 Galon, William, of Ewell, husbandman 1
4777273 2288880 2288880 defendant Bole William tailor 586799 586799 Bole, William, of Ewell, tailor 0
4780969 2290051 2290051 defendant Janyn John husbandman 586799 586799 Janyn, John, of Ewell, husbandman 0
4780970 2290051 2290051 defendant Kyllyk William laborer 586799 586799 Kyllyk, William, of Ewell, laborer 1
4785678 2291550 2291550 defendant Janyn John husbandman 586799 586799 Janyn, John, of Ewell, husbandman 1
4814057 2300501 2300501 defendant Agulon John husbandman 586799 586799 Agulon, John, of Ewell, husbandman 1
4816731 2301330 2301330 defendant Seton Thomas yeoman 586799 586799 Seton, Thomas, of Ewell, yeoman 0
4828536 2304965 2304965 defendant Seton Thomas gent 586799 586799 Seton, Thomas, of Ewell, gent 0
4828537 2304965 2304965 defendant Borle Thomas yeoman 586799 586799 Borle, Thomas, of Ewell, yeoman 1
4828538 2304965 2304965 defendant Holt Thomas husbandman 586799 586799 Holt, Thomas, of Ewell, husbandman 2
4863438 2315534 2315534 defendant Javytt James yeoman 586799 586799 Javytt, James, of Ewell, yeoman 0
4867292 2316734 2316734 defendant Norman Thomas husbandman 586799 586799 Norman, Thomas, of Ewell, husbandman 0
4867293 2316734 2316734 defendant Holte Thomas husbandman 586799 586799 Holte, Thomas, of Ewell, husbandman 1
4915908 2331470 2331470 defendant Bole Thomas yeoman 586799 586799 Bole, Thomas, of Ewell, yeoman 0
4918963 2332444 2332444 defendant Ottewey John husbandman 586799 586799 Ottewey, John, of Ewell, husbandman 1
4918964 2332444 2332444 defendant Janyn Alice widow 586799 586799 Janyn, Alice, of Ewell, widow 2
4936081 2337681 2337681 defendant Seton Thomas yeoman 586799 586799 Seton, Thomas, of Ewell, yeoman 0
4936914 2337921 2337921 defendant Kyllyng William laborer 586799 586799 Kyllyng, William, of Ewell, laborer 0
4936915 2337921 2337921 defendant Osmond John husbandman 586799 586799 Osmond, John, of Ewell, husbandman 1
4936916 2337921 2337921 defendant Rede Thomas husbandman 586799 586799 Rede, Thomas, of Ewell, husbandman 2
4941042 2339219 2339219 defendant Lukke John husbandman 586799 586799 Lukke, John, of Ewell, husbandman 0
4941043 2339219 2339219 defendant Hauke John husbandman 586799 586799 Hauke, John, of Ewell, husbandman 1
4964739 2346364 2346364 defendant Osmond John husbandman 586799 586799 Osmond, John, of Ewell, husbandman 1
4967291 2347157 2347157 defendant Abbat Robert husbandman 586799 586799 Abbat, Robert, of Ewell, husbandman 0
4967293 2347158 2347158 defendant Staunton Richard husbandman 586799 586799 Staunton, Richard, of Ewell, husbandman 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);