names

95 rows where place_id = 599996

✎ 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
3639239 1907083 1907083 defendant Goodrede Edmund husbandman 599996 599996 Goodrede, Edmund, of Carbroke, husbandman 5
3639589 1907192 1907192 defendant Aleyn Thomas   599996 599996 Aleyn, Thomas, of Carbroke husbandman 1
3649832 1910310 1910310 defendant Godered Edmund yeoman 599996 599996 Godered, Edmund, of Carbroke, yeoman 3
3659657 1913275 1913275 defendant Scott Thomas husbandman 599996 599996 Scott, Thomas, of Carbroke, husbandman 0
3671829 1917187 1917187 defendant Goodred Edmund yeoman 599996 599996 Goodred, Edmund, of Carbroke, yeoman 0
3672756 1917486 1917486 defendant Wulterton Walter laborer 599996 599996 Wulterton, Walter, of Carbroke, laborer 0
3686324 1921879 1921879 defendant Fennamour Richard husbandman 599996 599996 Fennamour, Richard, of Carbroke, husbandman 0
3689570 1922895 1922895 defendant Bocher George husbandman 599996 599996 Bocher, George, of Carbroke, husbandman 0
3701407 1926688 1926688 defendant Fennamore Richard husbandman 599996 599996 Fennamore, Richard, of Carbroke, husbandman 0
3705668 1928055 1928055 defendant Aleyn Thomas husbandman 599996 599996 Aleyn, Thomas, of Carbroke, husbandman 0
3705671 1928056 1928056 defendant Fenne Thomas husbandman 599996 599996 Fenne, Thomas, of Carbroke, husbandman 0
3705672 1928056 1928056 defendant Aleyn Thomas husbandman 599996 599996 Aleyn, Thomas, of Carbroke, husbandman 1
3705673 1928056 1928056 defendant Skotte Thomas husbandman 599996 599996 Skotte, Thomas, of Carbroke, husbandman 2
3728780 1935245 1935245 defendant Godsave Hugh husbandman 599996 599996 Godsave, Hugh, of Carbroke, husbandman 3
3739024 1938410 1938410 defendant Godsave Hugh husbandman 599996 599996 Godsave, Hugh, of Carbroke, husbandman 3
3753597 1943067 1943067 defendant Wright John yeoman 599996 599996 (Wright, John, of Carbroke, yeoman 1
3753598 1943067 1943067 defendant Fykas Robert yeoman 599996 599996 Fykas, Robert, of Carbroke, yeoman 2
3761774 1945694 1945694 defendant Pecok William husbandman 599996 599996 Pecok, William, of Carbroke, husbandman 0
3767523 1947479 1947479 defendant Wright John yeoman 599996 599996 Wright, John, of Carbroke, yeoman 2
3767627 1947514 1947514 plaintiff Newcome William   599996 599996 Newcome, William, of Carbroke 0
3767628 1947514 1947514 defendant Scotte William butcher 599996 599996 Scotte, William, of Carbroke, butcher 0
3768821 1947896 1947896 defendant Emysson John clerk 599996 599996 Emysson, John, of Carbroke, clerk 1
3774084 1949608 1949608 defendant Garne Thomas husbandman 599996 599996 Garne, Thomas, of Carbroke, husbandman 0
3774089 1949609 1949609 defendant Shymplyng Thomas tanner 599996 599996 Shymplyng, Thomas, of Carbroke, tanner 0
3774090 1949609 1949609 defendant Grene John, junior tailor 599996 599996 Grene, John, junior, of Carbroke, tailor 1
3774091 1949609 1949609 defendant Skotte Thomas, junior yeoman 599996 599996 Skotte, Thomas, junior, of Carbroke, yeoman 2
3780320 1951577 1951577 defendant Pek Thomas clerk 599996 599996 Pek, Thomas, of Carbroke, clerk 0
3786489 1953565 1953565 defendant Jorge John husbandman 599996 599996 Jorge, John, of Carbroke, husbandman 2
3791866 1955302 1955302 defendant Shrymlyng Thomas tanner 599996 599996 Shrymlyng, Thomas, of Carbroke, tanner 0
3791867 1955302 1955302 defendant Grene John, junior tailor 599996 599996 Grene, John, junior, of Carbroke, tailor 1
3791868 1955302 1955302 defendant Scott Thomas, junior yeoman 599996 599996 Scott, Thomas, junior, of Carbroke, yeoman 2
3794622 1956196 1956196 defendant Skaff John husbandman 599996 599996 Skaff, John, of Carbroke, husbandman 0
3794624 1956196 1956196 defendant Downyng Robert husbandman 599996 599996 Downyng, Robert, of Carbroke, husbandman 2
3808391 1960500 1960500 plaintiff Aleyn Thomas (legal representative) 599996 599996 Aleyn, Thomas, of Carbroke, executors of 0
3808393 1960500 1960500 plaintiff Fekes Robert   599996 599996 Fekes, Robert, of Carbroke 2
3831692 1967812 1967812 defendant Payn John husbandman 599996 599996 Payn, John, of Carbroke, husbandman 0
3835151 1968935 1968935 plaintiff Payn John   599996 599996 Payn, John, of Carbroke 0
3838583 1969994 1969994 defendant Payn John shoemaker 599996 599996 Payn, John, of Carbroke, shoemaker 0
3845407 1972126 1972126 defendant Chylderhowes William husbandman 599996 599996 Chylderhowes, William, of Carbroke, husbandman 0
3846707 1972526 1972526 plaintiff Grey John gent 599996 599996 Grey, John, of Carbroke, gent 0
3847189 1972677 1972677 defendant Payne John husbandman 599996 599996 Payne, John, of Carbroke, husbandman 0
3850322 1973688 1973688 defendant Childerhous William husbandman 599996 599996 Childerhous, William, of Carbroke, husbandman 0
3864160 1978202 1978202 defendant Smethys Robert husbandman 599996 599996 Smethys, Robert, of Carbroke, husbandman 0
3864161 1978202 1978202 defendant Sewall Thomas husbandman 599996 599996 Sewall, Thomas, of Carbroke, husbandman 1
3866423 1979001 1979001 defendant Browne Richard baker 599996 599996 Browne, Richard, of Carbroke, baker 4
3876475 1982379 1982379 plaintiff Grey John esq 599996 599996 Grey, John, of Carbroke, esq 0
3876477 1982380 1982380 plaintiff Grey John esq 599996 599996 Grey, John, of Carbroke, esq 0
3876725 1982457 1982457 defendant Sewall Thomas husbandman 599996 599996 Sewall, Thomas, of Carbroke, husbandman 2
3876773 1982474 1982474 defendant Rows William   599996 599996 Rows, William, of Carbroke, horse courser 0
3879246 1983310 1983310 defendant Chylderhous William husbandman 599996 599996 Chylderhous, William, of Carbroke, husbandman 0
3879322 1983336 1983336 defendant Totell William husbandman 599996 599996 Totell, William, of Carbroke, husbandman 0
3880147 1983614 1983614 defendant Emysson John clerk 599996 599996 Emysson, John, of Carbroke, clerk 0
3880148 1983614 1983614 defendant Nycolson Thomas haberdasher 599996 599996 Nycolson, Thomas, of Carbroke, haberdasher 1
3880149 1983614 1983614 defendant Downyng Nicholas husbandman 599996 599996 Downyng, Nicholas, of Carbroke, husbandman 2
3880151 1983615 1983615 defendant Nicolson Thomas haberdasher 599996 599996 Nicolson, Thomas, of Carbroke, haberdasher 0
3886228 1985646 1985646 defendant Seward Thomas husbandman 599996 599996 Seward, Thomas, of Carbroke, husbandman 0
3906620 1992507 1992507 defendant Grene Thomas laborer 599996 599996 Grene, Thomas, of Carbroke, laborer 3
3908943 1993285 1993285 defendant Coke James yeoman 599996 599996 Coke, James, of Carbroke, yeoman 1
3914471 1995181 1995181 defendant Constable Richard husbandman 599996 599996 Constable, Richard, of Carbroke, husbandman 3
3915280 1995477 1995477 plaintiff Crane Robert husbandman 599996 599996 Crane, Robert, of Carbroke, husbandman 0
3939894 2003643 2003643 defendant Wonge or Wouge Richard husbandman 599996 599996 Wonge or Wouge, Richard, of Carbroke, husbandman 0
3973344 2015250 2015250 plaintiff Grey Robert gent 599996 599996 Grey, Robert, of Carbroke, gent 0
3973650 2015355 2015355 defendant Wyther John tanner 599996 599996 Wyther, John, of Carbroke, tanner 0
3976498 2016357 2016357 plaintiff Kerman Lawrence (legal representative) 599996 599996 Kerman, Lawrence, of Carbroke, husbandman, executor of 0
3976499 2016357 2016357 plaintiff Folsham John, senior   599996 599996 Folsham, John, senior, of Carbroke 1
3984238 2019131 2019131 defendant Spryng Jerome gent 599996 599996 Spryng, Jerome, of Carbroke, gent 1
4015678 2030305 2030305 defendant Jones Walter carpenter 599996 599996 Jones, Walter, of Carbroke, carpenter 2
4056062 2044553 2044553 defendant Scott William yeoman 599996 599996 Scott, William, of Carbroke, yeoman 0
4057784 2045169 2045169 defendant Norrysse Barnabe husbandman 599996 599996 Norrysse, Barnabe, of Carbroke, husbandman 1
4057785 2045169 2045169 defendant Beele George tailor 599996 599996 Beele, George, of Carbroke, tailor 2
4063305 2047167 2047167 defendant George William husbandman 599996 599996 George, William, of Carbroke, husbandman 1
4064194 2047467 2047467 defendant Morrell Robert laborer 599996 599996 Morrell, Robert, of Carbroke, laborer 2
4083580 2054402 2054402 defendant George Ralph baker 599996 599996 George, Ralph, of Carbroke, baker 1
4085534 2055099 2055099 defendant Wyett Thomas husbandman 599996 599996 Wyett, Thomas, of Carbroke, husbandman 1
4085538 2055099 2055099 defendant Wright William yeoman 599996 599996 Wright, William, of Carbroke, yeoman 5
4099828 2060263 2060263 defendant Cole John laborer 599996 599996 Cole, John, of Carbroke, laborer 1
4116226 2066092 2066092 defendant Wryghte William yeoman 599996 599996 Wryghte, William, of Carbroke, yeoman 2
4192444 2092915 2092915 defendant Rodes Christopher husbandman 599996 599996 Rodes, Christopher, of Carbroke, husbandman 0
4406118 2166610 2166610 defendant Dixon John clerk 599996 599996 Dixon, John, of Carbroke, clerk 0
4408773 2167531 2167531 defendant Grey Anthony gent 599996 599996 Grey, Anthony, of Carbroke, gent 0
4641556 2243629 2243629 defendant Doleyne John   599996 599996 Doleyne, John, of Carbroke 0
4745633 2279237 2279237 defendant Gyle Thomas husbandman 599996 599996 Gyle, Thomas, of Carbroke, husbandman 0
5026616 2364659 2364659 defendant Bongeon or Bougeon John, junior husbandman 599996 599996 Bongeon or Bougeon, John, junior, of Carbroke, husbandman 0
5026617 2364659 2364659 defendant Tedpole William laborer 599996 599996 Tedpole, William, of Carbroke, laborer 1
5193622 2413860 2413860 defendant Holdernesse John (legal representative) 599996 599996 Holdernesse, John, of Carbroke, executrix of 0
5193623 2413860 2413860 defendant Holdernesse Margaret   599996 599996 Holdernesse, Margaret, of Carbroke, widow, formerly wife of John 1
5208283 2418150 2418150 defendant Holdernesse John (legal representative) 599996 599996 Holdernesse, John, of Carbroke, gent, executrix of 0
5309780 2447959 2447959 defendant Conyers Thomas esq 599996 599996 Conyers, Thomas, of Carbroke, esq 1
5326978 2453144 2453144 defendant Conyers Thomas esq 599996 599996 Conyers, Thomas, of Carbroke, esq 0
5326980 2453145 2453145 defendant Conyers Thomas esq 599996 599996 Conyers, Thomas, of Carbroke, esq 0
5405173 2476561 2476561 defendant Mounteyn Richard esq 599996 599996 Mounteyn, Richard, of Carbroke, esq 0
5418251 2480384 2480384 defendant Mounteyn Richard esq 599996 599996 Mounteyn, Richard, of Carbroke, esq 0
5450914 2490162 2490162 defendant Mounteyn Richard esq 599996 599996 Mounteyn, Richard, of Carbroke, esq 0
5498819 2504586 2504586 defendant Wulterton Roger husbandman 599996 599996 Wulterton, Roger, of Carbroke, husbandman 3
5505214 2506540 2506540 defendant Byrle John yeoman 599996 599996 Byrle, John, of Carbroke, yeoman 1

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