names

135 rows where place_id = 587063

✎ 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
3590360 1864625 1864625 defendant Manser Christopher yeoman 587063 587063 Manser, Christopher, of Totenham, yeoman 1
3593542 1865614 1865614 defendant Smyth alias Vynt William smith or yeoman 587063 587063 Smyth alias Vynt, William, of Totenham, smith or yeoman 0
3608999 1870471 1870471 defendant Wheler William laborer 587063 587063 Wheler, William, of Totenham, laborer 2
3632770 1905063 1905063 defendant Savage John gent 587063 587063 Savage, John, of Totenham, gent 2
3633084 1905159 1905159 defendant More alias Amowre Thomas yeoman 587063 587063 More alias Amowre, Thomas, of Totenham, yeoman 2
3633560 1905307 1905307 defendant Pakyngton John tailor 587063 587063 Pakyngton, John, of Totenham, tailor 0
3637105 1906405 1906405 defendant Pake John butcher 587063 587063 Pake, John, of Totenham, butcher 0
3650009 1910370 1910370 defendant Pate John butcher 587063 587063 Pate, John, of Totenham, butcher 0
3651992 1910970 1910970 defendant Edryche Richard yeoman 587063 587063 Edryche, Richard, of Totenham, yeoman 0
3677001 1918844 1918844 defendant Pate John (legal representative) 587063 587063 Pate, John, of Totenham, butcher, executors of 1
3677002 1918844 1918844 defendant A More Thomas yeoman 587063 587063 (A More, Thomas, of Totenham, yeoman 2
3699134 1925939 1925939 defendant Whytyngton Christopher brewer 587063 587063 Whytyngton, Christopher, of Totenham, brewer 0
3699484 1926069 1926069 defendant Whityngton Christopher brewer 587063 587063 Whityngton, Christopher, of Totenham, brewer 0
3699486 1926070 1926070 defendant Whityngton Christopher brewer 587063 587063 Whityngton, Christopher, of Totenham, brewer 0
3719880 1932488 1932488 plaintiff Hennyngham George gent 587063 587063 Hennyngham, George, of Totenham, gent 0
3719882 1932489 1932489 plaintiff Hennyngham George gent 587063 587063 Hennyngham, George, of Totenham, gent 0
3784031 1952784 1952784 defendant Boterell Thomas gent 587063 587063 Boterell, Thomas, of Totenham, gent 0
3866323 1978969 1978969 defendant Castell George butcher 587063 587063 Castell, George, of Totenham, butcher 0
4436354 2176106 2176106 defendant Muleward John le   587063 587063 Muleward, John le, of Totenham 0
4462956 2189113 2189113 defendant Hoggekyn John   587063 587063 Hoggekyn, John, of Totenham 0
4504271 2201889 2201889 defendant Taillour Thomas   587063 587063 Taillour, Thomas, of Totenham 0
4557483 2218277 2218277 plaintiff Lane Richard   587063 587063 Lane, Richard, of Totenham 0
4569011 2221892 2221892 plaintiff Wakefeld John   587063 587063 Wakefeld, John, of Totenham 1
4689192 2262178 2262178 defendant Stokes John yeoman 587063 587063 Stokes, John, of Totenham, yeoman 0
4781854 2290340 2290340 defendant Dacre John husbandman 587063 587063 Dacre, John, of Totenham, husbandman 1
4781855 2290340 2290340 defendant Sewall John smith 587063 587063 Sewall, John, of Totenham, smith 2
4785775 2291588 2291588 defendant Dymbyll Richard husbandman 587063 587063 Dymbyll, Richard, of Totenham, husbandman 0
4788146 2292365 2292365 defendant Duke Henry husbandman 587063 587063 Duke, Henry, of Totenham, husbandman 3
4788151 2292366 2292366 defendant Duke Henry husbandman 587063 587063 Duke, Henry, of Totenham, husbandman 3
4789974 2292940 2292940 defendant Burton John gent 587063 587063 Burton, John, of Totenham, gent 0
4789975 2292940 2292940 defendant Cacher John husbandman 587063 587063 together with Cacher, John, of Totenham, husbandman 1
4789976 2292940 2292940 defendant Chestre Thomas husbandman 587063 587063 Chestre, Thomas, of Totenham, husbandman 2
4881096 2320997 2320997 plaintiff William Geoffrey   587063 587063 William, Geoffrey, of Totenham 0
4891546 2324093 2324093 defendant Williamson Geoffrey yeoman 587063 587063 Williamson, Geoffrey, of Totenham, yeoman 1
4893415 2324643 2324643 defendant Burrelll John laborer 587063 587063 Burrelll, John, of Totenham, laborer 0
4896297 2325505 2325505 defendant Williamson Geoffrey husbandman 587063 587063 Williamson, Geoffrey, of Totenham, husbandman 0
4916958 2331807 2331807 defendant Stubbe John carpenter 587063 587063 Stubbe, John, of Totenham, carpenter 0
4932490 2336557 2336557 plaintiff William Geoffrey   587063 587063 William, Geoffrey, of Totenham, on his own account 0
4932491 2336557 2336557 defendant Bonser William butcher 587063 587063 Bonser, William, of Totenham, butcher 0
4932494 2336557 2336557 defendant Hyde John husbandman 587063 587063 Hyde, John, of Totenham, husbandman 3
4932495 2336557 2336557 defendant Botell John husbandman 587063 587063 Botell, John, of Totenham, husbandman 4
4935229 2337419 2337419 defendant Stokes Robert husbandman 587063 587063 Stokes, Robert, of Totenham, husbandman 1
4935233 2337420 2337420 defendant Stokes Robert husbandman 587063 587063 Stokes, Robert, of Totenham, husbandman 1
4935239 2337423 2337423 defendant Hever Thomas carpenter 587063 587063 Hever, Thomas, of Totenham, carpenter 0
4936590 2337827 2337827 defendant Slatton William husbandman 587063 587063 Slatton, William, of Totenham, husbandman 0
4936592 2337828 2337828 defendant Slatton William husbandman 587063 587063 Slatton, William, of Totenham, husbandman 0
4936594 2337829 2337829 defendant Cheseman John husbandman 587063 587063 Cheseman, John, of Totenham, husbandman 0
4936597 2337829 2337829 defendant Levyng John husbandman 587063 587063 Levyng, John, of Totenham, husbandman 3
4936602 2337830 2337830 defendant Levyng John husbandman 587063 587063 Levyng, John, of Totenham, husbandman 3
4942850 2339735 2339735 defendant Bristowe John husbandman 587063 587063 Bristowe, John, of Totenham, husbandman 0
4968342 2347495 2347495 defendant Bristowe John husbandman 587063 587063 Bristowe, John, of Totenham, husbandman 0
4968347 2347497 2347497 defendant William Geoffrey husbandman 587063 587063 William, Geoffrey, of Totenham, husbandman 0
4984389 2352262 2352262 plaintiff William Geoffrey   587063 587063 William, Geoffrey, of Totenham 0
4995308 2355440 2355440 defendant Fuller William carpenter 587063 587063 Fuller, William, of Totenham, carpenter 0
5016963 2361857 2361857 defendant Lunt John barber 587063 587063 Lunt, John, of Totenham, barber 0
5039810 2368550 2368550 defendant Rowe William miller 587063 587063 Rowe, William, of Totenham, miller 2
5058271 2374027 2374027 defendant Williamson Geoffrey yeoman 587063 587063 Williamson, Geoffrey, of Totenham, yeoman 3
5070387 2377636 2377636 defendant Mannewyk John yeoman 587063 587063 Mannewyk, John, of Totenham, yeoman 0
5072851 2378362 2378362 defendant William Geoffrey husbandman 587063 587063 William, Geoffrey, of Totenham, husbandman 0
5074418 2378853 2378853 defendant Doun Richard yeoman 587063 587063 Doun, Richard, of Totenham, yeoman 0
5074420 2378853 2378853 defendant Johnson Robert butcher 587063 587063 Johnson, Robert, of Totenham, butcher 2
5074421 2378853 2378853 defendant Edward John laborer 587063 587063 Edward, John, of Totenham, laborer 3
5074422 2378853 2378853 defendant Bristowe John yeoman 587063 587063 Bristowe, John, of Totenham, or of Attiwugh, Norf, yeoman 4
5084549 2381892 2381892 defendant Mordemoure Robert   587063 587063 Mordemoure, Robert, of Totenham 0
5084551 2381893 2381893 defendant Slapton William   587063 587063 Slapton, William, of Totenham 0
5131927 2395822 2395822 defendant Combe John husbandman 587063 587063 Combe, John, of Totenham, husbandman 1
5137119 2397371 2397371 defendant Pave John husbandman 587063 587063 Pave, John, of Totenham, husbandman 0
5137120 2397371 2397371 defendant Bocher John butcher 587063 587063 Bocher, John, of Totenham, butcher 1
5137121 2397371 2397371 defendant Gippe John husbandman 587063 587063 Gippe, John, of Totenham, husbandman 2
5137130 2397372 2397372 defendant Sutton Richard   587063 587063 Sutton, Richard, of Totenham, minstrel 0
5137806 2397567 2397567 defendant Clerke Edmund husbandman 587063 587063 Clerke, Edmund, of Totenham, husbandman 0
5137807 2397567 2397567 defendant Rowe John fuller 587063 587063 Rowe, John, of Totenham, fuller 1
5149637 2401023 2401023 defendant Smyth Geoffrey smith 587063 587063 Smyth, Geoffrey, of Totenham, smith 0
5149638 2401023 2401023 defendant Butte William laborer 587063 587063 Butte, William, of Totenham, laborer 1
5149639 2401023 2401023 defendant Butte John laborer 587063 587063 Butte, John, of Totenham, laborer 2
5149642 2401024 2401024 defendant Butte John   587063 587063 Butte, John, of Totenham, holy water clerk 0
5149643 2401024 2401024 defendant Clerk Edmund laborer 587063 587063 Clerk, Edmund, of Totenham, laborer 1
5149644 2401024 2401024 defendant Bistowe Emma widow 587063 587063 Bistowe, Emma, of Totenham, widow 2
5149645 2401024 2401024 defendant Gyggys John yeoman 587063 587063 Gyggys, John, of Totenham, yeoman 3
5158485 2403603 2403603 defendant Clerke Edmund husbandman 587063 587063 Clerke, Edmund, of Totenham, husbandman 0
5158486 2403603 2403603 defendant Rowe John fuller 587063 587063 Rowe, John, of Totenham, fuller 1
5158488 2403604 2403604 defendant Clerke Edmund husbandman 587063 587063 Clerke, Edmund, of Totenham, husbandman 0
5158489 2403604 2403604 defendant Rowe John fuller 587063 587063 Rowe, John, of Totenham, fuller 1
5168515 2406506 2406506 defendant Bystowe Emma widow 587063 587063 Bystowe, Emma, of Totenham, widow 2
5205944 2417473 2417473 defendant Ederych Thomas husbandman 587063 587063 Ederych, Thomas, of Totenham, husbandman 4
5214905 2420079 2420079 defendant Heyward William smith 587063 587063 Heyward, William, of Totenham, smith 0
5221946 2422123 2422123 defendant Yon or You John husbandman 587063 587063 Yon or You, John, of Totenham, husbandman 0
5221948 2422123 2422123 defendant Playter John laborer 587063 587063 Playter, John, of Totenham, laborer 2
5225760 2423205 2423205 defendant Rede Hugh husbandman 587063 587063 Rede, Hugh, of Totenham, husbandman 0
5225763 2423206 2423206 defendant Rede Hugh husbandman 587063 587063 Rede, Hugh, of Totenham, husbandman 0
5231815 2424877 2424877 defendant Henyngham Thomas yeoman 587063 587063 Henyngham, Thomas, of Totenham, yeoman 2
5231816 2424877 2424877 defendant Confesse John baker 587063 587063 Confesse, John, of Totenham, baker 3
5232108 2424963 2424963 defendant Hale John husbandman 587063 587063 Hale, John, of Totenham, husbandman 2
5240902 2427545 2427545 plaintiff Kynge John Gent 587063 587063 Kynge, John, of Totenham, Gent 0
5294615 2443404 2443404 defendant Drayton William gent 587063 587063 Drayton, William, of Totenham, gent 1
5302724 2445795 2445795 defendant Wheler Thomas husbandman 587063 587063 Wheler, Thomas, of Totenham, husbandman 0
5306828 2447038 2447038 defendant Isabell John yeoman 587063 587063 Isabell, John, of Totenham, yeoman 0
5310810 2448270 2448270 defendant Edryche William husbandman 587063 587063 Edryche, William, of Totenham, husbandman 0
5310814 2448270 2448270 defendant Heyward John husbandman 587063 587063 Heyward, John, of Totenham, husbandman 4
5326636 2453036 2453036 defendant Stubbe Thomas husbandman 587063 587063 Stubbe, Thomas, of Totenham, husbandman 1

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);