names

102 rows where place_id = 593818

✎ 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
3609306 1870570 1870570 plaintiff Wryghte Robert (legal representative) 593818 593818 Wryghte, Robert, of Brethenham, baker, executors of 0
3613449 1871852 1871852 defendant Twhyght Thomas husbandman 593818 593818 Twhyght, Thomas, of Brethenham, husbandman 0
3636838 1906315 1906315 defendant Weneve John husbandman 593818 593818 Weneve, John, of Brethenham, husbandman 0
3636847 1906318 1906318 defendant Weneve John husbandman 593818 593818 Weneve, John, of Brethenham, husbandman 0
3645373 1908962 1908962 defendant Hoby Giles laborer 593818 593818 Hoby, Giles, of Brethenham, laborer 1
3832538 1968096 1968096 plaintiff Hudsone John clerk 593818 593818 Hudsone, John, of Brethenham, clerk 0
3877552 1982731 1982731 plaintiff hudson John clerk 593818 593818 hudson, John, of Brethenham, clerk 0
3890587 1987116 1987116 plaintiff Hudson John clerk 593818 593818 Hudson, John, of Brethenham, clerk 0
3909998 1993651 1993651 defendant Wryght Hugh husbandman 593818 593818 Wryght, Hugh, of Brethenham, husbandman 0
3909999 1993651 1993651 defendant Wryght Walter husbandman 593818 593818 Wryght, Walter, of Brethenham, husbandman 1
4021522 2032426 2032426 plaintiff Wynyffe Thomas gent 593818 593818 Wynyffe, Thomas, of Brethenham, gent 0
4428649 2173762 2173762 defendant Rugger Ralph   593818 593818 Rugger, Ralph, of Brethenham 0
4462892 2189087 2189087 defendant Payn Alice   593818 593818 Payn, Alice, of Brethenham 0
4469013 2190982 2190982 defendant Chapman John   593818 593818 Chapman, John, of Brethenham 0
4493555 2198687 2198687 defendant fitz Steven Roger   593818 593818 fitz Steven, Roger, of Brethenham 3
4530634 2209876 2209876 defendant Lellesey Thomas   593818 593818 Lellesey, Thomas, of Brethenham 0
4530635 2209876 2209876 defendant Wode Nicholas   593818 593818 Wode, Nicholas, of Brethenham 1
4533102 2210617 2210617 plaintiff Redenhale Robert   593818 593818 Redenhale, Robert, of Brethenham 0
4533103 2210617 2210617 defendant Belleman John   593818 593818 Belleman, John, of Brethenham 0
4560948 2219378 2219378 defendant Lolleseye Thomas   593818 593818 Lolleseye, Thomas, of Brethenham 0
4560949 2219378 2219378 defendant Wode Nicholas   593818 593818 Wode, Nicholas, of Brethenham 1
4563176 2220051 2220051 defendant Wolleman John   593818 593818 Wolleman, John, of Brethenham 0
4563177 2220052 2220052 plaintiff Redenhale Robert   593818 593818 Redenhale, Robert, of Brethenham 0
4563178 2220052 2220052 defendant Belleman John   593818 593818 Belleman, John, of Brethenham 0
4570839 2222448 2222448 defendant Purre Nicholas   593818 593818 Purre, Nicholas, of Brethenham 0
4575208 2223767 2223767 defendant Symond John   593818 593818 Symond, John, of Brethenham 1
4597227 2230376 2230376 defendant del Wode Nicholas woolman 593818 593818 del Wode, Nicholas, of Brethenham, woolman 2
4597231 2230377 2230377 defendant del Wode Nicholas woolman 593818 593818 del Wode, Nicholas, of Brethenham, woolman 2
4597561 2230483 2230483 defendant Chapman John   593818 593818 Chapman, John, of Brethenham 0
4597934 2230612 2230612 defendant Folk Thomas   593818 593818 Folk, Thomas, of Brethenham 5
4615421 2235831 2235831 defendant Shakerys Nicholas   593818 593818 Shakerys, Nicholas, of Brethenham 0
4627270 2239476 2239476 defendant Parle John   593818 593818 Parle, John, of Brethenham 0
4652903 2246842 2246842 defendant Folke Thomas butcher 593818 593818 Folke, Thomas, of Brethenham, butcher 1
4657528 2248247 2248247 defendant Purne Nicholas gent 593818 593818 Purne, Nicholas, of Brethenham, gent 1
4657533 2248248 2248248 defendant Purre Nicholas gent 593818 593818 Purre, Nicholas, of Brethenham, gent 1
4657539 2248249 2248249 defendant Purre Nicholas gent 593818 593818 Purre, Nicholas, of Brethenham, gent 0
4666384 2250962 2250962 defendant Pyke John weaver 593818 593818 Pyke, John, of Brethenham, weaver 0
4667058 2255428 2255428 defendant Whapsted William fuller 593818 593818 Whapsted, William, of Brethenham, fuller 0
4682187 2260051 2260051 defendant Freman John laborer 593818 593818 Freman, John, of Brethenham, laborer 0
4687776 2261749 2261749 defendant Whepstede William husbandman 593818 593818 Whepstede, William, of Brethenham, husbandman 0
4703551 2266489 2266489 defendant Whepstede John laborer 593818 593818 Whepstede, John, of Brethenham, laborer 3
4709198 2268243 2268243 defendant Purre Nicholas husbandman 593818 593818 Purre, Nicholas, of Brethenham, husbandman 0
4712662 2269276 2269276 defendant Purre Nicholas husbandman 593818 593818 Purre, Nicholas, of Brethenham, husbandman 0
4724775 2273046 2273046 defendant Wode Agnes widow 593818 593818 Wode, Agnes, of Brethenham, widow 3
4733979 2275812 2275812 defendant Brethenham John gent 593818 593818 Brethenham, John, of Brethenham, gent 0
4750238 2280546 2280546 defendant Brethenham John husbandman 593818 593818 Brethenham, John, of Brethenham, husbandman 0
4785320 2291426 2291426 defendant Baylle Richard yeoman 593818 593818 Baylle, Richard, of Brethenham, formerly dwelling in Preston, yeoman 0
4830022 2305436 2305436 defendant Bailly Thomas husbandman 593818 593818 Bailly, Thomas, of Brethenham, husbandman 0
4887229 2322845 2322845 defendant Brethenham John gent 593818 593818 Brethenham, John, of Brethenham, gent 1
4915183 2331255 2331255 defendant Thurmode John husbandman 593818 593818 Thurmode, John, of Brethenham, husbandman 1
4951406 2342401 2342401 defendant Brethenham John gent 593818 593818 Brethenham, John, of Brethenham, gent 0
4965018 2346455 2346455 defendant Purry Richard gent 593818 593818 Purry, Richard, of Brethenham, gent 0
4979782 2350909 2350909 defendant Symond Simon husbandman 593818 593818 Symond, Simon, of Brethenham, husbandman 0
4982061 2351550 2351550 defendant Brethenham John gent 593818 593818 Brethenham, John, of Brethenham, gent 0
4993053 2354807 2354807 defendant Symond Simon husbandman 593818 593818 Symond, Simon, of Brethenham, husbandman 2
4993230 2354855 2354855 defendant Symond Simon husbandman 593818 593818 Symond, Simon, of Brethenham, husbandman 2
5003562 2357936 2357936 defendant Rogeres Thomas   593818 593818 Rogeres, Thomas, of Brethenham, husb 7
5003687 2357971 2357971 defendant Hamond Thomas husbandman 593818 593818 Hamond, Thomas, of Brethenham, husbandman 4
5034203 2366863 2366863 defendant Brethenham John gent 593818 593818 Brethenham, John, of Brethenham, gent 0
5036359 2367486 2367486 defendant Brethenham John gent 593818 593818 Brethenham, John, of Brethenham, gent 0
5074336 2378820 2378820 defendant Brethenham William gent 593818 593818 Brethenham, William, of Brethenham, gent 0
5078462 2380056 2380056 defendant Brethenham John gent 593818 593818 Brethenham, John, of Brethenham, gent 0
5079803 2380438 2380438 defendant Brethenham John gent 593818 593818 Brethenham, John, of Brethenham, gent 0
5105287 2387989 2387989 defendant Brethenham John gent 593818 593818 Brethenham, John, of Brethenham, gent 0
5114257 2390562 2390562 defendant Smyth Nicholas husbandman 593818 593818 Smyth, Nicholas, of Brethenham, husbandman 1
5115757 2391038 2391038 defendant Brethenham Reginald yeoman 593818 593818 Brethenham, Reginald, of Brethenham, yeoman 1
5118324 2391794 2391794 defendant Russhebroke John husbandman 593818 593818 Russhebroke, John, of Brethenham, husbandman 2
5133485 2396286 2396286 defendant Ferthyng Edmund yeoman 593818 593818 Ferthyng, Edmund, of Brethenham, yeoman 1
5134959 2396725 2396725 defendant Walle Richard clerk 593818 593818 Walle, Richard, of Brethenham, clerk 3
5135187 2396790 2396790 defendant Homond Thomas yeoman 593818 593818 Homond, Thomas, of Brethenham, yeoman 0
5137727 2397548 2397548 defendant Hamond Thomas husbandman 593818 593818 Hamond, Thomas, of Brethenham, husbandman 0
5152621 2401907 2401907 defendant Ferthyng Edmund yeoman 593818 593818 Ferthyng, Edmund, of Brethenham, yeoman 1
5155090 2402638 2402638 defendant Walle Richard clerk 593818 593818 Walle, Richard, of Brethenham, clerk 3
5170311 2407048 2407048 defendant Ferthyng Edmund yeoman 593818 593818 Ferthyng, Edmund, of Brethenham, yeoman 1
5171842 2407481 2407481 defendant Walle Richard clerk & parson 593818 593818 Walle, Richard, of Brethenham, clerk & parson 3
5182615 2410672 2410672 defendant Smyth Nicholas husbandman 593818 593818 Smyth, Nicholas, of Brethenham, husbandman 0
5182942 2410758 2410758 defendant Kyng Thomas husbandman 593818 593818 Kyng, Thomas, of Brethenham, husbandman 0
5187971 2412190 2412190 defendant Ferthyng Edmund yeoman 593818 593818 Ferthyng, Edmund, of Brethenham, yeoman 1
5197565 2415025 2415025 defendant Kyng Thomas husbandman 593818 593818 Kyng, Thomas, of Brethenham, husbandman 1
5197576 2415028 2415028 defendant Kyng Thomas husbandman 593818 593818 Kyng, Thomas, of Brethenham, husbandman 1
5197581 2415029 2415029 defendant Kyng Thomas husbandman 593818 593818 Kyng, Thomas, of Brethenham, husbandman 1
5202527 2416500 2416500 defendant Kynge Thomas husbandman 593818 593818 Kynge, Thomas, of Brethenham, husbandman 6
5203499 2416777 2416777 defendant Smyth Nicholas husbandman 593818 593818 Smyth, Nicholas, of Brethenham, husbandman 0
5210204 2418710 2418710 defendant Kyng Thomas husbandman 593818 593818 Kyng, Thomas, of Brethenham, husbandman 1
5214065 2419843 2419843 defendant Kynge Thomas husbandman 593818 593818 Kynge, Thomas, of Brethenham, husbandman 1
5220412 2421666 2421666 defendant Ferthyng Edmund yeoman 593818 593818 Ferthyng, Edmund, of Brethenham, yeoman 1
5240667 2427482 2427482 defendant Folk John husbandman 593818 593818 Folk, John, of Brethenham, husbandman 4
5258383 2432736 2432736 defendant Resshebrooke John, senior weaver 593818 593818 Resshebrooke, John, senior, of Brethenham, weaver 1
5281474 2439650 2439650 defendant Kyng Thomas husbandman 593818 593818 Kyng, Thomas, of Brethenham, husbandman 0
5284052 2440357 2440357 defendant Kyng Thomas husbandman 593818 593818 Kyng, Thomas, of Brethenham, husbandman 0
5294427 2443349 2443349 defendant Kyng Thomas yeoman 593818 593818 Kyng, Thomas, of Brethenham, yeoman 0
5303951 2446186 2446186 defendant Folk Thomas husbandman 593818 593818 Folk, Thomas, of Brethenham, husbandman 0
5343745 2458228 2458228 defendant Smyth Nicholas husbandman 593818 593818 Smyth, Nicholas, of Brethenham, husbandman 2
5352661 2460923 2460923 defendant Cokyn Richard husbandman 593818 593818 Cokyn, Richard, of Brethenham, husbandman 0
5490204 2501954 2501954 defendant Payn John husbandman 593818 593818 Payn, John, of Brethenham, husbandman 0
5533846 2515130 2515130 defendant Whepsted John laborer 593818 593818 Whepsted, John, of Brethenham, laborer 1
5596692 2533887 2533887 defendant Bowle Henry laborer 593818 593818 Bowle, Henry, of Brethenham, laborer 0
5605557 2536617 2536617 defendant Bowle Henry husbandman 593818 593818 Bowle, Henry, of Brethenham, husbandman 0
5613357 2547963 2547963 defendant Aylyfes John   593818 593818 Aylyfes, John, of Brethenham 0
5626783 2552348 2552348 defendant Purre Nicholas husbandman 593818 593818 Purre, Nicholas, of Brethenham, 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);