names

190 rows where place_id = 589398

✎ 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
3597497 1866837 1866837 defendant Smyth alias Falyate Edmund husbandman 589398 589398 Smyth alias Falyate, Edmund, of Blofeld, husbandman 0
3599224 1867398 1867398 defendant Gilys John husbandman 589398 589398 Gilys, John, of Blofeld, husbandman 0
3599226 1867399 1867399 defendant Galle Thomas tailor 589398 589398 Galle, Thomas, of Blofeld, tailor 0
3599933 1867634 1867634 defendant Barker William chaplain 589398 589398 Barker, William, of Blofeld, chaplain 1
3602915 1868575 1868575 plaintiff Bernard John   589398 589398 Bernard, John, of Blofeld 2
3602917 1868575 1868575 defendant Bodyvaunt William yeoman 589398 589398 Bodyvaunt, William, of Blofeld, yeoman 0
3606652 1869754 1869754 defendant Hall John husbandman 589398 589398 Hall, John, of Blofeld, husbandman 2
3609413 1870605 1870605 defendant Eyer John butcher 589398 589398 Eyer, John, of Blofeld, butcher 3
3609535 1870644 1870644 plaintiff Bernard John   589398 589398 Bernard, John, of Blofeld 2
3609537 1870644 1870644 defendant Bodyvaunt William yeoman 589398 589398 Bodyvaunt, William, of Blofeld, yeoman 0
3617169 1872995 1872995 defendant Halle John husbandman 589398 589398 Halle, John, of Blofeld, husbandman 0
3623801 1874976 1874976 defendant Gyggys John, senior butcher 589398 589398 Gyggys, John, senior, of Blofeld, butcher 2
3623802 1874976 1874976 defendant Gyggys John, junior butcher 589398 589398 Gyggys, John, junior, of Blofeld, butcher 3
3625714 1875580 1875580 defendant Gyggys John, junior butcher 589398 589398 Gyggys, John, junior, of Blofeld, butcher 1
3633097 1905163 1905163 defendant Skynner John yeoman 589398 589398 Skynner, John, of Blofeld, yeoman 0
3644523 1908703 1908703 defendant Penteney John   589398 589398 Penteney, John, of Blofeld, shepherd 1
3670938 1916878 1916878 defendant Smyth alias Felgate John husbandman 589398 589398 Smyth alias Felgate, John, of Blofeld, husbandman 1
3717683 1931826 1931826 defendant Bysshopp John, junior husbandman 589398 589398 Bysshopp, John, junior, of Blofeld, husbandman 0
3720659 1932750 1932750 defendant Roper Richard chapman 589398 589398 Roper, Richard, of Blofeld, chapman 1
3748344 1941413 1941413 defendant Aunderson John smith 589398 589398 Aunderson, John, of Blofeld, smith 0
3787150 1953771 1953771 defendant Gyllys Thomas husbandman 589398 589398 Gyllys, Thomas, of Blofeld, husbandman 1
3791978 1955341 1955341 defendant Brightmere Robert husbandman 589398 589398 Brightmere, Robert, of Blofeld, husbandman 0
3835012 1968891 1968891 defendant Bryghtmere Robert husbandman 589398 589398 Bryghtmere, Robert, of Blofeld, husbandman 1
3852415 1974360 1974360 defendant Bryghtmere Robert husbandman 589398 589398 Bryghtmere, Robert, of Blofeld, husbandman 0
3853609 1974758 1974758 plaintiff Spencer Leonard gent 589398 589398 Spencer, Leonard, of Blofeld, gent 0
3861227 1977229 1977229 defendant Bysshopp John husbandman 589398 589398 Bysshopp, John, of Blofeld, husbandman 0
3862082 1977505 1977505 defendant Rowland Walter smith 589398 589398 Rowland, Walter, of Blofeld, smith 1
3868056 1979549 1979549 defendant Edon John husbandman 589398 589398 Edon, John, of Blofeld, husbandman 0
3890342 1987018 1987018 defendant Bussy John yeoman 589398 589398 Bussy, John, of Blofeld, yeoman 0
3909713 1993558 1993558 plaintiff Spratt Thomas husbandman 589398 589398 Spratt, Thomas, of Blofeld, husbandman 0
3909714 1993558 1993558 defendant Harryes Robert husbandman 589398 589398 Harryes, Robert, of Blofeld, husbandman 0
4159170 2081274 2081274 defendant Gamblyn John husbandman 589398 589398 Gamblyn, John, of Blofeld, husbandman 0
4161526 2082105 2082105 defendant Edwyn John tailor 589398 589398 Edwyn, John, of Blofeld, tailor 0
4161527 2082105 2082105 defendant Newman Thomas shoemaker 589398 589398 Newman, Thomas, of Blofeld, shoemaker 1
4161528 2082105 2082105 defendant Corbet Edmund sherman 589398 589398 Corbet, Edmund, of Blofeld, sherman 2
4182928 2089510 2089510 defendant Buddyvant John husbandman 589398 589398 Buddyvant, John, of Blofeld, husbandman 0
4221214 2102920 2102920 defendant Tolye John husbandman 589398 589398 Tolye, John, of Blofeld, husbandman 0
4336608 2142530 2142530 defendant Dennys Henry husbandman 589398 589398 Dennys, Henry, of Blofeld, husbandman 1
4351602 2147800 2147800 defendant Buttyvant Elias yeoman 589398 589398 Buttyvant, Elias, of Blofeld, yeoman 0
4354975 2148955 2148955 defendant Botyvant Elias yeoman 589398 589398 Botyvant, Elias, of Blofeld, yeoman 0
4395819 2163183 2163183 defendant Woodcocke William clerk 589398 589398 Woodcocke, William, of Blofeld, clerk 0
4436494 2176151 2176151 defendant atte Fen Henry   589398 589398 atte Fen, Henry, of Blofeld 1
4456469 2187043 2187043 defendant dod John   589398 589398 dod, John, of Blofeld 2
4456470 2187043 2187043 defendant Milham Edmund   589398 589398 Milham, Edmund, of Blofeld 3
4456472 2187043 2187043 defendant Wolman John   589398 589398 Wolman, John, of Blofeld 5
4458457 2187691 2187691 plaintiff Randolf Thomas   589398 589398 Randolf, Thomas, of Blofeld 0
4489515 2197442 2197442 defendant Dallyng John   589398 589398 Dallyng, John, of Blofeld 0
4500070 2200668 2200668 defendant Dallyng John   589398 589398 Dallyng, John, of Blofeld 0
4501938 2201206 2201206 defendant Cole Thomas   589398 589398 Cole, Thomas, of Blofeld 1
4504315 2201899 2201899 defendant Bailly Gilbert that-was-the   589398 589398 Bailly, Gilbert that-was-the, of Blofeld 9
4591841 2228803 2228803 defendant Snowe Andrew   589398 589398 Snowe, Andrew, of Blofeld 0
4594033 2229397 2229397 defendant Snowe Andrew   589398 589398 Snowe, Andrew, of Blofeld 2
4652027 2246567 2246567 defendant Snowe Andrew yeoman 589398 589398 Snowe, Andrew, of Blofeld, yeoman 1
4652030 2246568 2246568 defendant Snowe Andrew yeoman 589398 589398 Snowe, Andrew, of Blofeld, yeoman 1
4671280 2256670 2256670 defendant Snowe Andrew carpenter 589398 589398 Snowe, Andrew, of Blofeld, carpenter 3
4699441 2265283 2265283 defendant Buntyngford John yeoman 589398 589398 Buntyngford, John, of Blofeld, yeoman 0
4718114 2271005 2271005 defendant Hoo Thomas husbandman 589398 589398 Hoo, Thomas, of Blofeld, husbandman 7
4728393 2274116 2274116 defendant Therkyld John husbandman 589398 589398 Therkyld, John, of Blofeld, husbandman 0
4737670 2276889 2276889 defendant Chirche John husbandman 589398 589398 Chirche, John, of Blofeld, husbandman 3
4748245 2279995 2279995 defendant Kydman John yeoman 589398 589398 Kydman, John, of Blofeld, yeoman 2
4754995 2281946 2281946 defendant atte Chirche John clerk 589398 589398 atte Chirche, John, of Blofeld, clerk 1
4755258 2282033 2282033 defendant Snowe Andrew carpenter 589398 589398 Snowe, Andrew, of Blofeld, carpenter 0
4758972 2283158 2283158 defendant Snowe Andrew   589398 589398 Snowe, Andrew, of Blofeld, wright 1
4760799 2283715 2283715 plaintiff Bernham William   589398 589398 Bernham, William, of Blofeld, parson 1
4767944 2285946 2285946 defendant Dallyng Thomas husbandman 589398 589398 Dallyng, Thomas, of Blofeld, husbandman 1
4768822 2286226 2286226 defendant Goodewyn Vincent husbandman 589398 589398 Goodewyn, Vincent, of Blofeld, husbandman 1
4786467 2291814 2291814 defendant Colle Edmund husbandman 589398 589398 Colle, Edmund, of Blofeld, husbandman 3
4800772 2296428 2296428 defendant Petyte John husbandman 589398 589398 Petyte, John, of Blofeld, husbandman 2
4807560 2298558 2298558 plaintiff Cole Thomas (legal representative) 589398 589398 Cole, Thomas, of Blofeld, executor of 0
4835525 2307102 2307102 defendant Petit William husbandman 589398 589398 Petit, William, of Blofeld, husbandman 1
4838547 2307976 2307976 plaintiff Goodwyn Vincent husbandman 589398 589398 Goodwyn, Vincent, of Blofeld, husbandman 0
4839723 2308339 2308339 defendant Skynner William husbandman 589398 589398 Skynner, William, of Blofeld, husbandman 1
4863456 2315541 2315541 defendant Kydman John husbandman 589398 589398 Kydman, John, of Blofeld, husbandman 0
4874401 2318935 2318935 defendant Skynner William laborer 589398 589398 Skynner, William, of Blofeld, laborer 2
4900097 2326660 2326660 defendant Skynner William   589398 589398 Skynner, William, of Blofeld 5
4921124 2333123 2333123 plaintiff Kyddeman John   589398 589398 Kyddeman, John, of Blofeld 0
4921125 2333123 2333123 defendant Thurkeld John carpenter 589398 589398 Thurkeld, John, of Blofeld, carpenter 0
4921126 2333124 2333124 plaintiff Kyddeman John   589398 589398 Kyddeman, John, of Blofeld 0
4921127 2333124 2333124 defendant Thurkeld John carpenter 589398 589398 Thurkeld, John, of Blofeld, carpenter 0
4931068 2336109 2336109 defendant Dallyng Thomas husbandman 589398 589398 Dallyng, Thomas, of Blofeld, husbandman 2
4931069 2336109 2336109 defendant de Goolys John husbandman 589398 589398 de Goolys, John, of Blofeld, husbandman 3
4931969 2336386 2336386 defendant Dalllyng Thomas husbandman 589398 589398 Dalllyng, Thomas, of Blofeld, husbandman 0
4944892 2340393 2340393 defendant Dallyng Thomas husbandman 589398 589398 Dallyng, Thomas, of Blofeld, husbandman 2
4946641 2340949 2340949 plaintiff Kyddeman John   589398 589398 Kyddeman, John, of Blofeld 0
4946642 2340949 2340949 defendant Thurkeld John carpenter 589398 589398 Thurkeld, John, of Blofeld, carpenter 0
4984455 2352284 2352284 defendant Heye Thomas yeoman 589398 589398 Heye, Thomas, of Blofeld, yeoman 3
5003764 2357993 2357993 defendant Sylvester Thomas husbandman 589398 589398 Sylvester, Thomas, of Blofeld, husbandman 1
5003765 2357993 2357993 defendant Dallyng Thomas husbandman 589398 589398 Dallyng, Thomas, of Blofeld, husbandman 2
5016667 2361764 2361764 defendant Souter alias Skynner William yeoman 589398 589398 Souter alias Skynner, William, of Blofeld, yeoman 3
5046824 2370672 2370672 defendant Rydeman John husbandman 589398 589398 Rydeman, John, of Blofeld, husbandman 0
5049063 2371354 2371354 defendant Kydman John husbandman 589398 589398 Kydman, John, of Blofeld, husbandman 0
5051875 2372174 2372174 defendant Ranyngham John husbandman 589398 589398 Ranyngham, John, of Blofeld, husbandman 1
5061544 2375042 2375042 defendant Kydman John yeoman 589398 589398 Kydman, John, of Blofeld, yeoman 0
5068521 2377077 2377077 defendant Bakere Edmund yeoman 589398 589398 Bakere, Edmund, of Blofeld, yeoman 1
5115288 2390899 2390899 defendant Gilbert Henry husbandman 589398 589398 Gilbert, Henry, of Blofeld, husbandman 3
5116346 2391210 2391210 defendant Kydman John yeoman 589398 589398 Kydman, John, of Blofeld, yeoman 7
5128352 2394770 2394770 defendant Baker John husbandman 589398 589398 Baker, John, of Blofeld, husbandman 0
5128353 2394770 2394770 defendant Geffrey Edmund husbandman 589398 589398 Geffrey, Edmund, of Blofeld, husbandman 1
5135805 2396986 2396986 defendant Gilberd Henry husbandman 589398 589398 Gilberd, Henry, of Blofeld, husbandman 1
5136366 2397155 2397155 defendant B-- John yeoman 589398 589398 B--, John, of Blofeld, yeoman 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);