names

93 rows where place_id = 587402

✎ 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
3591305 1864908 1864908 defendant Rous Thomas gent 587402 587402 Rous, Thomas, of Aldham, gent 2
3601317 1868078 1868078 defendant Savage William yeoman 587402 587402 Savage, William, of Aldham, yeoman 0
3625260 1875435 1875435 defendant Savage William husbandman 587402 587402 Savage, William, of Aldham, husbandman 1
3647749 1909687 1909687 defendant Clyfford Robert husbandman 587402 587402 Clyfford, Robert, of Aldham, husbandman 1
3742688 1939585 1939585 defendant Fanne William husbandman 587402 587402 Fanne, William, of Aldham, husbandman 1
3759494 1944963 1944963 plaintiff Clyfford Robert (legal representative) 587402 587402 Clyfford, Robert, of Aldham, executors of 0
3779194 1951214 1951214 defendant Betyll Thomas, junior husbandman 587402 587402 Betyll, Thomas, junior, of Aldham, husbandman 0
3779197 1951214 1951214 defendant Betyll Thomas, senior husbandman 587402 587402 Betyll, Thomas, senior, of Aldham, husbandman 3
3812340 1961750 1961750 defendant Danne William husbandman 587402 587402 Danne, William, of Aldham, husbandman 4
3824182 1965440 1965440 defendant Danne William husbandman 587402 587402 Danne, William, of Aldham, husbandman 3
3825702 1965891 1965891 defendant Martyn Robert yeoman 587402 587402 Martyn, Robert, of Aldham, yeoman 1
3867958 1979517 1979517 defendant Offote William husbandman 587402 587402 Offote, William, of Aldham, husbandman 1
3897511 1989381 1989381 defendant Bull John husbandman 587402 587402 Bull, John, of Aldham, husbandman 1
3965732 2012632 2012632 plaintiff Bennett John husbandman 587402 587402 Bennett, John, of Aldham, husbandman 0
4031588 2035959 2035959 defendant Harland Robert husbandman 587402 587402 Harland, Robert, of Aldham, husbandman 2
4126424 2069736 2069736 defendant Wellam John husbandman 587402 587402 Wellam, John, of Aldham, husbandman 1
4132657 2072001 2072001 defendant Newton Joshua yeoman 587402 587402 Newton, Joshua, of Aldham, yeoman 0
4135274 2072935 2072935 defendant Wade John, senior yeoman 587402 587402 Wade, John, senior, of Aldham, yeoman 0
4145443 2076565 2076565 defendant Wellam John husbandman 587402 587402 Wellam, John, of Aldham, or of Kersey, husbandman 0
4163920 2082908 2082908 defendant Hart Thomas husbandman 587402 587402 Hart, Thomas, of Aldham, husbandman 1
4180426 2088630 2088630 defendant Webbe John husbandman 587402 587402 Webbe, John, of Aldham, husbandman 0
4181614 2089055 2089055 defendant Cook Thomas turner 587402 587402 Cook, Thomas, of Aldham, turner 2
4237705 2108785 2108785 defendant Downynge Robert butcher 587402 587402 Downynge, Robert, of Aldham, butcher 2
4246322 2111747 2111747 defendant Downinge Robert butcher 587402 587402 Downinge, Robert, of Aldham, butcher 2
4246608 2111841 2111841 defendant Wyles Thomas husbandman 587402 587402 Wyles, Thomas, of Aldham, husbandman 0
4279295 2122687 2122687 defendant Beryff William gent 587402 587402 Beryff, William, of Aldham, gent, son or William Beryff, of Awldam, gent 0
4282894 2123916 2123916 defendant Byrd Thomas yeoman 587402 587402 Byrd, Thomas, of Aldham, yeoman 0
4328351 2139799 2139799 defendant Hantemore or Hautemore John yeoman 587402 587402 Hantemore or Hautemore, John, of Aldham, yeoman 0
4328762 2139932 2139932 defendant Haunting John husbandman 587402 587402 Haunting, John, of Aldham, husbandman 1
4332980 2141315 2141315 defendant Backe John yeoman 587402 587402 Backe, John, of Aldham, yeoman 0
4334134 2141696 2141696 defendant Shawe Henry grocer 587402 587402 Shawe, Henry, of Aldham, grocer 0
4335779 2142243 2142243 defendant Neve Thomas shoemaker 587402 587402 Neve, Thomas, of Aldham, shoemaker 2
4379418 2157718 2157718 defendant Newton Joshua yeoman 587402 587402 Newton, Joshua, of Aldham, yeoman 0
4404541 2166086 2166086 defendant Birde John yeoman 587402 587402 Birde, John, of Aldham, yeoman 0
4413794 2169212 2169212 defendant Hildeyard Robert de   587402 587402 Hildeyard, Robert de, of Aldham 0
4431676 2174675 2174675 defendant atte Hoo Henry   587402 587402 atte Hoo, Henry, of Aldham, son of Richard atte Hoo 0
4431700 2174685 2174685 defendant atte Hoo Henry   587402 587402 atte Hoo, Henry, of Aldham, son of Richard 0
4436074 2176024 2176024 plaintiff Reymys Robert (legal representative) 587402 587402 Reymys, Robert, of Aldham, parson, executors of 0
4440466 2181930 2181930 defendant Taillour John   587402 587402 Taillour, John, of Aldham, bailiff 3
4444808 2183348 2183348 defendant Taillour John   587402 587402 Taillour, John, of Aldham 1
4445048 2183425 2183425 defendant Christine formerly the wife of James 587402 587402 Christine, formerly the wife of James, of Aldham 2
4460276 2188268 2188268 defendant Ileer William   587402 587402 Ileer, William, of Aldham 0
4512272 2204279 2204279 defendant Spayne William   587402 587402 Spayne, William, of Aldham 0
4610455 2234343 2234343 defendant Fullere William   587402 587402 Fullere, William, of Aldham 7
4610456 2234343 2234343 defendant Fullere John   587402 587402 Fullere, John, of Aldham 8
4610469 2234346 2234346 defendant Fullere William   587402 587402 Fullere, William, of Aldham 1
4617589 2236509 2236509 defendant London John   587402 587402 London, John, of Aldham 1
4630275 2240378 2240378 defendant Bocher Nicholas   587402 587402 Bocher, Nicholas, of Aldham 3
4631289 2240680 2240680 defendant Holtone Walter butcher 587402 587402 Holtone, Walter, of Aldham, butcher 2
4645897 2244869 2244869 defendant Sagor Geoffrey   587402 587402 Sagor, Geoffrey, of Aldham 2
4648211 2245542 2245542 defendant Swek John   587402 587402 Swek, John, of Aldham 0
4697740 2264787 2264787 defendant Maycons John laborer 587402 587402 Maycons, John, of Aldham, laborer 0
4697827 2264818 2264818 defendant Gravener John yeoman 587402 587402 Gravener, John, of Aldham, yeoman 2
4711801 2269016 2269016 defendant Holton Walter butcher 587402 587402 Holton, Walter, of Aldham, butcher 1
4760984 2283780 2283780 defendant Houden John   587402 587402 Houden, John, of Aldham, parson 0
4762316 2284195 2284195 defendant atte Ree John husbandman 587402 587402 atte Ree, John, of Aldham, husbandman 0
4800653 2296385 2296385 defendant Prat Peter thatcher 587402 587402 Prat, Peter, of Aldham, thatcher 0
4811930 2299844 2299844 defendant Alfrygh Nicholas husbandman 587402 587402 Alfrygh, Nicholas, of Aldham, husbandman 0
4835237 2307021 2307021 defendant Coloppe Nicholas   587402 587402 Coloppe, Nicholas, of Aldham, franklin 0
4838394 2307922 2307922 defendant Stanton John yeoman 587402 587402 Stanton, John, of Aldham, yeoman 2
4839717 2308337 2308337 defendant Alfrith Nicholas husbandman 587402 587402 Alfrith, Nicholas, of Aldham, husbandman 0
4865580 2316199 2316199 defendant Stanton John yeoman 587402 587402 Stanton, John, of Aldham, yeoman 2
4866919 2316616 2316616 defendant Alfryth Nicholas husbandman 587402 587402 Alfryth, Nicholas, of Aldham, husbandman 0
4882730 2321517 2321517 defendant Mynche Thomas yeoman 587402 587402 Mynche, Thomas, of Aldham, yeoman 0
4884069 2321929 2321929 defendant Maycons John husbandman 587402 587402 Maycons, John, of Aldham, husbandman 0
4885641 2322382 2322382 defendant Austyn John husbandman 587402 587402 Austyn, John, of Aldham, husbandman 3
4898450 2326169 2326169 defendant Wynde William yeoman 587402 587402 Wynde, William, of Aldham, yeoman 3
4932100 2336433 2336433 defendant Freman John yeoman 587402 587402 Freman, John, of Aldham, yeoman 1
4944779 2340353 2340353 defendant Batyll Thomas husbandman 587402 587402 Batyll, Thomas, of Aldham, husbandman 2
4944780 2340353 2340353 defendant Andrewe John laborer 587402 587402 Andrewe, John, of Aldham, laborer 3
4975268 2349559 2349559 defendant Cresfeld John husbandman 587402 587402 Cresfeld, John, of Aldham, husbandman 1
4975272 2349560 2349560 defendant Cresfeld John husbandman 587402 587402 Cresfeld, John, of Aldham, husbandman 1
4984125 2352184 2352184 defendant Botell Thomas husbandman 587402 587402 Botell, Thomas, of Aldham, husbandman 1
4984126 2352184 2352184 defendant Mynche Thomas husbandman 587402 587402 Mynche, Thomas, of Aldham, husbandman 2
5020043 2362749 2362749 defendant Maycons John husbandman 587402 587402 Maycons, John, of Aldham, husbandman 0
5035312 2367190 2367190 defendant Mowney Bartholomew husbandman 587402 587402 Mowney, Bartholomew, of Aldham or of Hadley, Suff, husbandman 0
5092075 2384056 2384056 defendant Roche Richard butcher 587402 587402 Roche, Richard, of Aldham, butcher 4
5116275 2391191 2391191 defendant Arnold John butcher 587402 587402 Arnold, John, of Aldham, butcher 0
5213311 2419625 2419625 defendant Havell John yeoman 587402 587402 Havell, John, of Aldham, yeoman 0
5258386 2432736 2432736 defendant Heth William husbandman 587402 587402 Heth, William, of Aldham, husbandman 4
5325797 2452798 2452798 defendant Smyth Thomas clerk 587402 587402 Smyth, Thomas, of Aldham, clerk 2
5379150 2469076 2469076 defendant Bole or Bele John husbandman 587402 587402 Bole or Bele, John, of Aldham, husbandman 0
5379151 2469076 2469076 defendant Colman Thomas yeoman 587402 587402 Colman, Thomas, of Aldham, husbandman. Fraunceys, Nicholas, of Aldham, yeoman 1
5379152 2469076 2469076 defendant Chapman John yeoman 587402 587402 Chapman, John, of Aldham, yeoman 2
5379153 2469076 2469076 defendant Colman Robert yeoman 587402 587402 Colman, Robert, of Aldham, yeoman 3
5387016 2471352 2471352 plaintiff Draper Roger   587402 587402 Draper, Roger, of Aldham, administrators of 0
5399234 2474850 2474850 defendant Colman Thomas husbandman 587402 587402 Colman, Thomas, of Aldham, husbandman 0
5425456 2482587 2482587 defendant Cok William butcher 587402 587402 Cok, William, of Aldham, butcher 2
5503300 2505941 2505941 defendant Chapman John husbandman 587402 587402 Chapman, John, of Aldham, husbandman 1
5503302 2505941 2505941 defendant Parker John husbandman 587402 587402 Parker, John, of Aldham, husbandman 3
5509993 2507964 2507964 defendant Broke Robert   587402 587402 Broke, Robert, of Aldham, tile maker 1
5582423 2529574 2529574 plaintiff Draper Roger gent 587402 587402 Draper, Roger, of Aldham, gent 0
5630648 2553590 2553590 defendant Bocher Walter butcher 587402 587402 Bocher, Walter, of Aldham, butcher 2

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