names

94 rows where place_id = 596426

✎ 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
3624724 1875271 1875271 defendant Kebyll Thomas gent 596426 596426 Kebyll, Thomas, of Glemsford, gent 1
3633268 1905222 1905222 defendant Jorden John husbandman 596426 596426 Jorden, John, of Glemsford, husbandman 1
3633269 1905222 1905222 defendant Rogyll William yeoman 596426 596426 Rogyll, William, of Glemsford, yeoman 2
3684636 1921328 1921328 defendant Manwod Thomas clothmaker 596426 596426 Manwod, Thomas, of Glemsford, clothmaker 0
3684637 1921328 1921328 defendant Strawe John weaver 596426 596426 Strawe, John, of Glemsford, weaver 1
3690423 1923170 1923170 defendant Brewster Thomas fuller 596426 596426 Brewster, Thomas, of Glemsford, fuller 0
3690425 1923171 1923171 defendant Brewster Thomas fuller 596426 596426 Brewster, Thomas, of Glemsford, fuller 0
3702697 1927114 1927114 defendant Hunt John smith 596426 596426 Hunt, John, of Glemsford, smith 0
3704882 1927819 1927819 defendant Hunt John smith 596426 596426 Hunt, John, of Glemsford, smith 0
3705690 1928061 1928061 defendant Dyster George clothmaker 596426 596426 Dyster, George, of Glemsford, clothmaker 1
3711264 1929827 1929827 plaintiff Sudbury Agnes (legal representative) 596426 596426 Sudbury, Agnes, of Glemsford, executors of 0
3711266 1929827 1929827 plaintiff Bygge John   596426 596426 Bygge, John, of Glemsford, son of Bygge, John, senior 2
3711267 1929827 1929827 defendant Everard William fuller 596426 596426 Everard, William, of Glemsford, fuller 0
3711268 1929828 1929828 plaintiff Sudbury Agnes (legal representative) 596426 596426 Sudbury, Agnes, of Glemsford, executors of 0
3711270 1929828 1929828 plaintiff Bygge John   596426 596426 Bygge, John, of Glemsford, son of Bygge, John, senior 2
3711271 1929828 1929828 defendant Everard William fuller 596426 596426 Everard, William, of Glemsford, fuller 0
3734603 1937070 1937070 defendant Marshall Nicholas sherman 596426 596426 Marshall, Nicholas, of Glemsford, sherman 0
3741171 1939100 1939100 defendant Marchall Nicholas sherman 596426 596426 Marchall, Nicholas, of Glemsford, sherman 1
3744520 1940187 1940187 defendant Ruggyll William, senior fuller 596426 596426 Ruggyll, William, senior, of Glemsford, fuller 2
3746707 1940883 1940883 defendant Frost William yeoman 596426 596426 Frost, William, of Glemsford, yeoman 0
3748728 1941533 1941533 defendant Smethe Thomas weaver 596426 596426 Smethe, Thomas, of Glemsford, weaver 0
3750660 1942128 1942128 defendant Dister George weaver 596426 596426 Dister, George, of Glemsford, weaver 1
3750661 1942128 1942128 defendant Crykke James sherman 596426 596426 Crykke, James, of Glemsford, sherman 2
3752494 1942704 1942704 defendant Rove John husbandman 596426 596426 Rove, John, of Glemsford, husbandman 2
3762029 1945770 1945770 defendant Reter John clothmaker 596426 596426 Reter, John, of Glemsford, clothmaker 1
3765286 1946807 1946807 defendant Barton John husbandman 596426 596426 Barton, John, of Glemsford, husbandman 1
3774219 1949653 1949653 defendant Manwood Richard clothmaker 596426 596426 Manwood, Richard, of Glemsford, clothmaker 0
3784399 1952901 1952901 defendant Cryk John sherman 596426 596426 Cryk, John, of Glemsford, sherman 0
3795878 1956576 1956576 defendant Fowler Margaret widow 596426 596426 Fowler, Margaret, of Glemsford, widow 0
3797952 1957257 1957257 plaintiff Strutt Thomas clothmaker 596426 596426 Strutt, Thomas, of Glemsford, clothmaker 1
3814413 1962423 1962423 defendant Manwode James yeoman 596426 596426 Manwode, James, of Glemsford, yeoman 0
3814414 1962423 1962423 defendant Roote John weaver 596426 596426 Roote, John, of Glemsford, weaver 1
3833949 1968557 1968557 defendant Dystar John miller 596426 596426 Dystar, John, of Glemsford, miller 0
3836447 1969307 1969307 defendant Butler William weaver 596426 596426 Butler, William, of Glemsford, weaver 0
3836642 1969364 1969364 defendant Botyller William fuller 596426 596426 Botyller, William, of Glemsford, fuller 0
3836643 1969364 1969364 defendant Dyster John smith 596426 596426 Dyster, John, of Glemsford, smith 1
3863931 1978113 1978113 defendant Smethe Thomas weaver 596426 596426 Smethe, Thomas, of Glemsford, weaver 0
3867880 1979491 1979491 defendant Berton John husbandman 596426 596426 Berton, John, of Glemsford, husbandman 0
3867881 1979491 1979491 defendant Smyth Giles tailor 596426 596426 Smyth, Giles, of Glemsford, tailor 1
3888307 1986353 1986353 defendant Goldyng John yeoman 596426 596426 Goldyng, John, of Glemsford, yeoman 0
3892068 1987599 1987599 defendant Holborowe John clothmaker 596426 596426 Holborowe, John, of Glemsford, clothmaker 0
3892069 1987599 1987599 defendant Stratte John clothmaker 596426 596426 Stratte, John, of Glemsford, clothmaker 1
3894069 1988232 1988232 defendant Rotte John barber 596426 596426 Rotte, John, of Glemsford, barber 4
3909055 1993328 1993328 plaintiff Scott Richard clothmaker 596426 596426 Scott, Richard, of Glemsford, clothmaker 0
3938835 2003330 2003330 defendant Frost Richard clothier 596426 596426 Frost, Richard, of Glemsford, clothier 0
3938836 2003330 2003330 defendant Holborowe William clothier 596426 596426 Holborowe, William, of Glemsford, clothier 1
3938837 2003330 2003330 defendant Cryke John sheer man 596426 596426 Cryke, John, of Glemsford, sheer man 2
3943739 2004922 2004922 defendant Heigham George clothier 596426 596426 Heigham, George, of Glemsford, clothier 0
3943740 2004922 2004922 defendant Aleyne John clothier 596426 596426 Aleyne, John, of Glemsford, clothier 1
3943742 2004923 2004923 defendant Heigham George clothier 596426 596426 Heigham, George, of Glemsford, clothier 0
3943743 2004923 2004923 defendant Aleyne John clothier 596426 596426 Aleyne, John, of Glemsford, clothier 1
3952934 2008096 2008096 defendant Manwood James weaver 596426 596426 Manwood, James, of Glemsford, weaver 0
3962465 2011464 2011464 defendant Lurkyn John clothier 596426 596426 Lurkyn, John, of Glemsford, clothier 0
3962466 2011464 2011464 defendant Brewster Thomas clothier 596426 596426 Brewster, Thomas, of Glemsford, clothier 1
3963842 2011957 2011957 plaintiff Allyn John clothier 596426 596426 Allyn, John, of Glemsford, clothier 0
4052656 2043375 2043375 defendant Crosse Edward butcher 596426 596426 Crosse, Edward, of Glemsford, butcher 2
4067683 2048754 2048754 defendant Allen Edward yeoman 596426 596426 Allen, Edward, of Glemsford, yeoman 0
4077186 2052126 2052126 defendant Stansbye Robert yeoman 596426 596426 Stansbye, Robert, of Glemsford, yeoman 0
4099034 2059981 2059981 defendant Heywood John husbandman 596426 596426 Heywood, John, of Glemsford, husbandman 0
4110721 2064093 2064093 defendant Hardye Thomas sherman 596426 596426 Hardye, Thomas, of Glemsford, sherman 1
4127028 2069956 2069956 defendant Mason John clothier 596426 596426 Mason, John, of Glemsford, clothier 0
4153574 2079342 2079342 defendant Howe William clothier 596426 596426 Howe, William, of Glemsford, clothier 0
4307549 2132778 2132778 defendant Parker Thomas yeoman 596426 596426 Parker, Thomas, of Glemsford, yeoman 0
4335238 2142058 2142058 defendant Hardie Thomas sherman 596426 596426 Hardie, Thomas, of Glemsford, sherman 3
4387584 2160485 2160485 defendant Frost John clothier 596426 596426 Frost, John, of Glemsford, clothier 1
4681733 2259899 2259899 defendant Fitz Adam Richard husbandman 596426 596426 Fitz Adam, Richard, of Glemsford, husbandman 2
4829516 2305271 2305271 defendant Skynnere John yeoman 596426 596426 Skynnere, John, of Glemsford, yeoman 0
4910558 2329813 2329813 defendant Letton Ralph husbandman 596426 596426 Letton, Ralph, of Glemsford, husbandman 0
5113403 2390312 2390312 plaintiff Panel or Pavel William   596426 596426 Panel or Pavel, William, of Glemsford 1
5125967 2394081 2394081 defendant Ewnce Thomas gent 596426 596426 Ewnce, Thomas, of Glemsford, gent 0
5144703 2399607 2399607 defendant Halle Robert butcher 596426 596426 Halle, Robert, of Glemsford, butcher 1
5280727 2439439 2439439 defendant Wode Richard (legal representative) 596426 596426 Wode, Richard, of Glemsford, fuller, executrix of 3
5369069 2465924 2465924 defendant Rokell John husbandman 596426 596426 Rokell, John, of Glemsford, husbandman 0
5522625 2511901 2511901 defendant Hoo John husbandman 596426 596426 Hoo, John, of Glemsford, husbandman 4
5527914 2513296 2513296 defendant Hoo John husbandman 596426 596426 Hoo, John, of Glemsford, husbandman 0
5527915 2513296 2513296 defendant Hoo William husbandman 596426 596426 Hoo, William, of Glemsford, husbandman 1
5542270 2517713 2517713 defendant Hoo William wheeler 596426 596426 Hoo, William, of Glemsford, wheeler 1
5553530 2521060 2521060 defendant Manwode John, senior clothmaker 596426 596426 Manwode, John, senior, of Glemsford, clothmaker 0
5565619 2524536 2524536 defendant Dyster Alan weaver 596426 596426 Dyster, Alan, of Glemsford, weaver 1
5568649 2525381 2525381 plaintiff Frost Roger   596426 596426 Frost, Roger, of Glemsford 0
5578735 2528412 2528412 plaintiff Bakster Agnes   596426 596426 Bakster, Agnes, of Glemsford 0
5578737 2528413 2528413 plaintiff Bakster Agnes   596426 596426 Bakster, Agnes, of Glemsford 0
5586980 2530955 2530955 defendant Anderson Richard tailor 596426 596426 Anderson, Richard, of Glemsford, tailor 0
5586981 2530955 2530955 defendant Everard Ralph weaver 596426 596426 Everard, Ralph, of Glemsford, weaver 1
5586982 2530955 2530955 defendant Bygg William laborer 596426 596426 Bygg, William, of Glemsford, laborer 2
5586983 2530955 2530955 defendant Everard John weaver 596426 596426 Everard, John, of Glemsford, weaver 3
5589754 2531790 2531790 defendant Hunt John smith 596426 596426 Hunt, John, of Glemsford, smith 3
5598927 2534543 2534543 plaintiff Frost Roger clothmaker 596426 596426 Frost, Roger, of Glemsford, clothmaker 0
5602301 2535615 2535615 defendant Heygeman William husbandman 596426 596426 Heygeman, William, of Glemsford, husbandman 1
5602302 2535615 2535615 defendant Gardener John baker 596426 596426 Gardener, John, of Glemsford, baker 2
5602306 2535615 2535615 defendant Jurdon John husbandman 596426 596426 Jurdon, John, of Glemsford, husbandman 6
5604596 2536297 2536297 defendant Dalton Geoffrey yeoman 596426 596426 Dalton, Geoffrey, of Glemsford, yeoman 0
5604749 2536347 2536347 defendant Atthoo John husbandman 596426 596426 Atthoo, John, of Glemsford, husbandman 1
5634722 2554856 2554856 defendant Glemsford John   596426 596426 Glemsford, John, of Glemsford 0

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