names

140 rows where place_id = 606657

✎ 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
3666062 1915325 1915325 plaintiff Staycock John dyer 606657 606657 Staycock, John, of Bynham, dyer 1
3707751 1928721 1928721 defendant Aleyn Thomas husbandman 606657 606657 Aleyn, Thomas, of Bynham, husbandman 0
3750118 1941951 1941951 defendant Slaycok John husbandman 606657 606657 Slaycok, John, of Bynham, husbandman 0
3758996 1944801 1944801 defendant Cokke John dyer 606657 606657 Cokke, John, of Bynham, dyer 3
3784220 1952852 1952852 defendant Chapman Reginald husbandman 606657 606657 Chapman, Reginald, of Bynham, husbandman 0
3800740 1958144 1958144 defendant Chapman Reginald husbandman 606657 606657 Chapman, Reginald, of Bynham, husbandman 0
3800742 1958145 1958145 defendant Chapman Reginald husbandman 606657 606657 Chapman, Reginald, of Bynham, husbandman 0
3815129 1962651 1962651 defendant Sego William yeoman 606657 606657 Sego, William, of Bynham, yeoman 1
3831349 1967692 1967692 defendant Shae William yeoman 606657 606657 Shae, William, of Bynham, yeoman 4
3890591 1987117 1987117 defendant Dewe Thomas thatcher 606657 606657 Dewe, Thomas, of Bynham, thatcher 0
3890594 1987118 1987118 defendant Lamberd William yeoman 606657 606657 Lamberd, William, of Bynham, yeoman 0
4001981 2025488 2025488 defendant Forrest John glover 606657 606657 Forrest, John, of Bynham, glover 0
4032162 2036172 2036172 defendant Hagon Peter grocer 606657 606657 Hagon, Peter, of Bynham, grocer 0
4032164 2036173 2036173 defendant Hagon Peter glover 606657 606657 Hagon, Peter, of Bynham, glover 0
4059258 2045704 2045704 defendant Walker Richard yeoman 606657 606657 Walker, Richard, of Bynham, yeoman 0
4064410 2047550 2047550 defendant Forrest John yeoman 606657 606657 Forrest, John, of Bynham, yeoman 1
4067020 2048502 2048502 defendant Cobbe John yeoman 606657 606657 Cobbe, John, of Bynham, yeoman 1
4071098 2049966 2049966 defendant Bynkes Nicholas husbandman 606657 606657 Bynkes, Nicholas, of Bynham, husbandman 0
4079532 2052977 2052977 defendant Forrest John glover 606657 606657 Forrest, John, of Bynham, glover 0
4201643 2096118 2096118 defendant Alderson Cuthbert yeoman 606657 606657 Alderson, Cuthbert, of Bynham, yeoman 1
4203191 2096665 2096665 defendant Meanes Thomas laborer 606657 606657 Meanes, Thomas, of Bynham, laborer 0
4203368 2096726 2096726 defendant Pygyon or Pygeon Thomas gent 606657 606657 Pygyon or Pygeon, Thomas, of Bynham, gent 0
4222141 2103235 2103235 defendant Lambart John gent 606657 606657 Lambart, John, of Bynham, gent 1
4226471 2104730 2104730 defendant Hagon Peter yeoman 606657 606657 Hagon, Peter, of Bynham, yeoman 0
4226472 2104730 2104730 defendant Hagon John   606657 606657 Hagon, John, of Bynham, yeoman, his son 1
4226806 2104850 2104850 defendant Hargyn John yeoman 606657 606657 Hargyn, John, of Bynham, yeoman 3
4242243 2110400 2110400 defendant Bynck Thomas husbandman 606657 606657 Bynck, Thomas, of Bynham, husbandman 0
4242244 2110400 2110400 defendant Bynck Robert merchant 606657 606657 Bynck, Robert, of Bynham, merchant 1
4242246 2110401 2110401 defendant Bynck Thomas husbandman 606657 606657 Bynck, Thomas, of Bynham, husbandman 0
4242247 2110401 2110401 defendant Bynck Robert merchant 606657 606657 Bynck, Robert, of Bynham, merchant 1
4261477 2116802 2116802 defendant Cartrope Robert cordwainer 606657 606657 Cartrope Robert, of Bynham, cordwainer 3
4275377 2121324 2121324 defendant Lamberte Clement gent 606657 606657 Lamberte, Clement, of Bynham, gent 0
4288340 2125879 2125879 defendant Jarie William husbandman 606657 606657 Jarie, William, of Bynham, husbandman 0
4288341 2125879 2125879 defendant Lee John husbandman 606657 606657 Lee, John, of Bynham, husbandman 1
4288342 2125879 2125879 defendant Sanderson William husbandman 606657 606657 Sanderson, William, of Bynham, husbandman 2
4288343 2125879 2125879 defendant Money William, junior husbandman 606657 606657 Money, William, junior, of Bynham, husbandman 3
4288351 2125883 2125883 defendant Heare Robert   606657 606657 Heare, Robert, of Bynham, shepherd 0
4288883 2126078 2126078 defendant Bynk Robert yeoman 606657 606657 Bynk, Robert, of Bynham, yeoman 1
4290409 2126627 2126627 defendant Lambarte Clement gent 606657 606657 Lambarte, Clement, of Bynham, gent 0
4295237 2128382 2128382 defendant Bynck Robert yeoman 606657 606657 Bynck, Robert, of Bynham, yeoman 0
4311404 2134130 2134130 defendant Lamberte Clement gent 606657 606657 Lamberte, Clement, of Bynham, gent 0
4314735 2135267 2135267 defendant Colles Humphrey yeoman 606657 606657 Colles, Humphrey, of Bynham, yeoman 0
4315123 2135402 2135402 defendant Beccles Richard husbandman 606657 606657 Beccles, Richard, of Bynham, husbandman 3
4330806 2140601 2140601 defendant Ixforth Christopher tailor 606657 606657 Ixforth, Christopher, of Bynham, tailor 1
4336282 2142423 2142423 defendant Lambert Clement gent 606657 606657 Lambert, Clement, of Bynham, gent 0
4337946 2143017 2143017 defendant Bordger Isaac yeoman 606657 606657 Bordger, Isaac, of Bynham, yeoman 3
4341930 2144457 2144457 defendant Newman Edmund husbandman 606657 606657 Newman, Edmund, of Bynham, husbandman 0
4341931 2144457 2144457 defendant Beckles Richard husbandman 606657 606657 Beckles, Richard, of Bynham, husbandman 1
4341932 2144457 2144457 defendant Bynk Nicholas husbandman 606657 606657 Bynk, Nicholas, of Bynham, husbandman 2
4344351 2145304 2145304 defendant Leake Peter husbandman 606657 606657 Leake, Peter, of Bynham, husbandman 0
4344352 2145304 2145304 defendant Upgate Anne widow 606657 606657 Upgate, Anne, of Bynham, widow 1
4345381 2145658 2145658 defendant Lambard Rose spinster 606657 606657 Lambard, Rose, of Bynham, spinster 3
4359576 2150585 2150585 defendant Lambert Clement gent 606657 606657 Lambert, Clement, of Bynham, gent 0
4370944 2154665 2154665 defendant Monye William, junior yeoman 606657 606657 Monye, William, junior, of Bynham, yeoman 0
4370945 2154665 2154665 defendant Jarye William husbandman 606657 606657 Jarye, William, of Bynham, husbandman 1
4370946 2154665 2154665 defendant Lee John yeoman 606657 606657 Lee, John, of Bynham, yeoman 2
4389244 2161030 2161030 defendant Batty Edward husbandman 606657 606657 Batty, Edward, of Bynham, husbandman 3
4389737 2161191 2161191 defendant Batye Edward husbandman 606657 606657 Batye, Edward, of Bynham, husbandman 3
4392633 2162156 2162156 defendant Newman Edmund husbandman 606657 606657 Newman, Edmund, of Bynham, husbandman 0
4392634 2162156 2162156 defendant Beckles Richard husbandman 606657 606657 Beckles, Richard, of Bynham, husbandman 1
4393336 2162374 2162374 defendant Manne John yeoman 606657 606657 Manne, John, of Bynham, yeoman 0
4393338 2162374 2162374 defendant Baker John yeoman 606657 606657 Baker, John, of Bynham, yeoman 2
4397784 2163835 2163835 defendant Ixforth Thomas tailor 606657 606657 Ixforth, Thomas, of Bynham, tailor 0
4397785 2163835 2163835 defendant Alderson Cuthbert glover 606657 606657 Alderson, Cuthbert, of Bynham, glover 1
4398739 2164158 2164158 defendant Monye William husbandman 606657 606657 Monye, William, of Bynham, husbandman 0
4398740 2164158 2164158 defendant Lee John yeoman 606657 606657 Lee, John, of Bynham, yeoman 1
4398742 2164159 2164159 defendant Mann John yeoman 606657 606657 Mann, John, of Bynham, yeoman 0
4398743 2164159 2164159 defendant Jeksser Christopher yeoman 606657 606657 Jeksser, Christopher, of Bynham, yeoman 1
4467785 2190602 2190602 defendant Skynner John   606657 606657 Skynner, John, of Bynham 0
4467786 2190602 2190602 defendant Heyne Simon   606657 606657 Heyne, Simon, of Bynham 1
4471045 2191601 2191601 defendant Bale Adam   606657 606657 Bale, Adam, of Bynham 0
4494983 2199119 2199119 defendant Brondyour Nicholas   606657 606657 Brondyour, Nicholas, of Bynham 1
4495375 2199234 2199234 plaintiff Calwere Thomas   606657 606657 Calwere, Thomas, of Bynham, vicar 0
4523741 2207753 2207753 defendant Bale Adam   606657 606657 Bale, Adam, of Bynham 0
4523742 2207753 2207753 defendant Bale Thomas   606657 606657 Bale, Thomas, of Bynham, son of Adam 1
4534604 2211092 2211092 defendant Bale Adam   606657 606657 Bale, Adam, of Bynham, wool man 0
4565764 2220847 2220847 defendant Bale John   606657 606657 Bale, John, of Bynham 2
4610904 2234484 2234484 defendant Sony Thomas   606657 606657 Sony, Thomas, of Bynham 0
4624374 2238602 2238602 defendant Bale Thomas   606657 606657 Bale, Thomas, of Bynham 0
4634883 2241760 2241760 defendant Smyth Geoffrey   606657 606657 Smyth, Geoffrey, of Bynham 1
4641560 2243630 2243630 defendant Webstere William   606657 606657 Webstere, William, of Bynham 0
4645468 2244743 2244743 defendant Bale Thomas   606657 606657 Bale, Thomas, of Bynham 0
4655001 2247446 2247446 defendant Mateshale John mercer 606657 606657 Mateshale, John, of Bynham, mercer 4
4655008 2247447 2247447 defendant Mateshale John mercer 606657 606657 Mateshale, John, of Bynham, mercer 4
4663160 2249944 2249944 defendant Bocher Andrew butcher 606657 606657 Bocher, Andrew, of Bynham, butcher 1
4704561 2266802 2266802 defendant Miller Thomas miller 606657 606657 Miller, Thomas, of Bynham, miller 2
4737838 2276938 2276938 plaintiff (not given) John vicar of Syger 606657 606657 Syger, John, of Bynham, vicar of St Mary's church 2
4789717 2292853 2292853 defendant Ryngstede William husbandman 606657 606657 Ryngstede, William, of Bynham, husbandman 0
4816696 2301318 2301318 defendant Gentyle John yeoman 606657 606657 Gentyle, John, of Bynham, yeoman 0
4816698 2301319 2301319 defendant Gentyle John yeoman 606657 606657 Gentyle, John, of Bynham, yeoman 0
4843596 2309519 2309519 plaintiff Mateshal John (legal representative) 606657 606657 Mateshal, John, of Bynham, executors of 0
4843597 2309519 2309519 plaintiff Wutton Thomas   606657 606657 (Wutton, Thomas, of Bynham 1
4843598 2309519 2309519 plaintiff Chapman John   606657 606657 Chapman, John, of Bynham 2
4910165 2329703 2329703 defendant Pays John husbandman 606657 606657 Pays, John, of Bynham, husbandman 0
4937736 2338181 2338181 defendant Pays John yeoman 606657 606657 Pays, John, of Bynham, yeoman 0
4968216 2347445 2347445 defendant Cokhill William miller 606657 606657 Cokhill, William, of Bynham, miller 2
4975311 2349572 2349572 defendant Baxster John baker 606657 606657 Baxster, John, of Bynham, baker 0
4978566 2350540 2350540 defendant Pays John chapman 606657 606657 Pays, John, of Bynham, chapman 2
4984803 2352386 2352386 defendant Baxter John husbandman 606657 606657 Baxter, John, of Bynham, husbandman 2
5016102 2361588 2361588 defendant Pays John husbandman 606657 606657 Pays, John, of Bynham, husbandman 1

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