names

96 rows where place_id = 590819

✎ 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
3602404 1868413 1868413 defendant Maunsell John yeoman 590819 590819 Maunsell, John, of Bynbroke, yeoman 2
3608715 1870387 1870387 defendant Maunsfeld John draper 590819 590819 Maunsfeld, John, of Bynbroke, draper 4
3669535 1916409 1916409 defendant Twydale William yeoman 590819 590819 Twydale, William, of Bynbroke, yeoman 2
3676942 1918825 1918825 defendant Twydall William yeoman 590819 590819 Twydall, William, of Bynbroke, yeoman 2
3774653 1949801 1949801 defendant Thistilton Robert husbandman 590819 590819 Thistilton, Robert, of Bynbroke, husbandman 1
3800344 1958026 1958026 defendant Thistilton Robert husbandman 590819 590819 Thistilton, Robert, of Bynbroke, husbandman 1
3826233 1966052 1966052 defendant Stanes Thomas husbandman 590819 590819 Stanes, Thomas, of Bynbroke, husbandman 0
3839594 1970307 1970307 defendant Foster Christopher husbandman 590819 590819 Foster, Christopher, of Bynbroke, husbandman 0
3839595 1970307 1970307 defendant Ibry Thomas husbandman 590819 590819 Ibry, Thomas, of Bynbroke, husbandman 1
3852618 1974425 1974425 defendant Beche Robert yeoman 590819 590819 Beche, Robert, of Bynbroke, yeoman 0
3897249 1989296 1989296 defendant Curtays Edward husbandman 590819 590819 Curtays, Edward, of Bynbroke, husbandman 0
4003054 2025856 2025856 defendant Goodhand Francis gent 590819 590819 Goodhand, Francis, of Bynbroke, gent 0
4090639 2056939 2056939 defendant Gregbye Thomas, senior yeoman 590819 590819 Gregbye, Thomas, senior, of Bynbroke, yeoman 0
4090640 2056939 2056939 defendant Gregby John yeoman 590819 590819 Gregby, John, of Bynbroke, yeoman 1
4113930 2065266 2065266 defendant Chapman John husbandman 590819 590819 Chapman, John, of Bynbroke, husbandman 0
4125428 2069375 2069375 defendant Gregbey James husbandman 590819 590819 Gregbey, James, of Bynbroke, husbandman 0
4162723 2082517 2082517 defendant Gregby James yeoman 590819 590819 Gregby, James, of Bynbroke, yeoman 1
4177030 2087439 2087439 defendant Scamelsbye Thomas husbandman 590819 590819 Scamelsbye, Thomas, of Bynbroke, husbandman 0
4280618 2123127 2123127 defendant Johnson John yeoman 590819 590819 Johnson, John, of Bynbroke, yeoman 3
4441611 2182311 2182311 defendant Boynton Richard de   590819 590819 Boynton, Richard de, of Bynbroke 0
4459291 2187954 2187954 defendant Boynton Richard de   590819 590819 Boynton, Richard de, of Bynbroke, parson 0
4463133 2189170 2189170 plaintiff Tray Joan   590819 590819 Tray, Joan, of Bynbroke 0
4463134 2189170 2189170 defendant B--- William   590819 590819 B---, William, of Bynbroke 0
4501730 2201141 2201141 defendant Hanley William   590819 590819 Hanley, William, of Bynbroke 2
4505075 2202119 2202119 plaintiff Sibill John   590819 590819 Sibill, John, of Bynbroke 0
4554804 2217429 2217429 defendant Smyth atte Grene John   590819 590819 Smyth atte Grene, John, of Bynbroke 0
4554806 2217430 2217430 defendant Warde John chaplain 590819 590819 Warde, John, of Bynbroke, chaplain 0
4565073 2220647 2220647 defendant Daweson William   590819 590819 Daweson, William, of Bynbroke 0
4598942 2230891 2230891 defendant Walker John   590819 590819 Walker, John, of Bynbroke 1
4623140 2238213 2238213 plaintiff Mason Nicholas   590819 590819 Mason, Nicholas, of Bynbroke 0
4663372 2250016 2250016 defendant Hoggesson John walker 590819 590819 Hoggesson, John, of Bynbroke, walker 0
4664023 2250233 2250233 defendant Mason Nicholas   590819 590819 Mason, Nicholas, of Bynbroke, mason 0
4668187 2255759 2255759 defendant atte Prestes Thomas husbandman 590819 590819 atte Prestes, Thomas, of Bynbroke, husbandman 2
4674363 2257589 2257589 defendant Walker William walker 590819 590819 Walker, William, of Bynbroke, walker 0
4706936 2267548 2267548 defendant Fox William husbandman 590819 590819 Fox, William, of Bynbroke, husbandman 0
4716794 2270578 2270578 defendant Fox William husbandman 590819 590819 Fox, William, of Bynbroke, husbandman 0
4728359 2274107 2274107 defendant Grene Peter   590819 590819 Grene, Peter, of Bynbroke, shepherd 0
4729909 2274562 2274562 defendant Gybonson John husbandman 590819 590819 Gybonson, John, of Bynbroke, husbandman 0
4748029 2279935 2279935 defendant Gybunson John husbandman 590819 590819 Gybunson, John, of Bynbroke, husbandman 0
4748030 2279935 2279935 defendant Yoole Richard husbandman 590819 590819 Yoole, Richard, of Bynbroke, husbandman 1
4751431 2280901 2280901 defendant Sybell John husbandman 590819 590819 Sybell, John, of Bynbroke, husbandman 0
4754446 2281770 2281770 plaintiff Wyse William   590819 590819 Wyse, William, of Bynbroke 0
4779279 2289498 2289498 defendant Fox John husbandman 590819 590819 Fox, John, of Bynbroke, husbandman 0
4810902 2299527 2299527 defendant Fox William husbandman 590819 590819 Fox, William, of Bynbroke, husbandman 3
4811106 2299583 2299583 defendant Bekke John husbandman 590819 590819 Bekke, John, of Bynbroke, husbandman 0
4812645 2300073 2300073 defendant Fox William husbandman 590819 590819 Fox, William, of Bynbroke, husbandman 0
4812648 2300073 2300073 defendant Bek John husbandman 590819 590819 Bek, John, of Bynbroke, husbandman 3
4850004 2311472 2311472 defendant Hamsterley Thomas gent 590819 590819 Hamsterley, Thomas, of Bynbroke, gent 0
4868372 2317083 2317083 defendant Warde John husbandman 590819 590819 Warde, John, of Bynbroke, husbandman 0
4868373 2317083 2317083 defendant Smyth John husbandman 590819 590819 Smyth, John, of Bynbroke, husbandman 1
4868374 2317083 2317083 defendant Frankyssh John husbandman 590819 590819 Frankyssh, John, of Bynbroke, husbandman 2
4868375 2317083 2317083 defendant Sibill John, senior husbandman 590819 590819 Sibill, John, senior, of Bynbroke, husbandman 3
4868376 2317083 2317083 defendant Misden William husbandman 590819 590819 Misden, William, of Bynbroke, husbandman 4
4868377 2317083 2317083 defendant Davy John tailor 590819 590819 Davy, John, of Bynbroke, tailor 5
4868378 2317083 2317083 defendant Fermour William chapman 590819 590819 Fermour, William, of Bynbroke, chapman 6
4868379 2317083 2317083 defendant Hede Thomas laborer 590819 590819 Hede, Thomas, of Bynbroke, laborer 7
4868380 2317083 2317083 defendant Boket Thomas husbandman 590819 590819 Boket, Thomas, of Bynbroke, husbandman 8
4868381 2317083 2317083 defendant Camage Robert husbandman 590819 590819 Camage, Robert, of Bynbroke, husbandman 9
4868382 2317083 2317083 defendant Sotherby William husbandman 590819 590819 Sotherby, William, of Bynbroke, husbandman 10
4868383 2317083 2317083 defendant Smyth William husbandman 590819 590819 Smyth, William, of Bynbroke, husbandman 11
4868384 2317083 2317083 defendant Fox William husbandman 590819 590819 Fox, William, of Bynbroke, husbandman 12
4868385 2317083 2317083 defendant Bekke John husbandman 590819 590819 Bekke, John, of Bynbroke, husbandman 13
4868386 2317083 2317083 defendant Ivre John husbandman 590819 590819 Ivre, John, of Bynbroke, husbandman 14
4868387 2317083 2317083 defendant Beche Robert flesshewer or butcher 590819 590819 Beche, Robert, of Bynbroke, flesshewer or butcher 15
4878068 2320092 2320092 defendant Hamsterley John gent 590819 590819 Hamsterley, John, of Bynbroke, gent 0
4886061 2322499 2322499 defendant Fox William husbandman 590819 590819 Fox, William, of Bynbroke, husbandman 0
4888253 2323133 2323133 defendant Hamsterlay John   590819 590819 Hamsterlay, John, of Bynbroke, gent, administrators of 0
4888254 2323133 2323133 defendant Davy John tailor 590819 590819 (Davy, John, of Bynbroke, tailor 1
4888255 2323133 2323133 defendant Stoleslay Thomas husbandman 590819 590819 Stoleslay, Thomas, of Bynbroke, husbandman 2
4891564 2324100 2324100 defendant Fox William husbandman 590819 590819 Fox, William, of Bynbroke, husbandman 0
4936656 2337850 2337850 defendant Aweneby Richard husbandman 590819 590819 Aweneby, Richard, of Bynbroke, husbandman 0
4936657 2337850 2337850 defendant Aweneby William husbandman 590819 590819 Aweneby, William, of Bynbroke, husbandman 1
5059006 2374258 2374258 defendant Bek John, senior husbandman 590819 590819 Bek, John, senior, of Bynbroke, husbandman 0
5109005 2389050 2389050 defendant Fox William husbandman 590819 590819 Fox, William, of Bynbroke, husbandman 0
5286310 2441002 2441002 defendant Fermer Robert husbandman 590819 590819 Fermer, Robert, of Bynbroke, husbandman 2
5286311 2441002 2441002 defendant Sotby William husbandman 590819 590819 Sotby, William, of Bynbroke, husbandman 3
5286312 2441002 2441002 defendant Ivry or Ibry Walter husbandman 590819 590819 Ivry or Ibry, Walter, of Bynbroke, husbandman 4
5286313 2441002 2441002 defendant Lovell Richard husbandman 590819 590819 Lovell, Richard, of Bynbroke, husbandman 5
5298947 2444672 2444672 defendant Botyvaunt William husbandman 590819 590819 Botyvaunt, William, of Bynbroke, husbandman 0
5317435 2450298 2450298 defendant Alygar William husbandman or wright 590819 590819 Alygar, William, of Bynbroke, husbandman or wright 1
5336023 2455848 2455848 defendant Skelton John husbandman 590819 590819 Skelton, John, of Bynbroke, husbandman 1
5491299 2502287 2502287 defendant Maunsell John yeoman 590819 590819 Maunsell, John, of Bynbroke, yeoman 0
5495283 2503486 2503486 defendant Haward Nicholas husbandman 590819 590819 Haward, Nicholas, of Bynbroke, husbandman 1
5495284 2503486 2503486 defendant Massam John husbandman 590819 590819 Massam, John, of Bynbroke, husbandman 2
5497208 2504104 2504104 defendant Tateham Oliver yeoman 590819 590819 Tateham, Oliver, of Bynbroke, yeoman 0
5497209 2504104 2504104 defendant Curtas Henry yeoman 590819 590819 Curtas, Henry, of Bynbroke, yeoman 1
5497210 2504104 2504104 defendant Ivre or Jure Robert husbandman 590819 590819 Ivre or Jure, Robert, of Bynbroke, husbandman 2
5497211 2504104 2504104 defendant Ivre or Jure Walter husbandman 590819 590819 Ivre or Jure, Walter, of Bynbroke, husbandman 3
5497212 2504104 2504104 defendant Soteby Thomas husbandman 590819 590819 Soteby, Thomas, of Bynbroke, husbandman 4
5497213 2504104 2504104 defendant Daystern Thomas husbandman 590819 590819 Daystern, Thomas, of Bynbroke, husbandman 5
5497214 2504104 2504104 defendant Bruse or Bense William husbandman 590819 590819 Bruse or Bense, William, of Bynbroke, husbandman 6
5497216 2504105 2504105 defendant Wilson Robert husbandman 590819 590819 Wilson, Robert, of Bynbroke, husbandman 0
5497217 2504105 2504105 defendant Shipman William husbandman 590819 590819 Shipman, William, of Bynbroke, husbandman 1
5497218 2504105 2504105 defendant Wilson Brian husbandman 590819 590819 Wilson, Brian, of Bynbroke, husbandman 2
5497219 2504105 2504105 defendant Ibre William husbandman 590819 590819 Ibre, William, of Bynbroke, husbandman 3
5525332 2512514 2512514 defendant Curtes William chaplain 590819 590819 Curtes, William, of Bynbroke, chaplain 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);