names

185 rows where place_id = 589386

✎ 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
3597450 1866821 1866821 plaintiff Warner James gent 589386 589386 Warner, James, of Chesham, gent 1
3615275 1872423 1872423 defendant Hayne or Hayno John gent 589386 589386 Hayne or Hayno, John, of Chesham, gent 0
3615276 1872423 1872423 defendant Mordon Richard husbandman 589386 589386 Mordon, Richard, of Chesham, husbandman 1
3615277 1872423 1872423 defendant Grynder John miller 589386 589386 Grynder, John, of Chesham, miller 2
3627252 1903369 1903369 defendant Stapulford Thomas husbandman 589386 589386 Stapulford, Thomas, of Chesham, husbandman 0
3631194 1904581 1904581 defendant Fulmer William yeoman 589386 589386 Fulmer, William, of Chesham, yeoman 0
3637833 1906650 1906650 defendant Trotte Simon chapman 589386 589386 Trotte, Simon, of Chesham, chapman 3
3644949 1908829 1908829 defendant Tredwey George husbandman 589386 589386 Tredwey, George, of Chesham, husbandman 0
3655997 1912126 1912126 defendant Bromeley alias Bruley Matilda widow 589386 589386 Bromeley alias Bruley, Matilda, of Chesham, widow 0
3657318 1912549 1912549 defendant Gate John, junior yeoman 589386 589386 Gate, John, junior, of Chesham, yeoman 0
3657319 1912549 1912549 defendant Gate John husbandman 589386 589386 Gate, John, of Chesham, husbandman 1
3666149 1915357 1915357 defendant Clark Thomas   589386 589386 Clark, Thomas, of Chesham, ca rpenter 0
3670250 1916641 1916641 defendant Gate John, senior husbandman 589386 589386 Gate, John, senior, of Chesham, husbandman 0
3671065 1916918 1916918 defendant Clemens Thomas weaver 589386 589386 Clemens, Thomas, of Chesham, weaver 1
3671067 1916919 1916919 defendant Cok Henry husbandman 589386 589386 Cok, Henry, of Chesham, husbandman 0
3671068 1916919 1916919 defendant Masse Thomas butcher 589386 589386 Masse, Thomas, of Chesham, butcher 1
3671069 1916919 1916919 defendant Ussher Nicholas (legal representative) 589386 589386 Ussher, Nicholas, of Chesham, executors of 2
3671070 1916919 1916919 defendant Morley John weaver 589386 589386 (Morley, John, of Chesham, weaver 3
3672500 1917401 1917401 defendant Tournour William husbandman 589386 589386 Tournour, William, of Chesham, husbandman 0
3672502 1917401 1917401 defendant Turnour Joseph husbandman 589386 589386 Turnour, Joseph, of Chesham, husbandman 2
3675198 1918275 1918275 plaintiff Hardyng Thomas   589386 589386 Hardyng, Thomas, of Chesham 0
3675199 1918275 1918275 defendant Clerk Thomas, junior carpenter 589386 589386 Clerk, Thomas, junior, of Chesham, carpenter 0
3687115 1922143 1922143 defendant Clemens Thomas husbandman or weaver 589386 589386 Clemens, Thomas, of Chesham, husbandman or weaver 0
3687859 1922366 1922366 defendant Hardyng Edmund husbandman 589386 589386 Hardyng, Edmund, of Chesham, husbandman 2
3690408 1923165 1923165 defendant Clerk Thomas carpenter 589386 589386 Clerk, Thomas, of Chesham, carpenter 0
3690417 1923168 1923168 defendant Clerk Thomas carpenter 589386 589386 Clerk, Thomas, of Chesham, carpenter 0
3704649 1927741 1927741 plaintiff Gardener Walter yeoman 589386 589386 Gardener, Walter, of Chesham, yeoman 0
3704650 1927741 1927741 plaintiff Pound Henry yeoman 589386 589386 Pound, Henry, of Chesham, yeoman 1
3704896 1927825 1927825 defendant Rowberd Stephen husbandman 589386 589386 Rowberd, Stephen, of Chesham, husbandman 0
3704897 1927825 1927825 defendant Walaxston Christopher chandler 589386 589386 Walaxston, Christopher, of Chesham, chandler 1
3704898 1927825 1927825 defendant Hardyng John husbandman 589386 589386 Hardyng, John, of Chesham, husbandman 2
3704899 1927825 1927825 defendant Wheteley William butcher 589386 589386 Wheteley, William, of Chesham, butcher 3
3704900 1927825 1927825 defendant Gate John butcher 589386 589386 Gate, John, of Chesham, butcher 4
3709892 1929409 1929409 defendant Wheteley William husbandman 589386 589386 Wheteley, William, of Chesham, husbandman 0
3715427 1931111 1931111 defendant Clerk Thomas carpenter 589386 589386 Clerk, Thomas, of Chesham, carpenter 0
3719840 1932471 1932471 defendant Gate William butcher 589386 589386 Gate, William, of Chesham, butcher 0
3729429 1935449 1935449 defendant Lenard Henry shoemaker 589386 589386 Lenard, Henry, of Chesham, shoemaker 0
3749320 1941713 1941713 defendant West Thomas laborer 589386 589386 West, Thomas, of Chesham, laborer 2
3749321 1941713 1941713 defendant Hylle John laborer 589386 589386 Hylle, John, of Chesham, laborer 3
3769702 1948180 1948180 defendant Gate John husbandman 589386 589386 Gate, John, of Chesham, husbandman 1
3769704 1948180 1948180 defendant Wydmer Nicholas wheeler 589386 589386 Wydmer, Nicholas, of Chesham, wheeler 3
3779150 1951202 1951202 defendant Gate John butcher 589386 589386 Gate, John, of Chesham, butcher 0
3780654 1951676 1951676 defendant Gate William butcher 589386 589386 Gate, William, of Chesham, butcher 1
3788288 1954134 1954134 defendant Banaster George tanner 589386 589386 Banaster, George, of Chesham, tanner 0
3838576 1969991 1969991 defendant Hardyng John yeoman 589386 589386 Hardyng, John, of Chesham, yeoman 0
3838587 1969995 1969995 defendant Hardyng John yeoman 589386 589386 Hardyng, John, of Chesham, yeoman 0
3841129 1970801 1970801 defendant Bennyng Richard husbandman 589386 589386 Bennyng, Richard, of Chesham, husbandman 0
3855520 1975370 1975370 defendant Hutton Robert yeoman 589386 589386 Hutton, Robert, of Chesham, yeoman 0
3859502 1976667 1976667 defendant Rychardson John carpenter 589386 589386 Rychardson, John, of Chesham, carpenter 0
3861770 1977402 1977402 defendant Tochyll alias Tochyn James husbandman 589386 589386 Tochyll alias Tochyn, James, of Chesham, husbandman 0
3861772 1977403 1977403 defendant Tochyll alias Tochyn James husbandman 589386 589386 Tochyll alias Tochyn, James, of Chesham, husbandman 0
3862873 1977775 1977775 defendant Hawkyns John weaver 589386 589386 Hawkyns, John, of Chesham, weaver 0
3867372 1979319 1979319 defendant Gate William husbandman 589386 589386 Gate, William, of Chesham, husbandman 0
3872711 1981088 1981088 defendant Byrche Robert husbandman 589386 589386 Byrche, Robert, of Chesham, husbandman 3
3900973 1990554 1990554 plaintiff Cheyne John gent 589386 589386 Cheyne, John, of Chesham, gent 0
3900979 1990556 1990556 defendant Cokdell Henry husbandman 589386 589386 Cokdell, Henry, of Chesham, husbandman 1
3904102 1991615 1991615 defendant Long John   589386 589386 Long, John, of Chesham 0
3914747 1995277 1995277 plaintiff Cheyne John gent 589386 589386 Cheyne, John, of Chesham, gent 0
3915484 1995548 1995548 defendant Horn John miller 589386 589386 Horn, John, of Chesham, miller 1
3928293 1999799 1999799 defendant Byrche James yeoman 589386 589386 Byrche, James, of Chesham, yeoman 0
3928294 1999799 1999799 defendant Alen Richard husbandman 589386 589386 Alen, Richard, of Chesham, husbandman 1
3946184 2005743 2005743 defendant Johnson William husbandman 589386 589386 Johnson, William, of Chesham, husbandman 0
3946185 2005743 2005743 defendant Johnson Richard laborer 589386 589386 Johnson, Richard, of Chesham, laborer 1
3964567 2012211 2012211 plaintiff Atkyns John yeoman 589386 589386 Atkyns, John, of Chesham, yeoman 0
3964572 2012212 2012212 plaintiff Atkyns John yeoman 589386 589386 Atkyns, John, of Chesham, yeoman 0
3982928 2018673 2018673 defendant Ayshefyld Thomas gent 589386 589386 Ayshefyld, Thomas, of Chesham, gent 0
3993728 2022506 2022506 plaintiff Cheyne John esq 589386 589386 Cheyne, John, of Chesham, esq 0
3996285 2023420 2023420 defendant Byrche James yeoman 589386 589386 (Byrche, James, of Chesham, yeoman 1
3997261 2023791 2023791 defendant Smythe William butcher 589386 589386 Smythe, William, of Chesham, butcher 0
4023484 2033108 2033108 defendant Cheyney Henry   589386 589386 Cheyney, Henry, of Chesham, Bucks gent 0
4026162 2034003 2034003 defendant Dell Henry husbandman 589386 589386 Dell, Henry, of Chesham, husbandman 0
4026166 2034005 2034005 defendant Turnor John husbandman 589386 589386 Turnor, John, of Chesham, husbandman 0
4026406 2034088 2034088 defendant Cheyney Henry   589386 589386 Cheyney, Henry, of Chesham, Bucks gent 0
4027356 2034431 2034431 plaintiff Cheyney John esq 589386 589386 Cheyney, John, of Chesham, esq 0
4028077 2034692 2034692 defendant Cheyney Henry   589386 589386 Cheyney, Henry, of Chesham, Bucks gent 0
4028100 2034700 2034700 defendant Turnor Richard husbandman 589386 589386 Turnor, Richard, of Chesham, husbandman 0
4035729 2037454 2037454 defendant Turner Richard husbandman 589386 589386 Turner, Richard, of Chesham, husbandman 0
4035730 2037454 2037454 defendant Payne William laborer 589386 589386 Payne, William, of Chesham, laborer 1
4035731 2037454 2037454 defendant Wedon John laborer 589386 589386 Wedon, John, of Chesham, laborer 2
4035732 2037454 2037454 defendant Pratt Henry laborer 589386 589386 Pratt, Henry, of Chesham, laborer 3
4066072 2048153 2048153 defendant Gardener William (legal representative) 589386 589386 Gardener, William, of Chesham, husbandman, executors of 1
4066073 2048153 2048153 defendant Fourde John miller 589386 589386 (Fourde, John, of Chesham, miller 2
4443937 2183073 2183073 defendant Gromet Richard   589386 589386 Gromet, Richard, of Chesham 4
4443942 2183074 2183074 defendant Gromet Richard   589386 589386 Gromet, Richard, of Chesham 3
4465515 2189882 2189882 defendant Doffeld Thomas   589386 589386 Doffeld, Thomas, of Chesham 0
4546054 2214706 2214706 defendant Payn William   589386 589386 Payn, William, of Chesham 0
4546055 2214706 2214706 defendant Danver William   589386 589386 Danver, William, of Chesham 1
4556714 2218033 2218033 defendant Pynell John   589386 589386 Pynell, John, of Chesham 3
4568388 2221683 2221683 defendant Godehale Henry   589386 589386 Godehale, Henry, of Chesham 6
4611791 2234749 2234749 defendant Rumsey William   589386 589386 Rumsey, William, of Chesham 0
4629234 2240077 2240077 plaintiff Smyth Richard   589386 589386 Smyth, Richard, of Chesham 0
4637055 2242395 2242395 defendant Wykrygge William   589386 589386 Wykrygge, William, of Chesham 1
4637059 2242396 2242396 defendant Wykrygge William   589386 589386 Wykrygge, William, of Chesham 1
4657512 2248242 2248242 defendant Spycer William Bucks, draper 589386 589386 Spycer William, of Chesham, Bucks, draper 2
4663234 2249968 2249968 defendant Gery John husbandman 589386 589386 Gery, John, of Chesham, husbandman 0
4663661 2250113 2250113 defendant Grene John husbandman 589386 589386 Grene, John, of Chesham, husbandman 0
4695343 2264024 2264024 defendant Crykkelade John husbandman 589386 589386 Crykkelade, John, of Chesham, husbandman 0
4719826 2271546 2271546 defendant Grace William   589386 589386 Grace, William, of Chesham 0
4720396 2271714 2271714 plaintiff Brook William   589386 589386 Brook, William, of Chesham 0
4798019 2295566 2295566 defendant Theccher Richard   589386 589386 Theccher, Richard, of Chesham 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);