names

107 rows where place_id = 607716

✎ 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
3627832 1903563 1903563 defendant Yetson or Zetson Robert quarrier 607716 607716 Yetson or Zetson, Robert , of Corby, laborer, quarrier 4
3670554 1916754 1916754 defendant Archer William cordwainer 607716 607716 Archer, William, of Corby, cordwainer 0
3682737 1920701 1920701 defendant Archer William yeoman 607716 607716 Archer, William, of Corby, yeoman 0
3701087 1926586 1926586 defendant Alford William laborer 607716 607716 Alford, William, of Corby, laborer 0
3714666 1930884 1930884 defendant Alford William laborer 607716 607716 Alford, William, of Corby, laborer 0
3739032 1938414 1938414 defendant Shershawe Richard yeoman 607716 607716 Shershawe Richard, of Corby, yeoman 0
3785322 1953197 1953197 defendant Inshelard Christopher yeoman 607716 607716 Inshelard, Christopher, of Corby, yeoman 0
3832143 1967963 1967963 defendant Dryver Lawrence baker 607716 607716 Dryver, Lawrence, of Corby, baker 0
3850869 1973865 1973865 defendant Inglelard Thomas yeoman 607716 607716 Inglelard, Thomas, of Corby, yeoman 2
3858880 1976457 1976457 defendant Archer William   607716 607716 Archer, William, of Corby, "sowter" 1
3865582 1978707 1978707 defendant Ingelard Thomas yeoman 607716 607716 Ingelard, Thomas, of Corby, yeoman 2
3865588 1978708 1978708 defendant Ingelard Thomas yeoman 607716 607716 Ingelard, Thomas, of Corby, yeoman 2
3886029 1985578 1985578 defendant Johnson William butcher 607716 607716 Johnson, William, of Corby, butcher 0
3917333 1996156 1996156 defendant Johnson William butcher 607716 607716 Johnson, William, of Corby, butcher 0
4080533 2053351 2053351 defendant Vaykye Thomas yeoman 607716 607716 Vaykye, Thomas, of Corby, yeoman 2
4080534 2053351 2053351 defendant Watson William yeoman 607716 607716 Watson, William, of Corby, yeoman 3
4111092 2064220 2064220 defendant Merydale John gent 607716 607716 Merydale, John, of Corby, gent 0
4160343 2081692 2081692 defendant Barnerd Richard gent 607716 607716 Barnerd, Richard, of Corby, gent 0
4421440 2171610 2171610 defendant Tayllour William   607716 607716 Tayllour, William, of Corby 0
4472254 2191992 2191992 defendant Baxter David   607716 607716 Baxter, David, of Corby 0
4483304 2195478 2195478 defendant Wilteshire Ralph   607716 607716 Wilteshire, Ralph, of Corby 0
4486613 2196526 2196526 plaintiff Saundres John   607716 607716 Saundres, John, of Corby 0
4503350 2201620 2201620 plaintiff Ingham Thomas   607716 607716 Ingham, Thomas, of Corby 1
4516679 2205630 2205630 plaintiff Cook William   607716 607716 Cook, William, of Corby 0
4531878 2210234 2210234 plaintiff Picard William   607716 607716 Picard, William, of Corby 0
4533372 2210703 2210703 plaintiff Ricard William   607716 607716 Ricard, William, of Corby 0
4544793 2214289 2214289 defendant Hengham Thomas   607716 607716 Hengham, Thomas, of Corby, son of John Hengham 0
4549207 2215691 2215691 defendant Smyth Thomas   607716 607716 Smyth, Thomas, of Corby 0
4549209 2215692 2215692 defendant Smyth Thomas   607716 607716 Smyth, Thomas, of Corby 0
4601796 2231782 2231782 defendant Wylkes John   607716 607716 Wylkes, John, of Corby 0
4644191 2244395 2244395 defendant Aleyn Henry   607716 607716 Aleyn, Henry, of Corby 0
4644972 2244601 2244601 defendant Pulham John   607716 607716 Pulham, John, of Corby 0
4665907 2250813 2250813 defendant Bek William husbandman 607716 607716 Bek, William, of Corby, husbandman 1
4666660 2255292 2255292 defendant D--gy Roger husbandman 607716 607716 D--gy, Roger, of Corby, husbandman 0
4682559 2260164 2260164 defendant Dyxy Roger husbandman 607716 607716 Dyxy, Roger, of Corby, husbandman 3
4698548 2265018 2265018 defendant Hardy Robert husbandman 607716 607716 Hardy, Robert, of Corby, husbandman 3
4700392 2265536 2265536 defendant Godsaulle John husbandman 607716 607716 Godsaulle, John, of Corby, husbandman 1
4700393 2265536 2265536 defendant Beverley Richard yeoman 607716 607716 Beverley, Richard, of Corby, yeoman 2
4708404 2267993 2267993 defendant Harpam William chaplain 607716 607716 Harpam, William, of Corby, chaplain 1
4714321 2269810 2269810 defendant Jonson Thomas husbandman 607716 607716 Jonson, Thomas, of Corby, husbandman 0
4739506 2277440 2277440 defendant Ingham Edmund husbandman 607716 607716 Ingham, Edmund, of Corby, husbandman 2
4745812 2279281 2279281 defendant (not given) Nicholas vicar of Harpham 607716 607716 Harpham, Nicholas, of Corby, vicar & formerly vicar of Elsham 0
4750797 2280715 2280715 defendant Bate Robert yeoman 607716 607716 Bate, Robert, of Corby, yeoman 1
4750798 2280715 2280715 defendant Spencer John yeoman 607716 607716 Spencer, John, of Corby, yeoman 2
4784633 2291200 2291200 defendant Cost Robert husbandman 607716 607716 Cost, Robert, of Corby, husbandman 1
4834323 2306745 2306745 defendant Margretson John husbandman 607716 607716 Margretson, John, of Corby, husbandman 1
4834703 2306857 2306857 defendant Crosse Thomas   607716 607716 Crosse, Thomas, of Corby, flax chapman 4
4846473 2310404 2310404 defendant Cost Robert   607716 607716 Cost, Robert, of Corby, bailiff 2
4863444 2315536 2315536 defendant Cost Robert husbandman 607716 607716 Cost, Robert, of Corby, husbandman 2
4882129 2321312 2321312 defendant Bate John yeoman 607716 607716 Bate, John, of Corby, yeoman 0
4897482 2325873 2325873 defendant Hardy Robert husbandman 607716 607716 Hardy, Robert, of Corby, husbandman 2
4944358 2340210 2340210 plaintiff Hardy Robert   607716 607716 Hardy, Robert, of Corby 0
4945326 2340515 2340515 defendant Dancastre William yeoman 607716 607716 Dancastre, William, of Corby, yeoman 0
4970105 2348010 2348010 plaintiff Hardy Robert   607716 607716 Hardy, Robert, of Corby 0
4985398 2352553 2352553 defendant Dancastre William yeoman 607716 607716 Dancastre, William, of Corby, yeoman 4
4990248 2353992 2353992 defendant Danastre William yeoman 607716 607716 Danastre, William, of Corby, yeoman 1
5013274 2360716 2360716 defendant Alyn John husbandman 607716 607716 Alyn, John, of Corby, husbandman 4
5024488 2364074 2364074 defendant Hardy Robert yeoman 607716 607716 Hardy, Robert, of Corby, yeoman 0
5029703 2365557 2365557 defendant Armstrong William husbandman 607716 607716 Armstrong, William, of Corby, husbandman 3
5031500 2366072 2366072 defendant Glasyer Robert weaver 607716 607716 Glasyer, Robert, of Corby, weaver 0
5094027 2384652 2384652 defendant Toures Thomas smith 607716 607716 Toures, Thomas, of Corby, smith 0
5096332 2385358 2385358 defendant Colston Constance widow 607716 607716 Colston, Constance, of Corby, widow 5
5098508 2385993 2385993 defendant Ingelard John yeoman 607716 607716 Ingelard, John, of Corby, yeoman 1
5099132 2386171 2386171 defendant Eliston John husbandman 607716 607716 Eliston, John, of Corby, husbandman 2
5099133 2386171 2386171 defendant Alayn John husbandman 607716 607716 Alayn, John, of Corby, husbandman 3
5102012 2387012 2387012 defendant Broun William drover 607716 607716 Broun, William, of Corby, drover 0
5116546 2391271 2391271 defendant Ekton William husbandman 607716 607716 Ekton, William, of Corby, husbandman 0
5122845 2393113 2393113 defendant Hardy Robert husbandman 607716 607716 Hardy, Robert, of Corby, husbandman 1
5122850 2393114 2393114 defendant Ricarde Nicholas gent 607716 607716 (Ricarde, Nicholas, of Corby, gent 1
5125309 2393884 2393884 defendant Broun Henry (legal representative) 607716 607716 Broun, Henry, of Corby, clerk, executor of 0
5127768 2394600 2394600 defendant Ingelard John   607716 607716 Ingelard, John, of Corby, bailiff 1
5143906 2399359 2399359 defendant Broun Henry (legal representative) 607716 607716 Broun, Henry, of Corby, clerk & parson, executor of 0
5143909 2399360 2399360 defendant Broun Henry (legal representative) 607716 607716 Broun, Henry, of Corby, clerk & parson, executor of 0
5151434 2401570 2401570 defendant Thorney John yeoman 607716 607716 Thorney, John, of Corby, yeoman 0
5164944 2405483 2405483 defendant Broun Henry (legal representative) 607716 607716 Broun, Henry, of Corby, parson & clerk, executor of 0
5178549 2409440 2409440 defendant Broun Henry   607716 607716 Broun, Henry, of Corby, clerk, administrators of 0
5179837 2409837 2409837 defendant Clyfton John laborer 607716 607716 Clyfton, John, of Corby, laborer 2
5179838 2409837 2409837 defendant Bailly John husbandman 607716 607716 Bailly, John, of Corby, husbandman 3
5179839 2409837 2409837 defendant Forster Walter husbandman 607716 607716 Forster, Walter, of Corby, husbandman 4
5218713 2421201 2421201 defendant of Towres Richard yeoman 607716 607716 of Towres, Richard, of Corby, yeoman 0
5218714 2421201 2421201 defendant of Towres John yeoman 607716 607716 of Towres, John, of Corby, yeoman 1
5218715 2421201 2421201 defendant Spenser Joan widow 607716 607716 Spenser, Joan, of Corby, widow 2
5219831 2421520 2421520 defendant Northfolk Thomas clerk 607716 607716 Northfolk, Thomas, of Corby, clerk 10
5219834 2421520 2421520 defendant Taylour John, junior tailor 607716 607716 Taylour, John, junior, of Corby, tailor 13
5219835 2421520 2421520 defendant Margotson William weaver 607716 607716 Margotson, William, of Corby, weaver 14
5219838 2421520 2421520 defendant Thorp John yeoman 607716 607716 Thorp, John, of Corby, yeoman 17
5219839 2421520 2421520 defendant Holme Bartholomew yeoman 607716 607716 Holme, Bartholomew, of Corby, yeoman 18
5219851 2421521 2421521 defendant Northfolke Thomas clerk 607716 607716 Northfolke, Thomas, of Corby, clerk 10
5219856 2421521 2421521 defendant Thorp John yeoman 607716 607716 Thorp, John, of Corby, yeoman 15
5219857 2421521 2421521 defendant Holme Bartholomew yeoman 607716 607716 Holme, Bartholomew, of Corby, yeoman 16
5219858 2421521 2421521 defendant Taillour John, junior tailor 607716 607716 Taillour, John, junior, of Corby, tailor 17
5219859 2421521 2421521 defendant Margetson William weaver 607716 607716 Margetson,William, of COrby, weaver 18
5243952 2428421 2428421 defendant Aleyn William husbandman 607716 607716 Aleyn, William, of Corby, husbandman 0
5248987 2429827 2429827 defendant Fyssher John butcher 607716 607716 Fyssher, John, of Corby, butcher 2
5264565 2434668 2434668 defendant Smyth Thomas husbandman 607716 607716 Smyth, Thomas, of Corby, husbandman 3
5265044 2434828 2434828 defendant Wright John husbandman 607716 607716 Wright, John, of Corby, husbandman 0
5265045 2434828 2434828 defendant Wright Wymark   607716 607716 Wright, Wymark, of Corby, servant 1
5293624 2443099 2443099 defendant Sherman Thomas laborer 607716 607716 Sherman, Thomas, of Corby, laborer 2
5308790 2447668 2447668 defendant Sherman Thomas husbandman 607716 607716 Sherman, Thomas, of Corby, husbandman 2
5327883 2453410 2453410 defendant Okeley John husbandman 607716 607716 Okeley, John, of Corby, husbandman 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);