names

87 rows where place_id = 598732

✎ 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
3633853 1905398 1905398 defendant Dey Richard husbandman 598732 598732 Dey, Richard, of Lemyngton, husbandman 0
3649758 1910287 1910287 defendant Gee Richard husbandman 598732 598732 Gee, Richard, of Lemyngton, husbandman 0
3649759 1910287 1910287 defendant Gee John husbandman 598732 598732 Gee, John, of Lemyngton, husbandman 1
3661835 1913986 1913986 plaintiff Longworth Nicholas chaplain 598732 598732 Longworth, Nicholas, of Lemyngton, chaplain 0
3661837 1913987 1913987 plaintiff Longworth Nicholas chaplain & curator of Peter church 598732 598732 Longworth, Nicholas, of Lemyngton, chaplain & curator of Peter church 0
3661838 1913987 1913987 defendant Dey Richard yeoman 598732 598732 Dey, Richard, of Lemyngton, yeoman 0
3726808 1934652 1934652 defendant Fuller Mathew yeoman 598732 598732 Fuller, Mathew, of Lemyngton, yeoman 0
3799064 1957616 1957616 defendant Palmer John gent 598732 598732 Palmer, John, of Lemyngton, gent 0
3799066 1957617 1957617 defendant Palmer John gent 598732 598732 Palmer, John, of Lemyngton, gent 0
3822528 1964947 1964947 defendant Peny John   598732 598732 Peny, John, of Lemyngton, mason 0
3828662 1966843 1966843 defendant Dey Richard husbandman 598732 598732 Dey, Richard, of Lemyngton, husbandman 0
3828663 1966843 1966843 defendant Dey John husbandman 598732 598732 Dey, John, of Lemyngton, husbandman 1
3828665 1966843 1966843 defendant Gybbes Robert husbandman 598732 598732 Gybbes, Robert, of Lemyngton, husbandman 3
3850465 1973733 1973733 defendant Gee William husbandman 598732 598732 Gee, William, of Lemyngton, husbandman 1
3910324 1993771 1993771 defendant Palmer John esq 598732 598732 Palmer, John, of Lemyngton, esq 0
3924691 1998572 1998572 defendant Palmer William esq 598732 598732 Palmer, William, of Lemyngton, esq 0
3983353 2018819 2018819 defendant Dowe Bartholomew gent 598732 598732 Dowe, Bartholomew, of Lemyngton, gent 0
4026285 2034046 2034046 defendant Blysse John husbandman 598732 598732 Blysse, John, of Lemyngton, husbandman 0
4083318 2054318 2054318 defendant Olney Michael yeoman 598732 598732 Olney, Michael, of Lemyngton, yeoman 0
4127231 2070031 2070031 defendant Pryde John tailor 598732 598732 Pryde, John, of Lemyngton, tailor 3
4468502 2190815 2190815 plaintiff Baynyng Richard   598732 598732 Baynyng, Richard, of Lemyngton 0
4475707 2193080 2193080 defendant Craft John   598732 598732 Craft, John, of Lemyngton 1
4477434 2193605 2193605 defendant Mascall Nicholas   598732 598732 Mascall, Nicholas, of Lemyngton 1
4485701 2196233 2196233 defendant Salman Wiliam   598732 598732 Salman, Wiliam, of Lemyngton 5
4485709 2196234 2196234 defendant Salman Wiliam   598732 598732 Salman, Wiliam, of Lemyngton 5
4509926 2203590 2203590 plaintiff Baker John   598732 598732 Baker, John, of Lemyngton 0
4509929 2203591 2203591 plaintiff Baker John   598732 598732 Baker, John, of Lemyngton 0
4512719 2204411 2204411 defendant Baker Stephen   598732 598732 Baker, Stephen, of Lemyngton 0
4532799 2210530 2210530 defendant Swayn John   598732 598732 Swayn, John, of Lemyngton 0
4532806 2210533 2210533 defendant Swayn John   598732 598732 Swayn, John, of Lemyngton 0
4540048 2212795 2212795 defendant Bakere Stephen   598732 598732 Bakere, Stephen, of Lemyngton 2
4541255 2213161 2213161 defendant Baker Stephen   598732 598732 Baker, Stephen, of Lemyngton 2
4541256 2213161 2213161 defendant Baker John   598732 598732 Baker, John, of Lemyngton 3
4551223 2216323 2216323 defendant Dengard Richard   598732 598732 Dengard, Richard, of Lemyngton 3
4553716 2217084 2217084 defendant Grene John   598732 598732 Grene, John, of Lemyngton 0
4554396 2217304 2217304 defendant Shepperd John   598732 598732 Shepperd, John, of Lemyngton 0
4555997 2217817 2217817 defendant York John   598732 598732 York, John, of Lemyngton 0
4557547 2218296 2218296 defendant Badecok Thomas dyer 598732 598732 Badecok, Thomas, of Lemyngton, dyer 0
4565024 2220631 2220631 defendant Grene John   598732 598732 Grene, John, of Lemyngton 0
4565405 2220750 2220750 plaintiff Smyth John   598732 598732 Smyth, John, of Lemyngton 0
4567318 2221335 2221335 defendant Rachebrook Stephen tanner 598732 598732 Rachebrook, Stephen, of Lemyngton, tanner 0
4579123 2224953 2224953 defendant Colyer William tailor 598732 598732 Colyer, William, of Lemyngton, tailor 0
4598679 2230824 2230824 defendant Kandener William   598732 598732 Kandener, William, of Lemyngton 0
4600090 2231255 2231255 defendant Baker John   598732 598732 Baker, John, of Lemyngton 0
4601223 2231615 2231615 defendant Baker John   598732 598732 Baker, John, of Lemyngton 0
4638993 2242923 2242923 defendant Podder Robert   598732 598732 Podder, Robert, of Lemyngton 0
4640720 2243390 2243390 defendant Bakere John   598732 598732 Bakere, John, of Lemyngton 5
4662713 2249795 2249795 defendant Baker John   598732 598732 Baker, John, of Lemyngton 0
4674780 2257726 2257726 defendant Bakere John ostler 598732 598732 Bakere, John, of Lemyngton, ostler 0
4685548 2261074 2261074 defendant Ayssheman William   598732 598732 Ayssheman, William, of Lemyngton, burgess 0
4691155 2262754 2262754 defendant Ryver Thomas husbandman 598732 598732 Ryver, Thomas, of Lemyngton, husbandman 1
4703260 2266398 2266398 plaintiff Helewyse John   598732 598732 Helewyse, John, of Lemyngton 0
4711481 2268920 2268920 defendant Ayssheman William   598732 598732 together with Ayssheman, William, of Lemyngton, burgess 3
4711486 2268921 2268921 defendant Ayssheman William   598732 598732 Ayssheman, William, of Lemyngton, burgess 0
4723834 2272757 2272757 defendant Burleg Agnes   598732 598732 Burleg, Agnes, of Lemyngton, widow, formerly wife of Richard 1
4729336 2274392 2274392 defendant Baker John ostler 598732 598732 Baker, John, of Lemyngton, ostler 0
4729338 2274393 2274393 defendant Bakere John ostler 598732 598732 Bakere, John, of Lemyngton, ostler 0
4747683 2279830 2279830 defendant Bakere John husbandman 598732 598732 Bakere, John, of Lemyngton, husbandman 0
4761197 2283852 2283852 defendant Baker John mariner 598732 598732 Baker, John, of Lemyngton, mariner 0
4772110 2287250 2287250 defendant Poy John   598732 598732 Poy, John, of Lemyngton, husb 12
4773585 2287710 2287710 defendant Sewer Thomas carpenter 598732 598732 Sewer, Thomas, of Lemyngton, carpenter 0
4807217 2298458 2298458 defendant Forton John   598732 598732 Forton, John, of Lemyngton, parson & clerk 1
4857011 2313572 2313572 defendant Seman Richard gent 598732 598732 Seman, Richard, of Lemyngton, gent 1
4895773 2325354 2325354 defendant Hosyer John chapman 598732 598732 Hosyer, John, of Lemyngton, chapman 0
4902370 2327354 2327354 defendant Hosyer John chapman 598732 598732 Hosyer, John, of Lemyngton, chapman 0
4920039 2332779 2332779 defendant Tanner Thomas tanner 598732 598732 Tanner, Thomas, of Lemyngton, tanner 2
4941554 2339376 2339376 defendant Hosyer John hosier 598732 598732 Hosyer, John, of Lemyngton, hosier 1
4942455 2339626 2339626 defendant Gosse Richard weaver 598732 598732 Gosse, Richard, of Lemyngton, weaver 4
4945654 2340621 2340621 defendant Forton John clerk 598732 598732 Forton, John, of Lemyngton, clerk 0
4945655 2340621 2340621 defendant Wyseman John yeoman 598732 598732 Wyseman, John, of Lemyngton, yeoman 1
4945656 2340621 2340621 defendant Forton Roger yeoman 598732 598732 Forton, Roger, of Lemyngton, yeoman 2
4945657 2340621 2340621 defendant Seburn Thomas yeoman 598732 598732 Seburn, Thomas, of Lemyngton, yeoman 3
4950730 2342196 2342196 defendant Cranborn Thomas tanner 598732 598732 Cranborn, Thomas, of Lemyngton, tanner 1
5115328 2390911 2390911 defendant Dene John chapman 598732 598732 Dene, John, of Lemyngton, chapman 0
5118165 2391748 2391748 defendant Dene John chapman 598732 598732 Dene, John, of Lemyngton, chapman 0
5118167 2391749 2391749 defendant Dene John chapman 598732 598732 Dene, John, of Lemyngton, chapman 0
5243466 2428284 2428284 defendant Grevell Richard gent 598732 598732 Grevell, Richard, of Lemyngton, gent 0
5250838 2430373 2430373 defendant Bygge John husbandman 598732 598732 Bygge, John, of Lemyngton, husbandman 3
5250839 2430373 2430373 defendant Yngull William husbandman 598732 598732 Yngull, William, of Lemyngton, husbandman 4
5260013 2433253 2433253 defendant Gely John butcher 598732 598732 Gely, John, of Lemyngton, butcher 2
5314588 2449395 2449395 defendant Hone or Hove Walter dyer 598732 598732 Hone or Hove, Walter, of Lemyngton, or of Winchester, dyer 0
5379705 2469237 2469237 defendant Nele Thomas husbandman 598732 598732 Nele, Thomas, of Lemyngton, husbandman 1
5511156 2508326 2508326 defendant Jacard Thomas husbandman 598732 598732 Jacard, Thomas, of Lemyngton Prior, husbandman 0
5536696 2515964 2515964 defendant Bygge Richard husbandman 598732 598732 Bygge, Richard, of Lemyngton, husbandman 1
5589697 2531774 2531774 defendant Dey John husbandman 598732 598732 Dey, John, of Lemyngton, husbandman 1
5612867 2547784 2547784 plaintiff Clerk Simon le merchant 598732 598732 Clerk, Simon le, of Lemyngton, merchant 0
5612868 2547784 2547784 defendant Bayny Richard merchant 598732 598732 Bayny, Richard, of Lemyngton, merchant 0

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