names

155 rows where place_id = 597185

✎ 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
3627582 1903485 1903485 defendant Westwode Geoffrey yeoman 597185 597185 Westwode, Geoffrey, of Freston, yeoman 0
3635812 1906001 1906001 defendant Jakson John laborer 597185 597185 Jakson, John, of Freston, laborer 0
3646772 1909398 1909398 defendant Whetam John husbandman 597185 597185 Whetam, John, of Freston, husbandman 0
3661558 1913889 1913889 defendant Carter John husbandman 597185 597185 Carter, John, of Freston, husbandman 0
3665883 1915265 1915265 defendant Baker John husbandman 597185 597185 Baker, John, of Freston, husbandman 0
3665884 1915265 1915265 defendant Hobson Richard husbandman 597185 597185 Hobson, Richard, of Freston, husbandman 1
3692507 1923840 1923840 defendant Pynchebek John husbandman 597185 597185 Pynchebek, John, of Freston, husbandman 0
3695059 1924665 1924665 defendant Westwood Katherine widow 597185 597185 Westwood, Katherine, of Freston, widow 0
3695060 1924665 1924665 defendant Neth John husbandman 597185 597185 Neth, John, of Freston, husbandman 1
3708707 1929023 1929023 defendant Pedder Richard, senior fisher 597185 597185 Pedder, Richard, senior, of Freston, fisher 0
3708708 1929023 1929023 defendant Pedder Richard, junior fisher 597185 597185 Pedder, Richard, junior, of Freston, fisher 1
3708709 1929023 1929023 defendant Pedder John fisher 597185 597185 Pedder, John, of Freston, fisher 2
3708710 1929023 1929023 defendant Morefote John fisher 597185 597185 Morefote, John, of Freston, fisher 3
3708711 1929023 1929023 defendant Pakharnes William, senior fisher 597185 597185 Pakharnes, William, senior, of Freston, fisher 4
3708712 1929023 1929023 defendant Pakharnes William, junior fisher 597185 597185 Pakharnes, William, junior, of Freston, fisher 5
3708713 1929023 1929023 defendant Rudde Hugh fisher 597185 597185 Rudde, Hugh, of Freston, fisher 6
3708714 1929023 1929023 defendant Ben John fisher 597185 597185 Ben, John, of Freston, fisher 7
3739451 1938547 1938547 defendant Forman Henry husbandman 597185 597185 Forman, Henry, of Freston, husbandman 1
3739452 1938547 1938547 defendant Woderoff William husbandman 597185 597185 Woderoff, William, of Freston, husbandman 2
3805567 1959682 1959682 defendant Wade John husbandman 597185 597185 Wade, John, of Freston, husbandman 0
3813439 1962120 1962120 defendant Woodruff William husbandman 597185 597185 Woodruff, William, of Freston, husbandman 0
3817772 1963464 1963464 defendant Smyth John husbanmdman 597185 597185 Smyth, John, of Freston, husbanmdman 0
3840679 1970648 1970648 defendant Pynchebek Edmund husbandman 597185 597185 Pynchebek, Edmund, of Freston, husbandman 0
3878446 1983037 1983037 defendant Forman Thomas   597185 597185 Forman, Thomas, of Freston, cartwright 0
3958242 2009955 2009955 defendant Gunnell or Emmell Edmund husbandman 597185 597185 Gunnell or Emmell, Edmund, of Freston, husbandman 2
3971219 2014491 2014491 plaintiff Dynnyngton John husbandman 597185 597185 Dynnyngton, John, of Freston, husbandman 0
3971221 2014492 2014492 plaintiff Dynnyngton John husbandman 597185 597185 Dynnyngton, John, of Freston, husbandman 0
4033151 2036505 2036505 plaintiff Goodyng Thomas gent 597185 597185 Goodyng, Thomas, of Freston, gent 0
4082821 2054158 2054158 defendant Stampford William gent 597185 597185 Stampford, William, of Freston, gent 0
4127395 2070088 2070088 defendant Warner William gent 597185 597185 Warner, William, of Freston, gent 0
4135050 2072860 2072860 defendant Watkyns Henry clerk 597185 597185 Watkyns, Henry, of Freston, clerk 0
4135051 2072860 2072860 defendant Fennynge Robert yeoman 597185 597185 Fennynge, Robert, of Freston, yeoman 1
4187495 2091124 2091124 defendant Punder Thomas laborer 597185 597185 Punder, Thomas, of Freston, laborer 1
4206131 2097693 2097693 defendant Maye Robert   597185 597185 Maye, Robert, of Freston, twill weaver 0
4206132 2097693 2097693 defendant Bumpsted Roger husbandman 597185 597185 Bumpsted, Roger, of Freston, husbandman 1
4233374 2107186 2107186 defendant Campell Thomas yeoman 597185 597185 Campell, Thomas, of Freston, yeoman 0
4241986 2110311 2110311 defendant Campell Thomas yeoman 597185 597185 Campell, Thomas, of Freston, yeoman 0
4274369 2120980 2120980 defendant Fletcher Robert yeoman 597185 597185 Fletcher, Robert, of Freston, yeoman 0
4288067 2125780 2125780 defendant Bordall John laborer 597185 597185 Bordall, John, of Freston, laborer 0
4347274 2146305 2146305 defendant Laurence William yeoman 597185 597185 Laurence, William, of Freston, yeoman 0
4415019 2169595 2169595 defendant Stykeneye John de   597185 597185 Stykeneye, John de, of Freston, son of Brice 0
4436186 2176058 2176058 defendant Fipport Robert   597185 597185 Fipport, Robert, of Freston 0
4453452 2186086 2186086 defendant Phipport Robert   597185 597185 Phipport, Robert, of Freston 0
4453758 2186186 2186186 defendant Chambyrleyn Robert   597185 597185 together with Chambyrleyn, Robert, of Freston 10
4453761 2186187 2186187 defendant Bokele William   597185 597185 Bokele, William, of Freston 1
4453768 2186187 2186187 defendant Drenge Stephen   597185 597185 Drenge, Stephen, of Freston 8
4487285 2196740 2196740 defendant Pisshe John   597185 597185 Pisshe, John, of Freston 0
4492097 2198219 2198219 defendant Beauchampe John   597185 597185 Beauchampe, John, of Freston 2
4492099 2198219 2198219 defendant Kent John de butcher 597185 597185 Kent, John de, of Freston, butcher 4
4492107 2198219 2198219 defendant Worme John, junior   597185 597185 Worme, John, junior, of Freston 12
4507096 2202688 2202688 defendant Bardenay John   597185 597185 Bardenay, John, of Freston 0
4526113 2208460 2208460 defendant Swyft William   597185 597185 Swyft, William, of Freston 1
4533266 2210663 2210663 defendant Swyft William   597185 597185 Swyft, William, of Freston 0
4541658 2213287 2213287 plaintiff Wyghtfote Thomas   597185 597185 Wyghtfote, Thomas, of Freston 0
4557986 2218431 2218431 defendant Wheteholme William   597185 597185 Wheteholme, William, of Freston 0
4562880 2219954 2219954 plaintiff Pygot Robert   597185 597185 Pygot, Robert, of Freston 0
4563435 2220136 2220136 defendant Beek John   597185 597185 Beek, John, of Freston 0
4569310 2221989 2221989 defendant Blayke John   597185 597185 Blayke, John, of Freston 10
4570097 2222221 2222221 defendant Swyft William   597185 597185 Swyft, William, of Freston 2
4595378 2229808 2229808 defendant Man Richard skinner 597185 597185 Man, Richard, of Freston, skinner 0
4607819 2233560 2233560 defendant Farceux Ralph   597185 597185 Farceux, Ralph, of Freston 0
4612985 2235119 2235119 defendant Caudron John   597185 597185 Caudron, John, of Freston 1
4632653 2241097 2241097 defendant Baxstere John   597185 597185 Baxstere, John, of Freston 0
4646870 2245147 2245147 defendant Fretour John   597185 597185 Fretour, John, of Freston 2
4646874 2245147 2245147 defendant Fretour William   597185 597185 Fretour, William, of Freston 6
4673911 2257458 2257458 defendant Wryght John chaplain 597185 597185 Wryght, John, of Freston, chaplain 1
4686331 2261331 2261331 defendant Skot John ploghman 597185 597185 Skot, John, of Freston, ploghman 0
4689544 2262287 2262287 plaintiff Wace William   597185 597185 Wace, William, of Freston 0
4704586 2266812 2266812 defendant Farseux John   597185 597185 Farseux, John, of Freston 0
4735684 2276307 2276307 defendant Wace William husbandman 597185 597185 Wace, William, of Freston, husbandman 1
4738048 2277000 2277000 defendant Wace William gent 597185 597185 Wace, William, of Freston, gent 4
4780049 2289764 2289764 defendant Boteman Thomas fuller 597185 597185 Boteman, Thomas, of Freston, fuller 1
4801545 2296665 2296665 defendant Midelton John husbandman 597185 597185 Midelton, John, of Freston, husbandman 0
4801546 2296665 2296665 defendant Davy William husbandman 597185 597185 Davy, William, of Freston, husbandman 1
4801547 2296665 2296665 defendant Bonde William husbandman 597185 597185 Bonde, William, of Freston, husbandman 2
4813257 2300261 2300261 defendant Cartwryght Alan   597185 597185 Cartwryght, Alan, of Freston, cartwright 0
4821270 2302732 2302732 defendant Gye William   597185 597185 Gye, William, of Freston, husbandman, son of Alan Gye 0
4824345 2303676 2303676 defendant Dokkynge Thomas carpenter 597185 597185 Dokkynge, Thomas, of Freston, carpenter 2
4857688 2313784 2313784 defendant Blayke William husbandman 597185 597185 Blayke, William, of Freston, husbandman 0
4857689 2313784 2313784 defendant Herde John, junior husbandman 597185 597185 Herde, John, junior, of Freston, husbandman 1
4859215 2314258 2314258 defendant Gibonson Richard husbandman 597185 597185 Gibonson, Richard, of Freston, husbandman 0
4861166 2314852 2314852 defendant Herde John husbandman 597185 597185 Herde, John, of Freston, husbandman 1
4873101 2318540 2318540 defendant Pety Thomas husbandman 597185 597185 Pety, Thomas, of Freston, husbandman 5
4874387 2318931 2318931 defendant Blayke William husbandman 597185 597185 Blayke, William, of Freston, husbandman 0
4897474 2325871 2325871 defendant Grene John husbandman 597185 597185 Grene, John, of Freston, husbandman 4
4899035 2326339 2326339 defendant Grene John husbandman 597185 597185 Grene, John, of Freston, husbandman 3
4905626 2328362 2328362 defendant North John husbandman 597185 597185 North, John, of Freston, husbandman 1
4917497 2331986 2331986 defendant Gye Alexander husbandman 597185 597185 Gye, Alexander, of Freston, husbandman 1
4920071 2332788 2332788 defendant Taillour Peter husbandman 597185 597185 Taillour, Peter, of Freston, husbandman 1
4926699 2334769 2334769 defendant Swyft Ralph yeoman 597185 597185 Swyft, Ralph, of Freston, yeoman 0
4931552 2336252 2336252 defendant Baulle John husbandman 597185 597185 Baulle, John, of Freston, husbandman 0
4933246 2336789 2336789 defendant Wangeford Robert yeoman 597185 597185 Wangeford, Robert, of Freston, yeoman 1
4957494 2344211 2344211 defendant Horn John (legal representative) 597185 597185 Horn, John, of Freston, executors of 0
4957495 2344211 2344211 defendant Hierde John husbandman 597185 597185 (Hierde, John, of Freston, husbandman 1
4967336 2347174 2347174 defendant Herde John husbandman 597185 597185 Herde, John, of Freston, husbandman 4
4972688 2348766 2348766 defendant Fox Robert husbandman 597185 597185 Fox, Robert, of Freston, husbandman 0
4982624 2351716 2351716 defendant Boothby Ralph husbandman 597185 597185 Boothby, Ralph, of Freston, husbandman 1
4983791 2352079 2352079 defendant Gerde John husbandman 597185 597185 Gerde, John, of Freston, husbandman 0
4983858 2352097 2352097 defendant Swyfte Ralph husbandman 597185 597185 Swyfte, Ralph, of Freston, husbandman 0
4988885 2353628 2353628 defendant Herde John husbandman 597185 597185 Herde, John, of Freston, husbandman 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);