names

162 rows where place_id = 596900

✎ 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
3626576 1903164 1903164 defendant Gyrden or Jurden John butcher 596900 596900 Gyrden or Jurden, John, of Godmanchester, butcher 0
3667627 1915819 1915819 defendant Ivot William fisher 596900 596900 Ivot, William, of Godmanchester, fisher 0
3667629 1915820 1915820 defendant Laxton John husbandman 596900 596900 Laxton, John, of Godmanchester, husbandman 0
3667630 1915820 1915820 defendant Ibot or Ivot William fisher 596900 596900 Ibot or Ivot, William, of Godmanchester, fisher 1
3669890 1916527 1916527 defendant Anes William laborer 596900 596900 Anes, William, of Godmanchester, laborer 0
3675352 1918329 1918329 defendant Clapham John chaplain 596900 596900 Clapham, John, of Godmanchester, chaplain 2
3680647 1920025 1920025 defendant Pell Robert husbandman 596900 596900 Pell, Robert, of Godmanchester, husbandman 0
3688952 1922705 1922705 defendant Kyng Richard husbandman 596900 596900 Kyng, Richard, of Godmanchester, husbandman 0
3695911 1924958 1924958 defendant Mayes John miller 596900 596900 Mayes, John, of Godmanchester, miller 0
3712864 1930342 1930342 defendant Wynde Dorothy widow 596900 596900 Wynde, Dorothy, of Godmanchester, widow 3
3759191 1944862 1944862 defendant Wyld John husbandman 596900 596900 Wyld, John, of Godmanchester, husbandman 0
3759195 1944863 1944863 defendant Page John husbandman 596900 596900 Page, John, of Godmanchester, husbandman 0
3759197 1944863 1944863 defendant Ibotte William mercer 596900 596900 Ibotte, William, of Godmanchester, mercer 2
3761855 1945716 1945716 defendant Clapthorn Robert butcher 596900 596900 Clapthorn, Robert, of Godmanchester, butcher 1
3775567 1950102 1950102 defendant Meye John yeoman 596900 596900 Meye, John, of Godmanchester, yeoman 0
3775765 1950172 1950172 defendant Maye John yeoman 596900 596900 Maye, John, of Godmanchester, yeoman 0
3792043 1955363 1955363 defendant May John yeoman 596900 596900 May, John, of Godmanchester, yeoman 0
3802245 1958596 1958596 defendant Pelle Robert husbandman 596900 596900 Pelle, Robert, of Godmanchester, husbandman 0
3802246 1958596 1958596 defendant Wellys Simon smith 596900 596900 Wellys, Simon, of Godmanchester, smith 1
3808554 1960553 1960553 defendant May John yeoman 596900 596900 May, John, of Godmanchester, yeoman 0
3824922 1965673 1965673 defendant Page John husbandman 596900 596900 Page, John, of Godmanchester, husbandman 0
3824923 1965673 1965673 defendant Stoughton John husbandman 596900 596900 Stoughton, John, of Godmanchester, husbandman 1
3824924 1965673 1965673 defendant Massy Robert butcher 596900 596900 Massy, Robert, of Godmanchester, butcher 2
3824925 1965673 1965673 defendant Parker Thomas laborer 596900 596900 Parker, Thomas, of Godmanchester, laborer 3
3824926 1965673 1965673 defendant Heron Henry laborer 596900 596900 Heron, Henry, of Godmanchester, laborer 4
3827252 1966390 1966390 defendant Stylton William   596900 596900 Stylton, William, of Godmanchester, rope maker 0
3828427 1966763 1966763 defendant Townsend William husbandman 596900 596900 Townsend, William, of Godmanchester, husbandman 0
3836822 1969419 1969419 defendant Massey Robert butcher 596900 596900 Massey, Robert, of Godmanchester, butcher 0
3843330 1971446 1971446 defendant Townsend William husbandman 596900 596900 Townsend, William, of Godmanchester, husbandman 0
3852581 1974415 1974415 plaintiff Robyns Robert yeoman 596900 596900 Robyns, Robert, of Godmanchester, yeoman 0
3854503 1975048 1975048 defendant Marie Robert butcher 596900 596900 Marie, Robert, of Godmanchester, butcher 0
3854504 1975048 1975048 defendant Pell Robert husbandman 596900 596900 Pell, Robert, of Godmanchester, husbandman 1
3854506 1975049 1975049 defendant Maris or Marie Robert butcher 596900 596900 Maris or Marie, Robert, of Godmanchester, butcher 0
3854507 1975049 1975049 defendant Pell Robert husbandman 596900 596900 Pell, Robert, of Godmanchester, husbandman 1
3856347 1975604 1975604 defendant Wylde John husbandman 596900 596900 Wylde, John, of Godmanchester, husbandman 0
3859451 1976649 1976649 defendant Woodward Thomas gent 596900 596900 Woodward, Thomas, of Godmanchester, gent 1
3859480 1976659 1976659 defendant Woodward Thomas gent 596900 596900 Woodward, Thomas, of Godmanchester, gent 1
3859483 1976660 1976660 defendant Woodward Thomas gent 596900 596900 Woodward, Thomas, of Godmanchester, gent 1
3860227 1976914 1976914 defendant Warde Robert smith 596900 596900 Warde, Robert, of Godmanchester, smith 0
3861878 1977431 1977431 defendant Releton Brian butcher 596900 596900 Releton, Brian, of Godmanchester, butcher 0
3866970 1979192 1979192 defendant Wyld John husbandman 596900 596900 Wyld, John, of Godmanchester, husbandman 0
3866972 1979193 1979193 defendant Wylde John husbandman 596900 596900 Wylde, John, of Godmanchester, husbandman 0
3912426 1994488 1994488 defendant Massye Robert butcher 596900 596900 Massye, Robert, of Godmanchester, butcher 0
3927217 1999439 1999439 defendant Borough John yeoman 596900 596900 Borough, John, of Godmanchester, yeoman 1
4014239 2029821 2029821 defendant Collyns Richard yeoman 596900 596900 Collyns, Richard, of Godmanchester, yeoman 1
4129058 2070694 2070694 defendant Blascocke William husbandman 596900 596900 Blascocke, William, of Godmanchester, husbandman 2
4132579 2071970 2071970 defendant Fayrpoynt Richard yeoman 596900 596900 Fayrpoynt, Richard, of Godmanchester, yeoman 0
4141023 2075019 2075019 defendant Martyn James yeoman 596900 596900 Martyn, James, of Godmanchester, yeoman 0
4152540 2079003 2079003 defendant Herne Robert yeoman 596900 596900 Herne, Robert, of Godmanchester, yeoman 0
4162719 2082516 2082516 defendant Newman John husbandman 596900 596900 Newman, John, of Godmanchester, husbandman 0
4194475 2093619 2093619 defendant Coore Richard gent 596900 596900 Coore, Richard, of Godmanchester, gent 0
4212866 2100032 2100032 defendant Dorrington Ambrose clerk 596900 596900 Dorrington, Ambrose, of Godmanchester, clerk 1
4212869 2100033 2100033 defendant Williams Thomas fishmonger 596900 596900 Williams, Thomas, of Godmanchester, fishmonger 0
4275585 2121404 2121404 defendant Male Mathew yeoman 596900 596900 Male, Mathew, of Godmanchester, yeoman 0
4275586 2121404 2121404 defendant Male William yeoman 596900 596900 Male, William, of Godmanchester, yeoman 1
4289191 2126188 2126188 defendant Stevenson John husbandman 596900 596900 Stevenson, John, of Godmanchester, husbandman 0
4293032 2127569 2127569 defendant Fetherbye John husbandman 596900 596900 Fetherbye, John, of Godmanchester, husbandman 0
4293759 2127836 2127836 defendant Bentlie Henry laborer 596900 596900 Bentlie, Henry, of Godmanchester, laborer 0
4295646 2128527 2128527 defendant Bushe Nicholas husbandman 596900 596900 Bushe, Nicholas, of Godmanchester, husbandman 0
4297773 2129311 2129311 defendant Stevenson John husbandman 596900 596900 Stevenson, John, of Godmanchester,husbandman 0
4304544 2131726 2131726 defendant Fetherbie John husbandman 596900 596900 Fetherbie, John, of Godmanchester, husbandman 0
4309286 2133402 2133402 defendant Vawse Thomas husbandman 596900 596900 Vawse, Thomas, of Godmanchester, husbandman 1
4314768 2135276 2135276 defendant Tryce Jasper gent 596900 596900 Tryce, Jasper, of Godmanchester, gent 1
4321267 2137530 2137530 defendant Moatley John, junior husbandman 596900 596900 Moatley, John, junior, of Godmanchester, husbandman 0
4323319 2138218 2138218 defendant Besowth Richard yeoman 596900 596900 Besowth, Richard, of Godmanchester, yeoman 0
4334782 2141903 2141903 defendant Normanton Thomas husbandman 596900 596900 Normanton, Thomas, of Godmanchester, husbandman 0
4336839 2142612 2142612 defendant Normanton John yeoman 596900 596900 Normanton, John, of Godmanchester, yeoman 0
4336840 2142612 2142612 defendant Fetherbie John husbandman 596900 596900 Fetherbie, John, of Godmanchester, husbandman 1
4336841 2142612 2142612 defendant Aldred William yeoman 596900 596900 Aldred, William, of Godmanchester, yeoman 2
4336842 2142612 2142612 defendant Glascocke William husbandman 596900 596900 Glascocke, William, of Godmanchester, husbandman 3
4338048 2143049 2143049 defendant Burte William victualer 596900 596900 Burte, William, of Godmanchester, victualer 0
4338049 2143049 2143049 defendant Alred William yeoman 596900 596900 Alred, William, of Godmanchester, yeoman 1
4338050 2143049 2143049 defendant Stapper George innholder 596900 596900 Stapper, George, of Godmanchester, innholder 2
4338603 2143257 2143257 defendant Besowthe Richard yeoman 596900 596900 Besowthe, Richard, of Godmanchester, yeoman 0
4338605 2143258 2143258 defendant Westcoate John yeoman 596900 596900 Westcoate, John, of Godmanchester, yeoman 0
4338621 2143264 2143264 defendant Featherbie John yeoman 596900 596900 Featherbie, John, of Godmanchester, yeoman 1
4340247 2143851 2143851 defendant Besowthe Richard maltster 596900 596900 Besowthe, Richard, of Godmanchester, maltster 0
4340880 2144082 2144082 defendant Strachie or Strachey Samuel butcher 596900 596900 Strachie or Strachey, Samuel, of Godmanchester, butcher 0
4340940 2144108 2144108 defendant Turkington Henry husbandman 596900 596900 Turkington, Henry, of Godmanchester, husbandman 0
4346210 2145928 2145928 defendant Starchey Samuel butcher 596900 596900 Starchey, Samuel, of Godmanchester, butcher 0
4346211 2145928 2145928 defendant Richardson Hugh yeoman 596900 596900 Richardson, Hugh, of Godmanchester, yeoman 1
4346212 2145928 2145928 defendant Stocker Thomas tanner 596900 596900 Stocker, Thomas, of Godmanchester, tanner 2
4350689 2147493 2147493 defendant Frere Thomas gent 596900 596900 Frere, Thomas, of Godmanchester, gent 0
4350690 2147493 2147493 defendant Burte William tailor 596900 596900 Burte, William, of Godmanchester, tailor 1
4351664 2147825 2147825 defendant Besouthe Richard yeoman 596900 596900 Besouthe, Richard, of Godmanchester, yeoman 0
4353452 2148430 2148430 defendant Cromwell Oliver esq 596900 596900 Cromwell, Oliver, of Godmanchester, or of Hallywell, Hunts, esq 0
4353455 2148431 2148431 defendant Cromwell Oliver esq 596900 596900 Cromwell, Oliver, of Godmanchester, or of Hallywell, Hunts, esq 0
4354391 2148766 2148766 defendant Elward John glover 596900 596900 Elward, John, of Godmanchester, glover 0
4360153 2150795 2150795 defendant Normanton John yeoman 596900 596900 Normanton, John, of Godmanchester, yeoman 0
4360154 2150795 2150795 defendant Fetherbie John husbandman 596900 596900 Fetherbie, John, of Godmanchester, husbandman 1
4360155 2150795 2150795 defendant Aldred William yeoman 596900 596900 Aldred, William, of Godmanchester, yeoman 2
4360156 2150795 2150795 defendant Glascocke William husbandman 596900 596900 Glascocke, William, of Godmanchester, husbandman 3
4374448 2155930 2155930 defendant Bowler Robert gent 596900 596900 Bowler, Robert, of Godmanchester, or of Geaynes Hall, gent 0
4378549 2157401 2157401 defendant Fetherbie John yeoman 596900 596900 Fetherbie, John, of Godmanchester, yeoman 0
4379688 2157832 2157832 defendant Fetherbie John yeoman 596900 596900 Fetherbie, John, of Godmanchester, yeoman 0
4382405 2158816 2158816 defendant Starchie Samuel butcher 596900 596900 Starchie, Samuel, of Godmanchester, butcher 0
4398385 2164042 2164042 defendant Campinett Richard   596900 596900 Campinett, Richard, of Godmanchester, Hunts gent 0
4398386 2164042 2164042 defendant Trice Jasper gent 596900 596900 Trice, Jasper, of Godmanchester, gent 1
4407822 2167182 2167182 defendant Bushe Nicholas husbandman 596900 596900 Bushe, Nicholas, of Godmanchester, husbandman 1
4407823 2167182 2167182 defendant Glascocke William husbandman 596900 596900 Glascocke, William, of Godmanchester, husbandman 2

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