names

109 rows where place_id = 589674

✎ 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
3598382 1867124 1867124 defendant Purry John husbandman or mercer 589674 589674 Purry, John, of Aylesham, Norf, husbandman or mercer 0
3656083 1912155 1912155 defendant Boleyn William clerk 589674 589674 Boleyn, William, of Aylesham, Norf, clerk 2
3659571 1913254 1913254 defendant Cropps Richard yeoman 589674 589674 Cropps, Richard, of Aylesham, Norf, yeoman 0
3662190 1914090 1914090 defendant Corpe Richard   589674 589674 Corpe, Richard, of Aylesham, Norf, tallow chandler 2
3663100 1914370 1914370 defendant Bone Henry   589674 589674 Bone, Henry, of Aylesham, Norf, worsted weaver 0
3664109 1914726 1914726 defendant Prent Nicholas chapman 589674 589674 Prent, Nicholas, of Aylesham, Norf, chapman 1
3664123 1914730 1914730 defendant Orwell Thomas (legal representative) 589674 589674 Orwell, Thomas, of Aylesham, Norf, tallow chandler, executrix of 2
3702329 1926986 1926986 defendant Jamys John yeoman 589674 589674 Jamys, John, of Aylesham, Norf, yeoman 0
3895018 1988542 1988542 defendant Bullyn William   589674 589674 Bullyn, William, of Aylesham, Norf, archdeacon of Winchester 0
3945285 2005435 2005435 defendant Rake Robert husbandman 589674 589674 Rake, Robert, of Aylesham, Norf, husbandman 1
3946304 2005782 2005782 defendant Aleyn John yeoman 589674 589674 Aleyn, John, of Aylesham, Norf, yeoman 0
3970541 2014297 2014297 defendant Callys Edmund yeoman 589674 589674 Callys, Edmund, of Aylesham, Norf, yeoman 3
3970583 2014303 2014303 defendant Ebott Henry yeoman 589674 589674 Ebott, Henry, of Aylesham, Norf, yeoman 1
3987916 2020424 2020424 defendant Woodwarde John yeoman 589674 589674 Woodwarde, John, of Aylesham, Norf, yeoman 2
3998685 2024268 2024268 defendant Medowe Thomas chapman 589674 589674 Medowe, Thomas, of Aylesham, Norf, chapman 0
3998687 2024269 2024269 defendant Norgate Anthony chapman 589674 589674 Norgate, Anthony, of Aylesham, Norf, chapman 0
4016434 2030581 2030581 defendant Norgate Anthony mercer 589674 589674 Norgate, Anthony, of Aylesham, Norf, mercer 0
4041093 2039306 2039306 defendant Johnson Henry yeoman 589674 589674 Johnson, Henry, of Aylesham, Norf, yeoman 2
4041098 2039307 2039307 defendant Johnson Henry yeoman 589674 589674 Johnson, Henry, of Aylesham, Norf, yeoman 2
4094658 2058428 2058428 defendant Bulward Richard tailor 589674 589674 Bulward, Richard, of Aylesham, Norf, tailor 0
4280631 2123132 2123132 defendant Burrawaye Clement husbandman 589674 589674 Burrawaye, Clement, of Aylesham, Norf, husbandman 0
4301875 2130779 2130779 defendant Russell Richard chapman 589674 589674 Russell, Richard, of Aylesham, Norf, chapman 0
4312255 2134422 2134422 defendant Russell Richard chapman 589674 589674 Russell, Richard, of Aylesham, Norf, chapman 0
4401397 2165063 2165063 defendant Browne John gent 589674 589674 Browne, John, of Aylesham, Norf, gent 1
4687028 2261549 2261549 defendant Hardy William yeoman 589674 589674 Hardy, William, of Aylesham, Norf, yeoman 2
4743700 2278687 2278687 defendant Spynk William dyer 589674 589674 Spynk, William, of Aylesham, Norf, dyer 1
4769257 2286363 2286363 defendant Hempnale Robert   589674 589674 Hempnale, Robert, of Aylesham, Norf, gent, son of David 1
4829661 2305322 2305322 defendant Tegge William yeoman 589674 589674 Tegge, William, of Aylesham, Norf, yeoman 0
4917094 2331853 2331853 defendant Poynaunt William husbandman 589674 589674 Poynaunt, William, of Aylesham, Norf, husbandman 2
4994876 2355320 2355320 defendant Hempnale Robert gent 589674 589674 Hempnale, Robert, of Aylesham, Norf, gent 1
5041710 2369122 2369122 defendant Harower Robert   589674 589674 Harower, Robert, of Aylesham, Norf, servant 1
5041712 2369123 2369123 defendant Shelton Thomas esq 589674 589674 Shelton, Thomas, of Aylesham, Norf, esq 0
5041714 2369123 2369123 defendant Harower Robert   589674 589674 Harower, Robert, of Aylesham, Norf, servant 2
5042526 2369369 2369369 defendant Colet Nicholas husbandman 589674 589674 Colet, Nicholas, of Aylesham, Norf, husbandman 0
5042527 2369369 2369369 defendant Gamond John husbandman 589674 589674 Gamond, John, of Aylesham, Norf, husbandman 1
5093474 2384491 2384491 defendant Vergeous William gent 589674 589674 Vergeous, William, of Aylesham, Norf, gent 0
5111191 2389662 2389662 defendant Skyppyng Thomas yeoman 589674 589674 Skyppyng, Thomas, of Aylesham, Norf, yeoman 0
5126095 2394114 2394114 defendant Vergeons William gent 589674 589674 Vergeons, William, of Aylesham, Norf, gent 0
5126097 2394115 2394115 defendant Wylde Thomas yeoman 589674 589674 Wylde, Thomas, of Aylesham, Norf, yeoman 0
5126099 2394116 2394116 defendant Wylde Thomas yeoman 589674 589674 Wylde, Thomas, of Aylesham, Norf, yeoman 0
5126951 2394362 2394362 defendant Goodreed John smith 589674 589674 Goodreed, John, of Aylesham, Norf, smith 0
5128840 2394920 2394920 defendant Shelton Thomas   589674 589674 Shelton, Thomas, of Aylesham, Norf 1
5130634 2395449 2395449 defendant Vergeons William gent 589674 589674 Vergeons, William, of Aylesham, Norf, gent 0
5131381 2395668 2395668 defendant Skyppyng Thomas yeoman 589674 589674 Skyppyng, Thomas, of Aylesham, Norf, yeoman 0
5133672 2396342 2396342 defendant Shelton Thoma gent 589674 589674 Shelton, Thoma, of Aylesham, Norf, gent 0
5136857 2397302 2397302 defendant Abbes Thomas carpenter 589674 589674 Abbes, Thomas, of Aylesham, Norf, carpenter 0
5144716 2399609 2399609 defendant Vergeous William gent 589674 589674 Vergeous, William, of Aylesham, Norf, gent 0
5144719 2399610 2399610 defendant Vergeous William gent 589674 589674 Vergeous, William, of Aylesham, Norf, gent 0
5144721 2399611 2399611 defendant Wylde Thomas yeoman 589674 589674 Wylde, Thomas, of Aylesham, Norf, yeoman 0
5147097 2400289 2400289 defendant Skyppyng Thomas yeoman 589674 589674 Skyppyng, Thomas, of Aylesham, Norf, yeoman 0
5148043 2400574 2400574 defendant Shelton Thomas esq 589674 589674 Shelton, Thomas, of Aylesham, Norf, esq 1
5153477 2402171 2402171 defendant Shelton Thomas gent 589674 589674 Shelton, Thomas, of Aylesham, Norf, gent 0
5165445 2405638 2405638 defendant Vergeous William gent 589674 589674 Vergeous, William, of Aylesham, Norf, gent 0
5166942 2406060 2406060 defendant Skyppyng Thomas yeoman 589674 589674 Skyppyng, Thomas, of Aylesham, Norf, yeoman 0
5170876 2407206 2407206 defendant Shelton Thomas gent 589674 589674 Shelton, Thomas, of Aylesham, Norf, gent 0
5183009 2410776 2410776 defendant Shelton Thomas esq 589674 589674 Shelton, Thomas, of Aylesham, Norf, esq 1
5188937 2412500 2412500 defendant Shelton Thomas gent 589674 589674 Shelton, Thomas, of Aylesham, Norf, gent 0
5212877 2419511 2419511 defendant Vergeous William gent 589674 589674 Vergeous, William, of Aylesham, Norf, gent 2
5214644 2420013 2420013 defendant Vergeous William gent 589674 589674 Vergeous, William, of Aylesham, Norf, gent 0
5214664 2420017 2420017 defendant Vergeous William gent 589674 589674 Vergeous, William, of Aylesham, Norf, gent 0
5215103 2420142 2420142 defendant Skippyng Thomas yeoman 589674 589674 Skippyng, Thomas, of Aylesham, Norf, yeoman 1
5215797 2420346 2420346 defendant Shelton Thomas gent 589674 589674 Shelton, Thomas, of Aylesham, Norf, gent 2
5226259 2423344 2423344 defendant Launde George sherman 589674 589674 Launde, George, of Aylesham, Norf, sherman 0
5272215 2436950 2436950 defendant Godewyn Roger chapman 589674 589674 Godewyn, Roger, of Aylesham, Norf, chapman 1
5297474 2444264 2444264 defendant Wattys Robert   589674 589674 Wattys, Robert, of Aylesham, Norf 0
5304090 2446230 2446230 defendant Vergeous William gent 589674 589674 Vergeous, William, of Aylesham, Norf, gent 0
5307635 2447298 2447298 defendant Boon John yeoman 589674 589674 Boon, John, of Aylesham, Norf, yeoman 2
5312226 2448691 2448691 defendant Cade John yeoman 589674 589674 Cade, John, of Aylesham, Norf, yeoman 0
5312229 2448692 2448692 defendant Cade John yeoman 589674 589674 Cade, John, of Aylesham, Norf, yeoman 0
5326316 2452957 2452957 defendant Egremond John yeoman 589674 589674 Egremond, John, of Aylesham, Norf, yeoman 0
5326318 2452958 2452958 defendant Egremond John yeoman 589674 589674 Egremond, John, of Aylesham, Norf, yeoman 0
5329375 2453870 2453870 defendant Wylde William yeoman 589674 589674 Wylde, William, of Aylesham, Norf, yeoman 0
5329378 2453871 2453871 defendant Wylde William yeoman 589674 589674 Wylde, William, of Aylesham, Norf, yeoman 0
5329379 2453871 2453871 defendant Rocook John, senior husbandman 589674 589674 Rocook, John, senior, of Aylesham, Norf, husbandman 1
5330703 2454260 2454260 defendant Elyot William   589674 589674 Elyot, William, of Aylesham, Norf, worsted weaver 0
5330705 2454261 2454261 defendant Elyot William   589674 589674 Elyot, William, of Aylesham, Norf, worsted weaver 0
5343249 2458081 2458081 defendant Purry John chapman 589674 589674 Purry, John, of Aylesham, Norf, chapman 0
5366885 2465297 2465297 defendant Elvered John yeoman 589674 589674 Elvered, John, of Aylesham, Norf, yeoman 1
5372246 2466914 2466914 defendant (illegible) Robert husbandman 589674 589674 ----, Robert, of Aylesham, Norf, husbandman 3
5372252 2466915 2466915 defendant Wattys Robert husbandman 589674 589674 Wattys, Robert, of Aylesham, Norf, husbandman 3
5377054 2468414 2468414 defendant Dory William chaplain 589674 589674 Dory, William, of Aylesham, Norf, chaplain 4
5377060 2468415 2468415 defendant Dory William chaplain 589674 589674 Dory, William, of Aylesham, Norf, chaplain 4
5383744 2470433 2470433 defendant Base John yeoman 589674 589674 Base, John, of Aylesham, Norf, yeoman 4
5395559 2473809 2473809 defendant Base John yeoman 589674 589674 Base, John, of Aylesham, Norf, yeoman 4
5404651 2476405 2476405 defendant Bettes Robert butcher 589674 589674 Bettes, Robert, of Aylesham, Norf, butcher 1
5419352 2480706 2480706 defendant Benet William smith 589674 589674 Benet, William, of Aylesham, Norf, smith 4
5426660 2482920 2482920 defendant Kelle William   589674 589674 Kelle, William, of Aylesham, Norf, mason 1
5435278 2485484 2485484 defendant Bettes Robert butcher 589674 589674 Bettes, Robert, of Aylesham, Norf, butcher 0
5435293 2485490 2485490 defendant Bettes Robert butcher 589674 589674 Bettes, Robert, of Aylesham, Norf, butcher 1
5437598 2486180 2486180 defendant Benet William smith 589674 589674 Benet, William, of Aylesham, Norf, smith 4
5437603 2486181 2486181 defendant Benet William smith 589674 589674 Benet, William, of Aylesham, Norf, smith 3
5443460 2487955 2487955 defendant Galt John husbandman 589674 589674 Galt, John, of Aylesham, Norf, husbandman 10
5457419 2492120 2492120 defendant Kelle William   589674 589674 Kelle, William, of Aylesham, Norf, mason 1
5469236 2495728 2495728 defendant Kelle William   589674 589674 Kelle, William, of Aylesham, Norf, mason 1
5472010 2496588 2496588 defendant Kyd Thomas butcher 589674 589674 Kyd, Thomas, of Aylesham, Norf, butcher 3
5483425 2499991 2499991 defendant Cokkes John husbandman 589674 589674 Cokkes, John, of Aylesham, Norf, husbandman 0
5483427 2499992 2499992 defendant Cokkes John husbandman 589674 589674 Cokkes, John, of Aylesham, Norf, husbandman 0
5483952 2500137 2500137 defendant Pescod Thomas husbandman 589674 589674 Pescod, Thomas, of Aylesham, Norf, husbandman 0
5489477 2501737 2501737 defendant Warner Thomas miller 589674 589674 Warner, Thomas, of Aylesham, Norf, miller 0
5493264 2502894 2502894 defendant Potter William husbandman 589674 589674 Potter, William, of Aylesham, Norf, 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);