names

103 rows where place_id = 585881

✎ 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
3587412 1863708 1863708 defendant Twichener John draper 585881 585881 Twichener, John, of Wokyngham, Berks, draper 1
3588433 1864031 1864031 defendant Mychell John   585881 585881 Mychell, John, of Wokyngham, Berks, bell founder 0
3588435 1864032 1864032 defendant Mychell John   585881 585881 Mychell, John, of Wokyngham, Berks, bell founder 0
3608028 1870162 1870162 defendant Norbrigge Edmund clothier 585881 585881 Norbrigge, Edmund, of Wokyngham, Berks, clothier 1
3608354 1870271 1870271 defendant Wattes Richard clothmaker 585881 585881 Wattes, Richard, of Wokyngham, Berks, clothmaker 0
3641556 1907818 1907818 defendant Wattys Richard innholder 585881 585881 Wattys, Richard, of Wokyngham, Berks, innholder 0
3879960 1983556 1983556 plaintiff Palmer William clothier 585881 585881 Palmer, William, of Wokyngham, Berks, clothier 0
3900599 1990430 1990430 defendant Myll Thomas hosier 585881 585881 Myll, Thomas, of Wokyngham, Berks, hosier 0
3902532 1991082 1991082 defendant Michell Fowke bellfounder 585881 585881 Michell, Fowke, of Wokyngham, Berks, bellfounder 0
4652723 2246787 2246787 defendant atte Hethe Thomas husbandman 585881 585881 atte Hethe, Thomas, of Wokyngham, Berks, husbandman 0
4697876 2264830 2264830 defendant Symmet John chapman 585881 585881 Symmet, John, of Wokyngham, Berks, chapman 2
4697897 2264835 2264835 defendant Symmet John chapman 585881 585881 Symmet, John, of Wokyngham, Berks, chapman 1
4701856 2265984 2265984 defendant Wikeham John chaplain 585881 585881 Wikeham, John, of Wokyngham, Berks, chaplain 1
4701860 2265986 2265986 defendant Wykeham John chaplain 585881 585881 Wykeham, John, of Wokyngham, Berks, chaplain 0
4702373 2266152 2266152 defendant Symmnet John chapman 585881 585881 Symmnet, John, of Wokyngham, Berks, chapman 1
4730709 2274802 2274802 defendant Carter Felicity widow 585881 585881 Carter, Felicity, of Wokyngham, Berks, widow 2
4738308 2277076 2277076 defendant Ladde Richard yeoman 585881 585881 Ladde, Richard, of Wokyngham, Berks, yeoman 0
4874078 2318834 2318834 defendant Beche Robert gent 585881 585881 Beche, Robert, of Wokyngham, Berks, gent 0
4876108 2319488 2319488 defendant James Nicholas chaplain 585881 585881 James, Nicholas, of Wokyngham, Berks, chaplain 0
4889791 2323600 2323600 defendant Clerk Thomas husbandman 585881 585881 Clerk, Thomas, of Wokyngham, Berks, husbandman 0
4923382 2333739 2333739 defendant Zenenden Robert husbandman 585881 585881 Zenenden, Robert, of Wokyngham, Berks, husbandman 0
4967713 2347289 2347289 defendant Hogham John gent 585881 585881 Hogham, John, of Wokyngham, Berks, gent 0
4983125 2351854 2351854 defendant Everard Henry husbandman 585881 585881 Everard, Henry, of Wokyngham, Berks, husbandman 10
4994329 2355178 2355178 defendant Ogham John gent 585881 585881 Ogham, John, of Wokyngham, Berks, gent 1
5003178 2357832 2357832 defendant Ongham John gent 585881 585881 Ongham, John, of Wokyngham, Berks, gent 0
5003185 2357833 2357833 defendant Ougham John gent 585881 585881 Ougham, John, of Wokyngham, Berks, gent 0
5010573 2359966 2359966 defendant Reynold William gent 585881 585881 Reynold, William, of Wokyngham, Berks, gent 1
5010717 2359996 2359996 defendant Smyth John chaplain 585881 585881 Smyth, John, of Wokyngham, Berks, chaplain 0
5010723 2359997 2359997 defendant Smyth John chaplain 585881 585881 Smyth, John, of Wokyngham, Berks, chaplain 0
5021914 2363303 2363303 defendant Brocas Bernard esq 585881 585881 Brocas, Bernard, of Wokyngham, Berks, esq 2
5029918 2365621 2365621 defendant Ongham John gent 585881 585881 Ongham, John, of Wokyngham, Berks, gent 2
5083685 2381621 2381621 defendant Wodstoke John yeoman 585881 585881 Wodstoke, John, of Wokyngham, Berks, yeoman 0
5100307 2386535 2386535 defendant Landen Roger bellfounder 585881 585881 Landen, Roger, of Wokyngham, Berks, bellfounder 0
5105235 2387971 2387971 defendant Sherman Richard husbandman 585881 585881 Sherman, Richard, of Wokyngham, Berks, husbandman 0
5110634 2389509 2389509 defendant Body Richard chapman 585881 585881 Body, Richard, of Wokyngham, Berks, chapman 2
5131106 2395588 2395588 defendant Lande Roger   585881 585881 Lande, Roger, of Wokyngham, Berks, bell maker 0
5150612 2401325 2401325 defendant Landen Robert   585881 585881 Landen, Robert, of Wokyngham, Berks, bell maker 0
5150614 2401326 2401326 defendant Lauden Roger   585881 585881 Lauden, Roger, of Wokyngham, Berks, bell maker 0
5153368 2402137 2402137 defendant Honour Stephen merchant 585881 585881 Honour, Stephen, of Wokyngham, Berks, merchant 4
5170812 2407185 2407185 defendant Triplard John smith 585881 585881 Triplard, John, of Wokyngham, Berks, smith 1
5170815 2407185 2407185 defendant Honour Stephen merchant 585881 585881 Honour, Stephen, of Wokyngham, Berks, merchant 4
5182472 2410629 2410629 defendant Landen Roger   585881 585881 Landen, Roger, of Wokyngham, Berks, bell maker 1
5182478 2410630 2410630 defendant Landen Roger   585881 585881 Landen, Roger, of Wokyngham, Berks, bell maker 1
5185532 2411519 2411519 defendant Mychell John   585881 585881 Mychell, John, of Wokyngham, Berks, bell maker 0
5185539 2411521 2411521 defendant Mychall John   585881 585881 Mychall, John, of Wokyngham, Berks, bell maker 1
5185542 2411522 2411522 defendant Mychell John   585881 585881 Mychell, John, of Wokyngham, Berks, bell maker 0
5188824 2412461 2412461 defendant Treplard John smith 585881 585881 Treplard, John, of Wokyngham, Berks, smith 1
5188827 2412461 2412461 defendant Honour Stpeh merchant 585881 585881 Honour, Stpeh, of Wokyngham, Berks, merchant 4
5189806 2412765 2412765 defendant Westwode Thomas chapman 585881 585881 Westwode, Thomas, of Wokyngham, Berks, chapman 4
5189812 2412766 2412766 defendant Westwode Thomas chapman 585881 585881 Westwode, Thomas, of Wokyngham, Berks, chapman 4
5196053 2414593 2414593 defendant Hacche William chapman 585881 585881 Hacche, William, of Wokyngham, Berks, chapman 0
5196056 2414594 2414594 defendant Hacche William chapman 585881 585881 Hacche, William, of Wokyngham, Berks, chapman 0
5200245 2415833 2415833 plaintiff Wodestoke John gent 585881 585881 Wodestoke, John, of Wokyngham, Berks, gent 0
5204822 2417162 2417162 defendant Laidon Roger   585881 585881 Laidon, Roger, of Wokyngham, Berks, bell maker 0
5204824 2417163 2417163 defendant Mychell John   585881 585881 Mychell, John, of Wokyngham, Berks, bell maker 0
5206663 2417685 2417685 defendant Westwode Thomas chapman 585881 585881 Westwode, Thomas, of Wokyngham, Berks, chapman 4
5206669 2417686 2417686 defendant Westwode Thomas chapman 585881 585881 Westwode, Thomas, of Wokyngham, Berks, chapman 4
5209495 2418517 2418517 defendant Hacche Willai chapman 585881 585881 Hacche, Willai, of Wokyngham, Berks, chapman 0
5209498 2418518 2418518 defendant Hacche William chapman 585881 585881 Hacche, William, of Wokyngham, Berks, chapman 0
5209501 2418519 2418519 defendant Hacche William chapman 585881 585881 Hacche, William, of Wokyngham, Berks, chapman 0
5215726 2420325 2420325 defendant Tryplard John smith 585881 585881 Tryplard, John, of Wokyngham, Berks, smith 0
5217909 2420971 2420971 defendant Landen Roger bellmaker 585881 585881 Landen, Roger, of Wokyngham, Berks, bellmaker 0
5227537 2423678 2423678 defendant Tryplad John smith 585881 585881 Tryplad, John, of Wokyngham, Berks, smith 3
5233773 2425465 2425465 defendant Landen Roger   585881 585881 Landen, Roger, of Wokyngham, Berks, bell maker 1
5237241 2426476 2426476 defendant Landen Roger bellmaker 585881 585881 Landen, Roger, of Wokyngham, Berks, bellmaker 0
5239939 2427257 2427257 defendant Nasshe Thomas tanner 585881 585881 Nasshe, Thomas, of Wokyngham, Berks, tanner 3
5259058 2432949 2432949 defendant Landon Roger bellfounder 585881 585881 Landon, Roger, of Wokyngham, Berks, bellfounder 2
5259063 2432950 2432950 defendant Landen Roger bellfounder 585881 585881 Landen, Roger, of Wokyngham, Berks, bellfounder 3
5273949 2437459 2437459 defendant Bayly Thomas chapman 585881 585881 Bayly, Thomas, of Wokyngham, Berks, chapman 3
5354591 2461512 2461512 defendant Myles John chapman 585881 585881 Myles, John, of Wokyngham, Berks, chapman 1
5371421 2466642 2466642 defendant Mychell John   585881 585881 Mychell, John, of Wokyngham, Berks, bell founder 0
5380425 2469450 2469450 defendant Michell John   585881 585881 Michell, John, of Wokyngham, Berks, bell maker 1
5380432 2469452 2469452 defendant Michell John   585881 585881 Michell, John, of Wokyngham, Berks, bell maker 1
5380435 2469453 2469453 defendant Michell John belmaker 585881 585881 Michell, John, of Wokyngham, Berks, belmaker 1
5382288 2469993 2469993 defendant Mathew John gent 585881 585881 (Mathew, John, of Wokyngham, Berks, gent 3
5384991 2470781 2470781 defendant Michell John   585881 585881 Michell, John, of Wokyngham, Berks, bell maker 1
5384994 2470782 2470782 defendant Michell John   585881 585881 Michell, John, of Wokyngham, Berks, bell maker 1
5405801 2476730 2476730 defendant Lane Robert clothier 585881 585881 Lane, Robert, of Wokyngham, Berks, clothier 1
5409405 2477779 2477779 defendant Horwode Hugh dyer 585881 585881 Horwode, Hugh, of Wokyngham, Berks, dyer 1
5409412 2477780 2477780 defendant Horwode Hugh dyer 585881 585881 Horwode, Hugh, of Wokyngham, Berks, dyer 1
5409549 2477821 2477821 defendant Mychell John   585881 585881 Mychell, John, of Wokyngham, Berks, bell maker 0
5412707 2478750 2478750 defendant Bullok Richard gent 585881 585881 Bullok, Richard, of Wokyngham, Berks, gent 0
5418806 2480549 2480549 defendant Lane Robert clothier 585881 585881 Lane, Robert, of Wokyngham, Berks, clothier 1
5418812 2480550 2480550 defendant Lane Robert clothier 585881 585881 Lane, Robert, of Wokyngham, Berks, clothier 1
5422945 2481818 2481818 defendant Horwode Hugh beer brewer 585881 585881 Horwode, Hugh, of Wokyngham, Berks, beer brewer 1
5422951 2481819 2481819 defendant Horwode Hugh dyer 585881 585881 Horwode, Hugh, of Wokyngham, Berks, dyer 1
5423086 2481862 2481862 defendant Michell John   585881 585881 Michell, John, of Wokyngham, Berks, bell maker 0
5427582 2483203 2483203 defendant Bullok Richard gent 585881 585881 Bullok, Richard, of Wokyngham, Berks, gent 0
5442418 2487651 2487651 defendant Horwode Hugh dyer 585881 585881 Horwode, Hugh, of Wokyngham, Berks, dyer 1
5445312 2488494 2488494 defendant Bullok Richard gent 585881 585881 Bullok, Richard, of Wokyngham, Berks, gent 0
5474080 2497225 2497225 defendant Byrde Christopher tanner 585881 585881 Byrde, Christopher, of Wokyngham, Berks, tanner 1
5478952 2498723 2498723 defendant Michell John bellmaker 585881 585881 Michell, John, of Wokyngham, Berks, bellmaker 1
5478956 2498724 2498724 defendant Michell John bellmaker 585881 585881 Michell, John, of Wokyngham, Berks, bellmaker 1
5511234 2508357 2508357 defendant Dene Thomas husbandman 585881 585881 Dene, Thomas, of Wokyngham, Berks, husbandman 2
5514656 2509433 2509433 defendant Michell John   585881 585881 Michell, John, of Wokyngham, Berks, bell maker 0
5514661 2509434 2509434 defendant Michell John   585881 585881 Michell, John, of Wokyngham, Berks, bell maker 0
5514732 2509448 2509448 defendant Mylys John chapman 585881 585881 Mylys, John, of Wokyngham, Berks, chapman 1
5518100 2510495 2510495 defendant Michell John   585881 585881 Michell, John, of Wokyngham, Berks, bell founder 0
5536429 2515883 2515883 defendant Wattys Richard yeoman 585881 585881 Wattys, Richard, of Wokyngham, Berks, yeoman 3
5562040 2523497 2523497 defendant Wattys Richard innholder 585881 585881 Wattys, Richard, of Wokyngham, Berks, innholder 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);