names

118 rows where place_id = 586740

✎ 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
3589503 1864353 1864353 defendant Swan William gent 586740 586740 Swan, William, of Denham, gent 1
3599099 1867354 1867354 defendant Ingold Thomas yeoman 586740 586740 Ingold, Thomas, of Denham, yeoman 1
3611251 1871197 1871197 defendant Curson William gent 586740 586740 Curson, William, of Denham, gent 0
3616179 1872698 1872698 defendant Godard William husbandman 586740 586740 Godard, William, of Denham, husbandman 4
3674142 1917950 1917950 defendant Durdant George yeoman 586740 586740 Durdant, George, of Denham, yeoman 1
3674143 1917950 1917950 defendant Durdant Nicholas yeoman 586740 586740 Durdant, Nicholas, of Denham, yeoman 2
3674144 1917950 1917950 defendant Logge Thomas yeoman 586740 586740 Logge, Thomas, of Denham, yeoman 3
3681378 1920262 1920262 defendant Lauerauns Richard husbandman 586740 586740 Lauerauns, Richard, of Denham, husbandman 1
3686887 1922062 1922062 defendant Bardwall Edward gent 586740 586740 Bardwall, Edward, of Denham, gent 0
3704654 1927742 1927742 defendant Andrewe Hugh collier 586740 586740 Andrewe, Hugh, of Denham, collier 1
3710619 1929643 1929643 defendant Rawlyng John husbandman 586740 586740 Rawlyng, John, of Denham, husbandman 0
3718644 1932110 1932110 defendant Andrewe Hugh husbandman 586740 586740 Andrewe, Hugh, of Denham, husbandman 0
3718646 1932111 1932111 defendant Andrewe Hugh husbandman 586740 586740 Andrewe, Hugh, of Denham, husbandman 0
3718649 1932112 1932112 defendant Andrewe Hugh husbandman 586740 586740 Andrewe, Hugh, of Denham, husbandman 1
3718652 1932113 1932113 defendant Andrewe Hugh husbandman 586740 586740 Andrewe, Hugh, of Denham, husbandman 1
3737258 1937886 1937886 defendant Bardwell Edward gent 586740 586740 Bardwell, Edward, of Denham, gent 0
3753423 1943009 1943009 defendant Selfe William carpenter 586740 586740 Selfe, William, of Denham, carpenter 3
3757928 1944463 1944463 defendant Elsyng John laborer 586740 586740 Elsyng, John, of Denham, laborer 4
3765917 1947006 1947006 defendant Selff William carpenter 586740 586740 Selff, William, of Denham, carpenter 0
3780504 1951633 1951633 defendant Avys William husbandman 586740 586740 Avys, William, of Denham, husbandman 1
3780505 1951633 1951633 defendant Mody John husbandman 586740 586740 Mody, John, of Denham, husbandman 2
3784574 1952963 1952963 defendant Selff William carpenter 586740 586740 Selff, William, of Denham, carpenter 0
3784575 1952963 1952963 defendant Selff Nicholas husbandman 586740 586740 Selff, Nicholas, of Denham, husbandman 1
3796944 1956925 1956925 defendant Bardwell Edward gent 586740 586740 Bardwell, Edward, of Denham, gent 0
3809516 1960859 1960859 defendant Tredwey John husbandman 586740 586740 Tredwey, John, of Denham, husbandman 0
3848974 1973274 1973274 defendant Selff William carpenter 586740 586740 Selff, William, of Denham, carpenter 0
3860628 1977047 1977047 defendant Selfe William carpenter 586740 586740 Selfe, William, of Denham, carpenter 0
3904021 1991586 1991586 defendant Bardewell Edward gent 586740 586740 Bardewell, Edward, of Denham, gent 0
3924324 1998442 1998442 defendant Pratye alias Patye John yeoman 586740 586740 Pratye alias Patye, John, of Denham, yeoman 2
3952544 2007958 2007958 defendant Denys William gent 586740 586740 Denys, William, of Denham, gent 0
3965634 2012595 2012595 plaintiff Bedingfilde Edmund esq 586740 586740 Bedingfilde, Edmund, of Denham, esq 0
3965637 2012596 2012596 plaintiff Bedyngefeld Edmund esq 586740 586740 Bedyngefeld, Edmund, of Denham, esq 0
3965641 2012598 2012598 plaintiff Bedyngfelde Edmund esq 586740 586740 Bedyngfelde, Edmund, of Denham, esq 0
3974626 2015691 2015691 defendant Self Robert husbandman 586740 586740 Self, Robert, of Denham, husbandman 0
3974627 2015691 2015691 defendant Cuttinge William husbandman 586740 586740 Cuttinge, William, of Denham, husbandman 1
3989914 2021149 2021149 defendant Smyth John husbandman 586740 586740 Smyth, John, of Denham, husbandman 0
4000387 2024907 2024907 plaintiff Grantham Robert gent 586740 586740 Grantham, Robert, of Denham, gent 0
4034982 2037193 2037193 plaintiff Heigham Martha widow 586740 586740 Heigham, Martha, of Denham, widow 0
4057140 2044940 2044940 defendant Smythe John (legal representative) 586740 586740 Smythe, John, of Denham, executor of 0
4113232 2064998 2064998 defendant Welshe Arnold gent 586740 586740 Welshe, Arnold, of Denham, gent 0
4117304 2066490 2066490 defendant Waddington John laborer 586740 586740 Waddington, John, of Denham, laborer 2
4125320 2069340 2069340 defendant Homes Thomas yeoman 586740 586740 Homes, Thomas, of Denham, yeoman 1
4135802 2073133 2073133 defendant Russell Giles husbandman 586740 586740 Russell, Giles, of Denham, husbandman 2
4155252 2079930 2079930 defendant Homes Thomas yeoman 586740 586740 Homes, Thomas, of Denham, yeoman 1
4204560 2097143 2097143 defendant Herbert Henry gent 586740 586740 Herbert, Henry, of Denham, gent 0
4253197 2114065 2114065 defendant Sanderson Robert yeoman 586740 586740 Sanderson, Robert, of Denham, yeoman 0
4295021 2128302 2128302 defendant Easton John yeoman 586740 586740 Easton, John, of Denham, yeoman 0
4305104 2131926 2131926 defendant Cheif William miller 586740 586740 Cheif, William, of Denham, miller 1
4305901 2132202 2132202 defendant Butles William husbandman 586740 586740 Butles, William, of Denham, husbandman 0
4332859 2141273 2141273 defendant Saunderson Robert yeoman 586740 586740 Saunderson, Robert, of Denham, yeoman 1
4335895 2142285 2142285 defendant Haile Roger yeoman 586740 586740 Haile, Roger, of Denham, yeoman 0
4388779 2160880 2160880 defendant Fermor Philip clerk 586740 586740 Fermor, Philip, of Denham, clerk 0
4404631 2166118 2166118 defendant Crane William yeoman 586740 586740 Crane, William, of Denham, yeoman 0
4414579 2169465 2169465 defendant Durdaunt John   586740 586740 Durdaunt, John, of Denham 0
4465669 2189938 2189938 plaintiff Wyke John   586740 586740 Wyke, John, of Denham, parson 0
4465671 2189939 2189939 plaintiff Wyke John   586740 586740 Wyke, John, of Denham, parson 0
4546563 2214855 2214855 defendant Neel John grocer 586740 586740 Neel, John, of Denham, grocer 0
4555609 2217683 2217683 plaintiff Herun Roger   586740 586740 Herun, Roger, of Denham 0
4629968 2240294 2240294 defendant Talbot John   586740 586740 Talbot, John, of Denham 0
4640902 2243437 2243437 defendant Baron James   586740 586740 Baron, James, of Denham 1
4648048 2245495 2245495 defendant Moce John   586740 586740 Moce, John, of Denham 0
4655381 2247574 2247574 plaintiff Brook John draper 586740 586740 Brook, John, of Denham, draper 0
4684238 2260675 2260675 defendant Lambard John tiler 586740 586740 Lambard, John, of Denham, tiler 0
4761857 2284052 2284052 defendant Clerk Richard butcher 586740 586740 Clerk, Richard, of Denham, butcher 1
4787889 2292279 2292279 defendant Mose John yeoman 586740 586740 Mose, John, of Denham, yeoman 0
4821211 2302715 2302715 plaintiff Roger John esq 586740 586740 Roger, John, of Denham, esq, on his own account 0
4843944 2309623 2309623 defendant Stonehous Thomas yeoman 586740 586740 Stonehous, Thomas, of Denham, yeoman 0
4906080 2328496 2328496 defendant Gaunt John tiler 586740 586740 Gaunt, John, of Denham, tiler 0
4974755 2349418 2349418 defendant Bettys Hugh   586740 586740 Bettys, Hugh, of Denham, shepherd 2
5091173 2383819 2383819 plaintiff Muchgode Robert gent 586740 586740 Muchgode, Robert, of Denham, gent 0
5103959 2387583 2387583 defendant Tilly Walter carpenter 586740 586740 Tilly, Walter, of Denham, carpenter 1
5111523 2389768 2389768 defendant Tylly William carpenter 586740 586740 Tylly, William, of Denham, carpenter 1
5111524 2389768 2389768 defendant Wakefeld John carpenter 586740 586740 Wakefeld, John, of Denham, carpenter 2
5116389 2391223 2391223 plaintiff Osmonde Thomas husbandman 586740 586740 Osmonde, Thomas, of Denham, husbandman 0
5116391 2391224 2391224 plaintiff Osmonde Thomas husbandman 586740 586740 Osmonde, Thomas, of Denham, husbandman 0
5271645 2436802 2436802 plaintiff Harlyston William esq 586740 586740 Harlyston, William, of Denham, esq 0
5271647 2436803 2436803 plaintiff Harlyston William esq 586740 586740 Harlyston, William, of Denham, esq 0
5285767 2440863 2440863 plaintiff Harleston William esq 586740 586740 Harleston, William, of Denham, esq 0
5294040 2443230 2443230 defendant Marchaunt John husbandman 586740 586740 Marchaunt, John, of Denham, husbandman 1
5316711 2450086 2450086 defendant Waltham William butcher 586740 586740 Waltham, William, of Denham, butcher 1
5316712 2450086 2450086 defendant Crouche William husbandman 586740 586740 Crouche, William, of Denham, husbandman 2
5333933 2455224 2455224 defendant Waltham William butcher 586740 586740 together with Waltham, William, of Denham, butcher 1
5333934 2455224 2455224 defendant Crouche William husbandman 586740 586740 Crouche, William, of Denham, husbandman 2
5334311 2455332 2455332 defendant Penne John gent 586740 586740 Penne, John, of Denham, gent 0
5347094 2459250 2459250 plaintiff Barlowe John   586740 586740 Barlowe, John, of Denham 0
5354232 2461389 2461389 plaintiff Harleston William esq 586740 586740 Harleston, William, of Denham, esq 0
5354235 2461390 2461390 plaintiff Harleston William esq 586740 586740 Harleston, William, of Denham, esq 0
5361642 2463665 2463665 defendant Roger William yeoman 586740 586740 Roger, William, of Denham, yeoman 0
5361643 2463665 2463665 defendant Hughet John chaplain 586740 586740 Hughet, John, of Denham, chaplain 1
5382740 2470127 2470127 defendant Roger William husbandman 586740 586740 Roger, William, of Denham, husbandman 0
5391144 2472542 2472542 defendant Grene Richard laborer 586740 586740 Grene, Richard, of Denham, laborer 0
5395326 2473737 2473737 defendant Baldok Roger husbandman 586740 586740 Baldok, Roger, of Denham, husbandman 1
5406337 2476883 2476883 defendant Roger William husbandman 586740 586740 Roger, William, of Denham, husbandman 0
5408592 2477536 2477536 defendant Baldok Roger husbandman 586740 586740 Baldok, Roger, of Denham, husbandman 1
5419410 2480721 2480721 defendant Roger William husbandman 586740 586740 Roger, William, of Denham, husbandman 0
5421819 2481462 2481462 defendant Baldok Roger husbandman 586740 586740 Baldok, Roger, of Denham, husbandman 1
5421823 2481463 2481463 defendant Baldok Roger husbandman 586740 586740 Baldok, Roger, of Denham, husbandman 1
5421827 2481464 2481464 defendant Baldok Roger husbandman 586740 586740 Baldok, Roger, of Denham, husbandman 1
5446869 2488959 2488959 plaintiff Harleston William (legal representative) 586740 586740 Harleston, William, of Denham, esq, executrix of 0
5446874 2488960 2488960 plaintiff Harleston William (legal representative) 586740 586740 Harleston, William, of Denham, esq, executrix of 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);