names

91 rows where place_id = 589706

✎ 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
3598472 1867151 1867151 defendant Veske Simon yeoman 589706 589706 Veske, Simon, of Besthorp, yeoman 1
3606519 1869711 1869711 defendant Veske Simon yeoman 589706 589706 Veske, Simon, of Besthorp, yeoman 0
3607047 1869870 1869870 defendant Veske Simon yeoman 589706 589706 Veske, Simon, of Besthorp, yeoman 2
3607053 1869871 1869871 defendant Veske Simon yeoman 589706 589706 Veske, Simon, of Besthorp, yeoman 4
3637075 1906396 1906396 defendant Haghton Robert husbandman 589706 589706 Haghton, Robert, of Besthorp, husbandman 0
3637076 1906396 1906396 defendant Haghton Thomas yeoman 589706 589706 Haghton, Thomas, of Besthorp, yeoman 1
3687492 1922267 1922267 defendant Drury John gent 589706 589706 Drury, John, of Besthorp, gent 2
3691806 1923598 1923598 defendant Drury Robert gent 589706 589706 Drury, Robert, of Besthorp, gent 0
3706047 1928182 1928182 defendant Drury Robert gent 589706 589706 Drury, Robert, of Besthorp, gent 0
3712867 1930343 1930343 defendant Drury John gent 589706 589706 Drury, John, of Besthorp, gent 1
3798834 1957549 1957549 defendant Drury William, senior gent 589706 589706 Drury, William, senior, of Besthorp, gent 1
3825584 1965853 1965853 defendant Rodde Thomas husbandman 589706 589706 Rodde, Thomas, of Besthorp, husbandman 1
3838856 1970079 1970079 plaintiff Downyng Thomas clerk 589706 589706 Downyng, Thomas, of Besthorp, clerk 1
3846929 1972578 1972578 defendant Sokelyng Richard spooner 589706 589706 Sokelyng, Richard, of Besthorp, spooner 1
3861799 1977411 1977411 defendant Suklyng Richard spooner 589706 589706 Suklyng, Richard, of Besthorp, spooner 1
3889667 1986778 1986778 defendant Brampton William esq 589706 589706 Brampton, William, of Besthorp, esq 0
4181307 2088943 2088943 defendant Threlkeld Christopher gent 589706 589706 Threlkeld, Christopher, of Besthorp, gent 0
4458228 2187613 2187613 defendant Alysaundre Matilda   589706 589706 Alysaundre, Matilda, of Besthorp, son of John, junior 0
4461175 2188575 2188575 defendant Mason John   589706 589706 Mason, John, of Besthorp 1
4496189 2199481 2199481 defendant Portere Richard   589706 589706 Portere, Richard, of Besthorp 1
4505768 2202313 2202313 defendant Spayne Thomas, junior   589706 589706 Spayne, Thomas, junior, of Besthorp 5
4601790 2231780 2231780 defendant Spayne Margery   589706 589706 Spayne, Margery, of Besthorp 1
4617923 2236610 2236610 defendant Clerk Simon   589706 589706 Clerk, Simon, of Besthorp, vicar 0
4694341 2263731 2263731 defendant Potter Richard husbandman 589706 589706 Potter, Richard, of Besthorp, husbandman 3
4718967 2271279 2271279 defendant Lylye John   589706 589706 Lylye, John, of Besthorp, shoe maker 0
4774708 2288079 2288079 defendant Vesk William   589706 589706 Vesk, William, of Besthorp 0
4797367 2295348 2295348 defendant Maundevyle John clerk 589706 589706 Maundevyle, John, of Besthorp, clerk 2
4800927 2296479 2296479 plaintiff Wetenhale Henry   589706 589706 Wetenhale, Henry, of Besthorp 0
4800929 2296480 2296480 plaintiff Wetenhale Henry   589706 589706 Wetenhale, Henry, of Besthorp 0
4913507 2330721 2330721 plaintiff Bussh Robert gent 589706 589706 Bussh, Robert, of Besthorp, gent 1
4955644 2343654 2343654 defendant Hobbys Robert husbandman 589706 589706 Hobbys, Robert, of Besthorp, husbandman 2
4974690 2349396 2349396 defendant Litylburgh Richard husbandman 589706 589706 Litylburgh, Richard, of Besthorp, husbandman 4
4975249 2349552 2349552 defendant Neuton Thomas yeoman 589706 589706 Neuton, Thomas, of Besthorp, yeoman 0
4975252 2349552 2349552 defendant Bonne Robert yeoman 589706 589706 Bonne, Robert, of Besthorp, yeoman 3
4992262 2354579 2354579 defendant Overay Richard husbandman 589706 589706 Overay, Richard, of Besthorp, husbandman 1
5053314 2372594 2372594 defendant Wryte Adam laborer 589706 589706 Wryte, Adam, of Besthorp, laborer 0
5058344 2374040 2374040 defendant Deye Peter yeoman 589706 589706 Deye, Peter, of Besthorp, yeoman 1
5073809 2378654 2378654 plaintiff Warner Robert   589706 589706 Warner, Robert, of Besthorp 0
5093355 2384456 2384456 defendant Knyght Thomas husbandman 589706 589706 Knyght, Thomas, of Besthorp, husbandman 0
5106754 2388401 2388401 defendant Miller William husbandman 589706 589706 Miller, William, of Besthorp, husbandman 2
5133203 2396192 2396192 defendant Warner Robert gent 589706 589706 Warner, Robert, of Besthorp, gent 0
5157466 2403317 2403317 defendant Reynebald William husbandman 589706 589706 Reynebald, William, of Besthorp, husbandman 1
5173374 2407919 2407919 defendant Reynebald William husbandman 589706 589706 Reynebald, William, of Besthorp, husbandman 1
5193340 2413781 2413781 defendant Reynebald William husbandman 589706 589706 Reynebald, William, of Besthorp, husbandman 1
5193343 2413782 2413782 defendant Reynebald William husbandman 589706 589706 Reynebald, William, of Besthorp, husbandman 1
5226714 2423479 2423479 defendant Machon William miller 589706 589706 Machon, William, of Besthorp, miller 1
5233713 2425447 2425447 defendant Doughti Clement laborer 589706 589706 Doughti, Clement, of Besthorp, laborer 2
5248245 2429621 2429621 defendant Machon William miller 589706 589706 Machon, William, of Besthorp, miller 1
5266679 2435334 2435334 plaintiff Warner Robert gent 589706 589706 Warner, Robert, of Besthorp, gent 0
5266683 2435335 2435335 plaintiff Warner Robert gent 589706 589706 Warner, Robert, of Besthorp, gent 0
5266687 2435336 2435336 plaintiff Warner Robert   589706 589706 Warner, Robert, of Besthorp 0
5293139 2442975 2442975 defendant Groute Robert husbandman 589706 589706 Groute, Robert, of Besthorp, husbandman 1
5308191 2447479 2447479 defendant Burghard John husbandman 589706 589706 Burghard, John, of Besthorp, husbandman 0
5328004 2453442 2453442 defendant Dowe Thomas husbandman 589706 589706 Dowe, Thomas, of Besthorp, husbandman 1
5329673 2453943 2453943 defendant Veske Simon woolman 589706 589706 Veske, Simon, of Besthorp, woolman 0
5333860 2455199 2455199 defendant Yonge Richard husbandman 589706 589706 Yonge, Richard, of Besthorp, husbandman 0
5356982 2462245 2462245 defendant Veske Simon   589706 589706 Veske, Simon, of Besthorp, wool chapman 0
5366873 2465293 2465293 defendant Veske John gent 589706 589706 Veske, John, of Besthorp, gent 9
5368642 2465788 2465788 defendant Osberne Bartholomew yeoman 589706 589706 Osberne, Bartholomew, of Besthorp, yeoman 0
5368643 2465788 2465788 defendant Canne Robert yeoman 589706 589706 Canne, Robert, of Besthorp, yeoman 1
5368644 2465788 2465788 defendant Potter Stephen yeoman 589706 589706 Potter, Stephen, of Besthorp, yeoman 2
5368645 2465788 2465788 defendant Wyke Peter yeoman 589706 589706 Wyke, Peter, of Besthorp, yeoman 3
5425172 2482495 2482495 defendant Drury William gent 589706 589706 Drury, William, of Besthorp, gent 0
5433272 2484916 2484916 defendant Burthen John husbandman 589706 589706 Burthen, John, of Besthorp, husbandman 0
5433273 2484916 2484916 defendant Harry Robert husbandman 589706 589706 Harry, Robert, of Besthorp, husbandman 1
5433274 2484916 2484916 defendant Lytylburgh Robert husbandman 589706 589706 Lytylburgh, Robert, of Besthorp, husbandman 2
5433275 2484916 2484916 defendant Wheteley Thomas husbandman 589706 589706 Wheteley, Thomas, of Besthorp, husbandman 3
5448913 2489566 2489566 defendant Burthen John husbandman 589706 589706 Burthen, John, of Besthorp, husbandman 0
5448914 2489566 2489566 defendant Harry Robert husbandman 589706 589706 Harry, Robert, of Besthorp, husbandman 1
5448915 2489566 2489566 defendant Lytylburgh Robert husbandman 589706 589706 Lytylburgh, Robert, of Besthorp, husbandman 2
5448916 2489566 2489566 defendant Wheteley Thomas husbandman 589706 589706 Wheteley, Thomas, of Besthorp, husbandman 3
5462527 2493701 2493701 defendant Brett Thomas husbandman 589706 589706 Brett, Thomas, of Besthorp, husbandman 0
5462528 2493701 2493701 defendant Canne Robert husbandman 589706 589706 Canne, Robert, of Besthorp, husbandman 1
5498631 2504535 2504535 defendant Brette Thomas husbandman 589706 589706 Brette, Thomas, of Besthorp, husbandman 0
5502487 2505698 2505698 defendant Borell John husbandman 589706 589706 Borell, John, of Besthorp, husbandman 0
5507193 2507154 2507154 defendant Weske or Leske Simon yeoman 589706 589706 Weske or Leske, Simon, of Besthorp, yeoman 0
5507196 2507155 2507155 defendant Weske Simon yeoman 589706 589706 Weske, Simon, of Besthorp, yeoman 0
5521971 2511688 2511688 defendant Veske Simon yeoman 589706 589706 Veske, Simon, of Besthorp, yeoman 0
5525437 2512546 2512546 defendant Veske Simon woolman 589706 589706 Veske, Simon, of Besthorp, woolman 0
5528859 2513548 2513548 defendant Veske Simon yeoman 589706 589706 Veske, Simon, of Besthorp, yeoman 0
5539074 2516702 2516702 defendant Dowe Thomas turner 589706 589706 Dowe, Thomas, of Besthorp, turner 1
5547067 2519151 2519151 defendant Brett Thomas yeoman 589706 589706 Brett, Thomas, of Besthorp, yeoman 0
5550614 2520204 2520204 defendant Baldwyn John clerk 589706 589706 Baldwyn, John, of Besthorp, clerk 0
5561084 2523214 2523214 defendant Veske Simon (legal representative) 589706 589706 Veske, Simon, of Besthorp, yeoman, executors of 0
5568112 2525220 2525220 defendant Acton Thomas yeoman 589706 589706 Acton, Thomas, of Besthorp, yeoman 0
5616481 2548955 2548955 defendant Baxstere John   589706 589706 Baxstere, John, of Besthorp 0
5625922 2552060 2552060 defendant Veske William husbandman 589706 589706 Veske, William, of Besthorp, husbandman 0
5625923 2552060 2552060 defendant de Hoo Hugh husbandman 589706 589706 de Hoo, Hugh, of Besthorp, husbandman 1
5628041 2552741 2552741 defendant Bunne Richard husbandman 589706 589706 Bunne, Richard, of Besthorp, husbandman 3
5628042 2552741 2552741 defendant Pottere Richard husbandman 589706 589706 Pottere, Richard, of Besthorp, husbandman 4
5632358 2554153 2554153 plaintiff Stole William   589706 589706 Stole, William, of Besthorp 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);