names

41 rows where place_id = 616843

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3716448 1931437 1931437 defendant Ireche Robert butcher 616843 616843 Ireche, Robert, of Fordyngbrygge, butcher 0
3776696 1950460 1950460 defendant Iryche Robert husbandman 616843 616843 Iryche, Robert, of Fordyngbrygge, husbandman 0
3827650 1966507 1966507 defendant Wiloughby Walter esq 616843 616843 Wiloughby, Walter, of Fordyngbrygge, esq 0
4468491 2190809 2190809 defendant Gobyon John   616843 616843 Gobyon, John, of Fordyngbrygge 0
4818381 2301829 2301829 defendant Couper Thomas tailor 616843 616843 Couper, Thomas, of Fordyngbrygge, tailor 0
4850112 2311494 2311494 defendant Tollard Mathew   616843 616843 Tollard, Mathew, of Fordyngbrygge 0
4852343 2312154 2312154 defendant Goodbody Thomas   616843 616843 Goodbody, Thomas, of Fordyngbrygge, shoe maker 2
4891381 2324033 2324033 defendant Hoggekyns William butcher 616843 616843 Hoggekyns, William, of Fordyngbrygge, butcher 0
4891382 2324033 2324033 defendant Sparke Walter husbandman 616843 616843 Sparke, Walter, of Fordyngbrygge, husbandman 1
4891386 2324034 2324034 defendant Hoggekyns William butcher 616843 616843 together with Hoggekyns, William, of Fordyngbrygge, butcher 1
4891387 2324034 2324034 defendant Sparke Walter husbandman 616843 616843 Sparke, Walter, of Fordyngbrygge, husbandman 2
4892655 2324432 2324432 defendant White Thomas husbandman 616843 616843 White, Thomas, of Fordyngbrygge, husbandman 0
4900578 2326822 2326822 defendant Hoggekyns William butcher 616843 616843 Hoggekyns, William, of Fordyngbrygge, butcher 0
4914149 2330937 2330937 defendant Hechekyn William butcher 616843 616843 Hechekyn, William, of Fordyngbrygge, butcher 0
5018774 2362380 2362380 defendant Clyfton Thomas   616843 616843 together with Clyfton, Thomas, of Fordyngbrygge 1
5021134 2363077 2363077 defendant Bethefunt Henry smith 616843 616843 Bethefunt, Henry, of Fordyngbrygge, smith 2
5041975 2369201 2369201 defendant Ryngwode Thomas esq 616843 616843 Ryngwode, Thomas, of Fordyngbrygge, esq 0
5088435 2382993 2382993 defendant Baron John carpenter 616843 616843 Baron, John, of Fordyngbrygge, carpenter 0
5092598 2384211 2384211 defendant Ryngwode Thomas esq 616843 616843 Ryngwode, Thomas, of Fordyngbrygge, esq 0
5105770 2388135 2388135 defendant Botreaux Robert yeoman 616843 616843 (Botreaux, Robert, of Fordyngbrygge, yeoman 1
5213353 2419636 2419636 defendant Lythenerd alias Baker Walter butcher or baker 616843 616843 Lythenerd alias Baker, Walter, of Fordyngbrygge, butcher or baker 0
5228793 2424032 2424032 defendant Whynge Richard yeoman 616843 616843 Whynge, Richard, of Fordyngbrygge, yeoman 0
5242620 2428047 2428047 defendant Ballard John husbandman 616843 616843 Ballard, John, of Fordyngbrygge, husbandman 3
5263437 2434314 2434314 defendant Wyllesthorp Richard yeoman 616843 616843 Wyllesthorp, Richard, of Fordyngbrygge, yeoman 0
5289812 2442029 2442029 defendant Wyllethrope Richrd yeoman 616843 616843 Wyllethrope, Richrd, of Fordyngbrygge, yeoman 1
5289813 2442029 2442029 defendant Bryght Ralph yeoman 616843 616843 Bryght, Ralph, of Fordyngbrygge, yeoman 2
5289814 2442029 2442029 defendant Berkeham John miller 616843 616843 Berkeham, John, of Fordyngbrygge, miller 3
5294337 2443317 2443317 defendant Rygwode Thomas esq 616843 616843 Rygwode, Thomas, of Fordyngbrygge, esq 1
5294338 2443317 2443317 defendant Molyns John esq 616843 616843 Molyns, John, of Fordyngbrygge, esq 2
5298641 2444574 2444574 defendant Bewyn John yeoman 616843 616843 Bewyn, John, of Fordyngbrygge, yeoman 4
5300709 2445176 2445176 defendant Bother William butcher 616843 616843 Bother, William, of Fordyngbrygge, butcher 0
5324910 2452528 2452528 defendant Reson John husbandman 616843 616843 Reson, John, of Fordyngbrygge, husbandman 0
5325074 2452581 2452581 defendant Vele John husbandman 616843 616843 Vele, John, of Fordyngbrygge, husbandman 0
5325778 2452790 2452790 defendant Reson John husbandman 616843 616843 Reson, John, of Fordyngbrygge, husbandman 0
5388754 2471841 2471841 defendant Hall John yeoman 616843 616843 Hall, John, of Fordyngbrygge, yeoman 0
5390622 2472381 2472381 defendant Everard Edward dyer 616843 616843 Everard, Edward, of Fordyngbrygge, dyer 0
5400322 2475168 2475168 defendant Notche Thomas yeoman 616843 616843 Notche, Thomas, of Fordyngbrygge, yeoman 1
5403530 2476080 2476080 defendant Everard Edward dyer 616843 616843 Everard, Edward, of Fordyngbrygge, dyer 0
5445515 2488557 2488557 defendant Everard Edward dyer 616843 616843 Everard, Edward, of Fordyngbrygge, dyer 0
5467105 2495108 2495108 defendant Wexham John tanner 616843 616843 Wexham, John, of Fordyngbrygge, tanner 1
5535936 2515742 2515742 defendant Goodebody John baker 616843 616843 Goodebody, John, of Fordyngbrygge, baker 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);