names

2,059 rows where place_id = 588081

✎ 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
3593303 1865536 1865536 defendant Erlyche John draper 588081 588081 Erlyche, John, of Cambridge, draper 2
3596493 1866534 1866534 defendant Symson Simon husbandman 588081 588081 Symson, Simon, of Cambridge, husbandman 0
3600222 1867716 1867716 defendant Feld Walter clerk 588081 588081 Feld, Walter, of Cambridge, clerk 0
3601306 1868074 1868074 defendant Fyncham Thomas gent 588081 588081 (Fyncham, Thomas, of Cambridge, gent 1
3601307 1868074 1868074 defendant Seyntwary John clerk 588081 588081 Seyntwary, John, of Cambridge, clerk 2
3604285 1869003 1869003 defendant Belle John   588081 588081 Belle, John, of Cambridge, freemason 2
3605676 1869440 1869440 defendant Wylles William glover 588081 588081 Wylles, William, of Cambridge, glover 0
3608992 1870469 1870469 defendant Burton Richard, junior clerk 588081 588081 Burton, Richard, junior, of Cambridge, clerk 0
3613215 1871788 1871788 defendant Paynent or Payvent Robert chapman 588081 588081 Paynent or Payvent, Robert, of Cambridge, chapman 0
3613741 1871949 1871949 plaintiff Belle John   588081 588081 Belle, John, of Cambridge 0
3615805 1872585 1872585 defendant Roggers Richard innholder 588081 588081 Roggers, Richard, of Cambridge, innholder 0
3615806 1872585 1872585 defendant Colyn Walter laborer 588081 588081 Colyn, Walter, of Cambridge, laborer 1
3615807 1872585 1872585 defendant Bawetre Peter laborer 588081 588081 Bawetre, Peter, of Cambridge, laborer 2
3617716 1873164 1873164 defendant Mesaunt John barker 588081 588081 Mesaunt, John, of Cambridge, barker 0
3622886 1874687 1874687 plaintiff Rogers Richard clothmaker 588081 588081 Rogers, Richard, of Cambridge, clothmaker 0
3622888 1874688 1874688 plaintiff Rogers Richard clothmaker 588081 588081 Rogers, Richard, of Cambridge, clothmaker 0
3622892 1874689 1874689 plaintiff Rogers Richard clothmaker 588081 588081 Rogers, Richard, of Cambridge, clothmaker 0
3622897 1874691 1874691 plaintiff Roggers Richard woolman 588081 588081 Roggers, Richard, of Cambridge, clothmaker, or of Blonsham, Hunts, woolman 0
3622899 1874692 1874692 plaintiff Roggers Richard woolman 588081 588081 Roggers, Richard, of Cambridge, clothmaker, or of Blonsham, Hunts, woolman 0
3625056 1875370 1875370 plaintiff Warde William baker 588081 588081 Warde, William, of Cambridge, baker 0
3625534 1875525 1875525 defendant Waryn William baker 588081 588081 Waryn, William, of Cambridge, baker 0
3625538 1875525 1875525 defendant Panet Robert chapman 588081 588081 Panet, Robert, of Cambridge, chapman 4
3625855 1902938 1902938 defendant Rankyn Lawrence merchant 588081 588081 Rankyn, Lawrence, of Cambridge, merchant 0
3626001 1902989 1902989 defendant Hacke John grocer 588081 588081 Hacke, John, of Cambridge, grocer 2
3627480 1903452 1903452 defendant Smyth Nicholas ironmonger 588081 588081 Smyth, Nicholas, of Cambridge, yeoman, ironmonger 1
3627735 1903535 1903535 defendant Bell John merchant 588081 588081 Bell, John, of Cambridge, merchant 0
3630262 1904314 1904314 defendant Rankyn Lawrence merchant 588081 588081 Rankyn, Lawrence, of Cambridge, merchant 0
3633525 1905297 1905297 plaintiff Kyrkby John   588081 588081 Kyrkby, John, of Cambridge 0
3633637 1905330 1905330 defendant Norrys Walter yeoman 588081 588081 Norrys, Walter, of Cambridge, yeoman 0
3633766 1905373 1905373 defendant Brett John carpenter 588081 588081 Brett, John, of Cambridge, carpenter 0
3634206 1905498 1905498 defendant Arnold Richard glover 588081 588081 Arnold, Richard, of Cambridge, glover 5
3635122 1905785 1905785 defendant Powes Andrew clerk 588081 588081 Powes, Andrew, of Cambridge, clerk 0
3635610 1905941 1905941 defendant Saunder John grocer 588081 588081 Saunder, John, of Cambridge, grocer 0
3635616 1905942 1905942 defendant Saunder John grocer 588081 588081 Saunder, John, of Cambridge, grocer 0
3635696 1905965 1905965 defendant Sewe Robert innholder 588081 588081 Sewe, Robert, of Cambridge, innholder 1
3635700 1905966 1905966 defendant Sewe Robert innholder 588081 588081 Sewe, Robert, of Cambridge, innholder 1
3635704 1905967 1905967 defendant Sewe Robert innholder 588081 588081 Sewe, Robert, of Cambridge, innholder 1
3636445 1906188 1906188 defendant Diconson John yeoman of the crown 588081 588081 Diconson, John, of Cambridge, yeoman of the crown 1
3637338 1906482 1906482 defendant Wyllys Robert glover 588081 588081 Wyllys, Robert, of Cambridge, glover 0
3638940 1907003 1907003 plaintiff Veysy Henry (legal representative) 588081 588081 Veysy, Henry, of Cambridge, executors of 0
3640399 1907427 1907427 defendant Wandyr alias Saunder John haberdasher 588081 588081 Wandyr alias Saunder, John, of Cambridge, haberdasher 0
3640714 1907540 1907540 plaintiff Auncell Hankyn   588081 588081 Auncell, Hankyn, of Cambridge 0
3644437 1908678 1908678 defendant Rigge John tailor 588081 588081 Rigge, John, of Cambridge, tailor 1
3644443 1908679 1908679 defendant Rigge John tailor 588081 588081 Rigge, John, of Cambridge, tailor 1
3645296 1908938 1908938 defendant Taylour John clerk 588081 588081 Taylour, John, of Cambridge, clerk 0
3645297 1908938 1908938 defendant Strong John draper 588081 588081 Strong, John, of Cambridge, draper 1
3645298 1908938 1908938 defendant Parson William brewer 588081 588081 Parson, William, of Cambridge, brewer 2
3645299 1908938 1908938 defendant Robynson Robert brewer 588081 588081 Robynson, Robert, of Cambridge, brewer 3
3647511 1909612 1909612 defendant Bell John fishmonger 588081 588081 Bell, John, of Cambridge, fishmonger 2
3649716 1910283 1910283 plaintiff Rankyn Hugh alderman 588081 588081 Rankyn, Hugh, of Cambridge, alderman 0
3650332 1910479 1910479 defendant Scalys Oliver gent 588081 588081 Scalys, Oliver, of Cambridge, gent 0
3650821 1910620 1910620 defendant Wyllys Robert glover 588081 588081 Wyllys, Robert, of Cambridge, glover 0
3651802 1910922 1910922 defendant Senns James goldsmith 588081 588081 Senns, James, of Cambridge, goldsmith 3
3651890 1910940 1910940 defendant Rankyn Simon fishmonger 588081 588081 Rankyn, Simon, of Cambridge, fishmonger 0
3653508 1911363 1911363 defendant Senowe James goldsmith 588081 588081 Senowe, James, of Cambridge, goldsmith 0
3654466 1911657 1911657 plaintiff Auncell Haukyn (legal representative) 588081 588081 Auncell, Haukyn, of Cambridge, burgess, administrator of 0
3654473 1911658 1911658 defendant (not given) John vicar of Sale 588081 588081 Sale, John, of Cambridge, clerk & vicar of All Saints 0
3655115 1911861 1911861 plaintiff Berwyk Peter   588081 588081 Berwyk, Peter, of Cambridge 0
3655117 1911862 1911862 plaintiff Berwyk Peter brewer 588081 588081 Berwyk, Peter, of Cambridge, brewer 0
3656537 1912297 1912297 defendant Wolfe Robert butcher 588081 588081 Wolfe, Robert, of Cambridge, butcher 0
3657795 1912690 1912690 defendant Smyth Paul grocer 588081 588081 Smyth, Paul, of Cambridge, grocer 0
3657808 1912694 1912694 defendant Smith Paul grocer 588081 588081 Smith, Paul, of Cambridge, grocer 0
3658488 1912906 1912906 plaintiff Eyton or Exton Thomas gent 588081 588081 Eyton or Exton, Thomas, of Cambridge, gent 0
3659014 1913083 1913083 defendant Synderton William   588081 588081 Synderton, William, of Cambridge, burgess 1
3659889 1913350 1913350 plaintiff Hallehed Henry Alderman 588081 588081 Hallehed, Henry, of Cambridge, Alderman 0
3660087 1913416 1913416 defendant Noke Robert   588081 588081 Noke, Robert, of Cambridge, inn holder 3
3660396 1913509 1913509 plaintiff Hewke Walter (legal representative) 588081 588081 Hewke, Walter, of Cambridge, formerly Master of Trinity Hall & Doctor of Both Laws, executor of 0
3660662 1913599 1913599 plaintiff Watson John clerk & Master of the College of St Peter 588081 588081 (Watson, John, of Cambridge, clerk & Master of the College of St Peter 1
3661356 1913826 1913826 defendant Barwyk Peter brewer 588081 588081 Barwyk, Peter, of Cambridge, brewer 0
3662979 1914333 1914333 defendant Sponer James clerk 588081 588081 Sponer, James, of Cambridge, clerk 0
3662982 1914334 1914334 defendant Adam Thomas gent 588081 588081 Adam, Thomas, of Cambridge, gent 0
3662984 1914335 1914335 defendant Sponer James clerk 588081 588081 Sponer, James, of Cambridge, clerk 0
3662985 1914335 1914335 defendant Mylycent William clerk 588081 588081 Mylycent, William, of Cambridge, clerk 1
3664676 1914904 1914904 plaintiff Purgold John   588081 588081 Purgold, John, of Cambridge 1
3665262 1915088 1915088 defendant Baxster John   588081 588081 Baxster, John, of Cambridge, burgess & butcher 0
3665399 1915132 1915132 defendant Spencer John   588081 588081 Spencer, John, of Cambridge, apothecary 0
3665707 1915223 1915223 defendant Lucas Richard gent 588081 588081 Lucas, Richard, of Cambridge, gent 0
3665708 1915223 1915223 defendant Fawne John   588081 588081 Fawne, John, of Cambridge 1
3665709 1915223 1915223 defendant Andrew John yeoman 588081 588081 Andrew, John, of Cambridge, yeoman 2
3665888 1915267 1915267 defendant Hume John barber 588081 588081 Hume, John, of Cambridge, barber 0
3667114 1915647 1915647 defendant Smyth Paul grocer 588081 588081 Smyth, Paul, of Cambridge, grocer 0
3667115 1915647 1915647 defendant Otte Richard   588081 588081 Otte, Richard, of Cambridge, hardware man 1
3668368 1916053 1916053 defendant Hawke William   588081 588081 Hawke, William, of Cambridge, tallow chandler 0
3668895 1916204 1916204 defendant Marshall Thomas vintner 588081 588081 Marshall, Thomas, of Cambridge, vintner 0
3669064 1916256 1916256 defendant Jakson John husbandman 588081 588081 Jakson, John, of Cambridge, husbandman 1
3670156 1916612 1916612 defendant Sawston John yeoman 588081 588081 Sawston, John, of Cambridge, yeoman 0
3670630 1916779 1916779 defendant Morden John husbandman 588081 588081 Morden, John, of Cambridge, husbandman 4
3672451 1917383 1917383 plaintiff Daile Richard draper 588081 588081 Daile, Richard, of Cambridge, draper 0
3672476 1917392 1917392 defendant Nelson Margaret widow 588081 588081 Nelson, Margaret, of Cambridge, widow 0
3672478 1917393 1917393 defendant Nelson Margaret widow 588081 588081 Nelson, Margaret, of Cambridge, widow 0
3672600 1917428 1917428 defendant Pekke Thomas chaplain 588081 588081 Pekke, Thomas, of Cambridge, chaplain 0
3673370 1917689 1917689 plaintiff Eton Thomas gent 588081 588081 Eton, Thomas, of Cambridge, gent 0
3673445 1917715 1917715 defendant Saundre John salter of raffman 588081 588081 Saundre, John, of Cambridge, salter of raffman 0
3673446 1917716 1917716 plaintiff Eyton Thomas gent 588081 588081 Eyton, Thomas, of Cambridge, gent 0
3676447 1918678 1918678 defendant Carter John chapman 588081 588081 Carter, John, of Cambridge, chapman 1
3676899 1918815 1918815 defendant Marshall Thomas vintner 588081 588081 Marshall, Thomas, of Cambridge, vintner 0
3676900 1918815 1918815 defendant Glas John waterman 588081 588081 Glas, John, of Cambridge, waterman 1
3677432 1918993 1918993 defendant Smyth Paul grocer 588081 588081 Smyth, Paul, of Cambridge, grocer 0
3677433 1918993 1918993 defendant Chapman Hugh mercer 588081 588081 Chapman, Hugh, of Cambridge, mercer 1
3678646 1919383 1919383 plaintiff Nelson Margaret widow 588081 588081 Nelson, Margaret, of Cambridge, widow 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);