names

199 rows where place_id = 593853

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613601 1871899 1871899 defendant Turnour Stephen dyer 593853 593853 Turnour, Stephen, of Wysbech, dyer 4
3628081 1903637 1903637 defendant Style Nicholas mercer 593853 593853 Style, Nicholas, of Wysbech, mercer 0
3628083 1903637 1903637 defendant Ryches William draper 593853 593853 Ryches, William, of Wysbech, draper 2
4416088 2169916 2169916 defendant Reddyk Richard de   593853 593853 Reddyk, Richard de, of Wysbech 0
4439819 2181731 2181731 defendant Thomesson Thomas   593853 593853 Thomesson, Thomas, of Wysbech 0
4455237 2186647 2186647 plaintiff Merton William   593853 593853 Merton, William, of Wysbech 0
4464013 2189415 2189415 defendant Sutton Nicholas   593853 593853 Sutton, Nicholas, of Wysbech 0
4475717 2193083 2193083 plaintiff Ferrour Thomas   593853 593853 Ferrour, Thomas, of Wysbech, on his own account 0
4478781 2194032 2194032 defendant Rokelond Robert   593853 593853 Rokelond, Robert, of Wysbech 0
4478784 2194033 2194033 defendant Rokelond Robert   593853 593853 Rokelond, Robert, of Wysbech 0
4484942 2195988 2195988 defendant Ferour Thomas   593853 593853 Ferour, Thomas, of Wysbech 0
4507341 2202759 2202759 defendant Ferour John   593853 593853 Ferour, John, of Wysbech 4
4531733 2210188 2210188 defendant Leyght Simon   593853 593853 Leyght, Simon, of Wysbech 0
4557068 2218138 2218138 plaintiff Kep William (legal representative) 593853 593853 Kep, William, of Wysbech, executors of 0
4606213 2233051 2233051 defendant Saundres Thomas   593853 593853 Saundres, Thomas, of Wysbech 0
4606214 2233051 2233051 defendant Bolle Thomas   593853 593853 Bolle, Thomas, of Wysbech 1
4655758 2247684 2247684 defendant Mast William Cams, boatman 593853 593853 Mast William, of Wysbech, Cams, boatman 0
4662869 2249847 2249847 defendant Melton William brewer 593853 593853 Melton, William, of Wysbech, brewer 0
4676006 2258106 2258106 plaintiff Fyssher Thomas   593853 593853 Fyssher, Thomas, of Wysbech, on his own account 0
4684463 2260744 2260744 defendant Harwedon John husbandman 593853 593853 Harwedon, John, of Wysbech, husbandman 0
4684466 2260745 2260745 defendant Harwedon John husbandman 593853 593853 Harwedon, John, of Wysbech, husbandman 0
4699292 2265243 2265243 plaintiff Dousyng Thomas   593853 593853 Dousyng, Thomas, of Wysbech 0
4699294 2265244 2265244 plaintiff Dousyng Thomas   593853 593853 Dousyng, Thomas, of Wysbech 0
4699299 2265245 2265245 plaintiff Dousyng Thomas   593853 593853 Dousyng, Thomas, of Wysbech 0
4701566 2265884 2265884 defendant Vaux Bartholomew yeoman 593853 593853 Vaux, Bartholomew, of Wysbech, yeoman 0
4712714 2269290 2269290 plaintiff Sorell Hugh   593853 593853 Sorell, Hugh, of Wysbech 0
4712717 2269290 2269290 defendant Williamesson Simon tanner 593853 593853 Williamesson, Simon, of Wysbech, tanner 2
4712718 2269291 2269291 plaintiff Sorell Hugh   593853 593853 Sorell, Hugh, of Wysbech 0
4712721 2269291 2269291 defendant Williamesson Simon tanner 593853 593853 Williamesson, Simon, of Wysbech, tanner 2
4715165 2270072 2270072 defendant Fyssher Richard yeoman 593853 593853 Fyssher, Richard, of Wysbech, yeoman 0
4730929 2274871 2274871 defendant Keep John brewer 593853 593853 Keep, John, of Wysbech, brewer 0
4752131 2281104 2281104 defendant Ferrour Walter husbandman 593853 593853 Ferrour, Walter, of Wysbech, husbandman 0
4753176 2281377 2281377 defendant Sadler William sadler 593853 593853 Sadler, William, of Wysbech, sadler 0
4754120 2281667 2281667 defendant Vaux Bartholomew husbandman 593853 593853 Vaux, Bartholomew, of Wysbech, husbandman 0
4754121 2281667 2281667 defendant Sadeler William sadler 593853 593853 Sadeler, William, of Wysbech, sadler 1
4754122 2281667 2281667 defendant Salier William husbandman 593853 593853 Salier, William, of Wysbech, husbandman 2
4760095 2283501 2283501 defendant Bacon Thomas tailor 593853 593853 Bacon, Thomas, of Wysbech, tailor 1
4824262 2303656 2303656 plaintiff Taillour William   593853 593853 Taillour, William, of Wysbech 0
4824264 2303656 2303656 defendant Burwell Robert yeoman 593853 593853 Burwell, Robert, of Wysbech, yeoman 1
4833409 2306456 2306456 defendant Harpham Robert yeoman 593853 593853 Harpham, Robert, of Wysbech, yeoman 0
4833410 2306456 2306456 defendant Harpham Nicholas yeoman 593853 593853 Harpham, Nicholas, of Wysbech, yeoman 1
4833411 2306456 2306456 defendant Leper John yeoman 593853 593853 Leper, John, of Wysbech, yeoman 2
4852092 2312086 2312086 plaintiff Walton John   593853 593853 Walton, John, of Wysbech 0
4868884 2317243 2317243 defendant Baret John yeoman 593853 593853 Baret, John, of Wysbech, yeoman 3
4877955 2320059 2320059 defendant Pepir William yeoman 593853 593853 Pepir, William, of Wysbech, yeoman 3
4877956 2320059 2320059 defendant Pepir Richard yeoman 593853 593853 Pepir, Richard, of Wysbech, yeoman 4
4892742 2324454 2324454 defendant Sukar Robert (legal representative) 593853 593853 Sukar, Robert, of Wysbech, "iconami", executors of 0
4892744 2324454 2324454 defendant Kepe John husbandman 593853 593853 Kepe, John, of Wysbech, husbandman 2
4893361 2324626 2324626 defendant Sedyk John tailor 593853 593853 Sedyk, John, of Wysbech, tailor 0
4893374 2324630 2324630 defendant Gatissend John husbandman 593853 593853 Gatissend, John, of Wysbech, husbandman 1
4893376 2324631 2324631 defendant Lylye John chaplain 593853 593853 Lylye, John, of Wysbech, chaplain 0
4893377 2324631 2324631 defendant Kepe John yeoman 593853 593853 Kepe, John, of Wysbech, yeoman 1
4893378 2324631 2324631 defendant Grey William husbandman 593853 593853 Grey, William, of Wysbech, husbandman 2
4903296 2327639 2327639 defendant Gylyot John husbandman 593853 593853 Gylyot, John, of Wysbech, husbandman 0
4903297 2327639 2327639 defendant Mayhewe Martin brewer 593853 593853 Mayhewe, Martin, of Wysbech, brewer 1
4903880 2327829 2327829 defendant Lyly John chaplain 593853 593853 Lyly, John, of Wysbech, chaplain 2
4906008 2328479 2328479 defendant Mannyng John husbandman 593853 593853 Mannyng, John, of Wysbech, husbandman 1
4906030 2328482 2328482 defendant Hawekyn Simon waterman 593853 593853 Hawekyn, Simon, of Wysbech, waterman 0
4915453 2331334 2331334 defendant Grene William glover 593853 593853 Grene, William, of Wysbech, glover 8
4916342 2331613 2331613 defendant shepherd Henry tailor 593853 593853 shepherd, Henry, of Wysbech, tailor 1
4916344 2331613 2331613 defendant Herberd William husbandman 593853 593853 Herberd, William, of Wysbech, husbandman 3
4918427 2332280 2332280 defendant Joly Thomas dyer 593853 593853 Joly, Thomas, of Wysbech, dyer 4
4921020 2333086 2333086 defendant Awebell Ralph cooper 593853 593853 Awebell, Ralph, of Wysbech, cooper 0
4921021 2333086 2333086 defendant Chapman alias Barbour John husbandman 593853 593853 Chapman alias Barbour, John, of Wysbech, husbandman 1
4922449 2333431 2333431 defendant Ratellesden John butcher 593853 593853 Ratellesden, John, of Wysbech, butcher 0
4922450 2333431 2333431 defendant Chapman John fuller 593853 593853 Chapman, John, of Wysbech, fuller 1
4923629 2333826 2333826 plaintiff Methwold John   593853 593853 Methwold, John, of Wysbech 0
4923630 2333826 2333826 defendant Sutton Geoffrey esq 593853 593853 Sutton, Geoffrey, of Wysbech, esq 0
4924004 2333947 2333947 defendant Boteler William yeoman 593853 593853 Boteler, William, of Wysbech, yeoman 4
4924592 2334129 2334129 defendant Sutton Geoffrey esq 593853 593853 Sutton, Geoffrey, of Wysbech, esq 0
4927411 2335005 2335005 defendant Wheneld or Wheveld Thomas husbandman 593853 593853 Wheneld or Wheveld, Thomas, of Wysbech, husbandman 0
4927412 2335005 2335005 defendant Lelye John chaplain 593853 593853 Lelye, John, of Wysbech, chaplain 1
4927413 2335005 2335005 defendant Whyte John yeoman 593853 593853 Whyte, John, of Wysbech, yeoman 2
4927414 2335005 2335005 defendant Kape John yeoman 593853 593853 Kape, John, of Wysbech, yeoman 3
4929571 2335662 2335662 plaintiff Suker Robert (legal representative) 593853 593853 Suker, Robert, of Wysbech, executors of 0
4930354 2335893 2335893 defendant Everard William gent 593853 593853 Everard, William, of Wysbech, gent 3
4934531 2337195 2337195 plaintiff Halman William   593853 593853 Halman, William, of Wysbech 1
4934532 2337195 2337195 defendant Fawekes John husbandman 593853 593853 Fawekes, John, of Wysbech, husbandman 0
4934533 2337195 2337195 defendant Jolyfe Thomas dyer 593853 593853 Jolyfe, Thomas, of Wysbech, dyer 1
4935428 2337477 2337477 defendant Mast William husbandman 593853 593853 Mast, William, of Wysbech, husbandman 0
4938741 2338505 2338505 defendant Mannyng John husbandman 593853 593853 Mannyng, John, of Wysbech, husbandman 1
4938742 2338505 2338505 defendant Borewell William husbandman 593853 593853 Borewell, William, of Wysbech, husbandman 2
4939141 2338628 2338628 defendant Ketill Thomas husbandman 593853 593853 Ketill, Thomas, of Wysbech, husbandman 0
4939142 2338628 2338628 defendant Loveday Simon husbandman 593853 593853 Loveday, Simon, of Wysbech, husbandman 1
4944151 2340140 2340140 defendant Foke John yeoman 593853 593853 Foke, John, of Wysbech, yeoman 3
4949989 2341967 2341967 defendant Mannyng John, senior yeoman 593853 593853 Mannyng, John, senior, of Wysbech, yeoman 0
4979733 2350894 2350894 defendant Grene William husbandman 593853 593853 Grene, William, of Wysbech, husbandman 0
4986676 2352948 2352948 defendant Brasyere William brewer 593853 593853 Brasyere, William, of Wysbech, brewer 0
4987292 2353149 2353149 defendant Smyth John waterman 593853 593853 Smyth, John, of Wysbech, waterman 1
4989335 2353744 2353744 defendant Blyssell John husbandman 593853 593853 Blyssell, John, of Wysbech, husbandman 2
4993361 2354883 2354883 defendant Fook John yeoman 593853 593853 Fook, John, of Wysbech, yeoman 1
4993932 2355056 2355056 defendant Joly Thomas dyer 593853 593853 Joly, Thomas, of Wysbech, dyer 0
4996915 2355932 2355932 defendant Ketyll Thomas husbandman 593853 593853 Ketyll, Thomas, of Wysbech, husbandman 0
4996919 2355933 2355933 defendant Redyk Hugh husbandman 593853 593853 Redyk, Hugh, of Wysbech, husbandman 0
5004410 2358186 2358186 defendant Willyam John yeoman 593853 593853 Willyam, John, of Wysbech, yeoman 0
5005219 2358423 2358423 defendant Kepe John brewer 593853 593853 Kepe, John, of Wysbech, brewer 0
5005220 2358423 2358423 defendant Sutton Geoffrey esq 593853 593853 Sutton, Geoffrey, of Wysbech, esq 1
5008852 2359481 2359481 defendant Austyn John yeoman 593853 593853 Austyn, John, of Wysbech, yeoman 0
5008853 2359481 2359481 defendant Drake William husbandman 593853 593853 Drake, William, of Wysbech, husbandman 1
5012483 2360499 2360499 plaintiff York John draper 593853 593853 York, John, of Wysbech, draper 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);