names

142 rows where place_id = 586750

✎ 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
3589527 1864361 1864361 plaintiff Burton Robert   586750 586750 Burton, Robert, of Surflete 0
3596970 1866679 1866679 defendant Sparke Robert yeoman 586750 586750 Sparke, Robert, of Surflete, yeoman 0
3613349 1871821 1871821 defendant Oberey or Overey John husbandman 586750 586750 Oberey or Overey, John, of Surflete, husbandman 0
3613350 1871821 1871821 defendant Oberey or Overey William husbandman 586750 586750 Oberey or Overey, William, of Surflete, husbandman 1
3614039 1872051 1872051 defendant Lunton Robert laborer 586750 586750 Lunton, Robert, of Surflete, laborer 0
3639580 1907189 1907189 defendant Hochynson Gilbert husbandman 586750 586750 Hochynson, Gilbert, of Surflete, husbandman 0
3688732 1922638 1922638 defendant Fissher John husbandman 586750 586750 Fissher, John, of Surflete, husbandman 0
3773933 1949564 1949564 defendant Cotys George weaver 586750 586750 Cotys, George, of Surflete, weaver 0
3791662 1955235 1955235 defendant Cotys George weaver 586750 586750 Cotys, George, of Surflete, weaver 0
3791664 1955236 1955236 defendant Cotys George weaver 586750 586750 Cotys, George, of Surflete, weaver 0
3920852 1997318 1997318 defendant Coxson Alice spinster 586750 586750 Coxson, Alice, of Surflete, spinster 0
3920853 1997318 1997318 defendant Dowsby John laborer 586750 586750 Dowsby, John, of Surflete, laborer 1
3920854 1997318 1997318 defendant Johnson Helen spinster 586750 586750 Johnson, Helen, of Surflete, spinster 2
3920950 1997353 1997353 defendant Coxson John husbandman 586750 586750 Coxson, John, of Surflete, husbandman 0
3921991 1997700 1997700 defendant Burton Richard husbandman 586750 586750 Burton, Richard, of Surflete, husbandman 0
4025454 2033764 2033764 defendant Harves or Harnes James clerk 586750 586750 Harves or Harnes, James, of Surflete, clerk 1
4146516 2076933 2076933 defendant Sye John yeoman 586750 586750 Sye, John, of Surflete, yeoman 0
4273614 2120725 2120725 defendant Dowsinge Richard yeoman 586750 586750 Dowsinge, Richard, of Surflete, yeoman 2
4427354 2173392 2173392 defendant Cullul Richard   586750 586750 Cullul, Richard, of Surflete 0
4427356 2173392 2173392 defendant Breustere Thomas le   586750 586750 Breustere, Thomas le, of Surflete, chaplain, son of Geoffrey 2
4427358 2173392 2173392 defendant Clifton Gervase   586750 586750 Clifton, Gervase, of Surflete 4
4436243 2176076 2176076 defendant Cullul Richard   586750 586750 Cullul, Richard, of Surflete 0
4436245 2176076 2176076 defendant Breustere Thomas le chaplain 586750 586750 Breustere, Thomas le, of Surflete, son of Geoffrey, chaplain 2
4459487 2188020 2188020 defendant Spark Robert   586750 586750 Spark, Robert, of Surflete 0
4459488 2188020 2188020 defendant Curlewe Richard   586750 586750 Curlewe, Richard, of Surflete 1
4459489 2188020 2188020 defendant Klenche Thomas   586750 586750 Klenche, Thomas, of Surflete 2
4474422 2192658 2192658 plaintiff Dode John   586750 586750 Dode, John, of Surflete 0
4474423 2192658 2192658 defendant Thakkers John   586750 586750 Thakkers, John, of Surflete 0
4488441 2197104 2197104 defendant Capon Robert   586750 586750 Capon, Robert, of Surflete 0
4501971 2201214 2201214 defendant Glenche John   586750 586750 Glenche, John, of Surflete 0
4507207 2202720 2202720 defendant Rede William   586750 586750 Rede, William, of Surflete 0
4536361 2211655 2211655 plaintiff St Mary William   586750 586750 St Mary, William, of Surflete 0
4536362 2211655 2211655 defendant Rede William   586750 586750 Rede, William, of Surflete 0
4539764 2212696 2212696 defendant Rode William   586750 586750 Rode, William, of Surflete 0
4543709 2213927 2213927 defendant Lambe John   586750 586750 Lambe, John, of Surflete 1
4555830 2217763 2217763 defendant Thakker Thomas   586750 586750 Thakker, Thomas, of Surflete 0
4566804 2221187 2221187 plaintiff Sutton Robert   586750 586750 Sutton, Robert, of Surflete 0
4567476 2221388 2221388 defendant Mone John   586750 586750 Mone, John, of Surflete 0
4567477 2221388 2221388 defendant Rede Margaret   586750 586750 Rede, Margaret, of Surflete 1
4568431 2221699 2221699 defendant Cros John   586750 586750 Cros, John, of Surflete 1
4568436 2221700 2221700 defendant Cres John   586750 586750 Cres, John, of Surflete 1
4569714 2222112 2222112 plaintiff Whitbred Richard   586750 586750 Whitbred, Richard, of Surflete 0
4569715 2222112 2222112 defendant Smyth Gilbert   586750 586750 Smyth, Gilbert, of Surflete 0
4569717 2222112 2222112 defendant Sutton John   586750 586750 Sutton, John, of Surflete 2
4586054 2227062 2227062 defendant Dyot Robert   586750 586750 Dyot, Robert, of Surflete 0
4590459 2228374 2228374 defendant Smyth John   586750 586750 Smyth, John, of Surflete 0
4590460 2228374 2228374 defendant Smyth William   586750 586750 Smyth, William, of Surflete 1
4599523 2231066 2231066 defendant Hobbard Gilbert   586750 586750 Hobbard, Gilbert, of Surflete 0
4630832 2240533 2240533 plaintiff Sutton Joan   586750 586750 Sutton, Joan, of Surflete 0
4630834 2240533 2240533 defendant Thakker John carter 586750 586750 Thakker, John, of Surflete, carter 1
4649981 2246011 2246011 defendant Dyot Robert   586750 586750 Dyot, Robert, of Surflete 1
4656272 2247855 2247855 defendant Thakker John   586750 586750 Thakker, John, of Surflete 0
4658875 2248647 2248647 defendant Lemman Richard husbandman 586750 586750 Lemman, Richard, of Surflete, husbandman 0
4659776 2248907 2248907 defendant Thakkar William husbandman 586750 586750 Thakkar, William, of Surflete, husbandman 0
4714036 2269718 2269718 defendant Thakker atte Gote Robert laborer 586750 586750 Thakker atte Gote, Robert, of Surflete, laborer 0
4714038 2269719 2269719 defendant Sutton William yeoman 586750 586750 Sutton, William, of Surflete, yeoman 0
4714039 2269719 2269719 defendant Sutton Joan widow 586750 586750 Sutton, Joan, of Surflete, widow 1
4714040 2269719 2269719 defendant Jacob Robert husbandman 586750 586750 Jacob, Robert, of Surflete, husbandman 2
4724046 2272817 2272817 defendant Welby Athelardus   586750 586750 Welby, Athelardus, of Surflete, parson 0
4724047 2272817 2272817 defendant Sutton John gent 586750 586750 Sutton, John, of Surflete, gent 1
4740185 2277642 2277642 defendant Sutton William husbandman 586750 586750 Sutton, William, of Surflete, husbandman 6
4753594 2281495 2281495 defendant Capon Robert gent 586750 586750 Capon, Robert, of Surflete, gent 0
4773209 2287589 2287589 plaintiff Sutton William   586750 586750 Sutton, William, of Surflete 0
4781375 2290185 2290185 defendant Capon Robert gent 586750 586750 Capon, Robert, of Surflete, gent 0
4782793 2290635 2290635 defendant Capon Robert husbandman 586750 586750 Capon, Robert, of Surflete, husbandman 0
4795800 2294835 2294835 defendant Stevenson Thomas gent 586750 586750 Stevenson, Thomas, of Surflete, gent 0
4805873 2298044 2298044 defendant Dyet William laborer 586750 586750 Dyet, William, of Surflete, laborer 0
4821315 2302747 2302747 defendant Stevenson Thomas gent 586750 586750 Stevenson, Thomas, of Surflete, gent 0
4836042 2307253 2307253 defendant Smyth Thomas smith 586750 586750 Smyth, Thomas, of Surflete, smith 2
4838779 2308057 2308057 defendant Thekker William husbandman 586750 586750 Thekker, William, of Surflete, husbandman 0
4839859 2308377 2308377 defendant Crestye John husbandman 586750 586750 Crestye, John, of Surflete, husbandman 2
4861006 2314799 2314799 defendant Dandyson Simon gent 586750 586750 Dandyson, Simon, of Surflete, gent 0
4862786 2315344 2315344 defendant Thakker Ralph husbandman 586750 586750 Thakker, Ralph, of Surflete, husbandman 0
4876747 2319701 2319701 defendant Reede Robert husbandman 586750 586750 Reede, Robert, of Surflete, husbandman 0
4876802 2319716 2319716 defendant Thakker Ralph thatcher 586750 586750 Thakker, Ralph, of Surflete, thatcher 0
4895581 2325287 2325287 defendant Thakker Walter husbandman 586750 586750 Thakker, Walter, of Surflete, husbandman 2
4897452 2325865 2325865 defendant Brygge John yeoman 586750 586750 Brygge, John, of Surflete, yeoman 0
4907888 2329027 2329027 defendant Crecy John husbandman 586750 586750 Crecy, John, of Surflete, husbandman 1
4911162 2330001 2330001 defendant Crecy John husbandman 586750 586750 Crecy, John, of Surflete, husbandman 0
4915967 2331491 2331491 defendant Cresy John yeoman 586750 586750 Cresy, John, of Surflete, yeoman 0
4926363 2334668 2334668 defendant Thakker Ralph husbandman 586750 586750 Thakker, Ralph, of Surflete, husbandman 3
4926369 2334668 2334668 defendant Halle Robert husbandman 586750 586750 Halle, Robert, of Surflete, husbandman 9
4944206 2340158 2340158 defendant Coweherd Thomas weaver 586750 586750 Coweherd, Thomas, of Surflete, weaver 0
4944341 2340204 2340204 defendant Sutton William yeoman 586750 586750 Sutton, William, of Surflete, yeoman 3
4948066 2341370 2341370 defendant Thaker Randolph husbandman 586750 586750 Thaker, Randolph, of Surflete, husbandman 1
4948509 2341512 2341512 defendant Whytebrede John yeoman 586750 586750 Whytebrede, John, of Surflete, yeoman 2
4957399 2344180 2344180 defendant Storke Robert husbandman 586750 586750 Storke, Robert, of Surflete, husbandman 0
4957400 2344180 2344180 defendant Remy Nicholas husbandman 586750 586750 Remy, Nicholas, of Surflete, husbandman 1
4972085 2348589 2348589 defendant Crysp John husbandman 586750 586750 Crysp, John, of Surflete, husbandman 2
4981547 2351393 2351393 plaintiff Sutton William   586750 586750 Sutton, William, of Surflete 0
4981548 2351393 2351393 defendant Sutton John (legal representative) 586750 586750 Sutton, John, of Surflete, gent, executors of 0
4981550 2351393 2351393 defendant Whitbred John husbandman 586750 586750 Whitbred, John, of Surflete, husbandman 2
4982939 2351812 2351812 defendant Daweson John husbandman 586750 586750 Daweson, John, of Surflete, husbandman 2
4982940 2351812 2351812 defendant Halle Robert husbandman 586750 586750 Halle, Robert, of Surflete, husbandman 3
5020534 2362894 2362894 defendant Thaker Randolph yeoman 586750 586750 Thaker, Randolph, of Surflete, yeoman 0
5027444 2364906 2364906 defendant Crecy John pulter 586750 586750 Crecy, John, of Surflete, pulter 0
5087605 2382758 2382758 plaintiff Marys William yeoman 586750 586750 Marys, William, of Surflete, yeoman 1
5139750 2398103 2398103 defendant Chestyr Richard   586750 586750 Chestyr, Richard, of Surflete 0
5160683 2404222 2404222 defendant Chestyr Richard clerk 586750 586750 Chestyr, Richard, of Surflete, clerk 0
5196603 2414760 2414760 defendant Chestyr Richard clerk 586750 586750 Chestyr, Richard, of Surflete, clerk 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);