names

92 rows where place_id = 609763

✎ 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
3680172 1919870 1919870 defendant Penyon William clerk 609763 609763 Penyon, William, of Hunden, clerk 0
3680175 1919871 1919871 defendant Penyon William clerk 609763 609763 Penyon, William, of Hunden, clerk 1
3687682 1922317 1922317 plaintiff Hutton Henry gent 609763 609763 Hutton, Henry, of Hunden, gent 1
3698570 1925771 1925771 defendant Ive William husbandman 609763 609763 Ive, William, of Hunden, husbandman 0
3702548 1927066 1927066 defendant Ive William husbandman 609763 609763 Ive, William, of Hunden, husbandman 0
3702549 1927066 1927066 defendant Smyth John husbandman 609763 609763 Smyth, John, of Hunden, husbandman 1
3714171 1930730 1930730 defendant Trowsdall John gent 609763 609763 Trowsdall, John, of Hunden, gent 0
3768475 1947790 1947790 defendant Stregett Thomas carpenter 609763 609763 Stregett, Thomas, of Hunden, carpenter 0
3768476 1947790 1947790 defendant Flower Clement husbandman 609763 609763 Flower, Clement, of Hunden, husbandman 1
3772580 1949117 1949117 defendant Cokeshall Thomas gent 609763 609763 Cokeshall, Thomas, of Hunden, gent 0
3836242 1969247 1969247 defendant Heyward Henry husbandman 609763 609763 Heyward, Henry, of Hunden, husbandman 3
3836243 1969247 1969247 defendant Rowland Thomas husbandman 609763 609763 Rowland, Thomas, of Hunden, husbandman 4
3863280 1977916 1977916 defendant Baron Edward husbandman 609763 609763 Baron, Edward, of Hunden, husbandman 1
3890696 1987154 1987154 defendant Boleyn Richard butcher 609763 609763 Boleyn, Richard, of Hunden, butcher 2
3893475 1988044 1988044 defendant Laste Henry yeoman 609763 609763 Laste, Henry, of Hunden, yeoman 1
3894034 1988222 1988222 defendant Clark Robert husbandman 609763 609763 Clark, Robert, of Hunden, husbandman 0
3894035 1988222 1988222 defendant Clark George husbandman 609763 609763 Clark, George, of Hunden, husbandman 1
3894036 1988222 1988222 defendant Clark John husbandman 609763 609763 Clark, John, of Hunden, husbandman 2
3894037 1988222 1988222 defendant Last Henry laborer 609763 609763 Last, Henry, of Hunden, laborer 3
3894039 1988223 1988223 defendant Clarke Robert husbandman 609763 609763 Clarke, Robert, of Hunden, husbandman 0
3894040 1988223 1988223 defendant Clarke George husbandman 609763 609763 Clarke, George, of Hunden, husbandman 1
3894041 1988223 1988223 defendant Clarke John husbandman 609763 609763 Clarke, John, of Hunden, husbandman 2
3988593 2020664 2020664 defendant Ball John butcher 609763 609763 Ball, John, of Hunden, butcher 3
3988798 2020741 2020741 defendant Ball John butcher 609763 609763 Ball, John, of Hunden, butcher 3
4005853 2026863 2026863 defendant Whitfelde Nicholas clerk 609763 609763 Whitfelde, Nicholas, of Hunden, clerk 1
4005854 2026863 2026863 defendant Rychardson Edward husbandman 609763 609763 Rychardson, Edward, of Hunden, husbandman 2
4005857 2026864 2026864 defendant Whytfelde Nicholas clerk 609763 609763 Whytfelde, Nicholas, of Hunden, clerk 1
4005858 2026864 2026864 defendant Richardson Edward husbandman 609763 609763 Richardson, Edward, of Hunden, husbandman 2
4010403 2028491 2028491 defendant Clarke alias Webbe Joan widow 609763 609763 Clarke alias Webbe, Joan, of Hunden, widow 0
4013563 2029587 2029587 plaintiff Rowning Thomas   609763 609763 Rowning, Thomas, of Hunden, wheelwright 0
4025707 2033846 2033846 defendant Clarke alias Webb Elizabeth widow 609763 609763 Clarke alias Webb, Elizabeth, of Hunden, widow 0
4025767 2033870 2033870 defendant Osteler Alexander smith 609763 609763 Osteler, Alexander, of Hunden, smith 0
4025768 2033870 2033870 defendant Whitefeld Nicholas clerk 609763 609763 Whitefeld, Nicholas, of Hunden, clerk 1
4051222 2042876 2042876 defendant Parker Christopher bricklayer 609763 609763 Parker, Christopher, of Hunden, bricklayer 0
4059241 2045700 2045700 defendant Whatfeld Nicholas clerk 609763 609763 Whatfeld, Nicholas, of Hunden, clerk 4
4064707 2047666 2047666 defendant Barnard Robert tailor 609763 609763 Barnard, Robert, of Hunden, tailor 0
4168156 2084349 2084349 defendant Cowell William yeoman 609763 609763 Cowell, William, of Hunden, yeoman 1
4169852 2084953 2084953 defendant Wakeringe Ralph tailor 609763 609763 Wakeringe, Ralph, of Hunden, tailor 0
4169853 2084953 2084953 defendant Stokes John tailor or carpenter 609763 609763 Stokes, John, of Hunden, tailor or carpenter 1
4169854 2084953 2084953 defendant Adames William tailor 609763 609763 Adames, William, of Hunden, tailor 2
4196320 2094255 2094255 defendant Mathewe John husbandman 609763 609763 Mathewe, John, of Hunden, husbandman 0
4196617 2094362 2094362 defendant Sryven Charles husbandman 609763 609763 Sryven, Charles, of Hunden, husbandman 0
4205820 2097584 2097584 defendant Woode Augustine miller 609763 609763 Woode, Augustine, of Hunden, miller 0
4238268 2108993 2108993 defendant Richeman Robert yeoman 609763 609763 Richeman, Robert, of Hunden, yeoman 2
4238588 2109110 2109110 defendant Cutmaye Richard husbandman 609763 609763 Cutmaye, Richard, of Hunden, husbandman 1
4248078 2112343 2112343 defendant Cutinge alias Cutiner Richard husbandman 609763 609763 Cutinge alias Cutiner, Richard, of Hunden, husbandman 1
4248079 2112343 2112343 defendant Harpar John   609763 609763 Harpar, John, of Hunden, wheelwright 2
4255671 2114870 2114870 defendant Bentlye William carpenter 609763 609763 Bentlye, William, of Hunden, carpenter 1
4261496 2116807 2116807 defendant Coote William, senior husbandman 609763 609763 Coote, William, senior, of Hunden, husbandman 0
4261497 2116807 2116807 defendant Coote William, junior husbandman 609763 609763 Coote, William, junior, of Hunden, husbandman 1
4261498 2116807 2116807 defendant Pont John husbandman 609763 609763 Pont, John, of Hunden, husbandman 2
4296616 2128890 2128890 defendant Taylor Henry husbandman 609763 609763 Taylor, Henry, of Hunden, husbandman 0
4307346 2132707 2132707 defendant Koote William   609763 609763 Koote, William, of Hunden, or of Dedham, woollen draper 0
4309192 2133370 2133370 defendant Digby Richard   609763 609763 Digby, Richard, of Hunden, "clover" 0
4332228 2141073 2141073 defendant Koote William   609763 609763 Koote, William, of Hunden, or of Dedham, woollen weaver 0
4392702 2162178 2162178 defendant Fletcher Thomas maltster 609763 609763 Fletcher, Thomas, of Hunden, or of Chippenham, Cams, maltster 0
4410852 2168218 2168218 defendant Sparrowe Robert husbandman 609763 609763 Sparrowe, Robert, of Hunden, husbandman 0
4410854 2168219 2168219 defendant Sparrowe Robert husbandman 609763 609763 Sparrowe, Robert, of Hunden, husbandman 0
4520095 2206616 2206616 defendant Last Thomas   609763 609763 Last, Thomas, of Hunden, wool man 0
4529578 2209533 2209533 plaintiff Morymer John (legal representative) 609763 609763 Morymer, John, of Hunden, executor of 0
4586007 2227046 2227046 defendant Parker John   609763 609763 Parker, John, of Hunden 4
4835478 2307092 2307092 defendant Elsyng Robert   609763 609763 Elsyng, Robert, of Hunden, wheel wright 0
4894292 2324898 2324898 defendant Coggeshale John husbandman 609763 609763 Coggeshale, John, of Hunden, husbandman 5
4936013 2337664 2337664 defendant Goderham William laborer 609763 609763 Goderham, William, of Hunden, laborer 2
4936015 2337664 2337664 defendant Goderham Simon laborer 609763 609763 Goderham, Simon, of Hunden, laborer 4
4950534 2342127 2342127 defendant Topclyf John butcher 609763 609763 Topclyf, John, of Hunden, butcher 0
5028198 2365118 2365118 defendant Swayn John husbandman 609763 609763 Swayn, John, of Hunden, husbandman 0
5163357 2405018 2405018 defendant Tayllour John yeoman 609763 609763 Tayllour, John, of Hunden, yeoman 0
5163358 2405018 2405018 defendant Tayllour Thomas tailor 609763 609763 Tayllour, Thomas, of Hunden, tailor 1
5163362 2405019 2405019 defendant Tayllour John yeoman 609763 609763 Tayllour, John, of Hunden, yeoman 0
5163363 2405019 2405019 defendant Tayllour Thomas tailor 609763 609763 Tayllour, Thomas, of Hunden, tailor 1
5177031 2408977 2408977 defendant Tayllour John yeoman 609763 609763 Tayllour, John, of Hunden, yeoman 0
5199806 2415690 2415690 defendant Tayllour John yeoman 609763 609763 Tayllour, John, of Hunden, yeoman 0
5271226 2436676 2436676 defendant Norman John laborer 609763 609763 Norman, John, of Hunden, laborer 5
5378391 2468822 2468822 defendant Coggeshall William gent 609763 609763 Coggeshall, William, of Hunden, gent 0
5378393 2468822 2468822 defendant Clerk William husbandman 609763 609763 Clerk, William, of Hunden, husbandman 2
5402948 2475923 2475923 defendant Waterle William, junior tanner 609763 609763 Waterle, William, junior, of Hunden, tanner 0
5407039 2477073 2477073 defendant Clerk William husbandman 609763 609763 Clerk, William, of Hunden, husbandman 1
5490190 2501950 2501950 defendant Pye Richard yeoman 609763 609763 Pye, Richard, of Hunden, yeoman 4
5501625 2505440 2505440 defendant Davy Thomas smith 609763 609763 Davy, Thomas, of Hunden, smith 4
5512244 2508693 2508693 defendant Waterley William barker 609763 609763 Waterley, William, of Hunden, barker 1
5512245 2508693 2508693 defendant Venour John butcher 609763 609763 Venour, John, of Hunden, butcher 2
5512246 2508693 2508693 defendant Cleter John husbandman 609763 609763 Cleter, John, of Hunden, husbandman 3
5536294 2515841 2515841 defendant Pokeryk John   609763 609763 Pokeryk, John, of Hunden, wheelwright 3
5549743 2519957 2519957 defendant Topley John yeoman 609763 609763 Topley, John, of Hunden, yeoman 0
5549744 2519957 2519957 defendant Watyrley Thomas tanner 609763 609763 Watyrley, Thomas, of Hunden, tanner 1
5549745 2519957 2519957 defendant Wysbych John husbandman 609763 609763 Wysbych, John, of Hunden, husbandman 2
5594221 2533170 2533170 defendant Tebold William husbandman 609763 609763 Tebold, William, of Hunden, husbandman 0
5596056 2533680 2533680 defendant Webbe William laborer 609763 609763 Webbe, William, of Hunden, laborer 2
5601366 2535319 2535319 defendant Smyth John, junior smith 609763 609763 Smyth, John, junior, of Hunden, smith 3
5617378 2549255 2549255 defendant Stoor William chaplain 609763 609763 Stoor, William, of Hunden, chaplain 0
5626823 2552360 2552360 defendant Cassy John husbandman 609763 609763 Cassy, John, of Hunden, husbandman 2

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